| 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, Passenger-Freighter, Cargo, Combi, Quick Change, Ambulance, Hospital, Maritime Patrol, Military, Oil Spill Response, Parachuting, Police, Tanker, Testbed, Water Bomber, VIP) | 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 |
| Construction Site | varchar(255) | Construction site airport name | Fleets | | | |
| Construction Site ch-a Code | varchar(6) | Construction site airport code (in order of availability: 1) IATA, 2) ICAO, 3) FAA, 4) Alternative code | Fleets | Foreign | Airports | Main code |
| Construction Site Country | varchar(255) | Construction site country name (if aircraft is inactive) | Fleets | | | |
| Construction Site Country ISO Code | char(2) | Construction site Country ISO 3166-1 Alpha-2 country code | Fleets | Foreign | Countries | Country ISO |
| Construction Site Continent | varchar(255) | Continent of the onstruction site | Fleets | | | |
| 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 | | | |
| ICAO Engine Emission Databank ID | varchar(32) | Common unique identifier of ICAO Engine Emissions Databank | 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 | | | |
| Cargo Loading Type | varchar(255) | Type of loading the cargo into specially defined sections of an aircraft | | | | |
| 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 | | | |
| In-Seat Power Supply Y | varchar(7) | Indication if in-seat power supply is installed in Economy: yes/no/(blank) | Fleets | | | |
| In-Seat Power Supply YP | varchar(7) | Indication if in-seat power supply is installed in Economy Plus/Comfort: yes/no/(blank) | Fleets | | | |
| In-Seat Power Supply W | varchar(7) | Indication if in-seat power supply is installed in Premium Economy: yes/no/(blank) | Fleets | | | |
| In-Seat Power Supply C | varchar(7) | Indication if in-seat power supply is installed in Business: yes/no/(blank) | Fleets | | | |
| In-Seat Power Supply F | varchar(7) | Indication if in-seat power supply is installed in First: yes/no/(blank) | Fleets | | | |
| Power Source | varchar(255) | Source of power for both AC and DC aircraft | Fleets | | | |
| USB Port Y | varchar(7) | Indication if in-seat USB port is installed in Economy: yes/no/(blank) | Fleets | | | |
| USB Port YP | varchar(7) | Indication if in-seat USB port is installed in Economy Plus/Comfort: yes/no/(blank) | Fleets | | | |
| USB Port W | varchar(7) | Indication if in-seat USB port is installed in Premium Economy: yes/no/(blank) | Fleets | | | |
| USB Port C | varchar(7) | Indication if in-seat USB port is installed in Business: yes/no/(blank) | Fleets | | | |
| USB Port F | varchar(7) | Indication if in-seat USB port is installed in First: yes/no/(blank) | Fleets | | | |
| USB Port Type Y | enum('A','A/C','C') | Indication if in-seat USB port type is installed in Economy: yes/no/(blank) | Fleets | | | |
| USB Port Type YP | enum('A','A/C','C') | Indication if in-seat USB port type is installed in Economy Plus/Comfort: yes/no/(blank) | Fleets | | | |
| USB Port Type W | enum('A','A/C','C') | Indication if in-seat USB port type is installed in Premium Economy: yes/no/(blank) | Fleets | | | |
| USB Port Type C | enum('A','A/C','C') | Indication if in-seat USB port type is installed in Business: yes/no/(blank) | Fleets | | | |
| USB Port Type F | enum('A','A/C','C') | Indication if in-seat USB port type is installed in First: yes/no/(blank) | Fleets | | | |
| Wireless Charging Y | tinyint(1) | Indication if in-seat wireless charging is installed in Economy: yes/no/(blank) | Fleets | | | |
| Wireless Charging YP | tinyint(1) | Indication if in-seat wireless charging is installed in Economy Plus/Comfort: yes/no/(blank) | Fleets | | | |
| Wireless Charging W | tinyint(1) | Indication if in-seat wireless charging is installed in Premium Economy: yes/no/(blank) | Fleets | | | |
| Wireless Charging C | tinyint(1) | Indication if in-seat wireless charging is installed in Business: yes/no/(blank) | Fleets | | | |
| Wireless Charging F | tinyint(1) | Indication if in-seat wireless charging is installed in First: 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. Database Link | varchar(255) | Link to Availability Contact information | 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 | | | |
