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.