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.

N357MTravel Air S-6000-B · S/N 6B-2018Cancelled Feb 9, 1938 · Manning And Martin IncN13994Spartan 7W · S/N 7W-3Cancelled Apr 27, 1937 · Exported to Mexico · Built 1936 · Spartan Aircraft CoN232YLockheed ORION 9D · S/N 204Cancelled Mar 17, 1937 · Exported to Mexico · General Development Co IncN14449Porterfield 35-70 · S/N 119Cancelled Feb 15, 1937 · Exported to Mexico · Built 1935 · Jones Frank LN13992Spartan 7W · S/N 7W-1Cancelled Jan 18, 1937 · Built 1936 · Spartan Aircraft CoN14416Beech B17L · S/N B17L-29Cancelled Sep 26, 1935 · Manning And Terry IncN145KMono MONOSPORT MODEL ONE · S/N 2011Cancelled Aug 20, 1935 · Built 1929 · Collier W SN437WCurtiss Wright TRAVEL AIR 12K · S/N 12K-2003Cancelled Jul 26, 1935 · W S CollierN499WBuckley LC 4 · S/N 1Cancelled Jul 1, 1935 · Fisher Lola VirginiaN58YBeech 17R · S/N 17R2Cancelled Jul 1, 1935 · Loffland Brothers CoN3102Waco GXE · S/N 957Cancelled May 1, 1935 · Built 1927 · Stringer Grady SylvesterN161VTravel Air A-6000-A · S/N 2007Cancelled Aug 31, 1934 · Exported to Mexico · Loffland TomN7390Lincoln LINCOLN PAGE 3 · S/N 247Cancelled Aug 16, 1934 · Built 1916 · Hosler HelenN11906Spartan C2-60 · S/N J-13Cancelled Aug 7, 1934 · Spartan School Of Aeronautics IncN3347Stinson SM-1 · S/N M-213Cancelled Jul 12, 1934 · Iceless Airwing CorpN431WTravel Air S-6000-B · S/N 6B-2038Cancelled Feb 18, 1934 · Built 1931 · Mcanally James BN270KSpartan C3-120 · S/N 93Cancelled Feb 15, 1934 · Exported to Mexico · Spartan School Of Aeronautics IncN8056Spartan C3-120 · S/N 83Cancelled Feb 15, 1934 · Exported to Mexico · Spartan School Of AeronauticsN8058Spartan C3-120 · S/N 85Cancelled Feb 15, 1934 · Exported to Mexico · Spartan School Of Aeronautics IncN8064Spartan C-3 · S/N 91Cancelled Feb 15, 1934 · Exported to Mexico · Spartan School Of Aeronautics IncN8050Spartan C3-120 · S/N 78Cancelled Dec 7, 1933 · Exported to Mexico · Built 1928 · Spartan School Of Aeronautics IncN11460Waco QDC · S/N 3510Cancelled Dec 1, 1933 · Horrall AldenmN1278Lincoln STANDARD 5 · S/N 633Cancelled Jul 26, 1933 · Built 1924 · Cowan J CN457NTravel Air A-6000-A · S/N 2004Cancelled Mar 8, 1933 · Noble Drilling CoN2758Curtiss Wright JN4D · S/N 10Cancelled Feb 10, 1933 · Searle Douglas BN559MHeath PARASOL SPECIAL · S/N 50Cancelled Feb 9, 1933 · W A LewisN8054Spartan C3-120 · S/N 81Cancelled Jan 13, 1933 · Exported to Mexico · Built 1929 · Spartan Aircraft CoN8057Spartan C3-120 · S/N 84Cancelled Sep 13, 1932 · Exported to Mexico · Spartan Aircraft CoN2186Waco 9 · S/N 266Cancelled Jul 16, 1932 · Story S MiltonN2723Curtiss Wright JN4C · S/N 38574Cancelled May 2, 1932 · Barron M WN8055Spartan C3-120 · S/N 82Cancelled Mar 30, 1932 · Exported to Mexico · Built 1929 · Spartan Aircraft CoN425KFleet 1 · S/N 148Cancelled Feb 15, 1932 · Collier W SN597HButler BLACK HAWK · S/N 108Cancelled Oct 15, 1931 · Garland Aircraft CorpN808YGreat Lakes 2T-1A · S/N 177Cancelled Oct 2, 1931 · Dewelles Roy WN702NSpartan C3-165 · S/N 146Cancelled Aug 20, 1931 · Spartan Aircraft CoN865HSpartan C3-165 · S/N 117Cancelled Feb 27, 1931 · Spartan Aircraft CoN109EW S Collier MONOPLANE · S/N 3Cancelled Feb 17, 1931 · Wilcox H FN571MSpartan C3-165 · S/N 125Cancelled Jan 15, 1931 · Built 1929 · Spartan Aircraft CoN8061Spartan C3-120 · S/N 88Cancelled Dec 10, 1930 · Spartan School Of Aeronautics IncN8077Spartan C3 · S/N 104Cancelled Dec 8, 1930 · Spartan Aircraft CompanyN57EDehavilland DH-4B · S/N 395Cancelled Oct 18, 1930 · Built 1918 · Parks Tom D/Safe Way AirlinesN715NSpartan C3-225 · S/N A-9Cancelled Oct 9, 1930 · Skelly Oil CoN10482Spartan C4-300 · S/N B-4Cancelled Sep 19, 1930 · Built 1930 · Spartan Aircraft CoN338NFokker SUPER UNIVERSAL · S/N 868Cancelled Sep 19, 1930 · William Brothers IncN707NSpartan C3-165 · S/N 151Cancelled Aug 22, 1930 · Spartan Aircraft CoN8071Spartan C3-5 · S/N 114Cancelled Aug 1, 1930 · Spartan School Of Aeronautics IncN808HSpartan C-3 · S/N 97Cancelled Apr 25, 1930 · Spartan School Of Aeronautics IncN4929Spartan C-3 · S/N 58Cancelled Apr 18, 1930 · Sparten School Of Aeronautics IncN550VH F Wilcox WILCOX SPORT TRAINER · S/N 100Cancelled Apr 18, 1930 · H F Wilcox Aeronautics IncN243HFleet 1 · S/N 111Cancelled Apr 9, 1930 · Built 1929 · Garland Aircraft Corp
Back to Tulsa, OK