Tulsa, OK

Cancelled registrations · 1,071

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

N1304Cornett EAABIPLANE · S/N BC-1Cancelled Apr 14, 1978 · Sale reported, canceled · Built 1967N738NACessna 172N · S/N 17270097Cancelled Apr 10, 1978 · Exported to Australia · Christiansen Aviation IncN1844PPiper PA-22-150 · S/N 22-2624Cancelled Mar 4, 1978 · Exported to Canada · Hoover Jerry LN759CKCessna 182Q · S/N 18265885Cancelled Feb 6, 1978 · Exported to Australia · Pennant Aviation IncN759RBCessna 182Q · S/N 18266189Cancelled Feb 3, 1978 · Exported to Australia · Pennant Aviation IncN759ADCessna 182Q · S/N 18265831Cancelled Feb 2, 1978 · Exported to Australia · Pennant Aviation IncN4740GCessna 414 · S/N 414-0930Cancelled Jan 30, 1978 · Exported to NigeriaN761FNCessna T210M · S/N 21062223Cancelled Jan 9, 1978 · Exported to Canada · Pennant Aviation IncN736KUCessna R172K · S/N R172-2595Cancelled Dec 20, 1977 · Exported to Australia · Pennant Aviation IncN737UCCessna 172N · S/N 17269677Cancelled Dec 13, 1977 · Exported to Australia · Pennant Aviation IncN756CUCessna U206G · S/N U20603991Cancelled Dec 13, 1977 · Exported to Australia · Pennant Aviation IncN734EGCessna 172N · S/N 17268792Cancelled Dec 12, 1977 · Exported to Australia · Pennant Aviation IncN3865TPiper PA-28R-180 · S/N 28R-30188Cancelled Nov 18, 1977 · Rivair Flying Service IncN8956LGrumman American Avn. AA-1B · S/N AA1B-0406Cancelled Nov 18, 1977 · Rivair Flying Service IncN756FPCessna U206G · S/N U20604058Cancelled Nov 10, 1977 · Exported to Australia · Pennant Aviation IncN2371JBeech 23 · S/N M-335Cancelled Oct 27, 1977 · Selby George PN1049VCessna R172K · S/N R172-2092Cancelled Oct 19, 1977 · Exported to Australia · Pennant Aviation IncN735GGCessna 182Q · S/N 182-65408Cancelled Oct 19, 1977 · Exported to Australia · Pennant Aviation IncN759CPCessna 182Q · S/N 18265889Cancelled Oct 19, 1977 · Exported to Australia · Pennant Aviation IncN732YUCessna 210M · S/N 21061888Cancelled Oct 18, 1977 · Exported to Australia · Pennant Aviation IncN831FDouglas DC-8-33 · S/N 45606Cancelled Oct 14, 1977 · Boulder Bank & Trust CoN9521MMooney M20F · S/N 670098Cancelled Jul 19, 1977 · Built 1966 · Stanfield Cecil EN5762FPiper PA-28-140 · S/N 28-25065Cancelled Jul 12, 1977 · Hartman Cornelius CN6907MStinson 108-3 · S/N 108-4907Cancelled Jul 12, 1977 · Myers D LN10422Cessna 150L · S/N 15074852Cancelled Jul 6, 1977 · Ross School Of Aviation IncN735UJCessna 182Q · S/N 18265692Cancelled Jun 21, 1977 · Exported to Australia · Pennant Aviation IncN75719Cessna 172N · S/N 17267900Cancelled Apr 19, 1977 · Exported to Australia · Pennant Aviation IncN75781Cessna 172N · S/N 17267945Cancelled Apr 19, 1977 · Exported to Australia · Pennant Aviation IncN23GMBeech B95 · S/N TD-318Cancelled Apr 18, 1977 · Exported to Canada · Tulsair Beechcraft IncN7349SCessna 182P · S/N 18265140Cancelled Apr 15, 1977 · Exported to Australia · Pennant Aviation IncN732JGCessna 210L · S/N 21061544Cancelled Feb 16, 1977 · Exported to Australia · Pennant Aviation IncN35339Cessna 172G · S/N 17256719Cancelled Feb 14, 1977 · Oklahoma Airmen Flying Club IncN13132Cessna 172M · S/N 17262520Cancelled Feb 11, 1977 · Built 1973 · Cbsi Aero Club IncN45690Cessna 150M · S/N 15077021Cancelled Feb 11, 1977 · Built 1975 · Christiansen Aviation IncN4831UCessna 210-5A(205A) · S/N 2050531Cancelled Jan 28, 1977 · Reeds TedN7359SCessna 182P · S/N 18265150Cancelled Jan 21, 1977 · Exported to Australia · Pennant Aviation IncN101GGBeech 65-B80 · S/N LD-354Cancelled Jan 18, 1977 · Exported to Venezuela · Built 1967 · Great Planes Sales IncN310WMCessna 310P · S/N 310P-0034Cancelled Nov 8, 1976 · Exported to Canada · Jensen International IncN43CFCessna 421 · S/N 421-0009Cancelled Nov 2, 1976 · Exported to Canada · Sierra Bravo CorpN28LLockheed 18-56 · S/N 2199Cancelled Oct 22, 1976 · Hardesty Floyd RN9721VCessna 172M · S/N 17264487Cancelled Oct 18, 1976 · Exported to Canada · Tulsa Aircraft Sales IncN6991VMooney M20F · S/N 22-1353Cancelled Sep 3, 1976 · Exported to Canada · Sierra Bravo CorpN7343GCessna 172K · S/N 17259043Cancelled Jul 21, 1976 · Exported to Canada · Rivair Flying Service IncN1462RGrumman American Avn. AA-1B · S/N AA1B-0562Cancelled Jun 14, 1976 · Rivair Flying Service IncN4040JCessna 150G · S/N 15065340Cancelled Jun 11, 1976 · Built 1966 · Riverside Airlines IncN896TScheibe BERGFALKE-III · S/N 5580Cancelled May 28, 1976 · Tulsa Skyhawks Soaring Club IncN86877Bellanca 14-13 · S/N 1239Cancelled May 27, 1976 · Smedley Bobby RN6425PPiper PA-24-250 · S/N 24-1535Cancelled May 26, 1976 · Troncoso Carlos AN4522UCessna 150 · S/N 15060522Cancelled May 21, 1976 · Built 1964 · Aviation IncN4759Scheibe BERGFALKE II-55 · S/N 353Cancelled May 21, 1976 · Built 1962 · Tulsa Skyhawks Soaring Club Inc
Back to Tulsa, OK