# Cancelled registrations: Parma, OH

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

Cancelled aircraft registrations in Parma, OH.

- [N5596N](https://openairdocs.org/deregistered/N5596N-2020-05-01.md): Consolidated Vultee SNV-1 · S/N 5923 · Cancelled May 1, 2020 · Revoked, canceled · Hellman Engng
- [N753GK](https://openairdocs.org/deregistered/N753GK-2019-01-14.md): Kerr Gerald VELOCITY SUV · S/N SUV119 · Cancelled Jan 14, 2019 · Registration expired, pending cancellation · Built 2005 · Gulf Kilo Inc
- [N633DQ](https://openairdocs.org/deregistered/N633DQ-2018-06-11.md): DJI PHANTOM 2 VISION + · S/N BD210902525358 · Cancelled Jun 11, 2018 · Quinn John G
- [N77TH](https://openairdocs.org/deregistered/N77TH-2017-02-04.md): Cessna 172M · S/N 17262967 · Cancelled Feb 4, 2017 · Revoked, canceled · Built 1974 · Spurlock Mark G
- [N34DG](https://openairdocs.org/deregistered/N34DG-2013-10-29.md): Huber Gary SONERAI 2L · S/N 83911 · Cancelled Oct 29, 2013 · Registration expired, pending cancellation · Built 1983 · Huber Gary T
- [N8019Q](https://openairdocs.org/deregistered/N8019Q-2003-09-12.md): Cessna 421B · S/N 421B0019 · Cancelled Sep 12, 2003 · Second triennial mailing, no response · Built 1970 · Ford Motor Credit Company
- [N5662J](https://openairdocs.org/deregistered/N5662J-1996-05-24.md): Maule MX-7-180 · S/N 11016C · Cancelled May 24, 1996 · Exported to Brazil · Maden George E
- [N5660A](https://openairdocs.org/deregistered/N5660A-1991-03-22.md): Maule MX-7-180 · S/N 11005C · Cancelled Mar 22, 1991 · Triennial form not returned · Maden George
- [N9811](https://openairdocs.org/deregistered/N9811-1975-10-07.md): Bensen B-8M · S/N 31340 · Cancelled Oct 7, 1975 · Kilian Alan R
- [N4149T](https://openairdocs.org/deregistered/N4149T-1972-01-17.md): Cessna 320D · S/N 320D0049 · Cancelled Jan 17, 1972 · Air West Inc
- [N5581N](https://openairdocs.org/deregistered/N5581N-1965-06-02.md): Cessna T-50 · S/N 4792 · Cancelled Jun 2, 1965 · Bailey Frank J
- [N42314](https://openairdocs.org/deregistered/N42314-1954-12-28.md): Piper J3C-65 · S/N 14564 · Cancelled Dec 28, 1954 · Nick Parish
- [N93714](https://openairdocs.org/deregistered/N93714-1953-07-29.md): Ercoupe 415-C · S/N 1037 · Cancelled Jul 29, 1953 · Denk Mrs. Bertha
- [N36965](https://openairdocs.org/deregistered/N36965-1948-09-15.md): Aeronca 65-TAL · S/N L-2701-TA · Cancelled Sep 15, 1948 · Long William H
- [N15455](https://openairdocs.org/deregistered/N15455-1948-04-21.md): Porterfield 35-70 · S/N 155 · Cancelled Apr 21, 1948 · Built 1935 · Dase Roy Etal
- [N5609](https://openairdocs.org/deregistered/N5609-1940-04-15.md): Pheasant H-10 · S/N 126 · Cancelled Apr 15, 1940 · Lindsey Charles D

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

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