Airframe MRO Providers and Customers

ColumnData TypeData descriptionPackage requiredKeyData SetJoin On
Airframe MRO Namevarchar(255)Name of the MRO providerCommercial Aviation Airframe MRO Data
Airframe MRO ch-a Codevarchar(5)MRO provider ch-aviation code (2-5 characters)Commercial Aviation Airframe MRO DataForeignEntitiesEntity ch-a Code
Legal Namevarchar(255)MRO Provider legal nameCommercial Aviation Airframe MRO Data
Base Locationvarchar(255)Airport Display Name (combination of City Name and Airport Name)Commercial Aviation Airframe MRO Data
Base Location ch-a Codevarchar(6)Airport ch-aviation code (not a stable ID, IATA code if available, otherwise ICAO, otherwise alternative code)Commercial Aviation Airframe MRO DataForeignAirportsAirport ch-a Code
Base Location IATAchar(3)Airport three character IATA codeCommercial Aviation Airframe MRO Data
Base Location ICAOchar(4)Airport four character ICAO codeCommercial Aviation Airframe MRO Data
Base Continentvarchar(255)Continent nameCommercial Aviation Airframe MRO Data
Base Subdivisionvarchar(255)State nameCommercial Aviation Airframe MRO Data
Base Subdivision ch-a Codevarchar(255)ISO 3166-2 Alpha-2 subdivision code (used for states)Commercial Aviation Airframe MRO DataForeignStatesState ISO
Base Metro Groupvarchar(255)Metro Group nameCommercial Aviation Airframe MRO Data
Base Metro Group IATAchar(3)Metro Group three character IATA codeCommercial Aviation Airframe MRO DataForeignMetro GroupsMetro_Group
Base Countryvarchar(255)Country nameCommercial Aviation Airframe MRO Data
Base Country ISOchar(2)ISO 3166-1 Alpha-2 country codeCommercial Aviation Airframe MRO DataForeignCountriesCountry ISO
Maintenance Typevarchar(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 Customervarchar(255)Operator customer nameCommercial Aviation Airframe MRO Data
Operator Customer ch-a Codevarchar(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 DataForeignOperatorsOperator ch-a Code
Statusvarchar(255)MRO provider statusCommercial Aviation Airframe MRO Data
Websitevarchar(255)Website URLCommercial Aviation Airframe MRO Data
Stock Tickervarchar(255)Stock market ticker URLCommercial Aviation Airframe MRO Data
Launch Yearint(4)Year the MRO provider was launchedCommercial Aviation Airframe MRO Data
Termination Yearint(4)Year the MRO provider stopped operationsCommercial Aviation Airframe MRO Data