# Earlier aircraft under this name: Davis Aviation Inc

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

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

- [N701X](https://openairdocs.org/deregistered/N701X-2021-01-11.md): Beech E-90 · S/N LW-165 · Cancelled Jan 11, 2021 · Registration expired, pending cancellation · Brandon, MS
- [N75LA](https://openairdocs.org/deregistered/N75LA-2021-01-11.md): Beech 100 · S/N B-75 · Cancelled Jan 11, 2021 · Registration expired, pending cancellation · Built 1971 · Brandon, MS
- [N9116Q](https://openairdocs.org/deregistered/N9116Q-2021-01-11.md): Piper PA-42-720R · S/N 42-5501037 · Cancelled Jan 11, 2021 · Registration expired, pending cancellation · Built 1986 · Brandon, MS
- [N1551](https://openairdocs.org/deregistered/N1551-2021-01-09.md): Beech A200 · S/N BC-39 · Cancelled Jan 9, 2021 · Registration expired, pending cancellation · Brandon, MS
- [N43WS](https://openairdocs.org/deregistered/N43WS-2021-01-09.md): Beech E-90 · S/N LW-16 · Cancelled Jan 9, 2021 · Registration expired, pending cancellation · Brandon, MS
- [N206K](https://openairdocs.org/deregistered/N206K-2019-04-10.md): Beech 300 · S/N FA-36 · Cancelled Apr 10, 2019 · Built 1984 · Brandon, MS
- [N702TD](https://openairdocs.org/deregistered/N702TD-2018-09-13.md): Beech B100 · S/N BE-110 · Cancelled Sep 13, 2018 · Registration expired, pending cancellation · Built 1981 · Brandon, MS
- [N311AV](https://openairdocs.org/deregistered/N311AV-2013-11-01.md): Beech 200 · S/N BB-336 · Cancelled Nov 1, 2013 · Second renewal notice · Built 1978 · Brandon, MS
- [N855DA](https://openairdocs.org/deregistered/N855DA-1998-05-21.md): Cessna 152 · S/N 15282588 · Cancelled May 21, 1998 · Triennial form not returned · Gig Harbor, WA
- [N10221](https://openairdocs.org/deregistered/N10221-1977-07-29.md): Grumman G-164 · S/N 21 · Cancelled Jul 29, 1977 · Colusa, CA
- [N4385C](https://openairdocs.org/deregistered/N4385C-1970-06-29.md): Champion 7EC · S/N 411 · Cancelled Jun 29, 1970 · New Orleans, LA
- [N46710](https://openairdocs.org/deregistered/N46710-1955-10-10.md): Fairchild M-62A · S/N T-41-512 · Cancelled Oct 10, 1955 · New Orleans, LA
- [N75210](https://openairdocs.org/deregistered/N75210-1954-12-28.md): Cessna T-50 · S/N 5615 · Cancelled Dec 28, 1954 · New Orleans, LA
- [N88397](https://openairdocs.org/deregistered/N88397-1952-12-17.md): Piper J3C-65S · S/N 16015 · Cancelled Dec 17, 1952 · New Orleans, LA
- [N46883](https://openairdocs.org/deregistered/N46883-1951-10-22.md): Fairchild M-62A · S/N T43-5842 · Cancelled Oct 22, 1951 · New Orleans, LA
- [N6456K](https://openairdocs.org/deregistered/N6456K-1951-02-14.md): Republic RC-3 · S/N 707 · Cancelled Feb 14, 1951 · New Orleans, LA
- [N88401](https://openairdocs.org/deregistered/N88401-1951-02-14.md): Piper J3C-65S · S/N 16019 · Cancelled Feb 14, 1951 · New Orleans, LA
- [N75209](https://openairdocs.org/deregistered/N75209-1948-04-21.md): Cessna T-50 · S/N 1963 · Cancelled Apr 21, 1948 · New Orleans, LA

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

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