Refer to the below for a list of field names and their corresponding description in the Fleet Direct tables
Fleet Direct – Core View
Field Name |
Name in Database |
Type |
Description |
Natural ID | NATURAL_ID | VARCHAR (16777216) | 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) |
Aircraft ID | AIRCRAFT_ID | VARCHAR (16777216) | Unique ch-aviation created aircraft ID, remains stable throughout an aircraft’s life (assigned by ch-aviation) |
Operator Continent | OPERATOR_CONTINENT | VARCHAR (16777216) | Continent the operator is based on |
Operator Country | OPERATOR_COUNTRY | VARCHAR (16777216) | Country the operator is certified in |
Operator Country ISO | OPERATOR_COUNTRY_ISO | VARCHAR (16777216) | ISO 3166-1 Alpha-2 country code |
Operator | OPERATOR | VARCHAR (16777216) | Operator name |
Operator ch-a Code | OPERATOR_CH_A_CODE | VARCHAR (16777216) | Operator ch-aviation code (assigned by ch-aviation) |
Operator Type | OPERATOR_TYPE | VARCHAR (16777216) | Description of operator’s primary business model (Scheduled Carrier, Virtual Carrier, Division, Cargo Carrier, Business/Private Carrier, Government, Manufacturer, Supplier) |
Operator Base | OPERATOR_BASE | VARCHAR (16777216) | Operator main base airport name |
Operator Base Airport ID | OPERATOR_BASE_AIRPORT_ID | VARCHAR (16777216) | Operator main base airport numeric ID |
Operator IATA | OPERATOR_IATA | VARCHAR (16777216) | Operator IATA code (assigned by IATA) |
Operator ICAO | OPERATOR_ICAO | VARCHAR (16777216) | Operator ICAO code (assigned by ICAO) |
Division | DIVISION | VARCHAR (16777216) | Name of division within the operator, if applicable. |
Division ch-a Code | DIVISION_CH_A_CODE | VARCHAR (16777216) | Division ch-aviation code (assigned by ch-aviation), if in the Airline data set. |
Former Operator | FORMER_OPERATOR | VARCHAR (16777216) | Last former operator name |
Former Operator ch-a Code | FORMER_OPERATOR_CH_A_CODE | VARCHAR (16777216) | Last former operator ch-aviation code (assigned by ch-aviation) |
Delivery Customer | DELIVERY_CUSTOMER | VARCHAR (16777216) | Operator the aircraft was originally delivered to |
Delivery Operator ch-a Code | DELIVERY_OPERATOR_CH_A_CODE | VARCHAR (16777216) | Delivery Operator ch-aviation code (assigned by ch-aviation) |
Future Operator | FUTURE_OPERATOR | VARCHAR (16777216) | Next operator name |
Future Operator ch-a Code | FUTURE_OPERATOR_CH_A_CODE | VARCHAR (16777216) | Next operator ch-aviation code (assigned by ch-aviation) |
Cargo Customer | CARGO_CUSTOMER | VARCHAR (16777216) | Cargo customer name |
Cargo Customer ch-a Code | CARGO_CUSTOMER_CH_A_CODE | VARCHAR (16777216) | Cargo customer ch-aviation code (assigned by ch-aviation) |
ACMI Customer | ACMI_CUSTOMER | VARCHAR (16777216) | ACMI/Wet-Lease customer name |
ACMI Customer ch-a Code | ACMI_CUSTOMER_CH_A_CODE | VARCHAR (16777216) | ACMI/Wet-Lease customer ch-aviation code (assigned by ch-aviation) |
ACMI Operator Type | ACMI_OPERATOR_TYPE | VARCHAR (16777216) | ACMI/Wet-Lease customer operator type (refer to Operator Type above) |
Regional Partnership | REGIONAL_PARTNERSHIP | VARCHAR (16777216) | Name of regional partnership brand under which the aircraft is operated |
IOSA Certified | IOSA_CERTIFIED | BOOLEAN | Indication if the operator is IOSA certified: yes/no/(blank) |
Lease Division | LEASE_DIVISION | VARCHAR (16777216) | Name of division within ACMI/Wet-Lease customer, if applicable. |
Remarks | REMARKS | VARCHAR (16777216) | Various free text remarks |
Lease Remarks | LEASE_REMARKS | VARCHAR (16777216) | Various free text remarks for ACMI/Wet-Lease customer |
Aircraft Family | AIRCRAFT_FAMILY | VARCHAR (16777216) | Aircraft Family designation (i.e. A320N) |
Aircraft | AIRCRAFT | VARCHAR (16777216) | Aircraft designation (i.e. A321) |
Aircraft Type | AIRCRAFT_TYPE | VARCHAR (16777216) | Aircraft Type designation (i.e. A321-200) |
Aircraft Model | AIRCRAFT_MODEL | VARCHAR (16777216) | Aircraft Model designation (i.e. A321-271N) |
Aircraft Variant | AIRCRAFT_VARIANT | VARCHAR (16777216) | Aircraft Variant designation (i.e. A321-200N) |
Production Line | PRODUCTION_LINE | VARCHAR (16777216) | Production Line designation (i.e. A320) |
Aircraft Market Group | AIRCRAFT_MARKET_GROUP | VARCHAR (16777216) | Market group (Widebodies, Narrowbodies, Regional Jets, Regional Turboprops, Military Aircraft) |
Aircraft Role | AIRCRAFT_ROLE | VARCHAR (16777216) | Aircraft’s primary role (Passenger, Cargo, Combi, Quick Change, Ambulance, Hospital, Maritime Patrol, Military, Oil Spill Response, Parachuting, Police, Tanker, Testbed, Water Bomber) |
Aircraft IATA | AIRCRAFT_TYPE_IATA | VARCHAR (16777216) | Aircraft three-character IATA code (ch-aviation assigns dummy IATA codes to types for which IATA has not designated a code) |
Aircraft ICAO | AIRCRAFT_TYPE_ICAO | VARCHAR (16777216) | Aircraft four-character ICAO code |
Manufacturer | MANUFACTURER | VARCHAR (16777216) | Aircraft Manufacturer Name |
Manufacturer ch-a Code | MANUFACTURER_CH_A_CODE | VARCHAR (16777216) | Aircraft Manufacturer ch-aviation code (assigned by ch-aviation) |
Registration | AIRCRAFT_REGISTRATION_NUMBER | VARCHAR (16777216) | Aircraft Registration, blank if unknown or no longer registered |
Military Registration | MILITARY_AIRCRAFT_REGISTRATION_NUMBER | VARCHAR (16777216) | Aircraft’s secondary military registration (if dual registered) |
Former Registration | FORMER_AIRCRAFT_REGISTRATION_NUMBER | VARCHAR (16777216) | Former registration |
Former Military Registration | FORMER_MILITARY_AIRCRAFT_REGISTRATION_NUMBER | VARCHAR (16777216) | Aircraft’s former secondary military registration (if previously dual registered) |
Future Registration. | FUTURE_AIRCRAFT_REGISTRATION_NUMBER | VARCHAR (16777216) | Future registration if already known but not yet registered |
Aircraft Register | AIRCRAFT_REGISTER | VARCHAR (16777216) | Aircraft Registration Country |
Aircraft Register ISO | AIRCRAFT_REGISTER_ISO | VARCHAR (16777216) | Aircraft Registration Country ISO 3166-1 Alpha-2 country code |
Construction Line Number | CONSTRUCTION_LINE_NUMBER | VARCHAR (16777216) | Construction/Line Number |
Manufacturer Serial Number (MSN) | MANUFACTURER_SERIAL_NUMBER | VARCHAR (16777216) | Manufacturer Serial Number |
Hexcode | HEXCODE | VARCHAR (16777216) | ICAO 24-bit address/Mode-S hexcode |
Fleet Number | FLEET_NUMBER | VARCHAR (16777216) | Fleet number/Tail number assigned by some operators in addition to formal registration |
Block Number | BLOCK_NUMBER | VARCHAR (16777216) | Block Number (only applicable to Boeing aircraft) |
Status | STATUS | VARCHAR (16777216) | Current Aircraft Status (Active, Testbed/Demo, On repair, Stored, On display, Maintenance, Conversion, Completion, Derelict, Crashed, Beyond repair, Scrapped, Not yet delivered, Not built) |
Location | LOCATION | VARCHAR (16777216) | Location airport name (if the aircraft is inactive) |
Location ID | LOCATION_ID | VARCHAR (16777216) | Location ID (assigned by ch-aviation) (if aircraft is inactive) |
Location Airport Code | LOCATION_AIRPORT_CODE | VARCHAR (16777216) | Location primary airport code (in order of availability: 1) IATA, 2) ICAO, 3) FAA, 4) Alternative code (if aircraft is inactive) |
Location Country | LOCATION_COUNTRY | VARCHAR (16777216) | Location country name (if aircraft is inactive) |
Location Country Code | LOCATION_COUNTRY_CODE | VARCHAR (16777216) | Location ISO 3166-1 Alpha-2 country code (if aircraft is inactive) |
Write off/Scrapping Date | WRITE_OFF_SCRAPPING_DATE | DATE | Date the aircraft was written off or scrapped (YYYY-MM-DD, YYYY-MM or YYYY) |
Roll-Out | ROLL_OUT | DATE | Date the aircraft was rolled out (YYYY-MM-DD, YYYY-MM or YYYY) |
Registration Date | REGISTRATION_DATE | DATE | Date the aircraft was first registered (YYYY-MM-DD, YYYY-MM or YYYY) |
First Flight | FIRST_FLIGHT | DATE | Date the aircraft has first flown (YYYY-MM-DD, YYYY-MM or YYYY) |
Delivery Date | DELIVERY_DATE | DATE | Actual, confirmed or estimated Delivery Date (YYYY-MM-DD, YYYY-MM or YYYY) |
Delivery Date Type | DELIVERY_DATE_TYPE | VARCHAR (16777216) | Type of Delivery Date: actual / confirmed / estimated / (NULL) |
Delivery Year | DELIVERY_YEAR | VARCHAR (16777216) | Delivery Year (YYYY) |
Manufactured Year | MANUFACTURED_YEAR | VARCHAR (16777216) | Manufactured Year (based on the lowest of roll-out, registration, first flight, delivery or first sighting date) (YYYY) |
First Sighting | FIRST_SIGHTING | DATE | Date the aircraft was first seen (if other dates are unknown) (YYYY-MM-DD, YYYY-MM or YYYY) |
Aircraft Age | AIRCRAFT_AGE | FLOAT | Aircraft age (based on the lowest of roll-out, registration, first flight, delivery or first sighting date) |
Date In | DATE_IN | DATE | Date the aircraft was delivered to the current operator |
Stored As Of Date | STORED_AS_OF_DATE | DATE | Date as of which the aircraft has been inactive (YYYY-MM-DD, YYYY-MM or YYYY) |
Engine Manufacturer | ENGINE_MANUFACTURER | VARCHAR (16777216) | Engine manufacturer name |
Engine Manufacturer ch-a Code | ENGINE_MANUFACTURER_CH_A_CODE | VARCHAR (16777216) | Engine manufacturer ch-aviation code (assigned by ch-aviation) |
Engine Family | ENGINE_FAMILY | VARCHAR (16777216) | Engine family (i.e. JT9D) |
Engine Master Series | ENGINE_MASTER_SERIES | VARCHAR (16777216) | Engine master series designation (i.e. JT9D-7R4) |
Engine Type | ENGINE_TYPE | VARCHAR (16777216) | Engine type designation (i.e. PW JT9D) |
Engine Subtype | ENGINE_SUBTYPE | VARCHAR (16777216) | Engine subtype designation (i.e. PW JT9D-7R4H1) |
Number of Engines | NUMBER_OF_ENGINES | NUMBER (38,0) | Number of engines installed on the aircraft |
MTOW (kg) | MTOW_KG | NUMBER (38,0) | Maximum take-off weight in kilograms |
Generic MTOW? | GENERIC_MTOW | VARCHAR (16777216) | Indication whether the maximum take-off weight is generic or verified (yes, no) |
MTOW (lb) | MTOW_LB | NUMBER (38,0) | Maximum take-off weight in pounds |
Seats Y | ECONOMY_CLASS_SEATS | NUMBER (38,0) | Seats in Economy |
Seats YP | ECONOMY_PLUS_CLASS_SEATS | NUMBER (38,0) | 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. |
Seats W | PREMIUM_ECONOMY_CLASS_SEATS | NUMBER (38,0) | 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. |
Seats C | BUSINESS_CLASS_SEATS | NUMBER (38,0) | 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). |
Seats F | FIRST_CLASS_SEATS | NUMBER (38,0) | 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). |
Max Abreast Y | ECONOMY_CLASS_MAX_SEATS_PER_ROW | NUMBER (38,0) | Maximum number of seats per row in Economy |
Max Abreast YP | ECONOMY_PLUS_CLASS_MAX_SEATS_PER_ROW | NUMBER (38,0) | Maximum number of seats per row in Economy Plus/Comfort |
Max Abreast W | PREMIUM_ECONOMY_CLASS_MAX_SEATS_PER_ROW | NUMBER (38,0) | Maximum number of seats per row in Premium Economy |
Max Abreast C | BUSINESS_CLASS_MAX_SEATS_PER_ROW | NUMBER (38,0) | Maximum number of seats per row in Business |
Max Abreast F | FIRST_CLASS_MAX_SEATS_PER_ROW | NUMBER (38,0) | Maximum number of seats per row in First |
Pitch Y (lowest) | ECONOMY_CLASS_SEATS_MIN_PITCH | NUMBER (38,0) | Minimum seat pitch in Economy |
Pitch Y (highest) | ECONOMY_CLASS_SEATS_MAX_PITCH | NUMBER (38,0) | Maximum seat pitch in Economy |
Pitch YP (lowest) | ECONOMY_PLUS_CLASS_SEATS_MIN_PITCH | NUMBER (38,0) | Minimum seat pitch in Economy Plus/Comfort |
Pitch YP (highest) | ECONOMY_PLUS_CLASS_SEATS_MAX_PITCH | NUMBER (38,0) | Maximum seat pitch in Economy Plus/Comfort |
Pitch W (lowest) | PREMIUM_ECONOMY_CLASS_SEATS_MIN_PITCH | NUMBER (38,0) | Minimum seat pitch in Premium Economy |
Pitch W (highest) | PREMIUM_ECONOMY_CLASS_SEATS_MAX_PITCH | NUMBER (38,0) | Maximum seat pitch in Premium Economy |
Pitch C (lowest) | BUSINESS_CLASS_SEATS_MIN_PITCH | NUMBER (38,0) | Minimum seat pitch in Business |
Pitch C (highest) | BUSINESS_CLASS_SEATS_MAX_PITCH | NUMBER (38,0) | Maximum seat pitch in Business |
Pitch F (lowest) | FIRST_CLASS_SEATS_MIN_PITCH | NUMBER (38,0) | Minimum seat pitch in First |
Pitch F (highest) | FIRST_CLASS_SEATS_MAX_PITCH | NUMBER (38,0) | Maximum seat pitch in First |
Seats Comment | SEATS_COMMENT | VARCHAR (16777216) | 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 |
In-Seat Video Y | ECONOMY_CLASS_IN_SEAT_VIDEO | BOOLEAN | Indication if in-seat video is installed in Economy: yes/no/(blank) |
In-Seat Video YP | ECONOMY_PLUS_CLASS_IN_SEAT_VIDEO | BOOLEAN | Indication if in-seat video is installed in Economy Plus/Comfort: yes/no/(blank) |
In-Seat Video W | PREMIUM_ECONOMY_CLASS_IN_SEAT_VIDEO | BOOLEAN | Indication if in-seat video is installed in Premium Economy: yes/no/(blank) |
In-Seat Video C | BUSINESS_CLASS_IN_SEAT_VIDEO | BOOLEAN | Indication if in-seat video is installed in Business: yes/no/(blank) |
In-Seat Video F | FIRST_CLASS_IN_SEAT_VIDEO | BOOLEAN | Indication if in-seat video is installed in First: yes/no/(blank) |
Inflight Connectivity | INFLIGHT_CONNECTIVITY | BOOLEAN | Indication if inflight connectivity is installed on the aircraft: yes/no/(blank) |
Projected Retirement Date | PROJECTED_RETIREMENT_DATE | DATE | Projected retirement date (YYYY-MM-DD, YYYY-MM or YYYY) |
Projected Retirement Date Type | PROJECTED_RETIREMENT_DATE_TYPE | VARCHAR (16777216) | Projected retirement date type: confirmed / estimated / minimum_until / (NULL) |
Future Operator Date In | FUTURE_OPERATOR_DATE_IN | DATE | Future operator date in date (YYYY-MM-DD, YYYY-MM or YYYY) |
Future Operator Date In Type | FUTURE_OPERATOR_DATE_IN_TYPE | VARCHAR (16777216) | Future operator date in type: confirmed / estimated / (NULL) |
Availability | AVAILABILITY | BOOLEAN | Is aircraft listed as available via MyAirTrade (www.myairtrade.com) |
Availability Company | AVAILABILITY_COMPANY | VARCHAR (16777216) | Company listing the aircraft on MyAirTrade |
Database Link | AVAILABILITY_DATABASE_LINK | VARCHAR (16777216) | Not available yet. |
Lease/ACMI/Sale | LEASE_ACMI_SALE | VARCHAR (16777216) | Aircraft listed as available for Operating Lease (OL), ACMI Lease (A) or Sale (S) on MyAirTrade |
Listed | LISTED | VARCHAR (16777216) | Date the aircraft was initially listed on MyAirTrade (YYMMDD) |
Available | AVAILABLE | VARCHAR (16777216) | Date the aircraft will be available from (based on MyAirTrade listing) (YYMMDD) |
Order Entity | ORDER_ENTITY | VARCHAR (16777216) | Operator or lessor name of entity that has ordered the aircraft |
Order Entity ch-a Code | ORDER_ENTITY_CH_A_CODE | VARCHAR (16777216) | Operator or lessor entity code (assigned by ch-aviation) |
Order Date | ORDER_DATE | DATE | Order date (YYYY-MM-DD, YYYY-MM or YYYY) where available |
Order Cancellation Date | ORDER_CANCELLATION_DATE | DATE | Order cancellation date (YYYY-MM-DD, YYYY-MM or YYYY) where available, only for not built aircraft |
Order Commentary | ORDER_COMMENTARY | VARCHAR (16777216) | Order free text commentary regarding planned delivery dates (where uncertain or unknown) |
Hours | FLIGHT_HOURS | FLOAT | Cumulative number of flight hours since entry into service |
Cycles | FLIGHT_CYCLES | NUMBER (38,0) | Cumulative number of flight cycles since entry into service |
Hours TTM | FLIGHT_HOURS_TTM | FLOAT | Number of flight hours in TTM (trailing twelve months) |
Cycles TTM | FLIGHT_CYCLES_TTM | NUMBER (38,0) | Number of flight cycles in TTM (trailing twelve months) |
As of date | AS_OF_DATE | DATE | As of date (YYYY-MM-DD) for flight hours/cycles information |
Source | SOURCE | VARCHAR (16777216) | Source for flight hours/cycles information |
Avg. Stage Length | AVERAGE_STAGE_LENGTH | VARCHAR (16777216) | Average stage length (flight duration) (hh:mm) |
Avg. Annual Hours | AVERAGE_ANNUAL_FLIGHT_HOURS | FLOAT | Average annual flight hours since entry into service |
Avg. Annual Cycles | AVERAGE_ANNUAL_FLIGHT_CYCLES | NUMBER (38,0) | Average annual flight cycles since entry into service |
Avg. Daily Utilisation TTM | AVERAGE_DAILY_UTILISATION_TTM | VARCHAR (16777216) | Average daily utilisation (in flight hours) in TTM (trailing twelve months) (hh:mm) |
Avg. Daily Utilisation | AVERAGE_DAILY_UTILISATION | VARCHAR (16777216) | Average daily utilisation (in flight hours) since entry into service (hh:mm) |
Last Updated | LAST_UPDATED | DATE | Date the aircraft record has last been updated (YYYY-MM-DD) |
Snapshot Date | SNAPSHOT_DATE | DATE | Snapshot date of the file (YYYY-MM-DD) |
Fleet Direct – Ownership (an add-on to Core - cannot be subscribed to on its own)
Field Name |
Name in Database |
Type |
Description |
Owner | OWNER* | VARCHAR (16777216) | Aircraft legal owner name (i.e. FLY Leasing) |
Owner Entity ch-a Code | OWNER_ENTITY_CH_A_CODE* | VARCHAR (16777216) | Aircraft legal owner ch-aviation code (assigned by ch-aviation) |
Manager | MANAGER* | VARCHAR (16777216) | Aircraft asset manager name (i.e. BBAM) |
Manager Entity ch-a Code | MANAGER_ENTITY_CH_A_CODE* | VARCHAR (16777216) | Aircraft asset manager ch-aviation code (assigned by ch-aviation) |
Ownership Type | OWNERSHIP_TYPE* | VARCHAR (16777216) | Aircraft ownership type (Associated company-owner, BizAv-managed, Company-owned, Financial lease, Government, Operating lease, Remarketed, Unknown, Withdrawn from use) |
Registered Trust | REGISTERED_TRUST* | VARCHAR (16777216) | Trust the aircraft is registered to (if appliable) |
Special Purpose Vehicle (SPV) | SPECIAL_PURPOSE_VEHICLE* | VARCHAR (16777216) | Name of special purpose vehicle company set-up to hold the aircraft asset |
Market Lease Rate | MARKET_LEASE_RATE* | VARCHAR (16777216) | Current market lease rate in USD (provided by Collateral Verifications, value assumptions defined here. |
Current Market Value (*Millions) | CURRENT_MARKET_VALUE_MILLION* | FLOAT | Current market value in USD (provided by Collateral Verifications), value assumptions defined here. |
Operating Lease End Date | OPERATING_LEASE_END_DATE* | DATE | Operating lease end date (YYYY-MM-DD, YYYY-MM or YYYY) |
Lease End Date Type | LEASE_END_DATE_TYPE* | VARCHAR (16777216) | Operating lease end type: Confirmed Lease End Date / At least leased until / Estimated Lease End Date / (NULL) |
Fleet Direct – History View (an add-on to Core - cannot be subscribed to on its own)
Natural ID |
NATURAL_ID |
VARCHAR (16777216) |
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) |
Aircraft ID |
AIRCRAFT_ID |
VARCHAR (16777216) |
Unique ch-aviation created aircraft ID, remains stable throughout an aircraft’s life (assigned by ch-aviation) |
Construction Line Number |
CONSTRUCTION_LINE_NUMBER |
VARCHAR (16777216) |
Construction/Line Number |
Manufacturer Serial Number (MSN) |
MANUFACTURER_SERIAL_NUMBER |
VARCHAR (16777216) |
Manufacturer Serial Number |
Production Line |
PRODUCTION_LINE |
VARCHAR (16777216) |
Production Line designation (i.e. A320) |
Aircraft_Family |
AIRCRAFT_FAMILY |
VARCHAR (16777216) |
Aircraft Family designation (i.e. A320N) |
Aircraft |
AIRCRAFT |
VARCHAR (16777216) |
Aircraft designation (i.e. A321) |
Aircraft Type |
AIRCRAFT_TYPE |
VARCHAR (16777216) |
Aircraft Type designation (i.e. A321-200) |
Aircraft Variant |
AIRCRAFT_VARIANT |
VARCHAR (16777216) |
Aircraft Variant designation (i.e. A321-200N) |
Operator |
OPERATOR |
VARCHAR (16777216) |
Operator name |
Operator ch-a Code |
OPERATOR_CH_A_CODE |
VARCHAR (16777216) |
Operator ch-aviation code (assigned by ch-aviation) |
Registration |
AIRCRAFT_REGISTRATION_NUMBER |
VARCHAR (16777216) |
Aircraft Registration, blank if unknown or no longer registered |
Effective From |
EFFECTIVE_FROM |
DATE |
From date with current operator, registration and variant (YYYY-MM-DD, YYYY-MM or YYYY) |
Effective To |
EFFECTIVE_TO |
DATE |
To date with current operator, registration and variant (YYYY-MM-DD, YYYY-MM or YYYY) |
Date In |
DATE_IN |
DATE |
Date the aircraft was delivered to the operator (regardless of other changes such as registration, variant etc.) (YYYY-MM-DD, YYYY-MM or YYYY) |
Date Out |
DATE_OUT |
DATE |
Date the aircraft left the operator (regardless of other changes such as registration, variant etc.) (YYYY-MM-DD, YYYY-MM or YYYY) |
Roll Out |
ROLL_OUT |
DATE |
Date the aircraft was rolled out (YYYY-MM-DD, YYYY-MM or YYYY) |
Registration Date |
REGISTRATION_DATE |
DATE |
Date the aircraft was first registered (YYYY-MM-DD, YYYY-MM or YYYY) |
First Flight |
FIRST_FLIGHT |
DATE |
Date the aircraft has first flown (YYYY-MM-DD, YYYY-MM or YYYY) |
Delivery Date |
DELIVERY_DATE |
DATE |
Actual Delivery Date (YYYY-MM-DD, YYYY-MM or YYYY) |
First Sighting |
FIRST_SIGHTING |
DATE |
Date the aircraft was first seen (if other dates are unknown) (YYYY-MM-DD, YYYY-MM or YYYY) |
End of Life |
END_OF_LIFE |
DATE |
Date the aircraft was written off or scrapped (YYYY-MM-DD, YYYY-MM or YYYY) |
Engine Manufacturer |
ENGINE_MANUFACTURER |
VARCHAR (16777216) |
Engine manufacturer name |
Engine Manufacturer ch-a Code |
ENGINE_MANUFACTURER_CH_A_CODE |
VARCHAR (16777216) |
Engine manufacturer ch-aviation code (assigned by ch-aviation) |
Engine Family |
ENGINE_FAMILY |
VARCHAR (16777216) |
Engine family (i.e. JT9D) |
Engine Master Series |
ENGINE_MASTER_SERIES |
VARCHAR (16777216) |
Engine master series designation (i.e. JT9D-7R4) |
Engine Type |
ENGINE_TYPE |
VARCHAR (16777216) |
Engine type designation (i.e. PW JT9D) |
Engine Subtype |
ENGINE_SUBTYPE |
VARCHAR (16777216) |
Engine subtype designation (i.e. PW JT9D-7R4H1) |
Number of Engines |
NUMBER_OF_ENGINES |
NUMBER (38,0) |
Number of engines installed on the aircraft |