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.

N2433KPiper PA-38-112 · S/N 38-79A0631Cancelled Sep 6, 2011 · Sale reported, pending cancellationN6890ZPiper PA-25-235 · S/N 25-2615Cancelled Aug 11, 2011 · Exported to Argentina · Built 1964 · J & C Enterprises Aviation IncN4851QCessna A188B · S/N 18802587Cancelled Jul 25, 2011 · Exported to Brazil · Built 1976 · J & C Enterprises Aviation IncN9347RCessna A188B · S/N 18802248TCancelled Jul 25, 2011 · Exported to Brazil · J & C Enterprises Aviation IncN202AWCessna A188B · S/N 18800835Cancelled Jul 20, 2011 · Sale reported, pending cancellation · Built 1971N6190APiper PA-36-375 · S/N 36-8102022Cancelled Jun 28, 2011 · Exported to Brazil · Built 1982 · J & C Enterprises Aviation IncN731NKCessna A188B · S/N 18803023TCancelled Jun 24, 2011 · Exported to Brazil · Built 1977 · J & C Enterprises Aviation IncN4989QCessna A188B · S/N 18802723TCancelled Jun 21, 2011 · Exported to Brazil · Built 1976 · J & C Enterprises Aviation IncN5338JPitts Aerobatics S-2B · S/N 5075Cancelled Jun 9, 2011 · Exported to Brazil · J & C Enterprises Aviation IncN444TLBellanca 17-31ATC · S/N 73-31043Cancelled May 4, 2011 · Built 1972 · J & C Enterprises Aviation IncN4833QCessna A188B · S/N 18802569TCancelled Mar 8, 2011 · Exported to Brazil · Built 1976 · J & C Enterprises Aviation IncN57856Piper PA-36-300 · S/N 36-7760027Cancelled Jan 21, 2011 · Exported to Brazil · Built 1977 · J & C Enterprises Aviation IncN173JCCessna 310B · S/N 35553Cancelled Jan 7, 2011 · Expired dealer · Buster Jerry V DBAN3693YCessna 210C · S/N 21058193Cancelled Jan 7, 2011 · Expired dealer · Built 1963 · Buster Jerry V DBAN5547MAero Commander 100 · S/N 177Cancelled Jan 7, 2011 · Expired dealer · Buster Jerry V DBAN8154CPiper PA-34-200T · S/N 34-7970391Cancelled Nov 24, 2010 · Exported to Brazil · J & C Enterprises Aviation IncN4256NCessna A188B · S/N 188-01514TCancelled Nov 19, 2010 · Exported to Brazil · Built 1974 · J & C Enterprises Aviation IncN4911QCessna A188B · S/N 18802646TCancelled Nov 19, 2010 · Exported to Brazil · Built 1976 · J & C Enterprises Aviation IncN4879JCessna 172N · S/N 17273689Cancelled Nov 15, 2010 · Exported to Brazil · Built 1979 · J & C Enterprises Aviation IncN53207Cessna A188B · S/N 18801684TCancelled Nov 2, 2010 · Exported to Brazil · Built 1974 · J & C Enterprises Aviation IncN117LHCessna 188 · S/N 18801814Cancelled Oct 12, 2010 · Exported to Brazil · J & C Enterprises Aviation IncN41690Bellanca 7KCAB · S/N 399-73Cancelled Oct 6, 2010 · Exported to Brazil · Built 1973 · J & C Enterprises Aviation IncN88228Bellanca 7KCAB · S/N 476-74Cancelled Oct 6, 2010 · Exported to Brazil · Built 1974 · J & C Enterprises Aviation IncN9RBCessna 210F · S/N 21058776Cancelled Sep 8, 2010 · Built 1966 · J & C Enterprises Aviation IncN2350XPiper PA-36-375 · S/N 36-8202010Cancelled Aug 27, 2010 · Exported to Brazil · Built 1982 · J & C Enterprises Aviation IncN3673EPiper PA-36-375 · S/N 36-7902045Cancelled Aug 27, 2010 · Exported to Brazil · Built 1979 · J & C Enterprises Aviation IncN4459QCessna A188B · S/N 18800859Cancelled Jul 13, 2010 · Exported to Brazil · Built 1972 · J & C Enterprises Aviation IncN98505Cessna 172P · S/N 17276303Cancelled Jul 13, 2010 · Exported to Brazil · Built 1984 · J & C Enterprises Aviation IncN9153GCessna A188B · S/N 18801397Cancelled May 11, 2010 · Exported to Brazil · Built 1973 · J & C Enterprises Aviation IncN82642Piper PA-36-300 · S/N 36-7760124Cancelled Mar 16, 2010 · Exported to Paraguay · Built 1977 · J & C Enterprises Aviation IncN2478WCessna T182T · S/N T18208776Cancelled Mar 2, 2010 · Exported to Brazil · Built 2007 · J & C Enterprises Aviation IncN5650GCessna A188B · S/N 18801131TCancelled Oct 20, 2009 · Exported to Brazil · Built 1973 · J & C Enterprises Aviation IncN220RABeech 58 · S/N TH-624Cancelled Aug 10, 2009 · Exported to Brazil · J & C Enterprises Aviation IncN2199JCessna T188C · S/N T18803436TCancelled May 13, 2009 · Exported to Argentina · J & C Enterprises Aviation IncN2694JCessna T188C · S/N T18803499TCancelled May 13, 2009 · Exported to Argentina · Built 1979 · J & C Enterprises Aviation IncN9213RCessna A188B · S/N 18802158Cancelled Apr 8, 2009 · Exported to Brazil · Built 1975 · J & C Enterprises Aviation IncN9719PPiper PA-25-260 · S/N 25-7556038Cancelled Apr 8, 2009 · Exported to Brazil · Built 1974 · J & C Enterprises Aviation IncN9316GCessna A188B · S/N 18801451Cancelled Apr 7, 2009 · Exported to Brazil · Built 1973 · J & C Enterprises Aviation IncN9422GCessna A188B · S/N 18801480TCancelled Apr 7, 2009 · Exported to Brazil · Built 1974 · J & C Enterprises Aviation IncN9995GCessna A188A · S/N 18800795Cancelled Apr 7, 2009 · Exported to Brazil · Built 1971 · J & C Enterprises Aviation IncN11956Cessna 150L · S/N 15075734Cancelled Mar 20, 2009 · Exported to Paraguay · Built 1974 · J & C Enterprises Aviation IncN119HRHawker Beechcraft G36 · S/N E-3823Cancelled Mar 20, 2009 · Exported to Brazil · Built 2007 · J & C Enterprises Aviation IncN5356VCessna 172RG · S/N 172RG0513Cancelled Mar 20, 2009 · Exported to Paraguay · Built 1980 · J & C Enterprises Aviation IncN70126Cessna A188B · S/N 18801842TCancelled Dec 3, 2008 · Exported to Brazil · Built 1974 · J & C Enterprises Aviation IncN7790ZPiper PA-25-235 · S/N 25-2024Cancelled Oct 15, 2008 · Exported to Argentina · Built 1962 · J & C Enterprises Aviation IncN8514EChampion 7FC · S/N 7FC-327Cancelled Oct 2, 2008 · Exported to Canada · Built 1959 · Perkins EddieN4894RCessna A188B · S/N 18802412TCancelled Sep 30, 2008 · Exported to Brazil · Built 1975 · J & C Enterprises Aviation IncN9224RCessna A188B · S/N 18802167TCancelled Sep 16, 2008 · Exported to Brazil · Built 1975 · J & C Enterprises Aviation IncN4952QCessna A188B · S/N 18802686TCancelled Aug 26, 2008 · Exported to Brazil · Built 1976 · J & C Enterprises Aviation IncN5339QCessna 150L · S/N 15073239Cancelled Aug 26, 2008 · Exported to Brazil · Built 1972 · J & C Enterprises Aviation Inc
Back to Thomas, OK