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.

N100CSTipton Danny L · Webb, ALBuilt 2007 · S/N CH204951324 N1025ZSayder Ali Al Cevat · San Diego, CABuilt 1996 · S/N 0296 W 0605 N102JCAquino Wayne Lopes · Lake Havasu City, AZBuilt 2003 · S/N 4705 N10342Ross James B · Las Cruces, NMS/N TB1515 N103HKTaylor Roger D · Paris, TNBuilt 2008 · S/N H-SSC-947 N104LHHood Lloyd A · Wasilla, AKBuilt 1998 · S/N 98AK001 N105CECort Wayne B · Vernon, NJS/N 001 N106BLRegistration Pending · Medina, OHRegistration pendingBuilt 2020 · S/N 0649 N108RGTipton William M · Burlington, NCBuilt 2000 · S/N SRII 007 N109RHBurgess Terry A · Spray, ORBuilt 2007 · S/N 672 N110ZXHardesty Eugene P · Little Chute, WIBuilt 2009 · S/N 8307 N1113WMckusick Cassidy · Winooski, VTBuilt 2005 · S/N 101403095 N112CLSale Reported · Marseilles, ILSale reportedS/N 94-01 N117ZZDorazio Robert · Winooski, VTS/N 751 N119HBHarris Brock E · Chelan, WABuilt 2002 · S/N CH209971653BH N120LFFrehafer Glenn A · Spring Valley, CABuilt 1984 · S/N 1042 N120UFOrf Gary W · Middletown, MOBuilt 2015 · S/N CH2-0514-CW-2904 N124ZXHemphill Charles E · Cleburne, TXBuilt 2002 · S/N 006098 N125VTHarris Roy · Wasilla, AKBuilt 2013 · S/N CH2-0684B0125 N125WDWhitley William E · High Springs, FLBuilt 2007 · S/N CH2-0899-1896 N126BWBock Bryce K · Longwood, FLBuilt 1983 · S/N A276-503 N1284DDrebick Montgomery A · Olympia, WABuilt 2007 · S/N 001 N129AYParker Richard E · Greenfield, NHBuilt 2006 · S/N CH2-0206-2719 N134ERoark Thomas M · Malvern, ARBuilt 2004 · S/N CH2-0402-B-2212 N134JMMines Joseph · Palm Coast, FLS/N 2115 N134PCBrooker Bruce · Bemus Point, NYBuilt 2003 · S/N 006132 N138JBJarvis Christopher D · Leyden, MAS/N F1079 N139SWWhitley William E · High Springs, FLBuilt 2002 · S/N 14BSW N140JLGrubb Benjamin W · Veneta, ORBuilt 1992 · S/N 0392019 N141TLHeck John G · Spring Hill, FLS/N CH2-0710-Y-2881 N142DHBrown Timothy R · Saint Louis, MOBuilt 2000 · S/N 7717 N142KJEms Kenneth R · Biloxi, MSBuilt 2008 · S/N 2702 N1453FZechmann Casey M · Grangeville, IDS/N 001 N145JBWelch John T · Texarkana, TXBuilt 2006 · S/N WH1998 N147PMZapara Dale A · Stockton, CABuilt 2007 · S/N CH2-1002-2694 N148LSKuwait International Aircraft Leasing Inc · Wilmington, DEBuilt 1999 · S/N CH2-0599-R-1880 N1509GHawkins Garry B · Salome, AZBuilt 1995 · S/N 2004 N1516LLinback Kenneth R · Niles, MIBuilt 1997 · S/N CH2-0694-1167 N152ULBenson Howard R · Medford, ORBuilt 2003 · S/N 35196 N153DDDye Dennis Lyle · Marietta, OHBuilt 2017 · S/N FS15-4-00099 N153JCCaughey Jack A · Charlotte, MIBuilt 2007 · S/N 02223X3 N157HTThresher Harry L · Belton, MOBuilt 2010 · S/N CH2-0287-B-0233 N1610NAdams Jonathan Glenn · Conyers, GABuilt 2004 · S/N 503-919 N164ZXNelson Eric D · Creston, WABuilt 1999 · S/N CH2-01991839 N1655EMiller Mark J · Sheridan, ILBuilt 1993 · S/N FS-859 N1666RClow Dana R · Hillsborough, NHBuilt 2008 · S/N CH2-0899-1897 N1673LHart Lyman E Jr · New Canton, VABuilt 2001 · S/N 7718 N1689Defreece Tony · Battle Ground, WABuilt 2002 · S/N CB 1149 N169ADavy Robert R · Greene, NYBuilt 2000 · S/N FS003000044 N16VEKashefi Joseph A · Sherman Oaks, CAS/N 001

Back to Rotax 503 DCDI