Skip to content

Earlier aircraft under this name · 48

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

Query with 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

duckdb -csv -c "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"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N1884HCessna 310C · S/N 35984Cancelled Aug 8, 1985 · Administratively canceled · Randle Donald W, San Rafael, CA N1828XCessna 182H · S/N 18255928Cancelled Oct 25, 1984 · Administratively canceled · Bogdon C F, Elko, NV N18711Boeing 707-331B · S/N 19225Cancelled Aug 14, 1984 · Administratively canceled · Trans World Airlines Inc, New York, NY N1858TPiper PA-28-140 · S/N 28-7225007Cancelled Jul 11, 1984 · Administratively canceled · Spence William C, Kissimmee, FL N18790Beech B19 · S/N MB-851Cancelled Jul 11, 1984 · Administratively canceled · Air Service Inc, Greensboro, NC N1890HCessna 310C · S/N 35990Cancelled Jul 11, 1984 · Administratively canceled · Clarkes Osewez Needle, Goleta, CA N1845TPiper PA-28-140 · S/N 28-7125278Cancelled Jul 3, 1984 · Administratively canceled · Cramer Robert J, Racine, WI N18712Boeing 707-331B · S/N 19226Cancelled Jul 3, 1984 · Administratively canceled · Air Trans Of Golden Beach Inc, Golden Beach, FL N18710Boeing 707-331B · S/N 19224Cancelled May 5, 1984 · Administratively canceled · Trans World Airlines Inc, New York, NY N187QBeech D95A · S/N TD-609Cancelled Apr 17, 1984 · Administratively canceled · Angus I Hines Inc, Suffolk, VA N18702Boeing 707-331B · S/N 18979Cancelled Apr 10, 1984 · Administratively canceled · Trans World Airlines Inc, New York, NY N18707Boeing 707-331B · S/N 18983Cancelled Mar 23, 1984 · Administratively canceled · Trans World Airlines Inc, New York, NY N18704Boeing 707-331B · S/N 18981Cancelled Mar 7, 1984 · Administratively canceled · Boeing Co, Wichita, KS N18708Boeing 707-331B · S/N 18984Cancelled Feb 22, 1984 · Administratively canceled · Trans World Airlines Inc, New York, NY N1879XCessna 182H · S/N 18255979Cancelled Feb 13, 1984 · Administratively canceled · Burke Dale A, Las Vegas, NV N18881Beech C23 · S/N M-1960Cancelled Feb 13, 1984 · Administratively canceled · Barbosa Richard J, Miami Lakes, FL N1882DBeech C35 · S/N D-3154Cancelled Jan 17, 1984 · Administratively canceled · Wyche Cyril Jr, Boston, MA N18706Boeing 707-331B · S/N 18982Cancelled Jan 7, 1984 · Administratively canceled · Trans World Airlines Inc, New York, NY N1866VCessna 140 · S/N 14077Cancelled Nov 15, 1983 · Administratively canceled · Kinback Alan C, Woodbridge, VA N18842Aerospatiale SA341G GAZELLE · S/N 1107Cancelled Oct 28, 1983 · Administratively canceled · Aerospatiale Helicopter Corporation, Grand Prairie, TX N18736Cessna 150L · S/N 15074074Cancelled Sep 24, 1983 · Administratively canceled · Eagle Air Inc, Hagerstown, MD N19088Cessna 150L · S/N 15074159Cancelled Aug 2, 1983 · Administratively canceled · Costello Robert, Bloomfield, NJ N18850Stewart BD-5B · S/N 2535Cancelled Jun 25, 1983 · Administratively canceled · Stewart Lawrence W, Albuquerque, NM N18949Douglas DC3-G202A · S/N 2013Cancelled Jun 25, 1983 · Administratively canceled · Nathaniel Hawthorne College Corp, Antrim, NH N1846RCessna A185F · S/N 18502561Cancelled Jun 22, 1983 · Administratively canceled · Wishman Bros, Geraldine, MT N18906Beech C24R · S/N MC-522Cancelled Jun 15, 1983 · Administratively canceled · Wintell Associates, Denver, CO N18958Beech C24R · S/N MC-538Cancelled May 21, 1983 · Administratively canceled · Saldon Ltd, Ridgefield, CT N188CBBeech J35 · S/N D-5611Cancelled Dec 18, 1982 · Administratively canceled · Boggs Franklin D DBA, Gilley, KY N18616Cessna 150L · S/N 15073990Cancelled Dec 11, 1982 · Administratively canceled · Mosher Inc, Mt Gilead, OH N18919Beech C24R · S/N MC-526Cancelled Dec 9, 1982 · Administratively canceled · Compoo Inc, Shreveport, LA N1913PPiper PA-22 · S/N 22-2660Cancelled Dec 9, 1982 · Administratively canceled · Cooney John W, Victor, IA N1912PPiper PA-22-150 · S/N 22-2659Cancelled Nov 24, 1982 · Administratively canceled · Lawn Daniel J, Valdez, AK N1914SSavage-James STEEN SKYBOLT · S/N 1Cancelled Nov 6, 1982 · Administratively canceled · Savage James L, Atherton, CA N18969Beech C24R · S/N MC-541Cancelled Nov 4, 1982 · Administratively canceled · Piedmont Aviation Inc, Winston Salem, NC N18727Cessna 150L · S/N 15074065Cancelled Oct 30, 1982 · Administratively canceled · Otis Schmidt Enterprises Inc, Schaumburg, IL N19031Cessna 150L · S/N 15074108Cancelled Sep 16, 1982 · Administratively canceled · Northern Aviation Ltd, Riverhead, NY N18660Cessna 150L · S/N 15074022Cancelled Aug 12, 1982 · Administratively canceled · Wesley Martin R, Knob Noster, MO N1887HPiper PA-32R-300 · S/N 32R-7780198Cancelled Jun 19, 1982 · Administratively canceled · Langley Richard H, Clermont, FL N183FDassault-Breguet FALCON 20 · S/N 398Cancelled Jun 17, 1982 · Administratively canceled · Falcon Jet Corporation, Teterboro, NJ N1895TPiper PA-28-140 · S/N 28-7225044Cancelled Apr 17, 1982 · Administratively canceled · Wilson Leonard R, Perrysville, IN N18551Cessna 150L · S/N 15073936Cancelled Apr 15, 1982 · Administratively canceled · East Denver Flying Service Inc, Aurora, CO N18687Cessna 150L · S/N 15074042Cancelled Apr 15, 1982 · Administratively canceled · Keppler Richard J, Price, UT N191UBeech D18S · S/N A-305Cancelled Feb 6, 1982 · Administratively canceled · B & B Enterprises Inc, Honolulu, HI N1859GChampion 7KCAB · S/N 95Cancelled Jan 21, 1982 · Administratively canceled · Gibson James L, Oakland, MD N1836YCessna 172C · S/N 17249436Cancelled Jan 16, 1982 · Administratively canceled · Blalock & Blalock Inc, Sylvania, GA N1832JPiper PA-28-140 · S/N 28-24265Cancelled Oct 15, 1981 · Administratively canceled · Smith Harold C, Akron, OH N18669Cessna 150L · S/N 15074029Cancelled Oct 15, 1981 · Administratively canceled · Liberty Aviation Inc, Fiarfield, NJ N1912GMurphy 1912 BELLANCA · S/N 1Cancelled Oct 15, 1981 · Administratively canceled · Murphy Michael P, Oak Lawn, IL

Back to Warren D J