# Cancelled registrations: Defiance, OH

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

Cancelled aircraft registrations in Defiance, OH.

- [N567GD](https://openairdocs.org/deregistered/N567GD-2022-12-03.md): Cessna 320D · S/N 320D0022 · Cancelled Dec 3, 2022 · Registration expired, pending cancellation · Built 1965 · Tas Aviation Of Defiance Inc
- [N434AF](https://openairdocs.org/deregistered/N434AF-2022-11-05.md): Clements Steven QUICKSILVERMXIISPORT · S/N 993 · Cancelled Nov 5, 2022 · Registration expired, pending cancellation · Built 1999 · Burkhart Mark H
- [N214WE](https://openairdocs.org/deregistered/N214WE-2018-03-01.md): Drasutis Paul A QUICKSILVER SPORT 2S · S/N 0217 · Cancelled Mar 1, 2018 · Registration expired, pending cancellation · Built 2008 · Drasutis Paul A
- [N912XL](https://openairdocs.org/deregistered/N912XL-2013-03-18.md): Louks Raymond L PULSAR · S/N 251 · Cancelled Mar 18, 2013 · Registration expired, pending cancellation · Built 1993 · Louks Raymond L
- [N2072D](https://openairdocs.org/deregistered/N2072D-2008-05-14.md): Cameron Balloons US N-77 · S/N 5431 · Cancelled May 14, 2008 · Triennial form not returned · Built 1988 · J & M Leasing Of Defiance Inc
- [N7507T](https://openairdocs.org/deregistered/N7507T-2008-05-14.md): Cameron Balloons US N-77 · S/N 5800 · Cancelled May 14, 2008 · Triennial form not returned · Built 1993 · J & M Leasing Of Defiance Inc
- [N29915](https://openairdocs.org/deregistered/N29915-2005-06-14.md): Cameron Balloons US N-77 · S/N 5221 · Cancelled Jun 14, 2005 · Triennial form not returned · Built 1986 · J & M Leasing Of Defiance Inc
- [N29235](https://openairdocs.org/deregistered/N29235-1992-12-10.md): Hass SCORPION II · S/N S7520 · Cancelled Dec 10, 1992 · Triennial form not returned · Baden Jerry L
- [N2572C](https://openairdocs.org/deregistered/N2572C-1991-01-29.md): Piper PA-38-112 · S/N 3879A0235 · Cancelled Jan 29, 1991 · Triennial form not returned · Tas Aviation Of Defiance Inc
- [N1923R](https://openairdocs.org/deregistered/N1923R-1981-02-23.md): Raven S-50A · S/N S50A-127 · Cancelled Feb 23, 1981 · Built 1969 · Defiance College
- [N1563E](https://openairdocs.org/deregistered/N1563E-1975-10-01.md): Aeronca 7AC · S/N 7AC-5126 · Cancelled Oct 1, 1975 · Exported to Canada · Rose Paul I
- [N11309](https://openairdocs.org/deregistered/N11309-1974-06-26.md): Cessna 150L · S/N 15075318 · Cancelled Jun 26, 1974 · Exported to Canada · Built 1973 · M L Aviation Inc
- [N3722H](https://openairdocs.org/deregistered/N3722H-1971-04-19.md): Engineering & Research 415-D · S/N 4347 · Cancelled Apr 19, 1971 · Mcgovney John E
- [N7156W](https://openairdocs.org/deregistered/N7156W-1971-01-04.md): Piper PA-28-180 · S/N 28-964 · Cancelled Jan 4, 1971 · Flying D Inc
- [N7063K](https://openairdocs.org/deregistered/N7063K-1964-07-29.md): Piper PA-20 · S/N 20169 · Cancelled Jul 29, 1964 · Lane Elmer
- [N3964](https://openairdocs.org/deregistered/N3964-1928-11-20.md): Simplex RED ARROW · S/N 12 · Cancelled Nov 20, 1928 · Built 1927 · Simplex 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 = 'OH' AND d.registrant_city = 'DEFIANCE'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

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