Skip to content

Registered aircraft · 578

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

N818VPParker Richard C · Sahuarita, AZBuilt 2007 · S/N 0195 N819PPSolo Mark W · Jackson, MIBuilt 2003 · S/N A189 INF N820CDonnelly Mitch L · Mcloud, OKBuilt 2020 · S/N 872837 N8217CJackson Russell D · Salisbury, NCBuilt 2004 · S/N 222 N822CMRigstad Scott M · Northville, MIBuilt 2007 · S/N KK7607 N828RCCruz Ramon · Caguas, PRBuilt 2000 · S/N 0077 N829RSKubin Mark A · Ward, ARBuilt 2006 · S/N 809 N840YPWheaton Jerry W · Iola, TXBuilt 2017 · S/N A515PEG N841ARAbreu Orlando · Adjuntas, PRS/N 97-1802-2SR7 N8420PSchneider Duane E · Burwell, NEBuilt 2018 · S/N A516PEG N849JTMarcks Noel L · Cecil, WIFirst renewal noticeBuilt 2007 · S/N 0018 N8511ZOsborne Danny L · Lawton, OKBuilt 2003 · S/N 0057 N8541QKratz Allen R · Lincoln, CABuilt 1998 · S/N 98-2001-SR5XP N855YRNordlund Robert J · Champlin, MNBuilt 2018 · S/N RT001 N85804Lundberg Charles J · Fortine, MTBuilt 2003 · S/N A336POW N859DWCampbell Troy L · Aberdeen, WAS/N 373 N859HAustin William H · Overland, MOBuilt 2012 · S/N 001 N859XSale Reported · Fort Worth, TXSale reportedBuilt 2017 · S/N 001 N86022Ryan Richard M · Canyon Country, CABuilt 2005 · S/N 042505 N8604EConnie Danny H · Dennison, ILBuilt 2001 · S/N 2C0323 N86068Sullivan Lawrence W · Silex, MOBuilt 2003 · S/N A174PEG N8611TToler C Reggie · Franklin, ILBuilt 2004 · S/N 16429 N8614VGirard Louis W · Schulenburg, TXBuilt 2006 · S/N 16510 N8615NStockdale Mark A · Arcadia, FLBuilt 2004 · S/N H20024 N8615PAircraft Systems Group Inc · Odessa, FLBuilt 2006 · S/N USA 020306 N861SGKnowles Richard D · Willis, MIBuilt 2007 · S/N A404PEG N865HWNoble David J · New Lisbon, WIBuilt 2007 · S/N 759 N8771Lopez Sergio R · Port Washington, NYBuilt 1998 · S/N 582-330 N89117Locklear Delton Ray · Rockingham, NCBuilt 2004 · S/N IPP4-250 N896JPVan Hammers Gary C · Mukwonago, WIFirst renewal noticeS/N A287PEG N899UFNegrini Dario · Saint Petersburg, FLBuilt 2022 · S/N 398 N89SXTheriot Casey T · Hideaway, TXBuilt 2007 · S/N 0089 N90087Lightman Joseph · Questa, NMBuilt 1999 · S/N T01002 N9061FBixler Don A · Decatur, INS/N CH2-0199-1835 N909WXHowell Scott A · Nokomis, FLBuilt 2006 · S/N 16504 N9105RHarrison Bruce Charles · Fort Mohave, AZBuilt 2006 · S/N 414 N912MEBruns Darcy L · Sandia, TXBuilt 2007 · S/N W403 N913MMJunkerman Herman L · Monroeville, NJBuilt 2000 · S/N A 109 POW N913ZSShipley Anthony R · Aberdeen, IDBuilt 2021 · S/N 857 N91729Hudson Jeffrey D · Winchester, VABuilt 2006 · S/N 582-1051 N91755Poehlein Steven E · Mcleansville, NCS/N 229 N92048Martin Jerry D · Chester, MTBuilt 1998 · S/N 4387 N922DSTaylor Aviation Inc · Hinckley, ILBuilt 2012 · S/N 2011 N9242CSiebring Raymond E · Colorado Springs, COBuilt 2007 · S/N 2C0349 N9255RSeelbinder Norman W · Ransomville, NYBuilt 1999 · S/N 99-2287-SR5XP N925TULarner Ronald D · North Pole, AKBuilt 2000 · S/N 582-587 N9287BSkvara Mark D · Green Bay, WIBuilt 2006 · S/N 16519 N92928Kwarciany William L · Escanaba, MIBuilt 2003 · S/N 16330 N929EMMeyers Timothy J · Wheaton, ILBuilt 2010 · S/N XT-582-0071 N929HDannan Anthony S · Ellensburg, WABuilt 2018 · S/N HAII-321-TRI

Back to Rotax 582DCDI