Aircraft

ColumnData TypeData descriptionPackage requiredKeyData SetJoin On
Natural IDvarchar(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 IDint(11)Unique ch-aviation created aircraft ID, remains stable throughout an aircraft’s life (assigned by ch-aviation)FleetsPrimary
Operator Continentvarchar(255)Continent the operator is based onFleets
Operator Countryvarchar(255)Country the operator is certified inFleets
Operator Country ISOchar(2)ISO 3166-1 Alpha-2 country codeFleetsForeignCountriesCountry ISO
Operatorvarchar(255)Operator nameFleets
Opr. ch-a Codevarchar(3)Operator ch-aviation code (assigned by ch-aviation)FleetsForeignAirlinesAirline ch-a Code
Operator Typevarchar(255)Description of operator’s primary business model (Scheduled Carrier, Virtual Carrier, Division, Cargo Carrier, Business/Private Carrier, Government, Manufacturer, Supplier)Fleets
Operator Basevarchar(255)Operator main base airport nameFleets
Opr. Base Airport IDint(11)Operator main base airport numeric IDFleetsForeignAirportsAirport ID
Operator IATAchar(2)Operator IATA code (assigned by IATA)Fleets
Operator ICAOchar(3)Operator ICAO code (assigned by ICAO)Fleets
Divisionvarchar(96)Name of division within the operator, if applicable.Fleets
Division ch-a Codevarchar(3)Division ch-aviation code (assigned by ch-aviation), if in the Airline data set.FleetsForeignAirlinesAirline ch-a Code
Former Operatorvarchar(64)Last former operator nameHistory
Former Opr. ch-a Codechar(3)Last former operator ch-aviation code (assigned by ch-aviation)HistoryForeignAirlinesAirline ch-a Code
Delivery Customervarchar(64)Operator the aircraft was originally delivered toHistory
Delivery Opr. ch-a Codechar(3)Delivery Operator ch-aviation code (assigned by ch-aviation)HistoryForeignAirlinesAirline ch-a Code
Future Operatorvarchar(255)Next operator nameFleets
Future Opr. ch-a Codechar(3)Next operator ch-aviation code (assigned by ch-aviation)FleetsForeignAirlinesAirline ch-a Code
Cargo Customervarchar(255)Cargo customer nameFleets
Cargo Cust. ch-a Codechar(4)Cargo customer ch-aviation code (assigned by ch-aviation)FleetsForeignEntitiesEntity ch-a Code
ACMI Customervarchar(255)ACMI/Wet-Lease customer nameFleets
ACMI Cust. ch-a Codechar(3)ACMI/Wet-Lease customer ch-aviation code (assigned by ch-aviation)FleetsForeignAirlinesAirline ch-a Code
ACMI Operator Typevarchar(255)ACMI/Wet-Lease customer operator type (refer to Operator Type above)Fleets
Regional Partnershipvarchar(48)Name of regional partnership brand under which the aircraft is operatedFleetsForeignRegional PartnershipsRel Subsidiary
IOSA Certifiedchar(3)Indication if the operator is IOSA certified: yes/no/(blank)Fleets
Lease Divisionvarchar(96)Name of division within ACMI/Wet-Lease customer, if applicable.Fleets
Remarksvarchar(255)Various free text remarksFleets
Lease Remarksvarchar(255)Various free text remarks for ACMI/Wet-Lease customerFleets
Aircraft Familyvarchar(255)Aircraft Family designation (i.e. A320N)Fleets
Aircraftvarchar(16)Aircraft designation (i.e. A321)Fleets
Aircraft Typevarchar(65)Aircraft Type designation (i.e. A321-200)Fleets
Aircraft Modelvarchar(32)Aircraft Model designation (i.e. A321-271N)Fleets
Aircraft Variantvarchar(255)Aircraft Variant designation (i.e. A321-200N)Fleets
Production Linevarchar(9)Production Line designation (i.e. A320)Fleets
Aircraft Market Groupvarchar(255)Market group (Widebodies, Narrowbodies, Regional Jets, Regional Turboprops, Military Aircraft)Fleets
Aircraft Rolevarchar(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 IATAchar(3)Aircraft three character IATA code (ch-aviation assigns dummy IATA codes to types for which IATA has not designated a code)FleetsForeignAircraft Codes/Aircraft DataIATA
Aircraft ICAOvarchar(4)Aircraft four-character ICAO codeFleets
Manufacturervarchar(255)Aircraft Manufacturer NameFleets
Manufacturer ch-a Codevarchar(3)Aircraft Manufacturer ch-aviation code (assigned by ch-aviation)FleetsForeignAirlinesAirline ch-a Code
Registrationvarchar(16)Aircraft Registration, blank if unknown or no longer registeredFleets
Mil. Registrationvarchar(16)Aircraft’s secondary military registration (if dual registered)Fleets
Former Registrationvarchar(16)Former registrationHistory
Former Mil. Registrationvarchar(16)Aircraft’s former secondary military registration (if previously dual registered)History
Future Reg.varchar(16)Future registration if already known but not yet registeredFleets
Aircraft Registervarchar(255)Aircraft Registration CountryFleets
Aircraft Register ISOchar(2)Aircraft Registration Country ISO 3166-1 Alpha-2 country codeFleetsForeignCountriesCountry ISO
C/Nvarchar(16)Construction/Line NumberFleets
MSNvarchar(16)Manufacturer Serial NumberFleets
Hexcodechar(6)ICAO 24-bit address/Mode-S hexcodeFleets
Fleet Numbervarchar(16)Fleet number/Tail number assigned by some operators in addition to formal registrationFleets
Block Numbervarchar(5)Block Number (only applicable to Boeing aircraft)Fleets
Statusvarchar(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
Locationvarchar(255)Location airport name (if the aircraft is inactive)Fleets
Location IDint(11)Location ID (assigned by ch-aviation) (if aircraft is inactive)FleetsForeignAirportsAirport ID
Location Airport Codevarchar(6)Location primary airport code (in order of availability: 1) IATA, 2) ICAO, 3) FAA, 4) Alternative code (if aircraft is inactive)Fleets
Location Countryvarchar(255)Location country name (if aircraft is inactive)Fleets
Location Country Codechar(2)Location ISO 3166-1 Alpha-2 country code (if aircraft is inactive)FleetsForeignCountriesCountry ISO
Write off/Scrapping Datevarchar(10)Date the aircraft was written off or scrapped (YYYY-MM-DD, YYYY-MM or YYYY)History
Roll-Outvarchar(10)Date the aircraft was rolled out  (YYYY-MM-DD, YYYY-MM or YYYY)Fleets
Registration Datevarchar(10)Date the aircraft was first registered  (YYYY-MM-DD, YYYY-MM or YYYY)Fleets
First Flightvarchar(10)Date the aircraft has first flown  (YYYY-MM-DD, YYYY-MM or YYYY)Fleets
Delivery Datevarchar(10)Actual, confirmed or estimated Delivery Date (YYYY-MM-DD, YYYY-MM or YYYY)Fleets
Delivery Date Typevarchar(9)Type of Delivery Date: actual / confirmed / estimated / (NULL)Fleets
Delivery Yearint(4)Delivery Year (YYYY)Fleets
Manufactured Yearyear(4)Manufactured Year (based on the lowest of roll-out, registration, first flight, delivery or first sighting date) (YYYY)Fleets
First Sightingvarchar(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 Invarchar(10)Date the aircraft was delivered to the current operatorHistory
Stored As Of Datevarchar(10)Date as of which the aircraft has been inactive (YYYY-MM-DD, YYYY-MM or YYYY)History
Engine Manufacturervarchar(255)Engine manufacturer nameFleets
Engine Manufacturer ch-a Codevarchar(4)Engine manufacturer ch-aviation code (assigned by ch-aviation)FleetsForeignEntitiesEntity ch-a Code
Engine Familyvarchar(16)Engine family (i.e. JT9D)Fleets
Engine Master Seriesvarchar(32)Engine master series designation (i.e. JT9D-7R4)Fleets
Engine Typevarchar(16)Engine type designation (i.e. PW JT9D)Fleets
Engine Subtypevarchar(32)Engine subtype designation (i.e. PW JT9D-7R4H1)Fleets
Number of Enginesint(11)Number of engines installed on the aircraftFleets
MTOW (kg)int(11)Maximum take-off weight in kilogrammesFleets
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 poundsFleets
Seats Ysmallint(6)Seats in EconomyFleets
Seats YPsmallint(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 Wsmallint(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 Csmallint(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 Fsmallint(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 Ysmallint(6)Maximum number of seats per row in EconomyFleets
Max Abreast YPsmallint(6)Maximum number of seats per row in Economy Plus/ComfortFleets
Max Abreast Wsmallint(6)Maximum number of seats per row in Premium EconomyFleets
Max Abreast Csmallint(6)Maximum number of seats per row in BusinessFleets
Max Abreast Fsmallint(6)Maximum number of seats per row in FirstFleets
Pitch Y (lowest)decimal(5,2)Minimum seat pitch in EconomyFleets
Pitch Y (highest)decimal(5,2)Maximum seat pitch in EconomyFleets
Pitch YP (lowest)decimal(5,2)Minimum seat pitch in Economy Plus/ComfortFleets
Pitch YP (highest)decimal(5,2)Maximum seat pitch in Economy Plus/ComfortFleets
Pitch W (lowest)decimal(5,2)Minimum seat pitch in Premium EconomyFleets
Pitch W (highest)decimal(5,2)Maximum seat pitch in Premium EconomyFleets
Pitch C (lowest)decimal(5,2)Minimum seat pitch in BusinessFleets
Pitch C (highest)decimal(5,2)Maximum seat pitch in BusinessFleets
Pitch F (lowest)decimal(5,2)Minimum seat pitch in FirstFleets
Pitch F (highest)decimal(5,2)Maximum seat pitch in FirstFleets
Seats Commentvarchar(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 environmentFleets
In-Seat Video Ychar(3)Indication if in-seat video is installed in Economy: yes/no/(blank)Fleets
In-Seat Video YPchar(3)Indication if in-seat video is installed in Economy Plus/Comfort: yes/no/(blank)Fleets
In-Seat Video Wchar(3)Indication if in-seat video is installed in Premium Economy: yes/no/(blank)Fleets
In-Seat Video Cchar(3)Indication if in-seat video is installed in Business: yes/no/(blank)Fleets
In-Seat Video Fchar(3)Indication if in-seat video is installed in First: yes/no/(blank)Fleets
Inflight Connectivitychar(3)Indication if inflight connectivity is installed on the aircraft: yes/no/(blank)Fleets
Ownervarchar(200)Aircraft legal owner name (i.e. FLY Leasing)Ownership
Owner Ent. ch-a Codevarchar(4)Aircraft legal owner ch-aviation code (assigned by ch-aviation)OwnershipForeignEntitiesEntity ch-a Code
Managervarchar(200)Aircraft asset manager name (i.e. BBAM)Ownership
Manager Ent. ch-a Codevarchar(4)Aircraft asset manager ch-aviation code (assigned by ch-aviation)OwnershipForeignEntitiesEntity ch-a Code
Ownership Typevarchar(32)Aircraft ownership type (Associated company-owner, BizAv-managed, Company-owned, Financial lease, Government, Operating lease, Remarketed, Unknown, Withdrawn from use)Ownership
Registered Trustvarchar(200)Trust the aircraft is registered to (if appliable)Ownership
SPVvarchar(200)Name of special purpose vehicle company set-up to hold the aircraft assetOwnership
Market Lease Ratedecimal(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 Datevarchar(10)Operating lease end date (YYYY-MM-DD, YYYY-MM or YYYY)Ownership
Lease End Date Typevarchar(24)Operating lease end type: Confirmed Lease End Date / At least leased until / Estimated Lease End Date / (NULL)Ownership
Projected Retirement Datevarchar(10)Projected retirement date (YYYY-MM-DD, YYYY-MM or YYYY)Fleets
Projected Retirement Date Typevarchar(13)Projected retirement date type: confirmed / estimated / minimum_until / (NULL)Fleets
Future Operator Date Invarchar(10)Future operator date in date (YYYY-MM-DD, YYYY-MM or YYYY)Fleets
Future Operator Date In Typevarchar(9)Future operator date in type: confirmed / estimated / (NULL)Fleets
Availabilitychar(3)Aircraft listed as available via MyAirTrade (www.myairtrade.com): yes / noFleets
Avl. Companyvarchar(255)Company listing the aircraft on MyAirTradeFleets
Avl. Contact Namevarchar(255)Contact name of MyAirTrade listingFleets
Avl. Emailvarchar(255)E-Mail address of MyAirTrade listingFleets
Avl. Phonevarchar(255)Phone number of MyAirTrade listingFleets
Lease/ACMI/Salevarchar(255)Aircraft listed as available for Operating Lease (OL), ACMI Lease (A) or Sale (S) on MyAirTradeFleets
Listedvarchar(255)Date the aircraft was initially listed on MyAirTrade (YYMMDD)Fleets
Availablevarchar(255)Date the aircraft will be available from (based on MyAirTrade listing) (YYMMDD)Fleets
Order Entityvarchar(255)Operator or lessor name of entity that has ordered the aircraftFleets
Order Entity ch-a Codevarchar(4)Operator or lessor entity code (assigned by ch-aviation)FleetsForeignEntitiesEntity ch-a Code
Order Datevarchar(10)Order date (YYYY-MM-DD, YYYY-MM or YYYY) where availableFleets
Order Cancellation Datevarchar(10)Order cancellation date (YYYY-MM-DD, YYYY-MM or YYYY) where available, only for not built aircraftFleets
Order Commentaryvarchar(255)Order free text commentary regarding planned delivery dates (where uncertain or unknown)Fleets
Hoursdecimal(10,2)Cumulative number of flight hours since entry into serviceFleets
Cyclesint(11)Cumulative number of flight cycles since entry into serviceFleets
Hours TTMdecimal(10,2)Number of flight hours in TTM (trailing twelve months)Fleets
Cycles TTMint(11)Number of flight cycles in TTM (trailing twelve months)Fleets
As of datevarchar(10)As of date (YYYY-MM-DD) for flight hours/cycles informationFleets
Sourcevarchar(255)Source for flight hours/cycles informationFleets
Avg. Stage Lengthvarchar(5)Average stage length (flight duration) (hh:mm)Fleets
Avg. Annual Hoursdecimal(10,2)Average annual flight hours since entry into serviceFleets
Avg. Annual Cyclesdecimal(10,2)Average annual flight cycles since entry into serviceFleets
Avg. Daily Utilisation TTMvarchar(5)Average daily utilisation (in flight hours) in TTM (trailing twelve months) (hh:mm)Fleets
Avg. Daily Utilisationvarchar(5)Average daily utilisation (in flight hours) since entry into service (hh:mm)Fleets
Last UpdateddateDate the aircraft record has last been updated (YYYY-MM-DD)Fleets