# Cancelled registrations: New Berlin, IL

A list on [New Berlin, IL](https://openairdocs.org/faa-place/IL/New%20Berlin.md).

Cancelled aircraft registrations in New Berlin, IL.

- [N9050M](https://openairdocs.org/deregistered/N9050M-2018-01-29.md): Taylorcraft DCO-65 · S/N L-5483 · Cancelled Jan 29, 2018 · Registration expired, pending cancellation · Smith Allen C
- [N70691](https://openairdocs.org/deregistered/N70691-2018-01-23.md): Piper J3C-65 · S/N 17708 · Cancelled Jan 23, 2018 · Registration expired, pending cancellation · Built 1946 · Smith Allen C
- [N3305V](https://openairdocs.org/deregistered/N3305V-2017-06-21.md): Cessna 150M · S/N 15076456 · Cancelled Jun 21, 2017 · Registration expired, pending cancellation · Built 1974 · Smith Allen C
- [N2844N](https://openairdocs.org/deregistered/N2844N-2017-03-21.md): Cessna 120 · S/N 13105 · Cancelled Mar 21, 2017 · Registration expired, pending cancellation · Built 1947 · Smith Allen C
- [N44143](https://openairdocs.org/deregistered/N44143-2017-03-06.md): Cessna 120 · S/N 9470 · Cancelled Mar 6, 2017 · Registration expired, pending cancellation · Smith Allen C
- [N5374H](https://openairdocs.org/deregistered/N5374H-2016-09-02.md): Piper PA-16 · S/N 16-181 · Cancelled Sep 2, 2016 · Third renewal notice · Built 1949 · Smith Allen C
- [N9228U](https://openairdocs.org/deregistered/N9228U-2015-05-19.md): Cessna 150M · S/N 15078178 · Cancelled May 19, 2015 · Registration expired, pending cancellation · Built 1976 · Smith Allen C
- [N8107T](https://openairdocs.org/deregistered/N8107T-2015-05-15.md): Champion 7KCAB · S/N 85 · Cancelled May 15, 2015 · Registration expired, pending cancellation · Smith Allen C
- [N6291S](https://openairdocs.org/deregistered/N6291S-2014-11-12.md): Cessna 150G · S/N 15067091 · Cancelled Nov 12, 2014 · Registration expired, pending cancellation · Built 1967 · Smith Allen C
- [N6313M](https://openairdocs.org/deregistered/N6313M-2014-11-12.md): Stinson 108-3 · S/N 108-4313 · Cancelled Nov 12, 2014 · Registration expired, pending cancellation · Built 1948 · Smith Allen C
- [N5396M](https://openairdocs.org/deregistered/N5396M-2014-10-27.md): Cessna 152 · S/N 15284579 · Cancelled Oct 27, 2014 · Registration expired, pending cancellation · Built 1980 · Smith Allen C
- [N5511E](https://openairdocs.org/deregistered/N5511E-2014-10-27.md): Cessna 150 · S/N 17011 · Cancelled Oct 27, 2014 · Registration expired, pending cancellation · Built 1958 · Smith Allen C
- [N8015D](https://openairdocs.org/deregistered/N8015D-2013-10-29.md): Piper PA-22-150 · S/N 22-5540 · Cancelled Oct 29, 2013 · Registration expired, pending cancellation · Built 1957 · Smith Allen C
- [N9491E](https://openairdocs.org/deregistered/N9491E-2013-09-17.md): Aeronca 11AC · S/N 11AC-1133 · Cancelled Sep 17, 2013 · Registration expired, pending cancellation · Built 1946 · Smith Allen C
- [N301TB](https://openairdocs.org/deregistered/N301TB-2013-08-15.md): Blome Terry L JENNY · S/N 505 · Cancelled Aug 15, 2013 · Sale reported, canceled · Built 2003
- [N43782](https://openairdocs.org/deregistered/N43782-2013-06-18.md): Taylorcraft BC12-D · S/N 7441 · Cancelled Jun 18, 2013 · Registration expired, pending cancellation · Built 1946 · Smith Allen C
- [N9543D](https://openairdocs.org/deregistered/N9543D-2013-03-25.md): Piper PA-22-160 · S/N 22-6460 · Cancelled Mar 25, 2013 · Sale reported, canceled
- [N53LC](https://openairdocs.org/deregistered/N53LC-2013-03-07.md): Aeronca 11AC · S/N 11AC-191 · Cancelled Mar 7, 2013 · Sale reported, canceled · Built 1946
- [N5893C](https://openairdocs.org/deregistered/N5893C-2009-01-26.md): Bennenga Kenneth Gene PIETENPOL · S/N PIETPOL 4550 · Cancelled Jan 26, 2009 · Triennial form not returned · Beenenga Kenneth G

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

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