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.
N7513LHubbard John · Eagle Mountain, UTN7520EBorden Mark J · Carson City, MIN75271Williams Kenneth · Lone Jack, MON75273Thomas Mark C · Stillwater, PAN7529DGarvelink Frank A · Marcellus, MIN75302Paulsen Matthew C · Wisconsin Dells, WIN75307Kieffer Erv J · Pittsville, WIN75312Barbieri John M · Citrus Heights, CAN7531YPartridge Bruce R · Rockford, MIN75326Herring Nathan · Munday, TXN75331Murphy Michael D · Lexington, KYN75404Gould Gerald D Jr · Pickerington, OHN75437Wettrike Inc · Lucedale, MSN75464Elkins Lyndol L Jr · Alburgh, VTN75498Clarke Dennis N · Richmond, CAN75540Price Kent H · Eagle Mountain, UTN75585Todd Michael G · Jasper, ALN7559LMcclard Charles Ray · Chaffee, MON75609Smith Joey A · Benton, ARN75617Hedrick Benjamin A · Coquille, ORN756DMHughes Tom T · Mantorville, MNN75736Sale Reported · Tooele, UTSale reported, pending cancellationN75738Shoemaker James O · Millington, TNN757LWKarpinski Robert L · Fenton, MON757TPMatos Maceo David · Sebring, FLN758DFBradford Andrew Jason · Spokane, WAN7592ADodge Charles J · Finlayson, MNN759CPVida David · Pinole, CAN7600AFisher Larry A · Romney, WVN7645CPfeifer Anthony S · Delaware, NJN7673JCords Jerry · Cicero, INN7680CParunak Gene P · Saline, MIN769JRRea James C · Bowdoinham, MEN76NWPearson William C · Lenoir, NCN77186Sharp Carey F · Flower Mound, TXN7745CLange Daniel M · Whitewater, WIN7746RSanders Christopher L · Triplett, MON7765CQuisenberry Richard Scott · Marietta, OKN777ULCollen Dustin B · Hamilton, MTN7780CMohler Dennis E · Topeka, KSN778REEmmert Raymond Louis · Bethany, OKN778WALockhart Craig · Moses Lake, WAN77911Sturdivant Steven R · West Monroe, LAN782DPDaulton Steven · Somerset, KYN78333Keener William D · Maiden, NCN7861LMiller Douglas G · Mahaffey, PAN787WPAttaway Lauren · North Las Vegas, NVN78811Schwenker Michael J · Marietta, GAN789LGGirard Louis W · Schulenburg, TXN78HDBolkan Chris L · Pasco, WA
Back to Rotax 582SER