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 ('9830220')
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 ('9830220')
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.
N87YKNafak LLC · Louisville, KYN888YKLon Brothers Aviation LLC · Miami, FLN88902Phugoid Aero LLC · Longmont, CON88YKRed Star Warbirds LLC · Las Vegas, NVN894ZSmith Jeremy B · Jemison, ALN9011MWilkins David J · Claremore, OKN9073ERegistration Pending · Phoenix, AZRegistration pendingN90MDUnangst John F · Fort Worth, TXN90SMGolden Christopher A · Cartersville, GAN90YKJpm Holdings Nv LLC · Carson City, NVN9102EBluff Raymond E IV · El Cajon, CAN9102YGernetzke Jill R · Kingman, AZN9109TPlane Air Museum · Grand Prairie, TXN9110MMurray Amanda K · Falmouth, MEN92AHCompass Aviation LLC · Lagrange, GAN97YKCavanagh Michael B · Dubois, WYN9859Affordable Casket Outlet LLC · Honolulu, HI
Back to Yakovlev YAK 52