Skip to content

Lycoming AEIO-360-H1A

Registered aircraft · 8

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

N214CMKentucky Fly Boys Aviation LLC · Vine Grove, KYBuilt 1978 · S/N 372-78 N360WSWood Scot L · Irvington, ALBuilt 2014 · S/N 1482 N5528KGates Steven S · Midlothian, TXBuilt 1978 · S/N 388-78 N5731ASimpson Christopher David · Reno, NVBuilt 2001 · S/N 3616 N59MSSojka Michael J · Bainbridge, INBuilt 1994 · S/N 735-94 N787RHRushing Christian W · Savannah, GABuilt 1978 · S/N 435-78 N789WEStoked Aero LLC · Camas, WABuilt 1992 · S/N 666-92 N84JAAndre Joseph L · Puyallup, WABuilt 2006 · S/N 80602

Back to Lycoming AEIO-360-H1A