Airframe MRO Name | varchar(255) | Name of the MRO provider | Commercial Aviation Airframe MRO Data | | | |
Airframe MRO ch-a Code | varchar(5) | MRO provider ch-aviation code (2-5 characters) | Commercial Aviation Airframe MRO Data | Foreign | Entities | Entity ch-a Code |
Legal Name | varchar(255) | MRO Provider legal name | Commercial Aviation Airframe MRO Data | | | |
Base Location | varchar(255) | Airport Display Name (combination of City Name and Airport Name) | Commercial Aviation Airframe MRO Data | | | |
Base Location ch-a Code | varchar(6) | Airport ch-aviation code (not a stable ID, IATA code if available, otherwise ICAO, otherwise alternative code) | Commercial Aviation Airframe MRO Data | Foreign | Airports | Airport ch-a Code |
Base Location IATA | char(3) | Airport three character IATA code | Commercial Aviation Airframe MRO Data | | | |
Base Location ICAO | char(4) | Airport four character ICAO code | Commercial Aviation Airframe MRO Data | | | |
Base Continent | varchar(255) | Continent name | Commercial Aviation Airframe MRO Data | | | |
Base Subdivision | varchar(255) | State name | Commercial Aviation Airframe MRO Data | | | |
Base Subdivision ch-a Code | varchar(255) | ISO 3166-2 Alpha-2 subdivision code (used for states) | Commercial Aviation Airframe MRO Data | Foreign | States | State ISO |
Base Metro Group | varchar(255) | Metro Group name | Commercial Aviation Airframe MRO Data | | | |
Base Metro Group IATA | char(3) | Metro Group three character IATA code | Commercial Aviation Airframe MRO Data | Foreign | Metro Groups | Metro_Group |
Base Country | varchar(255) | Country name | Commercial Aviation Airframe MRO Data | | | |
Base Country ISO | char(2) | ISO 3166-1 Alpha-2 country code | Commercial Aviation Airframe MRO Data | Foreign | Countries | Country ISO |
Maintenance Type | varchar(255) | Type of the MRO event (Base, Completion, Conversion, Delivery, Induction, Lease Return, Line + A, Modifications, Paint, Part-Out, Production, Repairs, Storage, Transition) | Commercial Aviation Airframe MRO Data | | | |
Operator Customer | varchar(255) | Operator customer name | Commercial Aviation Airframe MRO Data | | | |
Operator Customer ch-a Code | varchar(255) | Operator customer ch-aviation code (assigned by ch-aviation). Operator ch-aviation codes can be 2, 3, or 5 characters. | Commercial Aviation Airframe MRO Data | Foreign | Operators | Operator ch-a Code |
Status | varchar(255) | MRO provider status | Commercial Aviation Airframe MRO Data | | | |
Website | varchar(255) | Website URL | Commercial Aviation Airframe MRO Data | | | |
Stock Ticker | varchar(255) | Stock market ticker URL | Commercial Aviation Airframe MRO Data | | | |
Launch Year | int(4) | Year the MRO provider was launched | Commercial Aviation Airframe MRO Data | | | |
Termination Year | int(4) | Year the MRO provider stopped operations | Commercial Aviation Airframe MRO Data | | | |