# Earlier aircraft under this name: Allegheny Airlines Inc

A list on [Allegheny Airlines Inc](https://openairdocs.org/faa-owner/ALLEGHENY%20AIRLINES%20INC.md).

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

- [N1550](https://openairdocs.org/deregistered/N1550-1981-06-19.md): British BAC 1-11 203/AE · S/N 044 · Cancelled Jun 19, 1981 · Administratively canceled · Washington, DC
- [N5817](https://openairdocs.org/deregistered/N5817-1981-05-28.md): Convair 340 · S/N 81 · Cancelled May 28, 1981 · Washington, DC
- [N5826](https://openairdocs.org/deregistered/N5826-1978-10-23.md): Convair 440 · S/N 385 · Cancelled Oct 23, 1978 · Exported to South Africa · Washington, DC
- [N994VJ](https://openairdocs.org/deregistered/N994VJ-1977-07-25.md): Douglas DC-9-31 · S/N 47333 · Cancelled Jul 25, 1977 · Washington, DC
- [N5838](https://openairdocs.org/deregistered/N5838-1977-01-20.md): Convair 340 · S/N 147 · Cancelled Jan 20, 1977 · Exported to Canada · Washington, DC
- [N5840](https://openairdocs.org/deregistered/N5840-1976-04-21.md): Convair 340 · S/N 28 · Cancelled Apr 21, 1976 · Exported to Canada · Washington, DC
- [N2710J](https://openairdocs.org/deregistered/N2710J-1974-12-16.md): Fairchild F-27J · S/N 121 · Cancelled Dec 16, 1974 · Exported to Bolivia · Washington, DC
- [N7821M](https://openairdocs.org/deregistered/N7821M-1974-12-12.md): Fairchild FH-227B · S/N 560 · Cancelled Dec 12, 1974 · Exported to Canada · Washington, DC
- [N2701J](https://openairdocs.org/deregistered/N2701J-1974-11-27.md): Fairchild F-27J · S/N 111 · Cancelled Nov 27, 1974 · Exported to Bolivia · Washington, DC
- [N2707J](https://openairdocs.org/deregistered/N2707J-1974-10-04.md): Fairchild F-27J · S/N 118 · Cancelled Oct 4, 1974 · Exported to Bolivia · Washington, DC
- [N7816M](https://openairdocs.org/deregistered/N7816M-1974-05-03.md): Fairchild FH-227B · S/N 537 · Cancelled May 3, 1974 · Exported to Norway · Washington, DC
- [N5844](https://openairdocs.org/deregistered/N5844-1973-06-26.md): Convair 340/440 · S/N 43 · Cancelled Jun 26, 1973 · Washington, DC
- [N5832](https://openairdocs.org/deregistered/N5832-1972-02-01.md): Convair 440 · S/N 384 · Cancelled Feb 1, 1972 · Washington, DC
- [N26209](https://openairdocs.org/deregistered/N26209-1971-03-25.md): Nord 262 A-12 · S/N 14 · Cancelled Mar 25, 1971 · Exported to Algeria · Washington, DC
- [N26213](https://openairdocs.org/deregistered/N26213-1971-01-20.md): Nord 262 A-12 · S/N 19 · Cancelled Jan 20, 1971 · Exported to Algeria · Washington, DC
- [N26212](https://openairdocs.org/deregistered/N26212-1970-12-29.md): Nord 262 A-12 · S/N 18 · Cancelled Dec 29, 1970 · Exported to Algeria · Washington, DC
- [N26207](https://openairdocs.org/deregistered/N26207-1970-12-11.md): Nord 262 A-12 · S/N 12 · Cancelled Dec 11, 1970 · Exported to Algeria · Washington, DC
- [N5802](https://openairdocs.org/deregistered/N5802-1970-06-25.md): Convair CV-440-79 · S/N 410 · Cancelled Jun 25, 1970 · Washington, DC
- [N5825](https://openairdocs.org/deregistered/N5825-1970-06-25.md): Convair 440 · S/N 386 · Cancelled Jun 25, 1970 · Washington, DC
- [N988VJ](https://openairdocs.org/deregistered/N988VJ-1970-06-25.md): Douglas DC-9-31 · S/N 47211 · Cancelled Jun 25, 1970 · Washington, DC
- [N8415H](https://openairdocs.org/deregistered/N8415H-1968-07-22.md): Convair 340 · S/N 125 · Cancelled Jul 22, 1968 · Washington, DC
- [N2702J](https://openairdocs.org/deregistered/N2702J-1968-05-21.md): Fairchild F-27J · S/N 113 · Cancelled May 21, 1968 · Exported to Canada · Washington, DC
- [N172A](https://openairdocs.org/deregistered/N172A-1964-10-19.md): Martin 202 · S/N 9142 · Cancelled Oct 19, 1964
- [N174A](https://openairdocs.org/deregistered/N174A-1964-10-19.md): Martin 202 · S/N 9159 · Cancelled Oct 19, 1964 · Washington, DC
- [N177A](https://openairdocs.org/deregistered/N177A-1964-04-14.md): Martin 202 · S/N 9147 · Cancelled Apr 14, 1964 · Washington, DC
- [N440E](https://openairdocs.org/deregistered/N440E-1963-06-14.md): Convair 440 · S/N 445 · Cancelled Jun 14, 1963 · Exported to Venezuela · Washington, DC
- [N11136](https://openairdocs.org/deregistered/N11136-1960-10-27.md): Convair 340 · S/N 136 · Cancelled Oct 27, 1960 · Exported to Chile · Washington, DC
- [N147A](https://openairdocs.org/deregistered/N147A-1960-09-29.md): Douglas DC3C-S1C3G · S/N 9175 · Cancelled Sep 29, 1960 · Exported to Haiti · Washington, DC

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

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