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.

N5617MMckee Brude · La Puente, CABuilt 2005 · S/N 2005DR N5617NDuval David · Bixby, OKS/N INFA049 N56185Dahl-Bredine Chris T · El Prado, NMBuilt 2005 · S/N T05076 N5618BOberlin Brandon G · Indianapolis, INBuilt 1995 · S/N 3343 N5619NMiller Glenn N · Westfield Center, OHBuilt 2000 · S/N 4859 N5621KRichani Abdala · Brandon, FLS/N 0192164 N56230Carr Timothy M · Cannon Falls, MNS/N 582-460 N56236Conroy Lawrence W · Grovertown, INBuilt 1997 · S/N 6573 N5627GFerrell Charles Steven · Lexington, KYBuilt 2003 · S/N IPP3-191 N5628KOwens Peter C · Corvallis, ORBuilt 2006 · S/N T06007 N5629QBox Aviation Inc · Montgomery, ALBuilt 2000 · S/N 4839 N56352Winkelman Danny L · North Bend, NEBuilt 2000 · S/N 1B0136 N565LFRonnebaum Daniel F · Seneca, KSBuilt 2016 · S/N CH2-1213-LSS-L65-0249 N56620Holliday Christopher R · Salem, MOBuilt 2001 · S/N A156POW N5662NGregory David A · Westmoreland, TNBuilt 1999 · S/N 4746 N568ADavid Glen E · Ash Fork, AZFirst renewal noticeBuilt 2014 · S/N 0042 N568JWWrona James B · Simpsonville, SCBuilt 2007 · S/N 582-523 N56939Tim Laidig Farms Inc · Bremen, INBuilt 2002 · S/N 16251 N56961Harper Larry R · Tipton, INS/N 3489 N56971Dickhudt Gene R · Mcpherson, KSBuilt 2002 · S/N A-286POW N56982Hostetler Omar T · Center, COBuilt 2003 · S/N 0088 N5698CClodfelter Mark C · Goodwell, OKS/N A332PEG N569DLChang Peter · Manalapan, NJBuilt 2008 · S/N XT-582-0052 N57010Martin Lawrence · Goshen, INBuilt 1999 · S/N 4528 N570ESGranieri Thomas P · Cave Creek, AZBuilt 2015 · S/N 2015 N574KGGills Marc Alan · Union, MOBuilt 2009 · S/N 333 N575KHEntertainment Etc LLC · Winter Garden, FLBuilt 2001 · S/N 1RWT N577BWMiller Richard T · Edgewater, FLBuilt 2004 · S/N 001 N580PGHart Bevan T · Los Gatos, CABuilt 2002 · S/N A058 PEG N5827USilverman Phillip E · Fullerton, CABuilt 1996 · S/N MK25827U N582ADPalmer David M · Jacksonville, ORBuilt 2018 · S/N 056 N582EBaker Dennis L · Royalston, MABuilt 2007 · S/N 3001 N582EEYoder Isaac J · Chappells, SCS/N 4902 N582EHHamm Errett J · Coeburn, VAFirst renewal noticeBuilt 2000 · S/N 5062 N582ELReiland Jason P · Savanna, ILBuilt 2006 · S/N CH2-0705-2653 N582FPBowling Robert Jr · Dutton, ALBuilt 2006 · S/N 582-1019 N582GRStyer David L · Mount Gilead, OHBuilt 2017 · S/N 1136 N582HTHamilton Robin Fm · Houston, TXBuilt 2001 · S/N 001 N582HWGray David M · Albuquerque, NMBuilt 2003 · S/N 0035 N582JBBalles Jeffrey J Sr · Hunker, PABuilt 2015 · S/N 1958B N582KBWoelfel Charles D · Magnolia, TXS/N 5162716 N582LMillsaps Robert · Vancleave, MSS/N CH2-0708-LSS-LW-0151 N582MEMathis Jimmy L · Silsbee, TXBuilt 2016 · S/N P582E42635 N582MKOrtiz Rivera Luis R · Carolina, PRBuilt 1991 · S/N 012 N582PHHockin Richard P · Raymond, MSBuilt 2001 · S/N 000545 N582RHRector Donny · Hubertus, WIBuilt 1989 · S/N 107 N582SAArnold Steven · Johnson, KSS/N A215POW N582SUDolezel Dwight Macarthur · Delhi, NYBuilt 2005 · S/N XT 582-06 N582THO Connor Douglas J · San Angelo, TXBuilt 2007 · S/N HAII-319-R582-TD N582TJMadore Lionel J · Berkeley, CAFirst renewal noticeS/N 436

Back to Rotax 582SER