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.
N401TFTeenflight Puyallup · Puyallup, WAN403JBBohmer James F · Tulsa, OKN403TFPowell Douglas O · Renton, WAN404RVSorenson James C III · Seattle, WAN409FMPrignano Richard V Jr · Shirley, NYN409PTWenk Charles Peter · Beaufort, NCN40BFFrazier Deborah A · Fort Myers, FLN40RJHeusinkveld Karen B · San Marcos, TXN40RK40rk LLC · Hickory, NCN412BRHollifield Billy R · Marshall, TXN412DRRutherford Douglas B · Cumming, GAN412FCPawsum Aviation Services LLC · Honolulu, HIN412JNNorling Jesse D · Enumclaw, WAN412RVRegistration Pending · San Luis Obispo, CARegistration pendingN412SBSudac Keith S · Belfair, WAN412TCEliason Terry B · Cushing, MNN413EHFly Ny Inc · East Aurora, NYN413KARv-12 Renegades LLC · Elizabethtown, KYN416SCRegistered aircraftN417EHeritch Ian D · San Antonio, TXN418MJRegistration Pending · Liberty Twp, OHRegistration pendingN419XAYoung Wallace D · Foley, ALN4212CAnderson Curt W · Independence, ORN4247ESchaller Richard F · Avondale, AZN425SMKerchmar Kelsie N · Pompano Beach, FLN427TDRuningen Aaron · Sussex, WIN42KJHill Jerre M · Loveland, CON430MHHossain Monir · Ashburn, VAN431RVCrego Richard H · Dover, NHN432CYWard Ronald W · Payson, AZN432SBZmyewski Justin S · Houston, MNN439CHChisholm Ronald F · Fort Atkinson, WIN439MJKrueger Anne · Phoenix, AZN440WBBurnette Wade D · Zebulon, NCN441DMGalt Sean P · Seattle, WAN442WGIcarus Time Building And Rental LLC · Bluff City, TNN448BSGiles Michael H · Belfast, MEN448JRRogers James E · The Villages, FLN448TGVinson Martha G · Gilbert, SCN448UVDockery Robert · Fort Blackmore, VAN44VABoth Wings LLC · Inver Grove, MNN450RVHickerson Timothy William · Springfield, OHN452NESmith Robert M · New Ipswich, NHN452USN9983y LLC · Dover, DEN453NSSmith Clarence M · Lakeland, FLN454TFCuller Chris A · Mount Vernon, WAN455HRLink Justin · Apple Valley, CAN4560Stevens Larry L · Beavercreek, ORN456DTThurman Delbert L · Atlantic, IAN457JJPage Raymond Thomas Jr · Georgetown, TX
Back to Vans RV-12