Search Example: Analysing deals in the year to date

In this example, we are going to review which deals have happened in the year to date to see what deal type is the most popular. Is the most popular type of deal overall the same as the most popular type of deals for the a/c type we are specifically looking at? For this, we shall look at the completed deals from the start of the year until today, and then apply filtering.

  1. Start in the Deals section, Detail tab.
  2. In the Deal Dates & Identification filter, adjust the deal start dates to  1 January and the deal status to Completed.
  3. Run the search and see how many deals have been done.
  4. Go to Summary view, select the grouping by Deal Structure – view the resulting screen in Figure 1.
Figure 1. Completed deals in the year to date by deal structure (click image to view full size).

Continue reading “”

Search Example: Future aircraft delivery schedule split by order type

To see the expected number of aircraft deliveries, but split by the order type (order, LOI etc.), we will have to use the Trend Tab, and then select the new “scheduled delivery of …” metrics introduced in release 7.11 (28 March 2016).

  1. On the Aircraft section, filter until you have the list of aircraft you are interested in.
  2. Move to the Trend Tab and then select the Add/Remove Metric button.
  3. In the Add/Remove Metric dialogue, under the Event heading, select the “Total Scheduled Delivery of….” metrics you wish to see.
  4. Use the date picker in the top left of the page to select a date range in the future.
Figure 1. A320neo future deliveries split by order type (click image to view full size).

Search Example: Viewing individual aircraft total hours and period hours for Delta Air Lines’ A320s

In this example, we’re going to show the trend in total hours and period hours for Delta Air Lines’ A320s.

  1. Go to the Aircraft section, Detail tab.
  2. In the Quick Filter Search (QFS) type “A320” and select A320 under the Aircraft Type category.
  3. In the QFS type “Delta Air” and select Delta Air Lines under the Operators category.
  4. In the QFS type “in service” and select In Service under the Status category. You should see around 69 aircraft in the grid.
  5. Now click on the Trend tab, and when presented with Add/Remove grouping dialogue, remove the defaults groups and add the following from under the Age and identification heading: Flightglobal ID and Registration. Then click Accept.
  6. When presented with the Select metrics dialogue, remove the defaults, and add the following from under the Hours and Cycles heading: Total Cumulative Hours, and Total Period Hours.
  7. Now select the calendar picker in the top left and select 2010 – 2015, Yearly.
  8. You should now see around 138 rows (69 aircraft x 2 metrics) similar to that shown below (Figure 1).

Grouping by FG ID (a unique key for individual aircraft) essentially creates a grouping of individual aircraft, and by also adding registration, we have given ourselves an easy way to identify each aircraft.

Figure 1. Total hours and period hours at individual aircraft level (click image to view full size).

Search Example: Filtering multiple aircraft by serial/registration/line/aircraft ID

In this example, we’re going to use the Aircraft section and populate the results grid with a specific set of aircraft. Rather than using coarse filters such as Aircraft Type etc., we’re going to filter by individual aircraft using multiple registration numbers. After we have the set of aircraft we’re interested in, we’re then going to save the search so we can view the aircraft again at a later date. This is a useful feature if you’re responsible for monitoring a particular group of aircraft that cannot be filtered by other means.

  1. Go to the Aircraft section.
  2. Click the Add Filter Menu.
  3. On the Age & Identification page, in the Registration numbers text box, enter the following registration numbers separated by commas; F-WWBA, JY-JAC, VT-EPB, and VT-EPC. The results grid should be populated with four aircraft (Figure 1).
Figure 1. Four aircraft filtered using multiple registration numbers (click image to view full size).

Continue reading “”

Search Example: Find original usage for 767s and compare with their usage today

In this example, we’re going to look at the fleet of Boeing 767s along with their original primary usage, and compare this with their primary usage at today’s date.

  1. Go to the Aircraft Events section.
  2. In the Quick Filter Search (QFS) type “767” and select 767 under the Aircraft Type category.
  3. In the QFS type “delivered” and select Delivered (Hand over) under the Detail Events Types category. You should see around 1000 767 aircraft delivery events in the grid.
  4. Click the Add/Remove Columns button, remove the default columns and add the following: New Aircraft Sub-Series, New Primary Usage and Current Primary Usage.
  5. Now click the Event Date column header and Sort Ascending. You’ll notice that all the original deliveries (in 1982) were for passenger aircraft, but as you scroll through the grid you’ll notice that many have since been converted to Freight/Cargo (Figure 1).
