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.

N2176RSmith Kevin B · Kiefer, OKBuilt 1999 · S/N 992332 N217BMErtl Gregory A · Yuma, AZBuilt 2003 · S/N 582-854 N217CVVarada Carlos R · Toa Alta, PRBuilt 1995 · S/N 06950614 N2184JAlcorta Greg A · Somerset, TXBuilt 2003 · S/N A224PEG N2225WRushing Patrice L · Apopka, FLS/N A427 PEG N22444Davis Dennis R · Walla Walla, WABuilt 1999 · S/N 4667 N2245NHerrmann David R · New London, WIBuilt 2015 · S/N 003 N224ERRicker Eric Charles · Kingston, TNBuilt 2014 · S/N 0297 N22500Fischer James E · West Terre Haute, INBuilt 2001 · S/N 6132 N225ECPrim Peter · Chapin, SCBuilt 1996 · S/N 3568 N226ABAnderson Clayton A · Holmen, WIBuilt 2009 · S/N 4C0610 N2272JKroft John B · Glade Park, COBuilt 1998 · S/N 98-1912 SR7X1 N227EFDelker Daniel M · Buckeye, AZS/N T06018 N228KMPerez Soto Luis Francisco · Dorado, PRS/N 0142 N229AKNielsen Jeffrey E · Warrenville, ILBuilt 2000 · S/N X EX-459 N22GYStayner Guy A · Lake Havasu City, AZBuilt 2009 · S/N 2007-1 N232JVBermudez Roman Jose Simon · Camuy, PRS/N 0170 N234AECovert Paul R · Victorville, CABuilt 2011 · S/N 0253 N2353LGirard Louis W · Schulenburg, TXS/N A-125 POW N235ASWilcox Kyle L · Council Bluffs, IABuilt 1994 · S/N 9407 N2374YBowman Caleb E · Eltopia, WAS/N 2940 N237ABBaxter Robert E · Bend, ORBuilt 2007 · S/N 1002 N237CBMulder David · Galesburg, MIBuilt 2003 · S/N 0075 N239ASHammock Timothy D · Marysville, OHS/N 4816 N242CRDoyon Joel L · Strong, MEBuilt 2000 · S/N 5098 N244DLStout Donald C · Glenpool, OKS/N A-244-PEG N244NIsom Michael G · Sebring, FLBuilt 2014 · S/N 010208 N2479SCarlson James M · Milbank, SDBuilt 2000 · S/N SR7XL-2429 N2481XCross Gary D · Bristol, VABuilt 1998 · S/N 4425 N2482URobison Russell S · Longmont, COBuilt 2002 · S/N A-073PEG N24837Sheehan Ricky E · Little Rock, MSBuilt 1999 · S/N 8231 N2488LGesto James W · Mishawaka, INBuilt 1996 · S/N 3436 N248PWBurns Virgil M · Pasco, WAS/N 0493489 N2493SGongolewski Robert · East Setauket, NYS/N 6168 N2494CThomas Timothy N · Dubois, IDBuilt 1996 · S/N 3469 N2494PKnowles Richard D · Willis, MIBuilt 2006 · S/N 16518 N2494UKrizizke Michael J · Two Rivers, WIBuilt 2004 · S/N IPP4-253 N2495LMohler Dennis E · Topeka, KSBuilt 2003 · S/N 1C0249 N2496JLumbeck Steven N · Oquawka, ILBuilt 2007 · S/N 6058 N2498KGeorge Kevin J · Joplin, MOBuilt 2003 · S/N A 157 PEG N2498TRawlings Randy E · Alton, ILS/N A443PEG N2499UWalker Robert K · Cecil, ARBuilt 2000 · S/N A-141-POW N249ABPierce Phillip L · Gering, NEBuilt 2000 · S/N 4857 N24HEGeer Daniel S · Ledyard, CTBuilt 1993 · S/N 731 N25020Graves Charles L · Joplin, MOBuilt 2002 · S/N A-038 PEG N25021Shoaff Christopher J · Savage, MNBuilt 2006 · S/N 0052 N2502WCharles W Clermont · Lincoln, NHS/N 300450 N2504VSellers Elde S · Grantsville, UTBuilt 2000 · S/N COA26TDA N250PPBolski Martin · Stockton, NJBuilt 2019 · S/N 0295 N2517STevis Aviation Inc · Emporia, KSBuilt 2000 · S/N 1B0154

Back to Rotax 582SER