Aircraft

ColumnData TypeData descriptionPackage requiredSegments supportedKeyData 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)FleetsAll
Aircraft IDint(11)Unique ch-aviation created aircraft ID, remains stable throughout an aircraft's life (assigned by ch-aviation)FleetsAllPrimary
Operator Continentvarchar(255)Continent the operator is based onFleetsAll
Operator Countryvarchar(255)Country the operator is certified inFleetsAll
Operator Country ISOchar(2)ISO 3166-1 Alpha-2 country codeFleetsAllForeignCountriesCountry ISO
Operatorvarchar(255)Operator name (if Operator is "Multiple Operators", the aircraft's multiple operators can be found in the Aircraft Multiple Operators table)FleetsAll
Opr. ch-a Codevarchar(5)Operator ch-aviation code (assigned by ch-aviation). Operator ch-aviation codes can be 2, 3, or 5 characters. (if Opr. ch-a Code is MLT, the aircraft's multiple operators can be found in the Aircraft Multiple Operators table)FleetsAllForeignAirlinesAirline 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)FleetsAll
Operator Basevarchar(255)Operator main base airport nameFleetsAll
Opr. Base Airport IDint(11)Operator main base airport numeric IDFleetsAllForeignAirportsAirport ID
Operator IATAchar(2)Operator IATA code (assigned by IATA)FleetsAll
Operator ICAOchar(3)FleetsAll
Divisionvarchar(96)Name of division within the operator, if applicable.FleetsAll
Division ch-a Codevarchar(5)Division ch-aviation code (assigned by ch-aviation), if in the Airline data set. Division ch-aviation codes can be 2, 3, or 5 characters.FleetsAllForeignAirlinesAirline ch-a Code
Former Operatorvarchar(64)Last former operator name (if Former Operator is "Multiple Operators", the aircraft's multiple operators can be found in the Aircraft Histories Multiple Operators table)HistoryAll
Former Opr. ch-a Codevarchar(5)Last former operator ch-aviation code (assigned by ch-aviation). Former operator ch-aviation codes can be 2, 3, or 5 characters. (if Former Opr. ch-a Code is MLT, the aircraft's multiple operators can be found in the Aircraft Histories Multiple Operators table)HistoryAllForeignAirlinesAirline ch-a Code
Delivery Customervarchar(64)Operator the aircraft was originally delivered to (if Delivery Customer is "Multiple Operators", the aircraft's multiple operators can be found in the Aircraft Histories Multiple Operators table)HistoryAll
Delivery Opr. ch-a Codevarchar(5)Delivery Operator ch-aviation code (assigned by ch-aviation). Delivery Operator ch-aviation codes can be 2, 3, or 5 characters. (if Delivery Opr. ch-a Code is MLT, the aircraft's multiple operators can be found in the Aircraft Histories Multiple Operators table)HistoryAllForeignAirlinesAirline ch-a Code
Future Operatorvarchar(255)Next operator nameFleetsAll
Future Opr. ch-a Codevarchar(5)Next operator ch-aviation code (assigned by ch-aviation). Future Operator ch-aviation codes can be 2, 3, or 5 characters.FleetsAllForeignAirlinesAirline ch-a Code
Cargo Customervarchar(255)Cargo customer nameFleetsAll
Cargo Cust. ch-a Codechar(4)Cargo customer ch-aviation code (assigned by ch-aviation).FleetsAllForeignEntitiesEntity ch-a Code
ACMI Customervarchar(255)ACMI/Wet-Lease customer nameFleetsCommercial Aviation
ACMI Cust. ch-a Codevarchar(5)ACMI/Wet-Lease customer ch-aviation code (assigned by ch-aviation). ACMI Customer ch-aviation codes can be 2, 3, or 5 characters.FleetsCommercial AviationForeignAirlinesAirline ch-a Code
ACMI Operator Typevarchar(255)ACMI/Wet-Lease customer operator type (refer to Operator Type above)FleetsCommercial Aviation
Regional Partnershipvarchar(48)Name of regional partnership brand under which the aircraft is operatedFleetsCommercial AviationForeignRegional PartnershipsRel Subsidiary
IOSA Certifiedchar(3)Indication if the operator is IOSA certified: yes/no/(blank)FleetsCommercial Aviation
Lease Divisionvarchar(96)Name of division within ACMI/Wet-Lease customer, if applicable.FleetsAll
Remarksvarchar(255)Various free text remarksFleetsAll
Lease Remarksvarchar(255)Various free text remarks for ACMI/Wet-Lease customerFleetsAll
Aircraft Familyvarchar(255)Aircraft Family designation (i.e. A320N)FleetsAll
Aircraftvarchar(16)Aircraft designation (i.e. A321)FleetsAll
Aircraft Typevarchar(65)Aircraft Type designation (i.e. A321-200)FleetsAll
Aircraft Modelvarchar(32)Aircraft Model designation (i.e. A321-271N)FleetsAll
Aircraft Variantvarchar(255)Aircraft Variant designation (i.e. A321-200N)FleetsAll
Production Linevarchar(9)Production Line designation (i.e. A320)FleetsAll
Aircraft Market Groupvarchar(255)Market group (Widebodies, Narrowbodies, Regional Jets, Regional Turboprops, Military Aircraft)FleetsAll
Aircraft Rolevarchar(32)Aircraft's primary role (Passenger, Passenger-Freighter, Cargo, Combi, Quick Change, Ambulance, Hospital, Maritime Patrol, Military, Oil Spill Response, Parachuting, Police, Tanker, Testbed, Water Bomber, VIP)FleetsAll
Aircraft IATAchar(3)Aircraft three character IATA code (ch-aviation assigns dummy IATA codes to types for which IATA has not designated a code)FleetsAllForeignAircraft Codes/Aircraft DataIATA
Aircraft ICAOvarchar(4)Aircraft four-character ICAO codeFleetsAll
Operator Aircraft Certificationvarchar(255)Aircraft certification descriptionFleetsBusiness Jets
Manufacturervarchar(255)Aircraft Manufacturer NameFleetsAll
Manufacturer ch-a Codevarchar(3)Aircraft Manufacturer ch-aviation code (assigned by ch-aviation)FleetsAllForeignAirlinesAirline ch-a Code
Registrationvarchar(16)Aircraft Registration, blank if unknown or no longer registeredFleetsAll
Mil. Registrationvarchar(16)Aircraft's secondary military registration (if dual registered)FleetsAll
Former Registrationvarchar(16)Former registrationHistoryAll
Former Mil. Registrationvarchar(16)Aircraft's former secondary military registration (if previously dual registered)HistoryAll
Future Reg.varchar(16)Future registration if already known but not yet registeredFleetsAll
Aircraft Registervarchar(255)Aircraft Registration CountryFleetsAll
Aircraft Register ISOchar(2)Aircraft Registration Country ISO 3166-1 Alpha-2 country codeFleetsAllForeignCountriesCountry ISO
Aircraft Basevarchar(255)Aircraft base airport nameFleetsBusiness Jets
Aircraft Base IDint(11)Operator main base airport numeric IDFleetsBusiness JetsForeignAirportsAirport ID
Aircraft Base ch-a Codevarchar(6)ch-aviation main airport code (if available IATA, otherwise ICAO, otherwise FAA/Other code) for aircraft baseFleetsBusiness Jets
Aircraft Base Subdivisionvarchar(255)Aircraft base state/subdivision nameFleetsBusiness Jets
Aircraft Base Subdivision ch-a Codechar(2)Aircraft base state/subdivision ISO 3166-2 Alpha-2 subdivision codeFleetsBusiness Jets
Aircraft Base Metro Groupvarchar(255)Aircraft base metro group descriptionFleetsBusiness Jets
Aircraft Base Metro Group IATAchar(3)Aircraft base metro group IATA codeFleetsBusiness Jets
Aircraft Base Countryvarchar(255)Aircraft base country nameFleetsBusiness Jets
Aircraft Base Country ISOchar(2)Aircraft Base ISO 3166-1 Alpha-2 country codeFleetsBusiness Jets
Aircraft Base Continentvarchar(255)Aircraft base continent nameFleetsBusiness Jets
C/Nvarchar(16)Construction/Line NumberFleetsAll
MSNvarchar(16)Manufacturer Serial NumberFleetsAll
Hexcodechar(6)ICAO 24-bit address/Mode-S hexcodeFleetsAll
Fleet Numbervarchar(16)Fleet number/Tail number assigned by some operators in addition to formal registrationFleetsAll
Block Numbervarchar(5)Block Number (only applicable to Boeing aircraft)FleetsAll
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)FleetsAll
Locationvarchar(255)Location airport name (if the aircraft is inactive)FleetsAll
Location IDint(11)Location ID (assigned by ch-aviation) (if aircraft is inactive)FleetsAllForeignAirportsAirport 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)FleetsAll
Location Countryvarchar(255)Location country name (if aircraft is inactive)FleetsAll
Location Country Codechar(2)Location ISO 3166-1 Alpha-2 country code (if aircraft is inactive)FleetsAllForeignCountriesCountry ISO
Construction Sitevarchar(255)Construction site airport nameFleetsAll
Construction Site ch-a Codevarchar(6)Construction site airport code (in order of availability: 1) IATA, 2) ICAO, 3) FAA, 4) Alternative codeFleetsAllForeignAirportsMain code
Construction Site Countryvarchar(255)Construction site country name (if aircraft is inactive)FleetsAll
Construction Site Country ISO Codechar(2)Construction site Country ISO 3166-1 Alpha-2 country codeFleetsAllForeignCountriesCountry ISO
Construction Site Continentvarchar(255)Continent of the onstruction siteFleetsAll
Write off/Scrapping Datevarchar(10)Date the aircraft was written off or scrapped (YYYY-MM-DD, YYYY-MM or YYYY)HistoryAll
Roll-Outvarchar(10)Date the aircraft was rolled out  (YYYY-MM-DD, YYYY-MM or YYYY)FleetsAll
Registration Datevarchar(10)Date the aircraft was first registered  (YYYY-MM-DD, YYYY-MM or YYYY)FleetsAll
First Flightvarchar(10)Date the aircraft has first flown  (YYYY-MM-DD, YYYY-MM or YYYY)FleetsAll
Delivery Datevarchar(10)Actual, confirmed or estimated Delivery Date (YYYY-MM-DD, YYYY-MM or YYYY)FleetsAll
Delivery Date Typevarchar(9)Type of Delivery Date: actual / confirmed / estimated / (NULL)FleetsAll
Delivery Yearint(4)Delivery Year (YYYY)FleetsAll
Manufactured Yearyear(4)Manufactured Year (based on the lowest of roll-out, registration, first flight, delivery or first sighting date) (YYYY)FleetsAll
First Sightingvarchar(10)Date the aircraft was first seen (if other dates are unknown) (YYYY-MM-DD, YYYY-MM or YYYY)FleetsAll
Age (a)decimal(4,1)Aircraft age (based on the lowest of roll-out, registration, first flight, delivery or first sighting date)FleetsAll
Date Invarchar(10)Date the aircraft was delivered to the current operatorHistoryAll
Stored As Of Datevarchar(10)Date as of which the aircraft has been inactive (YYYY-MM-DD, YYYY-MM or YYYY)HistoryAll
Engine Manufacturervarchar(255)Engine manufacturer nameFleetsAll
Engine Manufacturer ch-a Codevarchar(4)Engine manufacturer ch-aviation code (assigned by ch-aviation)FleetsAllForeignEntitiesEntity ch-a Code
Engine Familyvarchar(16)Engine family (i.e. JT9D)FleetsAll
Engine Master Seriesvarchar(32)Engine master series designation (i.e. JT9D-7R4)FleetsAll
Engine Typevarchar(16)Engine type designation (i.e. PW JT9D)FleetsAll
Engine Subtypevarchar(32)Engine subtype designation (i.e. PW JT9D-7R4H1)FleetsAll
Number of Enginesint(11)Number of engines installed on the aircraftFleetsAll
ICAO Engine Emission Databank IDvarchar(32)Common unique identifier of ICAO Engine Emissions DatabankFleetsAll
MTOW (kg)int(11)Maximum take-off weight in kilogrammesFleetsAll
Generic MTOWvarchar(8)Indication whether the maximum take-off weight is generic or verified (yes, no)FleetsAll
MTOW (lb)decimal(11,2)Maximum take-off weight in poundsFleetsAll
Cargo Loading Typevarchar(255)Type of loading the cargo into specially defined sections of an aircraftFleetsAll
Seats Ysmallint(6)Seats in EconomyFleetsCommercial Aviation
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.FleetsCommercial Aviation
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.FleetsCommercial Aviation
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).FleetsCommercial Aviation
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).FleetsCommercial Aviation
Seats Totalsmallint(6)Total number of seatsFleetsAll
Max Abreast Ysmallint(6)Maximum number of seats per row in EconomyFleetsCommercial Aviation
Max Abreast YPsmallint(6)Maximum number of seats per row in Economy Plus/ComfortFleetsCommercial Aviation
Max Abreast Wsmallint(6)Maximum number of seats per row in Premium EconomyFleetsCommercial Aviation
Max Abreast Csmallint(6)Maximum number of seats per row in BusinessFleetsCommercial Aviation
Max Abreast Fsmallint(6)Maximum number of seats per row in FirstFleetsCommercial Aviation
Pitch Y (lowest)decimal(5,2)Minimum seat pitch in EconomyFleetsCommercial Aviation
Pitch Y (highest)decimal(5,2)Maximum seat pitch in EconomyFleetsCommercial Aviation
Pitch YP (lowest)decimal(5,2)Minimum seat pitch in Economy Plus/ComfortFleetsCommercial Aviation
Pitch YP (highest)decimal(5,2)Maximum seat pitch in Economy Plus/ComfortFleetsCommercial Aviation
Pitch W (lowest)decimal(5,2)Minimum seat pitch in Premium EconomyFleetsCommercial Aviation
Pitch W (highest)decimal(5,2)Maximum seat pitch in Premium EconomyFleetsCommercial Aviation
Pitch C (lowest)decimal(5,2)Minimum seat pitch in BusinessFleetsCommercial Aviation
Pitch C (highest)decimal(5,2)Maximum seat pitch in BusinessFleetsCommercial Aviation
Pitch F (lowest)decimal(5,2)Minimum seat pitch in FirstFleetsCommercial Aviation
Pitch F (highest)decimal(5,2)Maximum seat pitch in FirstFleetsCommercial Aviation
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 environment
FleetsAll
In-Seat Video Ychar(3)Indication if in-seat video is installed in Economy: yes/no/(blank)FleetsCommercial Aviation
In-Seat Video YPchar(3)Indication if in-seat video is installed in Economy Plus/Comfort: yes/no/(blank)FleetsCommercial Aviation
In-Seat Video Wchar(3)Indication if in-seat video is installed in Premium Economy: yes/no/(blank)FleetsCommercial Aviation
In-Seat Video Cchar(3)Indication if in-seat video is installed in Business: yes/no/(blank)FleetsCommercial Aviation
In-Seat Video Fchar(3)Indication if in-seat video is installed in First: yes/no/(blank)FleetsCommercial Aviation
Inflight Connectivitychar(3)Indication if inflight connectivity is installed on the aircraft: yes/no/(blank)FleetsAll
In-Seat Power Supply Yvarchar(7)Indication if in-seat power supply is installed in Economy: yes/no/(blank)FleetsCommercial Aviation
In-Seat Power Supply YPvarchar(7)Indication if in-seat power supply is installed in Economy Plus/Comfort: yes/no/(blank)FleetsCommercial Aviation
In-Seat Power Supply Wvarchar(7)Indication if in-seat power supply is installed in Premium Economy: yes/no/(blank)FleetsCommercial Aviation
In-Seat Power Supply Cvarchar(7)Indication if in-seat power supply is installed in Business: yes/no/(blank)FleetsCommercial Aviation
In-Seat Power Supply Fvarchar(7)Indication if in-seat power supply is installed in First: yes/no/(blank)FleetsCommercial Aviation
Power Sourcevarchar(255)Source of power for both AC and DC aircraftFleetsCommercial Aviation
USB Port Yvarchar(7)Indication if in-seat USB port is installed in Economy: yes/no/(blank)FleetsCommercial Aviation
USB Port YPvarchar(7)Indication if in-seat USB port is installed in Economy Plus/Comfort: yes/no/(blank)FleetsCommercial Aviation
USB Port Wvarchar(7)Indication if in-seat USB port is installed in Premium Economy: yes/no/(blank)FleetsCommercial Aviation
USB Port Cvarchar(7)Indication if in-seat USB port is installed in Business: yes/no/(blank)FleetsCommercial Aviation
USB Port Fvarchar(7)Indication if in-seat USB port is installed in First: yes/no/(blank)FleetsCommercial Aviation
USB Port Type Yenum('A','A/C','C')Indication if in-seat USB port type is installed in Economy: yes/no/(blank)FleetsCommercial Aviation
USB Port Type YPenum('A','A/C','C')Indication if in-seat USB port type is installed in Economy Plus/Comfort: yes/no/(blank)FleetsCommercial Aviation
USB Port Type Wenum('A','A/C','C')Indication if in-seat USB port type is installed in Premium Economy: yes/no/(blank)FleetsCommercial Aviation
USB Port Type Cenum('A','A/C','C')Indication if in-seat USB port type is installed in Business: yes/no/(blank)FleetsCommercial Aviation
USB Port Type Fenum('A','A/C','C')Indication if in-seat USB port type is installed in First: yes/no/(blank)FleetsCommercial Aviation
Wireless Charging Ytinyint(1)Indication if in-seat wireless charging is installed in Economy: yes/no/(blank)FleetsCommercial Aviation
Wireless Charging YPtinyint(1)Indication if in-seat wireless charging is installed in Economy Plus/Comfort: yes/no/(blank)FleetsCommercial Aviation
Wireless Charging Wtinyint(1)Indication if in-seat wireless charging is installed in Premium Economy: yes/no/(blank)FleetsCommercial Aviation
Wireless Charging Ctinyint(1)Indication if in-seat wireless charging is installed in Business: yes/no/(blank)FleetsCommercial Aviation
Wireless Charging Ftinyint(1)Indication if in-seat wireless charging is installed in First: yes/no/(blank)FleetsCommercial Aviation
Lavatorytinyint(1)Indication if lavatory is available: 1 = yes, 0 = noFleetsBusiness Jets
Lavatory Beltedtinyint(1)Indication if lavatory is belted: 1 = yes, 0 = noFleetsBusiness Jets
Last Year Interior Refurbishmentint(10) unsignedLast year of aircraft interior refurbishmentFleetsBusiness Jets
Last Year Exterior Refurbishmentint(10) unsignedLast year of aircraft exterior refurbishmentFleetsBusiness Jets
Ownervarchar(200)Aircraft legal owner name (i.e. FLY Leasing)OwnershipAll
Owner Ent. ch-a Codevarchar(4)Aircraft legal owner ch-aviation code (assigned by ch-aviation)OwnershipAllForeignEntitiesEntity ch-a Code
Managervarchar(200)Aircraft asset manager name (i.e. BBAM)OwnershipAll
Manager Ent. ch-a Codevarchar(4)Aircraft asset manager ch-aviation code (assigned by ch-aviation)OwnershipAllForeignEntitiesEntity 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)OwnershipAll
Registered Trustvarchar(200)Trust the aircraft is registered to (if appliable)OwnershipAll
SPVvarchar(200)Name of special purpose vehicle company set-up to hold the aircraft assetOwnershipAll
Market Lease Ratedecimal(12,2)Current market lease rate in USD (provided by Collateral Verifications, value assumptions defined here.ValuesCommercial Aviation
Current Market Value (*Million)decimal(5,2)Current market value in USD (provided by Collateral Verifications), value assumptions defined here.ValuesCommercial Aviation
Operating Lease End Datevarchar(10)Operating lease end date (YYYY-MM-DD, YYYY-MM or YYYY)OwnershipCommercial Aviation
Lease End Date Typevarchar(24)Operating lease end type: Confirmed Lease End Date / At least leased until / Estimated Lease End Date / (NULL)OwnershipCommercial Aviation
Projected Retirement Datevarchar(10)Projected retirement date (YYYY-MM-DD, YYYY-MM or YYYY)FleetsAll
Projected Retirement Date Typevarchar(13)Projected retirement date type: confirmed / estimated / minimum_until / (NULL)FleetsAll
Future Operator Date Invarchar(10)Future operator date in date (YYYY-MM-DD, YYYY-MM or YYYY)FleetsAll
Future Operator Date In Typevarchar(9)Future operator date in type: confirmed / estimated / (NULL)FleetsAll
Availabilitychar(3)Aircraft listed as available via MyAirTrade (www.myairtrade.com): yes / noFleetsCommercial Aviation
Avl. Companyvarchar(255)Company listing the aircraft on MyAirTradeFleetsCommercial Aviation
Avl. Database Linkvarchar(255)Link to Availability Contact informationFleetsCommercial Aviation
Lease/ACMI/Salevarchar(255)Aircraft listed as available for Operating Lease (OL), ACMI Lease (A) or Sale (S) on MyAirTradeFleetsCommercial Aviation
Listedvarchar(255)Date the aircraft was initially listed on MyAirTrade (YYMMDD)FleetsCommercial Aviation
Availablevarchar(255)Date the aircraft will be available from (based on MyAirTrade listing) (YYMMDD)FleetsCommercial Aviation
Order Entityvarchar(255)Operator or lessor name of entity that has ordered the aircraftFleetsAll
Order Entity ch-a Codevarchar(4)Operator or lessor entity code (assigned by ch-aviation)FleetsAllForeignEntitiesEntity ch-a Code
Order Datevarchar(10)Order date (YYYY-MM-DD, YYYY-MM or YYYY) where availableFleetsAll
Order Cancellation Datevarchar(10)Order cancellation date (YYYY-MM-DD, YYYY-MM or YYYY) where available, only for not built aircraftFleetsAll
Order Commentaryvarchar(255)Order free text commentary regarding planned delivery dates (where uncertain or unknown)FleetsAll
Hoursdecimal(10,2)Cumulative number of flight hours since entry into serviceFleetsCommercial Aviation
Cyclesint(11)Cumulative number of flight cycles since entry into serviceFleetsCommercial Aviation
Hours TTMdecimal(10,2)Number of flight hours in TTM (trailing twelve months)FleetsCommercial Aviation
Cycles TTMint(11)Number of flight cycles in TTM (trailing twelve months)FleetsCommercial Aviation
As of datevarchar(10)As of date (YYYY-MM-DD) for flight hours/cycles informationFleetsCommercial Aviation
Sourcevarchar(255)Source for flight hours/cycles informationFleetsCommercial Aviation
Avg. Stage Lengthvarchar(5)Average stage length (flight duration) (hh:mm)FleetsCommercial Aviation
Avg. Annual Hoursdecimal(10,2)Average annual flight hours since entry into serviceFleetsCommercial Aviation
Avg. Annual Cyclesdecimal(10,2)Average annual flight cycles since entry into serviceFleetsCommercial Aviation
Avg. Daily Utilisation TTMvarchar(5)Average daily utilisation (in flight hours) in TTM (trailing twelve months) (hh:mm)FleetsCommercial Aviation
Avg. Daily Utilisationvarchar(5)Average daily utilisation (in flight hours) since entry into service (hh:mm)FleetsCommercial Aviation
Last UpdateddateDate the aircraft record has last been updated (YYYY-MM-DD)FleetsAll