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.

N1255YCessna 150B · S/N 15059655Cancelled Oct 27, 1972 · Spartan School Of Aeronautics IncN5651ECessna 150 · S/N 17151Cancelled Oct 27, 1972 · Sparan School AeronauticsN5857ECessna 150 · S/N 17357Cancelled Oct 27, 1972 · Spartan Aviation IncN5995ECessna 150 · S/N 17495Cancelled Oct 27, 1972 · Spartan Aviation IncN7306XCessna 150B · S/N 15059406Cancelled Oct 27, 1972 · Spartan Aviation IncN7864ECessna 150 · S/N 17664Cancelled Oct 27, 1972 · Spartan Aviation IncN60311Cessna 150J · S/N 15070217Cancelled Aug 14, 1972 · Big Heart Pipeline CorpN71503Cessna 182M · S/N 18259645Cancelled Jul 31, 1972 · Totah Aviation IncN8131Denney JEANIES TEENIE · S/N ED-001Cancelled May 11, 1972 · Denny Ernest LN6505NBellanca 14-13-3 · S/N 1623Cancelled Mar 1, 1972 · Built 1949 · Nesmith CulverN45507Douglas DC-6A · S/N 44074Cancelled Feb 28, 1972 · Exported to Colombia · Built 1954 · Concare Aircraft Leasing CorpN1651APiper PA-22 · S/N 22-414Cancelled Feb 25, 1972 · Jones Gary CN12CADouglas DC3C · S/N 12332Cancelled Feb 18, 1972 · Exported to Canada · Stan Burnstein DBA Continental Aviation CoN76029Cessna 140 · S/N 10423Cancelled Dec 3, 1971 · Air Scouters ClubN5222BMooney M20 · S/N 1085Cancelled Oct 4, 1971 · Ace Flyers IncN6323GCessna 150K · S/N 15071823Cancelled Jul 8, 1971 · Spartan School Of AeronauticsN2281BLuscombe 8E · S/N 6708Cancelled Jun 15, 1971 · E J Fitzgerald And B G FitzgeraldN45500Douglas DC-6A · S/N 45500Cancelled Feb 3, 1971 · Exported to Canada · Built 1959 · Concare Aircraft Leasing CorpN5918DPiper PA-22-150 · S/N 22-4580Cancelled Feb 1, 1971 · Ross Aviation IncN6521CDouglas DC-6B · S/N 43521Cancelled Feb 1, 1971 · Exported to Panama · Built 1952 · Concare Aircraft LeasingN1820HCessna 310C · S/N 35920Cancelled Jan 19, 1971 · Aircraft Co Of AmericaN7195PPiper PA-24-250 · S/N PA24-2366Cancelled Jan 18, 1971 · Mclaughlin J HN50605Taylorcraft DCO-65 · S/N L-4598Cancelled Jan 4, 1971 · Jims Flying ClubN42701Piper J3C-65 · S/N 14998Cancelled Dec 31, 1970 · Oklahoma AirmenN15LBensen B-8MC · S/N WC-1Cancelled Dec 1, 1970 · Reckaway Herman HN352WBBeech G50 · S/N GH-102Cancelled Nov 16, 1970 · Exported to Ecuador · Willbros Ecuador CompanyN6518CDouglas DC-6B · S/N 43518Cancelled Oct 28, 1970 · Exported to Panama · Concare Aircraft Leasing CorpN122MDouglas DC-6B · S/N 45078Cancelled Oct 26, 1970 · Exported to El Salvador · Concare Aircraft Leasing CorpN8612WPiper PA-25-235 · S/N 28-10128Cancelled Oct 15, 1970 · Osage Aviation Co IncN6712TCessna 310C · S/N 39012Cancelled Sep 4, 1970 · Missouri Kansas & Oklahoma Coach LinesN5020ZPiper PA-22-108 · S/N 22-8635Cancelled Sep 3, 1970 · Burgess Jerry AN919PDouglas A-26B · S/N 28056Cancelled Aug 19, 1970 · Built 1944 · Neblett Lloyd GN8736WPiper PA-28-235 · S/N 28-10276Cancelled Jul 28, 1970 · Gastineau James WN86525Lockheed 749A-79 · S/N 2662Cancelled Jul 27, 1970 · Concare Aircraft Leasing CorporationN74007Hall CHEROKEE II · S/N MPR-1Cancelled Jul 13, 1970 · Mccallum Robert DN163JDouglas DC3C-S1C3G · S/N 19402Cancelled Jul 8, 1970 · Built 1945 · Burnstein Stan DBA Continental Aviation CoN71830Luscombe 8A · S/N 3257Cancelled Jul 7, 1970 · Yandian SamN5927YPiper PA-23-250 · S/N 27-3087Cancelled Jul 6, 1970 · Great Western Airlines IncN29582Cessna 177 · S/N 17700973Cancelled Jun 29, 1970 · Pennant Aviation IncN6102TCessna 150E · S/N 15060802Cancelled Jun 26, 1970 · Sherman B ElderN7702PPiper PA-24-250 · S/N 24-2914Cancelled Jun 25, 1970 · Ross Leasing Company IncN4855UCessna 210-5A(205A) · S/N 205-0555Cancelled Jun 24, 1970 · Avanti Aviation CoN59565Taylorcraft DC-65 · S/N 6094Cancelled Jun 23, 1970 · Joseph O SchulteN820Beech E18S · S/N BA-185Cancelled Jun 19, 1970 · Built 1956 · Wat Henry Car Leasing Co IncN7156XCessna 150A · S/N 15059256Cancelled Jun 12, 1970 · Sinclair Pipe Line CompanyN399XLockheed 12A · S/N 1223Cancelled Apr 17, 1970 · Built 1937 · Bates Lumber Co IncN45894Luscombe 8A · S/N 2421Cancelled Dec 19, 1969 · Bilimek W CN26613Taylorcraft BL-65 · S/N 1955Cancelled Jun 23, 1966 · Built 1940 · Denny Gilbert TN51706Langley 2-4-90 · S/N 3Cancelled Dec 10, 1965 · John L PierceN720TTemco D-16A · S/N TTN88Cancelled Sep 10, 1965 · Hall J M
Back to Tulsa, OK