# Cancelled registrations: Crawfordsville, IN

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

Cancelled aircraft registrations in Crawfordsville, IN.

- [N34599](https://openairdocs.org/deregistered/N34599-2023-10-24.md): Aeronca 65-CA · S/N C15931 · Cancelled Oct 24, 2023 · Revoked, canceled · Built 1941 · Thompson Roy
- [N3673N](https://openairdocs.org/deregistered/N3673N-2022-06-04.md): Mooney M-20G · S/N 680031 · Cancelled Jun 4, 2022 · Registration expired, pending cancellation · Built 1967 · Manker Bernard E Jr
- [N5428B](https://openairdocs.org/deregistered/N5428B-2013-11-12.md): Cessna 182 · S/N 33428 · Cancelled Nov 12, 2013 · Registration expired, pending cancellation · Built 1956 · Calvert Byron M
- [N313SH](https://openairdocs.org/deregistered/N313SH-2013-07-23.md): Team Rocket F1 ROCKET · S/N 127B · Cancelled Jul 23, 2013 · Registration expired, pending cancellation · Sugar Creek Flying Service
- [N29BG](https://openairdocs.org/deregistered/N29BG-2013-04-10.md): Cordon Brian J DRAGONFLY · S/N 326 · Cancelled Apr 10, 2013 · Registration expired, pending cancellation · Gordon Brian J
- [N2886R](https://openairdocs.org/deregistered/N2886R-2002-03-29.md): Cessna 182K · S/N 18258486 · Cancelled Mar 29, 2002 · Exported to Canada · Built 1967 · Photon Aviation Inc
- [N137JM](https://openairdocs.org/deregistered/N137JM-1995-06-06.md): Martz John SKYE-RYDER II · S/N 9310732 · Cancelled Jun 6, 1995 · Martz John
- [N5197D](https://openairdocs.org/deregistered/N5197D-1994-08-08.md): Cessna 182A · S/N 51297 · Cancelled Aug 8, 1994 · Triennial form not returned · Touch N Go Flying Club
- [N2189G](https://openairdocs.org/deregistered/N2189G-1980-02-19.md): Cessna 182A · S/N 51489 · Cancelled Feb 19, 1980 · Jones Arthur J
- [N4862A](https://openairdocs.org/deregistered/N4862A-1974-11-06.md): Piper PA-22-150 · S/N 22-4201 · Cancelled Nov 6, 1974 · Rose Clarence
- [N2516X](https://openairdocs.org/deregistered/N2516X-1974-10-11.md): Cessna P206 · S/N P206-0016 · Cancelled Oct 11, 1974 · Nash Ronald L
- [N3559Q](https://openairdocs.org/deregistered/N3559Q-1973-10-01.md): Cessna A188 · S/N 188-0509 · Cancelled Oct 1, 1973 · Basils Aerial Corp Service Inc
- [N8200V](https://openairdocs.org/deregistered/N8200V-1973-07-23.md): Cessna 180H · S/N 18051702 · Cancelled Jul 23, 1973 · Exported to Canada · Swisher James
- [N8926W](https://openairdocs.org/deregistered/N8926W-1970-09-23.md): Piper PA-28-235 · S/N 28-10497 · Cancelled Sep 23, 1970 · Exported to New Zealand · Lawson M Dale
- [N2391E](https://openairdocs.org/deregistered/N2391E-1965-05-19.md): Champion 7AC · S/N 7AC-5970 · Cancelled May 19, 1965 · Basil H Hockersmith
- [N74434](https://openairdocs.org/deregistered/N74434-1959-01-15.md): Bellanca 14-13-2 · S/N 1547 · Cancelled Jan 15, 1959 · Mcgaughey Leo
- [N99230](https://openairdocs.org/deregistered/N99230-1954-10-18.md): Engineering & Research 415-C · S/N 1853 · Cancelled Oct 18, 1954 · Built 1946 · Hanson Parker
- [N77300](https://openairdocs.org/deregistered/N77300-1951-08-22.md): Cessna 140 · S/N 11742 · Cancelled Aug 22, 1951 · Built 1946 · Hill Chester C
- [N39417](https://openairdocs.org/deregistered/N39417-1951-08-01.md): Stinson 10A · S/N 8217 · Cancelled Aug 1, 1951 · Built 1942 · Jescheke Wire & Specialty Co
- [N97779](https://openairdocs.org/deregistered/N97779-1948-04-27.md): Stinson 108-1 · S/N 779 · Cancelled Apr 27, 1948 · Built 1946 · Bruner Russell L

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

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