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.

N2517STevis Aviation Inc · Emporia, KSBuilt 2000 · S/N 1B0154 N2521HMarquiss Steven A · Two Rivers, AKBuilt 1998 · S/N AIRC10815 N2526JFork Kevin L · Gibsonburg, OHBuilt 1997 · S/N 3611 N2526KJones Terry L · Halstead, KSBuilt 2002 · S/N 2002009 N2534SLalley Dennis D Trustee · Corvallis, ORBuilt 2004 · S/N 2944 N25354Correll William R · Ephrata, WABuilt 2002 · S/N 6233 N2538LZoltak Aviation LLC · Perry, GAS/N 582 1027 N2539FBarnhart David R · New Carlisle, INBuilt 2000 · S/N 6020 N2541TMinor Michael K · Royse City, TXBuilt 2001 · S/N IPP2-060 N2541VMonroe Roger · Shelbyville, INBuilt 2003 · S/N 4C0603 N2541YBurton Jeff J · Temple, GABuilt 1998 · S/N 4011 N2543GWillard John E · Rockwood, MEBuilt 1989 · S/N 1154 N2543LNeuzerling Pete F · Peru, INBuilt 2001 · S/N 1C0289 N2543MWilliams Aerosport LLC · Uniondale, INBuilt 2005 · S/N 4C0564 N2543WHarlan William T Jr · Beaumont, TXBuilt 2007 · S/N 9134 N2543YMullikin Deron K · Tollesboro, KYBuilt 2007 · S/N 046 N2545NMurray Willan C · Butler, PABuilt 2000 · S/N 6043 N2546JBarnes Douglas E · South Bend, INBuilt 1999 · S/N 4796 N2546LGeigley Arlin L · Montrose, COBuilt 2002 · S/N 2002010 N2549EOlson V Don · Salmon, IDBuilt 2000 · S/N 1B0025 N2551AWellnitz Patrick L · Whitewater, WIBuilt 2007 · S/N 0548 N2553LWalden Ron D · Dothan, ALS/N 2C0354RWB N2556GHoyt Nicholas L · Vernal, UTS/N 00115 N25578Miller George Lorin · Winnemucca, NVBuilt 2002 · S/N 4C0999A N2559NRoyse James · Saint Augustine, FLS/N 10021458ES N255TVDonnelly Gavin C · Jelm, WYS/N 948 N2561EMaas Michael J · Newton Falls, OHBuilt 2004 · S/N 0091 N2562VRedden Robert R · Utopia, TXFirst renewal noticeBuilt 2002 · S/N A-070PEG N2563LRichter Leon F · Afton, MNBuilt 2007 · S/N 001 N2564ADuncan David A · Granger, INFirst renewal noticeBuilt 2001 · S/N 6220 N2566XRoberts Rolland J · Hanover, MIS/N A417PEG N25670Winn Brian · Discovery Bay, CABuilt 1999 · S/N 4499 N2567NJackson Gideon T · Yoncalla, ORBuilt 2003 · S/N A-220-PEG N2567YGuarrera James J · St George, UTS/N 3CO515 N256RSDavis Steven M · Eastsound, WABuilt 2008 · S/N 0090 N25716Merrill Brian L · Rexburg, IDS/N 5387 N2571NFleischman Matthew A · Moab, UTS/N A50TDA N2572KBurkeen David T · Pinson, TNBuilt 1994 · S/N 094503C0HK0117 N2572QStaley Peter A · Agoura Hills, CABuilt 2002 · S/N 2CO326 N2589EHoward Michael D · West Liberty, KYBuilt 2000 · S/N 3C0408 N2592ERansdell Duane L · Columbus, NES/N KOLB/TIB227886584 N2600SHadlett Harlan C · Center Hill, FLBuilt 1997 · S/N 09960745 N2602EConaway Richard L · Esperance, NYBuilt 2002 · S/N HD 02070 M N2602PGall Raymond R · Vidor, TXBuilt 2001 · S/N 00102 N2605EBleil Gordon R · South Haven, MIS/N SPRINT 0641 N2608THemphill Charles E · Cleburne, TXBuilt 2007 · S/N A-447-PEG N2609AHaugland Arthur M · Tolna, NDBuilt 2004 · S/N 16392 N2609CAjc Farm LLC · Columbus, MSBuilt 1995 · S/N 001 N2613RAnderson Tony K · Cleburne, TXS/N A251PEG N2614WKelly William P · Wautoma, WIBuilt 1999 · S/N 99-2209

Back to Rotax 582SER