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.
N124KJMoore Joshua · Newville, ALN124KLKaluza Charles L · Wilsonville, ORN124RLBoyce Garrett E · Shelbyville, TNN124RNWarren John W · La Center, WAN124WBGem State Wings LLC · Eagle, IDN124WGDrane Stephen T · Kerrville, TXN124XDDuffield Christine P · Independence, ORN125JEAllee Marc · Granbury, TXN126BJRegistered aircraftN127RVBear Aerospace LLC · Palm Harbor, FLN128MSSantic Martin G · Davenport, IAN128TLLeibold Torsten K · Tucson, AZN129PWSamples Stuart H J · Huntsville, ALN12BBCooney Michael J · Green Bay, WIN12CSMeadows Craig A · Gainesville, GAN12HNNachshon Limor · Ocala, FLN12PDDamiano Paul J · Port Orange, FLN12SMJennings Scott M · Boise, IDN12VNAllen Aircraft Inc · Monroe, OHN12XBWright Ronald J · Olympia, WAN12XKSorochak Barbara · Rochester, MNN12ZCMarker Michael M Jr · Los Lunas, NMN130TBGfeller Gregory G · Post Falls, IDN1345GRegistered aircraftN137AZVangrunsven Stanley J · Vancouver, WAN138NTBerryhill Jerry · Marion, NCN142KLLeth Karlyn H · Middleboro, MAN143MRGallina Robert · Beaufort, SCN143WMDoyle Michael E · Xenia, OHN145GKSigrest Edwin D · Bakersfield, CAN145YHelpinstine Stephen S · Benton, KYN14DQCryer Don Q · Payson, AZN151MHHoward Michael A Trustee · Omaha, NEN159XPCarr Daryl G · Moville, IAN160BDHull Jeffrey M · Portland, ORN160JGMiller David M · Seabrook, TXN167SWGulf Coast Aerial Imagery LLC · Pensacola, FLN16VWRamm Donald E Trustee · Chula Vista, CAN172LBBoyer Philip B · Batavia, OHN1769KRegistered aircraftN177PPCressman Gary M · Elizabeth City, NCN179QHigh Desert Flyers Association · Albuquerque, NMN187DGAdle Scott T · Imperial, NEN188VSVan Santen Julian · Fountain Hills, AZN191TWRudolph Gary A Jr Trustee · Orinda, CAN1926LLinton Stephen W · Andrews, SCN1929EEtchell David A · Reno, NVN194DMRonnie'S Aircraft Sales Llp · Pittsfield, MAN1956KKurpgeweit William F · Ewing, NEN1975CMillar Stephen L Trustee · Hubbard, OR
Back to Vans RV-12