Knowledge Base

  • Aircraft Base Location

    Based on requests from customers, we are pleased to announce we have released individual aircraft base locations for our business aviation and helicopter data sets.

    This new data point is based upon the airport or helipad where the individual aircraft is most frequently known to be operating. We have built and researched this data by speaking to operators and OEMs, using flight tracking software, and monitoring enthusiast sources.Continue reading

  • Subscribe to Knowledge Base articles

    If you’d like to be informed of new Knowledge Base articles (without having to visit the Knowledge Base) then we recommend you subscribe using the RSS URL provided below which will result in all future articles appearing in a folder in MS outlook (or your chosen RSS aggregator.)Continue reading

  • How we have improved the Export capability in Fleets Analyzer

    Exporting data is a key feature of any data tool, and this is true of Fleets Analyzer. When we designed the export feature we increased (compared to previous products) the limit on the number of exportable rows to 100,000 and placed no limit on the number of columns. We also made sure that the exported Excel file is an exact copy of the results grid, including the column order.

    What we didn’t have access to when designing the export solution for Fleets Analyser was data on the export habits of users of our previous products (ACAS and ASO Fleets). It’s clear now that we underestimated the frequency with which Fleets Analyzer users export data, and also the size of those exports.Continue reading

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

Welcome to the knowledge base

What you can expect to find here: tips for users to get the most out of Fleets Analyzer, tricks for power users who are already in the know, product updates including sneak peeks and new features, and news about new data sets and taxonomy changes.

Latest Articles