# Earlier aircraft under this name: Aeronautical Accessories Inc

A list on [Aeronautical Accessories Inc](https://openairdocs.org/faa-owner/AERONAUTICAL%20ACCESSORIES%20INC.md).

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

- [N9233A](https://openairdocs.org/deregistered/N9233A-2018-01-29.md): Bell UH-1H · S/N 70-16330 · Cancelled Jan 29, 2018 · Registration expired, pending cancellation · Bristol, TN
- [N9249N](https://openairdocs.org/deregistered/N9249N-2018-01-29.md): Bell UH-1H · S/N 70-16271 · Cancelled Jan 29, 2018 · Registration expired, pending cancellation · Bristol, TN
- [N42389](https://openairdocs.org/deregistered/N42389-2018-01-19.md): Bell UH-1H · S/N 70-16414 · Cancelled Jan 19, 2018 · Registration expired, pending cancellation · Bristol, TN
- [N9247H](https://openairdocs.org/deregistered/N9247H-2017-07-19.md): Bell UH-1H · S/N 69-15729 · Cancelled Jul 19, 2017 · Registration expired, pending cancellation · Piney Flats, TN
- [N92514](https://openairdocs.org/deregistered/N92514-2017-07-18.md): Bell UH-1H · S/N 71-20221 · Cancelled Jul 18, 2017 · Registration expired, pending cancellation · Piney Flats, TN
- [N42294](https://openairdocs.org/deregistered/N42294-2017-07-10.md): Bell UH-1H · S/N 69-15175 · Cancelled Jul 10, 2017 · Registration expired, pending cancellation · Piney Flats, TN
- [N9249U](https://openairdocs.org/deregistered/N9249U-2017-06-19.md): Bell UH-1H · S/N 70-16292 · Cancelled Jun 19, 2017 · Registration expired, pending cancellation · Piney Flats, TN
- [N9239H](https://openairdocs.org/deregistered/N9239H-2017-03-06.md): Bell UH-1H · S/N 69-15309 · Cancelled Mar 6, 2017 · Registration expired, pending cancellation · Bristol, TN
- [N174MC](https://openairdocs.org/deregistered/N174MC-2013-09-19.md): Messerschmitt-Boelkow-Blohm-Gm BO-105C · S/N S74 · Cancelled Sep 19, 2013 · Registration expired, pending cancellation · Built 1973 · Bristol, TN
- [N1048G](https://openairdocs.org/deregistered/N1048G-2007-12-05.md): Bell UH-1H · S/N 69-15217 · Cancelled Dec 5, 2007 · Piney Flats, TN
- [N47HP](https://openairdocs.org/deregistered/N47HP-2007-12-01.md): Bell UH-1H · S/N 74-22469 · Cancelled Dec 1, 2007 · Piney Flats, TN
- [N23LV](https://openairdocs.org/deregistered/N23LV-1997-12-05.md): Bell 206B · S/N 2329 · Cancelled Dec 5, 1997 · Triennial form not returned · Bristol, TN
- [N206RV](https://openairdocs.org/deregistered/N206RV-1996-04-23.md): Bell 206B · S/N 1094 · Cancelled Apr 23, 1996 · Exported to Canada · Bristol, TN
- [N59590](https://openairdocs.org/deregistered/N59590-1985-03-18.md): Bell 206B · S/N 1469 · Cancelled Mar 18, 1985 · Exported to Canada · Bristol, TN
- [N2272D](https://openairdocs.org/deregistered/N2272D-1982-11-22.md): Bell 206B · S/N 3551 · Cancelled Nov 22, 1982 · Exported to Canada · Bristol, TN
- [N67219](https://openairdocs.org/deregistered/N67219-1981-03-05.md): Bell 206B · S/N 420 · Cancelled Mar 5, 1981 · Exported to Canada · Blountville, 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 = 'AERONAUTICAL ACCESSORIES INC' OR list_contains(d.other_registrant_names, 'AERONAUTICAL ACCESSORIES INC')
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

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