Skip to content

Engineering & Research ERCOUPE 415-CD

Registered aircraft · 31

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

N3177HLandon Jeff A · Lancaster, CABuilt 1946 · S/N 3802 N3314HFortune Conversions Corp · Cave Creek, AZS/N 3939 N3322HMeyer Edward Earl · Bolingbrook, ILBuilt 1947 · S/N 3947 N3406HBarnett Paul S · Brookhaven, MSBuilt 1948 · S/N 4031 N3544HShelton Flight LLC · Olympia, WABuilt 1946 · S/N 4169 N3555HStuckle Eugene A · Davenport, WABuilt 1947 · S/N 4180 N3581HDickard Gary D · Kimberly, IDBuilt 1947 · S/N 4206 N3632HMurry William V · Ocala, FLBuilt 1947 · S/N 4257 N3800HJensen Robert P · Vallejo, CAS/N 4501 N3804HGregory Vernon L · Swansea, SCBuilt 1947 · S/N 4505 N3828HYagel Michael J · Raymond, KSBuilt 1947 · S/N 4529 N3849HLooper Bobby L · Marion, TXS/N 4550 N3881HPoliak Mark A Trustee · Carmel, INBuilt 1947 · S/N 4582 N3892HDezso Joseph A · Arroyo Grande, CABuilt 1947 · S/N 4593 N3900HGraziano Thomas K · Benson, AZBuilt 1947 · S/N 4601 N3939HCoupe Nh LLC · East Helena, MTBuilt 1947 · S/N 4640 N3950HKlein Jerry L · Athens, MIBuilt 1947 · S/N 4651 N3984HDebrosse Stephen C · Avon Lake, OHBuilt 1947 · S/N 4685 N415CMFieldgrove Matt · Somerton, AZBuilt 1947 · S/N 4259 N94601Specht Leo M · Towner, COS/N 4702 N94634Glover Johnathon H · Konawa, OKBuilt 1947 · S/N 4741 N94635Larson Erick W · Fergus Falls, MNBuilt 1947 · S/N 4742 N94638Reed Aviation LLC · Pearl, MSBuilt 1947 · S/N 4745 N94648Odonnell John F III · Newbury, VTBuilt 1947 · S/N 4755 N94664Specht Leo M · Towner, COS/N 4775 N94670Van Kampen Anthony J · Weyauwega, WIBuilt 1947 · S/N 4781 N94675Poliak Mark A Trustee · Carmel, INBuilt 1947 · S/N 4786 N946PElliott Frank F · Mojave, CABuilt 1947 · S/N 4792 N94712Schamberger Kenneth E · Austin, MNBuilt 1947 · S/N 4823 N94740Ohanlon John M · Oshkosh, NEBuilt 1946 · S/N 4851 N96BKBernier Brian M · Austin, TXS/N 4751

Back to Engineering & Research ERCOUPE 415-CD