Capacities – Scheduled

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.

To access the full sample data set on Snowflake, visit the ch-aviation profile on Snowflake Marketplace here.

Sample File NameSample Description
capacities_scheduled.csvSample data for commercial aviation
ColumnData TypeData descriptionPackageKeyData SetJoin On
Operator Namevarchar(255)Operator nameCapacities - Scheduled
Operator ch-a Codevarchar(5)Operator ch-aviation code (assigned by ch-aviation). Operator ch-aviation codes can be 2, 3, or 5 characters.Capacities - ScheduledPrimary (combined)/ForeignOperatorsOperator ch-a Code
Originvarchar(255)Origin airport display name (combination of City Name and Airport Name)Capacities - Scheduled
Origin IATA Codechar(3)Origin airport three character IATA codeCapacities - Scheduled
Origin Airport IDint(11)Origin airport stable airport IDCapacities - ScheduledPrimary (combined)/ForeignAirportsAirport ID
Origin Continentvarchar(255)Origin airport continent nameCapacities - Scheduled
Origin Subdivisionvarchar(255)Origin airport state nameCapacities - Scheduled
Origin Subdivision ISO Codechar(2)Origin ISO 3166-2 Alpha-2 subdivision code (used for states)Capacities - ScheduledForeignStatesState ISO
Origin Metro Groupvarchar(255)Origin airport Metro Group nameCapacities - Scheduled
Origin Metro Group Codechar(3)Origin Metro Group three character IATA codeCapacities - ScheduledForeignMetro GroupsMetro_Group
Origin Countryvarchar(255)Origin airport country nameCapacities - Scheduled
Origin Country ISOchar(2)Origin airport ISO 3166-1 Alpha-2 country codeCapacities - ScheduledForeignCountriesCountry ISO
Destinationvarchar(255)Destination airport display name (combination of City Name and Airport Name)Capacities - Scheduled
Destination IATA Codechar(3)Destination airport three character IATA codeCapacities - Scheduled
Destination Airport IDchar(4)Destination airport stable airport IDCapacities - ScheduledPrimary (combined)/ForeignAirportsAirport ID
Destination Continentvarchar(255)Destination airport continent nameCapacities - Scheduled
Destination Subdivisionvarchar(255)Destination airport state nameCapacities - Scheduled
Destination Subdivision ISO Codechar(2)Destination ISO 3166-2 Alpha-2 subdivision code (used for states)Capacities - ScheduledForeignStatesState ISO
Destination Metro Groupvarchar(255)Destination airport Metro Group nameCapacities - Scheduled
Destination Metro Group Codechar(3)Destination Metro Group three character IATA codeCapacities - ScheduledForeignMetro GroupsMetro_Group
Destination Countryvarchar(255)Destination airport country nameCapacities - Scheduled
Destination Country ISOchar(2)Destination airport ISO 3166-1 Alpha-2 country codeCapacities - ScheduledForeignCountriesCountry ISO
aircraft_iatachar(3)Aircraft three character IATA code (ch-aviation assigns dummy IATA codes to types for which IATA has not designated a code)Capacities - ScheduledPrimary (combined)/ForeignAircraft CodesIATA
Aircraft IATA Descriptionvarchar(255)Aircraft IATA DescriptionCapacities - Scheduled
Economy Capacityint(11)Total number of Economy seats across all flights for the specified route, aircraft type, and dayCapacities - Scheduled
Economy Plus/Comfort Capacityint(11)Total number of Economy Plus/Comfort seats across all flights for the specified route, aircraft type, and dayCapacities - Scheduled
Premium Economy Capacityint(11)Total number of Premium Economy seats across all flights for the specified route, aircraft type, and dayCapacities - Scheduled
Business Capacityint(11)Total number of Business seats across all flights for the specified route, aircraft type, and dayCapacities - Scheduled
First Class Capacityint(11)Total number of First Class seats across all flights for the specified route, aircraft type, and dayCapacities - Scheduled
Total Capacityint(11)Total number of seats across all cabin classes for the specified route, aircraft type, and dayCapacities - Scheduled
Frequencyint(11)Number of flights in a day for the route, operator and aircraft type.Capacities - Scheduled
ASMbigint(20)Available Seat Miles: seats x flights x great-circle distance in statute miles.Capacities - Scheduled
ASKbigint(20)Available Seat Kilometres (ASM x 1.60934, rounded).Capacities - Scheduled
Flight daydateDate of the flight(s)Capacities - ScheduledPrimary (combined)