# Cancelled registrations: Lakewood, OH

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

Cancelled aircraft registrations in Lakewood, OH.

- [N25182](https://openairdocs.org/deregistered/N25182-2019-01-09.md): Fairchild 24W-9 · S/N W40103 · Cancelled Jan 9, 2019 · Revoked, canceled · Built 1940 · Townsend Charles S
- [N8795M](https://openairdocs.org/deregistered/N8795M-2014-11-20.md): Beech A23 · S/N M-578 · Cancelled Nov 20, 2014 · Registration expired, pending cancellation · Built 1964 · Danaceau Hubert M
- [N3540S](https://openairdocs.org/deregistered/N3540S-2013-07-30.md): Cessna 172E · S/N 17250740 · Cancelled Jul 30, 2013 · Registration expired, pending cancellation · Built 1963 · Garber Kenneth E
- [N34508](https://openairdocs.org/deregistered/N34508-2010-02-10.md): Cessna 177B · S/N 17701847 · Cancelled Feb 10, 2010 · Triennial form not returned · Built 1972 · Dick Arthur P
- [N76N](https://openairdocs.org/deregistered/N76N-2000-10-24.md): Cessna 210L · S/N 210-60293 · Cancelled Oct 24, 2000 · Triennial form not returned · Benkelman William G
- [N28AW](https://openairdocs.org/deregistered/N28AW-1994-08-23.md): Piper PA-28-161 · S/N 288016133 · Cancelled Aug 23, 1994 · Triennial form not returned · White Allen D
- [N64953](https://openairdocs.org/deregistered/N64953-1984-10-15.md): Cessna 152 · S/N 15281497 · Cancelled Oct 15, 1984 · Exported to Australia · Marjorie L Eynon
- [N2491H](https://openairdocs.org/deregistered/N2491H-1975-06-03.md): Engineering & Research 415-C · S/N 3116 · Cancelled Jun 3, 1975 · Snider William E Etal
- [N634H](https://openairdocs.org/deregistered/N634H-1973-06-25.md): Beech D-50 · S/N DH-30 · Cancelled Jun 25, 1973 · Gavin Frank J Jr
- [N25182](https://openairdocs.org/deregistered/N25182-1971-01-05.md): Fairchild 24W-40 · S/N W-40-103 · Cancelled Jan 5, 1971 · Built 1940 · Townsend Charles S
- [N7071N](https://openairdocs.org/deregistered/N7071N-1970-07-27.md): Beech D55 · S/N TE-495 · Cancelled Jul 27, 1970 · Exported to Philippines · Ranney Peter K
- [N9833H](https://openairdocs.org/deregistered/N9833H-1970-06-17.md): Howard DGA-15P · S/N 29480 · Cancelled Jun 17, 1970 · Built 1943 · Gilbert Jack F
- [N9259H](https://openairdocs.org/deregistered/N9259H-1965-05-26.md): Fairchild M-62A-3 · S/N FV-461 · Cancelled May 26, 1965 · Built 1943 · Baratko Mathew D
- [N47605](https://openairdocs.org/deregistered/N47605-1960-12-29.md): Aeronca 0-58B · S/N 7812 · Cancelled Dec 29, 1960 · Exported to Canada · Built 1944 · Stonis Edward
- [N46369](https://openairdocs.org/deregistered/N46369-1960-05-25.md): Fairchild M-62A · S/N 5283AE · Cancelled May 25, 1960 · Built 1945 · Baratko Methew D
- [N2153N](https://openairdocs.org/deregistered/N2153N-1958-06-23.md): Cessna 140 · S/N 12389 · Cancelled Jun 23, 1958 · Exported to Guadeloupe · Driehorst William M
- [N97941](https://openairdocs.org/deregistered/N97941-1956-03-21.md): Stinson 108-1 · S/N 108-941 · Cancelled Mar 21, 1956 · Zettelmeyer Charles E
- [N69743](https://openairdocs.org/deregistered/N69743-1956-03-05.md): Fairchild M-62A-3 · S/N T42-4263 · Cancelled Mar 5, 1956 · Miller II Clifford B
- [N61435](https://openairdocs.org/deregistered/N61435-1956-02-15.md): Consolidated Vultee BT-13B (SNV-2) · S/N 79-1055 · Cancelled Feb 15, 1956 · Terlaak Daniel J
- [N69904](https://openairdocs.org/deregistered/N69904-1955-10-25.md): Fairchild M-62A-4 · S/N T42-4108 · Cancelled Oct 25, 1955 · Logan A Becker
- [N5593N](https://openairdocs.org/deregistered/N5593N-1955-03-30.md): Cessna AT-17 · S/N 1729 · Cancelled Mar 30, 1955 · Scott R W
- [N85427](https://openairdocs.org/deregistered/N85427-1949-06-16.md): Aeronca 7AC · S/N 7AC-4167 · Cancelled Jun 16, 1949 · R C Browne Inc
- [N19460](https://openairdocs.org/deregistered/N19460-1947-09-29.md): Cessna C-38 · S/N 404 · Cancelled Sep 29, 1947 · Bosworth W G
- [N437M](https://openairdocs.org/deregistered/N437M-1941-05-03.md): Stinson JR. R · S/N 8517 · Cancelled May 3, 1941 · Built 1932 · Carpenter James
- [N11141](https://openairdocs.org/deregistered/N11141-1931-09-10.md): Lakewood Glider Club PRIMARY GLIDER · S/N LGC-I · Cancelled Sep 10, 1931 · Built 1930 · Lakewood Glider Club
- [N1397](https://openairdocs.org/deregistered/N1397-1930-04-30.md): Standard J-1 · S/N I-518 · Cancelled Apr 30, 1930 · Campbell Glen H

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

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