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.

N36DRFlaugher Jeffery R · Lake Orion, MIBuilt 2007 · S/N 0644 N3708DBrillhart Matthew M · Bonner Springs, KSBuilt 1999 · S/N A777GWB N370FPSale Reported · Cave Junction, ORSale reported, canceledS/N 0232 N370MJBain Joseph T · Paw Paw, MIBuilt 2006 · S/N 0292186 N371AZMorton Joseph A · Blountville, TNBuilt 2003 · S/N IPP3-197 N371PDees James R · Coolidge, GABuilt 1998 · S/N 4186 N3726DPegasus Flight Systems LLC · Mount Dora, FLBuilt 2007 · S/N 21432 N372GERegistration Pending · Carthage, MORegistration pendingBuilt 1997 · S/N 3637 N3735VJasunas William E · Arlington, TXBuilt 2007 · S/N IPP7-360 N3743ALowry Jack K · Jones, OKBuilt 2003 · S/N 0045 N374UNHam Derek · Independence, ORS/N E7010 N3750HWilliams Terrence A · Bastrop, TXBuilt 2001 · S/N A246 POW N375BQMott Charles A Jr · Chesapeake, VAS/N 001 N379ZSnead Robert B · Easton, MDFirst renewal noticeBuilt 1998 · S/N 9230601-24 N37PTRivir Jason R · Canton, KSS/N 3845 N3812PReynolds Randy E · St Maries, IDBuilt 2011 · S/N 012 N3816AVance Steven M · Moss Point, MSS/N 000543 N384CDBaedke Frank D · Story City, IABuilt 2000 · S/N A54POW N384FZLarsen William L · East Wenatchee, WABuilt 2010 · S/N E7015 N384GYOstry James A · Bruno, NEBuilt 2002 · S/N 2C0351 N3850HRinkhoff Grant E · Smock, PAS/N 17/2001 N3853VLambert Daniel V · Mosheim, TNBuilt 1999 · S/N 4328 N3856VHouston Hal B · Como, MSBuilt 2005 · S/N 16465 N386HLSingleton Addison · New Bedford, MABuilt 2000 · S/N 12 N386LTDesvernine Kenneth M · Oviedo, FLS/N 5145673 N3878VBegue George A · Pickerington, OHS/N 3830 N387EHHaggard Keith B · Salt Lake City, UTBuilt 2009 · S/N 90108 N3891JBarker Bradley W · Webster, MNBuilt 2003 · S/N 02217X3 N3896VMehaffey Billy H · Mims, FLBuilt 1997 · S/N 220088 N3899EWyatt Gaylon J · Pineville, ARBuilt 2017 · S/N CH2-0893-CW-1007 N389ECGobel John A · Gorham, MEFirst renewal noticeBuilt 2009 · S/N IPP9-387 N3901VElmer Bruce · Greenwood, WIBuilt 2007 · S/N IPP2-121 N3904BSmith Scott W · Rochester, MIBuilt 2009 · S/N 01 N3935VRabalais Brad J · Flora, MSBuilt 2007 · S/N IPP3-160 N394BJDye Samuel N · Eagle River, AKS/N 359 N396DFVan Ginkle Henry · Cleveland, GABuilt 2004 · S/N 0104 N4005HFettig Dale H · Jamestown, NDBuilt 2004 · S/N 16418 N4006AFender Patrick A · Polk City, FLBuilt 2002 · S/N 0503 N400AFTeel Rodney R · Blue Grass, IABuilt 2004 · S/N 418572 N4016MArmstrong Brandon S · Milton, WVBuilt 2000 · S/N 5009 N40210Martin Jonathan L · Newville, PABuilt 2002 · S/N IPP2-088 N40296Green Lloyd M · Bluffton, INBuilt 1998 · S/N 4113 N402DPPayne Darrell L · Culpeper, VABuilt 2004 · S/N XL-2986 N4036LRillema Russell L · Hudsonville, MIS/N 1C0227 N404RRMoorefield Jason B · Albany, ORS/N A254 N40534Lavi Natan · Cupertino, CAS/N 4957 N4053VCarroll Larry D · Hermiston, ORBuilt 2005 · S/N A361PEG N40560Wheeler William M · Huntington, WVBuilt 2004 · S/N 0513 N4057HEnglish Brian Q · Sapulpa, OKS/N 16333 N40649Parker Cory James · Hamilton, OHBuilt 2006 · S/N 0555

Back to Rotax 582SER