Atlas Air Inc
Registered aircraft · 53
Registered to this exact name, as owner or co-owner. Owners who share a name are listed together; other spellings aren’t included.
Query with SQL
duckdb -csv -c "SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code WHERE g.registrant_name = 'ATLAS AIR INC' OR list_contains(g.other_registrant_names, 'ATLAS AIR INC') ORDER BY g.n_number"
Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code WHERE g.registrant_name = 'ATLAS AIR INC' OR list_contains(g.other_registrant_names, 'ATLAS AIR INC') ORDER BY g.n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N1511ABoeing 767-383 · S/N 24318N1619ABoeing 767-3Y0 · S/N 26208N263SGBoeing 747-481 · S/N 29263N322SGBoeing 747-481 · S/N 30322N408MCBoeing 747-47UF · S/N 29261N409MCBoeing 747-47UF · S/N 30558N412MCBoeing 747-47UF · S/N 30559N416MCBoeing 747-47UF · S/N 32838N418MCBoeing 747-47UF · S/N 32840N419MCBoeing 747-48EF · S/N 28367N429MCBoeing 747-481 · S/N 24833N430GTBoeing 747-4H6F · S/N 28434N431GTBoeing 747-4H6F · S/N 29902N438GTBoeing 747-409F · S/N 30766N439GTBoeing 747-409F · S/N 30767N445MCBoeing 747-4B5F · S/N 33515N446MCBoeing 747-4B5F · S/N 33517N450PABoeing 747-46NF · S/N 30808N451PABoeing 747-46NF · S/N 30809N452PABoeing 747-46NF · S/N 30810N453PABoeing 747-46NF · S/N 30811N454PABoeing 747-46NF · S/N 30812N464MCBoeing 747-446 · S/N 26341N465MCBoeing 747-446 · S/N 24784N471MCBoeing 747-412 · S/N 26557N472MCBoeing 747-45E · S/N 27062N473MCBoeing 747-45E · S/N 27174N475MCBoeing 747-47UF · S/N 29252N476MCBoeing 747-47UF · S/N 29256N477MCBoeing 747-47UF · S/N 29255N480MCBoeing 747-422 · S/N 28812N481MCBoeing 747-443 · S/N 32339N482MCBoeing 747-443 · S/N 32340N489MCBoeing 747-412F · S/N 26553N492MCBoeing 747-47UF · S/N 29253N493MCBoeing 747-47UF · S/N 29254N496MCBoeing 747-47UF · S/N 29257N498MCBoeing 747-47UF · S/N 29259N499MCBoeing 747-47UF · S/N 29260N640GTBoeing 767-3S1 · S/N 25221N641GTBoeing 767-38E · S/N 25132N645GTBoeing 767-324 · S/N 27393N649GTBoeing 767-300ER · S/N 25864N662GTBoeing 767-31A · S/N 27619N663GTBoeing 767-324 · S/N 27568N850GTBoeing 747-87UF · S/N 37570N851GTBoeing 747-87UF · S/N 37565N852GTBoeing 747-87UF · S/N 37571N853GTBoeing 747-87UF · S/N 37572N854GTBoeing 747-87UF · S/N 37566
Back to Atlas Air Inc