Skip to content

Registered aircraft · 26

Aircraft with this engine in the FAA registry, by N-number.

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 ('55559')
  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 ('55559')
ORDER BY n_number

Run 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.

N10364Wilbur Everett L Jr · Willis, MIBuilt 2009 · S/N LS7016 N1188WMiller Larry G · Sioux Falls, SDBuilt 2008 · S/N LS7008 N127WPMoore Kevin R · Edgewood, NMBuilt 2006 · S/N 001 N131GEHine George · Mills, WYS/N 0695829ES N1962WBernard Peter C · Fleming Island, FLBuilt 2011 · S/N 0252 N2786AGardner Mark W · Wasola, MOBuilt 2003 · S/N A 131 PEG N366CNChatfield Billy W III · Riddle, ORBuilt 2008 · S/N LS 7007 N372KXMassey Jack Ryan · Alexandria, TNBuilt 2009 · S/N E7009 N381FACochenour Jerry E · Wellsboro, PABuilt 2009 · S/N X-582-1102 N43908Simoni Michael J · Geneseo, NYS/N 3C0413 N5599NSandberg Ruebin J · Lafayette, LABuilt 2003 · S/N 0066 N5627SGlendinning William O · South Bristol, MEBuilt 2002 · S/N 000574 N56718Brown Larry E · Pullman, WABuilt 1999 · S/N 4821 N582MSRodriguez Joey · Mobile, ALBuilt 2008 · S/N 000721 N582PCAguilar Miguel · Crosby, TXS/N A166POW N582RTHoskins Robert D · Euless, TXBuilt 1996 · S/N 0392022 N6160AHansen William R · Cheney, WABuilt 2003 · S/N F4A028 N617CTMartin Timmy L · Little River, SCBuilt 2008 · S/N A469PEG N647PCHansen William R · Cheney, WABuilt 2003 · S/N F4A026 N69AXMcdonald Scott · Longmont, COBuilt 2000 · S/N 582-614 N8039QSoroko Edward J · Kingman, AZBuilt 2007 · S/N 2494 N925DQDequiroz Glenn J · Discovery Bay, CABuilt 2011 · S/N SPORT 2S0264 N94350Martins Darin R · Klamath Falls, ORBuilt 2000 · S/N A74POW N94586Tipton Steve · Neosho, MOBuilt 2002 · S/N 0042 N947WLLewis William E · Cumberland, MEBuilt 1999 · S/N SWJ582105001 N979MJOliver Eric A · Stevensville, MDBuilt 2015 · S/N 10009

Back to Rotax 582UL-99