Thomas, OK

Cancelled registrations · 251

Query with SQL
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_state = 'OK' AND d.registrant_city = 'THOMAS'
  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.

N731MXCessna A188B · S/N 18803011TCancelled Dec 23, 2004 · Exported to Brazil · Built 1977N2083JCessna T188C · S/N T18803373TCancelled Dec 20, 2004 · Exported to Brazil · Built 1978N731EUCessna A188B · S/N 18802847TCancelled Dec 3, 2004 · Exported to Brazil · J & C Enterprises Aviation IncN731TRCessna A188B · S/N 18803147Cancelled Dec 2, 2004 · Exported to Brazil · Built 1978N4987QCessna A188B · S/N 18802721TCancelled Nov 29, 2004 · Exported to Brazil · Built 1976 · J & C Enterprises Aviation IncN6517ZPiper PA-25-235 · S/N 25-2045Cancelled Nov 29, 2004 · Exported to Brazil · Built 1962N9034RCessna A188B · S/N 18802084TCancelled Nov 29, 2004 · Exported to Brazil · Built 1975 · J & C Enterprises Aviation IncN4848QCessna A188B · S/N 18802584TCancelled Nov 19, 2004 · Exported to Argentina · Built 1976N4872RCessna A188B · S/N 18802391TCancelled Nov 19, 2004 · Exported to Brazil · J & C Enterprises Aviation IncN731CHCessna A188B · S/N 18802788TCancelled Nov 19, 2004 · Exported to Brazil · J & C Enterprises Aviation IncN1118EBellanca 8KCAB · S/N 304-77Cancelled Oct 20, 2004 · Exported to Brazil · Built 1977 · J & C Enterprises Aviation IncN8554LPiper PA-25-260 · S/N 25-4974Cancelled Aug 10, 2004 · Exported to Brazil · Built 1969N3874JCessna T188C · S/N T18803680TCancelled Aug 6, 2004 · Exported to Brazil · Built 1980 · J & C Enterprises Aviation IncN9972JCessna T188C · S/N T18803901TCancelled Aug 6, 2004 · Exported to Brazil · Built 1982 · J & C Enterprises Aviation IncN9603JCessna T188C · S/N T18803826TCancelled Mar 11, 2004 · Exported to Brazil · J & C Enterprises Aviation IncN8234GCessna A188B · S/N 18801261TCancelled Dec 30, 2003 · Exported to Brazil · Built 1973 · Buster Jerry V DBAN4719QCessna A188B · S/N 18802492TCancelled Oct 16, 2003 · Exported to Brazil · Built 1976 · J & C Enterprises Aviation IncN70214Cessna A188B · S/N 18801731TCancelled Sep 24, 2003 · Exported to Brazil · Built 1974N86405Cessna A188B · S/N 18802012TCancelled Sep 24, 2003 · Exported to Brazil · Built 1975N4941RCessna A188B · S/N 18802458TCancelled May 28, 2003 · Exported to Brazil · Built 1975 · J & C Enterprises Aviation IncN4922QCessna A188B · S/N 18802657TCancelled Apr 17, 2003 · Exported to Brazil · Built 1976 · J & C Enterprises Aviation IncN54883Piper PA-25-235 · S/N 25-7656029Cancelled Feb 18, 2003 · Exported to Brazil · Built 1976 · J & C Enterprises Aviation IncN92389Cessna A188B · S/N 18802062TCancelled Feb 18, 2003 · Exported to Brazil · Built 1975 · J & C Enterprises Aviation IncN215GAGippsland GA-200C · S/N 200C9939FCancelled Feb 14, 2003 · Exported to Brazil · Built 1999 · J & C Enterprises Aviation IncN4835QCessna A188B · S/N 18802571TCancelled Feb 4, 2003 · Exported to Brazil · Built 1976 · J & C Enterprises Aviation IncN9805PPiper PA-25-235 · S/N 25-7556121Cancelled Dec 5, 2002 · Exported to Brazil · Built 1975 · J & C Enterprises Aviation IncN6210ZWSK PZL Mielec M-18 DROMADER · S/N 1Z009-13Cancelled Jul 12, 2002 · Exported to Australia · Built 1982 · J & C Enterprises Aviation IncN86139Cessna A188B · S/N 18802007Cancelled May 14, 2002 · Exported to Brazil · Built 1975 · J & C Enterprises Aviation IncN9999JCessna A188B · S/N 18803928TCancelled Jan 14, 2002 · Exported to Brazil · Built 1982 · J & C Enterprises Aviation IncN9541JCessna A188B · S/N 18803819TCancelled Dec 31, 2001 · Exported to Brazil · J & C Enterprises Aviation IncN9868PPiper PA-25-235 · S/N 25-7556192Cancelled Dec 17, 2001 · Exported to Brazil · Built 1975 · J & C Enterprises Aviation IncN2827JCessna A188B · S/N 18803523TCancelled Oct 4, 2001 · Exported to Brazil · Built 1979 · J & C Enterprises Aviation IncN731AFCessna A188B · S/N 18802738TCancelled Oct 4, 2001 · Exported to Brazil · Built 1976 · J & C Enterprises Aviation IncN4812QCessna A188B · S/N 18802550TCancelled Sep 4, 2001 · Exported to Brazil · J & C Enterprises Aviation IncN4864RCessna A188B · S/N 18802383TCancelled Sep 4, 2001 · Exported to Brazil · J & C Enterprises Aviation IncN9887PPiper PA-25-235 · S/N 25-7556181Cancelled May 30, 2001 · Exported to Brazil · J & C Enterprises Aviation IncN9659JCessna T188C · S/N T18803833TCancelled Apr 27, 2001 · Exported to Brazil · J & C Enterprises Aviation IncN214GAGippsland GA-200C · S/N 200C9935Cancelled Jan 11, 2001 · Exported to Brazil · J & C Enterprises Aviation IncN4739RCessna A188B · S/N 18802312TCancelled Dec 27, 2000 · Exported to Brazil · J & C Enterprises Aviation IncN4937QCessna A188B · S/N 18802672TCancelled Nov 20, 2000 · Exported to Brazil · J & C Enterprises Aviation IncN53220Cessna A188B · S/N 18801697TCancelled Nov 20, 2000 · Exported to Brazil · J & C Enterprises Aviation IncN4934QCessna A188B · S/N 18802669TCancelled Nov 15, 2000 · Exported to Brazil · J & C Enterprises Aviation IncN6650GCessna A188B · S/N 18801209Cancelled Nov 6, 2000 · Exported to Brazil · J & C Enterprises Aviation IncN208GAGippsland GA200 · S/N 2009828FCancelled Jun 9, 2000 · Exported to Brazil · J & C Enterprises Aviation IncN2183JCessna T188C · S/N T18803420TCancelled Dec 13, 1999 · Exported to Brazil · J & Centerprises Aviation IncN4956RCessna A188B · S/N 18802473TCancelled Jan 13, 1999 · Exported to Argentina · J & C Enterprises Aviation IncN4901RCessna A188B · S/N 18802419TCancelled Mar 2, 1982 · J C Enterprises Of Thomas IncN4833RCessna A188B · S/N 18802352TCancelled Feb 3, 1978 · Buster Jerry V DBA J&C EnterprisesN1880CCessna 170B · S/N 26024Cancelled Oct 7, 1971 · Exported to Canada · Schou Niles FN2300GCessna 182B · S/N 51600Cancelled Dec 15, 1965 · Powers Jack L
Back to Thomas, OK