Skip to content

Lycoming IO-540-G1D5

Registered aircraft · 26

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

N129GCBlue Air Training Corp · Las Vegas, NVBuilt 1980 · S/N 55 N197ATBlue Air Training Corp · Las Vegas, NVBuilt 1974 · S/N 07 N218BWRoelofs David M · Prescott, AZBuilt 1975 · S/N 18 N3074DRigoni Terry · Prescott, AZBuilt 2012 · S/N 014SR N330JKAldrich Gregory C · Sarasota, FLBuilt 2010 · S/N 009 N330WLLee William L · Jonesborough, TNBuilt 2015 · S/N 011 N47XXEagle Air LLC · Boulder, COBuilt 1977 · S/N 30 N540MLTeebird Enterprises LLC · Brighton, COS/N 008 N604ATBrowning Larry L · Mountain View, CABuilt 2018 · S/N 060 N61289Huff Zachary Daniel · Mesa, AZBuilt 1974 · S/N 03 N6134JBlue Air Training Corp · Las Vegas, NVBuilt 1974 · S/N 08 N749DMPreferred Metalfab Inc · Mora, MNBuilt 2009 · S/N 109SR N823AAAnduze Helicopter LLC · West Palm Beach, FLBuilt 1977 · S/N 32 N823CKelly Mark D · Whitefish Bay, WIBuilt 1982 · S/N 73 N823DCSwanberg Charles Marvel · Sandia Park, NMBuilt 1983 · S/N 78 N823EHRogers Derek P · Lawrence, KSBuilt 1977 · S/N 33 N823JTJohnson Thomas Cavanagh · Scottsdale, AZBuilt 1976 · S/N 27 N823KUGeaney Joseph P III · Cabot, ARBuilt 1979 · S/N 51 N823RMRegistration Pending · Las Vegas, NVRegistration pending, pending cancellationBuilt 1977 · S/N 35 N823SHBlue Air Training Corp · Las Vegas, NVBuilt 1975 · S/N 12 N823TABlue Air Training Corp · Las Vegas, NVBuilt 1981 · S/N 71 N823WLigon Robert E III · Warner Robins, GABuilt 1976 · S/N 25 N823WTHillerman David A · Denair, CABuilt 1976 · S/N 24 N823YHoyt Charles · Wadsworth, OHBuilt 1982 · S/N 06 N88ZGBrandt Gray L · San Diego, CAS/N 010 N9047FOwens Todd C · Marietta, GABuilt 1977 · S/N 34

Back to Lycoming IO-540-G1D5