# Earlier aircraft under this name: Midwest Aviation Inc

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

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

- [N59DK](https://openairdocs.org/deregistered/N59DK-2020-02-21.md): Cessna 172S · S/N 172S11193 · Cancelled Feb 21, 2020 · Exported to Canada · Built 2012 · West Paducah, KY
- [N9819A](https://openairdocs.org/deregistered/N9819A-2019-10-02.md): Cessna 195A · S/N 7498 · Cancelled Oct 2, 2019 · Revoked, canceled · Built 1950 · Kirkwood, MO
- [N7237Z](https://openairdocs.org/deregistered/N7237Z-2017-02-04.md): Piper PA-25-235 · S/N 25-3161 · Cancelled Feb 4, 2017 · Revoked, canceled · Built 1965 · Baldwin, KS
- [N931JP](https://openairdocs.org/deregistered/N931JP-2016-09-21.md): Cessna T182T · S/N T18208897 · Cancelled Sep 21, 2016 · Exported to Canada · Built 2008 · West Paducah, KY
- [N528D](https://openairdocs.org/deregistered/N528D-2013-09-17.md): American Champion 8KCAB · S/N 1010-2005 · Cancelled Sep 17, 2013 · Exported to Indonesia · Built 2005 · West Paducah, KY
- [N60423](https://openairdocs.org/deregistered/N60423-2013-02-26.md): Cessna 172R · S/N 17281338 · Cancelled Feb 26, 2013 · Exported to Mexico · Built 2006 · West Paducah, KY
- [N281ME](https://openairdocs.org/deregistered/N281ME-2013-02-20.md): Cessna 172S · S/N 172S8539 · Cancelled Feb 20, 2013 · Exported to Canada · Built 2000 · West Paducah, KY
- [N586BJ](https://openairdocs.org/deregistered/N586BJ-2012-10-25.md): Cessna 172S · S/N 172S9232 · Cancelled Oct 25, 2012 · Exported to Malaysia · Built 2002 · West Paducah, KY
- [N429SP](https://openairdocs.org/deregistered/N429SP-2011-03-31.md): Cessna 172S · S/N 172S8355 · Cancelled Mar 31, 2011 · Exported to Canada · Built 2000 · West Paducah, KY
- [N61XS](https://openairdocs.org/deregistered/N61XS-2011-01-19.md): Cessna T182T · S/N T18208369 · Cancelled Jan 19, 2011 · Exported to New Zealand · Built 2005 · West Paducah, KY
- [N3504J](https://openairdocs.org/deregistered/N3504J-2010-12-28.md): Cessna 172S · S/N 172S8855 · Cancelled Dec 28, 2010 · Exported to Australia · West Paducah, KY
- [N17869](https://openairdocs.org/deregistered/N17869-2010-11-23.md): Cessna T182T · S/N T18208431 · Cancelled Nov 23, 2010 · Exported to South Africa · Built 2005 · West Paducah, KY
- [N5302U](https://openairdocs.org/deregistered/N5302U-2010-06-29.md): Cessna 172S · S/N 172S9251 · Cancelled Jun 29, 2010 · Exported to Brazil · Built 2002 · West Paducah, KY
- [N796SA](https://openairdocs.org/deregistered/N796SA-2010-06-17.md): Hawker Beechcraft G36 · S/N E-3796 · Cancelled Jun 17, 2010 · Exported to Australia · Built 2007 · West Paducah, KY
- [N4674K](https://openairdocs.org/deregistered/N4674K-2010-02-08.md): Cessna R172K · S/N R1722008 · Cancelled Feb 8, 2010 · Exported to Bolivia · Built 1976 · West Paducah, KY
- [N456DY](https://openairdocs.org/deregistered/N456DY-2010-02-05.md): Hawker Beechcraft G36 · S/N E-3787 · Cancelled Feb 5, 2010 · Exported to Australia · Built 2007 · West Paducah, KY
- [N1487D](https://openairdocs.org/deregistered/N1487D-2009-08-19.md): Cessna T182T · S/N T18208422 · Cancelled Aug 19, 2009 · Exported to Canada · Built 2005 · West Paducah, KY
- [N967AC](https://openairdocs.org/deregistered/N967AC-2008-01-22.md): Cessna 182T · S/N 18280995 · Cancelled Jan 22, 2008 · Exported to Australia · Built 2001 · West Paducah, KY
- [N6924B](https://openairdocs.org/deregistered/N6924B-2006-10-19.md): Raytheon A36 · S/N E-3090 · Cancelled Oct 19, 2006 · Exported to Australia · Built 1997 · West Paducah, KY
- [N213WG](https://openairdocs.org/deregistered/N213WG-2005-06-30.md): American Champion 8KCAB · S/N 745-95 · Cancelled Jun 30, 2005 · Exported to Canada · Built 1995 · West Paducah, KY
- [N717MA](https://openairdocs.org/deregistered/N717MA-2005-02-02.md): American Champion 8KCAB · S/N 950-2004 · Cancelled Feb 2, 2005 · Exported to Paraguay · Built 2004 · West Paducah, KY
- [N6042V](https://openairdocs.org/deregistered/N6042V-1997-05-05.md): Beech C24R · S/N MC660 · Cancelled May 5, 1997 · Exported to Portugal · West Paducah, KY
- [N74DC](https://openairdocs.org/deregistered/N74DC-1993-11-30.md): Beech V35B · S/N D9610 · Cancelled Nov 30, 1993 · Paducah, KY
- [N7370R](https://openairdocs.org/deregistered/N7370R-1991-07-01.md): Beech 95-B55 (T42A) · S/N TC1719 · Cancelled Jul 1, 1991 · Exported to Guatemala · Paducah, KY
- [N73319](https://openairdocs.org/deregistered/N73319-1956-02-20.md): Fairchild PT-26 M62A3 · S/N FV-141 · Cancelled Feb 20, 1956 · Fenton, MI
- [N95259](https://openairdocs.org/deregistered/N95259-1949-05-16.md): Taylorcraft BC12-D · S/N 9659 · Cancelled May 16, 1949 · Fenton, MI

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

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