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.
N94455Speer Justin R · Cape May Ch, NJN94471Butler Ronald J · Arbor Vitae, WIN94508Whitney Richard B · North Brookfield, MAN9451VWhitney Richard B · North Brookfield, MAN94534Erickson Daniel A · Marion, OHN94543Richardson Paul D · Pipe Creek, TXN945AZZwink Alan D · Grand Island, NEN94647Norman Monroe Emmett · Duvall, WAN94668Ormerod Larry A · Elizabeth City, NCN94689Medina Francisco J · Pico Rivera, CAN94725Martin Darrell · Goshen, INN94734Kensley Cletus K · Jeddo, MIN9474FChurch Alfred G Jr · Fallon, NVN94762Mclemore Robert E · Knoxville, TNN9476QLivgren Kerry A · Berryton, KSN94771Vandemark Jared K · Huntsville, OHN94781Schoaf Glen A · Waterville, MNN9516SBarefoot Michael T · Norwalk, OHN95243Promes Craig J · Denison, IAN9525QSpear Andy · Bolivar, MON95262Lewis Stephen A III · Fleming, GAN95319Bouis Charles J III · Missoula, MTN9543Deurloo Robert J · Salmon, IDN95483Kinzler Roderick Christopher · Watervliet, MIN954PFerrell James D · Mercer, PAN9550NWooding Josh · North Little Rock, ARN95520Rothwell-Nason Ranch Co · Tryon, NEN957AKThebes Joe · Delta Jet, AKN957RPParent Rick · Wolfeboro Falls, NHN960EOrendorff R Allen · Yuma, AZN960KEWhalen Richard G · Taylor, UTN962TAAguillard Tyler J · Cleveland, TNN9669BMcgee Charles J · Rochester, PAN96LRWilliams Patrick E · Lufkin, TXN971EWWilson Jimmy D · Dewey, AZN974CBRoberts Byron T · Navarre, FLN98CWHickey James E · Lonetree, WYN98VVMorrison Scott M · La Pine, ORN9902ZBeckman Alan C · Lexington, KYN9937Bellerby John Terence · Portland, ORN9971BBordelon Scott P · Ehco, LAN999NUJohnsen Chad P · Crete, NEN999WFSmith Andrew D · New Port Richey, FL
Back to Rotax 582SER