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 ('0630610')
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 ('0630610')
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.
N5723LPearlman Fredric M · Southfield, MIN5738LRosche Henry III · Loveland, OHN5739LMcgll Phil · Huntsville, ALN5741LWienclaw David E · Boise, IDN5742LGjorvad Steven A · Punta Gorda, FLN5743LHead William J · Verona, KYN5764LBanks Jeffery L · Pensacola, FLN5768LWilliams Charles J · Murfreesboro, TNN5774LHickman Robert D · Mobile, ALN5775LGulfstream Aerospace Corp · Savannah, GAN5776LCollins Timothy · Northfield, MNN5777LSessums David L · Seabrook, TXN5783LCarter Ryan L · Blackshear, GAN5785LVance Marc G · Canal Winchester, OHN5790LSeveca Ventures LLC DBA · Arcola, TXN5791LGuytek Aviation LLC · Margate, FLN5794LVanhorn Wyatt A · Macon, GAN5799LYoder George R · North Pole, AKN5901LDuff John R · Farmers Branch, TXN5902LWaffle Matthew · Bainbridge Island, WAN5904LRegistration Pending · Orem, UTRegistration pending, pending cancellationN5906LSonshine Unlimited LLC · Canfield, OHN5917LHill Jeffrey A · Boise, IDN5918LRobello Mel K · San Jose, CAFirst renewal noticeN5919LMckee Marty R · Lenoir City, TNN5920LSharratt Mark M · Ogilvie, MNN5922LJokerst Kenneth · Saint Louis, MON5927LTri State Airmotive LLC · Berryville, ARN5931LLuft Aviation Inc · Wilmington, DEN5938LMidland Avionics LLC · Louisville, KYN5942LSimulation International Management Inc · Tulsa, OKN5943LBlackmore Marc A · Hilltop Lakes, TXN5944LHoover Charles J · Logansport, INN5951LWilson Joe M · Lucedale, MSN5952LAskew Stell B III · Durham, NCN5953LTaylor John W Jr · Metairie, LAN5961LRobinson Morton · Fort Townsend, WAN5964LHortman Walter J · Ivyland, PAN5967LRegistration Pending · Carolina, PRRegistration pendingN5971LLetourneau University · Longview, TXN5974LFifer O Lynn · Woodstock, ILN5976LGoertz Anton Oscar · Santa Fe, NMN5978LCorbin Thomas T · Titusville, FLN5981LAnthony Allen J · Commerce Township, MIN5983LWatson Thomas M III · Lampasas, TXN5986LJilot Richard F · West Monroe, LAN5991LSlomer James A · Cheswick, PAN6104LPaul Michael W · Rabun Gap, GAN6109LParran James V · Kailua, HIN6110LRegistered aircraft
Back to American AA-1