Skip to content

Registered aircraft · 82

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

N536LLKoeppen Colin K · Albion, NEBuilt 2004 · S/N 2987 N5508HClaussen Larry S · Independence, ORS/N 3026 N55446Nogueras Eliseo · Attleboro, MABuilt 2008 · S/N 11MAM N56043Blanton Tracy G · Gaffney, SCBuilt 2000 · S/N 4916 N5607KGill Richard M · Bronwood, GABuilt 2008 · S/N A 365 PEG N5666WJohnson Gail E · Gig Harbor, WABuilt 2007 · S/N 3235 N5703CBailey Marvin John · Grand Island, NEBuilt 1999 · S/N 4633 N582PWTarkington Michael R · Sheridan, ARBuilt 2001 · S/N 1C0270 N602PWMeadow Jeff · Blanket, TXBuilt 2005 · S/N 6811410 N6049YLeake Kenneth · Sapulpa, OKBuilt 2008 · S/N A-048PEG N620BGAnderson Thomas W · Eastsound, WABuilt 2003 · S/N A-097PEG N624UFUltraflight Aviation LLC · Prospect, KYRegistration expired, pending cancellationBuilt 2004 · S/N 4C0624 N65027Bryan Gary V · Knotts Island, NCBuilt 2004 · S/N SPIRIT 2933 N65508Rans Monte J · Rochester, INBuilt 1999 · S/N 4475 N6597BMckinley Ed L · Dublin, OHBuilt 2004 · S/N HD04127M N6609SHanson Chris A · Mount Horeb, WIBuilt 2007 · S/N IPP6-341 N664DBBarkley Dale E · Paris, ILBuilt 2006 · S/N 4809 N668LVKohler Paul W · Inchelium, WABuilt 2006 · S/N 001 N7003JHerring Cliff · Clinton, NCBuilt 2005 · S/N 16457 N7046CTwenter Paul · Lebanon, MOBuilt 2004 · S/N A-345-PEG N719JNevermann Gary · Pewaukee, WIS/N 00112 N75071Byrnes Dennis S · Chalfont, PABuilt 2006 · S/N 1696506 N75632Gruninger Patrick R · Alachua, FLBuilt 2007 · S/N 98-1946-SR5XP N8098HKiselewsky Richard · Flemington, NJBuilt 2009 · S/N P582E40009 N85959Humphreys Howard M · Wilsonville, ALBuilt 2003 · S/N 16333 N8603LSchlabach Merlin Ray · Plain City, OHBuilt 2002 · S/N A084 N9219WErnst Mark A · Alexandria, KYBuilt 2004 · S/N 400621 N92473Johnston David · Fort Myers, FLS/N 3C0419 N9265LTurvey Tommie M · Williamson, GABuilt 2004 · S/N A-242-PEG N9381RGriffin Tad D · Trenton, MOBuilt 2002 · S/N A-120POW N94218Harden Randy C · Okeechobee, FLS/N A-280 PEG N94612Crain Neal J III · Harrison Twp, MIBuilt 2007 · S/N E3502K

Back to Rotax 582E