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(5) | Operator ch-aviation code (assigned by ch-aviation). Operator ch-aviation codes can be 2, 3, or 5 characters. | 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(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. | Fleets | Foreign | Airlines | Airline ch-a Code |
Former Operator | varchar(64) | Last former operator name | History | | | |
Former Opr. ch-a Code | varchar(5) | Last former operator ch-aviation code (assigned by ch-aviation). Former operator ch-aviation codes can be 2, 3, or 5 characters. | 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(5) | Delivery Operator ch-aviation code (assigned by ch-aviation). Delivery Operator ch-aviation codes can be 2, 3, or 5 characters. | History | Foreign | Airlines | Airline ch-a Code |
Future Operator | varchar(255) | Next operator name | Fleets | | | |
Future Opr. ch-a Code | char(5) | Next operator ch-aviation code (assigned by ch-aviation). Future Operator ch-aviation codes can be 2, 3, or 5 characters. | 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(5) | ACMI/Wet-Lease customer ch-aviation code (assigned by ch-aviation). ACMI Customer ch-aviation codes can be 2, 3, or 5 characters. | 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 | | | |