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 ('05901OL', '059002C', '0590118', '0590167', '05903I9', '059022Y', '05904VY')
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 ('05901OL', '059002C', '0590118', '0590167', '05903I9', '059022Y', '05904VY')
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.
N582KDucote Kendall J · Prairieville, LAN582PCAguilar Miguel · Crosby, TXN582RXGarrett Dennis D · Eudora, KSN582SAArnold Steven · Johnson, KSN60661Registration Pending · Reeds, MORegistration pendingN6173XGreen Michael E · Sandy, UTN65039King Bradley Scott · Plainfield, ILN6504FCoshow Bradley S · Niles, MIN65270Mudd Michael R · Owasso, OKN6537TWilliamson Terry W · Pratt, KSN65406Kowitz Brenda L · Hutchinson, KSN7014XZillig Tyler · Goliad, TXN70309Boster Joe D · Van Buren, ARN7057ZRegistration Pending · Kennerdell, PARegistration pendingN7085VBowman Dennis R · Brazil, INN717JAHamsher Austin J · Nappanee, INN71852Robson Ryan L · Wasilla, AKN8018PSyring Leslie J Jr · Belleville, MIN8102NSundquist Robert S · Paola, KSN811ETurner Ernest Ray Jr · Chillicothe, ILN8541Johnston John H · Parkville, MON908PCJung Jerre A · Littleton, CON913MMJunkerman Herman L · Monroeville, NJN9189YSandberg Forrest L · Jackson, WYN929MSSiravo Donald J · Westminster, CON93370Junkerman Herman L · Monroeville, NJN9338WHamilton Scott B · Turon, KSN9381RGriffin Tad D · Trenton, MON93998Boone Dennis W · Damascus, GAN9413Bateson Matthew E · Independence, KSN94350Martins Darin R · Klamath Falls, ORN9451PWilson Harold A · Louisiana, MON94762Mclemore Robert E · Knoxville, TNN9476QLivgren Kerry A · Berryton, KSN9477YSpickelmier Russell D · Culbertson, NEN9857WThrasher Larry M · Palm City, FL
Back to Powrachute PC 2000