# Earlier aircraft under this name: Department Of Transportation

A list on [Department Of Transportation](https://openairdocs.org/faa-owner/DEPARTMENT%20OF%20TRANSPORTATION.md).

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

- [N36978](https://openairdocs.org/deregistered/N36978-2019-09-06.md): DJI S1000 PREMIUM · S/N A2:0210072999 · Cancelled Sep 6, 2019 · Registration expired, pending cancellation · State Of Tennessee, Nashville, TN
- [N721LL](https://openairdocs.org/deregistered/N721LL-2018-03-06.md): Bell 206L-3 · S/N 51164 · Cancelled Mar 6, 2018 · Registration expired, pending cancellation · Built 1986 · State Of Illinois, Springfield, IL
- [N891LL](https://openairdocs.org/deregistered/N891LL-2017-10-12.md): Cessna U206G · S/N U206-06937 · Cancelled Oct 12, 2017 · First renewal notice · Built 1986 · State Of Illinois, Springfield, IL
- [N1244S](https://openairdocs.org/deregistered/N1244S-2015-08-19.md): Cessna 337H · S/N 33701892 · Cancelled Aug 19, 2015 · Exported to Canada · Built 1979 · State Of Illinois, Springfield, IL
- [N741LL](https://openairdocs.org/deregistered/N741LL-2013-02-06.md): Bell 206L-3 · S/N 51165 · Cancelled Feb 6, 2013 · First renewal notice · State Of Illinois, Springfield, IL
- [N781LL](https://openairdocs.org/deregistered/N781LL-2004-10-21.md): Bell 206L · S/N 45079 · Cancelled Oct 21, 2004 · Exported to Canada · State Of Illinois, Springfield, IL
- [N86SD](https://openairdocs.org/deregistered/N86SD-1994-07-14.md): Mitsubishi MU-2B-60 · S/N 765SA · Cancelled Jul 14, 1994 · Triennial form not returned · South Dakota State Of, Pierre, SD
- [N870H](https://openairdocs.org/deregistered/N870H-1993-10-07.md): Fairchild F-27F · S/N 71 · Cancelled Oct 7, 1993 · Exported to Ecuador · State Of Ohio, Columbus, OH
- [N30BL](https://openairdocs.org/deregistered/N30BL-1990-02-17.md): Pitts S-1S · S/N L2 · Cancelled Feb 17, 1990 · Administratively canceled · Paxton Jack, Paducah, KY
- [N141KT](https://openairdocs.org/deregistered/N141KT-1985-01-23.md): Bauer Lawrence L EASY RISER · S/N LB-1 · Cancelled Jan 23, 1985 · Administratively canceled · Bauer Lawrence L, Rockford, MI
- [N2964W](https://openairdocs.org/deregistered/N2964W-1984-07-11.md): Bell 206B · S/N 818 · Cancelled Jul 11, 1984 · Administratively canceled · Arizona Helicopters Inc, Scottsdale, AZ
- [N2990F](https://openairdocs.org/deregistered/N2990F-1984-02-25.md): Beech H-18 · S/N BA-753 · Cancelled Feb 25, 1984 · Administratively canceled · Airtour Acquisition Corp, Honolulu, HI
- [N2958F](https://openairdocs.org/deregistered/N2958F-1984-01-10.md): Handley Page HP-137 MK1 · S/N 201 · Cancelled Jan 10, 1984 · Administratively canceled · Apollo Airways Inc, Goleta, CA
- [N2954K](https://openairdocs.org/deregistered/N2954K-1983-11-15.md): Cessna 180K · S/N 18053137 · Cancelled Nov 15, 1983 · Administratively canceled · State Of Georgia, Atlanta, GA
- [N77112](https://openairdocs.org/deregistered/N77112-1982-09-14.md): Douglas DC3C 1830-94 · S/N 25627 · Cancelled Sep 14, 1982 · Washington, DC
- [N33](https://openairdocs.org/deregistered/N33-1982-03-24.md): Douglas DC3C-S1C3G · S/N 26583 · Cancelled Mar 24, 1982 · Built 1944 · Washington, DC
- [N35](https://openairdocs.org/deregistered/N35-1982-03-24.md): Douglas DC3C 1830-94 · S/N 32794 · Cancelled Mar 24, 1982 · Built 1945 · Washington, DC
- [N9](https://openairdocs.org/deregistered/N9-1980-09-30.md): Beech 65-80 · S/N LD-83 · Cancelled Sep 30, 1980 · Washington, DC
- [N22](https://openairdocs.org/deregistered/N22-1975-05-06.md): Douglas C-47A · S/N 20033 · Cancelled May 6, 1975 · Built 1944 · Washington, DC
- [N6](https://openairdocs.org/deregistered/N6-1975-04-10.md): Douglas DC3A 1830-94 · S/N 4146 · Cancelled Apr 10, 1975 · Washington, DC
- [N29](https://openairdocs.org/deregistered/N29-1975-01-16.md): Douglas DC3C · S/N 33133 · Cancelled Jan 16, 1975 · Washington, DC
- [N87818](https://openairdocs.org/deregistered/N87818-1974-11-25.md): Douglas DC3C 1830-94 · S/N 4279 · Cancelled Nov 25, 1974 · Built 1946 · Washington, DC
- [N152](https://openairdocs.org/deregistered/N152-1973-02-02.md): Lockheed TV-2 · S/N 128671 · Cancelled Feb 2, 1973 · Washington, DC
- [N247](https://openairdocs.org/deregistered/N247-1973-01-03.md): Convair AT-29C · S/N 378 · Cancelled Jan 3, 1973 · Washington, DC
- [N25](https://openairdocs.org/deregistered/N25-1971-03-23.md): Douglas DC3C 1830-94 · S/N 10243 · Cancelled Mar 23, 1971 · Built 1943 · Washington, DC
- [N47](https://openairdocs.org/deregistered/N47-1970-10-06.md): Douglas DC3C · S/N 33155 · Cancelled Oct 6, 1970 · Washington, DC
- [N81](https://openairdocs.org/deregistered/N81-1969-06-27.md): Douglas C-54G · S/N 35941 · Cancelled Jun 27, 1969 · Washington, DC
- [N246](https://openairdocs.org/deregistered/N246-1969-05-06.md): Convair ET-29C · S/N 364 · Cancelled May 6, 1969 · 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 = 'DEPARTMENT OF TRANSPORTATION' OR list_contains(d.other_registrant_names, 'DEPARTMENT OF TRANSPORTATION')
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

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