# Earlier aircraft under this name: Miami Aviation Corp

A list on [Miami Aviation Corp](https://openairdocs.org/faa-owner/MIAMI%20AVIATION%20CORP.md).

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

- [N852KB](https://openairdocs.org/deregistered/N852KB-1979-12-19.md): Dehavilland DHC-6 TWIN OTTER · S/N 145 · Cancelled Dec 19, 1979 · Exported to Fiji · Opa-Locka, FL
- [N123SC](https://openairdocs.org/deregistered/N123SC-1976-04-19.md): Convair 600-240D · S/N 92 · Cancelled Apr 19, 1976 · Exported to Uruguay · Opa Locka, FL
- [N8703A](https://openairdocs.org/deregistered/N8703A-1974-09-10.md): Douglas DC-6 · S/N 42900 · Cancelled Sep 10, 1974
- [N850D](https://openairdocs.org/deregistered/N850D-1972-05-11.md): Douglas DC-7B · S/N 45456 · Cancelled May 11, 1972 · Opa Locka, FL
- [N303MA](https://openairdocs.org/deregistered/N303MA-1971-04-20.md): Dehavilland DHC-6 · S/N 258 · Cancelled Apr 20, 1971 · Exported to French Polynesia · Opa-Locka, FL
- [N654MA](https://openairdocs.org/deregistered/N654MA-1970-07-13.md): Dehavilland DHC-6 TWIN OTTER · S/N 220 · Cancelled Jul 13, 1970 · Exported to Canada · Opa-Locka, FL
- [N7148Z](https://openairdocs.org/deregistered/N7148Z-1970-07-13.md): Piper PA-25-235 · S/N 25-2982 · Cancelled Jul 13, 1970 · Exported to Ecuador · Opa Locka, FL
- [N7151Z](https://openairdocs.org/deregistered/N7151Z-1970-07-13.md): Piper PA-25-235 · S/N 25-2990 · Cancelled Jul 13, 1970 · Exported to Ecuador · Opa Locka, FL
- [N7168Z](https://openairdocs.org/deregistered/N7168Z-1970-07-13.md): Piper PA-25-235 · S/N 25-3029 · Cancelled Jul 13, 1970 · Exported to Ecuador · Opa Locka, FL
- [N7169Z](https://openairdocs.org/deregistered/N7169Z-1970-07-13.md): Piper PA-25-235 · S/N 25-3033 · Cancelled Jul 13, 1970 · Exported to Ecuador · Opa Locka, FL
- [N4798F](https://openairdocs.org/deregistered/N4798F-1970-02-24.md): Cessna TP206B · S/N P206-0398 · Cancelled Feb 24, 1970 · Exported to Colombia · Opa Locka, FL
- [N75885](https://openairdocs.org/deregistered/N75885-1969-01-10.md): Douglas DC3C · S/N 19242 · Cancelled Jan 10, 1969 · Exported to Panama · Opa Locka, FL
- [N2420](https://openairdocs.org/deregistered/N2420-1968-08-15.md): Aero Commander 500-B · S/N 500B-982-23 · Cancelled Aug 15, 1968 · Exported to Colombia · Opalaca, FL
- [N615PR](https://openairdocs.org/deregistered/N615PR-1968-02-23.md): Aero Commander 500-B · S/N 1504-179 · Cancelled Feb 23, 1968 · Exported to Colombia · Opa Locka, FL
- [N90717](https://openairdocs.org/deregistered/N90717-1967-12-19.md): Douglas DC-6 · S/N 42884 · Cancelled Dec 19, 1967 · Exported to Panama · Opa Locka, FL
- [N4720Y](https://openairdocs.org/deregistered/N4720Y-1967-12-07.md): Piper PA-25-235 · S/N 25-4462 · Cancelled Dec 7, 1967 · Exported to Venezuela · Opa Locka, FL
- [N4723Y](https://openairdocs.org/deregistered/N4723Y-1967-12-05.md): Piper PA-25-235 · S/N 25-4466 · Cancelled Dec 5, 1967 · Exported to Venezuela · Opa Locka, FL
- [N4675Y](https://openairdocs.org/deregistered/N4675Y-1967-08-30.md): Piper PA-25-235 · S/N 25-4397 · Cancelled Aug 30, 1967 · Exported to Colombia · Opa Locka, FL
- [N7551Z](https://openairdocs.org/deregistered/N7551Z-1967-05-16.md): Piper PA-25 · S/N 25-3599 · Cancelled May 16, 1967 · Exported to Venezuela · Opa Locka, FL
- [N90727](https://openairdocs.org/deregistered/N90727-1967-02-20.md): Douglas DC-6 · S/N 42894 · Cancelled Feb 20, 1967 · Exported to Honduras · Opa Locka, FL
- [N2770B](https://openairdocs.org/deregistered/N2770B-1967-01-31.md): Aero Commander 500-B · S/N 1095-08 · Cancelled Jan 31, 1967 · Exported to Colombia · Opa Locka, FL
- [N7527Z](https://openairdocs.org/deregistered/N7527Z-1965-12-09.md): Piper PA-25-235 · S/N 25-3569 · Cancelled Dec 9, 1965 · Exported to Venezuela · Opa Locka, FL
- [N4997E](https://openairdocs.org/deregistered/N4997E-1965-07-26.md): Douglas DC3C · S/N 12191 · Cancelled Jul 26, 1965 · Opa-Locka, FL
- [N57985](https://openairdocs.org/deregistered/N57985-1965-05-25.md): Douglas DC-3A-S1C3G · S/N 19996 · Cancelled May 25, 1965 · Exported to Philippines · Opa Locka, FL
- [N4993E](https://openairdocs.org/deregistered/N4993E-1965-05-18.md): Douglas DC-3A-S1C3G · S/N 12440 · Cancelled May 18, 1965 · Exported to Philippines · Opa Locka, FL
- [N7816H](https://openairdocs.org/deregistered/N7816H-1965-01-25.md): Piper PA-12 · S/N 12719 · Cancelled Jan 25, 1965 · Exported to French Polynesia · Opa Locka, FL
- [N7180Z](https://openairdocs.org/deregistered/N7180Z-1964-12-10.md): Piper PA-25-235 · S/N 253052 · Cancelled Dec 10, 1964 · Exported to Venezuela
- [N4992E](https://openairdocs.org/deregistered/N4992E-1964-12-09.md): Douglas DC3C · S/N 12139 · Cancelled Dec 9, 1964 · Exported to Philippines · Opa Locka, FL
- [N4998E](https://openairdocs.org/deregistered/N4998E-1964-12-09.md): Douglas DC3C · S/N 13559 · Cancelled Dec 9, 1964 · Exported to Philippines · Opa-Locka, FL
- [N7137Z](https://openairdocs.org/deregistered/N7137Z-1964-09-11.md): Piper PA-25-235 · S/N 252955 · Cancelled Sep 11, 1964 · Exported to Venezuela
- [N6888Z](https://openairdocs.org/deregistered/N6888Z-1964-06-16.md): Piper PA-25-235 · S/N 25-2613 · Cancelled Jun 16, 1964 · Exported to Venezuela · Built 1964 · Opa Locka, FL
- [N2270D](https://openairdocs.org/deregistered/N2270D-undated.md): Dehavilland DHC-6 TWIN OTTER · S/N 98 · Cancellation date not recorded · Exported to Iceland · Opa Locka, FL

## 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 = 'MIAMI AVIATION CORP' OR list_contains(d.other_registrant_names, 'MIAMI AVIATION CORP')
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

This list as a web page: https://openairdocs.org/faa-owner/MIAMI%20AVIATION%20CORP/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.