Skip to content

Lycoming O-320-E2D

Registered aircraft · 258

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

N427SCJones Jeffrey A · Brooksville, FLBuilt 2010 · S/N 001 N42HCRegistered aircraftBuilt 2009 · S/N RV21364 N42WXWeselmann Randall C · Bainbridge, INBuilt 2008 · S/N RCW2 N431ERegistration Pending · Kokomo, INRegistration pendingBuilt 2007 · S/N 70423 N436HOllila Dale G · Buckeye, AZBuilt 1980 · S/N 1 N439JMartin James D · Marietta, TXBuilt 2008 · S/N 3034 N442CMAnderson Charles M Jr · Snohomish, WABuilt 2010 · S/N 1824 N446KWClementi Frank R · Wesley Chapel, FLBuilt 2011 · S/N 1474R N447BBFerree William M · Stafford Springs, CTBuilt 2017 · S/N 71509 N449DAArford Dennis C · Athens, GABuilt 2017 · S/N 22124 N44GDCarver Michael A · Ocala, FLBuilt 2009 · S/N 004 N44WPAnderson Stuart R Jr · Sahuarita, AZBuilt 2015 · S/N ES1 N456BTHatfield Timothy E · Parowan, UTBuilt 2013 · S/N 4712 N456TWSchmidt Gail M · Florence, COBuilt 2007 · S/N 02-1217 N459RCCouch Robert · Stephenville, TXS/N 90609 N46045Rabb Randolph W · El Cajon, CABuilt 2015 · S/N 75-8409 N46231Hibdon Repair LLC · Grundy Center, IABuilt 1968 · S/N 17257124 N4626546265 LLC · Eustis, FLBuilt 1968 · S/N 17257146 N464DGLyon Garth M · Blackfoot, IDBuilt 2018 · S/N 17 N464EHMurphy Dean J · Caledonia, ILBuilt 2012 · S/N 22705 N46DZLuepke Quinn L · Wasilla, AKS/N 001 N47TWRiley Steven M · Bucyrus, KSBuilt 2026 · S/N 0005611 N480YSArad Aviation LLC · Breckenridge, COBuilt 2015 · S/N 001 N48BRField Christopher R · Kingston, TNBuilt 2009 · S/N 90951 N490RVSmith William R · Seneca, PABuilt 2008 · S/N 20090 N493CKTaylor Mark Steven · Goshen, OHBuilt 2012 · S/N 493 N49JBTilley Robert E · Albany, GABuilt 2013 · S/N 049 N501RVSaunders Steven M · Elizabeth City, NCBuilt 2006 · S/N 90305 N506DBMerlin Labs Inc · Mojave, CABuilt 2008 · S/N 001 N510SFGibson William V II · Aberdeen, MSBuilt 2008 · S/N 001 N51274Worley Farms · Atwood, KSBuilt 2008 · S/N 91089 N5150Hlavac Mathew B · Ramona, CABuilt 2005 · S/N MBH-1 N51SMSolomon Steven D · Prospect Hill, NCS/N 90953 N521FCStevens Kole · Sebec, MEBuilt 2008 · S/N 001 N52BCCottle Kevin Patrick · Daniels, WVBuilt 2008 · S/N 011 N52DRJbpm LLC · Otisfield, MEBuilt 1973 · S/N 15075506 N52KDWhite Taylor D · Gainesville, GABuilt 2016 · S/N 20465 N53BLLawrie David A · Tijeras, NMBuilt 1981 · S/N 589 N541GW2 Huskies LLC · Sheridan, WYBuilt 2013 · S/N 91659 N543AHEquinox Aviation LLC · Albany, GABuilt 2008 · S/N 20543 N544WMCampbell Greg L · Greenville, WIBuilt 2012 · S/N 3358 N564GHughes Ramzi S · Alamo, NVBuilt 1968 · S/N 15068276 N569TJAnderson Thomas C · Poplar Grove, ILBuilt 2013 · S/N 259R N575DGSeamount Robert E · Milton Freewater, ORS/N 218 N57BZN57bz LLC · Sheridan, WYBuilt 2010 · S/N 24032 N5845ZGeldermann Bert E · Friday Harbor, WABuilt 1996 · S/N 230R N585CBBlack Christopher · Williamson, NYS/N 819R N592SCN592sc LLC · Inola, OKS/N 3100 N595DJSanchez Daniel J · Gonzales, LABuilt 2019 · S/N 26001 N59LPHalkett Blair Ross · Knoxville, TNBuilt 1999 · S/N 001

Back to Lycoming O-320-E2D