Skip to content

Lycoming IO-540-D4A5

Registered aircraft · 238

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

N1010EIndian Aire LLC · Water Mill, NYBuilt 2006 · S/N 40382 N1024NSolomon Jeremy M · Somerset, NJBuilt 2012 · S/N 3 FX026 N102KTPoler Steven P · Olympia, WABuilt 2014 · S/N 41059 N104CDOlson Timothy D · Elk Mound, WIBuilt 2006 · S/N 40170 N104EPEarwood Edward A · Sonora, TXBuilt 2012 · S/N 40820 N104GRMargolis David · Tucson, AZBuilt 2010 · S/N 40763 N104JGRoscioli Lamberto · Lighthouse Point, FLBuilt 2008 · S/N 40240 N104NRainey Norman W · Surprise, AZBuilt 2007 · S/N 40348 N104XPRv X Aviation LLC · Draper, UTBuilt 2006 · S/N 40111 N104ZURuttler James J · Bremerton, WABuilt 2015 · S/N 41103 N106VADeford Steven M · Livermore, CABuilt 2023 · S/N 41487 N1105Staley William J Jr · Medford, NJBuilt 2025 · S/N 001 N110SCClark Steven D · Bloomfield, INBuilt 2013 · S/N 40254 N111MEElliott Enterprises Group LLC · Wilmington, DEBuilt 2010 · S/N 073 N114MVMillin Andrew · Kalamazoo, MIBuilt 2012 · S/N 1 N115TPCavu Enterprises · Edgerton, WIBuilt 2013 · S/N 114 N1188CRobinson Samuel C · Knoxville, TNBuilt 2011 · S/N 40088 N1233TJesteadt Ronald J · Conneaut Lake, PABuilt 2018 · S/N 40306 N123CVVerhage Carroll L · Geneva, NEBuilt 2012 · S/N 41087 N142LMLamm Aviation Lc · Lees Summit, MOBuilt 2015 · S/N 41420 N143DVBruns Luke J · Flower Mound, TXBuilt 2007 · S/N 40026 N145RVColeman Ronald · Bastrop, TXBuilt 2011 · S/N 003 N152GHRegistration Pending · Edwards, CORegistration pendingBuilt 2012 · S/N 052-99/100-867 N157HSFairbairn Travis J · Fort Worth, TXS/N 40634 N16XVOlson Mark D · Longmont, COBuilt 2010 · S/N 168 N16YSSealing Edward L · Port Orange, FLBuilt 2015 · S/N 41251 N172KTWest Concrete Inc · Beaverton, ORBuilt 2007 · S/N 002 N174BKHall Brent Davis · Flagstaff, AZBuilt 2012 · S/N 40849 N184JMMiller John F Jr · Tullahoma, TNBuilt 2006 · S/N 40404 N1861GKestrel Aviation LLC · Marion, MTBuilt 2017 · S/N 41389 N19939Dream Seeker Inc · Wilmington, DEBuilt 2007 · S/N 40266 N1BYWigen Mary E · Porthill, IDBuilt 2012 · S/N 097 N203JJMidwest Aircraft Sales LLC · Lincoln, NEBuilt 2006 · S/N 40290 N210KHHale Greg D · Tulsa, OKBuilt 2010 · S/N 40385 N212FGWelch Charles E · North Chesterfield, VABuilt 2012 · S/N 40432 N215DWMoore David R · Granbury, TXBuilt 2012 · S/N 40455 N215TLLockard Theodore E Jr Trustee · Des Moines, IABuilt 2009 · S/N 40370 N222LKCoulter Lance A · Meeker, COBuilt 2009 · S/N 40262 N224APCloud Catcher Aviation LLC · Great Falls, MTBuilt 1977 · S/N 293/24-05 N225NTLattin Travis W · Beloit, KSBuilt 2024 · S/N 225 N2276WLisznianski Slawomir · Polson, MTBuilt 2022 · S/N 42128 N227APSagaponack Potato Company LLC · Sagaponack, NYBuilt 1977 · S/N 294 N227KPWinn Eric D · Maple Valley, WABuilt 2009 · S/N 40244 N229APBrown Jeffrey L · San Luis Obispo, CABuilt 1977 · S/N 296/24-08 N230APOak View Capital LLC · Brookhaven, MSBuilt 1977 · S/N 297/24-09 N234RNTucciarone Matthew · Amelia, VABuilt 2014 · S/N 40530 N238MJRivard Matthew G · Kansas City, MOBuilt 2025 · S/N 42596 N242BDDouglass Bryan C · Missoula, MTBuilt 2011 · S/N 40084 N24BJWasson Brian P · O Fallon, MOBuilt 2026 · S/N 42007 N24YMN24ym LLC · Madison, KSBuilt 2009 · S/N 40130

Back to Lycoming IO-540-D4A5