# Cancelled registrations: Miamisburg, OH

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

Cancelled aircraft registrations in Miamisburg, OH.

- [N801MP](https://openairdocs.org/deregistered/N801MP-2021-05-12.md): Patey Mark STOL CH-801 · S/N 84299 · Cancelled May 12, 2021 · Sale reported · Built 2007
- [N440HG](https://openairdocs.org/deregistered/N440HG-2020-12-05.md): Robinson Helicopter R44 · S/N 0485 · Cancelled Dec 5, 2020 · Registration expired, pending cancellation · Built 1998 · Higher Ground Helicopters Of Cincinnati LLC
- [N3737D](https://openairdocs.org/deregistered/N3737D-2018-02-15.md): Quad City Ultralights CHALLENGER I · S/N 0392 0380 · Cancelled Feb 15, 2018 · Registration expired, pending cancellation · Built 1996 · Swensen Conrad J Jr
- [N9146U](https://openairdocs.org/deregistered/N9146U-2018-01-29.md): Cessna 150M · S/N 15078097 · Cancelled Jan 29, 2018 · Registration expired, pending cancellation · Built 1976 · Schechter Ralph A
- [N199TX](https://openairdocs.org/deregistered/N199TX-2017-07-13.md): Cessna R182 · S/N R18200286 · Cancelled Jul 13, 2017 · Second renewal notice · Built 1978 · Dayton Pilots Club Inc
- [N4506W](https://openairdocs.org/deregistered/N4506W-2016-04-14.md): Piper PA-28-181 · S/N 28-8090028 · Cancelled Apr 14, 2016 · Built 1979 · Dayton Pilots Club Inc
- [N14284](https://openairdocs.org/deregistered/N14284-2015-09-24.md): Piper PA-23-250 · S/N 27-4847 · Cancelled Sep 24, 2015 · Built 1972 · Aviation Sales Inc
- [N1998S](https://openairdocs.org/deregistered/N1998S-2014-12-22.md): Cameron Balloons US 0-105 · S/N 5339 · Cancelled Dec 22, 2014 · Registration expired, pending cancellation · Built 1987 · Blum Roger J
- [N453WB](https://openairdocs.org/deregistered/N453WB-2013-10-22.md): Wright B Flyer WRIGHT B FLYER · S/N 002 · Cancelled Oct 22, 2013 · First renewal notice · Built 2010 · Wright B Flyer Inc
- [N6034K](https://openairdocs.org/deregistered/N6034K-2013-09-13.md): Cessna 150M · S/N 15077485 · Cancelled Sep 13, 2013 · Registration expired, pending cancellation · Built 1975 · Fliteway Inc
- [N9006Z](https://openairdocs.org/deregistered/N9006Z-2013-06-05.md): Aerostar International RX-7 · S/N RX7-3268 · Cancelled Jun 5, 2013 · Registration expired, pending cancellation · Built 1992 · Sandstrom Stephen B
- [N5593U](https://openairdocs.org/deregistered/N5593U-2013-04-22.md): Piper PA-28-140 · S/N 28-26323 · Cancelled Apr 22, 2013 · Registration expired, pending cancellation · Built 1969 · Wrenn Thomas E
- [N6575Y](https://openairdocs.org/deregistered/N6575Y-2011-03-18.md): Piper PA-23-250 · S/N 27-3874 · Cancelled Mar 18, 2011 · Expired dealer · Built 1968 · Fliteways Sales Inc
- [N6629E](https://openairdocs.org/deregistered/N6629E-2008-02-20.md): Golden Circle Air T-BIRD I · S/N T-274 · Cancelled Feb 20, 2008 · Exported to Canada · Built 2006 · Lambert Douglas E
- [N9731V](https://openairdocs.org/deregistered/N9731V-2006-09-22.md): Cessna 172M · S/N 17264495 · Cancelled Sep 22, 2006 · Triennial form not returned · Built 1974 · Schechter Ralph A
- [N3712G](https://openairdocs.org/deregistered/N3712G-2005-02-01.md): Robinson Helicopter R22 BETA · S/N 3169 · Cancelled Feb 1, 2005 · Exported to Canada · Built 2001 · Eagle Helicopters Inc
- [N38390](https://openairdocs.org/deregistered/N38390-2004-09-13.md): Piper PA-28-140 · S/N 28-7725279 · Cancelled Sep 13, 2004 · Triennial form not returned · Built 1977 · Blue Skies Aviation
- [N5363Q](https://openairdocs.org/deregistered/N5363Q-1998-03-13.md): Cessna 150L · S/N 15073263 · Cancelled Mar 13, 1998 · Triennial form not returned · Schechter Ralph A
- [N8611U](https://openairdocs.org/deregistered/N8611U-1991-10-29.md): Cessna 172 · S/N 17252512 · Cancelled Oct 29, 1991 · Triennial form not returned · Fisher Loman T
- [N217HB](https://openairdocs.org/deregistered/N217HB-1981-12-30.md): Bell SCORPION TOO · S/N 1240 · Cancelled Dec 30, 1981 · Built 1976 · Bell Homer K
- [N256C](https://openairdocs.org/deregistered/N256C-1981-03-13.md): Stinson 108-2 · S/N 108-3256 · Cancelled Mar 13, 1981 · Built 1947 · Brewer David C
- [N704FF](https://openairdocs.org/deregistered/N704FF-1980-04-25.md): Cessna 150M · S/N 15078571 · Cancelled Apr 25, 1980 · Exported to Canada · Fliteways Inc
- [N81337](https://openairdocs.org/deregistered/N81337-1973-03-20.md): Fairchild 24R-46 · S/N R46237 · Cancelled Mar 20, 1973 · Exported to Canada · Built 1946 · Dayton Aviation Co Inc
- [N8425M](https://openairdocs.org/deregistered/N8425M-1971-12-03.md): Cessna A150K · S/N A15000125 · Cancelled Dec 3, 1971 · Built 1969 · Mound Flying Club
- [N11KB](https://openairdocs.org/deregistered/N11KB-1971-09-14.md): Beech B-55 · S/N TC-1294 · Cancelled Sep 14, 1971 · Kyle Brogan
- [N2689G](https://openairdocs.org/deregistered/N2689G-1970-06-05.md): Cessna 182B · S/N 51989 · Cancelled Jun 5, 1970 · Aviation Sales Inc
- [N3304A](https://openairdocs.org/deregistered/N3304A-1963-11-06.md): Piper PA-22-135 · S/N 22-1582 · Cancelled Nov 6, 1963 · Sharritts Richard Raymond Ditmyer
- [N7408T](https://openairdocs.org/deregistered/N7408T-1961-03-20.md): Cessna 172A · S/N 47008 · Cancelled Mar 20, 1961 · Aviation Sales Inc

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

This list as a web page: https://openairdocs.org/faa-place/OH/Miamisburg/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, except the copies of manufacturers’ service documents, which belong to their rights holders.
