Guthrie, OK

Cancelled registrations · 143

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 = 'GUTHRIE'
  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.

N523UPBoeing 747-283B · S/N 22381Cancelled Jul 7, 2010 · Built 1982 · Stewart Industries International LLCN520UPBoeing 747-212B · S/N 21943Cancelled Jun 10, 2010 · Built 1980 · Stewart Industries International LLCN906AXMcdonnell Douglas DC-9-31 · S/N 47072Cancelled Nov 18, 2009 · Built 1968 · Stewart Industries International LLCN970AXDouglas DC-9-41 · S/N 47494Cancelled Nov 18, 2009 · Built 1970 · Stewart Industries International LLCN971AXMcdonnell Douglas DC-9-41 · S/N 47497Cancelled Nov 18, 2009 · Built 1970 · Stewart Industries International LLCN985AXMcdonnell Douglas DC-9-32 · S/N 47522Cancelled Nov 18, 2009 · Built 1972 · Stewart Industries International LLCN907AXDouglas DC-9-31 · S/N 47203Cancelled Aug 28, 2009 · Sale reported · Built 1968N951ASMcdonnell Douglas DC-9-82(MD-82) · S/N 49111Cancelled Apr 8, 2009 · Built 1982 · Stewart Industries International LLCN79830Mooney M20E · S/N 494Cancelled Jan 6, 2009 · Triennial form not returned · Built 1964 · Seward Leasing IncN221AAMcdonnell Douglas DC-9-82(MD-82) · S/N 49172Cancelled Nov 12, 2008 · Sale reported · Built 1983N288AAMcdonnell Douglas DC-9-82(MD-82) · S/N 49300Cancelled Nov 12, 2008 · Sale reported · Built 1985N210AAMcdonnell Douglas DC-9-82(MD-82) · S/N 49161Cancelled Nov 6, 2008 · Sale reported · Built 1983N275AAMcdonnell Douglas DC-9-82(MD-82) · S/N 49272Cancelled Nov 6, 2008 · Sale reported · Built 1984N285AAMcdonnell Douglas DC-9-82(MD-82) · S/N 49297Cancelled Nov 6, 2008 · Sale reported · Built 1985N286AAMcdonnell Douglas DC-9-82(MD-82) · S/N 49298Cancelled Nov 6, 2008 · Sale reported · Built 1985N936UPBoeing 727-108C · S/N 19503Cancelled Aug 4, 2008 · Sale reported · Built 1985N938UPBoeing 727-173C · S/N 19506Cancelled Aug 4, 2008 · Sale reported · Built 1967N944UPBoeing 727-22C · S/N 19103Cancelled Aug 4, 2008 · Sale reported · Built 1966N807ALBoeing 737-2T4 · S/N 23443Cancelled Jul 30, 2008 · Sale reported · Built 1985N821ALBoeing 737-230 · S/N 23155Cancelled Jul 30, 2008 · Built 1985 · Stewart Industries International LLCN940UPBoeing 727-185C · S/N 19826Cancelled Jul 11, 2008 · Sale reported · Built 1968N818ALBoeing 737-230 · S/N 22117Cancelled Feb 27, 2008 · Sale reported · Built 1980N935UPBoeing 727-1A7C · S/N 20143Cancelled Feb 22, 2008 · Built 1968 · Stewart Industries International LLCN976PGBoeing 737-212 · S/N 20521Cancelled Sep 4, 2007 · Sale reportedN417EXBoeing 727-51C · S/N 19290Cancelled May 5, 2007 · Built 1967 · Stewart Industries International LLCN421EXBoeing 727-22C · S/N 19099Cancelled May 5, 2007 · Built 1966 · Stewart Industries International LLCN426EXBoeing 727-22C · S/N 19089Cancelled May 5, 2007 · Built 1966 · Stewart Industries International LLCN427EXBoeing 727-22C · S/N 19090Cancelled May 5, 2007 · Built 1966 · Stewart Industries International LLCN428EXBoeing 727-22C · S/N 19097Cancelled May 5, 2007 · Built 1966 · Stewart Industries International LLCN528PCBoeing 727-82C · S/N 19597Cancelled May 5, 2007 · Built 1968 · Stewart Industries International LLCN322FVMcdonnell Douglas DC-9-82(MD-82) · S/N 49571Cancelled Apr 26, 2007 · Stewart Industries International LLCN775ATBoeing 727-290 · S/N 21511Cancelled Apr 24, 2007 · Built 1979 · Stewart Industries International LLCN820ALBoeing 737-230 · S/N 22138Cancelled Oct 17, 2006 · Built 1981 · Stewart Industries International LLCN908UPBoeing 727-27C · S/N 19114Cancelled Aug 23, 2006 · Sale reported · Built 1966N909UPBoeing 727-27C · S/N 19115Cancelled Aug 23, 2006 · Sale reported · Built 1966N910UPBoeing 727-27C · S/N 19117Cancelled Aug 23, 2006 · Sale reported · Built 1967N911UPBoeing 727-27C · S/N 19119Cancelled Aug 23, 2006 · Sale reported · Built 1967N912UPBoeing 727-62C · S/N 19244Cancelled Aug 23, 2006 · Sale reported · Built 1966N913UPBoeing 727-62C · S/N 19245Cancelled Aug 23, 2006 · Sale reported · Built 1966N914UPBoeing 727-27C · S/N 19246Cancelled Aug 23, 2006 · Sale reported · Built 1967N915UPBoeing 727-27C · S/N 19533Cancelled Aug 23, 2006 · Sale reported · Built 1967N917UPBoeing 727-30C · S/N 19310Cancelled Aug 23, 2006 · Sale reported · Built 1967N921UPBoeing 727-180C · S/N 19874Cancelled Aug 23, 2006 · Sale reported · Built 1968N923UPBoeing 727-31C · S/N 19229Cancelled Aug 23, 2006 · Sale reported · Built 1967N925UPBoeing 727-31C · S/N 19230Cancelled Aug 23, 2006 · Sale reported · Built 1967N929UPBoeing 727-22C · S/N 19092Cancelled Aug 23, 2006 · Sale reported · Built 1966N931UPBoeing 727-25C · S/N 19858Cancelled Aug 23, 2006 · Sale reported · Built 1968N939UPBoeing 727-27C · S/N 19532Cancelled Aug 23, 2006 · Sale reported · Built 1967N949UPBoeing 727-25C · S/N 19717Cancelled Aug 23, 2006 · Sale reported · Built 1967N950UPBoeing 727-25C · S/N 19718Cancelled Aug 23, 2006 · Sale reported · Built 1967
Back to Guthrie, OK