Skip to content

Registered aircraft · 135

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 ('55576')
  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 ('55576')
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.

N40203Powell Robert L · Lakeville, MNBuilt 2007 · S/N 1212 N4278EWebber Alvin R · Valley Springs, CABuilt 1997 · S/N 028700219 N43436Harley Jean K · Berkley, MAS/N P-98 N4350PSale Reported · Holley, NYSale reportedS/N 90128 N4360USahagun Salvador · Bothell, WABuilt 1997 · S/N 1948 N4362ASahagun Salvador G · Bothell, WAS/N 001 N4385HButler Gaylord A · Baltimore, MDBuilt 1996 · S/N 6235601 N43881Allen William T · Hawarden, IABuilt 1996 · S/N 1094-0510 N4431ERoberson Kenneth S · Halifax, NCBuilt 1986 · S/N 97142K N4443GNaylor Thomas F · Cave Junction, ORBuilt 1995 · S/N 342 N44551Moler Alan D · Valley Center, KSBuilt 1997 · S/N AB152 N447ASSmith Nathan A · Selbyville, DEBuilt 1994 · S/N H-SSC-945-R447-TRI N447GDDonohue Garry · Pt Pleasant, NJBuilt 2004 · S/N 001 N447RXPeschek Christopher · Hensley, ARBuilt 1996 · S/N AB-20 N447THGomez Lazaro A · Orlando, FLBuilt 1998 · S/N T408 N447TSSheldon Maurice A · Maricopa, AZBuilt 1999 · S/N 001 N4521GNevers James L · Fayetteville, NCBuilt 1995 · S/N 0295 0550 N4601FSearby Steve E · Lena, ILBuilt 1995 · S/N SS001 N463MBButts Michael P · Dartmouth, MABuilt 2008 · S/N RW278 N4735BDemunck Robert J · Allen, TXS/N 0501-CW-0755 N4746SSmith Steven B · Hudson, INBuilt 2012 · S/N 226 N476CDHewett Charles · Mountlake Terrace, WAS/N 244 N48EPPitman Edgar D · Corning, CABuilt 1990 · S/N SABRE 006 N48UGDierker Robert R · Chestertown, MDBuilt 2005 · S/N 10021805 N504MFortenberry James P · Gautier, MSBuilt 2005 · S/N 504M-1 N507BBBrower Bruce D · Black River Falls, WIBuilt 2007 · S/N 001 N5100BDunham Thomas D · Baker City, ORS/N 789 N5136FSchultz Bradley J · Longmont, COS/N 2801022 N5154EClement Jeffery A · Abilene, TXBuilt 1996 · S/N FS1002 N51GDLehman David M · Scottsburg, ORS/N GT2801191 N539JPEldridge Donald · Jewett City, CTS/N 001 N539RWCook Roy H · Springboro, OHBuilt 2016 · S/N 001 N5602BFournerat Kevin T · Vidor, TXBuilt 1980 · S/N 494 N56146Simonson David C · Iron River, WIBuilt 2008 · S/N GT-3499015 N5631VJessie James C · Jonesborough, TNBuilt 2005 · S/N JDT81 N5678MEngle David N · Central Square, NYBuilt 2003 · S/N 2803 N56995Cannizzaro Michael · Southwick, MABuilt 1994 · S/N 001 N57WLMisenheimer Gary · Newton, NCBuilt 2016 · S/N 057 N59JWCastleman Thomas G · League City, TXBuilt 2016 · S/N 1 N603AGGoring Brandon W · Camdenton, MOS/N 1002 N61478King John D · Midland, VABuilt 1997 · S/N 012996024 N614AGGirard Richard N · Udall, KSBuilt 2008 · S/N 1004 N6169AKreling Jack R · Mattawan, MIBuilt 1983 · S/N PH00150 N629EFQuitoriano Don · Queen Creek, AZBuilt 1994 · S/N 0893CW0440 N63791Wolfe Jonathan L · Kansas City, MOBuilt 2012 · S/N FF03100031 N65054Noga Gwain J · Youngstown, OHBuilt 2007 · S/N 7GRIZ202CUB N6506KNoga Gwain J · Youngstown, OHBuilt 2010 · S/N HMSNMKY5607 N65EPDahrens Virgil L · Troutdale, ORBuilt 2005 · S/N SPORT292 N67DTTevis Air LLC · Emporia, KSBuilt 2015 · S/N TA20 N69YEHoff Jesse K · Mariposa, CAS/N 001

Back to Rotax 447