# Cancelled registrations: Richmond, IN

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

Cancelled aircraft registrations in Richmond, IN.

- [N563PP](https://openairdocs.org/deregistered/N563PP-2021-10-02.md): DJI PV331 · S/N PH645356436 V2.0 · Cancelled Oct 2, 2021 · Registration expired, pending cancellation · City Of Richmond Police Dept
- [N417R](https://openairdocs.org/deregistered/N417R-2021-09-15.md): Aeropro CZ S R O A240 · S/N 29 309 · Cancelled Sep 15, 2021 · Built 2009 · Costlow Judson J
- [N38363](https://openairdocs.org/deregistered/N38363-2020-06-26.md): Piper J5A · S/N 5943 · Cancelled Jun 26, 2020 · Revoked, canceled · Built 1941 · Gause Ralph E
- [N2851](https://openairdocs.org/deregistered/N2851-2018-09-13.md): Davis D-1-66 · S/N 103 · Cancelled Sep 13, 2018 · Registration expired, pending cancellation · Built 1929 · Wayne County In Historical Society
- [N601BR](https://openairdocs.org/deregistered/N601BR-2017-09-07.md): Rehmel R S/Rehmel R L ZNTH ZODIAC CH601HDS · S/N 64410 · Cancelled Sep 7, 2017 · Registration expired, pending cancellation · Rehmel Robert S
- [N5897P](https://openairdocs.org/deregistered/N5897P-2017-04-05.md): Piper PA-24-250 · S/N 24-984 · Cancelled Apr 5, 2017 · Third renewal notice · Built 1959 · Fisher William
- [N74441](https://openairdocs.org/deregistered/N74441-2017-02-04.md): Bellanca 14-13-2 · S/N 1554 · Cancelled Feb 4, 2017 · Revoked, canceled · Built 1947 · Dancho Louis H
- [N9105H](https://openairdocs.org/deregistered/N9105H-2012-09-10.md): Cessna T-50 · S/N 3531 · Cancelled Sep 10, 2012 · Revoked, canceled · Built 1943 · Purves Mfg Corp
- [N295CB](https://openairdocs.org/deregistered/N295CB-2008-08-15.md): Cameron Balloons V-56 · S/N 451 · Cancelled Aug 15, 2008 · Triennial form not returned · Built 1979 · Magaw William P
- [N8270U](https://openairdocs.org/deregistered/N8270U-2007-09-20.md): White Gerald D EXEC 162F · S/N 6358 · Cancelled Sep 20, 2007 · Exported to New Zealand · Built 1998 · White Gerald D
- [N7915N](https://openairdocs.org/deregistered/N7915N-1977-07-21.md): Piper PA-28-180 · S/N 28-5327 · Cancelled Jul 21, 1977 · Nixon Tool Co Inc
- [N7798N](https://openairdocs.org/deregistered/N7798N-1972-02-29.md): Piper PA-28-180 · S/N 28-5247 · Cancelled Feb 29, 1972 · Built 1969 · Hall Webster F
- [N9967T](https://openairdocs.org/deregistered/N9967T-1969-12-11.md): Piper PA-28R-180 · S/N 28R-30555 · Cancelled Dec 11, 1969 · Weiss Leo S
- [N5181L](https://openairdocs.org/deregistered/N5181L-1968-08-06.md): Piper PA-28-180 · S/N 28-4467 · Cancelled Aug 6, 1968 · Richmond Flying Service Inc
- [N69735](https://openairdocs.org/deregistered/N69735-1956-02-20.md): Consolidated Vultee BT-13A · S/N 2407 · Cancelled Feb 20, 1956 · Winter Robert J
- [N22151](https://openairdocs.org/deregistered/N22151-1951-07-31.md): Aeronca 65-C · S/N C-2479 · Cancelled Jul 31, 1951 · Built 1939 · Mcbride James
- [N99718](https://openairdocs.org/deregistered/N99718-1951-07-25.md): Erco 415-C · S/N 2341 · Cancelled Jul 25, 1951 · Pea Roy D
- [N36887](https://openairdocs.org/deregistered/N36887-1950-05-12.md): Aeronca 65-TAL · S/N L2011TA · Cancelled May 12, 1950 · Built 1941 · Winter Robert J
- [N22124](https://openairdocs.org/deregistered/N22124-1949-10-28.md): Aeronca 50-C · S/N C-2268 · Cancelled Oct 28, 1949 · Universal C I T Credit Corporation
- [N17598](https://openairdocs.org/deregistered/N17598-1948-08-09.md): Piper J-2 · S/N 1098 · Cancelled Aug 9, 1948 · Rodefeld E F
- [N10990](https://openairdocs.org/deregistered/N10990-1948-03-31.md): Curtiss Wright CW-1 · S/N 1168 · Cancelled Mar 31, 1948 · Richmond Arpt & Flying Service
- [N1587](https://openairdocs.org/deregistered/N1587-1940-11-04.md): Driggs DART II · S/N 5 · Cancelled Nov 4, 1940 · Built 1927 · Hedges L M Et Al
- [N10N](https://openairdocs.org/deregistered/N10N-1940-06-15.md): Keystone K-78 (PATRICIAN) · S/N 206 · Cancelled Jun 15, 1940 · Heath Alford D
- [N649N](https://openairdocs.org/deregistered/N649N-1930-09-19.md): Davis D-1-K · S/N 506 · Cancelled Sep 19, 1930 · Davis Aircraft Corp
- [N842N](https://openairdocs.org/deregistered/N842N-1930-06-13.md): Davis D-1-K · S/N 502 · Cancelled Jun 13, 1930 · Davis Aircraft Corp
- [N733K](https://openairdocs.org/deregistered/N733K-1929-12-05.md): Davis V-3 · S/N 125 · Cancelled Dec 5, 1929 · Davis Aircraft Corp

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

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