Figure 1. 767 deliveries with the original and current usage (click image to view full size).

Continue reading “”

Search Example: 777 & 767s in-service fleet over 10 years

In this example, we’re going to look at the 777 and 767 Sub-Series trend over a 10-year period between 2010 and 2020 for passenger aircraft.

  1. On the Aircraft section, select the Trend tab.
  2. Select to group aircraft by Aircraft Type Sub-Series.
  3. Select a Trend Metric of Total In Service.
  4. In the Quick Filter Search (QFS) enter “777”, and select 777 under Aircraft Type.
  5. In the QFS type “767”, and select 767 under Aircraft Type.
  6. In the QFS type “passenger”, and select Passenger under Primary Usages.
  7. In the QFS type “in service”, and select In Service under Status.
  8. The Trend period will default to 2012 – 2016 in annual intervals. Select the Period selector from the top left of the page, and change the period to 2010 – 2020. You should now see around 12 rows in the results grid.
Figure 1. The 10-year trend of 777 & 767 by sub-series (click image to view full size).

Search Example: How is the global fleet of EC135s currently utilised?

In this example, we are going to look at how the in service EC135’s are being utilised.

  1. Start on the Aircraft Section, Detail tab.
  2. In the Quick Filter Search (QFS) type “H135” and then select both H135/EC135 (Airbus Helicopters) and H135/EC135 (RUAG Aerospace Ltd).
  3. In the QFS type “in service” and select in service in the Status category. You should see around 1150 aircraft in the grid.
  4. Now move over to the Summary Tab and group by Primary Usage.
  5. As you’ve filtered by in service aircraft only it’s worth customising the columns on the Summary tab, I’d suggested including Total In Service, Average Age, Age Range, and Total Operators.
  6. Now click the Total In Service column header and select Sort descending.
  7. Now click the Chart Tab which is located just above the Add/Remove Columns button.
Figure 1. How the current fleet of EC135s are utilised (click image to view full size).
Figure 2. The same data as shown in the Chart view (click image to view full size).

 

Search Example: Compare company finance data over time

In this example, we are going to look at the annual revenue for European Mainline Airlines between 2010 and 2015; we are going to limit our results to only those airlines that have exceeded $100m in annual revenue for at least one of the intervals during the 2010 – 2015 range.

  1. Start on the Companies Section, and select the Finance & Traffic tab.
  2. Accept the default column option of Company Type.
  3. Click the Add Filter Menu button, and then select the Company Category option from the menu on the left. In the Company Type list, select Mainline.
  4. Then select the Company Location option from the menu on the left, and select Europe from the Regions list.
  5. Now select the Revenues option from the left menu, this is under the Finance heading. Find the Total Revenue (US$m) range filter, and enter “100” into the From field. In the Date range and interval filter on the same page, make sure the interval is set to Yearly, and enter the date range 2010 to 2015. Now click the Accept button from the top right of the page.
  6. Now use the calendar picker on the search page and set the interval and range to match what you entered into the filter i.e. Yearly, 2010 – 2015. Your results should look like those shown below.
Figure 1. Annual Total Revenue and Total Revenue Change between 2010 and 2015 (click image to view full size).

Continue reading “”

Search Example: Exposure and risk of the helicopter fleet over the last 10-years

In this example, we are going to review the development of helicopter fleet and see if the industry is getting more or less safe in the last 10 years by looking at exposure and risk. For this, we shall review how the number of accidents changed versus changes in active helicopter fleet.

  1. Start in the Aircraft section, Trend tab.
  2. Adjust the dates to show the last 10 years.
  3. In the QFS type in Helicopter, select Helicopter as Aircraft Market Sector filter.
  4. Set grouping as Market Class to get more insight into how the fleet of different classes of helicopters has been developing.
  5. Select metrics ‘Total in Service’, ‘Total On Order’ and ‘Total in Storage’ to focus on the most relevant figures. Your screen would look like the image shown in Figure 1.
Figure 1. In Service and On Order helicopters by Market Class (click image to view full size).

Continue reading “”