# Cancelled registrations: Charles City, IA

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

Cancelled aircraft registrations in Charles City, IA.

- [N430WT](https://openairdocs.org/deregistered/N430WT-2026-09-18.md): Lyno Dynamics LD220 · S/N 2166FBQUC25BE0012DE7 · Cancelled Sep 18, 2026 · Ca Enterprises LLC
- [N65079](https://openairdocs.org/deregistered/N65079-2023-12-11.md): Harmening HIGHFLYER DELUXE · S/N 005999 · Cancelled Dec 11, 2023 · Sale reported, canceled · Built 1999
- [N9648S](https://openairdocs.org/deregistered/N9648S-2021-08-10.md): Gemini Industrie GEMINI TWIN 1 · S/N 0011 · Cancelled Aug 10, 2021 · First renewal notice · Built 2002 · Aikey Jason L
- [N983D](https://openairdocs.org/deregistered/N983D-2019-01-29.md): Universal Stinson 108-2 · S/N 108-2983 · Cancelled Jan 29, 2019 · Revoked, canceled · Built 1947 · Wright James C
- [N579DC](https://openairdocs.org/deregistered/N579DC-2018-12-11.md): Crop Copter MAX FLIGHT PRO · S/N MPF0004 · Cancelled Dec 11, 2018 · Registration expired, pending cancellation · Viafield
- [N551JD](https://openairdocs.org/deregistered/N551JD-2018-10-23.md): Sensefly EBEE · S/N EB-03-32398 · Cancelled Oct 23, 2018 · Registration expired, pending cancellation · Viafield
- [N2991H](https://openairdocs.org/deregistered/N2991H-2018-03-23.md): Engineering & Research ERCOUPE 415-C · S/N 3616 · Cancelled Mar 23, 2018 · Revoked, canceled · Built 1946 · Bramer Raymond A
- [N7157R](https://openairdocs.org/deregistered/N7157R-2015-05-04.md): Townsend Barton AVID FLYER · S/N 496 · Cancelled May 4, 2015 · Registration expired, pending cancellation · Built 1991 · Mulcahy Roger D
- [N210DA](https://openairdocs.org/deregistered/N210DA-2000-03-24.md): Cessna 210 · S/N 21064229 · Cancelled Mar 24, 2000 · Exported to Mexico · Charles City Aeronautics Inc
- [N2366N](https://openairdocs.org/deregistered/N2366N-1991-11-22.md): Piper PA-38-112 · S/N 3879A0812 · Cancelled Nov 22, 1991 · Triennial form not returned · Charles City Aeronautics Inc
- [N5013](https://openairdocs.org/deregistered/N5013-1971-09-29.md): Bensen B8M · S/N 1000 · Cancelled Sep 29, 1971 · Boyd Vernon
- [N3994V](https://openairdocs.org/deregistered/N3994V-1971-09-27.md): Cessna 170 · S/N 18313 · Cancelled Sep 27, 1971 · Revoked, canceled · Built 1948 · Charles City Flying Club
- [N7784Y](https://openairdocs.org/deregistered/N7784Y-1967-08-24.md): Piper PA-30 · S/N 30-867 · Cancelled Aug 24, 1967 · Charles City Aeronautics Inc
- [N74616](https://openairdocs.org/deregistered/N74616-1956-04-30.md): Fairchild PT-26 · S/N 6534 · Cancelled Apr 30, 1956 · Grafton Monaghan
- [N64518](https://openairdocs.org/deregistered/N64518-1956-03-22.md): Boeing B75N1 · S/N 75-6879 · Cancelled Mar 22, 1956 · Ray Bramer Flying Service
- [N1203C](https://openairdocs.org/deregistered/N1203C-1954-08-19.md): Piper PA-20 · S/N 20-965 · Cancelled Aug 19, 1954 · Exported to Canada · Ray Bramer Flying Service
- [N92606](https://openairdocs.org/deregistered/N92606-1951-05-03.md): Piper J3C-65 · S/N 16973 · Cancelled May 3, 1951 · Henry Flying Service

## 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 = 'CHARLES CITY'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

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