# Earlier aircraft under this name: Mid State Aviation Inc

A list on [Mid State Aviation Inc](https://openairdocs.org/faa-owner/MID%20STATE%20AVIATION%20INC.md).

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

- [N8030D](https://openairdocs.org/deregistered/N8030D-1982-01-19.md): Piper PA-22-150 · S/N 22-5555 · Cancelled Jan 19, 1982 · Bismarck, ND
- [N48432](https://openairdocs.org/deregistered/N48432-1980-11-12.md): Grumman G-164B · S/N 20B · Cancelled Nov 12, 1980 · Ellensburg, WA
- [N8269S](https://openairdocs.org/deregistered/N8269S-1973-11-14.md): Cessna 150F · S/N 15061869 · Cancelled Nov 14, 1973
- [N9992Y](https://openairdocs.org/deregistered/N9992Y-1973-04-16.md): Champion 7GCB · S/N 7GCB-192 · Cancelled Apr 16, 1973 · Exported to Canada · Bismarck, ND
- [N4059X](https://openairdocs.org/deregistered/N4059X-1972-06-01.md): Aero Commander 100-180 · S/N 5159 · Cancelled Jun 1, 1972 · Exported to Canada · Bismarck, ND
- [N5644W](https://openairdocs.org/deregistered/N5644W-1972-04-27.md): Piper PA-28-180 · S/N 28-799 · Cancelled Apr 27, 1972 · Exported to Canada · Built 1966 · Bismark, ND
- [N5673T](https://openairdocs.org/deregistered/N5673T-1972-01-14.md): Cessna 172E · S/N 17251573 · Cancelled Jan 14, 1972 · Exported to Canada · Bismark, ND
- [N2357E](https://openairdocs.org/deregistered/N2357E-1971-12-27.md): Aeronca 7CCM · S/N 7AC-5934 · Cancelled Dec 27, 1971 · Exported to Canada · Built 1946 · Bismarck, ND
- [N8756T](https://openairdocs.org/deregistered/N8756T-1971-05-27.md): Cessna 182C · S/N 52656 · Cancelled May 27, 1971 · Exported to Canada · Bismarck, ND
- [N1335A](https://openairdocs.org/deregistered/N1335A-1971-04-26.md): Piper PA-18 · S/N 18-1148 · Cancelled Apr 26, 1971 · Exported to Canada · Bismarck, ND
- [N40167](https://openairdocs.org/deregistered/N40167-1971-03-22.md): Stinson 108 · S/N 108-97 · Cancelled Mar 22, 1971 · Exported to Canada · Built 1946 · Bismarck, ND
- [N8609S](https://openairdocs.org/deregistered/N8609S-1971-03-02.md): Cessna 150F · S/N 15061909 · Cancelled Mar 2, 1971 · Exported to Canada · Bismarck, ND
- [N2495V](https://openairdocs.org/deregistered/N2495V-1971-02-11.md): Cessna 140 · S/N 14764 · Cancelled Feb 11, 1971 · Exported to Canada · Built 1948 · Bismarck, ND
- [N78009](https://openairdocs.org/deregistered/N78009-1971-02-11.md): Globe GC-1B · S/N 2009 · Cancelled Feb 11, 1971 · Exported to Canada · Bismarck, ND
- [N41185](https://openairdocs.org/deregistered/N41185-1970-08-26.md): Piper J5A · S/N 5-1283 · Cancelled Aug 26, 1970 · Exported to Canada · Bismarck, ND
- [N9773D](https://openairdocs.org/deregistered/N9773D-1970-07-20.md): Piper PA-18 · S/N 18-6833 · Cancelled Jul 20, 1970 · Exported to Canada · Bismarck, ND
- [N8714B](https://openairdocs.org/deregistered/N8714B-1970-06-26.md): Cessna 172 · S/N 36414 · Cancelled Jun 26, 1970 · Exported to Canada · Mandan, ND
- [N8910K](https://openairdocs.org/deregistered/N8910K-1970-06-02.md): Stinson 108-1 · S/N 1081910 · Cancelled Jun 2, 1970 · Exported to Canada
- [N4160N](https://openairdocs.org/deregistered/N4160N-1969-07-09.md): Cessna 140 · S/N 13631 · Cancelled Jul 9, 1969 · Exported to Canada · Bismarck, ND
- [N2063V](https://openairdocs.org/deregistered/N2063V-1969-06-25.md): Cessna 140 · S/N 14276 · Cancelled Jun 25, 1969 · Exported to Canada · Bismarck, ND
- [N5761Z](https://openairdocs.org/deregistered/N5761Z-1969-05-20.md): Piper PA-22-108 · S/N 22-9603 · Cancelled May 20, 1969 · Exported to Canada · Bismark, ND
- [N4845M](https://openairdocs.org/deregistered/N4845M-1969-04-22.md): Piper PA-11 · S/N 11-362 · Cancelled Apr 22, 1969 · Exported to Canada · Bismarck, ND
- [N7116W](https://openairdocs.org/deregistered/N7116W-1968-12-09.md): Piper PA-28-180 · S/N 28-907 · Cancelled Dec 9, 1968 · Exported to Canada · Built 1963 · Bismarck, ND
- [N3574C](https://openairdocs.org/deregistered/N3574C-1968-10-30.md): Cessna 170B · S/N 26618 · Cancelled Oct 30, 1968 · Exported to Canada · Built 1954 · Bismarck, ND
- [N2987Z](https://openairdocs.org/deregistered/N2987Z-1968-10-10.md): Piper PA-18A · S/N 18-7101 · Cancelled Oct 10, 1968 · Exported to Canada · Bismarck, ND
- [N4618R](https://openairdocs.org/deregistered/N4618R-1968-10-10.md): Piper PA-28-140 · S/N 28-21307 · Cancelled Oct 10, 1968 · Built 1966 · Bismarck, ND
- [N9403J](https://openairdocs.org/deregistered/N9403J-1968-10-10.md): Piper PA-28-180 · S/N 28-3509 · Cancelled Oct 10, 1968 · Exported to Canada · Built 1966 · Bismarck, ND
- [N3070Z](https://openairdocs.org/deregistered/N3070Z-1968-09-24.md): Piper PA-22-160 · S/N 22-7027 · Cancelled Sep 24, 1968 · Exported to Canada · Bismarck, ND
- [N4789D](https://openairdocs.org/deregistered/N4789D-1968-09-24.md): Cessna 182A · S/N 34889 · Cancelled Sep 24, 1968 · Exported to Canada · Bismark, ND
- [N7739H](https://openairdocs.org/deregistered/N7739H-1968-06-10.md): Piper PA-12 · S/N 12-635 · Cancelled Jun 10, 1968 · Exported to Canada · Built 1946 · Bismarck, ND
- [N8334W](https://openairdocs.org/deregistered/N8334W-1968-05-15.md): Piper PA-28-180 · S/N 28-2515 · Cancelled May 15, 1968 · Exported to Canada · Bismanck, ND
- [N6313R](https://openairdocs.org/deregistered/N6313R-1968-04-03.md): Piper PA-28-140 · S/N 28-21479 · Cancelled Apr 3, 1968 · Exported to Canada · Built 1966 · Bismark, ND
- [N9795J](https://openairdocs.org/deregistered/N9795J-1968-03-08.md): Piper PA-28-180 · S/N 28-4002 · Cancelled Mar 8, 1968 · Exported to Canada · Built 1967 · Bismarck, ND
- [N2734X](https://openairdocs.org/deregistered/N2734X-1967-05-22.md): Cessna 180H · S/N 18051534 · Cancelled May 22, 1967 · Exported to Canada · Bismark, ND
- [N8814C](https://openairdocs.org/deregistered/N8814C-1965-05-21.md): Piper PA-22-150 · S/N 22-1428 · Cancelled May 21, 1965 · Mandaw, ND

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

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