# Cancelled registrations: Deerfield, IL

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

Cancelled aircraft registrations in Deerfield, IL.

- [N129HP](https://openairdocs.org/deregistered/N129HP-2017-07-14.md): Lockheed P2V-7 · S/N 147950 · Cancelled Jul 14, 2017 · Registration expired, pending cancellation · Pride Capital Group LLC DBA
- [N67108](https://openairdocs.org/deregistered/N67108-2017-07-14.md): Hiller H-23D · S/N 1135 · Cancelled Jul 14, 2017 · Registration expired, pending cancellation · Built 1959 · Pride Capital Group LLC DBA
- [N67106](https://openairdocs.org/deregistered/N67106-2017-07-12.md): Hiller OH-23G · S/N 1694 · Cancelled Jul 12, 2017 · Registration expired, pending cancellation · Built 1964 · Pride Capital Group LLC DBA
- [N28909](https://openairdocs.org/deregistered/N28909-2017-07-07.md): Hiller UH-12E · S/N 1356 · Cancelled Jul 7, 2017 · Registration expired, pending cancellation · Built 1972 · Pride Capital Group LLC DBA
- [N7060Y](https://openairdocs.org/deregistered/N7060Y-2017-07-07.md): Lockheed SP-2H · S/N 145905 · Cancelled Jul 7, 2017 · Registration expired, pending cancellation · Pride Captial Group LLC DBA
- [N105CY](https://openairdocs.org/deregistered/N105CY-2017-03-24.md): AS+ AC 4 · S/N 15 · Cancelled Mar 24, 2017 · Registration expired, pending cancellation · Built 1995 · Ogren Del E
- [N1899F](https://openairdocs.org/deregistered/N1899F-2014-09-10.md): Cessna 210F · S/N 21058799 · Cancelled Sep 10, 2014 · Registration expired, pending cancellation · Built 1966 · Gampl Franz X
- [N138HP](https://openairdocs.org/deregistered/N138HP-2013-09-25.md): Lockheed P2V-7 · S/N 148338 · Cancelled Sep 25, 2013 · Registration expired, pending cancellation · Pride Capital Group LLC DBA
- [N2218A](https://openairdocs.org/deregistered/N2218A-2013-09-24.md): Lockheed P2V-7 · S/N 148355 · Cancelled Sep 24, 2013 · Registration expired, pending cancellation · Pride Capital Group LLC DBA
- [N19071](https://openairdocs.org/deregistered/N19071-2013-06-18.md): Taylorcraft A · S/N 177 · Cancelled Jun 18, 2013 · Registration expired, pending cancellation · Built 1937 · Ogren Del E
- [N8093](https://openairdocs.org/deregistered/N8093-2013-05-13.md): Fairchild C-119G · S/N 10776 · Cancelled May 13, 2013 · Registration expired, pending cancellation · Built 1953 · Pride Capital Group LLC DBA
- [N8908F](https://openairdocs.org/deregistered/N8908F-2013-01-31.md): Lockheed P-2H · S/N 140441 · Cancelled Jan 31, 2013 · Registration expired, pending cancellation · Pride Capital Group LLC DBA
- [N29620](https://openairdocs.org/deregistered/N29620-2012-01-30.md): Taylorcraft BL-65 · S/N 2462 · Cancelled Jan 30, 2012 · Sale reported, pending cancellation · Built 1940
- [N8BX](https://openairdocs.org/deregistered/N8BX-2009-06-08.md): Dassault-Breguet MYSTERE FALCON 900 · S/N 111 · Cancelled Jun 8, 2009 · Exported to Tunisia · Baxter Healthcare Corp
- [N99704](https://openairdocs.org/deregistered/N99704-2008-04-29.md): Cessna 172P · S/N 17276497 · Cancelled Apr 29, 2008 · Exported to Poland · Built 1985
- [N152BP](https://openairdocs.org/deregistered/N152BP-2007-09-20.md): Cessna 152 · S/N 15279426 · Cancelled Sep 20, 2007 · Exported to Poland · Built 1977 · Edgedtech Inc
- [N25944](https://openairdocs.org/deregistered/N25944-2007-09-20.md): Cessna 152 · S/N 15280872 · Cancelled Sep 20, 2007 · Exported to Poland · Built 1977 · Edgedtech Inc
- [N54197](https://openairdocs.org/deregistered/N54197-1999-02-17.md): Messerschmitt BO105CBS · S/N S-805 · Cancelled Feb 17, 1999 · Triennial form not returned · Deutsche Financial Services Holding Corporation
- [N9199X](https://openairdocs.org/deregistered/N9199X-1999-01-28.md): Mcdonnell Douglas Helicopter MD 900 · S/N 900-00037 · Cancelled Jan 28, 1999 · Exported to Switzerland · Aero Marketing Group Ltd
- [N7161J](https://openairdocs.org/deregistered/N7161J-1999-01-07.md): Messerschmitt-Boelkow-Blohm BO-105S · S/N S834 · Cancelled Jan 7, 1999 · Triennial form not returned · Built 1990 · Deutsche Financial Services Holding Corporation
- [N117HH](https://openairdocs.org/deregistered/N117HH-1998-12-28.md): Messerschmitt BK 117 · S/N 7015 · Cancelled Dec 28, 1998 · Triennial form not returned · Deutsche Financial Services Corporation
- [N8520Q](https://openairdocs.org/deregistered/N8520Q-1997-02-11.md): Cessna U206F · S/N U20603376 · Cancelled Feb 11, 1997 · Exported to Costa Rica · Higgins Associates Inc
- [N233RP](https://openairdocs.org/deregistered/N233RP-1995-10-18.md): Dornier DO.228-200 · S/N 8040 · Cancelled Oct 18, 1995 · Exported to Nigeria · Deutsche Financial Services Holding Corporation
- [N245RP](https://openairdocs.org/deregistered/N245RP-1995-08-01.md): Dornier DORNIER 228-202 · S/N 8125 · Cancelled Aug 1, 1995 · Exported to Nigeria · Deutsche Credit Corp
- [N228RP](https://openairdocs.org/deregistered/N228RP-1995-07-31.md): Dornier DORNIER 228-202 · S/N 8025 · Cancelled Jul 31, 1995 · Exported to Nigeria · Deutsche Credit Corp
- [N232RP](https://openairdocs.org/deregistered/N232RP-1995-07-31.md): Dornier DORNIER 228-202 · S/N 8026 · Cancelled Jul 31, 1995 · Exported to Nigeria · Deutsche Credit Corp
- [N234RP](https://openairdocs.org/deregistered/N234RP-1995-07-31.md): Dornier DORNIER 228-202 · S/N 8041 · Cancelled Jul 31, 1995 · Exported to Nigeria · Deutsche Credit Corp
- [N235RP](https://openairdocs.org/deregistered/N235RP-1995-07-31.md): Dornier DO.228-200 · S/N 8048 · Cancelled Jul 31, 1995 · Exported to Nigeria · Deutsche Credit Corp
- [N236RP](https://openairdocs.org/deregistered/N236RP-1995-07-31.md): Dornier DO.228-200 · S/N 8049 · Cancelled Jul 31, 1995 · Exported to Nigeria · Deutsche Credit Corp
- [N128DM](https://openairdocs.org/deregistered/N128DM-1995-05-26.md): Schweizer 269C · S/N S1461 · Cancelled May 26, 1995 · Exported to Germany
- [N262MC](https://openairdocs.org/deregistered/N262MC-1995-05-19.md): Dornier DO-228-201 · S/N 8127 · Cancelled May 19, 1995 · Exported to Germany · Deutsche Credit Corporation
- [N278MC](https://openairdocs.org/deregistered/N278MC-1995-03-15.md): Dornier DORNIER 228-202 · S/N 8122 · Cancelled Mar 15, 1995 · Exported to India · Deutsche Credit Corporation
- [N911LF](https://openairdocs.org/deregistered/N911LF-1995-01-18.md): Messerschmitt-Boelkow-Blohm BO-105S · S/N S740 · Cancelled Jan 18, 1995 · Triennial form not returned · Deutsche Credit Corporation
- [N701CM](https://openairdocs.org/deregistered/N701CM-1993-11-19.md): Merrin Claude E ZENAIR STOL CH701 · S/N 71275 · Cancelled Nov 19, 1993 · Merrin Claude E
- [N246RP](https://openairdocs.org/deregistered/N246RP-1993-10-12.md): Dornier DORNIER 228-202 · S/N 8126 · Cancelled Oct 12, 1993 · Exported to Papua New Guinea · Deutsche Credit Corporation
- [N259MC](https://openairdocs.org/deregistered/N259MC-1993-06-28.md): Dornier DORNIER 228-202 · S/N 8118 · Cancelled Jun 28, 1993 · Exported to Bahamas · Deutsche Credit Corporation
- [N256MC](https://openairdocs.org/deregistered/N256MC-1993-06-21.md): Dornier DO-228-201 · S/N 8101 · Cancelled Jun 21, 1993 · Exported to Papua New Guinea · Deutsche Credit Corp
- [N275MC](https://openairdocs.org/deregistered/N275MC-1993-06-21.md): Dornier DORNIER 228-202 · S/N 8100 · Cancelled Jun 21, 1993 · Exported to Papua New Guinea · Deutsche Credit Corp
- [N258MC](https://openairdocs.org/deregistered/N258MC-1993-06-18.md): Dornier DO-228-201 · S/N 8103 · Cancelled Jun 18, 1993 · Exported to Papua New Guinea · Deutsche Credit Corp
- [N750H](https://openairdocs.org/deregistered/N750H-1993-04-15.md): Messerschmitt-Boelkow-Blohm BO-105S · S/N S644 · Cancelled Apr 15, 1993 · Triennial form not returned · Deutsche Credit Corporation
- [N86QT](https://openairdocs.org/deregistered/N86QT-1993-01-14.md): Bull Herbert S KR-2 · S/N 4725JHB · Cancelled Jan 14, 1993 · Triennial form not returned · Bull Herbert S
- [N2156H](https://openairdocs.org/deregistered/N2156H-1971-09-28.md): Ercoupe 415-C · S/N 2779 · Cancelled Sep 28, 1971 · Mcdermott Lawrence M
- [N124VW](https://openairdocs.org/deregistered/N124VW-1964-10-20.md): Beech 35-A33 · S/N CD 290 · Cancelled Oct 20, 1964 · Arthur Z Brown & Company
- [N1012Z](https://openairdocs.org/deregistered/N1012Z-1963-07-18.md): Hruby Joseph H-2 · S/N 100 · Cancelled Jul 18, 1963 · Hruby Joseph
- [N4950E](https://openairdocs.org/deregistered/N4950E-1961-05-15.md): Auger AUGER N TWIN · S/N 1000 · Cancelled May 15, 1961 · Hruby Joseph

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

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