# Cancelled registrations: Red Oak, IA

A list on [Red Oak, IA](https://openairdocs.org/faa-place/IA/Red%20Oak.md).

Cancelled aircraft registrations in Red Oak, IA.

- [N89LA](https://openairdocs.org/deregistered/N89LA-2020-11-25.md): Robinson Helicopter R44 II · S/N 10984 · Cancelled Nov 25, 2020 · Built 2005 · Mills County Choppers Inc
- [N40917](https://openairdocs.org/deregistered/N40917-2019-05-04.md): Piper J3C-65 · S/N 7602 · Cancelled May 4, 2019 · Revoked, canceled · Built 1941 · Nease Harold A
- [N699TQ](https://openairdocs.org/deregistered/N699TQ-2018-03-02.md): Robinson Helicopter R44 II · S/N 10385 · Cancelled Mar 2, 2018 · Registration expired, pending cancellation · Built 2004 · Mills County Choppers Inc
- [N35131](https://openairdocs.org/deregistered/N35131-2018-01-18.md): Piper J3C-65 · S/N 6143 · Cancelled Jan 18, 2018 · Registration expired, pending cancellation · Nicks Inc
- [N6256D](https://openairdocs.org/deregistered/N6256D-2013-09-12.md): Aero Commander 680 · S/N 680-524-194 · Cancelled Sep 12, 2013 · Registration expired, pending cancellation · Built 1957 · Valley Aircraft Parts Inc
- [N1163K](https://openairdocs.org/deregistered/N1163K-2012-08-13.md): Luscombe 8A · S/N 3890 · Cancelled Aug 13, 2012 · Registration expired, pending cancellation · Built 1946 · Safety Fliers Inc
- [N160C](https://openairdocs.org/deregistered/N160C-2012-08-09.md): Stinson 108-2 · S/N 108-3160 · Cancelled Aug 9, 2012 · Registration expired, pending cancellation · Built 1947 · Classic Aero Inc
- [N6802W](https://openairdocs.org/deregistered/N6802W-2003-05-14.md): Piper PA-28-140 · S/N 28-20936 · Cancelled May 14, 2003 · Triennial form not returned · Built 1965 · Wagner Aero Service Inc
- [N88260](https://openairdocs.org/deregistered/N88260-1971-06-07.md): Piper J3C-65 · S/N 15876 · Cancelled Jun 7, 1971 · Donald L Chase / Richard O Willett
- [N4675T](https://openairdocs.org/deregistered/N4675T-1970-09-03.md): Gamble 6-64 GYROCOPTER · S/N GG1 · Cancelled Sep 3, 1970 · G R Gamble
- [N9256E](https://openairdocs.org/deregistered/N9256E-1965-05-26.md): Aeronca 11AC · S/N 11AC-890 · Cancelled May 26, 1965 · Built 1946 · Boyington Ives G
- [N70936](https://openairdocs.org/deregistered/N70936-1965-05-22.md): Piper J3C-65 · S/N 17960 · Cancelled May 22, 1965 · Carder John B
- [N55896](https://openairdocs.org/deregistered/N55896-1965-05-20.md): Cessna T-50 · S/N 2812 · Cancelled May 20, 1965 · Built 1943 · Belt R K
- [N64510](https://openairdocs.org/deregistered/N64510-1956-02-17.md): Cessna T-50 · S/N 5631 · Cancelled Feb 17, 1956 · Laire Jerald D
- [N54724](https://openairdocs.org/deregistered/N54724-1955-10-11.md): Fairchild M-62A · S/N T41-443 · Cancelled Oct 11, 1955 · Wyant Charles O
- [N96707](https://openairdocs.org/deregistered/N96707-1951-04-27.md): Taylorcraft BC12-D · S/N 9007 · Cancelled Apr 27, 1951 · Racine C E
- [N31632](https://openairdocs.org/deregistered/N31632-1951-04-17.md): Howard DGA-18 · S/N 632 · Cancelled Apr 17, 1951 · Racine C E DBA
- [N54787](https://openairdocs.org/deregistered/N54787-1949-03-04.md): Convair BT-13B · S/N 1425 · Cancelled Mar 4, 1949 · Mcquown Earl Jr

## 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_state = 'IA' AND d.registrant_city = 'RED OAK'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

This list as a web page: https://openairdocs.org/faa-place/IA/Red%20Oak/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.