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.

N3739VFord Bill · Kentland, INBuilt 2003 · S/N CH2-0903-2374 N373RFFairchild Ralph B · Wausau, WIBuilt 2019 · S/N CH2-0203-2298 N3746SMurtha Justin P · Woodville, WIBuilt 1995 · S/N 318 N375HHEnsley Jeremy P · Colfax, WABuilt 2007 · S/N FS06-2-00081 N3773CGarley Benjamin J · Chetek, WIBuilt 2015 · S/N 001 N3792AKeller Andrew P · La Grange, KYBuilt 1996 · S/N F 1169 N379PXAnderson Donald A · Kiel, WIFirst renewal noticeBuilt 2012 · S/N 001 N3803VHardy J Houston · Columbus, MSBuilt 2005 · S/N 0491 N380JMFoglesong Kurt A · Glenn, CABuilt 2004 · S/N GT 2801493 N382PCDarke John B · Punta Gorda, FLBuilt 2007 · S/N 81406 N38BVVolcko William S · Skaneateles, NYBuilt 1991 · S/N CH2 03910674 N3900AStith Terry J · Wurtland, KYBuilt 1998 · S/N 1120 N395TXMcmillan Dennis C · Carthage, TXBuilt 1985 · S/N 395 N396RBHottois Scott A · Whittemore, MIBuilt 1995 · S/N CH1CWR8M4Z6X N3973VDerrig Greg J · College Station, TXBuilt 2002 · S/N M5446091 N400GVPritzel Charles L · Palmyra, WIBuilt 2007 · S/N 1275 N4020HPowell Robert L · Lakeville, MNBuilt 2007 · S/N 1115 N40298Brezinsky David A · Fond Du Lac, WIBuilt 2007 · S/N 97-1821-2 N405ACRichardson Robert W · Bedford, INBuilt 2020 · S/N CH208951383 N4124TFlora Raymond · De Leon, TXBuilt 1998 · S/N 4382 N4145SPaine Brian P · Enterprise, ALBuilt 1999 · S/N CH203951314 N414LSGras William C · Lexington, OKBuilt 2004 · S/N CH2-01032294 N416BRykard Roger A · Iron City, GABuilt 2007 · S/N CH2-1095-1403 N420KPSavener Eric D · Kingsland, TXBuilt 1987 · S/N 1122 N424NSSchiller Douglas J · Oregon, ILBuilt 2013 · S/N CH2-0107-LSS-0121 N424RLLemon Ronald L · Concrete, WABuilt 2017 · S/N 001 N426RFFernandez Robert · Byron, ILBuilt 2000 · S/N 1B0093 N42767Barahona Claudio O · West New York, NJS/N 26112 N4292GStoecker Kevin E · Mobridge, SDBuilt 2001 · S/N 1293-0457 N43132Eddy James E · Laporte, INBuilt 2006 · S/N 71862 N43332Orton Leon J · Nibley, UTS/N 001 N434LBHammarback James A · Winston Salem, NCBuilt 2007 · S/N LB CH2 0207 98763 N4374ATpi Aviation LLC · Germantown, WIS/N CH205012093 N4378ALarose John E · West Glover, VTBuilt 1991 · S/N CH21910757 N4393GGuido Gino G · San Antonio, TXBuilt 1985 · S/N GT 2801086 N439EPNolen Charles W · Fayette, ALBuilt 2010 · S/N TTS 040 N43TGDavies Elizabeth V · Austin, TXS/N 7001 N4404GRegistered aircraftAssigned, pending cancellationS/N CH 20 5951 344 N4406KFischer James H · Wisconsin Rapids, WIBuilt 1994 · S/N FS KXP 5543 N4407GMurray Mark J · Georgetown, GABuilt 2007 · S/N 19692 N44152Watkins Richard L · Bellevue, NES/N CH2-1298-CW-1811 N441MSSchumacher Michael · Sidney, ILBuilt 2004 · S/N CH2-1200-CW-2039 N4430APeachey Samuel R · Belleville, PABuilt 2009 · S/N F 1258 N4433HUhlry Jay Clark · Gladstone, ORBuilt 1996 · S/N 121260 N444FBSchendel Thomas A · Brighton, MIBuilt 2003 · S/N 1 N445WSCaleca Paul T · Los Lunas, NMS/N 200 N446RCCronk Russell D · Big Bear City, CABuilt 1993 · S/N 446 N4493GHeinitz Bradford C · Arlington, WAS/N 9119 N453GBradburn Michael · Moselle, MSS/N CH2-0988-W-0361 N453MJBurgdorf Brandon M · Evansville, INBuilt 2008 · S/N H-SSA-897-R503-TRI

Back to Rotax 503 DCDI