Aircraft Owners

ColumnData TypeData descriptionPackage requiredKeyData SetJoin On
Entity Namevarchar(255)Entity nameEntities
Entity ch-a Codevarchar(4)Entity ch-aviation code (assigned by ch-aviation)EntitiesPrimary
Legal Namevarchar(255)Entity legal nameEntities
Locationvarchar(255)Location airport name (closest airport if not based at airport itself)Entities
Location IDint(11)Location ID (assigned by ch-aviation)EntitiesForeignAirportsAirport ID
Continentvarchar(255)Continent nameEntities
State Namevarchar(255)State descriptionEntities
State Codechar(2)ISO 3166-2 Alpha-2 subdivision code (used for states)EntitiesForeignStatesState ISO
Countryvarchar(255)Country nameEntities
Country ISOchar(2)ISO 3166-1 Alpha-2 country codeEntitiesForeignCountriesCountry ISO
Country_IASA_Statuschar(1)Country International Aviation Safety Assessment program status (assigned by FAA): 0 – not assessed / 1 – Category 1 (meets ICAO standards) / 2 – Category 2 (does not meet ICAO standards)Entities
Typevarchar(255)Entity typeEntities
Type Codechar(1)Entity type code (E: Engine Manufacturer, I: IT Provider, L: Lessor, X: Cargo Customer/Forwarder)Entities
Statusvarchar(255)Entity statusEntities
Entity Infovarchar(255)Free text remarks (where applicable)Entities
Merged intovarchar(255)Entity this particular entity has been merged into or rebranded to.Entities
Merged into ch-a Codevarchar(4)ch-aviation code for the successor entity as a result of a merger or rebrandingEntitiesForeignEntitiesEntity ch-a Code
Stock Tickervarchar(255)Stock market tickerEntities
Launch Yearint(4)Entity launch yearEntities
Termination Yearint(4)Entity termination yearEntities
Total Seats in Fleetdecimal(10,0)Number of total seats of all aircraft owned by the entityFleets
Number of Aircraftbigint(20)Number of aircraft owned by the entityFleets
Aircraft on Orderdecimal(10,0)Number of aircraft on order by the entityFleets
Number of Enginesdecimal(10,0)Number of engines fitted to aircraft owned by the entityFleets