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.

N3876ACollins Kevin J · Greenleaf, WIBuilt 2002 · S/N A-091PEG N3881BFrost Jack · Fountain, MIBuilt 2001 · S/N 2C0329 N392SKSale Reported · Hancock, WISale reportedS/N CH2-0501-2091 N394JBBrutger Jeremy D · Eden Valley, MNBuilt 2025 · S/N 506 N3966Hince Samuel B · Champaign, ILBuilt 1997 · S/N 01960674 N3968VEnns Danny · Whiteface, TXBuilt 1995 · S/N 1091136-0394 N3970Nye Brian M · Independence, ORBuilt 1998 · S/N 98-1869-2SR7 N3980DLange Daniel M · Whitewater, WIBuilt 2000 · S/N 59 N3990LKarlson Ken · Washington, UTBuilt 2004 · S/N 16391A N4004LClark Timothy B · Ogden, IABuilt 1998 · S/N 4157 N401EJLedford Timothy J · Erwin, TNBuilt 2007 · S/N 4C0600 N4023GCurtis Christopher M · Erie, PAS/N SR7XL-2661 N4050UBurton Mark P · Jackson, TNBuilt 2007 · S/N A78POW N405EPBurbage John C · Naples, FLS/N A481PEG N4061WYawn Robert · Mccomb, MSS/N A151 POW N40691Kiselewsky Richard · Flemington, NJBuilt 2002 · S/N 3093 N4070YKuntze Ryan W · Chassell, MIS/N A261PEG N40715Russo Troy M · Mary Esther, FLBuilt 2007 · S/N H20045 N408RPPassarella Ronald M · Chicago, ILBuilt 2002 · S/N T02005 N408WAMcfall Douglas J · Kimberly, IDBuilt 2000 · S/N T00069 N41061Seals Kevin M · Delavan, ILBuilt 1999 · S/N 4491 N41074Bouche Kevin J · Pelican Lake, WIS/N 2004031 N418PNFidler Peter S · Rolling Meadows, ILFirst renewal noticeBuilt 2006 · S/N D001 N423DAWhittier Scott · Orem, UTBuilt 2010 · S/N A484PEG N424VAFletcher Jerry W · Yuma, AZBuilt 2010 · S/N A483PEG N427GRLong Victor · Millington, MIFirst renewal noticeS/N 1025 N427RFFernandez Robert · Byron, ILBuilt 1998 · S/N 98010 N42PAJohnston Mark · Cotton, MNBuilt 2006 · S/N 1 N4305CPettys Robert C · Bottineau, NDBuilt 2001 · S/N A012CDR N430ZPHarmon Roger O · Cleburne, TXS/N A486PEG N4322BAutrey Randy D · Bethel, MEBuilt 2002 · S/N HD02084M N4350MHildebrandt John Edward · Adrian, MIS/N 4446 N43537Koopman Andrew W · Parkersburg, IABuilt 2006 · S/N 04040986 N4354JGabehart Weldon P · Campbellsville, KYBuilt 2001 · S/N 6128 N43667Case Cecil R · Evansville, ARBuilt 2003 · S/N A167PEG N4367FShaughnessy John M · Valparaiso, INBuilt 2001 · S/N 6097 N4367YSchorr Joseph R · Doylestown, OHBuilt 2000 · S/N 5097 N4385JGriswold Donald G · Pontiac, ILBuilt 1996 · S/N 3464 N4397GMartin Charles L · Hinesville, GABuilt 2000 · S/N 1B0107 N439AZMorton Mark O · Albuquerque, NMS/N T01072 N44323Leon James M · Frankfort, ILBuilt 2000 · S/N TUP0222 N4435FDroter Bert E · Chester, MDBuilt 2007 · S/N SNJ582207004 N444XSMiller Mark A · Saint Cloud, FLS/N PG0051286 N444YBHerring Morris Clifford Jr · Clinton, NCBuilt 1993 · S/N 1JB N4456BYates Travis D · Section, ALBuilt 2002 · S/N RKSTD20024456 N4476ALopez Hector R · Maricopa, AZBuilt 2001 · S/N 21499 N4478GMathews Virgil Leon · Kinta, OKS/N A036PEG N447KFVan Cleve Travis · Houston, TXBuilt 2013 · S/N 1439 N4490SAlred Steven J · Centre, ALBuilt 2012 · S/N 726 N4492GDoyle Patrick H · Fort Worth, TXBuilt 1991 · S/N B1B526

Back to Rotax 582DCDI