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 aircraft_model_code IN ('1384511')
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 aircraft_model_code IN ('1384511')
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.
N555LVSouthwest Airlines Co · Dallas, TXN556WNSouthwest Airlines Co · Dallas, TXN660CPEastern Air Express LLC · Greensboro, NCN7702ASouthwest Airlines Co · Dallas, TXN7704BSouthwest Airlines Co · Dallas, TXN7713ASouthwest Airlines Co · Dallas, TXN7715ESouthwest Airlines Co · Dallas, TXN7721ESouthwest Airlines Co · Dallas, TXN7724ASouthwest Airlines Co · Dallas, TXN7732ASouthwest Airlines Co · Dallas, TXN7734HSouthwest Airlines Co · Dallas, TXN7735ASouthwest Airlines Co · Dallas, TXN7736ASouthwest Airlines Co · Dallas, TXN7737ESouthwest Airlines Co · Dallas, TXN7738ASouthwest Airlines Co · Dallas, TXN7739ASouthwest Airlines Co · Dallas, TXN7740ASouthwest Airlines Co · Dallas, TXN7741CSouthwest Airlines Co · Dallas, TXN7742BSouthwest Airlines Co · Dallas, TXN7743BSouthwest Airlines Co · Dallas, TXN7744ASouthwest Airlines Co · Dallas, TXN7745ASouthwest Airlines Co · Dallas, TXN7746CSouthwest Airlines Co · Dallas, TXN7747CSouthwest Airlines Co · Dallas, TXN7748ASouthwest Airlines Co · Dallas, TXN7749BSouthwest Airlines Co · Dallas, TXN7750ASouthwest Airlines Co · Dallas, TXN7751ASouthwest Airlines Co · Dallas, TXN7752BSouthwest Airlines Co · Dallas, TXN959BPEastern Air Express LLC · Kansas City, MO
Back to Boeing 737-7BD