# Cancelled registrations: Marysville, OH

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

Cancelled aircraft registrations in Marysville, OH.

- [N9073R](https://openairdocs.org/deregistered/N9073R-2021-05-08.md): Buckeye DREAM MACHINE · S/N 4003 · Cancelled May 8, 2021 · Registration expired, pending cancellation · Built 1998 · Rosebrook John D
- [N74531](https://openairdocs.org/deregistered/N74531-2019-05-06.md): Mooney M20B · S/N 1842 · Cancelled May 6, 2019 · Registration expired, pending cancellation · Built 1961 · Friend Richard
- [N83DK](https://openairdocs.org/deregistered/N83DK-2019-04-22.md): Kroeplin Daniel KOLB MARK III · S/N 137 · Cancelled Apr 22, 2019 · Built 1996 · Kroeplin Daniel L
- [N3633L](https://openairdocs.org/deregistered/N3633L-2018-01-18.md): Aerostar International RX 8 · S/N RX8-3046 · Cancelled Jan 18, 2018 · Registration expired, pending cancellation · Built 1990 · Scobee Robert C
- [N2919Y](https://openairdocs.org/deregistered/N2919Y-2013-07-02.md): Aerostar International RX-7 · S/N RX7-3019 · Cancelled Jul 2, 2013 · Registration expired, pending cancellation · Built 1986 · Bishop Trent J
- [N563W](https://openairdocs.org/deregistered/N563W-2012-08-10.md): Heath BD-4 · S/N P-239 · Cancelled Aug 10, 2012 · Registration expired, pending cancellation · Heath Foundation
- [N6703J](https://openairdocs.org/deregistered/N6703J-2008-11-07.md): Beech 77 · S/N WA-46 · Cancelled Nov 7, 2008 · Exported to Mexico · Built 1979 · Prime Aero Inc
- [N6335Z](https://openairdocs.org/deregistered/N6335Z-2004-04-05.md): Mathys Greg A FISHER - AVENGER · S/N 00146 · Cancelled Apr 5, 2004 · Triennial form not returned · Built 1998 · Mathys Greg A
- [N6382W](https://openairdocs.org/deregistered/N6382W-2003-10-07.md): Winkle John E AVENGER · S/N A0-152 · Cancelled Oct 7, 2003 · Triennial form not returned · Built 1999 · Winkle John E
- [N72GR](https://openairdocs.org/deregistered/N72GR-1993-10-06.md): Ripley Forest Z MAX · S/N 382 · Cancelled Oct 6, 1993 · Ripley Forest E
- [N5106S](https://openairdocs.org/deregistered/N5106S-1973-11-20.md): Piper PA-28R-200 · S/N 28R7135105 · Cancelled Nov 20, 1973 · Exported to Canada · Flying Machines Inc
- [N4674L](https://openairdocs.org/deregistered/N4674L-1972-11-03.md): Cessna 172G · S/N 17254669 · Cancelled Nov 3, 1972 · Exported to Canada · Built 1966 · Flying Machines Inc
- [N2687W](https://openairdocs.org/deregistered/N2687W-1972-07-07.md): Mooney M20C · S/N 3322 · Cancelled Jul 7, 1972 · Exported to Canada · Flying Machines Inc
- [N3774F](https://openairdocs.org/deregistered/N3774F-1972-05-11.md): Cessna 172H · S/N 17255269 · Cancelled May 11, 1972 · Exported to Canada · Flying Machine Inc
- [N97547](https://openairdocs.org/deregistered/N97547-1971-11-09.md): Stinson 108 · S/N 108-547 · Cancelled Nov 9, 1971 · Exported to Canada · Flying Machines Inc
- [N3633Q](https://openairdocs.org/deregistered/N3633Q-1971-11-08.md): Beech 19A · S/N MB-292 · Cancelled Nov 8, 1971 · Exported to Canada · Built 1968 · Flying Machines Inc
- [N98486](https://openairdocs.org/deregistered/N98486-1971-07-16.md): Piper J3C-65 · S/N 18689 · Cancelled Jul 16, 1971 · Built 1946 · Ripley Forest E
- [N3858W](https://openairdocs.org/deregistered/N3858W-1971-06-25.md): Piper PA-32-260 · S/N 32-800 · Cancelled Jun 25, 1971 · Exported to Canada · Flying Machines Inc
- [N7898P](https://openairdocs.org/deregistered/N7898P-1971-06-22.md): Piper PA-24-250 · S/N 24-3127 · Cancelled Jun 22, 1971 · Exported to Canada · Flying Machines Inc
- [N9041X](https://openairdocs.org/deregistered/N9041X-1971-06-14.md): Cessna 182 · S/N 18253441 · Cancelled Jun 14, 1971 · Exported to Canada · Flying Machines Inc
- [N1926C](https://openairdocs.org/deregistered/N1926C-1971-03-09.md): Cessna 170B · S/N 26071 · Cancelled Mar 9, 1971 · Exported to Canada · Flying Machines Inc
- [N76968](https://openairdocs.org/deregistered/N76968-1971-03-01.md): Cessna 120 · S/N 11414 · Cancelled Mar 1, 1971 · Exported to Canada · Built 1946 · Flying Machines Inc
- [N7983W](https://openairdocs.org/deregistered/N7983W-1971-03-01.md): Piper PA-28-180 · S/N 28-2037 · Cancelled Mar 1, 1971 · Exported to Canada · Russell Clark Trucking Co Inc
- [N2464Q](https://openairdocs.org/deregistered/N2464Q-1971-01-05.md): Cessna 182K · S/N 18257664 · Cancelled Jan 5, 1971 · Exported to Canada · Flying Machines Inc
- [N9076K](https://openairdocs.org/deregistered/N9076K-1965-05-21.md): Stinson 108-1 · S/N 108-2076 · Cancelled May 21, 1965 · Lee Louis

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

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