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.

N7887LPiper PA-34-200 · S/N 34-7250112Cancelled Aug 8, 1977 · Exported to Canada · Catlin Aviation CoN65162Douglas DC3C · S/N 12683Cancelled Jul 21, 1977 · Kerr Mcgee CorpN5732LAmerican AA-1 · S/N AA1-0132Cancelled Jul 12, 1977 · Strickler William A DBA V & W Machine WorksN558EGConvair 240-7 · S/N 75Cancelled Jul 8, 1977 · Executive Aviation Ltd.N7985FPiper PA-28-181 · S/N 28-7790231Cancelled Feb 17, 1977 · Exported to Australia · Catlin Aviation CoN63185Cessna 150M · S/N 15077163Cancelled Jan 28, 1977 · Exported to Canada · Wiley Post Aircraft Sales IncN81430Rockwell Commander 690A · S/N 11321Cancelled Sep 16, 1976 · Exported to Australia · Downtown Airpark IncN70811Cessna 182M · S/N 18259375Cancelled Aug 10, 1976 · Exported to Canada · Sky Sales & Service IncN67KMNorth American NA-265-80 · S/N 380-7Cancelled May 25, 1976 · Kerr Mcgee CorpN711LZAero Commander 500 S · S/N 1846Cancelled Jul 16, 1975 · Kerr-Mcgee CorpN3924GCessna U206C · S/N U206-0924Cancelled Jun 23, 1975 · Exported to Peru · Sky Sales 7 Service IncN8014CDouglas DC3C · S/N 4200Cancelled May 19, 1975 · Exported to Canada · Sky Sales & Service IncN65512North American AT-6A · S/N 78-6661Cancelled May 9, 1975 · Rorem S DN8912YPiper PA-39 · S/N 39-68Cancelled Nov 15, 1974 · Exported to New Zealand · Air Center Sales IncN9723GCessna 180 · S/N 18052223Cancelled Oct 18, 1974 · Exported to Canada · Glenn E Crabtree DBA Nw Aviation Sales & ServiceN6479YPiper PA-23-250 (6PCLM) · S/N 27-3775Cancelled Jun 18, 1974 · Exported to United Kingdom · Catlin Aviation IncN5565North American NA-265-20 · S/N 282119Cancelled Apr 16, 1974 · Kerr Mc Gee CorpN5592YPiper PA-23-250 (6PCLM) · S/N 27-2699Cancelled Jan 22, 1974 · Exported to Canada · Catlin Aviation IncN78297Cessna 172K · S/N 17257557Cancelled Dec 21, 1973 · Air Center Employees Flying ClubN8454NBeech D55 · S/N TE-573Cancelled Nov 23, 1973 · Exported to Australia · Built 1968 · Catlin Aviation CoN9395YBeech N35 · S/N D-6602Cancelled Jul 24, 1973 · Exported to Australia · Catlin Aviation CoN1691TPiper PA-28-140 · S/N 28-7125008Cancelled Jul 16, 1973 · Exported to Australia · Catlin Aviation CoN9367WPiper PA-28-235 · S/N 28-11057Cancelled Jul 16, 1973 · Exported to Canada · Catlin Aviation CoN5260TPiper PA-28-140 · S/N 28-7225379Cancelled Jun 25, 1973 · Exported to Australia · Built 1972 · Catlin Aviation CoN660FLPiper PA-28-140 · S/N 28-7125578Cancelled Dec 15, 1972 · Exported to Canada · Catlin Aviation CoN1037SHandley Page HP-137 MK1 · S/N 216Cancelled May 30, 1972 · Exported to United Kingdom · Insured Aircraft Title Service IncN5822YPiper PA-23-250 · S/N 27-2970Cancelled Feb 17, 1972 · Exported to Australia · Downtown Airpark IncN30HPCessna 150J · S/N 15070277Cancelled Sep 15, 1971 · Oklahoma Dept Of Public SafetyN74538Mooney M20B · S/N 1849Cancelled Oct 12, 1970 · Oklahoma City Aircraft CoN5833ECessna 150 · S/N 17333Cancelled Jun 23, 1970 · Downtown Airpark IncN204WBell 47G · S/N 215Cancelled May 8, 1970 · Aircraft Lease Charter IncN6333UAero Commander 680FL · S/N 1352-31Cancelled May 4, 1970 · Exported to South Africa · Downtown Airpark IncN352HLockheed 18-08 · S/N 2059Cancelled Sep 28, 1967 · National Aircraft Sales IncN5969XBrantly B-2 · S/N 111Cancelled May 7, 1965 · Catlin Aviation CoN62WPiper PA-23 · S/N 23-144Cancelled Nov 7, 1960 · Catlin Aviation CoN46817Cessna T-50 · S/N 5150Cancelled Jan 6, 1960 · Page & ColbertN2364APiper PA-18-135 · S/N 18-1912Cancelled May 17, 1958 · Exported to Germany · Catlin Aviation CoN5172NFairchild M-62A · S/N 10354AECancelled Nov 15, 1955 · Maurice J PrunerN61719Cessna T-50 · S/N 6561Cancelled Oct 12, 1955 · Lamoureaux Roy MN5262NTaylorcraft DCO-65 · S/N L5411Cancelled Oct 6, 1955 · Roy A Good JrN65979Consolidated Vultee BT-13A · S/N 11113Cancelled Apr 18, 1955 · Morris E RN4199VCessna 170 · S/N 18532Cancelled Jun 8, 1953 · Downtown Airpark IncN5261NLockheed P-38L · S/N 4424189Cancelled Jun 8, 1953 · Page Aviation ServiceN9045ACessna 170A · S/N 18898Cancelled Sep 7, 1951 · Downtown Airpark IncN16497Porterfield 35 · S/N 197Cancelled Jul 31, 1951 · Tom M HarrisN3413VBeech 35 · S/N D-892Cancelled Apr 25, 1951 · Albert Johnsons ExcavationsN4934NCessna T-50 · S/N 4197Cancelled Dec 14, 1950 · Patterson Elmer WN4300VCessna 195 · S/N 7213Cancelled Jun 7, 1949 · Denver Producing & Refining CoN91096Stinson AT-19 · S/N 77-444Cancelled Apr 29, 1949 · Veteran Sales Services DBA Ja SpiersN29022General G1-80 · S/N 9Cancelled Nov 8, 1948 · Built 1941 · Cheenermaurice
Back to Okc, OK