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 ('3940032')
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 ('3940032')
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.
N659NKUmb Bank Na Trustee · Salt Lake City, UTN660NKSpirit Airlines LLC · Dania Beach, FLN661NKSpirit Airlines LLC · Dania Beach, FLN662NKSpirit Airlines LLC · Dania Beach, FLN663NKSpirit Airlines LLC · Dania Beach, FLN664NKSpirit Airlines LLC · Dania Beach, FLN665NKSpirit Airlines LLC · Dania Beach, FLN667NKSpirit Airlines LLC · Dania Beach, FLN668NKSpirit Airlines LLC · Dania Beach, FLN668SDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN669NKSpirit Airlines LLC · Dania Beach, FLN670NKSpirit Airlines LLC · Dania Beach, FLN671NKSpirit Airlines LLC · Dania Beach, FLN672NKSpirit Airlines LLC · Dania Beach, FLN673NKSpirit Airlines LLC · Dania Beach, FLN674NKSpirit Airlines LLC · Dania Beach, FLN675NKSpirit Airlines LLC · Dania Beach, FLN678NKSpirit Airlines LLC · Dania Beach, FLN679NKUmb Bank Na Trustee · Salt Lake City, UTN680NKUmb Bank Na Trustee · Salt Lake City, UTN681NKSpirit Airlines LLC · Dania Beach, FLN682NKSpirit Airlines LLC · Dania Beach, FLN683NKSpirit Airlines LLC · Dania Beach, FLN684NKSpirit Airlines LLC · Dania Beach, FLN685NKSpirit Airlines LLC · Dania Beach, FLN686NKSpirit Airlines LLC · Dania Beach, FLN687NKSpirit Airlines LLC · Dania Beach, FLN900UWAmerican Airlines Inc · Fort Worth, TXN901AAAmerican Airlines Inc · Fort Worth, TXN902AABank Of Utah Trustee · Salt Lake City, UTN903AAAmerican Airlines Inc · Fort Worth, TXN903JBJetblue Airways Corp · Long Island City, NYN904AABank Of Utah Trustee · Salt Lake City, UTN905AUBank Of Utah Trustee · Salt Lake City, UTN906AABank Of Utah Trustee · Salt Lake City, UTN907AABank Of Utah Trustee · Salt Lake City, UTN908AABank Of Utah Trustee · Salt Lake City, UTN909AMWilmington Trust Co Trustee · Wilmington, DEN910AUWilmington Trust Co Trustee · Wilmington, DEN912UYAmerican Airlines Inc · Fort Worth, TXN913JBJetblue Airways Corp · Long Island City, NYN913USAmerican Airlines Inc · Fort Worth, TXN914UYAmerican Airlines Inc · Fort Worth, TXN915USAmerican Airlines Inc · Fort Worth, TXN916USAmerican Airlines Inc · Fort Worth, TXN917UYAmerican Airlines Inc · Fort Worth, TXN918USAmerican Airlines Inc · Fort Worth, TXN919USAmerican Airlines Inc · Fort Worth, TXN920USAmerican Airlines Inc · Fort Worth, TXN921USAmerican Airlines Inc · Fort Worth, TX
Back to Airbus A321-231