# Cancelled registrations: Berwyn, IL

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

Cancelled aircraft registrations in Berwyn, IL.

- [N85195](https://openairdocs.org/deregistered/N85195-2019-10-02.md): Aeronca 7AC · S/N 7AC-3928 · Cancelled Oct 2, 2019 · Revoked, canceled · Built 1946 · Williams David C
- [N94382](https://openairdocs.org/deregistered/N94382-2018-03-23.md): Engineering & Research 415-C · S/N 1605 · Cancelled Mar 23, 2018 · Revoked, canceled · Built 1946 · Gaba James J
- [N27HA](https://openairdocs.org/deregistered/N27HA-2013-08-08.md): Smith AEROSTAR 601 · S/N 61-0147-078 · Cancelled Aug 8, 2013 · Registration expired, pending cancellation · Built 1973 · Richard Nemec Aircraft Inc
- [N4563L](https://openairdocs.org/deregistered/N4563L-2012-11-14.md): Cessna 421 · S/N 421-0163 · Cancelled Nov 14, 2012 · Sale reported, canceled · Built 1968
- [N103BZ](https://openairdocs.org/deregistered/N103BZ-2009-06-25.md): Hughes 269B · S/N 36-0246 · Cancelled Jun 25, 2009 · Registration revoked · Built 1966 · Nemec Richard
- [N56352](https://openairdocs.org/deregistered/N56352-2002-07-11.md): Mooney M20K · S/N 25-0743 · Cancelled Jul 11, 2002 · Triennial form not returned · Lyssenko Taras C
- [N878BB](https://openairdocs.org/deregistered/N878BB-1976-05-14.md): Piper PA-31 · S/N 31-170 · Cancelled May 14, 1976 · Exported to Canada · Built 1968 · Nemec Richard J Bea Nemec Aircraft
- [N90201](https://openairdocs.org/deregistered/N90201-1972-11-22.md): Johnson ROCKET 185 · S/N #8 · Cancelled Nov 22, 1972 · Brown George
- [N3384W](https://openairdocs.org/deregistered/N3384W-1972-03-16.md): Piper PA-32-260 · S/N 32-240 · Cancelled Mar 16, 1972 · Viren Louis
- [N9110W](https://openairdocs.org/deregistered/N9110W-1970-06-24.md): Piper PA-28-235 · S/N 28-10720 · Cancelled Jun 24, 1970 · Delco Aviation Inc
- [N3808N](https://openairdocs.org/deregistered/N3808N-1970-06-22.md): Beech 35 · S/N D-1036 · Cancelled Jun 22, 1970 · Pinta Otto R
- [N2045D](https://openairdocs.org/deregistered/N2045D-1967-11-09.md): Beech D18S · S/N A-933 · Cancelled Nov 9, 1967 · Mid Continent Finance Co
- [N97485](https://openairdocs.org/deregistered/N97485-1965-05-22.md): Universal Stinson 108 · S/N 108-485 · Cancelled May 22, 1965 · Anderson George
- [N54358](https://openairdocs.org/deregistered/N54358-1965-05-20.md): Fairchild M-62A · S/N T421421 · Cancelled May 20, 1965 · Roth Alfred R
- [N4005P](https://openairdocs.org/deregistered/N4005P-1961-07-27.md): Piper PA-23-160 · S/N 23-1480 · Cancelled Jul 27, 1961 · Exported to Canada · Built 1958 · King Ray H
- [N9881H](https://openairdocs.org/deregistered/N9881H-1960-04-25.md): Fairchild PT-26 · S/N T43-4462 · Cancelled Apr 25, 1960 · Johnson Ronald W
- [N29548](https://openairdocs.org/deregistered/N29548-1954-09-13.md): Taylorcraft BL12-65 · S/N 2501 · Cancelled Sep 13, 1954 · Built 1940 · Markowski Joseph
- [N308](https://openairdocs.org/deregistered/N308-1933-02-14.md): Curtiss JN4D · S/N 3046 · Cancelled Feb 14, 1933 · Stella Charles
- [N6864](https://openairdocs.org/deregistered/N6864-1932-09-13.md): Waco GXE · S/N 1737 · Cancelled Sep 13, 1932 · E V Stivers
- [N4144](https://openairdocs.org/deregistered/N4144-1931-09-24.md): Eaglerock LONG WING EAGLEROCK · S/N 424 · Cancelled Sep 24, 1931 · Built 1928 · Heitz Joseph L/Hackworth Clyde

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

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