“Run search” button – questionnaire results

We recently (March 2017) solicited feedback from users regarding the possibility of including a “Run search” button. At the moment, a search is initiated after each filter has been added via the Quick Filter Select (QFS).

Why did we ask the question?

There are two reasons why we were considering making this change:

  • We had received a request from a user who suggested we do so.
  • It would reduce the number of queries being sent to our servers, and therefore reduce the server load.

The mock-up below shows how this could look if implemented. In the mock-up the selected filters are no longer in sync with the results (as a new filter has been added since the search was last run), so the results are “disabled”, and a “Run search” button has been added.

Figure 1. A mock-up showing the “Run search” button (click image to view full size)

Continue reading “”

Defining the age of an aircraft

Defining age

The age of an aircraft in Fleets Analyzer is defined as follows:

  • If the aircraft at the query date has the status “Retired” or “Written Off”, the aircraft age will be null (shown as “-” on detail grids).
  • In all other cases, the aircraft age will be the number of years between the query date and the Aircraft Start of Life Date.
  • The Aircraft Start of Life Date will be one of the following dates (in order of precedence, i.e. the first in the list that is available will be used), rounded nearest to one decimal place:
    • First Flight Date.
    • The earliest date the aircraft reached either status “In Service” or “Storage”.
  • If the Aircraft Start of Life Date is null, the aircraft age will be null (shown as “-” on detail grids) e.g. for aircraft with a status of “On order”.
  • If the Aircraft Start of Life Date is greater than the query date, the aircraft age will be null (shown as “-” on detail grids)

Continue reading “”

Search Example: Reviewing company activity

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.
Figure 1. Deals with AWAS as participant in any role (click image to view full size).

Continue reading “”

Search Example: Analysing deals in the year to date

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.
Figure 1. Completed deals in the year to date by deal structure (click image to view full size).

Continue reading “”

Search Example: Future aircraft delivery schedule split by order type

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.
Figure 1. A320neo future deliveries split by order type (click image to view full size).

Search Example: Viewing individual aircraft total hours and period hours for Delta Air Lines’ A320s

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.

Figure 1. Total hours and period hours at individual aircraft level (click image to view full size).

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