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.

N7512RBell Helicopter Textron Canada 206L-4 · S/N 52337Cancelled Jan 9, 2007 · Exported to Japan · Built 2006 · Irving, TXN44454Bell 412EP · S/N 36210Cancelled Jan 7, 1999 · Exported to Japan · Irving, TXN4445VBell 412EP · S/N 36211Cancelled Jan 7, 1999 · Exported to Japan · Irving, TXN4446MBell 412EP · S/N 36214Cancelled Jan 7, 1999 · Exported to Japan · Irving, TXN44319Bell 206-L4 · S/N 52209Cancelled Nov 3, 1998 · Exported to Japan · Irving, TXN6317XBell 412EP · S/N 36175Cancelled Dec 23, 1997 · Exported to Japan · Irving, TXN1208JBell 206B · S/N 4456Cancelled Dec 16, 1997 · Exported to Japan · Irving, TXN7224QBell 412EP · S/N 36167Cancelled Nov 6, 1997 · Exported to Japan · Irving, TXN7208HBell 430 · S/N 49031Cancelled Oct 28, 1997 · Exported to Japan · Irving, TXN7251KBell 206-L4 · S/N 52197Cancelled Oct 22, 1997 · Exported to Japan · Irving, TXN62837Bell 430 · S/N 49009Cancelled May 7, 1997 · Exported to Japan · Irving, TXN1216HBell 407 · S/N 53064Cancelled Jan 29, 1997 · Exported to Japan · Irving, TXN1148QBell 206B · S/N 4437Cancelled Jan 14, 1997 · Exported to Japan · Irving, TXN86699Bell 206B · S/N 4438Cancelled Jan 14, 1997 · Exported to Japan · Irving, TXN34961Bell 412EP · S/N 36135Cancelled Dec 17, 1996 · Exported to Japan · Irving, TXN34957Bell 412EP · S/N 36134Cancelled Dec 11, 1996 · Exported to Japan · Irving, TXN1164RBell 412EP · S/N 36132Cancelled Nov 26, 1996 · Exported to Japan · Irving, TXN92115Bell 412EP · S/N 36117Cancelled May 24, 1996 · Exported to Japan · Irving, TXN92130Bell 412EP · S/N 36118Cancelled Mar 6, 1996 · Exported to Japan · Irving, TXN3293GBell 412EP · S/N 36115Cancelled Feb 16, 1996 · Exported to Japan · Irving, TXN3293ABell 412EP · S/N 36114Cancelled Jan 23, 1996 · Exported to Japan · Irving, TXN3292NBell 412EP · S/N 36109Cancelled Jan 19, 1996 · Exported to Japan · Irving, TXN32929Bell 412EP · S/N 36113Cancelled Jan 18, 1996 · Exported to Japan · Irving, TXN3292RBell 412EP · S/N 36110Cancelled Nov 17, 1995 · Exported to Japan · Irving, TXN64050Bell 206-L4 · S/N 52145Cancelled Nov 9, 1995 · Exported to Japan · Irving, TXN64049Bell 206-L4 · S/N 52147Cancelled Nov 3, 1995 · Exported to Japan · Irving, TXN64070Bell 206-L4 · S/N 52144Cancelled Nov 1, 1995 · Exported to Japan · Irving, TXN82627Bell 412EP · S/N 36107Cancelled Oct 27, 1995 · Exported to Japan · Irving, TXN2123NBell 206-L4 · S/N 52135Cancelled Sep 7, 1995 · Exported to Japan · Irving, TXN22888Bell 206-L4 · S/N 52090Cancelled Oct 6, 1994 · Exported to Japan · Irving, TX
Back to Mitsui Bussan Aerospace Corporation