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.
N3372HPapich William · Boston, NYN3431HBuchanan Richard C · Westminster, SCN3434HBradley James C · Springfield, ORN3518HPaceinnovations Inc · Fort Worth, TXN3552HSpecht Leo M · Towner, CON3566HWilson Theron C · Chugiak, AKN3575HKinser Randall C · Minerva, OHN35VAuburn University · Auburn, ALN3625HCurrie Mark H · Justin, TXN3647H1287e LLC · Cold Spring, NYN3658HAshlock Donald Earl · Rockwall, TXN3665HKastella Kobuk · Independence, ORN3669HLee Justin W · Maud, TXN3680HDavis Vincent W · Spirit Lake, IAN36ECGarcia Raymond F · Gilroy, CAN3709HSmith Don E · Carmel, INN37107Gregory Vernon L · Swansea, SCN3731HStillman Holbrook · Lordsburg, NMN3736HGrald Jonathan A · New Hampton, NYN3785HGregory Vernon L · Swansea, SCN3787HSpringman Brandt L · Riverton, WYN411FClement Robert D · Arizona City, AZN415BPSchwettmann Dennis E · Nampa, IDN415CBHowell Dave B · Orlando, FLN415DKMoore Elmer L Sr · Weston, WVN415EHDane-Muterspaugh Julie W · Weirsdale, FLN415FBrigger Teddy D · Clarion, IAN42ECCase Sean · Seward, NEN43PAKolb Airport Flying Club · Phoenixville, PAN552SMMondloch Jesse R · Freedom, WIN58585Atkinson James A · Bouse, AZN588BJErcoupe LLC · Orlando, FLN616PTPrice Penelope · Bloomington, INN66ZYHarris Gregory · Huntingdon Valley, PAN738Massey Air Museum Inc · Massey, MDN8501JWillis James R · Belleview, FLN86961Sale Reported · Grove, OKSale reportedN86991Gregory Vernon L · Swansea, SCN86997Corry Thomas F · Rockport, TXN87018Hier Richard · Lambert, MTN87023Chickasha Wings Inc · Chickasha, OKN87112Morrilton Flying Club Inc · Conway, ARN87207Crofut Reha A · Westville, OKN87226Strong Neil E · Pittsburg, TXN87237Tallent Chris M · Horatio, SCN87279Pankey Eric S · Claremore, OKN87284Kromrey Edward P · Saint Croix Falls, WIN87301Dizer William D · Poland, INN87308Cato James W · Las Cruces, NMN87323Cardwell Gregory D · Cameron Park, CA
Back to Engineering & Research ERCOUPE 415-C