The following new features have been added in this release:

• Seats and Internal Fit data
• Aircraft values
• Company category, type and status
• Filtering by event-detail type
• Improved formatting of Excel exports
• Print aircraft profiles
• Total APU
• Trend – date-range fix

Seats and Internal Fit data

For each of the seat classes used in Flight Fleets Analyzer (seven in total), the following optional columns have been added to the Detail tab on the Aircraft page:

• Cabin name (this is the name used by the operator for the class)
• Number of seats
• Number of convertible seats
• Number of converted seats
• Seats converted to class
• Seat pitch (in)
• Seat width (in)
• Seat recline (deg)
• Seat recline (in)
• Seat model (by name)
• Seat OEM (by name)
• Seat-support OEM
• Seats abreast
• Primary IFE model (by name)
• Primary IFE OEM (by name)
• Primary IFE screen size (in)
• Power outlet (Yes/No)
• Internet model (by name)
• Internet OEM (by name)
• Phone model (by name)
• Phone OEM (by name)
• Paid connectivity (Yes/No)

On the Summary tab of the Aircraft page, you can now group by any of the following new groups:

• Seat model
• Seat OEM
• Seat-support OEM
• Primary IFE model
• Primary IFE OEM
• Internet model
• Internet OEM
• Phone model
• Phone OEM

On the Summary tab of the Aircraft page, the following new optional columns are now available:

• Total Seats. This is the total number of seats across all classes summed over all aircraft in the group. If any value contributing to this total is estimated, the cell will be styled as estimated.
• Total Convertible Seats. This is the total number of convertible seats across all classes summed over all aircraft in the group.
• Average Seats. This is the number of seats across all classes averaged over all aircraft in the group. If any value contributing to this total is estimated, the cell will be styled as estimated.
• Average Convertible Seats. This is the total number of convertible seats across all classes averaged over all aircraft in the group.
• Total Premium Economy Convertible Seats. This is the total number of convertible seats for the premium economy class summed over all aircraft in the group.
• Total Economy Class Convertible Seats. This is the total number of convertible seats for the economy class summed over all aircraft in the group.
• Average Premium Economy Convertible Seats. This is the number of convertible seats for the premium economy class averaged over all aircraft in the group.
• Average Economy Class Convertible Seats. This is the number of convertible seats for the economy class averaged over all aircraft in the group.

In addition to those listed above, the following new columns will be available for each of the seven seat classes:

• Total Seats. This is the total number of seats for the class summed over all aircraft in the group. If any value contributing to this total is estimated, the cell will be styled as estimated.
• Average Seats. This is the number of seats for the class averaged over all aircraft in the group. If any value contributing to this total is estimated, the cell will be styled as estimated.
• Total Seat OEMs. This is the number of unique seat OEMs for the class over all aircraft in the group.
• Total IFE OEMs. This is the number of unique IFE OEMs for the class over all aircraft in the group.
• Total Internet OEMs. This is the number of unique internet OEMs for the class over all aircraft in the group.
• Total Phone OEMs. This is the number of unique phone OEMs for the class over all aircraft in the group.

Example – Seats and Internal Fit data

The following example displays all in-service Airbus aircraft that have at least one business-class seat, grouped by type and sorted by the average number of business-class seats. We also display the number of business-class seat OEMs for each group.

Aircraft values

Average Market Value and Average Market Lease Rate are added to the aircraft profiles and as columns to the Aircraft detail and Summary views. The values are 180-day rolling averages and are not specific (representing generic specification of the aircraft of a given year of build). Definitions below provide detail on how the average values are calculated:

Average Market Value ($m). This reflects a 180-day rolling average of the Half-Life Market Value for an aircraft of that vintage with the Flight Ascend Consultancy baseline specifications for that type and variant (not spec-adjusted). For aircraft that are not yet built, it reflects the average value of that aircraft if it existed today (year of build = current year).

Average Market Lease Rate (US$m). This reflects a 180-day rolling average of Market Lease Rate for an aircraft of the same vintage leased to an average airline credit. For aircraft that are not yet built, it reflects the average lease rate that could be expected of that aircraft if it existed today (year of build = current year).

Example – Aircraft values

The example below shows in-service Airbus aircraft, grouped by Type.

Company category, type, and status

On the Detail tab of the Aircraft page, we have added the following optional columns for each of the seven company roles:

• [Company Role] Category: for example, Operator Category (Airline)
• [Company Role] Type: for example, Operator Type (Low-cost)
• [Company Role] Status: for example, Operator Status (Suspended)

On the Summary Tab of the Aircraft page, we have added the following new grouping options:

• [Company Role] Category: for example, Operator Category
• [Company Role] Type: for example, Operator Type
• [Company Role] Status: for example, Operator Status

Example – Company category, type, and status

The following example makes use of the new Company Role Category grouping option on the Summary tab of the Aircraft page. In this example, the results are grouped by Operator Company Category.

Filtering by event-detail type

On the Aircraft Events page, the ability to filter by event type (for example, “Ferried”) has always been part of Flight Fleets Analyzer. In this new release, we’ve added the ability to filter by event-detail type, as this is a more granular level (for example, “Ferried to storage prior to delivery”).

Example – Filtering by event-detail type

The image below displays the Events filter page. In this example, you can see that the “Ferried” type has been selected, but now it’s also possible to select the detail type for “Ferried” events only.

Improved formatting of Excel exports

In the Excel export files, dates are now formatted as dates, and numeric columns formatted as numeric (previously they were formatted as text). This should greatly improve the ability to manipulate the exported files.

Print aircraft profiles

The ability to print aircraft profiles has been implemented. You can choose to print the whole profile or select specific pages only.

Total APU

A “Total APU” column has been added to the Summary tab of the Aircraft page.

Example – Total APU

Search for in-service A320s, A380s, and Apache helicopters, grouped by type. The Total APU column can be seen on the far right.

Trend – Date-range fix

We had a bug on the Trend tab where aircraft were generating rows of results (populated with zeroes) if the aircraft had satisfied the filter parameters at any point in time, even outside of the trend period. This has now been fixed such that the filters are only applied during the trend period.

The following two screenshots show the Trend tab of the aircraft page, both before and after the fix. In both examples, the following filters have been applied:

• Operator: British Airways
• Aircraft status: in service
• Date range: 2011-2015
• Date intervals: annual

Previously, rows were appearing for British Airways aircraft that had been in-service at any point in time.

After the fix, the filters are now being correctly applied during the trend period only. The result is far fewer rows populated entirely with zeroes. You’ll notice from the image below that even after the fix it is still possible (and valid) to see a row of zeroes. In this example, British Airways was the operator of a single A330 between 2011 and 2015, but this occurred for a short period during October 2012 and did not coincide with the end of an interval – that is, 31 December, which is when annual trend intervals are counted.