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.

N79057Douglas DC3C-S1C3G · S/N 10088Cancelled Apr 14, 1950 · Exported to Colombia · Williams Brothers CoN2701EAeronca 7AC · S/N 7AC-6281Cancelled Feb 21, 1950 · Brown Hazel HN9265ACessna 170A · S/N 19026Cancelled Jan 30, 1950 · D-G Aviation SalesN8469ABeech A35 · S/N D-1887Cancelled Sep 2, 1949 · Sinclair Prairie Oil CoN3359VBeech 35 · S/N D-824Cancelled Jun 7, 1949 · Williams Brothers CorpN53730Fairchild M-62A · S/N T42-1645Cancelled Jun 4, 1949 · Built 1942 · Campbell W F And Egger John CN73715North American 047B · S/N 3895Cancelled May 10, 1949 · Aero Exploration CoN73717North American 047B · S/N 51-981Cancelled May 10, 1949 · Aero Exploration CoN73718North American 047B · S/N 51-1032Cancelled May 10, 1949 · Aero Exploration CoN73719North American 047B · S/N 51-103Cancelled May 10, 1949 · Aero Exploration CoN73720North American 047B · S/N 51-1015Cancelled May 10, 1949 · Aero Exploration CoN73721North American 047B · S/N 51-1030Cancelled May 10, 1949 · Aero Exploration CoN73723North American 047B · S/N 51-1022Cancelled May 10, 1949 · Aero Exploration CoN47515Aeronca 0-58B · S/N 058B-10183Cancelled Apr 8, 1949 · Lowe Airmotive IncorporatedN2721VBeech 35 · S/N D-98Cancelled Mar 28, 1949 · Exported to Venezuela · Williams Brothers CoN75566Boeing B75N1 · S/N 75-2673Cancelled Mar 9, 1949 · Built 1941 · Keith L L/Harris J/Southwestern Aero ExchangeN75550Boeing N2S-3 · S/N 75-7978Cancelled Mar 2, 1949 · Poole CharlesN75552Consolidated Vultee BT-13A · S/N 9871Cancelled Feb 21, 1949 · Built 1943 · Johnson Donald CN75565Consolidated Vultee BT-15 · S/N 1156Cancelled Feb 15, 1949 · Mayer Richard BN47759Taylorcraft ST-100 · S/N 6042Cancelled Jan 14, 1949 · Built 1942 · Bassham Carl AN65421Cessna T-50 · S/N 2689Cancelled Jan 2, 1949 · Cooper Fred EN54592Boeing A75N1 · S/N 75-1008Cancelled Dec 30, 1948 · Rainwater Jeral DN53737Consolidated Vultee BT-13A · S/N 2993Cancelled Dec 7, 1948 · Stamps EarlN51793Douglas DC3C · S/N 19276Cancelled Dec 2, 1948 · William Reilly JrN3113KCulver V · S/N V-332Cancelled Nov 24, 1948 · Whitaker Ray BN54589Boeing A75N1 · S/N 75-988Cancelled Nov 15, 1948 · Built 1940 · Mohr C A JrN47543Fairchild M-62A · S/N T42-3671Cancelled Nov 9, 1948 · Spartan Aircraft CoN40170Stinson 108 · S/N 180-100Cancelled Sep 28, 1948 · Virgil CrainN5027NNorth American P-51C · S/N 10226222Cancelled Sep 17, 1948 · Mighton P JN18789Beech D17R · S/N 214Cancelled May 4, 1948 · Built 1938 · Spartan School AeronauticsN16261Aeronca C-3 · S/N 649Cancelled Apr 27, 1948 · Bradie F RN1213Curtiss JN4D · S/N NONECancelled Mar 9, 1948 · Mcintyre D AN94081Ercoupe 415-C · S/N 1404Cancelled Jul 7, 1947 · Spartan Aircraft CompanyN89079Cessna 140 · S/N 8083Cancelled May 15, 1947 · Barry J GN59571Consolidated Vultee BT-13A · S/N 1490Cancelled Oct 24, 1946 · Scott Frank LN21903Beech D17S · S/N 417Cancelled Jan 25, 1945 · Built 1940 · Noble Drilling CorpN28684Fairchild M-62A · S/N T40368Cancelled Nov 17, 1943 · Built 1940 · Spartan Aircraft CoN29002Fairchild M-62A · S/N T40361Cancelled May 3, 1943 · Built 1940 · Spartan Aircraft CoN572MSpartan C3-165 · S/N 126Cancelled Jun 1, 1941 · Spartan Aircraft CoN721NSpartan C3-225 · S/N 155Cancelled May 15, 1941 · Spartan Aircraft CoN17612Spartan 8W · S/N 8W-1Cancelled May 1, 1941 · Spartan Aircraft CoN10483Spartan SPARTAN C4-225 · S/N B-5Cancelled Nov 4, 1940 · Exported to Mexico · Built 1930 · Spartan School Of AeronauticsN17634Spartan NS-1 · S/N 1Cancelled Oct 15, 1940 · Spartan Aircraft CompanyN403WCessna EC-2 · S/N 251Cancelled Oct 1, 1940 · De Witt Ross JrN993NSpartan SPARTAN · S/N D-1Cancelled Oct 1, 1940 · Spartan School Of AeronauticsN13984Spartan 7X · S/N 0Cancelled Nov 15, 1939 · Built 1936 · Spartan Aircraft Co IncN17622Aeronca BL-7AC · S/N B-1Cancelled Jul 1, 1939 · Stewart Charles LouisN17603Spartan 7W · S/N 7W-8Cancelled Sep 28, 1938 · Exported to Mexico · Built 1937 · Spartan Aircraft Co IncN12382Monocoupe MONOCOUPE 90-J · S/N 6J57Cancelled Sep 3, 1938 · Patterson I UN8080Spartan C3 · S/N 108Cancelled Aug 15, 1938 · Lewis Holy Name School Of Aeronautics Inc
Back to Tulsa, OK