# Earlier aircraft under this name: Ming-Ayer Inc

A list on [Ming-Ayer Inc](https://openairdocs.org/faa-owner/MING-AYER%20INC.md).

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

- [N4145A](https://openairdocs.org/deregistered/N4145A-1974-01-14.md): Sikorsky S-51 · S/N 5154 · Cancelled Jan 14, 1974 · Built 1956 · Linden, NJ
- [N4143A](https://openairdocs.org/deregistered/N4143A-1971-01-15.md): Sikorsky S-51 · S/N 5124 · Cancelled Jan 15, 1971 · Built 1956 · Linden, NJ
- [N7430C](https://openairdocs.org/deregistered/N7430C-1962-12-11.md): Lockheed PV-2 · S/N 151313 · Cancelled Dec 11, 1962 · Linden, NJ
- [N7433C](https://openairdocs.org/deregistered/N7433C-1962-12-11.md): Lockheed PV-2 · S/N 151411 · Cancelled Dec 11, 1962 · Linden, NJ
- [N6606D](https://openairdocs.org/deregistered/N6606D-1962-11-14.md): Lockheed PV-2 · S/N 151115 · Cancelled Nov 14, 1962 · Linden, NJ
- [N6607D](https://openairdocs.org/deregistered/N6607D-1962-11-14.md): Lockheed PV-2 · S/N 151129 · Cancelled Nov 14, 1962 · Linden, NJ
- [N6608D](https://openairdocs.org/deregistered/N6608D-1962-11-14.md): Lockheed PV-2 · S/N 151141 · Cancelled Nov 14, 1962 · Linden, NJ
- [N6609D](https://openairdocs.org/deregistered/N6609D-1962-11-14.md): Lockheed PV-2 · S/N 151173 · Cancelled Nov 14, 1962 · Linden, NJ
- [N6613D](https://openairdocs.org/deregistered/N6613D-1962-11-14.md): Lockheed PV-2 · S/N 151495 · Cancelled Nov 14, 1962 · Linden, NJ
- [N6601D](https://openairdocs.org/deregistered/N6601D-1962-11-13.md): Lockheed PV-2 · S/N 151194 · Cancelled Nov 13, 1962 · Linden, NJ
- [N6604D](https://openairdocs.org/deregistered/N6604D-1962-11-13.md): Lockheed PV-2 · S/N 151043 · Cancelled Nov 13, 1962 · Linden, NJ
- [N6605D](https://openairdocs.org/deregistered/N6605D-1962-11-13.md): Lockheed PV-2 · S/N 151047 · Cancelled Nov 13, 1962 · Linden, NJ
- [N6610D](https://openairdocs.org/deregistered/N6610D-1962-11-13.md): Lockheed PV-2 · S/N 151176 · Cancelled Nov 13, 1962 · Linden, NJ
- [N6612D](https://openairdocs.org/deregistered/N6612D-1962-11-13.md): Lockheed PV-2 · S/N 151221 · Cancelled Nov 13, 1962 · Linden, NJ
- [N6602D](https://openairdocs.org/deregistered/N6602D-1962-10-14.md): Lockheed PV-2 · S/N 151217 · Cancelled Oct 14, 1962 · Linden, NJ
- [N4141A](https://openairdocs.org/deregistered/N4141A-1957-11-18.md): Thorp T-11 · S/N BU 42-37099 · Cancelled Nov 18, 1957 · Exported to Canada · Linden, NJ
- [N4146A](https://openairdocs.org/deregistered/N4146A-1957-11-18.md): Thorp T-11 · S/N 42-37679 · Cancelled Nov 18, 1957 · Exported to Canada · Linden, NJ

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

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