# Earlier aircraft under this name: Bush Field Aircraft Company

A list on [Bush Field Aircraft Company](https://openairdocs.org/faa-owner/BUSH%20FIELD%20AIRCRAFT%20COMPANY.md).

Cancelled registrations that named this owner when they ended, newest first.

- [N600MM](https://openairdocs.org/deregistered/N600MM-2013-06-04.md): Rockwell International 695 · S/N 95029 · Cancelled Jun 4, 2013 · Registration expired, pending cancellation · Augusta, GA
- [N500X](https://openairdocs.org/deregistered/N500X-2012-12-19.md): Mitsubishi MU-2B-20 · S/N 114 · Cancelled Dec 19, 2012 · Triennial form not returned · Aiken, SC
- [N93UM](https://openairdocs.org/deregistered/N93UM-2012-03-05.md): Mitsubishi MU-2B-30 · S/N 537 · Cancelled Mar 5, 2012 · First renewal notice · Built 1971 · Aiken, SC
- [N19GU](https://openairdocs.org/deregistered/N19GU-2011-08-31.md): Mitsubishi MU-2B-35 · S/N 574 · Cancelled Aug 31, 2011 · Second renewal notice · Built 1972 · Aiken, SC
- [N434AN](https://openairdocs.org/deregistered/N434AN-2008-09-18.md): Lockheed 1329 · S/N 5050 · Cancelled Sep 18, 2008 · Triennial form not returned · Aiken, SC
- [N119BF](https://openairdocs.org/deregistered/N119BF-1995-09-07.md): Mitsubishi MU-2B-30 · S/N 517 · Cancelled Sep 7, 1995 · Augusta, GA
- [N80398](https://openairdocs.org/deregistered/N80398-1995-05-17.md): Mitsubishi MU-2B-36A · S/N 712SA · Cancelled May 17, 1995 · Augusta, GA
- [N271MA](https://openairdocs.org/deregistered/N271MA-1994-12-01.md): Mitsubishi MU-2B-60 · S/N 797SA · Cancelled Dec 1, 1994 · Triennial form not returned · Augusta, GA
- [N4202K](https://openairdocs.org/deregistered/N4202K-1994-07-25.md): Mitsubishi MU-2B-35 · S/N 603 · Cancelled Jul 25, 1994 · Augusta, GA
- [N125AB](https://openairdocs.org/deregistered/N125AB-1994-06-14.md): Mitsubishi MU-2B-60 · S/N 1531SA · Cancelled Jun 14, 1994 · Triennial form not returned · Augusta, GA
- [N5NQ](https://openairdocs.org/deregistered/N5NQ-1994-06-14.md): Mitsubishi MU-2B-26A · S/N 356SA · Cancelled Jun 14, 1994 · Augusta, GA
- [N638MA](https://openairdocs.org/deregistered/N638MA-1994-06-14.md): Mitsubishi MU-2B-35 · S/N 638 · Cancelled Jun 14, 1994 · Triennial form not returned · Augusta, GA
- [N339MA](https://openairdocs.org/deregistered/N339MA-1994-03-03.md): Mitsubishi MU-2B-35 · S/N 607 · Cancelled Mar 3, 1994 · Augusta, GA
- [N437MA](https://openairdocs.org/deregistered/N437MA-1993-05-14.md): Mitsubishi MU-2B-60 · S/N 1521SA · Cancelled May 14, 1993 · Exported to Canada · Augusta, GA
- [N273MA](https://openairdocs.org/deregistered/N273MA-1991-08-06.md): Mitsubishi MU-2B-60 · S/N 785SA · Cancelled Aug 6, 1991 · Exported to Canada · Augusta, GA
- [N24MW](https://openairdocs.org/deregistered/N24MW-1990-12-07.md): Mitsubishi MU-2B-40 · S/N 434SA · Cancelled Dec 7, 1990 · Exported to Canada · Augusta, GA

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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
```

This list as a web page: https://openairdocs.org/faa-owner/BUSH%20FIELD%20AIRCRAFT%20COMPANY/earlier

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain, except the copies of manufacturers’ service documents, which belong to their rights holders.
