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.

N234CGGrembowicz Conrad G · Peoria, ILBuilt 1997 · S/N 001 N234FDMednick Phillip · Odessa, FLBuilt 1996 · S/N 2561705 N235AWPhillips Scott · Morganton, GABuilt 1991 · S/N 0691003 N239WPDeschler Karl · Byers, COBuilt 2005 · S/N CH2-2398 N241PWWeinacker Charles W · Robertsdale, ALBuilt 2007 · S/N 1477 N2480YGray David M · Albuquerque, NMBuilt 1996 · S/N CH20394-4139 N2481VGeiser Franklin S · Dalton, OHBuilt 1988 · S/N 001 N24860Eshuis Herman · Lake City, FLS/N H-860-55A-503-TRI N2486ZMclain Justin · Covington, INBuilt 1998 · S/N 4299 N248DEKane Donald K · Seattle, WABuilt 1997 · S/N 970723JA N2491ZWarren David E · Chillicothe, MOS/N CH2-1195-B-1423 N2493UBalko David G · Pensacola, FLBuilt 1993 · S/N F1161 N2494XParham John B III · Saint Marys, GAS/N 00-2B-003 N2494YKesler Gilbert L (Pete) Jr · Florence, COBuilt 1998 · S/N 001 N2522YRoland Paul A · Esmond, ILBuilt 1999 · S/N 7551 N2532NTom Dodson LLC · Leonard, OKS/N 97-1706-2SR7 N2534CRobertson Johnny T · Slaton, TXBuilt 2004 · S/N DE001 N2534JBuchanan Tom L · Curtiss, WIBuilt 2000 · S/N 301092385 N2542AParrish John W · Punta Gorda, FLBuilt 1992 · S/N 0392-0829 N2543TKersey Larry M · Doniphan, MOBuilt 2007 · S/N CH2-0505-2629 N2550ERichards Douglas A · Cookeville, TNBuilt 2005 · S/N CH2-2373 N2551YWallace David N · Elko, NVBuilt 2001 · S/N CH2-1100-2028 N2552SWilkins Peter E · Kalamazoo, MIFirst renewal noticeBuilt 1984 · S/N 602 N25686Clark Stanley · Plymouth, ILBuilt 2007 · S/N CH983074 N2587TLambdin William M · Amherst, VABuilt 2003 · S/N 10-SP N260DBKlebenow Jeffery J · Casa Grande, AZBuilt 2010 · S/N DBS01 N2610TWroe Daniel · Denton, MDBuilt 1996 · S/N C2-0196-0-1445 N2614TBowman Doug W DBA · Pasco, WABuilt 1995 · S/N RVHOM04 N2615TPenrod James L · Farmington, NMS/N BJPOM04 N2617EDemuth John J · Eufaula, ALBuilt 2002 · S/N 1C0285 N26346Harris Norman W · Needles, CABuilt 2004 · S/N 5148 N2635FStewart Robert C · John Day, ORBuilt 1984 · S/N 1044 N2636EWehrman Don Clifford · Everett, WAS/N 2000 N2641TCarter David W · Nenana, AKS/N 1965 N2643THudgins John M · Era, TXBuilt 1998 · S/N 2071 N2647TBucy Rick D · Murray, KYS/N 020378 N2678PVolk James E · Argyle, TXBuilt 2004 · S/N GT2810492 N2694RBracey Robert B Jr · Smithfield, VABuilt 2008 · S/N CH2-0101-2053 N2710NSmetana Michael A · Banks, ORBuilt 2002 · S/N GT 280 1478 N271SWJernigan Jonathan · Ben Wheeler, TXBuilt 2004 · S/N RR2005000 N2736AHummel Jeffery L · Demotte, INBuilt 1997 · S/N T97460FCOHK0282 N2753Masterson Paul C · Windsor, MOS/N 98266 N279JDSingleton Addison · New Bedford, MABuilt 2003 · S/N 001 N279SDCox Jimmy B · Beaumont, TXBuilt 2025 · S/N 00290 N2812Sky Knights Flight Club · Thousand Oaks, CABuilt 2001 · S/N 0001763 N2825NErickson Joshua J · Union Grove, WIBuilt 1988 · S/N XP-50398 N289MNCampbell James A · What Cheer, IABuilt 2015 · S/N 2089 N28LNTeynor Jason J · Ontario, WIBuilt 2007 · S/N CH2-1005-CW-2689 N291BDDombrowski Byron D II · Phoenix, AZBuilt 2011 · S/N CH2-0906-2760 N293JPPilon James G · Lawton, OKBuilt 2007 · S/N CH2-0793-B1002

Back to Rotax 503 DCDI