# Earlier aircraft under this name: Hamilton Aircraft Co

A list on [Hamilton Aircraft Co](https://openairdocs.org/faa-owner/HAMILTON%20AIRCRAFT%20CO.md).

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

- [N6679](https://openairdocs.org/deregistered/N6679-1977-07-14.md): Beech 3 TM · S/N CA-124 · Cancelled Jul 14, 1977 · Pima, AZ
- [N6128](https://openairdocs.org/deregistered/N6128-1971-10-26.md): Beech 3 TM · S/N 43-35873 · Cancelled Oct 26, 1971 · Tucson, AZ
- [N6177](https://openairdocs.org/deregistered/N6177-1971-10-26.md): Beech 3T · S/N 6142 · Cancelled Oct 26, 1971 · Tucson, AZ
- [N6178](https://openairdocs.org/deregistered/N6178-1971-10-26.md): Beech 3T · S/N 43-35556 · Cancelled Oct 26, 1971 · Tucson, AZ
- [N6179](https://openairdocs.org/deregistered/N6179-1971-10-26.md): Beech 3T · S/N 43-35549 · Cancelled Oct 26, 1971 · Tucson, AZ
- [N6180](https://openairdocs.org/deregistered/N6180-1971-10-26.md): Beech 3T · S/N 5852 · Cancelled Oct 26, 1971 · Tucson, AZ
- [N6368](https://openairdocs.org/deregistered/N6368-1971-10-26.md): Beech 3T · S/N 7841 · Cancelled Oct 26, 1971 · Tucson, AZ
- [N6369](https://openairdocs.org/deregistered/N6369-1971-10-26.md): Beech 3T · S/N 8199 · Cancelled Oct 26, 1971 · Tucson, AZ
- [N6687](https://openairdocs.org/deregistered/N6687-1969-02-24.md): Beech 3 TM · S/N CA156 · Cancelled Feb 24, 1969 · Exported to Mexico
- [N9460Z](https://openairdocs.org/deregistered/N9460Z-1967-05-25.md): North American T-28A · S/N 49-1596 · Cancelled May 25, 1967 · Exported to Ecuador · Tucson, AZ
- [N9100Z](https://openairdocs.org/deregistered/N9100Z-1967-05-12.md): North American T-28A · S/N 50-229 · Cancelled May 12, 1967 · Tucson, AZ
- [N1717](https://openairdocs.org/deregistered/N1717-1965-05-18.md): Lockheed 14-N2 · S/N 7419 · Cancelled May 18, 1965 · Built 1942 · Tucson, AZ
- [N9103Z](https://openairdocs.org/deregistered/N9103Z-1963-06-18.md): North American T-28A · S/N 49-1734 · Cancelled Jun 18, 1963 · Exported to Mexico · Tucson, AZ
- [N7040C](https://openairdocs.org/deregistered/N7040C-1959-12-10.md): Boeing B-17G · S/N 44-83778 · Cancelled Dec 10, 1959 · Tucson, AZ
- [N7041C](https://openairdocs.org/deregistered/N7041C-1959-12-10.md): Boeing B-17G · S/N 44-83763 · Cancelled Dec 10, 1959 · Tucson, AZ
- [N7042C](https://openairdocs.org/deregistered/N7042C-1959-12-10.md): Boeing B-17G · S/N 44-83634 · Cancelled Dec 10, 1959 · Tucson, AZ
- [N7044C](https://openairdocs.org/deregistered/N7044C-1959-12-10.md): Boeing B-17G · S/N 44-83600 · Cancelled Dec 10, 1959 · Tucson, AZ

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

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