Skip to content

Engineering & Research ERCOUPE 415-D

Registered aircraft · 24

Aircraft of this model 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 aircraft_model_code IN ('0420316')
  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 aircraft_model_code IN ('0420316')
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.

N2068HPhilip Eckert R · Paso Robles, CAS/N 2691 N21JWMaximus Aviation LLC · Cheyenne, WYBuilt 1946 · S/N 2358 N222PMennenga Michael J · Ocala, FLBuilt 1946 · S/N 3684 N2386HBerkebile Lynn B · Twin Falls, IDBuilt 1946 · S/N 3011 N2439HPumphrey Vickie E · Devine, TXBuilt 1946 · S/N 3064 N2854HMiller Matthew A · Marine St Crx, MNBuilt 1946 · S/N 3479 N3040HSmith Raymond E · Hazlehurst, GABuilt 1946 · S/N 3665 N3070HObrien Aviation Inc · Port Orange, FLBuilt 1946 · S/N 3695 N3362HMcavay Thomas Jacob · Sophia, NCS/N 3987 N556PKKenney Patrick J · Billings, MTS/N 4736 N5DGNibler Anthony A · Klamath Falls, ORBuilt 1946 · S/N 1633 N87349Blackner Justin A · Fontana, CABuilt 1946 · S/N 522 N87359Manning Gary · Newalla, OKBuilt 1946 · S/N 532 N93355Brunettin Mark · Frierson, LABuilt 1946 · S/N 678 N93492Trone Gary L · Taylorville, ILS/N 815 N93503Rankovich Danny · Lehighton, PAS/N 826 N93609Anderson Wilbur W · Diamond City, ARBuilt 1946 · S/N 932 N93931Arnie Or Sharon Schweer LLC · Helena, MTBuilt 1946 · S/N 1254 N94196Cohen Sydney B · Wausau, WIBuilt 1946 · S/N 1519 N99027Sims Philip · Otis, COBuilt 1946 · S/N 1650 N99206Gregory Vernon L · Swansea, SCBuilt 1946 · S/N 1829 N99284Winter Jack W · Custer, SDS/N 1907 N99658Gregory Vernon L · Swansea, SCBuilt 1946 · S/N 2281 N99698Beecher Dennis L · Martinsburg, PABuilt 1946 · S/N 2321

Back to Engineering & Research ERCOUPE 415-D