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.

Continue reading

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.

Continue reading

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.

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.

Continue reading

In order to find a list of operators, managers, owners, etc. who are associated with aircraft, you first have to search for the relevant aircraft. i.e. you have to start on the Aircraft section.

1. On the Aircraft section, filter until you have the list of aircraft you are interested in.
2. Click on the column header of the company role you are interested in e.g. ‘operator’ (if the company role you are interested in is not visible then add it using the Add/Remove columns).
3. From the drop-down list that appears, select ‘Companies in this role’ (see Figure 1).
4. You will then be taken to the Companies section, where your list of companies will be displayed in the results (see Figure 2). You can then add company specific filters or company specific columns.