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 ('0690009', '060009Y', '05622D3')
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 ('0690009', '060009Y', '05622D3')
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.
N6712Martin Robert J · Mcminnville, ORN676RVWheeler Darren S · Novato, CAN678ADCutrer John J · Mc Alpin, FLN67GWMannon Michael F · Collierville, TNN67JGGarrett James C · Friendswood, TXN6812YYoung John D · Birmingham, ALN683ASNistico Vincent P · Salem, ORN686MJLytle Robert B Jr · Copenhagen, NYN6886DDaedalus Vi LLC · Wilmington, DEN68DMRobison Douglas B · Avon, OHN697WBishop Patrick M · Reading, MAN702MDTrexair Planes LLC · Concord, CAN706RReiter Larry J · Loup City, NEN709KEWiborg Daniel Stewart · Bend, ORN710HBBoorsma Dale · Bakersfield, CAN710PPHrib Michael · Woodstock, GAN7112AAllis Frederick M · Eden Prairie, MNN712BKKibby Bobby G · Arlington, TXN712CFRentoumis Michael G · Altoona, FLN712JCCox Jim L · El Paso, TXN712KWJohnson Wayne C · Auburn, WAN712PHHardin Paul H · Cary, NCN712RVRegistration Pending · Fulshear, TXRegistration pendingN712WERegistered aircraftN712XBilderback Emil W · San Antonio, TXN713RPParker Richard D · Ocoee, FLN716JTAbbas Kyle · Gilbert, AZN716ZMarconi Joseph · Hamilton, OHN7185ARegistration Pending · North Tonawanda, NYRegistration pendingN719VALong Gregory D · Johnston, IAN719WEEmmick Jeffrey T · Indianapolis, INN725VARegistration Pending · Hendersonville, NCRegistration pendingN728RBSirani Aviation · Oasis, IDN728SLLane Scott R · Hillsboro, ORN729CTCorley Tommy G · Palmer Lake, CON729WRegistration Pending · Buckley, WARegistration pendingN72DJCarmody Brendan P · Sequim, WAN731JNMonderine Joseph J · Staten Island, NYN731TZGyllstrom Gregory W · Chagrin Falls, OHN734DDSheely Raymond A Jr · Valrico, FLN73712Rawlins Bruce L · Richland, WAN737GBogash Robert A · Hansville, WAN73DFOwl And Cardinal Aviation LLC · Sorrento, FLN73HRReese Robert J · Austin, TXN73HSSorensen Harvey L · Creighton, NEN746CPWright David A · Independence, ORN748EDDurham Ray · Jasper, TNN748KSDrath Bruce A · Tucson, AZN74GDProchut Richard L · Chesterton, INN754RCCostello Robert P · Owens Cross Roads, AL
Back to Vans RV-12