# Earlier aircraft under this name: Warren D J

A list on [Warren D J](https://openairdocs.org/faa-owner/WARREN%20D%20J.md).

Cancelled registrations that named this owner when they ended, newest first.

- [N1884H](https://openairdocs.org/deregistered/N1884H-1985-08-08.md): Cessna 310C · S/N 35984 · Cancelled Aug 8, 1985 · Administratively canceled · Randle Donald W, San Rafael, CA
- [N1828X](https://openairdocs.org/deregistered/N1828X-1984-10-25.md): Cessna 182H · S/N 18255928 · Cancelled Oct 25, 1984 · Administratively canceled · Bogdon C F, Elko, NV
- [N18711](https://openairdocs.org/deregistered/N18711-1984-08-14.md): Boeing 707-331B · S/N 19225 · Cancelled Aug 14, 1984 · Administratively canceled · Trans World Airlines Inc, New York, NY
- [N1858T](https://openairdocs.org/deregistered/N1858T-1984-07-11.md): Piper PA-28-140 · S/N 28-7225007 · Cancelled Jul 11, 1984 · Administratively canceled · Spence William C, Kissimmee, FL
- [N18790](https://openairdocs.org/deregistered/N18790-1984-07-11.md): Beech B19 · S/N MB-851 · Cancelled Jul 11, 1984 · Administratively canceled · Air Service Inc, Greensboro, NC
- [N1890H](https://openairdocs.org/deregistered/N1890H-1984-07-11.md): Cessna 310C · S/N 35990 · Cancelled Jul 11, 1984 · Administratively canceled · Clarkes Osewez Needle, Goleta, CA
- [N1845T](https://openairdocs.org/deregistered/N1845T-1984-07-03.md): Piper PA-28-140 · S/N 28-7125278 · Cancelled Jul 3, 1984 · Administratively canceled · Cramer Robert J, Racine, WI
- [N18712](https://openairdocs.org/deregistered/N18712-1984-07-03.md): Boeing 707-331B · S/N 19226 · Cancelled Jul 3, 1984 · Administratively canceled · Air Trans Of Golden Beach Inc, Golden Beach, FL
- [N18710](https://openairdocs.org/deregistered/N18710-1984-05-05.md): Boeing 707-331B · S/N 19224 · Cancelled May 5, 1984 · Administratively canceled · Trans World Airlines Inc, New York, NY
- [N187Q](https://openairdocs.org/deregistered/N187Q-1984-04-17.md): Beech D95A · S/N TD-609 · Cancelled Apr 17, 1984 · Administratively canceled · Angus I Hines Inc, Suffolk, VA
- [N18702](https://openairdocs.org/deregistered/N18702-1984-04-10.md): Boeing 707-331B · S/N 18979 · Cancelled Apr 10, 1984 · Administratively canceled · Trans World Airlines Inc, New York, NY
- [N18707](https://openairdocs.org/deregistered/N18707-1984-03-23.md): Boeing 707-331B · S/N 18983 · Cancelled Mar 23, 1984 · Administratively canceled · Trans World Airlines Inc, New York, NY
- [N18704](https://openairdocs.org/deregistered/N18704-1984-03-07.md): Boeing 707-331B · S/N 18981 · Cancelled Mar 7, 1984 · Administratively canceled · Boeing Co, Wichita, KS
- [N18708](https://openairdocs.org/deregistered/N18708-1984-02-22.md): Boeing 707-331B · S/N 18984 · Cancelled Feb 22, 1984 · Administratively canceled · Trans World Airlines Inc, New York, NY
- [N1879X](https://openairdocs.org/deregistered/N1879X-1984-02-13.md): Cessna 182H · S/N 18255979 · Cancelled Feb 13, 1984 · Administratively canceled · Burke Dale A, Las Vegas, NV
- [N18881](https://openairdocs.org/deregistered/N18881-1984-02-13.md): Beech C23 · S/N M-1960 · Cancelled Feb 13, 1984 · Administratively canceled · Barbosa Richard J, Miami Lakes, FL
- [N1882D](https://openairdocs.org/deregistered/N1882D-1984-01-17.md): Beech C35 · S/N D-3154 · Cancelled Jan 17, 1984 · Administratively canceled · Wyche Cyril Jr, Boston, MA
- [N18706](https://openairdocs.org/deregistered/N18706-1984-01-07.md): Boeing 707-331B · S/N 18982 · Cancelled Jan 7, 1984 · Administratively canceled · Trans World Airlines Inc, New York, NY
- [N1866V](https://openairdocs.org/deregistered/N1866V-1983-11-15.md): Cessna 140 · S/N 14077 · Cancelled Nov 15, 1983 · Administratively canceled · Kinback Alan C, Woodbridge, VA
- [N18842](https://openairdocs.org/deregistered/N18842-1983-10-28.md): Aerospatiale SA341G GAZELLE · S/N 1107 · Cancelled Oct 28, 1983 · Administratively canceled · Aerospatiale Helicopter Corporation, Grand Prairie, TX
- [N18736](https://openairdocs.org/deregistered/N18736-1983-09-24.md): Cessna 150L · S/N 15074074 · Cancelled Sep 24, 1983 · Administratively canceled · Eagle Air Inc, Hagerstown, MD
- [N19088](https://openairdocs.org/deregistered/N19088-1983-08-02.md): Cessna 150L · S/N 15074159 · Cancelled Aug 2, 1983 · Administratively canceled · Costello Robert, Bloomfield, NJ
- [N18850](https://openairdocs.org/deregistered/N18850-1983-06-25.md): Stewart BD-5B · S/N 2535 · Cancelled Jun 25, 1983 · Administratively canceled · Stewart Lawrence W, Albuquerque, NM
- [N18949](https://openairdocs.org/deregistered/N18949-1983-06-25.md): Douglas DC3-G202A · S/N 2013 · Cancelled Jun 25, 1983 · Administratively canceled · Nathaniel Hawthorne College Corp, Antrim, NH
- [N1846R](https://openairdocs.org/deregistered/N1846R-1983-06-22.md): Cessna A185F · S/N 18502561 · Cancelled Jun 22, 1983 · Administratively canceled · Wishman Bros, Geraldine, MT
- [N18906](https://openairdocs.org/deregistered/N18906-1983-06-15.md): Beech C24R · S/N MC-522 · Cancelled Jun 15, 1983 · Administratively canceled · Wintell Associates, Denver, CO
- [N18958](https://openairdocs.org/deregistered/N18958-1983-05-21.md): Beech C24R · S/N MC-538 · Cancelled May 21, 1983 · Administratively canceled · Saldon Ltd, Ridgefield, CT
- [N188CB](https://openairdocs.org/deregistered/N188CB-1982-12-18.md): Beech J35 · S/N D-5611 · Cancelled Dec 18, 1982 · Administratively canceled · Boggs Franklin D DBA, Gilley, KY
- [N18616](https://openairdocs.org/deregistered/N18616-1982-12-11.md): Cessna 150L · S/N 15073990 · Cancelled Dec 11, 1982 · Administratively canceled · Mosher Inc, Mt Gilead, OH
- [N18919](https://openairdocs.org/deregistered/N18919-1982-12-09.md): Beech C24R · S/N MC-526 · Cancelled Dec 9, 1982 · Administratively canceled · Compoo Inc, Shreveport, LA
- [N1913P](https://openairdocs.org/deregistered/N1913P-1982-12-09.md): Piper PA-22 · S/N 22-2660 · Cancelled Dec 9, 1982 · Administratively canceled · Cooney John W, Victor, IA
- [N1912P](https://openairdocs.org/deregistered/N1912P-1982-11-24.md): Piper PA-22-150 · S/N 22-2659 · Cancelled Nov 24, 1982 · Administratively canceled · Lawn Daniel J, Valdez, AK
- [N1914S](https://openairdocs.org/deregistered/N1914S-1982-11-06.md): Savage-James STEEN SKYBOLT · S/N 1 · Cancelled Nov 6, 1982 · Administratively canceled · Savage James L, Atherton, CA
- [N18969](https://openairdocs.org/deregistered/N18969-1982-11-04.md): Beech C24R · S/N MC-541 · Cancelled Nov 4, 1982 · Administratively canceled · Piedmont Aviation Inc, Winston Salem, NC
- [N18727](https://openairdocs.org/deregistered/N18727-1982-10-30.md): Cessna 150L · S/N 15074065 · Cancelled Oct 30, 1982 · Administratively canceled · Otis Schmidt Enterprises Inc, Schaumburg, IL
- [N19031](https://openairdocs.org/deregistered/N19031-1982-09-16.md): Cessna 150L · S/N 15074108 · Cancelled Sep 16, 1982 · Administratively canceled · Northern Aviation Ltd, Riverhead, NY
- [N18660](https://openairdocs.org/deregistered/N18660-1982-08-12.md): Cessna 150L · S/N 15074022 · Cancelled Aug 12, 1982 · Administratively canceled · Wesley Martin R, Knob Noster, MO
- [N1887H](https://openairdocs.org/deregistered/N1887H-1982-06-19.md): Piper PA-32R-300 · S/N 32R-7780198 · Cancelled Jun 19, 1982 · Administratively canceled · Langley Richard H, Clermont, FL
- [N183F](https://openairdocs.org/deregistered/N183F-1982-06-17.md): Dassault-Breguet FALCON 20 · S/N 398 · Cancelled Jun 17, 1982 · Administratively canceled · Falcon Jet Corporation, Teterboro, NJ
- [N1895T](https://openairdocs.org/deregistered/N1895T-1982-04-17.md): Piper PA-28-140 · S/N 28-7225044 · Cancelled Apr 17, 1982 · Administratively canceled · Wilson Leonard R, Perrysville, IN
- [N18551](https://openairdocs.org/deregistered/N18551-1982-04-15.md): Cessna 150L · S/N 15073936 · Cancelled Apr 15, 1982 · Administratively canceled · East Denver Flying Service Inc, Aurora, CO
- [N18687](https://openairdocs.org/deregistered/N18687-1982-04-15.md): Cessna 150L · S/N 15074042 · Cancelled Apr 15, 1982 · Administratively canceled · Keppler Richard J, Price, UT
- [N191U](https://openairdocs.org/deregistered/N191U-1982-02-06.md): Beech D18S · S/N A-305 · Cancelled Feb 6, 1982 · Administratively canceled · B & B Enterprises Inc, Honolulu, HI
- [N1859G](https://openairdocs.org/deregistered/N1859G-1982-01-21.md): Champion 7KCAB · S/N 95 · Cancelled Jan 21, 1982 · Administratively canceled · Gibson James L, Oakland, MD
- [N1836Y](https://openairdocs.org/deregistered/N1836Y-1982-01-16.md): Cessna 172C · S/N 17249436 · Cancelled Jan 16, 1982 · Administratively canceled · Blalock & Blalock Inc, Sylvania, GA
- [N1832J](https://openairdocs.org/deregistered/N1832J-1981-10-15.md): Piper PA-28-140 · S/N 28-24265 · Cancelled Oct 15, 1981 · Administratively canceled · Smith Harold C, Akron, OH
- [N18669](https://openairdocs.org/deregistered/N18669-1981-10-15.md): Cessna 150L · S/N 15074029 · Cancelled Oct 15, 1981 · Administratively canceled · Liberty Aviation Inc, Fiarfield, NJ
- [N1912G](https://openairdocs.org/deregistered/N1912G-1981-10-15.md): Murphy 1912 BELLANCA · S/N 1 · Cancelled Oct 15, 1981 · Administratively canceled · Murphy Michael P, Oak Lawn, IL

## 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_name = 'WARREN D J' OR list_contains(d.other_registrant_names, 'WARREN D J')
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

This list as a web page: https://openairdocs.org/faa-owner/WARREN%20D%20J/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.