Skip to content

Lycoming O-320-D2A

Registered aircraft · 72

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

N103LFChang Tien Chien · Port Orange, FLBuilt 2006 · S/N 91048 N112YMedeiros Joel · Lumberton, NJBuilt 2011 · S/N 9000-1 N123DRRitson Craig E · Weirsdale, FLBuilt 2023 · S/N 70822 N125GCChi Aerospace Inc · Portsmouth, NHBuilt 2007 · S/N 160A-07011 N12HEOlafsen George F · Greeneville, TNBuilt 2007 · S/N 91367 N13VAMcgrew Kevin P · Red Oak, IABuilt 2015 · S/N 90823 N13WKKnight Wallace R II · Collierville, TNBuilt 2007 · S/N 200401 N161DFulper Lester D · Clearwater, FLBuilt 2024 · S/N 5745 N1695Mcvey Steven A · Versailles, KYBuilt 2007 · S/N 91026 N174RVLutgring Thomas J · Parma, OHBuilt 2007 · S/N 90189 N189DWAurai Aeronautical Specialties LLC · Warner Robins, GABuilt 2021 · S/N 90080 N194WENightingale Jeffrey R · Gallatin, TNBuilt 2007 · S/N 90259 N19HVOlin Charles W · Union, WABuilt 2006 · S/N 90946 N202DLLeedham Donald R · Elk River, MNBuilt 2007 · S/N 102956 N208KKThomas Randall Darren · Exeter, CABuilt 2021 · S/N E571 N209SCInternational Air Services Inc Trustee · Carson City, NVBuilt 1976 · S/N 28-7625115 N276RVRegistered aircraftBuilt 2016 · S/N 20471 N295PCFleming Charles R · Merritt Island, FLBuilt 2003 · S/N 54864 N313RVBusbea Shawn · Conway, ARBuilt 2008 · S/N 11366 N314PTStrong Thomas W · Rigby, IDBuilt 2006 · S/N 90489 N318MBHenderson Michael E · Edmonds, WABuilt 2006 · S/N 5661 N320STGuaglione Anthony · El Dorado Hills, CABuilt 2006 · S/N S-10002 N337CWWebb Peter C · Rockport, MEBuilt 2010 · S/N 90811 N343PCCloutier Philip L · Sparks, NVBuilt 2015 · S/N 1655 N3446Benjamin Harold E · New York, NYBuilt 2012 · S/N 3446 N345HUSkydotcom LLC · Inver Grove Height, MNBuilt 1996 · S/N 1312 N359HWChenier Anthony D · Longview, WABuilt 2006 · S/N 90035 N365DLSoehner Harold D · Winslow, AZBuilt 2009 · S/N DAL001 N370DLLee David · Skaneateles, NYBuilt 2024 · S/N 02210162 N376EShepard Rockwood S · Williamston, MIBuilt 2020 · S/N 92094 N38KPAero Equity LLC · Boise, IDBuilt 2006 · S/N S-0014 N38RGGee Kevin D · Chandler, TXBuilt 2020 · S/N 72564 N417CTGleaton Benjamin F · Waycross, GABuilt 2007 · S/N 91365 N417LLutes David W · Berryton, KSBuilt 2000 · S/N 22952 N418STDoan Michael C · Phoenix, AZBuilt 2018 · S/N MR411 N459RVBenjamin David J · La Porte, INBuilt 2009 · S/N 021207 N46362Weber Scott · Hastings, MNBuilt 2001 · S/N 0018 N506PCShettlesworth Ryan C · Bloomington, INBuilt 1992 · S/N 1465 N511PCClear Skies Avionics Inc · Clearwater, FLBuilt 1993 · S/N 1539 N5121KTebbe Francis L · Maryville, ILBuilt 2007 · S/N 1308 N51HSGilbert Joe M · Sapulpa, OKBuilt 2006 · S/N 91126 N53PDHume James W · Valley View, TXBuilt 1987 · S/N 1202 N54WYBernegger Mark S · West Point, MSBuilt 2013 · S/N WF0002 N5578FJarvis Trent A · Apo, AEBuilt 1972 · S/N FA-200-180 N580SKEary Enterprises LLC · Peoria, AZBuilt 2006 · S/N S-0013 N61NDPilot Partners LLC · Saint Augustine, FLS/N 25675 N624TFDominy Kenneth W · Ave Maria, FLBuilt 2006 · S/N 5405 N625DKKnight Doug B · Jefferson, ORBuilt 2006 · S/N 90625 N638SAJohnson James W · Panama City, FLBuilt 2005 · S/N S-0001 N670BBeck Mark A · Fort Wayne, INBuilt 2007 · S/N 60176

Back to Lycoming O-320-D2A