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 engine_model_code IN ('55556')
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 engine_model_code IN ('55556')
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.
N91351Rodencal Gary L · Pine River, WIN913LWPires Joe · Geneva, FLN9140WJones Rodney A · Rexburg, IDN91411Derrick Joseph F · Kent, WAN9163RDowler Steve J · Geuda Springs, KSN91758Holman Robert S · Delta, UTN9181FMorrell Kevin J · Gladwin, MIN91859Alderman Leslie · Saint Clairsville, OHN9189YSandberg Forrest L · Jackson, WYN918DNNordwall Dale S · Duluth, MNN918UTSteiner Paul · Eagle Mountain, UTN919AAFriel Stephen M · Locust Grove, GAN92162Head Larry N · Celina, TNN92256Girard Louis W · Schulenburg, TXN9228TGraham Thomas A · Leesville, LAN9235GVroman Brian C · Centerville, PAN9238BCartwright Matthew D · Algonac, MIN923BHMccoy Timothy M · Artois, CAN924KMarsh Michael B · Freeland, MIN925RMMorey Elmer E · San Antonio, TXN92660Roell Rodney A · Panama City Beach, FLN9274VBontrager Jonathan L · Goshen, INN927HBetts James S · Kissimmee, FLN927PGBaugh Caleb G · Carthage, MON92897Mull Guy A Jr · Lake Toxaway, NCN9296MDawson William Charles Jr · Hesperia, CAN92986Gregerson Leif E · Wisconsin Dells, WIN9299EKempf Michael David · Vanceburg, KYN929MSSiravo Donald J · Westminster, CON929TRHeselschwerdt Troy D · Grass Lake, MIN9310YRegistration Pending · Simi Valley, CARegistration pendingN93187Forbes Mark G · Corvallis, ORN93387Mccullough Donald S · West Bend, WIN9339GCassell Aaron S · Lone Pine, CAN933BWWaller Charles R · Ashford, ALN9341RBaldwin Thomas A · Puyallup, WAN9352GReesor Jerry B · Concord, ARN93676Sutter Investments Lp · Dallas, TXN93786Luetchens Mel H · Murdock, NEN9382FPatterson Mathew · Ellisville, MSN9383DWolfe Ricky W · Lakeville, INN9384SHodges Greg B · Corryton, TNN9385TWolfe Ricky W · Lakeville, INN939TWarren Kenneth N · Anamosa, IAN94207Nichols Tommy J · Cheney, WAN94226Wiley Amy Joan · Las Vegas, NVN942EJReilly Patrick W · Rockford, ILN942WAKoppes Monte R · Hamilton, MTN94337Gajentan Jason · Leesburg, FLN94437Williams Terrance A · Bastrop, TX
Back to Rotax 582SER