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.

N731NGCessna A188B · S/N 18803015TCancelled Aug 26, 2008 · Exported to Brazil · J & C Enterprises Aviation IncN731SQCessna A188B · S/N 18803122TCancelled Aug 26, 2008 · Exported to Brazil · Built 1978 · J & C Enterprises Aviation IncN79138Cessna A188B · S/N 18801965TCancelled Aug 26, 2008 · Exported to Brazil · Built 1974 · J & C Enterprises Aviation IncN7346ZPiper PA-25-235 · S/N 25-3297Cancelled Jul 24, 2008 · Exported to Brazil · Built 1965 · J & C Enterprises Aviation IncN3727EPiper PA-36-300 · S/N 36-7960057Cancelled Jul 18, 2008 · Exported to Brazil · Built 1978 · J & C Enterprises Aviaiton IncN774TCessna A188B · S/N 188-01756TCancelled Jul 16, 2008 · Exported to Brazil · Built 1974 · J & C Enterprises Aviation IncN4768YPiper PA-25-260 · S/N 25-4530Cancelled Jun 19, 2008 · Exported to Brazil · Built 1968N21860Cessna A188B · S/N 18801081Cancelled May 15, 2008 · Exported to Brazil · Built 1972 · J & C Enterprises Aviation IncN9438RCessna A188B · S/N 18802284Cancelled May 15, 2008 · Exported to Bolivia · Built 1975 · J & C Enterprises Aviation IncN4723QCessna A188B · S/N 18802494TCancelled Mar 12, 2008 · Exported to Argentina · Built 1976 · J & C Enterprises Aviation IncN9503GCessna A188B · S/N 18801505TCancelled Mar 10, 2008 · Exported to Brazil · Built 1974 · J & C Enterprises Aviation IncN70191Cessna A188B · S/N 18801861TCancelled Dec 13, 2007 · Exported to Brazil · Built 1974 · J & C Enterprises Aviation IncN731NACessna A188B · S/N 18803014TCancelled Nov 28, 2007 · Exported to Brazil · Built 1977 · J & C Enterprises Aviation IncN21735Cessna A188B · S/N 18800991Cancelled Nov 1, 2007 · Exported to Argentina · Built 1972 · J & C Enterprises Aviation IncN6677ZPiper PA-25-235 · S/N 25-2282Cancelled Aug 16, 2007 · Exported to Brazil · Built 1963 · J & C Enterprises Aviation IncN4861RCessna A188B · S/N 18802380TCancelled Jul 13, 2007 · Exported to Argentina · J & C Enterprises Aviation IncN2119JCessna T188C · S/N T18803853TCancelled May 18, 2007 · Exported to Brazil · Built 1981 · J & C Enterprises Aviation IncN2030JCessna T188C · S/N T18803335TCancelled May 17, 2007 · Exported to Brazil · Built 1978 · J & C Enterprises Aviation IncN2154KCessna A188B · S/N 18801249TCancelled Jan 17, 2007 · Exported to Argentina · Built 1973 · J & C Enterprises Aviation IncN53274Cessna A188B · S/N 18801730TCancelled Jan 17, 2007 · Exported to Brazil · Built 1974 · J & C Enterprises Aviation IncN9537PPiper PA-25-235 · S/N 25-7405625Cancelled Dec 6, 2006 · Exported to Brazil · Built 1974 · J & C Enterprises Aviation IncN9766JCessna A188B · S/N 18803851TCancelled Oct 19, 2006 · Exported to BrazilN9438GCessna A188B · S/N 18801485TCancelled Oct 17, 2006 · Exported to Brazil · Built 1974 · J & C Enterprises Aviation IncN731GUCessna A188B · S/N 18802892TCancelled Sep 12, 2006 · Exported to Argentina · Built 1977N9957JCessna T188C · S/N T18803886TCancelled Sep 5, 2006 · Exported to Brazil · Built 1981 · J & C Enterprises Aviation IncN4785QCessna A188B · S/N 18802527TCancelled Aug 29, 2006 · Exported to Argentina · Built 1976 · J & C Enterprises Aviation IncN4943RCessna A188B · S/N 18802460TCancelled Aug 24, 2006 · Exported to Brazil · J & C Enterprises Aviation IncN4385SCessna A188B · S/N 18801443Cancelled Aug 10, 2006 · Exported to Argentina · Built 1973 · J & C Enterprises Aviation IncN4456QCessna 188B · S/N 18800856Cancelled Jul 31, 2006 · Exported to Brazil · Built 1971 · J & C Enterprises Aviation IncN8060FCessna A188B · S/N 18801392TCancelled Jul 28, 2006 · Exported to Brazil · J & C Enterprises Aviation IncN9640GCessna A188B · S/N 18801576Cancelled Jul 28, 2006 · Exported to Brazil · Built 1974 · Buster Jerry V DBAN6978ZPiper PA-25-235 · S/N 25-2724Cancelled May 24, 2006 · Exported to Brazil · Built 1964 · J & C Enterprises Aviation IncN7610ZPiper PA-25-235 · S/N 25-3710Cancelled May 24, 2006 · Exported to Brazil · Built 1965 · J & C Enterprises Aviation IncN731CLCessna A188B · S/N 18802790TCancelled Mar 30, 2006 · Exported to Brazil · Built 1976 · Buster Jerry V DBAN7085BCessna A188B · S/N 188-02182TCancelled Mar 14, 2006 · Exported to Brazil · J & C Enterprises Aviation IncN82365Piper PA-25-235 · S/N 25-7656103Cancelled Mar 14, 2006 · Exported to Paraguay · Built 1976 · J & C Enterprises Aviation IncN90183Cessna A188B · S/N 18802629TCancelled Mar 14, 2006 · Exported to Brazil · J & C Enterprises Aviation IncN4383SCessna A188B · S/N 18803168TCancelled Feb 2, 2006 · Exported to Brazil · Built 1978 · J & C Enterprises Aviation IncN4818QCessna A188B · S/N 18802555Cancelled Oct 25, 2005 · Exported to Argentina · Built 1976 · J & C Enterprises Aviation IncN4056JCessna T188C · S/N T18803716TCancelled Oct 13, 2005 · Exported to Argentina · Built 1980 · J & C Enterprises Aviation IncN9956JCessna T188C · S/N T18803885TCancelled Oct 11, 2005 · Exported to Argentina · Built 1981 · J & C Enterprises Aviation IncN731LJCessna A188B · S/N 18802975TCancelled Sep 13, 2005 · Exported to Argentina · Buster Jerry V DBAN9409GCessna A188B · S/N 18801477Cancelled Sep 13, 2005 · Exported to Argentina · Built 1974 · J & C Enterprises Aviation IncN9777GCessna A188B · S/N 18801602TCancelled Sep 13, 2005 · Exported to Brazil · Built 1974 · J & C Enterprises Aviation IncN731GBCessna A188B · S/N 18802807TCancelled Aug 10, 2005 · Exported to Brazil · J & C Enterprises Aviation IncN731JDCessna A188B · S/N 18802924Cancelled Jun 23, 2005 · Exported to Brazil · Built 1977 · Buster Jerry V DBAN4882RCessna A188B · S/N 18802401TCancelled Feb 24, 2005 · Exported to Brazil · Built 1975N3872JCessna T188C · S/N T18803679TCancelled Feb 23, 2005 · Exported to Brazil · Built 1980 · J & C Enterprises Aviation IncN4848RCessna A188B · S/N 18802367TCancelled Feb 22, 2005 · Exported to Brazil · Built 1975 · J & C Enterprises Aviation IncN2832JCessna A188B · S/N 18803526TCancelled Jan 20, 2005 · Exported to Brazil · J And C Enterprises Aviation Inc
Back to Thomas, OK