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.

N3984GCessna 340A · S/N 340A0256Cancelled Oct 12, 2007 · Exported to Canada · Built 1977 · 3984g LLCN277MLLadigo Michael E KR-1 · S/N 002Cancelled Sep 27, 2007 · Triennial form not returned · Ladigo Michael EN1SECessna 180K · S/N 18053027Cancelled Aug 16, 2007 · Triennial form not returned · Built 1978 · Barnes Claudia AN761HACessna T210M · S/N 21062259Cancelled Aug 9, 2007 · Exported to Mexico · Built 1977 · Dan Howard Aircraft Sales IncN351MABeech 200 · S/N BB-359Cancelled Jan 30, 2007 · Exported to Canada · Built 1978 · Old Glory IncN31PECessna 210L · S/N 21059952Cancelled Nov 29, 2006 · Exported to Australia · Built 1973 · Dan Howard Aircraft Sales IncN1151WBell 47G-4 · S/N 3328Cancelled Oct 16, 2006 · Exported to Canada · Built 1964 · Allied Helicopters Internatl IncN64701Bell H-13H · S/N 2066Cancelled Oct 16, 2006 · Exported to Canada · Allied Helicopter Service IncN4796TCessna R182 · S/N R18201767Cancelled Oct 4, 2006 · Exported to Brazil · Built 1981 · Intercontinental Jet IncN5086QCessna 152 · S/N 15285069Cancelled Oct 3, 2006 · Triennial form not returned · Built 1981 · Spartan Aviation Industries IncN124KFChumsae Ray A KITFOX SPEEDSTER · S/N HCS124Cancelled Sep 29, 2006 · Woronko IreneuszN2874ABeech E50 · S/N 56-3700Cancelled Jul 7, 2006 · Triennial form not returned · Tula County Area Vocational Technical SchoolN3127KPiper PA-44-180 · S/N 4496216Cancelled May 23, 2006 · Exported to Australia · Built 2005 · Spartan Aviation Industries Inc DBAN3128APiper PA-44-180 · S/N 4496217Cancelled May 23, 2006 · Exported to Australia · Built 2005 · Spartan Aviation Industries Inc DBAN3124EPiper PA-44-180 · S/N 4496212Cancelled May 22, 2006 · Exported to Australia · Built 2005 · Spartan Aviation Industries Inc DBAN3126LPiper PA-44-180 · S/N 4496215Cancelled May 22, 2006 · Exported to Australia · Built 2005 · Spartan Aviation Industries Inc DBAN48CQGrumman American Avn. G-1159 · S/N 181Cancelled Dec 2, 2005 · Triennial form not returned · Built 1976 · Jet Place IncN27AXGates Lear Jet 24D · S/N 323Cancelled Nov 14, 2005 · Triennial form not returned · Built 1975 · Omni Air International IncN4670BCessna 152 · S/N 15283574Cancelled Oct 14, 2005 · Triennial form not returned · Built 1979 · Spartan Aviation Industries IncN3064GBell 47G-4 · S/N 3151Cancelled Sep 27, 2005 · Exported to Canada · Built 1964 · Allied Helicopter Svc IncN27FVCessna T210N · S/N 21063483Cancelled Sep 7, 2005 · Exported to Mexico · Built 1979 · Rourke Aviation IncN5450TCessna R182 · S/N R18201869Cancelled Jun 22, 2005 · Triennial form not returned · Built 1982 · Bp Pipelines (North America) IncN61082Cirrus Design SR22 · S/N 1421Cancelled Jun 13, 2005 · Exported to South Africa · Ice Dragons International Aviation IncN3624SCessna 172E · S/N 17250824Cancelled May 9, 2005 · Triennial form not returned · Built 1963 · Tulsa County Area Vo Tech School District 18N6PEBeech B200 · S/N BB-856Cancelled May 5, 2005 · Built 1981 · Rnh Air 1 LLCN93168Cessna 210L · S/N 21060291Cancelled Apr 5, 2005 · Exported to Canada · Built 1974 · Dan Howard Aircraft Sales IncN8051LCessna 172H · S/N 17256251Cancelled Feb 8, 2005 · Triennial form not returned · Built 1967 · Tulsa County Area Vo TechN215CWCessna 550 · S/N 550-0155Cancelled Feb 3, 2005 · Exported to Canada · Fox Flite IncN143AAMcdonnell-Douglas DC-10-30 · S/N 46555Cancelled Jan 4, 2005 · Triennial form not returned · Omni Air International IncN502CABeech 58P · S/N TJ-354Cancelled Dec 23, 2004 · Exported to Canada · Built 1981 · Fox Flite IncN12080Mcdonnell-Douglas DC-10-30 · S/N 47981Cancelled Dec 3, 2004 · Sale reportedN318CDBritish Aerospace HS 125-700B · S/N 257136Cancelled Nov 17, 2004 · Exported to Aruba · Built 1981 · Jito Investments LLCN251MMitsubishi MU-2B · S/N 013Cancelled Apr 1, 2004 · Built 1966 · International Business Aircraft IncN4903YCessna 210N · S/N 21064037Cancelled Mar 25, 2004 · Exported to Australia · Built 1980 · Dan Howard Aircraft Sales IncN360AXMcdonnell Douglas DC-10-10 · S/N 46706Cancelled Feb 13, 2004 · Triennial form not returned · Built 1972 · Omni Dc-10 Leasing LLCN6550VAerostar International RAVEN S57-A · S/N S57A-3008Cancelled Feb 7, 2004 · Triennial form not returned · Built 1987 · Mosher James LN8329BRobinson Helicopter R44 · S/N 0219Cancelled Dec 24, 2003 · Triennial form not returned · Built 1995 · Stokely Helicopter Services IncN325VBritish BAC 1-11 401/AK · S/N BAC.086Cancelled Dec 8, 2003 · Exported to Cayman Islands · Built 1966 · Jet Place IncN15CACessna 421A · S/N 421A0111Cancelled Aug 19, 2003 · Second triennial mailing, no response · Built 1969 · Stevenson Red DBAN5088NFairchild M-62A · S/N 4333688Cancelled Jul 25, 2003 · Registration revoked · Brown Waterman F JrN770TCCessna 208 · S/N 20800014Cancelled Jun 10, 2003 · Exported to Venezuela · Built 1985 · Mach Aero International CorpN1220KLuscombe 8A · S/N 3947Cancelled May 5, 2003 · Triennial form not returned · Built 1946 · Blue Sky IncN5812FCessna 210F · S/N 21058812Cancelled Apr 16, 2003 · Built 1966 · Dan Howard Aircraft SalesincN107CBBellanca 17-31ATC · S/N 73-31051Cancelled Apr 9, 2003 · Second triennial mailing, no response · Built 1973 · Schiller John PN424CRBeech 200 · S/N BB-347Cancelled Mar 19, 2003 · Exported to Canada · Built 1978 · Sar Aviation LLCN95AFSchweizer 269C · S/N S1574Cancelled Jul 31, 2002 · Exported to Canada · Built 1991 · Tsp IncN63SSSchweizer 269C · S/N S1519Cancelled Jul 29, 2002 · Exported to Canada · T S P IncN93187Cessna 152 · S/N 15285434Cancelled May 15, 2002 · Triennial form not returned · Built 1981 · Christiansen Aviation IncN89099Cessna 152 · S/N 15283010Cancelled Apr 10, 2002 · Exported to Mexico · Built 1978 · Air Tulsa IncN114HCGates Lear Jet 25B · S/N 114Cancelled Mar 1, 2002 · Exported to Mexico · Built 1973 · N114hc LLC
Back to Tulsa, OK