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.

N690RCessna 310 · S/N 35249Cancelled Feb 15, 2002 · Triennial form not returned · Built 1956 · Tulsa County Area Vo-Tech Dist 18N6940TCessna 310D · S/N 39240Cancelled Feb 15, 2002 · Triennial form not returned · Built 1960 · Tulsa Cnty Area Vo-Tech Dist #18N3656FBell 47D1 · S/N 307Cancelled Feb 12, 2002 · Triennial form not returned · Built 1959 · Allied Helicopter Svc IncN9766KPiper PA-28R-201T · S/N 28R-7803066Cancelled Jan 14, 2002 · Second triennial mailing, no response · Built 1977 · Yancey Michael DN525ZPiper PA-28 · S/N 28-301Cancelled Jan 10, 2002 · Built 1961 · Stroud Donald JN6607MStinson 108-3 · S/N 108-4607Cancelled Oct 15, 2001 · Second triennial mailing, no response · Built 1948 · Schwarz Scott RN110AESikorsky S-76C · S/N 760385Cancelled Sep 26, 2001 · Exported to South Africa · Lockard Aircraft Sales CoN6712WBeech C23 · S/N M-2251Cancelled Sep 10, 2001 · Triennial form not returned · Tulsair Beechcraft IncN200SLBeech C90A · S/N LJ-1189Cancelled Apr 5, 2001 · Exported to Canada · Sutherland Lumber & Home Center IncN551RHale Greg MINI 500 · S/N 455Cancelled Jan 9, 2001 · Hale GregN3059WBeech V35B · S/N D-9552Cancelled Dec 6, 2000 · Triennial form not returned · A And M EnterprisesN29571Cessna 177 · S/N 17700968Cancelled Nov 15, 2000 · Good Weldon JN494DLSmith H David MARCETTI AVENGER · S/N 1Cancelled Oct 31, 2000 · Triennial form not returned · Smith Herbert DN2872NBeech E50 · S/N 57-6059Cancelled Oct 27, 2000 · Triennial form not returned · Tulsa County Area Voca Tech SchoolN5077NCessna 310 · S/N 38072Cancelled Oct 11, 2000 · Exported to Japan · Air Tulsa IncN2423PPiper PA-38-112 · S/N 38-79A0991Cancelled Sep 16, 2000 · Triennial form not returned · Grosh Donald R DBAN9940LGrumman American Avn. AA-1B · S/N AA1B-0450Cancelled Jul 19, 2000 · Triennial form not returned · Mcvay Jr Sam HN3329APiper PA-22-135 · S/N 22-1604Cancelled Jun 8, 2000 · Mankoff Robert MN425DWRobinson Helicopter R44 · S/N 0222Cancelled Apr 6, 2000 · Exported to Canada · Rubicon Research IncN12085Bell 47G · S/N 829Cancelled Feb 25, 2000 · Triennial form not returned · Allied Helicopter Service IncN100HCBeech A100 · S/N B-229Cancelled Dec 23, 1999 · Exported to Canada · Bristol American Holdings IncN62487Evans Ted C SUPER CAT · S/N 110792Cancelled Sep 30, 1999 · Triennial form not returned · Evans Ted CN60KGMitsubishi MU-2B-30 · S/N 511Cancelled Jun 25, 1999 · Corporate Aviation Services IncN8862PPiper PA-24-260 · S/N 244319Cancelled Oct 8, 1998 · Second triennial mailing, no response · Ugly Johns Custom Boats IncN33322Piper PA-28R-200 · S/N 28R7535134Cancelled Aug 31, 1998 · Triennial form not returned · Shaw H WN147AAMcdonnell Douglas DC-10-10 · S/N 46702Cancelled Aug 11, 1998 · Omni Dc-10 Leasing LLCN4095SBeech C90 · S/N LJ655Cancelled Jun 16, 1998 · Exported to Australia · Pinney Leasing LLCN1680VCessna 120 · S/N 13882Cancelled Jun 15, 1998 · Second triennial mailing, no response · Smith Marcus DN44PAGates Lear Jet 25B · S/N 144Cancelled Jun 4, 1998 · Triennial form not returned · Flight Management IncN4056QBalloon Works FIREFLY 7 · S/N 10075Cancelled May 12, 1998 · Triennial form not returned · Mccollie Carl DN3223QKinsler/Cooper K1K · S/N K1K001Cancelled Jan 8, 1998 · Triennial form not returned · Kinsler Kenneth KN94AAPiper PA-28RT-201 · S/N 28R8118040Cancelled Oct 25, 1997 · Triennial form not returned · Hall William EN28698Beech E50 · S/N 581362Cancelled Aug 26, 1997 · Triennial form not returned · Tulsa Cty Area Vo Tech SchoolN28715Beech E50 · S/N 576033Cancelled Aug 26, 1997 · Triennial form not returned · Tulsa County Area Voca Tech SchoolN2871JBeech E50 · S/N 583052Cancelled Aug 26, 1997 · Triennial form not returned · Tulsa County Area Voca Tech SchoolN93139Cessna 152 · S/N 15285414Cancelled Aug 23, 1997 · Triennial form not returned · Nec Resident Schools Inc DBAN112RSGraves William S MITCHELL WING B-10 · S/N 488Cancelled Jun 11, 1997 · Second triennial mailing, no response · Graves William SN1858GBeech 58P · S/N TJ383Cancelled May 14, 1997 · Exported to Canada · Southwest Aviation Specialties LLCN106TDStephenson Charles R TEENIE TWO · S/N 510674Cancelled Apr 30, 1997 · Second triennial mailing, no response · Stephenson Charles HN74067Bell/Alcopters 47G2 MODIFIED · S/N 1Cancelled Apr 4, 1997 · Triennial form not returned · Allied Helicopter Service IncN182XCessna 182R · S/N 18267956Cancelled Apr 2, 1997 · Triennial form not returned · Wyalkatchem Aviation IncN2558WBeech A36 · S/N E2306Cancelled Feb 5, 1997 · Triennial form not returned · Williford Energy CompanyN94526Cessna 152 · S/N 15285704Cancelled Dec 26, 1996 · Sale reportedN353WGBritish Aerospace BAE 125 SERIES 800A · S/N NA0416Cancelled Dec 12, 1996 · Exported to Canada · Williams Companies IncN98003Cessna 172P · S/N 17276247Cancelled Nov 26, 1996 · Triennial form not returned · Christiansen Aviation IncN25TCPiper PA-31P · S/N 31P7400223Cancelled Oct 25, 1996 · Triennial form not returned · Dutsch Dennis DN105MAMitsubishi MU-2B-20 · S/N 123Cancelled Sep 3, 1996 · Second triennial mailing, no response · Corporate Aviation Services IncN106MAMitsubishi MU-2B-20 · S/N 184Cancelled Sep 3, 1996 · Corporate Aviation Services IncN95012Cessna 152 · S/N 15285837Cancelled Aug 27, 1996 · Exported to Argentina · Christiansen Aviation IncN6487LCessna 152 · S/N 15284415Cancelled Aug 14, 1996 · Exported to United Kingdom · Christiansen Aviation Inc
Back to Tulsa, OK