# Cancelled registrations: Van Wert, OH

A list on [Van Wert, OH](https://openairdocs.org/faa-place/OH/Van%20Wert.md).

Cancelled aircraft registrations in Van Wert, OH.

- [N82581](https://openairdocs.org/deregistered/N82581-2020-04-03.md): Aeronca 7AC · S/N 7AC-1218 · Cancelled Apr 3, 2020 · Revoked, canceled · Built 1946 · Sopina Mathew
- [N727NM](https://openairdocs.org/deregistered/N727NM-2014-11-17.md): Smith AEROSTAR 601A · S/N 61-0276-106 · Cancelled Nov 17, 2014 · Registration expired, pending cancellation · Built 1975 · Surgical Assoc Of Van Wert Inc
- [N5222W](https://openairdocs.org/deregistered/N5222W-2014-10-27.md): Piper PA-28 · S/N 28-259 · Cancelled Oct 27, 2014 · Registration expired, pending cancellation · Built 1961 · Evans Douglas E
- [N6390T](https://openairdocs.org/deregistered/N6390T-2013-04-29.md): Campbell Robert A COUGAR 1 · S/N RC-1 · Cancelled Apr 29, 2013 · Registration expired, pending cancellation · Built 1961 · Badders Jeff D
- [N10153](https://openairdocs.org/deregistered/N10153-2009-02-09.md): Miller Bleary Eye 1 · S/N 1 · Cancelled Feb 9, 2009 · Triennial form not returned · Built 1959 · Miller John T
- [N10DB](https://openairdocs.org/deregistered/N10DB-2007-05-08.md): Cessna 310L · S/N 310L-0201 · Cancelled May 8, 2007 · Built 1967 · Jamat Leasing Co Inc
- [N40369](https://openairdocs.org/deregistered/N40369-1995-10-04.md): Balloon Works FIREFLY 7 · S/N 7797 · Cancelled Oct 4, 1995 · Triennial form not returned · Sunrise Ballooning Adventures Inc
- [N2104X](https://openairdocs.org/deregistered/N2104X-1981-05-08.md): Cessna 337 · S/N 337-0004 · Cancelled May 8, 1981 · Exported to Canada · Built 1964 · Hammond John H DBA
- [N4040Y](https://openairdocs.org/deregistered/N4040Y-1979-09-13.md): Balloon Works FIREFLY 7 · S/N 7838 · Cancelled Sep 13, 1979 · Built 1978 · Laudick Stephen L
- [N40428](https://openairdocs.org/deregistered/N40428-1979-08-27.md): Balloon Works FIREFLY 7 · S/N 7863 · Cancelled Aug 27, 1979 · Laudick Steve
- [N6356L](https://openairdocs.org/deregistered/N6356L-1976-05-26.md): American AA-1A · S/N AA1A-0356 · Cancelled May 26, 1976 · Baker Herbert E
- [N6420L](https://openairdocs.org/deregistered/N6420L-1975-01-16.md): American AA-5 · S/N AA5-0222 · Cancelled Jan 16, 1975 · Hammond John H
- [N81916](https://openairdocs.org/deregistered/N81916-1974-05-17.md): Aeronca 7AC · S/N 7AC-539 · Cancelled May 17, 1974 · Van Wert Air Service
- [N5450Z](https://openairdocs.org/deregistered/N5450Z-1971-07-21.md): Piper PA-22-108 · S/N 22-9227 · Cancelled Jul 21, 1971 · Van Wert Aor Service Inc
- [N8115P](https://openairdocs.org/deregistered/N8115P-1970-09-21.md): Piper PA-24-250 · S/N 24-3368 · Cancelled Sep 21, 1970 · Alspach Funeral Home
- [N5517Z](https://openairdocs.org/deregistered/N5517Z-1963-10-31.md): Piper PA-22-108 · S/N 22-9304 · Cancelled Oct 31, 1963 · Exported to Canada · Built 1962 · Van Wert Air Service Inc
- [N27219](https://openairdocs.org/deregistered/N27219-1960-02-18.md): Porterfield LP-65 · S/N 716 · Cancelled Feb 18, 1960 · Gordon A Mcmillen
- [N61779](https://openairdocs.org/deregistered/N61779-1956-02-15.md): Boeing A75N1(PT17) · S/N 75-4791 · Cancelled Feb 15, 1956 · Mcgee Norman
- [N2253E](https://openairdocs.org/deregistered/N2253E-1951-11-21.md): Aeronca 7AC · S/N 7AC-5827 · Cancelled Nov 21, 1951 · Mcgee Norman C

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

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