Skip to content

Lycoming 0-145A series

Registered aircraft · 30

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

N1117HSenf Raymond L · Central Square, NYS/N 15-332 N17226Eaa Chapter 1077 · New Philadelphia, OHBuilt 1939 · S/N 1892 N192TTTerning Thomas N · Sedan, KSBuilt 1995 · S/N 1932P N22227Withrow Thomas E · Lewisburg, WVS/N 1173 N22258Fischer Alfred M DBA · Genoa City, WIS/N 1206 N22364Wagner Daniel L · Howe, INBuilt 1939 · S/N L-3609 N22671Snider Tim · Port Townsend, WABuilt 1939 · S/N 1318 N23601Whitaker Cecil D · Pryor, OKBuilt 1939 · S/N 1325 N23836Hofacker Paul E · Brookville, OHS/N 1472 N23869Boggs Ricky L · London, OHBuilt 1939 · S/N 1505 N23952Ford Dale E · Ripley, OKBuilt 1939 · S/N L6089 N24076Homolka James D · Ellsworth, KSBuilt 1940 · S/N 1611 N24232York Stanley A · Leetonia, OHBuilt 1939 · S/N L6999 N24312Eisenhauer Corp · Erwinna, PABuilt 1940 · S/N 1647 N24430Pryce James T · Ebensburg, PABuilt 1940 · S/N 1766 N24444Kusch Kim G · Hot Springs, SDBuilt 1940 · S/N 1781 N25876Johnson Richard E · Duluth, MNBuilt 1939 · S/N 3826 N26085Van Nostran Seth A · Doylestown, OHS/N 4023 N26554Taylor Kenneth R · Seminole, OKBuilt 1940 · S/N 1896 N36537Terrell Mark · Greentown, INBuilt 1941 · S/N LB-16131 N379AWingnut Inc · Wilmington, DEBuilt 1949 · S/N 40 N38797Hopkins Elizabeth Reeves · Sunnyvale, TXBuilt 1941 · S/N 7274 N3881WKincaid Bruce W · Garland, TXBuilt 1967 · S/N 32-827 N41110Davis Chris D · Athens, GAS/N 7756 N4314HCragg Noel J · Millbrae, CABuilt 1948 · S/N 15-96 N4473HUhlenhopp Eldon K · Ames, IABuilt 1948 · S/N 15-261 N48365Ching Robert · Elsie, MIBuilt 1976 · S/N 1 N51528Good Enuf LLC · Wilmington, DEBuilt 1943 · S/N 10415 N51776Pennewell Ollie Lee · Hannibal, MOBuilt 1992 · S/N 1 N612CBelton Mark S · Eugene, ORBuilt 1948 · S/N 5

Back to Lycoming 0-145A series