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.

N3474JCessna 150G · S/N 15066174Cancelled May 12, 1976 · Built 1968 · Aviation IncN531BBeech A35 · S/N D1546Cancelled Mar 4, 1976 · Como Motor CoN22CADouglas DC-7C · S/N 45181Cancelled Jan 21, 1976 · Built 1957 · Concare Aircraft Leasing CorpN7902TCessna 175A · S/N 56602Cancelled Dec 17, 1975 · Horry WilliamN97424Stinson 108 · S/N 108-424Cancelled Oct 16, 1975 · Exported to Canada · Rogers S L And/Or William E NormanN9623LGrumman American Avn. AA-1B · S/N AA1B-0123Cancelled Oct 3, 1975 · Built 1973 · Rivair Flying Service IncN8272PPiper PA-24 · S/N 24-3525Cancelled Sep 25, 1975 · Exported to Canada · Oklahoma Airmen Flying Club IncN5749UPiper PA-28-140 · S/N 28-26572Cancelled Sep 16, 1975 · Exported to Canada · Grosh Donald R DBA Aircraft Service CoN4547QCessna 402B · S/N 402B0344Cancelled Jun 11, 1975 · Exported to Trinidad and Tobago · Built 1973 · Pennant Avaition IncN3584FCessna 150J · S/N 15071055Cancelled Jun 9, 1975 · Built 1969 · Ross School Of Aviation IncN5846GCessna 150K · S/N 15071346Cancelled May 28, 1975 · Aviation IncN50667Cessna 150J · S/N 15069471Cancelled May 8, 1975 · Ross School Of Aviation IncN60033Cessna 150J · S/N 15070020Cancelled May 8, 1975 · Ross School Of Aviation IncN60159Cessna 150J · S/N 15070113Cancelled May 8, 1975 · Ross School Of Aviation IncN819BBeech 95 · S/N TD-117Cancelled Jan 31, 1975 · Tulsair Distributors IncN8953BCessna 172 · S/N 36653Cancelled Dec 5, 1974 · Exported to Canada · Chief Freight Lines Co IncN47CACessna 150J · S/N 15070247Cancelled Nov 8, 1974 · Continental Aviation CoN250ZHurt TERN II · S/N 2072Cancelled Oct 25, 1974 · Hurt Robert DrexelN7729NPiper PA-28-180 · S/N 28-5173Cancelled Aug 20, 1974 · Frederick Jr GordonN13794Piper PA-23-250 · S/N 274442Cancelled Aug 19, 1974 · Exported to Canada · Built 1969 · Waco Aircraft Distributors IncN3573KPiper J3C-65 · S/N 22265Cancelled Jul 31, 1974 · Spartan Aircraft CoN2MHHuffman MODEL-1 · S/N 001Cancelled Jul 29, 1974 · Huffman G MichaelN1574UCessna 207 · S/N 20700174Cancelled Jul 10, 1974 · Exported to Bolivia · Built 1970 · Pennant Aviation IncN123ABeech C18S · S/N BA-465Cancelled Jul 5, 1974 · Ross Aviation IncN76819Cessna 140 · S/N 11251Cancelled Jul 1, 1974 · Selby Geo PN2883QCessna 172L · S/N 17259883Cancelled Jun 19, 1974 · Exported to Canada · Bixby A/C Sales/Tso We Harison JrN40KBeech E18S · S/N BA-160Cancelled Jun 4, 1974 · Great Western Airlines IncN1138YCessna 150B · S/N 15059538Cancelled May 22, 1974 · Spartan Aviation IncN84691Cessna 172K · S/N 17258580Cancelled May 17, 1974 · Exported to Canada · Built 1969 · Sayler Keith FN1018Lot-Airo SCT · S/N 1Cancelled May 16, 1974 · Lotere Manuel MN84910Cessna 172K · S/N 17258664Cancelled May 13, 1974 · Exported to Canada · Built 1969 · Rivair Flying Service IncN1239PPiper PA-23-150 · S/N 23-260Cancelled May 7, 1974 · Built 1955 · Hiroca CorpN4939ZPiper PA-22-108 · S/N 22-8532Cancelled May 7, 1974 · Ross Aviation IncN4035WPiper PA-32-300 · S/N 3240059Cancelled Apr 23, 1974 · Built 1966 · Timmons John DN45388Douglas DC-3A-S1C3G · S/N 7348Cancelled Mar 12, 1974 · Built 1945 · Burnstein StanN5248NSmedley Bobby R L R S -3 · S/N BRS-1Cancelled Mar 11, 1974 · Campbell James RichardN5866GCessna 150K · S/N 15071366Cancelled Feb 11, 1974 · Spartan School Of AeronauticsN7430SSmith AEROSTAR 601 · S/N 61-0015Cancelled Jan 21, 1974 · White Joseph PN7737MMooney M22 · S/N 700004Cancelled Dec 19, 1973 · Built 1970 · Fisher E WN9642FHughes 269C · S/N 1100068Cancelled Dec 19, 1973 · Exported to New Zealand · Great Planes Sales IncN711PCCameron SKYBOLT · S/N PP-1Cancelled Dec 5, 1973 · Built 1973 · Cameron Paul CN9670FHughes 369C · S/N 310099Cancelled Dec 3, 1973 · Exported to New Zealand · Built 1971 · Great Planes Sales IncN67242Stinson L-5 · S/N 1931Cancelled Nov 15, 1973 · Exported to Canada · Hess Charles EN4192UCessna 150D · S/N 15060192Cancelled Aug 10, 1973 · Aviation IncN83187Aeronca 7AC · S/N 7AC-1848Cancelled Aug 7, 1973 · Exported to Canada · Tim Tritt & Don P WilliamsN50778Cessna 150J · S/N 15069547Cancelled Jun 21, 1973 · Kostich Walter &/Or Marguerite KostichN841NSBeech 65-B80 · S/N LD-346Cancelled May 24, 1973 · Ross Aviation IncN111ADDouglas DC-6B · S/N 45539Cancelled Feb 13, 1973 · Exported to Guatemala · Concare Aircraft Leasing CorpN4CABeech 95-A55 · S/N TC-476Cancelled Jan 2, 1973 · Exported to Canada · Built 1963 · Concare Aircraft LeasingN48XSemcraft X-1 GYROCOPTER · S/N 001Cancelled Nov 24, 1972 · Semple William F Jr
Back to Tulsa, OK