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.

N787TBWoods Phillip A · Cimarron, KSBuilt 1996 · S/N 22127 N78TGGardner Terrence L · Grassy Creek, NCBuilt 2021 · S/N 90743 N79198Azad Raja M · Hawthorne, CAS/N 17257952 N795MCLake John K · Park City, UTBuilt 2012 · S/N 356 N7962GR House Leasing LLC · Stormville, NYBuilt 1971 · S/N 17259662 N7971FJanes Christopher D · Columbia, KYBuilt 1966 · S/N 15064071 N8009KDoxey William Mark · American Fork, UTS/N 512 N80218Tom Hassenfritz Equipment Co Inc · Mount Pleasant, IABuilt 1975 · S/N 17266453 N825ABAchord James D · Decatur, ALBuilt 2010 · S/N 21748 N826DSSutton Douglas · Wichita, KSBuilt 2025 · S/N 02220236 N827FJMiller Andrew W · Palmer, AKBuilt 2022 · S/N 92010 N8286RHuhnke John F · Newburgh, INBuilt 1999 · S/N 103 N829BGGipson Robert E · Port Byron, ILBuilt 1968 · S/N 17700667 N82MTMalo Blake Ridgway Trustee · Portland, ORBuilt 2017 · S/N 004 N831GRGrahn James A · Las Vegas, NVBuilt 1988 · S/N 831 N836Furnari Jonathan P · Whitewright, TXBuilt 2014 · S/N HC-063 N8364TPrice Michael A · Carson City, NVBuilt 1961 · S/N 17557064 N84105Jost Jared D · Hillsboro, KSS/N 17258335 N842DBBrons Lawrence C · Canby, ORBuilt 2019 · S/N 70689 N84489Rinkenback Keven H · Kailua-Kona, HIBuilt 1970 · S/N 17258491 N8448MMohamed Jaleel · Dallas, TXBuilt 1969 · S/N A1500148 N84529Eckert Philip · Paso Robles, CABuilt 1969 · S/N 17258512 N856RHWijma Alexander Sotiri · Cumming, GABuilt 2009 · S/N 22032 N858SCNightscape Aerial Advertising LLC · San Diego, CAS/N 17265779 N859RAThree Green Inc · Wilmington, DEBuilt 2019 · S/N 75-10874 N86SMChase Aero LLC · Darrington, WABuilt 1986 · S/N 1973-L N8882ERandall Christopher D · Northridge, CABuilt 2008 · S/N 001 N88ETGelfan Russell A · Bellingham, WABuilt 1980 · S/N 202 N88TURv There Yet ? LLC · Lewes, DEBuilt 2013 · S/N 2956 N890DKKubik Darrel J · Boise, IDBuilt 2015 · S/N 90840 N8969VCrowley Brett A · Wasilla, AKS/N 17264325 N899NRichards Vallin J · Spearfish, SDS/N 4472 N89KAKenmore Air Harbor LLC · Kenmore, WABuilt 1973 · S/N 17261114 N901JWings Over Texas Holdings LLC · Denton, TXBuilt 1969 · S/N 17258779 N906RVFennell Stacy L · Conroe, TXBuilt 2006 · S/N 90330 N907TTHangar Ak LLC · Sterling, AKBuilt 1974 · S/N 17262358 N910LCEuroaviation Inc Trustee · KematenBuilt 1975 · S/N F17201256 N9124USmith Stanley P · Athens, ALBuilt 1976 · S/N 15078075 N915KKKramer Kurt J · Volcano, CABuilt 2022 · S/N 25744 N9177HLind Enterprises LLC · Manistee, MIBuilt 1976 · S/N 17265994 N917WETaylor William H II · Albuquerque, NMBuilt 1968 · S/N 17256920 N9193HPrairie Flyers Flying Club · Eudora, KSBuilt 1975 · S/N 17266006 N919RVSamadhi Clear Mind Yoga Retreat LLC · San Marcos, TXBuilt 2016 · S/N 72328 N923MGGoss Mark William · Lake Stevens, WABuilt 2023 · S/N 11328B N924DLester Christopher J · Vancouver, WABuilt 1994 · S/N 001 N929BMSuntops Aircraft Holding LLC · Lakeland, FLBuilt 1975 · S/N 17265826 N931RKFratt John R · Cleveland, TXBuilt 2007 · S/N 90140 N932WTRose Doug · Anderson, INBuilt 2013 · S/N 90747 N9333ZLong Todd A · Maple Plain, MNBuilt 2008 · S/N 1010 N93AZ93az LLC · Marietta, GABuilt 2003 · S/N 90017

Back to Lycoming O-320-E2D