# Cancelled registrations: Connersville, IN

A list on [Connersville, IN](https://openairdocs.org/faa-place/IN/Connersville.md).

Cancelled aircraft registrations in Connersville, IN.

- [N71453](https://openairdocs.org/deregistered/N71453-2023-10-01.md): Fisher Michael E CELEBRITY · S/N AV1015 · Cancelled Oct 1, 2023 · Sale reported, canceled
- [N71TB](https://openairdocs.org/deregistered/N71TB-2020-08-02.md): Brewer Thomas J JR FLIGHTSTAR II SC · S/N 01 · Cancelled Aug 2, 2020 · Sale reported, canceled · Built 2003
- [N35200](https://openairdocs.org/deregistered/N35200-2020-01-16.md): Piper J3L-65 · S/N 6247 · Cancelled Jan 16, 2020 · Revoked, pending cancellation · Built 1941 · Sevilla Richard
- [N692TG](https://openairdocs.org/deregistered/N692TG-2019-10-05.md): DJI INSPIRE 1 · S/N W1DCG29040453 · Cancelled Oct 5, 2019 · Registration expired, pending cancellation · Granger Branden L
- [N692UG](https://openairdocs.org/deregistered/N692UG-2019-10-05.md): DJI PHANTOM 3 STANDARD · S/N P5ADCH1506028M · Cancelled Oct 5, 2019 · Registration expired, pending cancellation · Granger Branden L
- [N61KR](https://openairdocs.org/deregistered/N61KR-2012-11-09.md): Rieder Kris RANS S-6ES COYOTE II · S/N 0592310 · Cancelled Nov 9, 2012 · Registration expired, pending cancellation · Rieder Kris A
- [N76MP](https://openairdocs.org/deregistered/N76MP-2006-01-27.md): Mooney M20L · S/N 26-0009 · Cancelled Jan 27, 2006 · Triennial form not returned · Cirrus Inc
- [N287JC](https://openairdocs.org/deregistered/N287JC-2005-01-31.md): Cox Jerry E C217 · S/N 217287JC · Cancelled Jan 31, 2005 · Triennial form not returned · Cox Jerry E
- [N99710](https://openairdocs.org/deregistered/N99710-1983-06-22.md): Engineering & Research ERCOUPE 415-D · S/N 2333 · Cancelled Jun 22, 1983 · Administratively canceled · Todd Joseph E
- [N5546J](https://openairdocs.org/deregistered/N5546J-1974-04-23.md): Piper PA-32-260 · S/N 321008 · Cancelled Apr 23, 1974 · Duncan Thomas W
- [N3556A](https://openairdocs.org/deregistered/N3556A-1972-08-11.md): Piper PA-22-135 · S/N 22-1830 · Cancelled Aug 11, 1972 · King John W
- [N64326](https://openairdocs.org/deregistered/N64326-1965-05-22.md): Fairchild M-62C · S/N 2723-AE · Cancelled May 22, 1965 · Connersville Flying Service
- [N3971E](https://openairdocs.org/deregistered/N3971E-1965-05-20.md): Aeronca 11BC · S/N 11BC-56 · Cancelled May 20, 1965 · Built 1947 · Hamilton W R/Hudson A M/Hume W C
- [N1224](https://openairdocs.org/deregistered/N1224-1948-03-09.md): Waco HRE · S/N 5095 · Cancelled Mar 9, 1948 · Built 1940 · American Central Manufacturing Corp
- [N87991](https://openairdocs.org/deregistered/N87991-1946-06-22.md): Piper J3C-65 · S/N 15608 · Cancelled Jun 22, 1946 · Binder Leland Dean
- [N2926](https://openairdocs.org/deregistered/N2926-1932-06-22.md): Curtiss JN4H · S/N 34044 · Cancelled Jun 22, 1932 · Cohen Frank

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

This list as a web page: https://openairdocs.org/faa-place/IN/Connersville/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.