# Earlier aircraft under this name: Colemill Enterprises Inc

A list on [Colemill Enterprises Inc](https://openairdocs.org/faa-owner/COLEMILL%20ENTERPRISES%20INC.md).

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

- [N111UU](https://openairdocs.org/deregistered/N111UU-2018-01-09.md): Piper PA-31-325 · S/N 318112024 · Cancelled Jan 9, 2018 · Registration expired, pending cancellation · Nashville, TN
- [N7485L](https://openairdocs.org/deregistered/N7485L-2014-12-22.md): Piper PA-31-310 · S/N 31-7300907 · Cancelled Dec 22, 2014 · Registration expired, pending cancellation · Built 1972 · Nashville, TN
- [N3076W](https://openairdocs.org/deregistered/N3076W-2008-11-06.md): Beech A100 · S/N B-176 · Cancelled Nov 6, 2008 · Exported to Canada · Built 1973 · Nashville, TN
- [N6119H](https://openairdocs.org/deregistered/N6119H-2001-01-12.md): Cessna 152 · S/N 15284132 · Cancelled Jan 12, 2001 · Triennial form not returned · Nashville, TN
- [N67002](https://openairdocs.org/deregistered/N67002-2001-01-12.md): Cessna 152 · S/N 15281716 · Cancelled Jan 12, 2001 · Triennial form not returned · Nashville, TN
- [N67296](https://openairdocs.org/deregistered/N67296-2001-01-12.md): Cessna 152 · S/N 15281731 · Cancelled Jan 12, 2001 · Triennial form not returned · Nashville, TN
- [N75832](https://openairdocs.org/deregistered/N75832-2000-04-26.md): Cessna 172N · S/N 17267988 · Cancelled Apr 26, 2000 · Triennial form not returned · Nashville, TN
- [N255Z](https://openairdocs.org/deregistered/N255Z-2000-03-28.md): Beech V35 · S/N D-8228 · Cancelled Mar 28, 2000 · Triennial form not returned · Nashville, TN
- [N24432](https://openairdocs.org/deregistered/N24432-1999-07-27.md): Cessna 152 · S/N 15280257 · Cancelled Jul 27, 1999 · Triennial form not returned · Nashville, TN
- [N30EL](https://openairdocs.org/deregistered/N30EL-1996-05-24.md): Piper PA-31-325 · S/N 318112077 · Cancelled May 24, 1996 · Exported to South Africa · Nashville, TN
- [N27404](https://openairdocs.org/deregistered/N27404-1994-02-24.md): Piper PA-31-325 · S/N 317712098 · Cancelled Feb 24, 1994 · Exported to Panama · Nashville, TN
- [N41BV](https://openairdocs.org/deregistered/N41BV-1994-02-10.md): Bell 206A · S/N 438 · Cancelled Feb 10, 1994 · Triennial form not returned · Nashville, TN
- [N7421L](https://openairdocs.org/deregistered/N7421L-1991-08-20.md): Piper PA-31 · S/N 31-806 · Cancelled Aug 20, 1991 · Exported to Canada · Built 1972 · Nashville, TN
- [N355SR](https://openairdocs.org/deregistered/N355SR-1991-06-21.md): Piper PA-31-325 · S/N 318012046 · Cancelled Jun 21, 1991 · Exported to Colombia · Nashville, TN
- [N804PC](https://openairdocs.org/deregistered/N804PC-1991-03-15.md): Piper PA-31-350 · S/N 31-7752110 · Cancelled Mar 15, 1991 · Exported to Canada · Nashville, TN
- [N9052Y](https://openairdocs.org/deregistered/N9052Y-1980-12-15.md): Piper PA-31 · S/N 3175 · Cancelled Dec 15, 1980 · Exported to Canada
- [N37457](https://openairdocs.org/deregistered/N37457-1980-10-17.md): Piper PA-31 · S/N 31-46 · Cancelled Oct 17, 1980 · Exported to Canada · Built 1967 · Nashville, TN
- [N8302Q](https://openairdocs.org/deregistered/N8302Q-1977-03-23.md): Cessna U206F · S/N U20603163 · Cancelled Mar 23, 1977 · Exported to Venezuela · Nashville, TN
- [N8382Q](https://openairdocs.org/deregistered/N8382Q-1977-03-04.md): Cessna U206F · S/N U20603243 · Cancelled Mar 4, 1977 · Exported to Venezuela · Nashville, TN
- [N6147X](https://openairdocs.org/deregistered/N6147X-1976-05-26.md): Aero Commander 500-A · S/N 500A-994-35 · Cancelled May 26, 1976 · Nashville, TN
- [N1607Q](https://openairdocs.org/deregistered/N1607Q-1976-01-16.md): Cessna U206F · S/N U20602914 · Cancelled Jan 16, 1976 · Exported to Venezuela · Nashville, TN
- [N1206Q](https://openairdocs.org/deregistered/N1206Q-1975-10-16.md): Cessna U206F · S/N U20602869 · Cancelled Oct 16, 1975 · Exported to Venezuela · Nashville, TN
- [N35823](https://openairdocs.org/deregistered/N35823-1975-07-25.md): Cessna U206 · S/N U20602742 · Cancelled Jul 25, 1975 · Exported to Venezuela · Nashville, TN
- [N6713L](https://openairdocs.org/deregistered/N6713L-1975-05-06.md): Piper PA-31 · S/N 31-608 · Cancelled May 6, 1975 · Exported to Canada · Nashville, TN
- [N4056G](https://openairdocs.org/deregistered/N4056G-1975-02-04.md): Bell 206A · S/N 211 · Cancelled Feb 4, 1975 · Exported to Canada · Nashville, TN
- [N1379M](https://openairdocs.org/deregistered/N1379M-1974-03-15.md): Cessna 172L · S/N 17260579 · Cancelled Mar 15, 1974 · Exported to Mexico · Nashville, TN
- [N5875G](https://openairdocs.org/deregistered/N5875G-1972-08-08.md): Cessna 150 · S/N 15071375 · Cancelled Aug 8, 1972 · Exported to Canada · Built 1969 · Nashville, TN
- [N5893G](https://openairdocs.org/deregistered/N5893G-1972-08-04.md): Cessna 150K · S/N 15071393 · Cancelled Aug 4, 1972 · Exported to Canada · Nashville, TN
- [N60132](https://openairdocs.org/deregistered/N60132-1972-04-18.md): Cessna 150J · S/N 15070094 · Cancelled Apr 18, 1972 · Exported to Canada · Nashville, TN

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

This list as a web page: https://openairdocs.org/faa-owner/COLEMILL%20ENTERPRISES%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, except the copies of manufacturers’ service documents, which belong to their rights holders.
