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 ('55562')
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 ('55562')
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.
N65799Brown Patrick A · West Bend, WIN6582DHasbrouck David E · Meadville, PAN658BYNaile Donald Jr · Inverness, FLN658EZMays Allan G · Normal, ILN66008Martin Timmy Lee · Yuma, AZN66095Berg John · Sand Springs, OKN660RTKerns Danny L · Chatham, ILN662MFVan Jacobs Courtney · Port Charlotte, FLN666QDDavison Jeffrey G · Saginaw, MIN671JHHenley Mark A · Sulphur Rock, ARN677NCPeeler James K · Cherryville, NCN68NZWilliams Grady L · Atwater, CAN69377Snipes Albert D · Pace, FLN694KStanbery Bryan T · Mocksville, NCN696NCRegistered aircraftRegistration pending, pending cancellationN7010HBaugh Ty · Jasper, MON7014UHoward Dennis V · Memphis, MON7017CLocklear Delton Ray · Rockingham, NCN70197Guthrie Carroll B · Azle, TXN702DWWaters Donnie G · Bellevue, TXN70349Risner Robert K · Wheelersburg, OHN7055TFuller John M · Duanesburg, NYN7057ZRegistration Pending · Kennerdell, PARegistration pendingN7058LMackey Lanny J · Rochester, WAN7058UMarks Steven J · Wautoma, WIN7083JJourdan Robert M · Glen Ellyn, ILN7084LReilly Broghan J · Chippewa Falls, WIN7091BBruss Scott R · Copper Center, AKN7096PList Jerome O · Anchorage, AKN7099JSavio Dominic · East Patchogue, NYN71038Grable Eugene W · Foristell, MON7105ZBailey Charles S Jr · Sumterville, FLN7107JPittard Billy · Winterville, GAN710WPSmith Keaton J · Interlochen, MIN7113NWilliamson Aaron H · Lake Elsinore, CAN7114HPaddock Douglas O · Arlington, NEN712ELDaniels Joshua A · Colfax, LAN71314Schwab Randy L · Ketchum, IDN7136MDebruin Katie A · Cleveland, WIN7155BPaddock Douglas O · Arlington, NEN7163ERegistration Pending · Des Moines, IARegistration pendingN7173YLacost Michael W · Kankakee, ILN717JAHamsher Austin J · Nappanee, INN71852Robson Ryan L · Wasilla, AKN7188ZLenth Lonnie E · Wadena, IAN718DMCopley Cloyce D · Dayton, OHN7191KNash Larry W · Brookneal, VAN7191WTrizzino James Thomas Jr · North Pole, AKFirst renewal noticeN720UFDebord Christopher David · Plant City, FLN722ARSoto Arocho Luis Geraldo · Arecibo, PR
Back to Rotax 582DCDI