Skip to content

Registered aircraft · 1,193

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

N13LZDusek Robert N II · Solebury, PABuilt 2003 · S/N F4A0046 N13YWSahni Irvin · Seguin, TXBuilt 2006 · S/N PC070653W306 N140ALDuran-Wyzisk Marco A · Plant City, FLS/N 893-A N140SEAchor James D · Converse, INS/N A-040PEG N140TRRegistration Pending · Iuka, MSRegistration pendingBuilt 2012 · S/N CH2-0811-LSS-L650195 N141HKStrang Jeffrey R · Orrington, MES/N 0206 N142SECowan Herb · Round Rock, TXS/N 2200 N143KKKrettler Frank · Cary, ILBuilt 2004 · S/N 31298 N143SCMerritt Geoffrey T · College Place, WABuilt 2007 · S/N 3051 N143SEHarter Chris D · San Mateo, CABuilt 2000 · S/N B21445 N147DGGeise Todd J · Milton, PABuilt 1998 · S/N 4318 N148AJN504fl LLC · Killeen, TXBuilt 2011 · S/N 0257 N1490Saavedra Gilberto · Quebradillas, PRS/N 0157 N149MBBrillhart Matthew M · Bonner Springs, KSBuilt 2002 · S/N SPIRIT XL-2833 N149TTFox Jack G · Swartz Creek, MIS/N 3348 N149ZXHoward Michael D · Groveland, FLS/N 582-693 N14RZButt Alan K · Chesapeake, VABuilt 2016 · S/N CH2-0412-LSS-L65-0212 N150RADunagan David T · Canton, TXBuilt 2000 · S/N 1B045 N1525MBridger Shawn D · Pocatello, IDS/N A312PEG N153DHTurner Richard W · Gaffney, SCBuilt 2006 · S/N 61241051306 N155JTWelch Robert A · Greenfield, INS/N 1292948 N1561Surf Aviation · Lake Havasu City, AZS/N 0273 N1562Williams Timothy A · Lyons, ORS/N 992277SR7XL N156SCWhitley Randy · Carlsbad, NMS/N 3095 N15704Chirico Angelo M · Longs, SCBuilt 2007 · S/N 1C0252 N158FWThompson Brian R · Bethlehem, NHBuilt 2002 · S/N 3C0439 N158SCWaters Gwen M · Valley Falls, NYBuilt 2009 · S/N 3098 N160ASHunt Larry D · Garfield, WABuilt 2002 · S/N 2774 N161CPStokesberry Cecil F · Sagle, IDBuilt 2008 · S/N 1451 N1637Hopson Audie L · Haleyville, ALBuilt 1995 · S/N 0016 N163RCIrvine Robin R · Ravenna, NEBuilt 2000 · S/N A114 POW N1648Accettola Frank J · Napa, CABuilt 1995 · S/N E-162 N1651LHutchison Joe R · Howard, KSBuilt 1999 · S/N 4561 N1659CFlorida Hang Gliding Inc · Davenport, FLBuilt 2007 · S/N 001 N1659SWeesner David F · Apache Junction, AZBuilt 2006 · S/N PC 120553W302 N165LSNeiman John W · Santa Fe, NMBuilt 2008 · S/N 04970790 N165SMFlatland Harold · Cresco, IABuilt 2004 · S/N 85306 N1661CStansbury Tony DBA · Rincon, GABuilt 2007 · S/N A435PEG N16630Woodriff R Lee Dr · O Brien, FLBuilt 2001 · S/N A003FAA N1663LWoodriff R Lee Dr · O Brien, FLBuilt 2004 · S/N H20018 N1665LSchmitt Steven A · Rochester, MNBuilt 2006 · S/N 0546 N166LSGonzalez Jorge · Cicero, ILBuilt 2005 · S/N 02020942 N168SCStalter Luther · Cooperstown, NYBuilt 2008 · S/N 3082 N16ZXMyers Scott James · Sebewaing, MIBuilt 1998 · S/N 4379 N1727BBardin William D · Sacramento, CABuilt 2014 · S/N 0960 N1753CDebord Ricky L · Taylorsville, KYBuilt 2003 · S/N A-008 PEG N1775LMahan Clifton R Jr · Pemaquid, MES/N 2017 N1775PLurvey Anthony J · Lake Jackson, TXBuilt 2007 · S/N 000640 MXLII SPORT N1780SSlade Scott N · Marysville, WAS/N SNS01 N1788LKarevoll John R · Running Springs, CAS/N 4141 MEO

Back to Rotax 582SER