# Cancelled registrations: Lorain, OH

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

Cancelled aircraft registrations in Lorain, OH.

- [N780TR](https://openairdocs.org/deregistered/N780TR-2020-07-10.md): 3D Robotics Y-6 · S/N LCCCMHL3DRY620130908 · Cancelled Jul 10, 2020 · Registration expired, pending cancellation · Lorain County Community College
- [N78AR](https://openairdocs.org/deregistered/N78AR-2019-10-05.md): Sukel Ronald J VARIEZE · S/N 265 · Cancelled Oct 5, 2019 · Registration expired, pending cancellation · Built 1979 · Sukel James D
- [N6723H](https://openairdocs.org/deregistered/N6723H-2019-08-08.md): Piper J3C-65 · S/N 19938 · Cancelled Aug 8, 2019 · Revoked, canceled · Built 1946 · Ferner Floyd W
- [N963Z](https://openairdocs.org/deregistered/N963Z-2018-04-10.md): Allison C J COUGAR MODIFIED · S/N CJ1 · Cancelled Apr 10, 2018 · Revoked, canceled · Built 1963 · Allison Carroll James
- [N4679J](https://openairdocs.org/deregistered/N4679J-2017-05-23.md): Piper PA-28R-180 · S/N 28R-30579 · Cancelled May 23, 2017 · Registration expired, pending cancellation · Built 1968 · Muska Robert M
- [N82790](https://openairdocs.org/deregistered/N82790-2017-02-04.md): Aeronca 7AC · S/N 7AC-1437 · Cancelled Feb 4, 2017 · Revoked, canceled · Built 1946 · Long Wm H
- [N6942G](https://openairdocs.org/deregistered/N6942G-2013-05-02.md): Cessna 150L · S/N 15072442 · Cancelled May 2, 2013 · Registration expired, pending cancellation · Built 1970 · Bohan Robert G
- [N8384N](https://openairdocs.org/deregistered/N8384N-1991-08-14.md): Beech E33 · S/N CD1165 · Cancelled Aug 14, 1991 · Exported to Germany · Griffith Thomas E
- [N8607R](https://openairdocs.org/deregistered/N8607R-1974-05-29.md): Schweizer SGS 1-23H · S/N 56 · Cancelled May 29, 1974 · Exported to Canada · Schmitkons David L
- [N31949](https://openairdocs.org/deregistered/N31949-1971-08-18.md): Aeronca 65-CA · S/N C12261 · Cancelled Aug 18, 1971 · Revoked, pending cancellation · Built 1941 · Long William H
- [N1495B](https://openairdocs.org/deregistered/N1495B-1970-09-18.md): Luscombe 8F · S/N 6122 · Cancelled Sep 18, 1970 · Powers Michael John
- [N38596](https://openairdocs.org/deregistered/N38596-1970-09-04.md): Piper J5A · S/N 5-1015 · Cancelled Sep 4, 1970 · William H Long
- [N8765H](https://openairdocs.org/deregistered/N8765H-1970-06-30.md): North American NAVION · S/N NAV-4-765 · Cancelled Jun 30, 1970 · Nielson Carl G
- [N22878](https://openairdocs.org/deregistered/N22878-1970-06-29.md): Cessna 150H · S/N 15068583 · Cancelled Jun 29, 1970 · James Bodnar
- [N9989Y](https://openairdocs.org/deregistered/N9989Y-1968-06-05.md): Champion 7FC · S/N 468 · Cancelled Jun 5, 1968 · Built 1964 · Wright Hurshell L
- [N40893](https://openairdocs.org/deregistered/N40893-1965-11-26.md): Piper J5A · S/N 5-1202 · Cancelled Nov 26, 1965 · Built 1941 · John Lonas
- [N4270K](https://openairdocs.org/deregistered/N4270K-1965-10-22.md): Ryan NAVION · S/N NAV-4-1270 · Cancelled Oct 22, 1965 · Lucas Frank J
- [N2139K](https://openairdocs.org/deregistered/N2139K-1956-02-14.md): Luscombe 8A · S/N 4866 · Cancelled Feb 14, 1956 · Buckeye Airways Incorporated
- [N70079](https://openairdocs.org/deregistered/N70079-1955-10-25.md): Fairchild M-62C · S/N 3963AE · Cancelled Oct 25, 1955 · Buckeye Airways Inc
- [N23480](https://openairdocs.org/deregistered/N23480-1955-03-23.md): Piper J3F-50 · S/N 3208 · Cancelled Mar 23, 1955 · Built 1939 · Bozich Louis A
- [N24586](https://openairdocs.org/deregistered/N24586-1951-07-31.md): Piper J3F-50 · S/N 3278 · Cancelled Jul 31, 1951 · William G Tudich
- [N23473](https://openairdocs.org/deregistered/N23473-1948-09-24.md): Piper J3F-50 · S/N 3189 · Cancelled Sep 24, 1948 · Long William H
- [N5467](https://openairdocs.org/deregistered/N5467-1932-06-15.md): Curtiss Airplane & Motor CURTISS M F BOAT · S/N 5538 · Cancelled Jun 15, 1932 · Built 1919 · Long William 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 = 'LORAIN'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

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