Skip to content

Registered aircraft · 561

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

N2963ABorkholder Olen · Milford, INS/N 171 N2967ASmith James G · Euless, TXBuilt 2000 · S/N 1473 N29990Byler Jonathan P · Inman, SCBuilt 1991 · S/N T915030HF0006 N299KWWork Kevin D · Mc Ewen, TNBuilt 2013 · S/N CH2-0809-CW-2867 N3010FMashburn James · Bono, ARBuilt 2002 · S/N 2430 N3039GBarnd Dennis A · Lancaster, OHBuilt 2001 · S/N CH2-0798-1768 N303CWJesse Charles W · Shelbyville, ILBuilt 1997 · S/N CH2-0896-B1514 N30438Gossett Daniel D · Xenia, OHBuilt 2003 · S/N CH2 1102 B 2279 N304CDBerson William J · Port Townsend, WABuilt 1995 · S/N 484 N304RTHartpence Darian K · Newcastle, OKBuilt 2007 · S/N 892 N3064JHowell Aviation LLC · Orlando, FLS/N T00009 N3064LLittle Michael M · Summerville, GABuilt 2001 · S/N 7803 N3090JDaley Richard S · Waimea, HIBuilt 1994 · S/N 648 N3094KReed Robert A · Bowie, TXS/N 0904-CW-0789 N30PVKelly Cynthia · Sealy, TXS/N GT2801208 N31219High George C · Waverly, ALBuilt 2002 · S/N 9945 N312GLishtle Chester · Richland, MSBuilt 1996 · S/N 755 N3145Edwards James R · Russellville, ARBuilt 1968 · S/N 5658 N315TCSteichen Lyle C · Ulen, MNBuilt 2007 · S/N JU6-022803-15 N31601Perry James R · Stanton, MIS/N 001 N31622Registration Pending · Natchitoches, LARegistration pending, pending cancellationBuilt 1999 · S/N 961440 N3176GBranham Christopher R · Georgetown, TXS/N GT2801474 N320CKCooper Kristopher A · Hamersville, OHBuilt 2008 · S/N 01990716 N324DPHodge Matthew S · Eldridge, IABuilt 2014 · S/N CH2-0803-2356 N327SLWickes Chad D · Newmanstown, PAS/N FS1001 N3284QMarks William F · Neshkoro, WIBuilt 2002 · S/N CH2-0401-2069 N3284SMccarren Rory R · St George, UTBuilt 2006 · S/N SR083 N331RTTipton Danny L · Webb, ALBuilt 2007 · S/N CH2-0601-2105 N3471Thomas Robert · Fort Atkinson, WIBuilt 2014 · S/N CH2-0705-2657 N348SMDalka Dennis J · Rhinelander, WIBuilt 2008 · S/N CH0490O0302RM N34FSMethvin George B Jr · Woodstock, GABuilt 2000 · S/N 269 N34MGGraber Michael L · Adel, IABuilt 1999 · S/N 777341 N35023Cross Keith A · Quinnesec, MIBuilt 1997 · S/N 3683 N3503UStrickler Dennis L · Malvern, OHBuilt 1996 · S/N 610 N35135Gilbert Thomas Jeffery · Morrison, OKBuilt 2001 · S/N 001 N35150Buchholz William C · Saint Charles, MOBuilt 1984 · S/N 60091 N35154Enabnit Allen J · Clear Lake, IABuilt 2007 · S/N T95503SOHK0164A N35172Sullivan Stephen G · Mize, MSBuilt 2001 · S/N AS 20012 N3518TGriesman Scott W Jr · Phoenix, AZBuilt 2007 · S/N F-1274 N3519QBerry Bob A · La Center, KYBuilt 1995 · S/N F1042 N35234Johnson Mark R · Concord, NHBuilt 2001 · S/N 503-579 N354CDBeardsley David A · Arlington, WABuilt 2008 · S/N F 1205 N3551DLibby Daniel F · Maximo, OHBuilt 1983 · S/N 313 N3554ALin Jason · Buena Park, CAS/N 443 N356PSCobb Henry H · Pike Road, ALBuilt 2017 · S/N CH2-0301-2063 N3638DFalcone Tony J · Thousand Oaks, CABuilt 1997 · S/N CH2-0497-CW-1605 N367DMKc Aviation Aeroclub LLC · Plantation, FLBuilt 2006 · S/N 1236-0100-7-W1029 N370BPLove Charles R M · Hague, VAS/N CH2-0907-LSS-0136 N372TFRicard Jon S · Republic, WABuilt 2009 · S/N CH2-0804-2512 N3733UCarriere Michael J · Church Point, LABuilt 2009 · S/N GT364

Back to Rotax 503 DCDI