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.

N605CCPatterson Kyle M · Torrington, WYBuilt 2016 · S/N 003 N605MNSale Reported · Boise, IDSale reported, pending cancellationBuilt 2022 · S/N 5368 N606RVSuper D LLC · Nunn, COBuilt 2016 · S/N 22851 N61651Clw Aviation LLC · Springville, ALBuilt 1975 · S/N 17264702 N61804Skyhawk Virginia LLC · Chester, VABuilt 1975 · S/N 17264813 N619NTCahill Richard J · Columbus, OHBuilt 2013 · S/N 4039 N61ZBIntegratis Inc · Carmel, CABuilt 2006 · S/N 25255 N62FHOlson Raymond A · Somers, MTBuilt 2011 · S/N 91299 N62SGGoevert Steve B · Kingman, KSBuilt 2016 · S/N 25246 N642RN642r LLC · Farmland, INS/N 20569 N64334Vrionides Polis G · Collinsville, CTBuilt 1975 · S/N 17265174 N645LCJohnston Laura S · Seattle, WABuilt 2003 · S/N 263 N649ESFlymore Aviation LLC · Philadelphia, PABuilt 1975 · S/N 172-64536 N650PKKarmouche Paul · Penngrove, CABuilt 2009 · S/N 001 N652JPHarvey Gregory D Sr · Greenbush, MEBuilt 1983 · S/N 1066 N6530HWagons West LLC · Myrtle Beach, SCBuilt 1975 · S/N 17265477 N656GCotter Kevin G · Chico, CABuilt 2006 · S/N 90289 N65DRKlr Services LLC · Newalla, OKBuilt 2002 · S/N 60196 N65PPAir-Supply Aerial · Philomath, ORBuilt 2012 · S/N 20926 N666MTSch Aviation Inc Trustee · NorfolkBuilt 1973 · S/N 0985 N6695MRegistration Pending · Sheridan, WYRegistration pendingBuilt 1976 · S/N 17266695 N67KCBlanchard Robert E Jr · Washburn, WIBuilt 1985 · S/N 1185 N687AZZublin John A III · Murrieta, CABuilt 1968 · S/N 17256592 N68WLGlobal Pilot Inc · Wilmington, DES/N 70600 N694PKRule John H · Statesboro, GABuilt 2022 · S/N 92158 N69BNSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1974 · S/N 17261945 N710BWise Matthew A · Chambersburg, PABuilt 1990 · S/N 20017 N712GWArmstrong Michael L · Bend, ORBuilt 2010 · S/N 107M N714TCJt Air LLC · Luling, LABuilt 1977 · S/N 15279412 N717DBJohnston David M · Elwood, INBuilt 2021 · S/N 602 N71KSLazenby Gary M · Harpster, IDBuilt 2013 · S/N 20621 N72579Allee Mark J · Gillette, WYBuilt 1967 · S/N 15067593 N72DDMildebrandt Donald E · East Troy, WIBuilt 2006 · S/N 375 N72FDEngesath David H · Duluth, MNBuilt 1974 · S/N 17263913 N7348GHardy James H · Albany, NYBuilt 1970 · S/N 17259048 N734RBas Part Sales LLC · Greeley, COBuilt 2015 · S/N 734R N73WGGlattli William H · Boynton Beach, FLBuilt 2018 · S/N 11471 N73WRStanton Fred H · Amherst, NYBuilt 1997 · S/N 1272 N7476DHincke Cedar F · Kalispell, MTBuilt 2012 · S/N 001 N74GMMellen George J · Powell, OHBuilt 2008 · S/N 607 N750RECarpenter Richard S · Goshen, OHS/N C75-10111 N7577GElkhorn Aviation Inc · Baker City, ORBuilt 1970 · S/N 17259277 N759STraining Planes LLC · Tampa, FLBuilt 1974 · S/N 17264166 N761GSSaulsbury Greg F · Nash, TXBuilt 2023 · S/N 91360 N761LAIowa Lakes Community College · Estherville, IABuilt 1976 · S/N 172-67476 N77ZWMeyer Alan T · Eckert, COBuilt 2007 · S/N 1039 N782POrear Jeffrey W · Peshtigo, WIBuilt 2006 · S/N 25171 N78303Citizen Air LLC · Port Angeles, WABuilt 1968 · S/N 17257560 N78428Cypher Anne K · The Dalles, ORBuilt 1968 · S/N 17257612 N784TBHaugh John F · Simpsonville, SCBuilt 2008 · S/N 60584

Back to Lycoming O-320-E2D