American Eurocopter Corp
Earlier aircraft under this name · 174
Cancelled registrations that named this owner when they ended, newest first.
Query with SQL
duckdb -csv -c "SELECT d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code WHERE d.registrant_name = 'AMERICAN EUROCOPTER CORP' OR list_contains(d.other_registrant_names, 'AMERICAN EUROCOPTER CORP') ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id"
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 d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code WHERE d.registrant_name = 'AMERICAN EUROCOPTER CORP' OR list_contains(d.other_registrant_names, 'AMERICAN EUROCOPTER CORP') ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
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.
N380AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9630N384AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9634N383AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9632N510ALEurocopter EC120B · S/N 1251N340AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9624N364AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9628N548AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9536N594AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9620N596AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9622N571AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9563N511ALEurocopter EC120B · S/N 1252N591AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9615N592AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9617N546AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9611N540AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9606N535AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9602N536AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9604N232AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9598N250AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9599N203AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9591N214AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9594N222AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9596N196AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9585N198AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9589N193AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9581N194AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9583N179AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9575N189AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9577N190AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9579N109AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9566N137AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9569N143AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9571N898AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9565N793AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9555N860AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9558N866AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9561N780AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9549N786AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9551N773AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9544N775AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9546N538AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9537N765AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9539N766AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9541N545AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9528N531AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9530N532AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9532N537AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9534N530AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9527N528AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9523N865AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9358
Back to American Eurocopter Corp