# Cancelled registrations: Ravenna, OH

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

Cancelled aircraft registrations in Ravenna, OH.

- [N709EW](https://openairdocs.org/deregistered/N709EW-2019-09-06.md): DJI PHANTOM 3 PROFESSION · S/N P76DCI07017475 · Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Walouke Charles A
- [N3543A](https://openairdocs.org/deregistered/N3543A-2017-04-07.md): Piper PA-31-350 · S/N 31-7952242 · Cancelled Apr 7, 2017 · Registration expired, pending cancellation · Built 1979 · Grossmann Michael H
- [N4204U](https://openairdocs.org/deregistered/N4204U-2014-10-06.md): Cessna 150D · S/N 15060204 · Cancelled Oct 6, 2014 · Registration expired, pending cancellation · Built 1963 · Prichard Charles B
- [N629TM](https://openairdocs.org/deregistered/N629TM-2014-08-14.md): Mitsubishi MU-2B-35 · S/N 631 · Cancelled Aug 14, 2014 · Built 1974 · Corporate Aircraft Management
- [N3871B](https://openairdocs.org/deregistered/N3871B-2013-09-26.md): Beech F35 · S/N D-4154 · Cancelled Sep 26, 2013 · Registration expired, pending cancellation · Built 1955 · United Aero Services Inc
- [N71140](https://openairdocs.org/deregistered/N71140-2013-05-31.md): Balloon Works FIREFLY 7-B · S/N F7B-139 · Cancelled May 31, 2013 · Sale reported, canceled
- [N55WN](https://openairdocs.org/deregistered/N55WN-2013-03-26.md): Nichols Terry DRAGONFLY · S/N 030 · Cancelled Mar 26, 2013 · Sale reported, canceled · Built 1982
- [N9302T](https://openairdocs.org/deregistered/N9302T-2013-03-18.md): Piper PA-38-112 · S/N 38-78A0012 · Cancelled Mar 18, 2013 · Sale reported, canceled · Built 1978
- [N47316](https://openairdocs.org/deregistered/N47316-2000-08-29.md): Cessna 152 · S/N 15283213 · Cancelled Aug 29, 2000 · Triennial form not returned · Chinn Robert
- [N47109](https://openairdocs.org/deregistered/N47109-2000-04-13.md): Cessna 152 · S/N 15283171 · Cancelled Apr 13, 2000 · Triennial form not returned · Chinn Robert
- [N6308E](https://openairdocs.org/deregistered/N6308E-1999-10-25.md): Aerostar International RAVEN S-55A · S/N S55A-3056 · Cancelled Oct 25, 1999 · Triennial form not returned · Tad Enterprises One Inc
- [N3077X](https://openairdocs.org/deregistered/N3077X-1998-05-04.md): Bertel Bonnie J QUCKSLVR MXL SPRT II · S/N 572 · Cancelled May 4, 1998 · Triennial form not returned · Bertel Bonnie J
- [N5364M](https://openairdocs.org/deregistered/N5364M-1992-08-05.md): Cessna 152 · S/N 15284564 · Cancelled Aug 5, 1992 · Triennial form not returned · Chinn Robert
- [N231RK](https://openairdocs.org/deregistered/N231RK-1991-06-19.md): Mooney M20K · S/N 250172 · Cancelled Jun 19, 1991 · Exported to France · United Aero Sales Inc
- [N82535](https://openairdocs.org/deregistered/N82535-1991-03-20.md): Piper PA-32-301T · S/N 328024040 · Cancelled Mar 20, 1991 · Exported to United Kingdom · United Aero Sales Inc
- [N9371B](https://openairdocs.org/deregistered/N9371B-1972-05-11.md): Cessna 175 · S/N 55171 · Cancelled May 11, 1972 · Martin A Quentin
- [N6102L](https://openairdocs.org/deregistered/N6102L-1971-05-04.md): American AA-1 · S/N AA1-0302 · Cancelled May 4, 1971 · Shirbill Airways Inc
- [N92610](https://openairdocs.org/deregistered/N92610-1970-12-31.md): Piper J3C-65 · S/N 16977 · Cancelled Dec 31, 1970 · Ravenna Air 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 = 'OH' AND d.registrant_city = 'RAVENNA'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

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