OpenAirDocs.org
Shawnee, OK

Cancelled registrations · 58

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

N305PWCessna 208B · S/N 208B0828Cancelled Apr 1, 2023 · Registration expired, pending cancellation · Built 2000 · Delta Wing Equipment LLCN48021Cessna 170B · S/N 27087Cancelled Apr 1, 2023 · Registration expired, pending cancellation · Built 1956 · Buoy Stephen MatthewN6293LGrumman American Avn. AA-1B · S/N AA1B0093Cancelled Dec 3, 2022 · Registration expired, pending cancellation · Hembree Jamie LN6202MCessna 152 · S/N 15284638Cancelled Jun 5, 2021 · Registration expired, pending cancellation · Built 1980 · Flyokair LLCN59HRCessna 150 · S/N 17547Cancelled Dec 8, 2020 · Registration expired, pending cancellation · Built 1959 · Treatco WeldingN423MCBeech 58 · S/N TH-719Cancelled Oct 31, 2020 · Registration expired, pending cancellation · Built 1976 · Dghmd LLCN8786KStinson 108-1 · S/N 108-1786Cancelled Sep 6, 2019 · Revoked, canceled · Built 1947 · Flyers ClubN843PHCessna 208B · S/N 208B1207Cancelled Aug 2, 2018 · Exported to Indonesia · Built 2006 · Pacific Air Holdings LLCN842PHCessna 208B · S/N 208B1174Cancelled Feb 21, 2018 · Exported to Indonesia · Pacific Air Holdings LLCN707EMCessna 208B · S/N 208B2076Cancelled Jan 23, 2018 · Exported to Indonesia · Built 2009 · Pacific Air Holdings LLCN945APiper PA-22 · S/N 22-254Cancelled Jan 10, 2018 · Registration expired, pending cancellation · Built 1951 · Hunt Jim RN301PWCessna 208B · S/N 208B0983Cancelled Oct 5, 2017 · Exported to Indonesia · Aero Wing Equipment LLCN308PWCessna 208B · S/N 208B1274Cancelled Sep 1, 2017 · Exported to Indonesia · Built 2007 · Delta Wing Equipment LLCN306PWCessna 208B · S/N 208B1240Cancelled Aug 21, 2017 · Exported to Indonesia · Built 2007 · Delta Wing Equipment LLCN766UBeech D55 · S/N TE-636Cancelled Jun 7, 2017 · Registration expired, pending cancellation · Built 1968 · Gordon Cooper Technology CenterN7299LRaven Industries RX6 · S/N RX6-130Cancelled Feb 4, 2017 · Revoked, canceled · Built 1974 · Wallace Charles AN307PWCessna 208B · S/N 208B1254Cancelled Nov 30, 2016 · Exported to Indonesia · Built 2007 · Delta Wing Equipment LLCN20VGBell 206B · S/N 4572Cancelled Apr 25, 2014 · Exported to Canada · Built 2003 · Air Flite IncN955LSikorsky 269C · S/N S1955Cancelled Jan 10, 2014 · Exported to China · Built 2013 · Air Flite IncN1854PBeech C24R · S/N MC-766Cancelled Jul 26, 2013 · Built 1982 · Sparkman Chance PN6004PPiper PA-24-250 · S/N 24-1098Cancelled Apr 25, 2013 · Registration expired, pending cancellation · Built 1959 · Phillips William GN6899SAero Commander 680 · S/N 680-428-101Cancelled Feb 13, 2013 · Sale reported, canceled · Built 1956N2241HBalloon Works FIREFLY 7 · S/N 7775Cancelled Feb 7, 2013 · Registration expired, pending cancellation · Built 1978 · Epperson Dwight E DBAN5685YRaven S55A · S/N S55A-529Cancelled Sep 25, 2012 · Sale reported, pending cancellationN18127Cessna 177B · S/N 17702529Cancelled Aug 13, 2012 · Registration expired, pending cancellation · Built 1976 · Gholson Enterprises IncN2554YCessna 172D · S/N 17249854Cancelled Aug 10, 2012 · Registration pending, canceled · Built 1962N404MASchweizer 269C-1 · S/N 0373Cancelled Oct 18, 2011 · Exported to Brazil · Air Flite IncN82648Aeronca 7AC · S/N 7AC-1290Cancelled Aug 18, 2005 · Triennial form not returned · Built 1946 · Heister Victor CN7185XCessna 150A · S/N 15059285Cancelled Jun 15, 2005 · Triennial form not returned · Built 1961 · Gordon Cooper Vocational TechnicalN109AJAgusta A109E · S/N 11024Cancelled Mar 19, 2002 · Exported to Venezuela · Built 1998 · Oklahoma Austin Jet LLCN415XTEngler Royce O EXEC 162F · S/N 6252Cancelled Jun 21, 2001 · Triennial form not returned · Engler Royce OdellN894AJBell 212 · S/N 30894Cancelled Mar 2, 2001 · Exported to Canada · Oklahoma Austin Jet LLCN13DUBell 206B · S/N 4224Cancelled Jul 23, 1999 · Exported to India · Oklahoma Austin Jet LLCN61495Schweizer 269C-1 · S/N 0005Cancelled Nov 4, 1998 · Exported to Argentina · Air Flite IncN102JKPiper PA-23-250 · S/N 2751Cancelled Sep 26, 1995 · Gordon Cooper Area Votech SchoolN378WMPiper PA-18-150 · S/N 185668Cancelled Nov 15, 1994 · Sexton Rickey DN7507NSchweizer 269C · S/N S1378Cancelled Sep 7, 1993 · Exported to Uruguay · Air Flite IncN9292FHughes 269C · S/N 250396Cancelled Oct 1, 1992 · Exported to Argentina · Air Flite IncN1097ZHughes 269C · S/N 400917Cancelled Sep 23, 1992 · Exported to Australia · Air Flite IncN24WERockwell International 112TC · S/N 13072Cancelled Sep 9, 1992 · Exported to France · Bain Max SN7201EMooney M20J · S/N 240596Cancelled Apr 3, 1991 · Triennial form not returned · Woodward James DN3820FGreat Lakes 2T-1A-2 · S/N 0788Cancelled Oct 25, 1984 · Administratively canceled · Keith Aviation IncN5751VBeech A23-24 · S/N MA-15Cancelled Jun 25, 1984 · Barr Michael JN57820Fairchild M-62A · S/N T-43-7219Cancelled May 21, 1965 · Miller Melvin EN8834KUniversal Stinson 108-1 · S/N 108-1834Cancelled Nov 13, 1961 · Exported to Venezuela · Speaker Don EN740BBeech A35 · S/N D-1746Cancelled Oct 23, 1959 · Reding H EN44681Culver V · S/N V-72Cancelled Feb 29, 1956 · Jr Mcfarling A CN98383Piper J3C-65 · S/N 18569Cancelled Aug 3, 1955 · Built 1946 · Youts H AN35084Piper J3C-65 · S/N 6091Cancelled Feb 23, 1955 · Built 1940 · Regan Lionel EN85064Aeronca 7AC · S/N 7AC-3791Cancelled Oct 24, 1951 · Gwynne W Davidson
Back to Shawnee, OK