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 ('3230203')
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 ('3230203')
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.
N8801XPiercy Ronald S · Moses Lake, WAN8801YWelch Thomas R DBA · Modesto, CAN88024Madsen Travis E · New Underwood, SDN8802RPacific Kota LLC · Beresford, SDN8802YMadsen Travis E · New Underwood, SDN8802ZMadsen Travis E · New Underwood, SDN8803RMadsen Travis E · New Underwood, SDN8803ZReed Aviation Inc · Iota, LAN8804MKruse Paul L DBA · Colfax, ILN88061Stoican Steve G · Ryegate, MTN8806KMadsen Travis E · New Underwood, SDN8806LMadsen Travis E · New Underwood, SDN8806YPrecissi Flying Service Inc · Lodi, CAN88099Nor-Wes Inc · Shreveport, LAN8809UDoyles Ag Services LLC · Two Buttes, CON88108Nor-Wes Inc · Shreveport, LAN8810TC Fleet LLC · Missoula, MTN88124West Aviation Inc · Creston, IAN88128Moore John T · Ward, ARN8812BSale Reported · Missoula, MTSale reportedN8812EHeiman Flying Services LLC · Summerfield, KSN88135Reed Aviation Inc · Iota, LAN8813KPrecissi Flying Service Inc · Lodi, CAN8815UHendrickson Tyrel L · Chester, MT
Back to Eagle EAGLE DW-1