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.

N787SMMock Stephen R · Sapulpa, OKBuilt 1996 · S/N 1 N7894KLockepaddon Kenneth · Watsonville, CABuilt 2007 · S/N 001 N795ESSales Michael B · Westminster, COBuilt 2017 · S/N T95503SOHK0143 N797AKCampbell Paul M · Parsons, TNBuilt 2003 · S/N 503-789 N797HSClarry Bradford D · Syracuse, NYBuilt 2007 · S/N 5853 N7ULTaylor Aviation Inc · North Aurora, ILBuilt 2005 · S/N AM5446377 N8000QDoyne Michael E · Gary, INBuilt 1997 · S/N F1182 N800LWWilson Leslie · Terry, MSBuilt 2008 · S/N B 212 N8021FHablutzel Ronnie E · Upper Lake, CABuilt 2005 · S/N 574123109 N80274Jackson Andrew W · Franklin, GABuilt 1998 · S/N 00749 N8029UVazquez Jorge L · Browns Mills, NJBuilt 2004 · S/N CH11012148 N80360Baswell Paul T · Loxley, ALBuilt 1985 · S/N ME001 N8038QHoeppner James C · Whitewater, WIBuilt 2007 · S/N E085 N8039YJohnson Mark D · Phoenix, AZBuilt 2002 · S/N 503708 N80422Erickson Joshua J · Union Grove, WIBuilt 1998 · S/N 98013 N80450Mock John L · Fullerton, CABuilt 1994 · S/N 101 N80466Bonnel Maurice W · Novinger, MOBuilt 1994 · S/N CH20894B1198 N8049FElliott Earl D · Memphis, TXBuilt 1988 · S/N 94576 N80538Peeler James K · Cherryville, NCBuilt 1994 · S/N 21-1 N80559Seal Jerry W · Westlake, LABuilt 1985 · S/N JS6869 N80574Benedict Samuel R · Elberta, ALBuilt 1997 · S/N SB006 N8058PSellars Robert L · Iowa, LABuilt 1984 · S/N 18500489 N8064ABenedict Samuel R · Elberta, ALBuilt 1992 · S/N SB005 N80812Ackland Les E · Albert Lea, MNBuilt 2007 · S/N T94XXXCOHK 0112 N8083EHillman David L · Centennial, COS/N 0392016 N80857Brunson Franklin D · Union Springs, ALBuilt 1993 · S/N MXL II SPORT 000491 N8109England Steven C · Hampton, NHS/N CH2-1106-2765 N8113YMcmullen Danny L · Thomasville, GAS/N 0038 N811EEGilbert Thoms J · Morrison, OKBuilt 1996 · S/N FS-002 N817RSSmith Ronald C · Spiceland, INBuilt 2007 · S/N 001 N826BPPowell James A · Zanesville, OHBuilt 2017 · S/N FS1041 N827BACooper Fletcher Mcknight · Coppell, TXBuilt 2008 · S/N CH2-1206-LSS-0013 N829BHChapman Robert L · Skowhegan, MEBuilt 2004 · S/N MAX SKYRANGER N83BKKoza Williams J · Albert Lea, MNBuilt 2007 · S/N 001 N842SCHarris Jamie L · Newland, NCS/N 317 N8507TSwanson Timmy J · Lynd, MNBuilt 1999 · S/N 02157 N8507VHiggins Kenneth R · Flippin, ARBuilt 2004 · S/N T03503S0HK0463 N8560RSmooth Flyers LLC · Athens, GAFirst renewal noticeS/N 503-1026 N8595XMurphy Don · Harvel, ILBuilt 2008 · S/N CH2-1202-CN-2282 N8602XDodd Reece W · Pittsboro, INBuilt 1990 · S/N 071958 N86030Miller Thomas E · San Diego, CABuilt 1992 · S/N HUR-001 N8604LMiller Thomas E · San Diego, CABuilt 1997 · S/N HUR-100 N8607EPelikan Baye Aviation LLC · Saint Charles, MOFirst renewal noticeBuilt 2003 · S/N CH2-0503-2319 N8607ZKeyes Matthew P · Eau Claire, WIBuilt 2007 · S/N 332 N8608YMccallister Shawn D · Hendersonville, NCBuilt 2007 · S/N 0801-CW-0760 N8614ZSlack Stephen J · Fort Wayne, INBuilt 2000 · S/N 2000-123 N862PLoeppert Peter Verne · Durand, ILBuilt 2000 · S/N T00037 N864RCByler Jonathan P · Inman, SCBuilt 1999 · S/N CH2 0499-B-1868 N8756VSensenig Vicki L · Tucumcari, NMBuilt 2019 · S/N 8-2019-68 N876SRGeissler Arthur D · Louisville, KYBuilt 2006 · S/N CH2-1097-1677

Back to Rotax 503 DCDI