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.
N108KMJessop Edson L · Corvallis, MTN113DCChaney David H · Baton Rouge, LAN12450Camplin Jon E · Lincoln, NEN1350Lindley Eric L · Keokuk, IAN154TRRiffe Thomas W · Larkspur, CON160TDDriscoll Tom · Melba, IDN163RCIrvine Robin R · Ravenna, NEN16630Woodriff R Lee Dr · O Brien, FLN2018QMurphy Robert L · Morristown, TNN209ABHorton Brian R · Chillicothe, MON2116KDoolin James J · Carrollton, TXN2284FMcdonald Coy D · Bay City, TXN2353LGirard Louis W · Schulenburg, TXN2499UWalker Robert K · Cecil, ARN25349Hayward Stace A · Terrell, TXN2543HKinney Peter H · Watertown, SDN2569BCole Roger G · Greenfield, ILN264JLong James L · Berryton, KSN2678NMiller Timothy A · Warsaw, INN2738AKnowles Charles M · Chapmanville, WVN30526Babcock Tansi M · Lowell, INN30VCYoder Larry L · Sherwood, MIN3120LBill Steven Scott · Hollywood, MDN3128BEnglish Jared J · Walnut Shade, MON31765Orin Christopher A · Monmouth, ORN3503RZelasko Edward P · Lansing, ILN3515QJess Alvie E · Arthur, ILN3541VDavis Calvin R · Gassville, ARN361TWPoleski Martin L · Ballwin, MON384CDBaedke Frank D · Story City, IAN4050UBurton Mark P · Jackson, TNN4061WYawn Robert · Mccomb, MSN4068MCorwin Timothy G · Southampton, NYN406MESheppherd Anthony B · San Diego, CAN409JKSavage Julian J · Butler, PAN422AFWerneke Jeff C · Neosho, MON423AFHayes Bradley J · Adair, OKN440ABHowell Aviation LLC · Orlando, FLN456CTTucker Clifford R · Warrenton, MON488AStier Steven T · Hahira, GAN5052CLester Gordon W · Corpus Christi, TXN5070MGeise Todd J · Milton, PAN511RCCox Rodney J · Haven, KSN5159LPerkinson Robert D · Gallatin, TNN5166KSchmidt Kent D · Arnold, MON5605NIfly4u LLC · Benton, LAN56620Holliday Christopher R · Salem, MON566AWBruns Darcy L · Sandia, TXN56932Tanner Steve E · Norton, KSN56971Dickhudt Gene R · Mcpherson, KS
Back to Powrachute PC 2000