Skip to content

Lycoming O-540-E4B5

Registered aircraft · 21

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

N134RTTaylor Robert E · Soldotna, AKBuilt 2017 · S/N 78 N154RVLavalley Thomas L · Colorado Springs, COBuilt 2015 · S/N 004 N220EXRodriguez Henry Solano · Charlotte, NCBuilt 2010 · S/N 97143 N253PRRenaud Paul D · Tenafly, NJBuilt 2012 · S/N 40686 N3119XReese Travis A · Glade Park, COBuilt 2007 · S/N 001 N3593WGriffin Julie A · Locust Grove, GABuilt 1966 · S/N 32-489 N3922WSteffey John · Saint Augustine, FLBuilt 1967 · S/N 32923 N408PTRegistered aircraftBuilt 1981 · S/N 1 N4769SRedemption Leasing LLC · Kodiak, AKS/N 32-1177 N4878SGarmin International Inc · Salem, ORBuilt 1971 · S/N 32-7100002 N540CZOrr David A C · Lake Forest, CABuilt 2006 · S/N 0673 N540KLJohannes Dale R · Whitefish, MTBuilt 2014 · S/N 1083 N57GFKuklo Robert M · Livermore, CABuilt 2012 · S/N RK1-008 N6098MAnderson Luther B Jr · Wasilla, AKBuilt 1947 · S/N 108-4098 N60LYLeon Roberts Enterprises LLC · Vienna, VABuilt 1965 · S/N 32-10 N6234XMoeller Raymond H II · Willowbrook, ILBuilt 2019 · S/N 001 N655XRoyall Michael B · Morgan, UTBuilt 2008 · S/N 54 N7081HTaubert Martyn Wayne · South Yarmouth, MABuilt 1971 · S/N 32-7100028 N728HRVelasco Higareda Ignacio L · Valencia, CABuilt 2009 · S/N 007 N77RMBendure Ryan R · Brighton, COBuilt 2012 · S/N 200 N817LHHavelka Lambert H · Mc Gregor, TXBuilt 2017 · S/N 41054

Back to Lycoming O-540-E4B5