Skip to content

Registered aircraft · 577

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.

N101ULClay John L · Cambridge, MNBuilt 1999 · S/N 00517 N102GFLeroy Philippe G · Willcox, AZS/N 001 N102JYYobbka Joseph C · Burnham, ILBuilt 1996 · S/N 1135 N103BLandry Anthony H · Port Orchard, WABuilt 2007 · S/N CH2100602762 N105BESpeas Johnathan M · Cartersville, VABuilt 2000 · S/N 001 N105WTSinnot Steven M · Metairie, LABuilt 2003 · S/N 001 N106VXScott Michael J · Lombard, ILBuilt 2006 · S/N 0005 N111JCWalker Mackenzie C · Indianapolis, INBuilt 1994 · S/N 94-0143 N111UFPayne Joseph C · Lafayette, TNS/N CH2-2856 N112EKBenfer Brian L · New Columbia, PABuilt 1998 · S/N 4089 N112JGMeyer Ronald E · Keokuk, IABuilt 2006 · S/N 5743159 N115QBaugh Ty B · Jasper, MOS/N 00052 N116RTMelvin Phillip E · Bluff City, TNBuilt 2004 · S/N 67 N117PGTurner Steven C · Hastings, FLBuilt 2000 · S/N 0301011 N120JAAndriotis John C · Hudson, FLS/N 5016 N121ZWGarcia Alexander · Miami Gardens, FLS/N T01074 N124APSakai Fred · Virginia City, NVBuilt 2008 · S/N 00003 N124JAAndriotis John C · Hudson, FLS/N 4804 N126MBGanuza Diego · North Miami Beach, FLBuilt 1987 · S/N 6025082 N1274Mashy Carolyn T · Sugar Land, TXBuilt 2001 · S/N T-04075 N12911Pekrul Keith R · Posen, MIBuilt 2009 · S/N CH2-1296-1544 N129APFrame Douglas G · Lore City, OHBuilt 2008 · S/N 00002 N12ULScott Dennis L · Tabor City, NCBuilt 2004 · S/N 001 N1315LVerburg Thomas C · Ada, MIBuilt 1995 · S/N 3276 N132RTTilman Robert B · Marathon, FLBuilt 2006 · S/N 0631205 N1350Lindley Eric L · Keokuk, IABuilt 2000 · S/N A013POW N137EEberhardt Daniel T · Adell, WIBuilt 2000 · S/N 6046 N142FSMoore Richard H · Concord, MABuilt 1996 · S/N 001 N142PTLeak Edward V · Cordova, TNBuilt 2007 · S/N CH2-0292-B-0824 N1465RRozinski Tim · Columbus, WIBuilt 2004 · S/N 4C0632 N146RMMullins Richard G · New Richmond, OHBuilt 2005 · S/N 001 N147JLZamora Marco A · Miami Beach, FLBuilt 2004 · S/N 001 N150JTScherer James S · Port Townsend, WABuilt 2006 · S/N 00-2B-001 N1520KTomaszewski Kyle · Medford, ORBuilt 2022 · S/N 2864 N153CPPillman Francis C · Lake Geneva, WIBuilt 1999 · S/N 4498 N153GTWebster Travis C · Erath, LABuilt 2011 · S/N CH2-0206-B-2718 N156MBJensen Lorenzo · Iola, KSBuilt 1998 · S/N 4201 N156SEJensen Jeffery A · Lynchburg, VABuilt 1996 · S/N 3466 N1578MMace Larry · Santa Monica, CABuilt 2006 · S/N 01 N157XTompkins Robert C · Belton, MOBuilt 2003 · S/N A 223 PEG N1610RDenman Jeff B · Hensley, ARBuilt 2003 · S/N SPIRIT XL-2877 N1612WMartin William C · Warrensburg, MOS/N 597 N1618BButh Gary M · Grand Haven, MIBuilt 1997 · S/N 3691 N1658LRossi Christopher S · Gleason, WIBuilt 2024 · S/N 4183 N1659LRossi Christopher S · Gleason, WIS/N 4748 N165RSLewis Landon J · Hope, NDBuilt 2006 · S/N 0165 N1663GMurray Mark J · Georgetown, GAS/N 130 N1666LBaker Rory W · Angleton, TXBuilt 1995 · S/N QKS 122845 N1674TMccammack Clayton D · Cloverdale, INBuilt 2007 · S/N A054SCI N16LEErshler Lewis · Salt Lake City, UTBuilt 2004 · S/N SPIRIT DE-2994

Back to Rotax 582DCDI