Skip to content

Registered aircraft · 578

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 ('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_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.

N724HCMillette Robert T · Killington, VTBuilt 2001 · S/N 352001 N725WREckert Christopher · Odessa, FLS/N UF2S161 N729JLLittrel Jeremy M · Davenport, NEBuilt 1991 · S/N RANS 1916151820 N72PHSamuel Dawson G · Minden, LABuilt 2009 · S/N CH2-0707-2813 N731BWUngrey Tom R · Rockford, MIBuilt 2004 · S/N IPP4-274 N731CGGenheimer Craig S · Columbus, OHBuilt 1999 · S/N 01999 N741KButler Mark E · Texarkana, TXBuilt 2009 · S/N 705 N747FWWalther Frank C · Crawford, COBuilt 1995 · S/N 2536 N747RGDamien Curtis E · Drummonds, TNBuilt 2002 · S/N 3C0464 N7504UWhyte Jack L · Pinconning, MIBuilt 2003 · S/N 0617 N75086Bergdolt Terry W · Paris, ILBuilt 2003 · S/N A-199 PEG N75097Deister Todd W · Manitou Beach, MIBuilt 2003 · S/N 2883 N7513VBoyd Dane S · Manhattan, KSBuilt 2002 · S/N A317POW N751FSWagner Douglas A · Stone Mountain, GABuilt 2001 · S/N 259 N75364Knisley Dennis L · Rockwell City, IABuilt 2008 · S/N 188PK N75372Culbertson Jason D · Marshall, TXBuilt 2004 · S/N 407098 N75443Deaton Clay R · West Alexandria, OHBuilt 2008 · S/N QSPP-1 N7551ALane Michael L · Ector, TXS/N 4926 N75660Porter Gary L · Norwood, PABuilt 1996 · S/N 34427 N75700Weiss Roger W · Faith, SDBuilt 2000 · S/N SR7X1-2447 N75780Hastings Warren J · Scottsburg, VABuilt 1998 · S/N 98-1848 2SR/7 N769GMalone Grady I · Loudon, TNS/N 1001 N7711ZOsborne Kevin S · Acworth, GABuilt 2007 · S/N SWJ582301028 N7769LHadley Carl G · Monmouth, ORBuilt 1988 · S/N 001 N785QJSchachterle Gregg E · Kearney, NEBuilt 2013 · S/N A402PEG N787MCHorton Kevin T · Hamilton, MTBuilt 2005 · S/N 3002 N797BHHeverly Robert M Jr · White Lake, MIS/N 0659 N798SCBender Brian T · Napa, CABuilt 1998 · S/N 98-1841-2SR7 N799DKAntunes Daniel · Evansville, INS/N 5036 N8003VSchafer Daniel J · Oviedo, FLBuilt 1998 · S/N 98-1984-SR7XL N80074Stukel James · Ahmeek, MIBuilt 1996 · S/N 3502 N80098Lingscheit Richard A · Spearfish, SDBuilt 2003 · S/N A186CDR N8016KKoeller Arlene J · Lanark, ILBuilt 2003 · S/N V4A0013 N8018PSyring Leslie J Jr · Belleville, MIBuilt 2000 · S/N A17PQW N8019QGarcia Adam M · Jackson, MIS/N 4641 N8025LKoeller Arlene J · Lanark, ILBuilt 2003 · S/N IPP3-135 N8026AHeatherly Charles · Elizabethtown, NCS/N 6033 N80290Cooper Terry L · Burlington, WIBuilt 2007 · S/N A451 PEG N803DMIrwin Donna Lynn · Sparta, TNBuilt 2007 · S/N A452PEG N80459Kelderman Tom · Oskaloosa, IABuilt 2004 · S/N A01PC N8049UKleine Paul W · Cedar Lake, INBuilt 1999 · S/N 4670 N80510Wangerin Thomas Wayne · Daggett, MIBuilt 1995 · S/N 3344 N8054NBrent Terry D · Foley, ALBuilt 1991 · S/N 093 N8054QFrank Richard E · Bozeman, MTBuilt 2007 · S/N 000539 N80894Abby Air LLC · Abbotsford, WIBuilt 2003 · S/N 81603AA N8098JBuelow Frank B · La Valle, WIBuilt 2007 · S/N SKR0401428 N81141Barnes Orvil · Westville, OKBuilt 1992 · S/N 000505 N811TCHedrick Benjamin A · Winters, CABuilt 2005 · S/N 4759 N812FBAske Karl R · Brainerd, MNBuilt 2007 · S/N 582-850 N816VPKuhns Joseph L · Sullivan, ILBuilt 2017 · S/N A512PEG

Back to Rotax 582DCDI