# Cancelled registrations: Vermilion, OH

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

Cancelled aircraft registrations in Vermilion, OH.

- [N307WD](https://openairdocs.org/deregistered/N307WD-2019-11-19.md): Yuneec TYPHOON Q500 4K · S/N YU15262231804801 · Cancelled Nov 19, 2019 · Third renewal notice · Karman Robert M
- [N81976](https://openairdocs.org/deregistered/N81976-2019-08-05.md): Aeronca 7AC · S/N 7AC601 · Cancelled Aug 5, 2019 · Revoked, canceled · Built 1946 · Burkle Richard H
- [N1535V](https://openairdocs.org/deregistered/N1535V-2018-05-18.md): Curtiss Wright C-46F · S/N 44-78553 · Cancelled May 18, 2018 · Revoked, canceled · Built 1951 · Sunnyside Enterprises Inc
- [N6138D](https://openairdocs.org/deregistered/N6138D-2018-03-06.md): Piper PA-22-150 · S/N 22-4782 · Cancelled Mar 6, 2018 · Registration expired, pending cancellation · Built 1957 · Mueller Michael H
- [N9908W](https://openairdocs.org/deregistered/N9908W-2013-10-28.md): Piper PA-28-140 · S/N 28-23428 · Cancelled Oct 28, 2013 · Registration expired, pending cancellation · Built 1967 · Burwell Stephen R
- [N3136T](https://openairdocs.org/deregistered/N3136T-2013-07-02.md): Cessna 177 · S/N 17700436 · Cancelled Jul 2, 2013 · Registration expired, pending cancellation · Built 1967 · Newburger Randolph E
- [N4955S](https://openairdocs.org/deregistered/N4955S-2013-03-29.md): Cessna R182 · S/N R18201492 · Cancelled Mar 29, 2013 · Exported to South Africa · Built 1980 · Armbruster LLC
- [N5837H](https://openairdocs.org/deregistered/N5837H-2013-02-21.md): Piper PA-16 · S/N 16-455 · Cancelled Feb 21, 2013 · Revoked, canceled · Built 1949 · Drown Rolland K
- [N9533U](https://openairdocs.org/deregistered/N9533U-2012-09-17.md): Grumman American Avn. AA-1C · S/N AA1C0029 · Cancelled Sep 17, 2012 · Exported to Australia · Built 1977 · Armbruster LLC
- [N92574](https://openairdocs.org/deregistered/N92574-2011-11-21.md): Cessna R182 · S/N R18201928 · Cancelled Nov 21, 2011 · Exported to Australia · Built 1982 · Armbruster LLC
- [N2243T](https://openairdocs.org/deregistered/N2243T-2010-08-13.md): Cessna R182 · S/N R18200003 · Cancelled Aug 13, 2010 · Exported to Venezuela · Built 1977 · Armbruster LLC
- [N19696](https://openairdocs.org/deregistered/N19696-2009-12-28.md): Cessna 172L · S/N 17260678 · Cancelled Dec 28, 2009 · Exported to Paraguay · Built 1972 · Armbruster LLC
- [N286AC](https://openairdocs.org/deregistered/N286AC-2009-11-12.md): Cessna 172N · S/N 17272120 · Cancelled Nov 12, 2009 · Exported to Brazil · Built 1979 · Armbruster LLC
- [N4458W](https://openairdocs.org/deregistered/N4458W-2009-11-12.md): Beech F33A · S/N CE-490 · Cancelled Nov 12, 2009 · Exported to Brazil · Built 1974 · Armbruster LLC
- [N5287L](https://openairdocs.org/deregistered/N5287L-2009-11-12.md): Piper PA-28-180 · S/N 28-4587 · Cancelled Nov 12, 2009 · Exported to Canada · Built 1967 · Armbruster LLC
- [N5770L](https://openairdocs.org/deregistered/N5770L-1996-02-14.md): S N I A S AS-350B ECUREUIL · S/N 1377 · Cancelled Feb 14, 1996 · Exported to Canada · Brown Donald A
- [N5674E](https://openairdocs.org/deregistered/N5674E-1971-10-13.md): Cessna 150 · S/N 17174 · Cancelled Oct 13, 1971 · Mis Frank J

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

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