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.
N87405Specht Leo M · Towner, CON87423Texas Air And Space Museum Inc · Amarillo, TXN87426Safety-Net LLC · Salem, INN87436Moore James E · Woodstock, GAN919BJGilson Alexander · Austin, TXN91NMccutchan Clay T · Milton, FLN93301Holland Randall M · Las Vegas, NVFirst renewal noticeN93306Ercoupeaire LLC · Blackwood, NJN93341Soest Ernest D · Quartz Hill, CAN93348Post George G · Mapleton, KSN93369Taylor Raymond E · Oklahoma City, OKRegistration revokedN93386Mahon David L · Payson, ILN93388Manda Forrest G · Pleasant Hill, MON93425Hoffman Harrison · Port Aransas, TXN93437Bums Joyce A · Sparta, MON93450Bodeker Richard W · Vermilion, OHN93451Recine John N · Lititz, PAN93491Craig J Douglas · Santurce, PRRegistration revokedN93502Corbin Russell B · North Olmsted, OHN93512Cuthbert Alan R · Dowagiac, MIN93593Jones Bruce B · Ukiah, CAN93597North Fergus Flying Club · Winifred, MTN93602Cunningham-Seltzer Sallie Lee · Burbank, CAN93624Manley Christopher · Hendersonville, TNFirst renewal noticeN93646Newsome Allard K · West Jefferson, OHN93667Spivey Harold E · Thomaston, GAN93732Wagner Mark S · Mohnton, PAN93734Rogers Samuel · Le Roy, KSN93735Suko Gary L · Rathdrum, IDN93750Charleston Flying Club LLC · Charleston, SCN93774Wakefield Matthew Q · Mountain View, ARN93789Kenkel Alan E · Cincinnati, OHN93812Ippolito Joseph W · Twin Falls, IDN93877Moore William C · Mc Lemoresville, TNN93879Gregory Vernon L · Swansea, SCN93890Hammer Thomas J · Corvallis, ORN93938Yocum Jason D · Cocoa, FLN93939Prentice Robert D · Ripon, WIN93946Voyce Terry L · East Leroy, MIN93961Gardner David A · Summerville, SCN93973Clouse William J · Strafford, MON93975Alki Investments LLC · Texarkana, TXN93992Jones Dennis P · Nacogdoches, TXN94002Yogini Modi · Homestead, FLN94027Killgore Tommie D · Ramer, TNN94028Payne Billy J · Powhatan, VAN94057International Security Network Inc · Pahrump, NVN94107Claxon David W · Gifford, ILN94125Geldermann Timothy J · Sussex, WIN94139Fix Donald J Jr · Shaker Heights, OH
Back to Engineering & Research ERCOUPE 415-C