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.

N226RTMilke Shaun M · Anchorage, AKBuilt 2018 · S/N 01-1193 N226RVWells James E · Beavercreek, OHBuilt 2014 · S/N 12-1471 N230FDConnolly Robert · Carmel, NYBuilt 2006 · S/N 1753 N231RVJacks Brian Douglas · Wilsonville, ALBuilt 2005 · S/N 7221 N235RMScroggs Ross A · Locust Grove, GABuilt 2023 · S/N 3911 N23TXFisher Richard K · Horseshoe Bay, TXBuilt 2014 · S/N 11022 N2423MHarrington Robert D · Chico, CABuilt 2024 · S/N 90611 N247KBPaap Patrick S · Menifee, CABuilt 1985 · S/N 798 N248TTLohrman Lonny A · Wichita, KSBuilt 2018 · S/N 25408 N267MSweetman Gary S · Wolcott, CTBuilt 2006 · S/N 90607 N2785RTorqerson Leif H · Cut Bank, MTBuilt 2007 · S/N 122 N27EGVetterman Larry D · Hot Springs, SDBuilt 2017 · S/N 062 N27KPMcgaughey Patrick L · Los Alamos, NMBuilt 2007 · S/N 22066 N284SMMurray Stephen H · Flat Rock, NCBuilt 2026 · S/N 1179 N2856AOne Grand Adventure LLC · De Pere, WIBuilt 2007 · S/N 007 N295ABFogerty Barry L · Shawnee, OKBuilt 2015 · S/N 23322 N29SMGarner Hannah L · Tupelo, ARBuilt 2014 · S/N 90578 N29YDPerry David · Las Vegas, NVS/N 4456 N2NUEkstrand Marshall C · Lake Stevens, WABuilt 2010 · S/N 602 N303KTTarver Dalton K · Fallon, NVBuilt 2018 · S/N M2-938 N304PRRedlands Air And Road Museum · Yucaipa, CABuilt 2014 · S/N 001 N307KKSharp Gary · Rigby, IDBuilt 2017 · S/N 75-8782 N31299Brion William F · Chugiak, AKBuilt 2005 · S/N 001 N314MFGobel Victor M · White City, ORBuilt 2023 · S/N JA5980920 N314RVRegistered aircraftBuilt 2007 · S/N 802 N316MMattson Douglas L · Dike, IABuilt 2009 · S/N 91035 N316SDHamilton Scott Richard · Fort Worth, TXBuilt 2006 · S/N 23582 N320BMSchenk Jonathan M · Amarillo, TXBuilt 2019 · S/N 96M N325KMorris Timothy J · Fairfield, OHBuilt 2009 · S/N 102 N325RHHensley Roger A · Rosamond, CABuilt 2016 · S/N 543-320-290 N339AGGirard Albert J · Portsmouth, RIBuilt 2017 · S/N 92001 N349RVJs Aircraft Group LLC · Lewes, DEBuilt 2020 · S/N 90015 N35735Gaston Brothers Excavating Inc · Seattle, WAS/N 17256943 N359WEiden Ryan J · Albany, MNBuilt 2012 · S/N 463 N361AKAronson Kenneth I Trustee · Truckee, CABuilt 2016 · S/N 91935 N366RAdema Walker · Enid, OKBuilt 2007 · S/N 23100 N369PPPositive Attitude Ia LLC · Gaithersburg, MDBuilt 1974 · S/N 17263099 N36EJKessler Rafael · Alamogordo, NMBuilt 2007 · S/N 413-1936 N372GMShetterly Gregory W · Warrensburg, MOBuilt 2010 · S/N 97-0396 N3803QAmerican Patrols Inc · Midland, TXBuilt 1971 · S/N 17259903 N3807JJohnson Gunnar W · Wasilla, AKBuilt 2012 · S/N 00100 N393THDobesh Craig L · Granbury, TXS/N 8 N3940QN3940q LLC · Newnan, GABuilt 1971 · S/N 17260040 N4066BKuipers Abram B · Derby, KSBuilt 2007 · S/N 23198 N406ZShapiro Jeffrey M · South Beach, ORBuilt 2009 · S/N MB 1201 N414DEdgewater Aviation LLC · Lake Havasu City, AZBuilt 1999 · S/N 460 N419JNWheeler Kelly · Columbia Falls, MTBuilt 2017 · S/N 419 N419RStruthers Robert J · Geneva, ILBuilt 2009 · S/N 0001 N41VBVon Bevern Brian J · Overland Park, KSBuilt 2008 · S/N 21583 N425KWWooten Kurt R · Wichita, KSBuilt 2014 · S/N 14001

Back to Lycoming O-320-E2D