# Cancelled registrations: Lewisburg, PA

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

Cancelled aircraft registrations in Lewisburg, PA.

- [N755DW](https://openairdocs.org/deregistered/N755DW-2024-04-20.md): Weidner Franklin ULTRA PUP · S/N 0158 · Cancelled Apr 20, 2024 · Registration pending, canceled · Built 1997
- [N796CK](https://openairdocs.org/deregistered/N796CK-2023-04-15.md): Charles Kremer HORIZEN 1 · S/N 001 · Cancelled Apr 15, 2023 · Registration pending, canceled · Built 2013
- [N522N](https://openairdocs.org/deregistered/N522N-2022-10-01.md): Van Ausdall Ivor SPORT TRAINER · S/N 1246 · Cancelled Oct 1, 2022 · Registration expired, pending cancellation · Built 1995 · Cromley Douglas B
- [N673LC](https://openairdocs.org/deregistered/N673LC-2019-09-06.md): Parrot BEBOP 2 · S/N PS726000AB5K012970 · Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Charles Justin P
- [N4822F](https://openairdocs.org/deregistered/N4822F-2018-12-03.md): Buckeye DREAM MACHINE · S/N 4593 · Cancelled Dec 3, 2018 · Registration expired, pending cancellation · Built 2007 · Miller Joseph L
- [N3782V](https://openairdocs.org/deregistered/N3782V-2017-07-18.md): Miller Joseph L DREAM MACHINE · S/N 9664 · Cancelled Jul 18, 2017 · Registration expired, pending cancellation · Built 2007 · Miller Joseph L
- [N3532S](https://openairdocs.org/deregistered/N3532S-2017-07-14.md): Miller Joseph L TWIN · S/N 9663 · Cancelled Jul 14, 2017 · Registration expired, pending cancellation · Built 2007 · Miller Joseph L
- [N4826F](https://openairdocs.org/deregistered/N4826F-2017-07-06.md): Buckeye DREAM MACHINE · S/N 3791 · Cancelled Jul 6, 2017 · Registration expired, pending cancellation · Built 2007 · Miller Joseph L
- [N34542](https://openairdocs.org/deregistered/N34542-2016-08-15.md): Cessna 177B · S/N 17701864 · Cancelled Aug 15, 2016 · Exported to New Zealand · Built 1973 · Dagle Richard E
- [N65245](https://openairdocs.org/deregistered/N65245-2013-02-13.md): Semco Balloon T · S/N SEM121 · Cancelled Feb 13, 2013 · Sale reported, canceled · Built 1973
- [N69GL](https://openairdocs.org/deregistered/N69GL-2012-03-08.md): C Gehret/F Lesher GL BREEZY · S/N GL-1 · Cancelled Mar 8, 2012 · Exported to Canada · Built 1977 · Dagle Richard E
- [N1966V](https://openairdocs.org/deregistered/N1966V-2006-12-05.md): Galaxy Balloons GALAXY 7 · S/N GLX-1707 · Cancelled Dec 5, 2006 · Triennial form not returned · Built 1994 · Cloud 9 Enterprises Inc
- [N5344E](https://openairdocs.org/deregistered/N5344E-2001-06-21.md): Galaxy Balloons GALAXY 7 · S/N GLX-1397 · Cancelled Jun 21, 2001 · Triennial form not returned · Cloud 9 Enterprises Inc
- [N3226B](https://openairdocs.org/deregistered/N3226B-1971-02-05.md): Piper PA-22-135 · S/N 22-2054 · Cancelled Feb 5, 1971 · Lahout Air Service
- [N4562P](https://openairdocs.org/deregistered/N4562P-1971-01-04.md): Piper PA-23-250 · S/N 27-69 · Cancelled Jan 4, 1971 · Built 1960 · Lankford Philip W / Lankford Lois G
- [N53599](https://openairdocs.org/deregistered/N53599-1955-12-09.md): Fairchild PT-23 · S/N HO-389 · Cancelled Dec 9, 1955 · Built 1943 · The Alpha Flyers Club 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 = 'PA' AND d.registrant_city = 'LEWISBURG'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

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