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 “”

Search Example: British Airways accidents over a 5-year period.

In this example, we are going to review the fleet of British Airways and any accidents related to the operator or the fleet in the past 5 years (01/01/2011 – 31/12/2015).

  1. Start in the Aircraft section, Detail tab.
  2. In the QFS type in British Airways, select British Airways as Operator filter. Similarly, add Status & Usage filters as ‘In Service’ and ‘Storage’, you are now viewing the currently active fleet of British Airways.
  3. Go to the Trend view, select to group by status and adjust the dates to show the last 5 complete years (2011-2015) to see how it has developed in the past 5 years. Select metric ‘Total aircraft’ to focus on the most relevant figures. Your screen would look like the image shown in Figure 1.
Figure 1. British Airways accidents over a 5-year period (click image to view full size).

Continue reading “”

Search Example: All-risk total losses to commercial aircraft over a 10-year period

In this example, we are going to review the number of accidents that are of all-risk (that is, not resulting from acts of war) and were total losses to commercial aircraft, for the ten ear period 01/01/2006 to 30/12/2015.

  1. Start in the Accidents section, Detail tab.
  2. Click on the ‘Add filter menu’ button.
  3. Go to the Date & Identification filter and selecte the date range for 01/01/2006 to 30/12/2015.
  4. Go to the Event Circumstances filter, select Accident Category as ‘All Risk’.
  5. Go to the Loss Type filter, select ‘Total Loss’ filter.
  6. Go to the Market Grouping At Accident filter, select ‘Commercial’ in Market Sector at Accident.
  7. Click Accept to run the search. Your screen will look like the image shown in Figure 1 below.
Figure 1. All-risk total loss results (click image to view full size).

Search Example: Find leased aircraft from a Lessor

In this example, we are going to look for the aircraft currently leased from SMBC Aviation Capital, and then we’re going to see which aircraft types are in service with which operators, along with the contact information for those operators.

  1. Start on the Aircraft Section, Detail tab.
  2. In the Quick Filter Search (QFS) type “SMBC” and select SMBC Aviation Capital from the Manager category.
  3. In the QFS type “in service” and select in service from the Status category. You should see around 380 aircraft in the grid.
  4. Now select the Summary Tab and group by Operator and Aircraft Type. You should see around 140 rows in the grid.
  5. As you have filtered by in service aircraft only, it is worth customising the columns in the grid, I’d suggested including Total In Service, Age Range, and Average Age. Your screen should appear similar to that shown in Figure 1.
Figure 1. SMBC leased aircraft, grouped by Operator and Type (click image to view full size).

Continue reading “”