Skip to content

Lycoming O-540-B4B5

Registered aircraft · 40

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

N1058TRock Island Aviation Inc · Wilmington, DEBuilt 2010 · S/N 23107C N166AZJantzon Markus I F · Kingwood, TXBuilt 1969 · S/N 28-11320 N17PFlying M LLC · Reno, NVBuilt 2008 · S/N 23106C N205MXHlavnicka Thomas L · Big Sandy, MTBuilt 1999 · S/N 15006C N2611TW&H Services LLC · Boerne, TXS/N 23102C N287MCValiair Lc Trustee · Casper, WYBuilt 2001 · S/N 25045C N292FWWallace Fred R · Wheat Ridge, COBuilt 2006 · S/N 8-4220 N3019TDanner Eric C · Benton, KSBuilt 2007 · S/N 23099C N307HPButler Tracey D · Buckley, WABuilt 2006 · S/N 102 N3179ULawson John A · Lott, TXBuilt 1995 · S/N 20028C N365NGReid Michael V · Sulphur Springs, TXBuilt 1968 · S/N 28-11124 N4055XAtlas Air LLC · Salt Lake City, UTBuilt 1974 · S/N 5055C N422NPGarvin Honi J Trustee · Monument, COBuilt 2007 · S/N 23103C N442PMBusby James D II · Port Saint Lucie, FLBuilt 2008 · S/N 40105 N528RWChaplin Michael A · Marathon, FLBuilt 1970 · S/N 28-11342 N574HBIngram Grant Leigh · Hurricane, UTBuilt 2021 · S/N 4134C N5937VLeftridge Dustin · Kalispell, MTBuilt 1977 · S/N 28-7710044 N595ZEvans Samuel F · Iuka, MSBuilt 2008 · S/N 23105C N616RSHubert Richard A · Fowlerville, MIBuilt 2012 · S/N 700 N656LRHays Robert E · Saint Paul, MNBuilt 2014 · S/N 656 N681GBBurgett Glenn E · Wooster, OHBuilt 2009 · S/N 681 N68TYKing Ty · Rogers, ARBuilt 1968 · S/N 28-11207 N719DFDubroc Marcus C · La Place, LABuilt 1975 · S/N 287510046 N719JSJensen Perry · Cameron Park, CABuilt 2008 · S/N 050-91/92-796 N7235AValiair Limited Co Trustee · Casper, WYBuilt 2026 · S/N 24002C N7313ZSimmons Mark A DBA · Pawcatuck, CTBuilt 1965 · S/N 25-3245 N734JReynolds John C · Macon, GABuilt 2006 · S/N 23091C N77077Hammarback Inc · East Grand Forks, MNBuilt 1977 · S/N 28-7710019 N787GWRegent Trust Corp Trustee · Wichita, KSBuilt 2004 · S/N 25101C N7904CVaught Jon M · Stillwater, OKBuilt 1976 · S/N 28-7610064 N79VEIsocelestian Concepts LLC · Pelzer, SCBuilt 2023 · S/N 25118C N812RRAstraeus LLC · Greenport, NYBuilt 2004 · S/N 25100C N825HBGallegos Joel · Yellville, ARBuilt 1967 · S/N 28-10861 N886ZJohn Galt LLC · Fairbanks, AKBuilt 2022 · S/N 4135C N8889WNedoba John · Stevensville, MIBuilt 1964 · S/N 28-10450 N8974WRassmussen Troy · Fayetteville, NCBuilt 1966 · S/N 28-10811 N9027WAg Air Squadron One LLC · Saint Joseph, ILBuilt 1965 · S/N 28-10617 N9209FAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1990 · S/N 4102C N9289WCoffman John H · Polo, ILBuilt 1967 · S/N 28-10966 N963MRAerospace Trust Management LLC · Wilmington, DEBuilt 1967 · S/N 28-10838

Back to Lycoming O-540-B4B5