Bush Field Aircraft Company

Earlier aircraft under this name · 16

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 = 'BUSH FIELD AIRCRAFT COMPANY' OR list_contains(d.other_registrant_names, 'BUSH FIELD AIRCRAFT COMPANY')
  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.

N600MMRockwell International 695 · S/N 95029Cancelled Jun 4, 2013 · Registration expired, pending cancellation · Augusta, GAN500XMitsubishi MU-2B-20 · S/N 114Cancelled Dec 19, 2012 · Triennial form not returned · Aiken, SCN93UMMitsubishi MU-2B-30 · S/N 537Cancelled Mar 5, 2012 · First renewal notice · Built 1971 · Aiken, SCN19GUMitsubishi MU-2B-35 · S/N 574Cancelled Aug 31, 2011 · Second renewal notice · Built 1972 · Aiken, SCN434ANLockheed 1329 · S/N 5050Cancelled Sep 18, 2008 · Triennial form not returned · Aiken, SCN119BFMitsubishi MU-2B-30 · S/N 517Cancelled Sep 7, 1995 · Augusta, GAN80398Mitsubishi MU-2B-36A · S/N 712SACancelled May 17, 1995 · Augusta, GAN271MAMitsubishi MU-2B-60 · S/N 797SACancelled Dec 1, 1994 · Triennial form not returned · Augusta, GAN4202KMitsubishi MU-2B-35 · S/N 603Cancelled Jul 25, 1994 · Augusta, GAN125ABMitsubishi MU-2B-60 · S/N 1531SACancelled Jun 14, 1994 · Triennial form not returned · Augusta, GAN5NQMitsubishi MU-2B-26A · S/N 356SACancelled Jun 14, 1994 · Augusta, GAN638MAMitsubishi MU-2B-35 · S/N 638Cancelled Jun 14, 1994 · Triennial form not returned · Augusta, GAN339MAMitsubishi MU-2B-35 · S/N 607Cancelled Mar 3, 1994 · Augusta, GAN437MAMitsubishi MU-2B-60 · S/N 1521SACancelled May 14, 1993 · Exported to Canada · Augusta, GAN273MAMitsubishi MU-2B-60 · S/N 785SACancelled Aug 6, 1991 · Exported to Canada · Augusta, GAN24MWMitsubishi MU-2B-40 · S/N 434SACancelled Dec 7, 1990 · Exported to Canada · Augusta, GA
Back to Bush Field Aircraft Company