Category: example searches

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