# Earlier aircraft under this name: Memphis Aero Corp

A list on [Memphis Aero Corp](https://openairdocs.org/faa-owner/MEMPHIS%20AERO%20CORP.md).

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

- [N2850D](https://openairdocs.org/deregistered/N2850D-1979-08-06.md): Piper PA-34-200T · S/N 34-7970285 · Cancelled Aug 6, 1979 · Exported to Mexico · Built 1979 · Memphis, TN
- [N1478H](https://openairdocs.org/deregistered/N1478H-1977-02-10.md): Piper PA-28-181 · S/N 28-7790305 · Cancelled Feb 10, 1977 · Exported to Costa Rica · Memphis, TN
- [N4482X](https://openairdocs.org/deregistered/N4482X-1975-12-18.md): Piper PA-28-151 · S/N 287615018 · Cancelled Dec 18, 1975 · Exported to Canada · Memphis, TN
- [N54842](https://openairdocs.org/deregistered/N54842-1975-12-05.md): Piper PA-23-250 (6PCLM) · S/N 277554142 · Cancelled Dec 5, 1975 · Exported to Canada · Memphis, TN
- [N44598](https://openairdocs.org/deregistered/N44598-1975-06-18.md): Piper PA-28-151 · S/N 28-7415680 · Cancelled Jun 18, 1975 · Exported to Canada · Built 1974 · Memphis, TN
- [N54306](https://openairdocs.org/deregistered/N54306-1975-01-14.md): Piper PA-31-350 · S/N 317405434 · Cancelled Jan 14, 1975 · Exported to Sweden · Memphis, TN
- [N666BW](https://openairdocs.org/deregistered/N666BW-1974-12-16.md): Piper PA-23-250 (6PCLM) · S/N 27-3140 · Cancelled Dec 16, 1974 · Exported to Canada · Memphis, TN
- [N4359T](https://openairdocs.org/deregistered/N4359T-1974-09-11.md): Piper PA-28-140 · S/N 28-7225143 · Cancelled Sep 11, 1974 · Exported to Canada · Built 1971 · Memphis, TN
- [N4585T](https://openairdocs.org/deregistered/N4585T-1973-11-23.md): Piper PA-34-200 · S/N 34-7250140 · Cancelled Nov 23, 1973 · Exported to Canada · Built 1972 · Memphis, TN
- [N5980S](https://openairdocs.org/deregistered/N5980S-1973-09-10.md): Beech A23-19 · S/N MB-71 · Cancelled Sep 10, 1973 · Exported to Canada · Memphis, TN
- [N7564Z](https://openairdocs.org/deregistered/N7564Z-1973-07-20.md): Piper PA-25-235 · S/N 25-3621 · Cancelled Jul 20, 1973 · Memphis, TN
- [N6683P](https://openairdocs.org/deregistered/N6683P-1971-07-27.md): Piper PA-24-250 · S/N 24-1807 · Cancelled Jul 27, 1971 · Memphis, TN
- [N7455Z](https://openairdocs.org/deregistered/N7455Z-1971-04-05.md): Piper PA-25-235 · S/N 25-3449 · Cancelled Apr 5, 1971 · Memphis, TN
- [N4539D](https://openairdocs.org/deregistered/N4539D-1970-06-30.md): Beech G35 · S/N D-4689 · Cancelled Jun 30, 1970 · Memphis, TN
- [N7524P](https://openairdocs.org/deregistered/N7524P-1969-04-04.md): Piper PA-24-250 · S/N 24-2726 · Cancelled Apr 4, 1969 · Exported to Canada · Memphis, TN
- [N7309Z](https://openairdocs.org/deregistered/N7309Z-1967-11-14.md): Piper PA-25-235 · S/N 25-3256 · Cancelled Nov 14, 1967 · Exported to Nicaragua · Memphis, TN
- [N4347J](https://openairdocs.org/deregistered/N4347J-1967-07-25.md): Piper PA-28-140 · S/N 28-22724 · Cancelled Jul 25, 1967 · Memphis, TN
- [N4985Z](https://openairdocs.org/deregistered/N4985Z-1962-09-14.md): Piper PA-18-150 · S/N 18-7764 · Cancelled Sep 14, 1962 · Exported to Cyprus · Memphis, TN
- [N8874C](https://openairdocs.org/deregistered/N8874C-1960-09-21.md): Piper PA-22 · S/N 22-1485 · Cancelled Sep 21, 1960 · Memphis, TN
- [N3371Z](https://openairdocs.org/deregistered/N3371Z-1960-07-07.md): Piper PA-18A 150 · S/N 18-7243 · Cancelled Jul 7, 1960 · Exported to Canada · Memphis, TN
- [N3291Z](https://openairdocs.org/deregistered/N3291Z-1960-06-29.md): Piper PA-18A · S/N 18-7228 · Cancelled Jun 29, 1960 · Exported to Canada · Memphis, TN
- [N6373A](https://openairdocs.org/deregistered/N6373A-1960-05-05.md): Cessna 182 · S/N 33173 · Cancelled May 5, 1960 · Exported to Australia · Memphis, TN
- [N492B](https://openairdocs.org/deregistered/N492B-1950-03-07.md): Beech A35 · S/N D-1512 · Cancelled Mar 7, 1950 · Memphis, TN

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

This list as a web page: https://openairdocs.org/faa-owner/MEMPHIS%20AERO%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, except the copies of manufacturers’ service documents, which belong to their rights holders.
