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.
N794ZGoulet Steven J · Greene, MEN796DSAbney Timothy R · Crossett, ARN7WCSeus Eugene E · Manteca, CAN8003EKovatch John R · Lake Dallas, TXN8009MRobson Brent · Tetonia, IDN8009UMartin Joseph P · Milton, FLN80255Toomey Lyn R · Londonderry, NHN8029ZHayes Lance Garett · Opelousas, LAN8030RDudeck Martin J · Daytona Beach, FLN8038GFenrick Earl F · Janesville, WIN80455Ferree Thomas L · Wampum, PAN8045ZBoyd James G · Killen, ALFirst renewal noticeN8049VWatson Ricky E · New Market, TNN8051LBrewer Mark S · Salt Lake City, UTN8054RThorstad Ronald P · Titusville, FLN8055APatton James E · Spencer, INN805RPitman Air LLC · Red Bluff, CAN8060YKuehne David · Fayetteville, NCN8067YHurley Ken · Billings, MON8070JClausen Matthew · Yucca Valley, CAN8073ZHawkins Ronald W · Walnut Grove, MON8075KBatton Douglas M · Williamsville, MON8077TStephenson James G · Lake City, FLN8080WSale Reported · Rch Palos Vrd, CASale reportedN8083ZBlankenheim Thomas N · Kiel, WIN8088UGill Jay L · Rudy, ARN80907Boswell Steven J · Mason, ILN80BXHarvey Erin S · Cape Charles, VAN80SJHigher Standard Contracting LLC · San Antonio, FLN8102NSundquist Robert S · Paola, KSN8115NGill Jay L · Rudy, ARN8115VGill Jay L · Rudy, ARN811DSSale Reported · St Louis Park, MNSale reportedN811ETurner Ernest Ray Jr · Chillicothe, ILN81950Sport Flyers LLC · Mount Vernon, MON819JLJones Norman D · Boulder City, NVN819NEArcher James W · Prescott Valley, AZN819RHHoward Michael D · Groveland, FLN81TGGeorges Thomas E · Edinburg, ILN81UPKanocz Kathy A · Houston, TXN82047Sayner George H · San Diego, CAN82240Nobel David J · New Lisbon, WIN822WVNce Inc · Tucson, AZN823CCCompton Travis D · Miami, OKN830DIngersoll Dean M · Holland Patent, NYN836KBCorrigan Michael S · Cedar Grove, TNN846JPAnstine Douglas W · Arkansas City, KSN847JMMyers Joey M · Fairfield, CAN84FWHorner Joseph D · Bolivar, MON84PMLockhart John P · Mapleton, ME
Back to Rotax 582SER