Skip to content

Leblond 70 series

Registered aircraft · 17

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

N14475Smith Peter A · Lockport, NYS/N 132 N14485Martinez Anthony III · Great Bend, KSBuilt 1935 · S/N 403 N14486Owen Jayson · Tampa, FLBuilt 1935 · S/N 406 N14488Wingnut Inc · Wilmington, DEBuilt 1935 · S/N 405 N15444Richards Thomas D · Krum, TXBuilt 1935 · S/N 144 N15809Airpower Museum Inc · Ottumwa, IABuilt 1936 · S/N 445 N15898Andrews Leon V · Germantown, TNS/N 478 N16495Kerr Rodney W · Lincoln City, ORS/N 195 N17026Workman Paul E · Urbana, OHBuilt 1936 · S/N 225 N17029Williams David R Jr · Bellevue, WABuilt 1936 · S/N 229 N17038Reid Marici · Independence, ORBuilt 1937 · S/N 238 N3079Parker Richard B · Orange, CABuilt 1929 · S/N 337 N320NRhinebeck Aerodrome Museum · Rhinebeck, NYS/N 2-59 N32320Boelman Scott · Whittier, CABuilt 1940 · S/N 778 N34814Schiermeister Lloyd G · La Center, WABuilt 1941 · S/N 916 N41655Pearlman Aircraft Co · Orlando, FLBuilt 1941 · S/N 1035 N804MAero Mobil Inc · Wilmington, DEBuilt 1929 · S/N 431

Back to Leblond 70 series