# Earlier aircraft under this name: Roach Aircraft Inc

A list on [Roach Aircraft Inc](https://openairdocs.org/faa-owner/ROACH%20AIRCRAFT%20INC.md).

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

- [N24951](https://openairdocs.org/deregistered/N24951-1981-06-02.md): Piper J3L-65 · S/N 3559 · Cancelled Jun 2, 1981 · Denver, CO
- [N735GF](https://openairdocs.org/deregistered/N735GF-1980-03-04.md): Cessna TU206G · S/N U20604918 · Cancelled Mar 4, 1980 · Exported to Mexico · Broomfield, CO
- [N7569M](https://openairdocs.org/deregistered/N7569M-1979-05-10.md): Cessna U206G · S/N U20604516 · Cancelled May 10, 1979 · Exported to Canada · Broomfield, CO
- [N4269C](https://openairdocs.org/deregistered/N4269C-1978-12-26.md): Cessna 340A · S/N 340A0520 · Cancelled Dec 26, 1978 · Exported to Mexico · Built 1978 · Denver, CO
- [N3204T](https://openairdocs.org/deregistered/N3204T-1978-05-03.md): Cessna 177 · S/N 17700504 · Cancelled May 3, 1978 · Exported to Denmark · Built 1967 · Denver, CO
- [N6826R](https://openairdocs.org/deregistered/N6826R-1977-02-22.md): Cessna T210G · S/N T210-0226 · Cancelled Feb 22, 1977 · Denver, CO
- [N9859Q](https://openairdocs.org/deregistered/N9859Q-1976-04-20.md): Cessna 172M · S/N 17265803 · Cancelled Apr 20, 1976 · Exported to Canada · Built 1975 · Broomfield, CO
- [N4255L](https://openairdocs.org/deregistered/N4255L-1976-03-24.md): Cessna 172G · S/N 17254324 · Cancelled Mar 24, 1976 · Exported to Canada · Built 1966 · Broomfield, CO
- [N6325F](https://openairdocs.org/deregistered/N6325F-1975-11-28.md): Cessna 182P · S/N 18264158 · Cancelled Nov 28, 1975 · Exported to Canada · Denver, CO
- [N1517V](https://openairdocs.org/deregistered/N1517V-1974-10-21.md): Cessna 172M · S/N 17263639 · Cancelled Oct 21, 1974 · Exported to Canada · Broomfield, CO
- [N66013](https://openairdocs.org/deregistered/N66013-1974-09-19.md): Cessna 150L · S/N 15075775 · Cancelled Sep 19, 1974 · Exported to Canada · Broomfield, CO
- [N7755M](https://openairdocs.org/deregistered/N7755M-1974-07-26.md): Mooney M20E · S/N 21-0029 · Cancelled Jul 26, 1974 · Denver, CO
- [N3862R](https://openairdocs.org/deregistered/N3862R-1974-02-14.md): Cessna 172H · S/N 17255362 · Cancelled Feb 14, 1974 · Exported to Canada · Denver, CO
- [N555TM](https://openairdocs.org/deregistered/N555TM-1973-10-02.md): Cessna A150L · S/N A1500317 · Cancelled Oct 2, 1973 · Exported to Canada · Denver, CO
- [N9447V](https://openairdocs.org/deregistered/N9447V-1973-09-10.md): Mooney M20C · S/N 700050 · Cancelled Sep 10, 1973 · Exported to Canada · Denver, CO
- [N6553B](https://openairdocs.org/deregistered/N6553B-1971-04-14.md): Mooney M20A · S/N 1223 · Cancelled Apr 14, 1971 · Broomfield, CO
- [N5468F](https://openairdocs.org/deregistered/N5468F-1971-04-13.md): Alon A-2A · S/N B-268 · Cancelled Apr 13, 1971 · Denver, CO
- [N9578M](https://openairdocs.org/deregistered/N9578M-1970-09-09.md): Mooney M20F · S/N 670155 · Cancelled Sep 9, 1970 · Built 1966 · Broomfield, CO
- [N2726W](https://openairdocs.org/deregistered/N2726W-1970-06-16.md): Mooney M20E · S/N 1030 · Cancelled Jun 16, 1970 · Broomfield, CO
- [N4455C](https://openairdocs.org/deregistered/N4455C-1970-04-13.md): Cessna 195B · S/N 16040 · Cancelled Apr 13, 1970 · Built 1953 · Denver, CO
- [N3490X](https://openairdocs.org/deregistered/N3490X-1967-10-19.md): Mooney M20E · S/N 1160 · Cancelled Oct 19, 1967 · Exported to Canada · Denver, CO

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

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