Skip to content

Lycoming O-320-D1A

Registered aircraft · 116

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

N100SQBowles Chris · Taylorsville, NCBuilt 2018 · S/N 90359 N101DFFrench James H · College Park, MDBuilt 2000 · S/N 705R N110MAllen Ivan C · Saint Helens, ORBuilt 2021 · S/N 110 N116DPPaup Dennis C · Carroll, IABuilt 2006 · S/N 70194 N1179JWoldt Wayne E · Raymond, NEBuilt 2012 · S/N 91784 N123VEVerry James E · Prineville, ORS/N 90614 N123WSBibb Benjamin · Carlsbad, CABuilt 2008 · S/N 20501 N124SRCarr Wiley R · Rosharon, TXBuilt 1987 · S/N 865 N129BRMiller Theodore C Jr · Edinburg, TXBuilt 2008 · S/N 52A N129RVVans Aircraft Inc · Aurora, ORBuilt 2000 · S/N 2 N137DWDuck Wing LLC · Independence, ORBuilt 1987 · S/N S 37 N142CJSheppard Travis R · Redmond, ORBuilt 2007 · S/N 91286 N142DWNelson Jim · Midlothian, TXBuilt 1998 · S/N 2449 N1447ZHildebrand Dean A · Mesquite, TXBuilt 2012 · S/N 73178 N144MBBoarman Mark A · Clarkdale, AZBuilt 2007 · S/N 2866 N147CVAmparan Robert · Granbury, TXBuilt 2006 · S/N 91050 N149WSWexman Scott E · Port Hadlock, WABuilt 2008 · S/N 5257 N156CMOwens Christopher · New Auburn, WIBuilt 2012 · S/N 20361 N167CJMunn Oliver L · Ocala, FLBuilt 2010 · S/N 25879 N169RVFoster John O Jr · Hillsboro, ORBuilt 2013 · S/N 90574 N16PGGuerra Eduardo H · Polk City, FLBuilt 2000 · S/N 23918 N177EWMidwest Bush Co LLC · New Strawn, KSBuilt 1996 · S/N 23177 N194MHHoover Jeffrey M · Columbia, SCBuilt 2012 · S/N 90709 N20807Dyess William C · Franklin, TNBuilt 2005 · S/N 25772 N20LFFerguson Michael W · Burlington, WIBuilt 2020 · S/N 91029 N211XZDoty James A · Ocala, FLBuilt 2006 · S/N 82121 N216SMMoser Steve B · Mocksville, NCBuilt 2008 · S/N 91295 N222Foutz Robert V · Dublin, VABuilt 2008 · S/N 90988 N226XDildy Gary E · Nashville, ARBuilt 2011 · S/N 25837 N229RVElwell Joshua J · West Ossipee, NHBuilt 1995 · S/N 22029-RV6A N230EZMeyer Daniel B · Redding, CABuilt 2012 · S/N 462 N258MMGreene Leon Alfred Jr · Van Nuys, CABuilt 2007 · S/N 91442 N260JKKnight John S · Brewer, MEBuilt 2024 · S/N 806R N2745PColgan Paulette · Tucson, AZBuilt 2010 · S/N 90142 N279RVStewart James L · Garden City, TXBuilt 2016 · S/N 90299 N28KKAce Pdr LLC · Lewisville, TXS/N 2049 N29JVPrado Mike · Sugar Land, TXBuilt 2012 · S/N 91340 N29PKKillcommons Peter · Independence, ORBuilt 1991 · S/N S 56 N301FSNadh Development LLC · Santa Rosa, CABuilt 2022 · S/N 1565 N305KGBelisle Kenneth C · Jacksonville, FLS/N SN038 N321RCHitchen Robin J · Bernardsville, NJBuilt 2013 · S/N 90217 N3294CNorwood Kent L · Springfield, MOBuilt 2015 · S/N 90649 N339PJWallace James R · Aumsville, ORBuilt 2006 · S/N 90589 N339RVBillips Robert A · Bluefield, VABuilt 2016 · S/N 92170 N34CBCyrier John P · Lockhart, TXBuilt 1990 · S/N 2388 N359RWWells Rebecca K · Locust Grove, GABuilt 2014 · S/N 90640 N35JFBerry Damon R · Granbury, TXBuilt 2012 · S/N 1689 N36PFFoley Philip · Rathdrum, IDBuilt 2020 · S/N 90327 N377LMOliver Gerald D III · Midlothian, TXBuilt 2008 · S/N 648 N39CWWindham Charles R · Rogersville, TNBuilt 2012 · S/N 91447

Back to Lycoming O-320-D1A