Skip to content

Registered aircraft · 1,193

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 ('55556')
  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 ('55556')
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.

N2615CTomulet Marin C · Quinlan, TXBuilt 1999 · S/N 4439 N2616HBryan Paul S · Lake City, FLBuilt 2007 · S/N 582-766 N261DKClampitt Kent V · Eckert, COBuilt 2006 · S/N SCI0492006 N2620RDaffin Robert Vance III · New Waverly, TXFirst renewal noticeBuilt 2004 · S/N A-279-PEG N2628EWilson Matthew B · Apollo Beach, FLBuilt 2004 · S/N 14752 N2628ROlcott Laurianne M · Rumney, NHBuilt 2001 · S/N HD00039M N2628TMiller Nathan · Irwin, OHBuilt 2007 · S/N 4900 N2629ELong William E · Old Town, FLBuilt 2004 · S/N 16265 N2630WWixson Homer G · Alpine, NYBuilt 2002 · S/N 0892266 N2632TRicklick Kevin R · Tavernier, FLBuilt 2007 · S/N IT-LOM E3568F606 N2638THolzaepfel Stan D · Baytown, TXBuilt 2007 · S/N SPORT 2S #0211 N2640EJustice Mike · Suffolk, VABuilt 2000 · S/N 1B0187 N2645PDawson John H · Claremore, OKBuilt 1999 · S/N 992117SR7XL N2649BGraham Austin J · Belton, TXS/N 0692236 N2649ECrider Vernon Dwayne · Imperial, MOS/N 1B0156 N264JLong James L · Berryton, KSBuilt 2001 · S/N PC261 N2652MHyatt Philip F · Carson City, NVBuilt 2002 · S/N 582-723 N2653ACampbell Kenneth W · Lincoln, CABuilt 1997 · S/N 4655503 N2656PSturdivant Steven R · West Monroe, LABuilt 2014 · S/N 16306 N265SShaw Christopher L · Hondo, TXBuilt 1996 · S/N 006 N2666AMurphy Lawrence L · Shepherd, TXBuilt 2007 · S/N PC09753W401 N2667EFox Darrell D · Paauilo, HIBuilt 2002 · S/N 1949855 N266BKKreikemeier Bruce A · Altamont, TNBuilt 2006 · S/N 001 N2673FBlain Gregg E · Odessa, TXBuilt 2008 · S/N PC010853W407 N2674AGill Glenn L · Weston, OHBuilt 2003 · S/N 16372 N2681EHenry David L · Denton, TXBuilt 2002 · S/N 582-798 N2693CKimbrell Stanley Ernest · Pulaski, TNBuilt 2007 · S/N T01063 N2697TMarshall Gregg · Meridian, IDS/N SR5XP-2761 N269CENce Inc · Tucson, AZBuilt 2016 · S/N NCE-002 N2702PNorman Tamara A · Nicholasville, KYBuilt 2001 · S/N 2702 N2707TDuckett Ronnie E · Chesnee, SCBuilt 1995 · S/N 0395569 N2728RDavolt John W · Hobe Sound, FLS/N 001DC N2731NFoster Phillip Fayne · Hallsville, TXBuilt 2004 · S/N A325 PEG N2732NIezzi Leo E · Moreno Valley, CAS/N 102156 N2738AKnowles Charles M · Chapmanville, WVBuilt 2000 · S/N A 129 POW N2742TPerdue Jason B · Carlisle, KYBuilt 2003 · S/N PEG 123 N2745RRose Gerald B · Jonesville, VABuilt 2002 · S/N 4951 N2757AKadel David A · Randall, KSS/N 0494491 N2758NLowe Jerry W · Danville, VABuilt 2005 · S/N 0524 N2760TKober Chad B · Charles City, IABuilt 2000 · S/N 1BO166 N2764NDewalt Thomas W · Saint David, AZFirst renewal noticeS/N T0126 N2770PLehmann Bruce T · Clermont, IABuilt 2003 · S/N IPP3-164 N2772AContreras Cesar Revilla · Tucson, AZS/N A121641 N2772RButler Marshall B · Broken Arrow, OKFirst renewal noticeBuilt 2001 · S/N 301 N277DKHanel Enterprises Inc · Courtland, KSBuilt 2002 · S/N 000571 N2796UWuolo William E · North Port, FLS/N 246 N2802PCrawford Rocky D · Knoxville, TNS/N 4346 N2808SRatcliff Stephan J · Olivehill, KYBuilt 2003 · S/N 16372 N28407Santana Lisa · Wurtsboro, NYS/N 0307 N285SWTenny James · Wimberley, TXBuilt 2002 · S/N 10001234582

Back to Rotax 582SER