Skip to content

A.C.E. HIDR MARK III

Registered aircraft · 12

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

N11335Gardner Air LLC · Paragon, INS/N 248 N12611Hodgdon Theodore E III · Danbury, CTBuilt 1931 · S/N 1013 N12674Petro Jerry R · Williamsburg, VABuilt 1932 · S/N 1033 N15865Aircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1936 · S/N 302 N2816Western Antique Aeroplane & Automobile Museum · Hood River, ORBuilt 1933 · S/N 1053 N2871Petro Jerry R · Williamsburg, VABuilt 1933 · S/N 1055 N592EBalcerzak Gregg A · Maumee, OHBuilt 1929 · S/N 18 N624RHarris Joel E · Saratoga, CABuilt 1929 · S/N 85 N647KHoover Michael B · Ridgeland, WIBuilt 1930 · S/N 111 N833KAshley James M · Greenwood, SCBuilt 1930 · S/N 94 N866KSdl Enterprises LLC · Akron, IABuilt 1930 · S/N 127 N915NMadden William L · Las Cruces, NMBuilt 1929 · S/N 145

Back to A.C.E. HIDR MARK III