Aircraft
To access the full sample data set on Amazon Web Services manually or programmatically, the S3 bucket URLs are provided here.
To get user name and password for manual access or access key and secret key for programmatic access, contact sales@ch-aviation.com.
| Sample File Name | Sample Description |
|---|---|
| aircraft_with_history_columns_bizjets.csv | Subset for business jets |
| aircraft_with_history_columns_comav.csv | Subset for commercial aviation |
| aircraft_with_history_columns.csv | Sample data for commercial aviation and business jets |
| aircraft_with_history_ownership_columns_bizjets.csv | Subset for business jets |
| aircraft_with_history_ownership_columns_comav.csv | Subset for commercial aviation |
| aircraft_with_history_ownership_columns.csv | Sample data for commercial aviation and business jets |
| aircraft_with_history_ownership_values_columns_comav.csv | Subset for commercial aviation |
| aircraft_with_history_ownership_values_columns.csv | Sample data for commercial aviation and business jets (no values for business jets) |
| aircraft_with_ownership_columns_bizjets.csv | Subset for business jets |
| aircraft_with_ownership_columns_comav.csv | Subset for commercial aviation |
| aircraft_with_ownership_columns.csv | Sample data for commercial aviation and business jets |
| aircraft_with_ownership_values_columns_comav.csv | Subset for commercial aviation |
| aircraft_with_ownership_values_columns.csv | Sample data for commercial aviation and business jets (no values for business jets) |
| aircraft_with_values_columns_comav.csv | Subset for commercial aviation |
| aircraft_with_values_columns.csv | Sample data for commercial aviation and business jets (no values for business jets) |
| aircraft_without_optional_columns_bizjets.csv | Subset for business jets |
| aircraft_without_optional_columns_comav.csv | Subset for commercial aviation |
| aircraft_without_optional_columns.csv | Sample data for commercial aviation and business jets |
| Column | Data Type | Data description | Package required | Segments supported | 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 | All | |||
| Aircraft ID | int(11) | Unique ch-aviation created aircraft ID, remains stable throughout an aircraft's life (assigned by ch-aviation) | Fleets | All | Primary | ||
| Operator Continent | varchar(255) | Continent the operator is based on | Fleets | All | |||
| Operator Country | varchar(255) | Country the operator is certified in | Fleets | All | |||
| Operator Country ISO | char(2) | ISO 3166-1 Alpha-2 country code | Fleets | All | Foreign | Countries | Country ISO |
| Operator | varchar(255) | Operator name (if Operator is "Multiple Operators", the aircraft's multiple operators can be found in the Aircraft Multiple Operators table) | Fleets | All | |||
| 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. (if Opr. ch-a Code is MLT, the aircraft's multiple operators can be found in the Aircraft Multiple Operators table) | Fleets | All | 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 | All | |||
| Operator Base | varchar(255) | Operator main base airport name | Fleets | All | |||
| Opr. Base Airport ID | int(11) | Operator main base airport numeric ID | Fleets | All | Foreign | Airports | Airport ID |
| Operator IATA | char(2) | Operator IATA code (assigned by IATA) | Fleets | All | |||
| Operator ICAO | char(3) | Fleets | All | ||||
| Division | varchar(96) | Name of division within the operator, if applicable. | Fleets | All | |||
| 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 | All | Foreign | Airlines | Airline ch-a Code |
| Former Operator | varchar(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) | History | All | |||
| 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. (if Former Opr. ch-a Code is MLT, the aircraft's multiple operators can be found in the Aircraft Histories Multiple Operators table) | History | All | Foreign | Airlines | Airline ch-a Code |
| Delivery Customer | varchar(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) | History | All | |||
| Delivery Opr. ch-a Code | varchar(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) | History | All | Foreign | Airlines | Airline ch-a Code |
| Future Operator | varchar(255) | Next operator name | Fleets | All | |||
| Future Opr. ch-a Code | varchar(5) | Next operator ch-aviation code (assigned by ch-aviation). Future Operator ch-aviation codes can be 2, 3, or 5 characters. | Fleets | All | Foreign | Airlines | Airline ch-a Code |
| Cargo Customer | varchar(255) | Cargo customer name | Fleets | All | |||
| Cargo Cust. ch-a Code | char(4) | Cargo customer ch-aviation code (assigned by ch-aviation). | Fleets | All | Foreign | Entities | Entity ch-a Code |
| ACMI Customer | varchar(255) | ACMI/Wet-Lease customer name | Fleets | Commercial Aviation | |||
| ACMI Cust. ch-a Code | varchar(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 | Commercial Aviation | Foreign | Airlines | Airline ch-a Code |
| ACMI Operator Type | varchar(255) | ACMI/Wet-Lease customer operator type (refer to Operator Type above) | Fleets | Commercial Aviation | |||
| Regional Partnership | varchar(48) | Name of regional partnership brand under which the aircraft is operated | Fleets | Commercial Aviation | Foreign | Regional Partnerships | Rel Subsidiary |
| IOSA Certified | char(3) | Indication if the operator is IOSA certified: yes/no/(blank) | Fleets | Commercial Aviation | |||
| Lease Division | varchar(96) | Name of division within ACMI/Wet-Lease customer, if applicable. | Fleets | All | |||
| Remarks | varchar(255) | Various free text remarks | Fleets | All | |||
| Lease Remarks | varchar(255) | Various free text remarks for ACMI/Wet-Lease customer | Fleets | All | |||
| Aircraft Family | varchar(255) | Aircraft Family designation (i.e. A320N) | Fleets | All | |||
| Aircraft | varchar(16) | Aircraft designation (i.e. A321) | Fleets | All | |||
| Aircraft Type | varchar(65) | Aircraft Type designation (i.e. A321-200) | Fleets | All | |||
| Aircraft Model | varchar(32) | Aircraft Model designation (i.e. A321-271N) | Fleets | All | |||
| Aircraft Variant | varchar(255) | Aircraft Variant designation (i.e. A321-200N) | Fleets | All | |||
| Production Line | varchar(9) | Production Line designation (i.e. A320) | Fleets | All | |||
| Aircraft Market Group | varchar(255) | Market group (Widebodies, Narrowbodies, Regional Jets, Regional Turboprops, Military Aircraft) | Fleets | All | |||
| 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 | All | |||
| 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 | All | Foreign | Aircraft Codes/Aircraft Data | IATA |
| Aircraft ICAO | varchar(4) | Aircraft four-character ICAO code | Fleets | All | |||
| Operator Aircraft Certification | varchar(255) | Aircraft certification description | Fleets | Business Jets | |||
| Manufacturer | varchar(255) | Aircraft Manufacturer Name | Fleets | All | |||
| Manufacturer ch-a Code | varchar(3) | Aircraft Manufacturer ch-aviation code (assigned by ch-aviation) | Fleets | All | Foreign | Airlines | Airline ch-a Code |
| Registration | varchar(16) | Aircraft Registration, blank if unknown or no longer registered | Fleets | All | |||
| Mil. Registration | varchar(16) | Aircraft's secondary military registration (if dual registered) | Fleets | All | |||
| Former Registration | varchar(16) | Former registration | History | All | |||
| Former Mil. Registration | varchar(16) | Aircraft's former secondary military registration (if previously dual registered) | History | All | |||
| Future Reg. | varchar(16) | Future registration if already known but not yet registered | Fleets | All | |||
| Aircraft Register | varchar(255) | Aircraft Registration Country | Fleets | All | |||
| Aircraft Register ISO | char(2) | Aircraft Registration Country ISO 3166-1 Alpha-2 country code | Fleets | All | Foreign | Countries | Country ISO |
| Aircraft Base | varchar(255) | Aircraft base airport name | Fleets | Business Jets | |||
| Aircraft Base ID | int(11) | Operator main base airport numeric ID | Fleets | Business Jets | Foreign | Airports | Airport ID |
| Aircraft Base ch-a Code | varchar(6) | ch-aviation main airport code (if available IATA, otherwise ICAO, otherwise FAA/Other code) for aircraft base | Fleets | Business Jets | |||
| Aircraft Base Subdivision | varchar(255) | Aircraft base state/subdivision name | Fleets | Business Jets | |||
| Aircraft Base Subdivision ch-a Code | char(2) | Aircraft base state/subdivision ISO 3166-2 Alpha-2 subdivision code | Fleets | Business Jets | |||
| Aircraft Base Metro Group | varchar(255) | Aircraft base metro group description | Fleets | Business Jets | |||
| Aircraft Base Metro Group IATA | char(3) | Aircraft base metro group IATA code | Fleets | Business Jets | |||
| Aircraft Base Country | varchar(255) | Aircraft base country name | Fleets | Business Jets | |||
| Aircraft Base Country ISO | char(2) | Aircraft Base ISO 3166-1 Alpha-2 country code | Fleets | Business Jets | |||
| Aircraft Base Continent | varchar(255) | Aircraft base continent name | Fleets | Business Jets | |||
| C/N | varchar(16) | Construction/Line Number | Fleets | All | |||
| MSN | varchar(16) | Manufacturer Serial Number | Fleets | All | |||
| Hexcode | char(6) | ICAO 24-bit address/Mode-S hexcode | Fleets | All | |||
| Fleet Number | varchar(16) | Fleet number/Tail number assigned by some operators in addition to formal registration | Fleets | All | |||
| Block Number | varchar(5) | Block Number (only applicable to Boeing aircraft) | Fleets | All | |||
| 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 | All | |||
| Location | varchar(255) | Location airport name (if the aircraft is inactive) | Fleets | All | |||
| Location ID | int(11) | Location ID (assigned by ch-aviation) (if aircraft is inactive) | Fleets | All | 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 | All | |||
| Location Country | varchar(255) | Location country name (if aircraft is inactive) | Fleets | All | |||
| Location Country Code | char(2) | Location ISO 3166-1 Alpha-2 country code (if aircraft is inactive) | Fleets | All | Foreign | Countries | Country ISO |
| Construction Site | varchar(255) | Construction site airport name | Fleets | All | |||
| 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 | All | Foreign | Airports | Main code |
| Construction Site Country | varchar(255) | Construction site country name (if aircraft is inactive) | Fleets | All | |||
| Construction Site Country ISO Code | char(2) | Construction site Country ISO 3166-1 Alpha-2 country code | Fleets | All | Foreign | Countries | Country ISO |
| Construction Site Continent | varchar(255) | Continent of the onstruction site | Fleets | All | |||
| Write off/Scrapping Date | varchar(10) | Date the aircraft was written off or scrapped (YYYY-MM-DD, YYYY-MM or YYYY) | History | All | |||
| Roll-Out | varchar(10) | Date the aircraft was rolled out (YYYY-MM-DD, YYYY-MM or YYYY) | Fleets | All | |||
| Registration Date | varchar(10) | Date the aircraft was first registered (YYYY-MM-DD, YYYY-MM or YYYY) | Fleets | All | |||
| First Flight | varchar(10) | Date the aircraft has first flown (YYYY-MM-DD, YYYY-MM or YYYY) | Fleets | All | |||
| Delivery Date | varchar(10) | Actual, confirmed or estimated Delivery Date (YYYY-MM-DD, YYYY-MM or YYYY) | Fleets | All | |||
| Delivery Date Type | varchar(9) | Type of Delivery Date: actual / confirmed / estimated / (NULL) | Fleets | All | |||
| Delivery Year | int(4) | Delivery Year (YYYY) | Fleets | All | |||
| Manufactured Year | year(4) | Manufactured Year (based on the lowest of roll-out, registration, first flight, delivery or first sighting date) (YYYY) | Fleets | All | |||
| First Sighting | varchar(10) | Date the aircraft was first seen (if other dates are unknown) (YYYY-MM-DD, YYYY-MM or YYYY) | Fleets | All | |||
| Age (a) | decimal(4,1) | Aircraft age (based on the lowest of roll-out, registration, first flight, delivery or first sighting date) | Fleets | All | |||
| Date In | varchar(10) | Date the aircraft was delivered to the current operator | History | All | |||
| Stored As Of Date | varchar(10) | Date as of which the aircraft has been inactive (YYYY-MM-DD, YYYY-MM or YYYY) | History | All | |||
| Engine Manufacturer | varchar(255) | Engine manufacturer name | Fleets | All | |||
| Engine Manufacturer ch-a Code | varchar(4) | Engine manufacturer ch-aviation code (assigned by ch-aviation) | Fleets | All | Foreign | Entities | Entity ch-a Code |
| Engine Family | varchar(16) | Engine family (i.e. JT9D) | Fleets | All | |||
| Engine Master Series | varchar(32) | Engine master series designation (i.e. JT9D-7R4) | Fleets | All | |||
| Engine Type | varchar(16) | Engine type designation (i.e. PW JT9D) | Fleets | All | |||
| Engine Subtype | varchar(32) | Engine subtype designation (i.e. PW JT9D-7R4H1) | Fleets | All | |||
| Number of Engines | int(11) | Number of engines installed on the aircraft | Fleets | All | |||
| ICAO Engine Emission Databank ID | varchar(32) | Common unique identifier of ICAO Engine Emissions Databank | Fleets | All | |||
| MTOW (kg) | int(11) | Maximum take-off weight in kilogrammes | Fleets | All | |||
| Generic MTOW | varchar(8) | Indication whether the maximum take-off weight is generic or verified (yes, no) | Fleets | All | |||
| MTOW (lb) | decimal(11,2) | Maximum take-off weight in pounds | Fleets | All | |||
| Cargo Loading Type | varchar(255) | Type of loading the cargo into specially defined sections of an aircraft | Fleets | All | |||
| Seats Y | smallint(6) | Seats in Economy | Fleets | Commercial Aviation | |||
| 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 | Commercial Aviation | |||
| 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 | Commercial Aviation | |||
| 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 | Commercial Aviation | |||
| 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 | Commercial Aviation | |||
| Seats Total | smallint(6) | Total number of seats | Fleets | All | |||
| Max Abreast Y | smallint(6) | Maximum number of seats per row in Economy | Fleets | Commercial Aviation | |||
| Max Abreast YP | smallint(6) | Maximum number of seats per row in Economy Plus/Comfort | Fleets | Commercial Aviation | |||
| Max Abreast W | smallint(6) | Maximum number of seats per row in Premium Economy | Fleets | Commercial Aviation | |||
| Max Abreast C | smallint(6) | Maximum number of seats per row in Business | Fleets | Commercial Aviation | |||
| Max Abreast F | smallint(6) | Maximum number of seats per row in First | Fleets | Commercial Aviation | |||
| Pitch Y (lowest) | decimal(5,2) | Minimum seat pitch in Economy | Fleets | Commercial Aviation | |||
| Pitch Y (highest) | decimal(5,2) | Maximum seat pitch in Economy | Fleets | Commercial Aviation | |||
| Pitch YP (lowest) | decimal(5,2) | Minimum seat pitch in Economy Plus/Comfort | Fleets | Commercial Aviation | |||
| Pitch YP (highest) | decimal(5,2) | Maximum seat pitch in Economy Plus/Comfort | Fleets | Commercial Aviation | |||
| Pitch W (lowest) | decimal(5,2) | Minimum seat pitch in Premium Economy | Fleets | Commercial Aviation | |||
| Pitch W (highest) | decimal(5,2) | Maximum seat pitch in Premium Economy | Fleets | Commercial Aviation | |||
| Pitch C (lowest) | decimal(5,2) | Minimum seat pitch in Business | Fleets | Commercial Aviation | |||
| Pitch C (highest) | decimal(5,2) | Maximum seat pitch in Business | Fleets | Commercial Aviation | |||
| Pitch F (lowest) | decimal(5,2) | Minimum seat pitch in First | Fleets | Commercial Aviation | |||
| Pitch F (highest) | decimal(5,2) | Maximum seat pitch in First | Fleets | Commercial Aviation | |||
| 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 | All | |||
| In-Seat Video Y | char(3) | Indication if in-seat video is installed in Economy: yes/no/(blank) | Fleets | Commercial Aviation | |||
| In-Seat Video YP | char(3) | Indication if in-seat video is installed in Economy Plus/Comfort: yes/no/(blank) | Fleets | Commercial Aviation | |||
| In-Seat Video W | char(3) | Indication if in-seat video is installed in Premium Economy: yes/no/(blank) | Fleets | Commercial Aviation | |||
| In-Seat Video C | char(3) | Indication if in-seat video is installed in Business: yes/no/(blank) | Fleets | Commercial Aviation | |||
| In-Seat Video F | char(3) | Indication if in-seat video is installed in First: yes/no/(blank) | Fleets | Commercial Aviation | |||
| Inflight Connectivity | char(3) | Indication if inflight connectivity is installed on the aircraft: yes/no/(blank) | Fleets | All | |||
| In-Seat Power Supply Y | varchar(7) | Indication if in-seat power supply is installed in Economy: yes/no/(blank) | Fleets | Commercial Aviation | |||
| In-Seat Power Supply YP | varchar(7) | Indication if in-seat power supply is installed in Economy Plus/Comfort: yes/no/(blank) | Fleets | Commercial Aviation | |||
| In-Seat Power Supply W | varchar(7) | Indication if in-seat power supply is installed in Premium Economy: yes/no/(blank) | Fleets | Commercial Aviation | |||
| In-Seat Power Supply C | varchar(7) | Indication if in-seat power supply is installed in Business: yes/no/(blank) | Fleets | Commercial Aviation | |||
| In-Seat Power Supply F | varchar(7) | Indication if in-seat power supply is installed in First: yes/no/(blank) | Fleets | Commercial Aviation | |||
| Power Source | varchar(255) | Source of power for both AC and DC aircraft | Fleets | Commercial Aviation | |||
| USB Port Y | varchar(7) | Indication if in-seat USB port is installed in Economy: yes/no/(blank) | Fleets | Commercial Aviation | |||
| USB Port YP | varchar(7) | Indication if in-seat USB port is installed in Economy Plus/Comfort: yes/no/(blank) | Fleets | Commercial Aviation | |||
| USB Port W | varchar(7) | Indication if in-seat USB port is installed in Premium Economy: yes/no/(blank) | Fleets | Commercial Aviation | |||
| USB Port C | varchar(7) | Indication if in-seat USB port is installed in Business: yes/no/(blank) | Fleets | Commercial Aviation | |||
| USB Port F | varchar(7) | Indication if in-seat USB port is installed in First: yes/no/(blank) | Fleets | Commercial Aviation | |||
| USB Port Type Y | enum('A','A/C','C') | Indication if in-seat USB port type is installed in Economy: yes/no/(blank) | Fleets | Commercial Aviation | |||
| 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 | Commercial Aviation | |||
| 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 | Commercial Aviation | |||
| USB Port Type C | enum('A','A/C','C') | Indication if in-seat USB port type is installed in Business: yes/no/(blank) | Fleets | Commercial Aviation | |||
| USB Port Type F | enum('A','A/C','C') | Indication if in-seat USB port type is installed in First: yes/no/(blank) | Fleets | Commercial Aviation | |||
| Wireless Charging Y | tinyint(1) | Indication if in-seat wireless charging is installed in Economy: yes/no/(blank) | Fleets | Commercial Aviation | |||
| Wireless Charging YP | tinyint(1) | Indication if in-seat wireless charging is installed in Economy Plus/Comfort: yes/no/(blank) | Fleets | Commercial Aviation | |||
| Wireless Charging W | tinyint(1) | Indication if in-seat wireless charging is installed in Premium Economy: yes/no/(blank) | Fleets | Commercial Aviation | |||
| Wireless Charging C | tinyint(1) | Indication if in-seat wireless charging is installed in Business: yes/no/(blank) | Fleets | Commercial Aviation | |||
| Wireless Charging F | tinyint(1) | Indication if in-seat wireless charging is installed in First: yes/no/(blank) | Fleets | Commercial Aviation | |||
| Lavatory | tinyint(1) | Indication if lavatory is available: 1 = yes, 0 = no | Fleets | Business Jets | |||
| Lavatory Belted | tinyint(1) | Indication if lavatory is belted: 1 = yes, 0 = no | Fleets | Business Jets | |||
| Last Year Interior Refurbishment | int(10) unsigned | Last year of aircraft interior refurbishment | Fleets | Business Jets | |||
| Last Year Exterior Refurbishment | int(10) unsigned | Last year of aircraft exterior refurbishment | Fleets | Business Jets | |||
| Owner | varchar(200) | Aircraft legal owner name (i.e. FLY Leasing) | Ownership | All | |||
| Owner Ent. ch-a Code | varchar(4) | Aircraft legal owner ch-aviation code (assigned by ch-aviation) | Ownership | All | Foreign | Entities | Entity ch-a Code |
| Manager | varchar(200) | Aircraft asset manager name (i.e. BBAM) | Ownership | All | |||
| Manager Ent. ch-a Code | varchar(4) | Aircraft asset manager ch-aviation code (assigned by ch-aviation) | Ownership | All | 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 | All | |||
| Registered Trust | varchar(200) | Trust the aircraft is registered to (if appliable) | Ownership | All | |||
| SPV | varchar(200) | Name of special purpose vehicle company set-up to hold the aircraft asset | Ownership | All | |||
| Market Lease Rate | decimal(12,2) | Current market lease rate in USD (provided by Collateral Verifications, value assumptions defined here. | Values | Commercial Aviation | |||
| Current Market Value (*Million) | decimal(5,2) | Current market value in USD (provided by Collateral Verifications), value assumptions defined here. | Values | Commercial Aviation | |||
| Operating Lease End Date | varchar(10) | Operating lease end date (YYYY-MM-DD, YYYY-MM or YYYY) | Ownership | Commercial Aviation | |||
| Lease End Date Type | varchar(24) | Operating lease end type: Confirmed Lease End Date / At least leased until / Estimated Lease End Date / (NULL) | Ownership | Commercial Aviation | |||
| Projected Retirement Date | varchar(10) | Projected retirement date (YYYY-MM-DD, YYYY-MM or YYYY) | Fleets | All | |||
| Projected Retirement Date Type | varchar(13) | Projected retirement date type: confirmed / estimated / minimum_until / (NULL) | Fleets | All | |||
| Future Operator Date In | varchar(10) | Future operator date in date (YYYY-MM-DD, YYYY-MM or YYYY) | Fleets | All | |||
| Future Operator Date In Type | varchar(9) | Future operator date in type: confirmed / estimated / (NULL) | Fleets | All | |||
| Availability | char(3) | Aircraft listed as available via MyAirTrade (www.myairtrade.com): yes / no | Fleets | Commercial Aviation | |||
| Avl. Company | varchar(255) | Company listing the aircraft on MyAirTrade | Fleets | Commercial Aviation | |||
| Avl. Database Link | varchar(255) | Link to Availability Contact information | Fleets | Commercial Aviation | |||
| Lease/ACMI/Sale | varchar(255) | Aircraft listed as available for Operating Lease (OL), ACMI Lease (A) or Sale (S) on MyAirTrade | Fleets | Commercial Aviation | |||
| Listed | varchar(255) | Date the aircraft was initially listed on MyAirTrade (YYMMDD) | Fleets | Commercial Aviation | |||
| Available | varchar(255) | Date the aircraft will be available from (based on MyAirTrade listing) (YYMMDD) | Fleets | Commercial Aviation | |||
| Order Entity | varchar(255) | Operator or lessor name of entity that has ordered the aircraft | Fleets | All | |||
| Order Entity ch-a Code | varchar(4) | Operator or lessor entity code (assigned by ch-aviation) | Fleets | All | Foreign | Entities | Entity ch-a Code |
| Order Date | varchar(10) | Order date (YYYY-MM-DD, YYYY-MM or YYYY) where available | Fleets | All | |||
| Order Cancellation Date | varchar(10) | Order cancellation date (YYYY-MM-DD, YYYY-MM or YYYY) where available, only for not built aircraft | Fleets | All | |||
| Order Commentary | varchar(255) | Order free text commentary regarding planned delivery dates (where uncertain or unknown) | Fleets | All | |||
| Hours | decimal(10,2) | Cumulative number of flight hours since entry into service | Fleets | Commercial Aviation | |||
| Cycles | int(11) | Cumulative number of flight cycles since entry into service | Fleets | Commercial Aviation | |||
| Hours TTM | decimal(10,2) | Number of flight hours in TTM (trailing twelve months) | Fleets | Commercial Aviation | |||
| Cycles TTM | int(11) | Number of flight cycles in TTM (trailing twelve months) | Fleets | Commercial Aviation | |||
| As of date | varchar(10) | As of date (YYYY-MM-DD) for flight hours/cycles information | Fleets | Commercial Aviation | |||
| Source | varchar(255) | Source for flight hours/cycles information | Fleets | Commercial Aviation | |||
| Avg. Stage Length | varchar(5) | Average stage length (flight duration) (hh:mm) | Fleets | Commercial Aviation | |||
| Avg. Annual Hours | decimal(10,2) | Average annual flight hours since entry into service | Fleets | Commercial Aviation | |||
| Avg. Annual Cycles | decimal(10,2) | Average annual flight cycles since entry into service | Fleets | Commercial Aviation | |||
| Avg. Daily Utilisation TTM | varchar(5) | Average daily utilisation (in flight hours) in TTM (trailing twelve months) (hh:mm) | Fleets | Commercial Aviation | |||
| Avg. Daily Utilisation | varchar(5) | Average daily utilisation (in flight hours) since entry into service (hh:mm) | Fleets | Commercial Aviation | |||
| Last Updated | date | Date the aircraft record has last been updated (YYYY-MM-DD) | Fleets | All |