Aircraft

Column Data Type Data description Package required Key Data Set Join On
Natural ID varchar(30) Natural aircraft ID (combination of the ch-aviation production line code and either the line/construction or manufacturer serial number, changes for aircraft not yet delivered where l/n, c/n or msn are not yet known (assigned by ch-aviation) Fleets
Aircraft ID int(11) Unique ch-aviation created aircraft ID, remains stable throughout an aircraft’s life (assigned by ch-aviation) Fleets Primary
Operator Continent varchar(255) Continent the operator is based on Fleets
Operator Country varchar(255) Country the operator is certified in Fleets
Operator Country ISO char(2) ISO 3166-1 Alpha-2 country code Fleets Foreign Countries Country ISO
Operator varchar(255) Operator name Fleets
Opr. ch-a Code varchar(3) Operator ch-aviation code (assigned by ch-aviation) Fleets Foreign Airlines Airline ch-a Code
Operator Type varchar(255) Description of operator’s primary business model (Scheduled Carrier, Virtual Carrier, Division, Cargo Carrier, Business/Private Carrier, Government, Manufacturer, Supplier) Fleets
Operator Base varchar(255) Operator main base airport name Fleets
Opr. Base Airport ID int(11) Operator main base airport numeric ID Fleets Foreign Airports Airport ID
Operator IATA char(2) Operator IATA code (assigned by IATA) Fleets
Operator ICAO char(3) Operator ICAO code (assigned by ICAO) Fleets
Division varchar(96) Name of division within the operator, if applicable. Fleets
Division ch-a Code varchar(3) Division ch-aviation code (assigned by ch-aviation), if in the Airline data set. Fleets Foreign Airlines Airline ch-a Code
Former Operator varchar(64) Last former operator name History
Former Opr. ch-a Code char(3) Last former operator ch-aviation code (assigned by ch-aviation) History Foreign Airlines Airline ch-a Code
Delivery Customer varchar(64) Operator the aircraft was originally delivered to History
Delivery Opr. ch-a Code char(3) Delivery Operator ch-aviation code (assigned by ch-aviation) History Foreign Airlines Airline ch-a Code
Future Operator varchar(255) Next operator name Fleets
Future Opr. ch-a Code char(3) Next operator ch-aviation code (assigned by ch-aviation) Fleets Foreign Airlines Airline ch-a Code
Cargo Customer varchar(255) Cargo customer name Fleets
Cargo Cust. ch-a Code char(4) Cargo customer ch-aviation code (assigned by ch-aviation) Fleets Foreign Entities Entity ch-a Code
ACMI Customer varchar(255) ACMI/Wet-Lease customer name Fleets
ACMI Cust. ch-a Code char(3) ACMI/Wet-Lease customer ch-aviation code (assigned by ch-aviation) Fleets Foreign Airlines Airline ch-a Code
ACMI Operator Type varchar(255) ACMI/Wet-Lease customer operator type (refer to Operator Type above) Fleets
Regional Partnership varchar(48) Name of regional partnership brand under which the aircraft is operated Fleets Foreign Regional Partnerships Rel Subsidiary
IOSA Certified char(3) Indication if the operator is IOSA certified: yes/no/(blank) Fleets
Lease Division varchar(96) Name of division within ACMI/Wet-Lease customer, if applicable. Fleets
Remarks varchar(255) Various free text remarks Fleets
Lease Remarks varchar(255) Various free text remarks for ACMI/Wet-Lease customer Fleets
Aircraft Family varchar(255) Aircraft Family designation (i.e. A320N) Fleets
Aircraft varchar(16) Aircraft designation (i.e. A321) Fleets
Aircraft Type varchar(65) Aircraft Type designation (i.e. A321-200) Fleets
Aircraft Model varchar(32) Aircraft Model designation (i.e. A321-271N) Fleets
Aircraft Variant varchar(255) Aircraft Variant designation (i.e. A321-200N) Fleets
Production Line varchar(9) Production Line designation (i.e. A320) Fleets
Aircraft Market Group varchar(255) Market group (Widebodies, Narrowbodies, Regional Jets, Regional Turboprops, Military Aircraft) Fleets
Aircraft Role varchar(32) Aircraft’s primary role (Passenger, Cargo, Combi, Quick Change, Ambulance, Hospital, Maritime Patrol, Military, Oil Spill Response, Parachuting, Police, Tanker, Testbed, Water Bomber) Fleets
Aircraft IATA char(3) Aircraft three character IATA code (ch-aviation assigns dummy IATA codes to types for which IATA has not designated a code) Fleets Foreign Aircraft Codes/Aircraft Data IATA
Aircraft ICAO varchar(4) Aircraft four-character ICAO code Fleets
Manufacturer varchar(255) Aircraft Manufacturer Name Fleets
Manufacturer ch-a Code varchar(3) Aircraft Manufacturer ch-aviation code (assigned by ch-aviation) Fleets Foreign Airlines Airline ch-a Code
Registration varchar(16) Aircraft Registration, blank if unknown or no longer registered Fleets
Mil. Registration varchar(16) Aircraft’s secondary military registration (if dual registered) Fleets
Former Registration varchar(16) Former registration History
Former Mil. Registration varchar(16) Aircraft’s former secondary military registration (if previously dual registered) History
Future Reg. varchar(16) Future registration if already known but not yet registered Fleets
Aircraft Register varchar(255) Aircraft Registration Country Fleets

Aircraft Register ISO char(2) Aircraft Registration Country ISO 3166-1 Alpha-2 country code Fleets Foreign Countries Country ISO
C/N varchar(16) Construction/Line Number Fleets
MSN varchar(16) Manufacturer Serial Number Fleets
Hexcode char(6) ICAO 24-bit address/Mode-S hexcode Fleets
Fleet Number varchar(16) Fleet number/Tail number assigned by some operators in addition to formal registration Fleets
Block Number varchar(5) Block Number (only applicable to Boeing aircraft) Fleets
Status varchar(32) Current Aircraft Status (Active, Testbed/Demo, On repair, Stored, On display, Maintenance, Conversion, Completion, Derelict, Crashed, Beyond repair, Scrapped, Not yet delivered, Not built) Fleets
Location varchar(255) Location airport name (if the aircraft is inactive) Fleets
Location ID int(11) Location ID (assigned by ch-aviation) (if aircraft is inactive) Fleets Foreign Airports Airport ID
Location Airport Code varchar(6) Location primary airport code (in order of availability: 1) IATA, 2) ICAO, 3) FAA, 4) Alternative code (if aircraft is inactive) Fleets
Location Country varchar(255) Location country name (if aircraft is inactive) Fleets
Location Country Code char(2) Location ISO 3166-1 Alpha-2 country code (if aircraft is inactive) Fleets Foreign Countries Country ISO
Write off/Scrapping Date varchar(10) Date the aircraft was written off or scrapped (YYYY-MM-DD, YYYY-MM or YYYY) History
Roll-Out varchar(10) Date the aircraft was rolled out  (YYYY-MM-DD, YYYY-MM or YYYY) Fleets
Registration Date varchar(10) Date the aircraft was first registered  (YYYY-MM-DD, YYYY-MM or YYYY) Fleets
First Flight varchar(10) Date the aircraft has first flown  (YYYY-MM-DD, YYYY-MM or YYYY) Fleets
Delivery Date varchar(10) Actual, confirmed or estimated Delivery Date (YYYY-MM-DD, YYYY-MM or YYYY) Fleets
Delivery Date Type varchar(9) Type of Delivery Date: actual / confirmed / estimated / (NULL) Fleets
Delivery Year int(4) Delivery Year (YYYY) Fleets
Manufactured Year year(4) Manufactured Year (based on the lowest of roll-out, registration, first flight, delivery or first sighting date) (YYYY) Fleets
First Sighting varchar(10) Date the aircraft was first seen (if other dates are unknown) (YYYY-MM-DD, YYYY-MM or YYYY) Fleets
Age (a) decimal(4,1) Aircraft age (based on the lowest of roll-out, registration, first flight, delivery or first sighting date) Fleets
Date In varchar(10) Date the aircraft was delivered to the current operator History
Stored As Of Date varchar(10) Date as of which the aircraft has been inactive (YYYY-MM-DD, YYYY-MM or YYYY) History
Engine Manufacturer varchar(255) Engine manufacturer name Fleets
Engine Manufacturer ch-a Code varchar(4) Engine manufacturer ch-aviation code (assigned by ch-aviation) Fleets Foreign Entities Entity ch-a Code
Engine Family varchar(16) Engine family (i.e. JT9D) Fleets
Engine Master Series varchar(32) Engine master series designation (i.e. JT9D-7R4) Fleets
Engine Type varchar(16) Engine type designation (i.e. PW JT9D) Fleets
Engine Subtype varchar(32) Engine subtype designation (i.e. PW JT9D-7R4H1) Fleets
Number of Engines int(11) Number of engines installed on the aircraft Fleets
MTOW (kg) int(11) Maximum take-off weight in kilogrammes Fleets
Generic MTOW? varchar(8) Indication whether the maximum take-off weight is generic or verified (yes, no) Fleets
MTOW (lb) decimal(11,2) Maximum take-off weight in pounds Fleets
Seats Y smallint(6) Seats in Economy Fleets
Seats YP smallint(6) Seats in Economy Plus/Comfort, ch-aviation applies the following methodology for Economy Plus/Comfort vs. Premium Economy aircraft seat configurations/capacity calculations to ensure comparability across all carriers worldwide: ch-aviation only considers cabins to be Premium Economy if the maximum number of seats per row (Max Abreast) is at least 2 seats less than the maximum number of seats that could physically be fitted in Economy Class for the aircraft type (i.e. 10 for a B777) no matter what the actual maximum abreast configuration on that aircraft is. Fleets
Seats W smallint(6) Seats in Premium Economy, ch-aviation applies the following methodology for Economy Plus/Comfort vs. Premium Economy aircraft seat configurations/capacity calculations to ensure comparability across all carriers worldwide: ch-aviation only considers cabins to be Premium Economy if the maximum number of seats per row (Max Abreast) is at least 2 seats less than the maximum number of seats that could physically be fitted in Economy Class for the aircraft type (i.e. 10 for a B777) no matter what the actual maximum abreast configuration on that aircraft is. Fleets
Seats C smallint(6) Seats in Business, ch-aviation applies the following methodology for Business vs. First aircraft seat configurations/capacity calculations to ensure comparability across all carriers worldwide: ch-aviation only considers narrowbody cabins to be First Class if the maximum number of seats per row (Max Abreast) is 2 and widebody cabins to be First Class if the maximum number of seats across per row is 4 (unless there is a Business and First Class cabin installed on the aircraft and the First Class cabin has more than 4 seats across per row in these exceptional cases). Fleets
Seats F smallint(6) Seats in First, ch-aviation applies the following methodology for Business vs. First aircraft seat configurations/capacity calculations to ensure comparability across all carriers worldwide: ch-aviation only considers narrowbody cabins to be First Class if the maximum number of seats per row (Max Abreast) is 2 and widebody cabins to be First Class if the maximum number of seats across per row is 4 (unless there is a Business and First Class cabin installed on the aircraft and the First Class cabin has more than 4 seats across per row in these exceptional cases). Fleets
Max Abreast Y smallint(6) Maximum number of seats per row in Economy Fleets
Max Abreast YP smallint(6) Maximum number of seats per row in Economy Plus/Comfort Fleets
Max Abreast W smallint(6) Maximum number of seats per row in Premium Economy Fleets
Max Abreast C smallint(6) Maximum number of seats per row in Business Fleets
Max Abreast F smallint(6) Maximum number of seats per row in First Fleets
Pitch Y (lowest) decimal(5,2) Minimum seat pitch in Economy Fleets
Pitch Y (highest) decimal(5,2) Maximum seat pitch in Economy Fleets
Pitch YP (lowest) decimal(5,2) Minimum seat pitch in Economy Plus/Comfort Fleets
Pitch YP (highest) decimal(5,2) Maximum seat pitch in Economy Plus/Comfort Fleets
Pitch W (lowest) decimal(5,2) Minimum seat pitch in Premium Economy Fleets

