# Cancelled registrations: Midlothian, TX

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

Cancelled aircraft registrations in Midlothian, TX.

- [N54WP](https://openairdocs.org/deregistered/N54WP-2022-01-08.md): Janicki Steven B RV4 · S/N 2197 · Cancelled Jan 8, 2022 · Registration expired, pending cancellation · Built 2009 · Phillips Eric T
- [N4059R](https://openairdocs.org/deregistered/N4059R-2021-09-04.md): Piper PA-32-300 · S/N 32-40364 · Cancelled Sep 4, 2021 · Registration expired, pending cancellation · Built 1967 · Lauterbach Dennis R
- [N4687P](https://openairdocs.org/deregistered/N4687P-2021-09-04.md): Piper PA-23-250 · S/N 27-216 · Cancelled Sep 4, 2021 · Registration expired, pending cancellation · Built 1960 · Lauterbach Dennis R
- [N2168A](https://openairdocs.org/deregistered/N2168A-2019-09-04.md): Piper PA-32RT-300T · S/N 32R-7987010 · Cancelled Sep 4, 2019 · Third renewal notice · Built 1978 · Ross Charles D
- [N921ST](https://openairdocs.org/deregistered/N921ST-2019-01-22.md): Aero Commander 690A · S/N 11200 · Cancelled Jan 22, 2019 · Exported to Canada · Built 1974 · Rodney William Debaun Family Lp
- [N145BW](https://openairdocs.org/deregistered/N145BW-2018-12-15.md): Ward William F S2A · S/N S2A-1W · Cancelled Dec 15, 2018 · Registration expired, pending cancellation · Built 1994 · Chastain Gregory T
- [N193Q](https://openairdocs.org/deregistered/N193Q-2018-06-08.md): Beech S35 · S/N D-7708 · Cancelled Jun 8, 2018 · Registration expired, pending cancellation · Built 1964 · Bennett Robert D
- [N714HM](https://openairdocs.org/deregistered/N714HM-2018-06-05.md): Cessna 150M · S/N 15079189 · Cancelled Jun 5, 2018 · Registration expired, pending cancellation · Built 1977 · Cole Randall
- [N4VX](https://openairdocs.org/deregistered/N4VX-2018-03-14.md): Sibley Alfred E GLASAIR · S/N 301 · Cancelled Mar 14, 2018 · Registration expired, pending cancellation · Built 1985 · Hall Mark
- [N65857](https://openairdocs.org/deregistered/N65857-2018-01-25.md): Cessna 172P · S/N 17275907 · Cancelled Jan 25, 2018 · Registration expired, pending cancellation · Built 1983 · Aeroplace Services Inc
- [N2559R](https://openairdocs.org/deregistered/N2559R-2017-02-28.md): Piper PA-28-180 · S/N 28-5648 · Cancelled Feb 28, 2017 · Registration expired, pending cancellation · Built 1969 · Bowling James L
- [N6667Z](https://openairdocs.org/deregistered/N6667Z-2014-04-17.md): Piper PA-25-235 · S/N 25-2268 · Cancelled Apr 17, 2014 · Third renewal notice · Built 1963 · Texas Soaring Association Inc
- [N85BH](https://openairdocs.org/deregistered/N85BH-2014-02-07.md): Bell 206B · S/N 3792 · Cancelled Feb 7, 2014 · Built 1984 · Lauterbach Dennis
- [N41HE](https://openairdocs.org/deregistered/N41HE-2013-09-27.md): Aero Commander 680FL · S/N 1396-53 · Cancelled Sep 27, 2013 · Registration expired, pending cancellation · Built 1964 · Millet Barron P
- [N3904N](https://openairdocs.org/deregistered/N3904N-2013-09-13.md): Bell Helicopter Textron 206L-1 · S/N 45605 · Cancelled Sep 13, 2013 · Registration expired, pending cancellation · Lauterbach Dennis R DBA
- [N965SL](https://openairdocs.org/deregistered/N965SL-2013-08-08.md): Ladner Stanley PIETENPOL AIRCAMPER · S/N AS965 · Cancelled Aug 8, 2013 · Sale reported, canceled
- [N3869X](https://openairdocs.org/deregistered/N3869X-2013-07-09.md): Aero Commander 100 · S/N 166 · Cancelled Jul 9, 2013 · Registration expired, pending cancellation · Built 1967 · Clemmons Jerita
- [N9783U](https://openairdocs.org/deregistered/N9783U-2013-05-30.md): Grumman American Avn. AA-1C · S/N AA1C0121 · Cancelled May 30, 2013 · Registration expired, pending cancellation · Built 1977 · Aeroplace Services Inc
- [N8164R](https://openairdocs.org/deregistered/N8164R-2013-05-13.md): Beech 95-B55 (T42A) · S/N TC-1746 · Cancelled May 13, 2013 · Registration expired, pending cancellation · Built 1974 · Cothron Les
- [N761DK](https://openairdocs.org/deregistered/N761DK-2013-05-08.md): Cessna T210M · S/N 21062172 · Cancelled May 8, 2013 · Registration expired, pending cancellation · Built 1977 · Martinez Juan M DBA
- [N4091J](https://openairdocs.org/deregistered/N4091J-2013-04-17.md): Cessna 150G · S/N 15065391 · Cancelled Apr 17, 2013 · Registration expired, pending cancellation · Built 1966 · Clemmons Jerita
- [N4487J](https://openairdocs.org/deregistered/N4487J-2013-04-17.md): Piper PA-28-140 · S/N 28-22905 · Cancelled Apr 17, 2013 · Registration expired, pending cancellation · Built 1967 · Aeroplace Services Inc
- [N4506P](https://openairdocs.org/deregistered/N4506P-2012-11-09.md): Piper PA-23-250 · S/N 27-9 · Cancelled Nov 9, 2012 · Sale reported, canceled · Built 1960
- [N20220](https://openairdocs.org/deregistered/N20220-2012-08-22.md): Beech F33A · S/N CE-800 · Cancelled Aug 22, 2012 · Registration expired, pending cancellation · Built 1978 · Aeroplace Services Inc
- [N6389A](https://openairdocs.org/deregistered/N6389A-2012-06-04.md): Piper PA-38-112 · S/N 38-78A0407 · Cancelled Jun 4, 2012 · Exported to El Salvador · Built 1978 · Dillon Michael C
- [N510SP](https://openairdocs.org/deregistered/N510SP-2010-02-24.md): Peroyea John L II EXEC 162F · S/N 6172 · Cancelled Feb 24, 2010 · Exported to Canada · Peroyea John L II
- [N30WK](https://openairdocs.org/deregistered/N30WK-2009-11-16.md): Schleicher ASW-20B · S/N 20641 · Cancelled Nov 16, 2009 · Triennial form not returned · Built 1983 · Rider James
- [N727LV](https://openairdocs.org/deregistered/N727LV-2009-02-23.md): De Dominicis Hector RV-6 · S/N 001 · Cancelled Feb 23, 2009 · Exported to Netherlands · Built 1998 · Rv Training LLC
- [N17TS](https://openairdocs.org/deregistered/N17TS-2007-07-30.md): Pdps Pzl-Bielsko SZD-50-3 · S/N B-2109 · Cancelled Jul 30, 2007 · Exported to Australia · Built 1997 · Texas Soaring Association Inc
- [N911TC](https://openairdocs.org/deregistered/N911TC-2000-10-20.md): Mcdonnell Douglas Helicopter 600N · S/N RN020 · Cancelled Oct 20, 2000 · Exported to Mexico · Cherokee Aviation
- [N123SV](https://openairdocs.org/deregistered/N123SV-2000-06-26.md): Nord STAMPE SV4C · S/N 294 · Cancelled Jun 26, 2000 · Triennial form not returned · Peterson Don Collins III
- [N520DD](https://openairdocs.org/deregistered/N520DD-1997-06-02.md): Mcdonnell Douglas Helicopter 500N · S/N LN030 · Cancelled Jun 2, 1997 · Exported to Venezuela · Cherokee Aviation
- [N270LP](https://openairdocs.org/deregistered/N270LP-1997-03-20.md): Cessna 340A · S/N 340A0917 · Cancelled Mar 20, 1997 · Exported to Philippines · Aeroplace Services Inc
- [N4586W](https://openairdocs.org/deregistered/N4586W-1996-09-17.md): Rockwell International 112TC · S/N 13076 · Cancelled Sep 17, 1996 · Triennial form not returned · Carstens Fred D Jr
- [N17959](https://openairdocs.org/deregistered/N17959-1980-07-26.md): Schweizer SGS 2-33AK · S/N 259 · Cancelled Jul 26, 1980 · Built 1972 · Texas Soaring Assoc
- [N731DX](https://openairdocs.org/deregistered/N731DX-1980-06-10.md): Cessna A188B · S/N 18802825T · Cancelled Jun 10, 1980 · Exported to Canada · Red Bird Aircraft Sales Inc
- [N11819](https://openairdocs.org/deregistered/N11819-1977-08-17.md): Cessna 150L · S/N 15075647 · Cancelled Aug 17, 1977 · Exported to Canada · Lauterbach Dennis R
- [N9024B](https://openairdocs.org/deregistered/N9024B-1974-06-17.md): Aeronca 7FC · S/N 7FC-116 · Cancelled Jun 17, 1974 · Exported to Canada · Curb Marvin N

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

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