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 ('2072732')
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 ('2072732')
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.
N5283NGibson Bruce S · Cayucos, CAN5284NMiller Kevin A · Littleton, CON528ESBraner Dana A · Portland, ORN5291NJdb Aviation LLC · Topeka, KSN5292NGoicoechea Mitchell Trustee · Elko, NVN5295NHillcrest Emergency Physicans Inc · Tulsa, OKN529JKSkydogs LLC · Fairfax, VAN5302NNorthwoods Air LLC · Orono, MEN5304NHotrod Aviation LLC · Fayetteville, ARN5305NBennett Brian · Horseheads, NYN5313NGavin Patrick H · Carlsbad, CAN5317NJones Timothy S · St Simons Is, GAN5319NUSA Aviation LLC · Fairfield, MEN532DCDc Aviation LLC · Panama City, FLN5330NMarion Michael · Canyon Country, CAN5335NRaymond Larry D · Ennis, TXN5336NFischer Joseph A Jr · Lake Jackson, TXN5339NMaine State Police · Augusta, MEN5346NMustang Manufacturing Inc · Carson City, NVN5352NAhrens Douglas T · Los Altos, CAN5355NFlying South LLC · North Charleston, SCN5356NCacka Rudolph Jr · Wenatchee, WAN535DCCamber Air LLC · Santa Ana, CAN5369NDecio Justin M · Portsmouth, NHN5376NCowgill John David · Studio City, CAN537TTDudley Lee Brent · Passadumkeag, MEN5380NRackley Harvey R Jr · Liberal, KSN5381NBrentco Aerial Patrol Inc · Canton, OHN5383NCivil Air Patrol Inc · Maxwell Afb, ALN5384NBlizzard Johnny F · Lake City, FLN5385NTrevino Sergio A · Houston, TXN5390NLarsen Steve J · Colton, ORN5393NRegistration Pending · Craig, CORegistration pendingN5395NDelaware Horizon Properties LLC · Lewes, DEN5401NMcmanus Casey J · Edmonds, WAN5408NAviation Law LLC · Mesa, AZN5419NTwallace LLC · Griffin, GAN5420NAdelman Hiram · Bass Harbor, MEN542SWHardy Tracy G · Tucson, AZN54PWScheffers Lee · Riverside, CAN550BNAllen Anne · Huntsville, TXN550PTPeterson Jo · El Dorado, KSN550TXClassic Wings And Wheels LLC · Orlando, FLN550UClear Sky Aviation LLC · Mccall, IDN551SFFilmlites Montana LLC · Bozeman, MTN552RWWelch Richard L · Tazewell, TNN555AHRegistered aircraftN555FMHorst Aviation LLC · New Holland, PAN55HJRadlinger Joseph · Hudson, WIN55MBSimon Caesar · Carmel, CA
Back to Cessna 182Q