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.

N5144QSnyder Jeffery T · Llano, CABuilt 1995 · S/N 0295079 N514VPKirkpatrick Timothy D · Yuma, AZS/N A507PEG N5159LPerkinson Robert D · Gallatin, TNBuilt 2002 · S/N A-296POW N5166KSchmidt Kent D · Arnold, MOBuilt 2001 · S/N A-199 POW N51708Brumbaugh Wayne E · Peru, INBuilt 2002 · S/N HD02063M N5174Oconnell Christopher J Sr · Greenville, WIBuilt 2014 · S/N CH2-0199-1834 N5176DDerrig Greg J · College Station, TXBuilt 2007 · S/N 43250 N51822Harrison Rodney W · Manakin Sabot, VABuilt 2005 · S/N 31139 N51854Molloy Robert C · Leeds, ALBuilt 1995 · S/N 02115 N518DMBishton Michael P · Bethesda, MDBuilt 1995 · S/N D95XXXCOHK0156 N5194ACoblentz Kevin · Tulsa, OKBuilt 2006 · S/N A419 PEG N5236ARegistration Pending · Mobile, ALRegistration pendingS/N 0664 N530ATMoga Richard R · Fredericksburg, TXBuilt 1997 · S/N 0692109 N532SEKrell Brett W · Nowthen, MNBuilt 1987 · S/N 231 N532WLLavender David F · Lincoln Park, MIBuilt 1996 · S/N 3452 N533SEFerraro Gino J Jr · Latrobe, PABuilt 2015 · S/N M002 N534LFFitz Leroy L · Young America, MNBuilt 2007 · S/N 4317111 N545KBBeck Kevin A · Medford, NYBuilt 2020 · S/N X1027 N5504ALuluvg LLC · Kalispell, MTBuilt 1992 · S/N 4311 N5506VBerrios Ramon · Drummonds, TNS/N 5381809 N5509MSomers Michael L · Lindsay, OKBuilt 2004 · S/N 00133 N55104Wilkin Roy S · Bakersfield, CABuilt 1998 · S/N Q9812 N5514YDoucette Perry J · Sugar Grove, ILBuilt 1998 · S/N 981899 N55274Anderson Steven R · Cleveland, TNBuilt 2004 · S/N IPP4-281 N5534LLudwig William D · Colby, WIBuilt 2003 · S/N LW001 N55448Gardner Edmond J · Earleville, MDBuilt 2007 · S/N HD07153M N5569FJacobi Joseph L · Mexico, MOBuilt 2004 · S/N IPP4-260 N5572WLabado Michael L · Chickamauga, GABuilt 2003 · S/N KK-100 N5573JBawtinheimer Kris J · Grand Rapids, MIBuilt 2000 · S/N 4939 N5611HGeorge Jackie L · Woodbridge, VAS/N 001JG N5617XLoenser James A · Clayton, WIS/N 99-2211-SR7XL N5620YMartin Jeffrey L · Goshen, INBuilt 1998 · S/N 4131 N56215Roberts Travis B · Waterloo, ILBuilt 2008 · S/N 0214 N5621HSale Reported · Howard Lake, MNSale reported, canceledS/N D9758250HK025F N5624CFisher James K · Eagle Grove, IABuilt 2002 · S/N 2838 N5624NGirard Louis W · Schulenburg, TXBuilt 1998 · S/N 4426 N5626JThode Roger D · Chehalis, WABuilt 2001 · S/N A-159 POW N5629UJustice Paul D · Albuquerque, NMBuilt 2000 · S/N 5021 N5659VCole Michael R · Beaumont, TXBuilt 2004 · S/N A-267-PEG N566AWBruns Darcy L · Sandia, TXS/N A290POW N566GRLoeppky Neal K · Seminole, TXBuilt 2019 · S/N 0193369 N56908Hickey William P Jr · Tucson, AZS/N 0331045 N5695NKrush Paul R · New Berlin, WIS/N 4C0604 N56980Defebaugh Tim S · Mackinaw, ILBuilt 2002 · S/N 6086 N581TJGriffith Orin · Hastings, OKBuilt 2013 · S/N 1 N582BAJakoubek Kirk D · Valles Mines, MOBuilt 2007 · S/N A 421 PEG N582FBDaly Martin J · Hart, MIBuilt 2005 · S/N 1 N582JHSanders David L · Wise, VABuilt 1997 · S/N 3704 N582JKTrinque Thomas M · Pascoag, RIBuilt 1999 · S/N 15088 N582JLLitz Mark · Circleville, OHBuilt 2023 · S/N 23-1472

Back to Rotax 582DCDI