Mitsui Bussan Aerospace Corporation
Earlier aircraft under this name · 30
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 = 'MITSUI BUSSAN AEROSPACE CORPORATION' OR list_contains(d.other_registrant_names, 'MITSUI BUSSAN AEROSPACE CORPORATION') 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 = 'MITSUI BUSSAN AEROSPACE CORPORATION' OR list_contains(d.other_registrant_names, 'MITSUI BUSSAN AEROSPACE CORPORATION') 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.
N7512RBell Helicopter Textron Canada 206L-4 · S/N 52337N44454Bell 412EP · S/N 36210N4445VBell 412EP · S/N 36211N4446MBell 412EP · S/N 36214N44319Bell 206-L4 · S/N 52209N6317XBell 412EP · S/N 36175N1208JBell 206B · S/N 4456N7224QBell 412EP · S/N 36167N7208HBell 430 · S/N 49031N7251KBell 206-L4 · S/N 52197N62837Bell 430 · S/N 49009N1216HBell 407 · S/N 53064N1148QBell 206B · S/N 4437N86699Bell 206B · S/N 4438N34961Bell 412EP · S/N 36135N34957Bell 412EP · S/N 36134N1164RBell 412EP · S/N 36132N92115Bell 412EP · S/N 36117N92130Bell 412EP · S/N 36118N3293GBell 412EP · S/N 36115N3293ABell 412EP · S/N 36114N3292NBell 412EP · S/N 36109N32929Bell 412EP · S/N 36113N3292RBell 412EP · S/N 36110N64050Bell 206-L4 · S/N 52145N64049Bell 206-L4 · S/N 52147N64070Bell 206-L4 · S/N 52144N82627Bell 412EP · S/N 36107N2123NBell 206-L4 · S/N 52135N22888Bell 206-L4 · S/N 52090
Back to Mitsui Bussan Aerospace Corporation