Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE engine_model_code IN ('34601')
ORDER BY 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 n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE engine_model_code IN ('34601')
ORDER BY n_numberRun 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.
N816AWU S Bank Na Trustee · Boston, MAN816UAUnited Airlines Inc · Chicago, ILN817AWU S Bank Na Trustee · Boston, MAN818AWU S Bank Na Trustee · Boston, MAN818UAUnited Airlines Inc · Chicago, ILN819AWU S Bank Na Trustee · Boston, MAN819UAUnited Airlines Inc · Chicago, ILN820AWU S Bank Na Trustee · Boston, MAN820UAUnited Airlines Inc · Chicago, ILN821AWU S Bank Na Trustee · Boston, MAN821UAUnited Airlines Inc · Chicago, ILN822AWU S Bank Na Trustee · Boston, MAN822UAUnited Airlines Inc · Chicago, ILN823UAUnited Airlines Inc · Chicago, ILN824AWU S Bank Na Trustee · Boston, MAN824UAUnited Airlines Inc · Chicago, ILN825AWU S Bank Na Trustee · Boston, MAN825UAUnited Airlines Inc · Chicago, ILN826UAUnited Airlines Inc · Chicago, ILN827AWUS Bank Na Trustee · Boston, MAN827UAUnited Airlines Inc · Chicago, ILN828UAUnited Airlines Inc · Chicago, ILN829UAUnited Airlines Inc · Chicago, ILN830UAUnited Airlines Inc · Chicago, ILN831AWUS Bank Na Trustee · Boston, MAN831UAUnited Airlines Inc · Chicago, ILN832AWUS Bank Na Trustee · Boston, MAN832UAUnited Airlines Inc · Chicago, ILN833AWU S Bank Na Trustee · Boston, MAN833UAUnited Airlines Inc · Chicago, ILN834UAUnited Airlines Inc · Chicago, ILN835UAUnited Airlines Inc · Chicago, ILN836AWAwas 2570 Trust · New York, NYN836UAUnited Airlines Inc · Chicago, ILN837AWAwas 2595 Trust · New York, NYN837UAUnited Airlines Inc · Chicago, ILN838AWUmb Bank Na Trustee · Salt Lake City, UTN838UAUnited Airlines Inc · Chicago, ILN839AWAmerican Airlines Inc · Fort Worth, TXN839UAUnited Airlines Inc · Chicago, ILN840AWAmerican Airlines Inc · Fort Worth, TXN840UAUnited Airlines Inc · Chicago, ILN841UAUnited Airlines Inc · Chicago, ILN842UAUnited Airlines Inc · Chicago, ILN843UAUnited Airlines Inc · Chicago, ILN844UAUnited Airlines Inc · Chicago, ILN845UAUnited Airlines Inc · Chicago, ILN846UAUnited Airlines Inc · Chicago, ILN847UAUnited Airlines Inc · Chicago, ILN848UAUnited Airlines Inc · Chicago, IL
Back to IAE V2500SERIES