Skip to content

Lycoming O-235-L2C

Registered aircraft · 84

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

N114JKKrueger Grant M · Fort Bragg, CAS/N 2006-1 N1170YMacmullen Kenneth P · Quakertown, PAS/N 15059570 N124LFForsgren Lyle M · Oshkosh, WIBuilt 2015 · S/N 120465 N145TNewcomb Robert E · Greenfield, INBuilt 2021 · S/N 6-4971 N152BBJensen Harold G · San Antonio, TXBuilt 1979 · S/N 15283831 N161GBEagle Aviation LLC · Anchorage, AKBuilt 2015 · S/N MBL-002 N164NATaylor Steven · Des Arc, ARBuilt 1978 · S/N 3878A0403 N168HWClement Jim L · Baraboo, WIBuilt 2012 · S/N JC 12 N16JBRegistration Pending · Pawleys Island, SCRegistration pendingS/N 151 N1906LMosher David A · Pacifica, CABuilt 2016 · S/N 1906 N1WRRyan William R · Jupiter, FLS/N 1845 N213MKKwiatkowski Matthew A · Minooka, ILBuilt 2008 · S/N 213 N234WYEdgeington Randall K · Riverton, WYBuilt 2013 · S/N S9910-0221 N235BDDondi Beda C · Fort Lauderdale, FLBuilt 2011 · S/N 1686N N235KMckinney Steve R · Hamersville, OHBuilt 2005 · S/N 2 N235TJDickerson Timothy J · Woodlake, CABuilt 2013 · S/N S95010090 N241HRHickey Timothy J · Montrose, IABuilt 2016 · S/N 808R N252SFConlisk Christopher M · Hephzibah, GABuilt 2007 · S/N 66285 N2552DKindred Heather · Dania, FLBuilt 1978 · S/N 38-79A0368 N26CARogers Patricia A · Albany, ORBuilt 1979 · S/N 15283794 N275CWLunde Craig W · Fort Shaw, MTBuilt 1946 · S/N 1744 N277LTBeechnutz Aviation LLC · Atlanta, GABuilt 1981 · S/N WA277 N2815TNorwest Ventures LLC · Sagle, IDBuilt 1978 · S/N 15282250 N313KFGrahl Nickolas W · Appleton, WIBuilt 2012 · S/N S97060216 N324VRBrown Everett L · Yuma, AZBuilt 1985 · S/N 861 N331GZN331gz LLC · Fort Myers, FLBuilt 1980 · S/N WA-116 N335ERunia Allan D Trustee · Gold Hill, ORBuilt 1992 · S/N 246 N357HAWagner Rickey J · Stacy, MNBuilt 2008 · S/N NEICO AVIATION #90 N3663Carter Jay M · Mountain Home, ARBuilt 2017 · S/N C75-10112 N3915Crestair Air LLC · Dover, DEBuilt 2006 · S/N 2502B N398JMRohrs Jack L · Henderson, NVBuilt 2012 · S/N 398 N39ESHowell Jeff D · Payette, IDBuilt 2010 · S/N 0100 N401VFSchoenberger Neil J · Saint Petersburg, FLBuilt 2013 · S/N 91486 N409WMKlink John A Jr · Farmington, PABuilt 2012 · S/N 66870 N418KN418k LLC · Jupiter, FLBuilt 2016 · S/N 005 N419YBBlum Bradley R · Waukesha, WIBuilt 2011 · S/N 4566 N4224HWharton William R Jr · Dresden, OHBuilt 1978 · S/N 152-80324 N4417HBalunek Konrad K · Avon, OHBuilt 1986 · S/N F-1516 N44WBEvans Jerry R · York, PABuilt 1980 · S/N A1520909 N476PWGorton Gregory A · Ballston Spa, NYBuilt 2012 · S/N 1432 N48167American Aviation Inc · Brooksville, FLBuilt 1979 · S/N 15283293 N4818FCragg Philip A · Point Roberts, WABuilt 1981 · S/N WA311 N48239Harrell Robert L · Brooksville, FLBuilt 1979 · S/N 15283307 N485PALapointe Arthur L · Powder Springs, GABuilt 2017 · S/N 048 N496URRabins Jaime · Chatham, ILBuilt 2015 · S/N 65-8631 N49808Holloway James H · Merritt Island, FLBuilt 1979 · S/N 15283519 N49SMMaxwell Edward · Louisville, KYBuilt 2009 · S/N 001 N5180BRoberts Toney K · Batesville, MSS/N 6-6833 N521QJJacobi John W · Fort Collins, COBuilt 2016 · S/N 001 N52MSTaylor Jerry D · Blair, NEBuilt 2011 · S/N 050900074

Back to Lycoming O-235-L2C