Okc, OK

Cancelled registrations · 209

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

N8173ACessna 170B · S/N 25025Cancelled Nov 9, 2012 · Sale reported, pending cancellation · Built 1952N4203LCessna 172G · S/N 17254272Cancelled Nov 7, 2012 · Sale reported, canceled · Built 1966N736TJCessna R172K · S/N R1722773Cancelled Oct 16, 2012 · Sale reported, pending cancellation · Built 1977N5TYKane John A RV-4 · S/N 2846Cancelled Oct 3, 2012 · Sale reported, pending cancellationN950VJDouglas DC-9-31 · S/N 47564Cancelled Oct 3, 2012 · Sale reported, pending cancellation · Built 1972N609BBeech A35 · S/N D-1632Cancelled Oct 2, 2012 · Sale reported, pending cancellation · Built 1948N6105GCessna 150K · S/N 15071605Cancelled Oct 2, 2012 · Sale reported, pending cancellation · Built 1969N40671Maule M-4-220C · S/N 2178CCancelled Aug 22, 2012 · Sale reported, pending cancellation · Built 1973N9764UGrumman American Avn. AA-5A · S/N AA5A-0164Cancelled Aug 21, 2012 · Sale reported, canceled · Built 1976N204AHBell 204-B · S/N 2030Cancelled Jun 29, 2012 · Exported to Canada · Built 1985N1545FBalloon Works FIREFLY 7-B · S/N 10263Cancelled Jun 27, 2012 · Sale reported, canceled · Built 1981N3893JCessna 150G · S/N 15065193Cancelled Jun 14, 2012 · Sale reported, pending cancellation · Built 1966N360MJSukhoi SU-26MX · S/N 5105Cancelled Feb 15, 2012 · Exported to Hungary · Built 1990N35453Piper PA-31-350 · S/N 31-8052006Cancelled Dec 27, 2011 · Exported to Canada · Built 1979N2799BAero Commander 560-A · S/N 299Cancelled Nov 23, 2011 · Sale reported, pending cancellation · Built 1956N23505Cessna 150H · S/N 15068997Cancelled Aug 19, 2011 · Sale reported, pending cancellation · Built 1968N8810VBellanca 17-30A · S/N 30340Cancelled Jun 30, 2011 · Sale reported · Built 1971N508MCBoeing 747-230B · S/N 21644Cancelled Jun 7, 2011 · Sale reported · Built 1979N1621BLuscombe 11A · S/N 11127Cancelled Apr 16, 2011 · Sale reported, pending cancellation · Built 1948N9148NStapleton James F BOWERS FLYBABY 1A · S/N 6650Cancelled Apr 16, 2011 · Sale reported, pending cancellationN142PHBell 412 · S/N 33150Cancelled Apr 4, 2011 · Exported to Israel · Built 1987N1503MBeech GB-2 · S/N 4794Cancelled Mar 28, 2011 · Sale reported, pending cancellationN313NTNorth American NA-265-40 · S/N 282-94Cancelled Mar 16, 2011 · Sale reported, pending cancellation · Built 1968N2116AMarkwell Cleone FSII · S/N MARK02Cancelled Jan 5, 2011 · Sale reported, pending cancellation · Built 1995N5339PCessna 182T · S/N 18281205Cancelled Mar 31, 2010 · Exported to Russia · Built 2003N7058DPiper PA-22-150 · S/N 22-4955Cancelled Jan 21, 2010 · Exported to South Africa · Built 1957N7035LCessna 310K · S/N 310K0135Cancelled May 16, 2007 · Sale reported · Built 1966N89208Cessna 140 · S/N 8228Cancelled Dec 15, 2005 · Sale reported · Built 1946N739SPCessna 172S · S/N 172S8668Cancelled Oct 6, 2005 · Exported to Australia · Built 2000N1123SCessna 208B · S/N 208B0396Cancelled Jul 11, 2005 · Exported to South Africa · Built 1994N8974UDouglas DC-8-62 · S/N 46110Cancelled Jul 11, 2005 · Exported to Swaziland · Built 1969N1036MRiggs Robert CH .701 · S/N 1701Cancelled Nov 9, 2004 · Exported to Thailand · Built 1996N208TCThunder & Colt Airborne Amer AX8-90 S 2 · S/N 2011USACancelled Oct 20, 2004 · Exported to Poland · Built 1991N30DBPiper PA-30 · S/N 30-1657Cancelled Oct 7, 2004 · Exported to Germany · Built 1967N457TAAirbus Industrie A320-233 · S/N 0902Cancelled Jul 30, 2004 · Exported to China · Built 1998N2471PPiper PA-22-150 · S/N 22-2846Cancelled Sep 15, 1992 · Exported to South Africa · Built 1955N617CABeech 95-B55 · S/N TC-1078Cancelled Nov 8, 1985 · Coffeyville Aircraft IncN67NDPiper PA-31 · S/N 31-7612108Cancelled Apr 23, 1981 · Exported to Canada · Catlin Aviation CoN63148Cessna 150M · S/N 15077137Cancelled Oct 31, 1979 · Exported to Canada · Ross James TN81767Rockwell International 690B · S/N 11465Cancelled Oct 15, 1979 · Exported to United Kingdom · Downtown Airpark IncN6755QGrumman American Avn. G-164B · S/N 266BCancelled Nov 28, 1978 · Exported to South Africa · American Agviation IncN6350VHelio H-295 · S/N 1220Cancelled Sep 28, 1978 · Exported to Ecuador · P B Odom EnterprisesN735BSCessna 182Q · S/N 18265300Cancelled Aug 30, 1978 · Exported to Australia · Sky Sales & Service IncN9034NAero Commander 500 S · S/N 3060Cancelled Aug 30, 1978 · Exported to Australia · Catlin Aviation CoN8534FPiper PA-28-181 · S/N 28-7790256Cancelled Apr 24, 1978 · Exported to Australia · Catlin Aviation CoN1772RCessna A185F · S/N 18502491Cancelled Apr 14, 1978 · Exported to Canada · Built 1974 · Catlin Aviation CoN5564VAero Commander 680 · S/N 680495165Cancelled Feb 14, 1978 · Exported to Venezuela · Sky Sales & Service IncN5635PPiper PA-24 · S/N 24-705Cancelled Dec 12, 1977 · Exported to Canada · Catlin Aviation CoN711JTAero Commander 1121 · S/N 91Cancelled Nov 1, 1977 · Cimarron Industries LtdN8822EPiper PA-28-181 · S/N 28-7690206Cancelled Sep 19, 1977 · Exported to New Zealand · Wiley Post Aircraft Sales Inc
Back to Okc, OK