Defining age

In this example, we are going to review what known deal activity a particular company has been involved in. This workflow would be useful to users who want to monitor competitor activity or find out more about the experience of their potential customers or partners.

1. Start in the Deals section, Detail view.
2. Click add filter, select the Any Participant filter in Deals and select the company or companies you are interested in monitoring, click accept and view the Deals that the company participated in any capacity. Similarly, you can search for a company’s participation in other roles (i.e. Seller, Buyer, Equity Provider, etc.) – see Figure 1.

Continue reading

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.

Continue reading

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.

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.

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).

Continue reading

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).

Continue reading

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.

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.

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.

Continue reading