Pitch W (highest) decimal(5,2) Maximum seat pitch in Premium Economy Fleets
Pitch C (lowest) decimal(5,2) Minimum seat pitch in Business Fleets
Pitch C (highest) decimal(5,2) Maximum seat pitch in Business Fleets
Pitch F (lowest) decimal(5,2) Minimum seat pitch in First Fleets
Pitch F (highest) decimal(5,2) Maximum seat pitch in First Fleets
Seats Comment varchar(32) Free text comments regarding seat configuration: VIP: aircraft is in VIP configuration. CY and WY: European business/premium economy class. Physically seats are not different from Y class, but there is either a removable curtain separating classes and/or ability to block seats and/or seat can be reclined. Full-flat in C; C/F; or F: seat can be fully reclined to 180°. Skycouch (in Y, in YP): Skycouch is available (in a certain class). What we consider to be a skycouch is a physical modification of the actual seat that allows extension and seat modification to a couch-like configuration of the seat block. Not full-flat in C; C/F: seat in C; C/F cannot be fully reclined (not 180°). Suite in F: every closed compartment where passenger seat and bed are separated in a room like environment Fleets
In-Seat Video Y char(3) Indication if in-seat video is installed in Economy: yes/no/(blank) Fleets
In-Seat Video YP char(3) Indication if in-seat video is installed in Economy Plus/Comfort: yes/no/(blank) Fleets
In-Seat Video W char(3) Indication if in-seat video is installed in Premium Economy: yes/no/(blank) Fleets
In-Seat Video C char(3) Indication if in-seat video is installed in Business: yes/no/(blank) Fleets
In-Seat Video F char(3) Indication if in-seat video is installed in First: yes/no/(blank) Fleets
Inflight Connectivity char(3) Indication if inflight connectivity is installed on the aircraft: yes/no/(blank) Fleets
Owner varchar(200) Aircraft legal owner name (i.e. FLY Leasing) Ownership
Owner Ent. ch-a Code varchar(4) Aircraft legal owner ch-aviation code (assigned by ch-aviation) Ownership Foreign Entities Entity ch-a Code
Manager varchar(200) Aircraft asset manager name (i.e. BBAM) Ownership
Manager Ent. ch-a Code varchar(4) Aircraft asset manager ch-aviation code (assigned by ch-aviation) Ownership Foreign Entities Entity ch-a Code
Ownership Type varchar(32) Aircraft ownership type (Associated company-owner, BizAv-managed, Company-owned, Financial lease, Government, Operating lease, Remarketed, Unknown, Withdrawn from use) Ownership
Registered Trust varchar(200) Trust the aircraft is registered to (if appliable) Ownership
SPV varchar(200) Name of special purpose vehicle company set-up to hold the aircraft asset Ownership
Market Lease Rate decimal(12,2) Current market lease rate in USD (provided by Collateral Verifications, value assumptions defined here. Values
Current Market Value (*Million) decimal(5,2) Current market value in USD (provided by Collateral Verifications), value assumptions defined here. Values
Operating Lease End Date varchar(10) Operating lease end date (YYYY-MM-DD, YYYY-MM or YYYY) Ownership
Lease End Date Type varchar(24) Operating lease end type: Confirmed Lease End Date / At least leased until / Estimated Lease End Date / (NULL) Ownership
Projected Retirement Date varchar(10) Projected retirement date (YYYY-MM-DD, YYYY-MM or YYYY) Fleets
Projected Retirement Date Type varchar(13) Projected retirement date type: confirmed / estimated / minimum_until / (NULL) Fleets
Future Operator Date In varchar(10) Future operator date in date (YYYY-MM-DD, YYYY-MM or YYYY) Fleets      
Future Operator Date In Type varchar(9) Future operator date in type: confirmed / estimated / (NULL) Fleets      
Availability char(3) Aircraft listed as available via MyAirTrade (www.myairtrade.com): yes / no Fleets      
Avl. Company varchar(255) Company listing the aircraft on MyAirTrade Fleets      
Avl. Contact Name varchar(255) Contact name of MyAirTrade listing Fleets      
Avl. Email varchar(255) E-Mail address of MyAirTrade listing Fleets      
Avl. Phone varchar(255) Phone number of MyAirTrade listing Fleets      
Lease/ACMI/Sale varchar(255) Aircraft listed as available for Operating Lease (OL), ACMI Lease (A) or Sale (S) on MyAirTrade Fleets      
Listed varchar(255) Date the aircraft was initially listed on MyAirTrade (YYMMDD) Fleets      
Available varchar(255) Date the aircraft will be available from (based on MyAirTrade listing) (YYMMDD) Fleets      
Order Entity varchar(255) Operator or lessor name of entity that has ordered the aircraft Fleets      
Order Entity ch-a Code varchar(4) Operator or lessor entity code (assigned by ch-aviation) Fleets Foreign Entities Entity ch-a Code
Order Date varchar(10) Order date (YYYY-MM-DD, YYYY-MM or YYYY) where available Fleets      
Order Cancellation Date varchar(10) Order cancellation date (YYYY-MM-DD, YYYY-MM or YYYY) where available, only for not built aircraft Fleets      
Order Commentary varchar(255) Order free text commentary regarding planned delivery dates (where uncertain or unknown) Fleets      
Hours decimal(10,2) Cumulative number of flight hours since entry into service Fleets      
Cycles int(11) Cumulative number of flight cycles since entry into service Fleets      
Hours TTM decimal(10,2) Number of flight hours in TTM (trailing twelve months) Fleets      
Cycles TTM int(11) Number of flight cycles in TTM (trailing twelve months) Fleets      
As of date varchar(10) As of date (YYYY-MM-DD) for flight hours/cycles information Fleets      
Source varchar(255) Source for flight hours/cycles information Fleets      
Avg. Stage Length varchar(5) Average stage length (flight duration) (hh:mm) Fleets      
Avg. Annual Hours decimal(10,2) Average annual flight hours since entry into service Fleets      
Avg. Annual Cycles decimal(10,2) Average annual flight cycles since entry into service Fleets      
Avg. Daily Utilisation TTM varchar(5) Average daily utilisation (in flight hours) in TTM (trailing twelve months) (hh:mm) Fleets      
Avg. Daily Utilisation varchar(5) Average daily utilisation (in flight hours) since entry into service (hh:mm) Fleets      
Last Updated date Date the aircraft record has last been updated (YYYY-MM-DD) Fleets