Engineering & Research ERCOUPE 415-C
Registered aircraft · 272
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 ('0420312')
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 ('0420312')
ORDER BY n_numberRun 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.
N99494Eaa Chapter 1590 Inc · Morrilton, ARN99535Brown David L · Hayesville, NCN99547Komara Lawrence · Fort Worth, TXN99577Alfred E Mcmillin · Parma, IDN99586Abrams David · Boston, MAN99630Denniston John A · Albion, NYN99651Shanks Von R · Nashville, NCN99694Sosnick Robert A · Saltsburg, PAN99705Howard Christopher J · New London, MNN99734Leonard Daniel J · Huntington, INN99761Delong Ronald D · Pueblo, CON99762Dr Carlton N Walker Dds LLC · Roswell, NMN99773Goode Jeremiah M · Broadway, VAN99784Montgomery Robert L · Kingman, AZN99810Taschwer Jeffrey T · Mcfarland, WIN99811Gregory Vernon L · Swansea, SCN99853Aviation Museum Of Santa Paula · Santa Paula, CAN99891Earl John M · Mccall, IDN99909Jesch Jeffrey P · Reno, NVN99913Gregory Vernon L · Swansea, SCN99927Azeredo Ian · Ringwood, NJN99960Barnes Lloyd L · Independence, OR
Back to Engineering & Research ERCOUPE 415-C