# Cancelled registrations: Berea, OH

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

Cancelled aircraft registrations in Berea, OH.

- [N49826](https://openairdocs.org/deregistered/N49826-2019-12-30.md): Fairchild M-62A · S/N T423921 · Cancelled Dec 30, 2019 · Revoked, canceled · Built 1943 · King Glen W
- [N89599](https://openairdocs.org/deregistered/N89599-2014-11-20.md): Cessna 120 · S/N 8646 · Cancelled Nov 20, 2014 · Registration expired, pending cancellation · Built 1946 · Madden Thomas
- [N4484M](https://openairdocs.org/deregistered/N4484M-2014-10-01.md): Thornton/Thornton CGS HAWK MODEL B · S/N 124 · Cancelled Oct 1, 2014 · Registration expired, pending cancellation · Thornton Robert P
- [N20273](https://openairdocs.org/deregistered/N20273-2013-04-11.md): Cessna 172M · S/N 17261149 · Cancelled Apr 11, 2013 · Registration expired, pending cancellation · Built 1972 · Berea Aviation Corp
- [N5092Q](https://openairdocs.org/deregistered/N5092Q-2013-03-21.md): Cessna 310Q · S/N 310Q0501 · Cancelled Mar 21, 2013 · Registration expired, pending cancellation · Built 1972 · Tieber Joseph M
- [N293A](https://openairdocs.org/deregistered/N293A-2012-10-19.md): Sage-Taylor Monoplane ST-1 · S/N ST-1 · Cancelled Oct 19, 2012 · Registration expired, pending cancellation · Built 1970 · Sage Arthur L
- [N85EE](https://openairdocs.org/deregistered/N85EE-2010-03-16.md): Cessna 208 · S/N 20800391 · Cancelled Mar 16, 2010 · Exported to Canada · Built 2005 · Cleveland Browns Transportation LLC
- [N1527D](https://openairdocs.org/deregistered/N1527D-1997-01-21.md): Cessna 195A · S/N 7749 · Cancelled Jan 21, 1997 · Triennial form not returned · Shaffer Jan
- [N2732Z](https://openairdocs.org/deregistered/N2732Z-1983-08-29.md): Schweizer SGU 2-22E · S/N 191 · Cancelled Aug 29, 1983 · Nemes Mihaly
- [N1899B](https://openairdocs.org/deregistered/N1899B-1975-05-07.md): Luscombe 8F · S/N 6326 · Cancelled May 7, 1975 · Built 1948 · Keblenzer Fred
- [N99603](https://openairdocs.org/deregistered/N99603-1974-05-10.md): Ercoupe 415-C · S/N 2226 · Cancelled May 10, 1974 · Built 1946 · Uhinck Richard W
- [N8722K](https://openairdocs.org/deregistered/N8722K-1971-01-04.md): Stinson 108 · S/N 108-1722 · Cancelled Jan 4, 1971 · Frame James R
- [N816C](https://openairdocs.org/deregistered/N816C-1967-12-08.md): Melba II · S/N 1 · Cancelled Dec 8, 1967 · Ben Hussan
- [N73098](https://openairdocs.org/deregistered/N73098-1965-05-22.md): Cessna 120 · S/N 10318 · Cancelled May 22, 1965 · Schlueter Donald C
- [N50053](https://openairdocs.org/deregistered/N50053-1955-11-28.md): Boeing A75N1 · S/N 75-986 · Cancelled Nov 28, 1955 · Earle Ray Robinson
- [N85934](https://openairdocs.org/deregistered/N85934-1949-06-17.md): Aeronca 11AC · S/N 11AC-357 · Cancelled Jun 17, 1949 · James Robert William
- [N622](https://openairdocs.org/deregistered/N622-1940-07-01.md): Arrow Aircraft & Motors ARROW SPORT · S/N 316 · Cancelled Jul 1, 1940 · Fay Robert Gillmore
- [N1685](https://openairdocs.org/deregistered/N1685-1938-08-21.md): Waco 10 · S/N 912 · Cancelled Aug 21, 1938 · Built 1927 · Fay Robert G
- [N4W](https://openairdocs.org/deregistered/N4W-1930-12-26.md): Griffin James Howard GRIFFIN SPECIAL · S/N 4997 · Cancelled Dec 26, 1930 · Griffin W F

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

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