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.

N45575Santamarina Noe · Cocoa, FLS/N 1 N455TTomljanovich Timothy R · Byron, ILBuilt 1998 · S/N 9818T N458HHHolzheimer David L · Montevideo, MNBuilt 2013 · S/N CH1-1110-2887 N459FFitt John R · Sebastopol, CABuilt 2019 · S/N FS II-459 N465CHCh20396w1465 LLC · Bruce Twp, MIBuilt 1996 · S/N CH20396W1465 N466XSSchultz Daniel M · Ticonderoga, NYBuilt 2012 · S/N 001 N46DNNicoson David H · East Troy, WIBuilt 2000 · S/N 2419 N46LRLiles Robert G · Arlington, TXBuilt 2016 · S/N 90002 N4702TCarlin David · Agoura Hills, CABuilt 2000 · S/N 001 N4741GSmith George E · Tulsa, OKBuilt 2007 · S/N 001 N4750Farrell Stan · Rockland, MEBuilt 2002 · S/N 000075 N480PBBell Homer K · Hillsboro, OHBuilt 2013 · S/N CH2-1293-1066 N4834FTchop Robert W · Chetek, WIBuilt 1994 · S/N 94-1186 N484CBPerkins William E · Louisville, KYS/N 1195B0592 N4877EBarnett Tom · Apple Valley, CABuilt 2000 · S/N 886 N48ECAsher Todd A · Martinsville, INBuilt 1999 · S/N 7562 N497DHMoore Brandt J · Tucson, AZBuilt 1997 · S/N 64134 N499ECCollins Russell David · Mountain Home, ARBuilt 2014 · S/N CH2-1201-2158 N49LZZimmerman Lawrence · Glen Ellyn, ILBuilt 2012 · S/N 1 N503AKHood Lloyd A · Wasilla, AKBuilt 2000 · S/N ANT159 N503BPJones Roger Travis · Reno, NVBuilt 2005 · S/N 001 N503DBTorres Kilgore Pablo L · Orlando, FLBuilt 2007 · S/N CH2-0397-1586 N503DFReynolds Jackye S · Raleigh, NCBuilt 2009 · S/N 001 N503DKKroesch Donald F · Minooka, ILBuilt 2001 · S/N CH20198-1705 N503FCBeetler Brooke A · Lake Park, FLBuilt 2001 · S/N 001 N503GCVandiver Christopher B · Raiford, FLBuilt 2003 · S/N CH2-1001-2141 N503HWRawlings Randy E · Alton, ILBuilt 2007 · S/N GT2801486 N503MBPoole Frederick J · Meridian, MSBuilt 2001 · S/N AU001 N503MSSchnabel Michael · Manchester, TNBuilt 2001 · S/N FS00 4 0052 N503PGFerguson Douglas B · Weed, CABuilt 1997 · S/N 35642 N503XTHaas Edward A · House Springs, MOBuilt 2005 · S/N EX-503-1018 N5050UBraswell Richard Earl · Mobile, ALBuilt 2004 · S/N C82-0203-2305 N50548Wingersky Michael C · Mesa, AZS/N NB1 N50681Iler Everett L Jr · Charleston, SCS/N 0300010 N5069YNorris Onel · Carolina, PRBuilt 2000 · S/N LROR-01 N5074JSmart Mark D · Imler, PABuilt 2002 · S/N 070702 N5076GPeacock Stacey R · Temple, TXBuilt 2006 · S/N 014 N5080KLee Raymond H · Buffalo Gap, TXBuilt 2007 · S/N CH2-1005-2674 N50903Lebeau John M · High Point, NCBuilt 2000 · S/N 303 N510RAAnderson Rickey H · Memphis, TNS/N 438 N5119VChamberlain Rex A · Hickory, NCBuilt 2006 · S/N CH20893R1009 N511GPVarilek Jerry L · Lamar, NEBuilt 2003 · S/N HSSA-PLUS-943-R503 TD N512DMuri Dennis W · Billings, MTS/N CH2-1005-CW-2680 N512JXPeter Mccaffrey · Maysville, GAS/N HSSC941R503TRI N512LMMarshall Adam J · Frankfort, KYS/N 7585 N51431Pittman Stuart P · Palisade, COBuilt 2001 · S/N 1117 N5148RWebb Howard A III · Clermont, FLBuilt 1984 · S/N 2001-HW1 N515YTEggers Benjamin D · Cumberland Furnace, TNBuilt 1993 · S/N CHII-0493-B-0967 N5161VKlein Jerry L · Athens, MIBuilt 2007 · S/N 647 N51641Maas Harvey L · Poplar, WIS/N 306

Back to Rotax 503 DCDI