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.

N757WACessna 152 · S/N 15280051Cancelled Aug 14, 1996 · Exported to United Kingdom · Christiansen Aviation IncN95493Cessna 152 · S/N 15285905Cancelled Aug 14, 1996 · Exported to United Kingdom · Christiansen Aviation IncN12GPBeech A36 · S/N E1786Cancelled Aug 8, 1996 · Exported to Chile · Conklin GaryN8173MPebbles Richard D CHRISTAVIA · S/N 443Cancelled Jun 18, 1996 · Pebbles Richard DN312RSBell 206B-III · S/N 2999Cancelled Jun 7, 1996 · Triennial form not returned · Lori IncN8770NPiper PA-28-140 · S/N 2825593Cancelled Nov 15, 1995 · Triennial form not returned · Shaw H WN49431Cessna 152 · S/N 15281261Cancelled Oct 18, 1995 · Triennial form not returned · Wood Michael LN600TPHughes Helicopters 369E · S/N 0128ECancelled Sep 5, 1995 · Exported to Canada · City Of Tulsa OklahomaN1976TPiper PA-28-181 · S/N 287690462Cancelled Jul 26, 1995 · Second triennial mailing, no response · Sittler Charles AN2318PPiper PA-38-112 · S/N 3879A0943Cancelled Jul 19, 1995 · Exported to New Zealand · Haywood Floyd ON6013NCessna 210M · S/N 21062881Cancelled Jun 29, 1995 · Exported to Brazil · Class Aivation IncN65HSBell 206B · S/N 1206Cancelled Jun 19, 1995 · Exported to Canada · Siegfried IncN7636UBoeing 727-222 · S/N 19909Cancelled Mar 2, 1995 · Omni Air Express IncN425JADassault/Sud FAN JET FALCON · S/N 51Cancelled Oct 18, 1994 · Triennial form not returned · Bizjet Intl Sales And Support IncN702FNMitsubishi MU-2B-25 · S/N 249Cancelled Aug 17, 1994 · Corporate Aviation Services IncN106DPMitsubishi MU-2B-35 · S/N 571Cancelled Jul 25, 1994 · Sidney 1 CorporationN17610Goodhead George COLLIER AMBASSADOR-1 · S/N 101Cancelled Jul 18, 1994 · Triennial form not returned · Goodhead George EN8840ABeech 300 · S/N FA182Cancelled Jun 23, 1994 · Exported to Canada · Parker Aviation IncN727DMMitsubishi MU-2B-25 · S/N 242Cancelled Jun 14, 1994 · Corporate Aviation Services IncN39RECessna 500 · S/N 5000311Cancelled Apr 29, 1994 · Exported to Sweden · Great Planes Sales IncN800TPHughes Helicopters HUGHES 369D · S/N 610993DCancelled Jan 14, 1994 · Exported to Canada · City Of Tulsa OklahomaN681WWWright Richard C W A R P47 · S/N 102Cancelled Nov 2, 1993 · Wright Richard CN7633UBoeing 727-222 · S/N 19906Cancelled Sep 24, 1993 · Continental Air Transport Co DBAN4608TCessna R182 · S/N R18201717Cancelled Sep 7, 1993 · Exported to Canada · Dutsch D DN4202MMitsubishi MU-2B-35 · S/N 628Cancelled Apr 26, 1993 · Exported to Canada · International Business Aircraft IncN96108Helio H-395 · S/N 635Cancelled Jan 8, 1993 · Exported to MexicoN761TACessna A152 · S/N A1520984Cancelled Dec 9, 1992 · Exported to Austria · Christiansen Aviation IncN94817Cessna 152 · S/N 15285793Cancelled Dec 9, 1992 · Exported to Austria · Christiansen Aviation IncN73571Cessna 172M · S/N 17267548Cancelled Dec 8, 1992 · Adams Judith KN5381BCessna 182 · S/N 33381Cancelled Oct 19, 1992 · Onyon James DN82089Harrigill Richard B HAGSRAG · S/N 0001Cancelled Oct 16, 1992 · Triennial form not returned · Harrigill Richard BN6633YPiper PA-23-250 · S/N 273945Cancelled Sep 16, 1992 · Triennial form not returned · F & S Investment CorpN756ERCessna TU206G · S/N U20604036Cancelled Aug 25, 1992 · Exported to Mexico · R B Aircraft LtdN608RGrumman G-159 · S/N 103Cancelled Aug 5, 1992 · Exported to Brazil · Great Planes Sales IncN71FNSwearingen SA-226T · S/N T384Cancelled Jul 20, 1992 · Exported to Venezuela · Tulsa Dental Products IncN11753Cessna 150L · S/N 15075613Cancelled Mar 23, 1992 · Triennial form not returned · National Education CenterN4205KNavion NAVION A · S/N NAV41205Cancelled Mar 17, 1992 · Triennial form not returned · George E Harris And Co IncN7062FCessna 150F · S/N 15063662Cancelled Feb 21, 1992 · Triennial form not returned · National Education CenterN18XRockwell International NA-265-60 · S/N 306137Cancelled Feb 7, 1992 · Exported to Mexico · Great Planes Sales IncN577NKBeech 65-90 · S/N LJ80Cancelled Jan 24, 1992 · Exported to South Africa · Sky KingN2024ECessna 172N · S/N 17271122Cancelled Nov 6, 1991 · Exported to Germany · T T M Inc DBAN2037JStiles Casey MONOFUN · S/N 0001Cancelled Oct 30, 1991 · Stiles Casey CN19083Cessna 150L · S/N 15074154Cancelled Oct 15, 1991 · Second triennial mailing, no response · Griffin William HN101ADHawker Siddeley BH.125-400A · S/N NA777Cancelled Sep 4, 1991 · Bizjet International Sales & SupportN64474Cessna 172M · S/N 17265255Cancelled May 23, 1991 · Exported to Germany · Transportation Locators LtdN94324Cessna 152 · S/N 15285649Cancelled May 6, 1991 · Triennial form not returned · National Education CenterN9235ZPiper PA-32-300 · S/N 3240368Cancelled Apr 17, 1991 · Triennial form not returned · Stiner Roy EdgarN11AUAeromet AURA · S/N 001Cancelled Apr 1, 1991 · Triennial form not returned · Aeromet IncN94370Cessna 152 · S/N 15285657Cancelled Mar 27, 1991 · Triennial form not returned · National Education CenterN2381BPiper PA-38-112 · S/N 3879A0030Cancelled Mar 26, 1991 · Triennial form not returned · Grosh Donald R DBA
Back to Tulsa, OK