# Earlier aircraft under this name: Piedmont Aviation Inc

A list on [Piedmont Aviation Inc](https://openairdocs.org/faa-owner/PIEDMONT%20AVIATION%20INC.md).

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

- [N6721F](https://openairdocs.org/deregistered/N6721F-1995-10-02.md): Beech 77 · S/N WA97 · Cancelled Oct 2, 1995 · Triennial form not returned · Winston Salem, NC
- [N18969](https://openairdocs.org/deregistered/N18969-1982-11-04.md): Beech C24R · S/N MC-541 · Cancelled Nov 4, 1982 · Administratively canceled · Winston Salem, NC
- [N9339S](https://openairdocs.org/deregistered/N9339S-1982-05-19.md): Beech B19 · S/N MB-775 · Cancelled May 19, 1982 · Revoked, pending cancellation · Built 1975 · Winston Salem, NC
- [N4086R](https://openairdocs.org/deregistered/N4086R-1981-11-16.md): Piper PA-42 · S/N 42-8001019 · Cancelled Nov 16, 1981 · Exported to Peru · Built 1980 · Winston Salem, NC
- [N264P](https://openairdocs.org/deregistered/N264P-1977-07-12.md): Nihon YS-11 · S/N 2040 · Cancelled Jul 12, 1977 · Winston-Salem, NC
- [N265P](https://openairdocs.org/deregistered/N265P-1977-07-12.md): Nihon YS-11 · S/N 2046 · Cancelled Jul 12, 1977 · Winston-Salem, NC
- [N15880](https://openairdocs.org/deregistered/N15880-1974-09-19.md): Piper PA-28-140 · S/N 28-7325187 · Cancelled Sep 19, 1974 · Built 1972 · Winston-Salem, NC
- [N6115N](https://openairdocs.org/deregistered/N6115N-1972-04-25.md): Beech B23 · S/N M-1201 · Cancelled Apr 25, 1972 · Winston Salem, NC
- [N2382W](https://openairdocs.org/deregistered/N2382W-1971-12-14.md): Beech A23-19 · S/N MB-16 · Cancelled Dec 14, 1971 · Winston Salem, NC
- [N7532R](https://openairdocs.org/deregistered/N7532R-1971-07-15.md): Piper PA-28-140 · S/N 28-22093 · Cancelled Jul 15, 1971 · Winston-Salem, NC
- [N5244Z](https://openairdocs.org/deregistered/N5244Z-1971-01-22.md): Piper PA-22-108 · S/N 22-8926 · Cancelled Jan 22, 1971 · Winston Salem, NC
- [N4748J](https://openairdocs.org/deregistered/N4748J-1970-06-30.md): Beech A23-24 · S/N MA-171 · Cancelled Jun 30, 1970 · Winston-Salem, NC
- [N7947L](https://openairdocs.org/deregistered/N7947L-1970-06-30.md): Beech A23-19 · S/N MB-147 · Cancelled Jun 30, 1970 · Winston-Salem, NC
- [N48V](https://openairdocs.org/deregistered/N48V-1967-03-01.md): Douglas DC3 · S/N 13835 · Cancelled Mar 1, 1967 · Built 1943 · Winston-Salem 1, NC
- [N40406](https://openairdocs.org/deregistered/N40406-1966-12-16.md): Martin 404 · S/N 14170 · Cancelled Dec 16, 1966 · Winston Salem, NC
- [N40446](https://openairdocs.org/deregistered/N40446-1966-09-22.md): Martin 404 · S/N 14238 · Cancelled Sep 22, 1966 · Winston-Salem, NC
- [N9106D](https://openairdocs.org/deregistered/N9106D-1964-10-01.md): Piper PA-18 · S/N 18-6485 · Cancelled Oct 1, 1964 · Winston-Salem, NC
- [N5124D](https://openairdocs.org/deregistered/N5124D-1963-08-26.md): Cessna 182A · S/N 51224 · Cancelled Aug 26, 1963 · Exported to Sweden · Winston=Salem, NC
- [N3379Z](https://openairdocs.org/deregistered/N3379Z-1961-04-18.md): Piper PA-18 · S/N 18-7260 · Cancelled Apr 18, 1961 · Exported to Germany · Winston-Salem, NC
- [N3384B](https://openairdocs.org/deregistered/N3384B-1956-12-14.md): Piper PA-22 · S/N 22-2183 · Cancelled Dec 14, 1956 · Winston-Salem, NC
- [N7176B](https://openairdocs.org/deregistered/N7176B-1956-10-10.md): Piper PA-18A 150 · S/N 185213 · Cancelled Oct 10, 1956 · Exported to Mexico
- [N52889](https://openairdocs.org/deregistered/N52889-1955-01-14.md): Cessna T-50 · S/N 3693 · Cancelled Jan 14, 1955 · Winston Salem, NC
- [N54121](https://openairdocs.org/deregistered/N54121-1955-01-14.md): Fairchild M-62A · S/N T43-7027 · Cancelled Jan 14, 1955 · Winston Salem, NC
- [N8065C](https://openairdocs.org/deregistered/N8065C-1954-10-13.md): Piper PA-18A · S/N 18-3416 · Cancelled Oct 13, 1954 · Exported to Colombia · Winston, NC
- [N52905](https://openairdocs.org/deregistered/N52905-1950-09-22.md): Cessna T-50 · S/N 4274 · Cancelled Sep 22, 1950 · Winston-Salem, NC
- [N52908](https://openairdocs.org/deregistered/N52908-1950-09-22.md): Cessna T-50 · S/N 3454 · Cancelled Sep 22, 1950 · Winston Salem, NC
- [N52888](https://openairdocs.org/deregistered/N52888-1948-11-30.md): Cessna T-50 · S/N 2715 · Cancelled Nov 30, 1948 · Winston Salem, NC
- [N36716](https://openairdocs.org/deregistered/N36716-1948-08-30.md): Stinson 10A · S/N 8116 · Cancelled Aug 30, 1948 · Built 1941 · Winston Salem, NC
- [N91980](https://openairdocs.org/deregistered/N91980-1947-08-20.md): Piper J3C-65 · S/N 16413 · Cancelled Aug 20, 1947 · Winston-Salem, NC
- [N88288](https://openairdocs.org/deregistered/N88288-1946-07-29.md): Piper J3C-65 · S/N 15906 · Cancelled Jul 29, 1946 · Winston-Salem, NC
- [N38832](https://openairdocs.org/deregistered/N38832-1943-08-28.md): Piper J3L-65 · S/N 7318 · Cancelled Aug 28, 1943 · Winston Salem, NC
- [N32541](https://openairdocs.org/deregistered/N32541-1941-08-13.md): Piper J-3 · S/N 5439 · Cancelled Aug 13, 1941 · Winston-Salem, NC
- [N37011](https://openairdocs.org/deregistered/N37011-1941-08-13.md): Luscombe 8B · S/N 1672 · Cancelled Aug 13, 1941 · Built 1941 · Winston Salem, NC
- [N213W](https://openairdocs.org/deregistered/N213W-1940-10-04.md): Stinson SM-8A · S/N 4008 · Cancelled Oct 4, 1940 · Built 1930 · Winston Salem, NC

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

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