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.

N77924Luscombe 8A · S/N 3651Cancelled Oct 24, 1955 · Built 1946 · Durham Frank BN43977Taylorcraft BC12-D · S/N 7636Cancelled Oct 21, 1955 · Russell Jr V M & Wolf Jr J EN51721Fairchild M-62A · S/N T43-5657Cancelled Oct 20, 1955 · Hanson Orville GN62158Consolidated Vultee BT-13A · S/N 1763Cancelled Oct 12, 1955 · Bain Edward UN80895Globe GC-1A · S/N 298Cancelled Oct 12, 1955 · Built 1946 · Robertson RandolphN4668NConsolidated Vultee BT-13A · S/N 10511Cancelled Oct 6, 1955 · Harding Donald EN75522Boeing B75N1 · S/N 75-8045Cancelled Aug 23, 1955 · R E LakeN1022PPiper PA-23 · S/N 23-24Cancelled May 19, 1955 · Exported to Venezuela · Sinclair Refining CoN2027NCessna 120 · S/N 12263Cancelled Feb 15, 1955 · Thermotic Engineering CoN57791Taylorcraft DCO-65 · S/N 6116Cancelled Oct 13, 1954 · Bice William E & James T Dunford JrN37947Piper J3C-65 · S/N 6724Cancelled Jul 21, 1954 · Exported to Mexico · Built 1941 · Coe C EN19098Taylorcraft A · S/N 204Cancelled Jul 8, 1954 · Dinius Burnett JN8316HEmigh TROJAN A-2 · S/N 19Cancelled May 5, 1954 · Ray R RebbN1580EAeronca 7AC · S/N 7AC-5147Cancelled Nov 20, 1953 · W M Combs DBA Lee & Combs ServiceN8686KStinson 108-1 · S/N 108-1686Cancelled Apr 15, 1953 · Spartan Aircraft CoN17604Spartan 7W · S/N 9Cancelled Mar 30, 1953 · Built 1937 · Spartan Aircraft CoN3874HErcoupe 415-CD · S/N 4575Cancelled Aug 29, 1952 · Albro Oscar BruceN3532KPiper J3C-65 · S/N 22223Cancelled Aug 21, 1952 · Spartan Aircraft CoN53696Fairchild PT-23 · S/N T40-356Cancelled Mar 20, 1952 · Riggs A LN2903HEngineering & Research ERCOUPE 415-C · S/N 3528Cancelled Feb 1, 1952 · Built 1947 · Brown Airport Sales Service IncN75585Consolidated Vultee BT-15 · S/N 2694Cancelled Feb 1, 1952 · Palmer Alford LowellN53740Piper J3L-65 · S/N 8490Cancelled Dec 27, 1951 · Built 1942 · Testerman Raymond S & Hutcheson Martha PN47511Interstate S-1B1 · S/N 120Cancelled Dec 19, 1951 · Lazy 6 Flying ClubN51358Consolidated Vultee BT-13A · S/N 1172Cancelled Nov 29, 1951 · J N VandeventerN40904Piper J3L-65 · S/N 7594Cancelled Nov 26, 1951 · Built 1941 · Pagan Louis PaganN75574Consolidated Vultee BT-13A · S/N 10139Cancelled Nov 14, 1951 · Built 1943 · Catron LeroyN75591Consolidated Vultee BT-13A · S/N 11236Cancelled Nov 14, 1951 · Shelton J WN15819Cessna C-34 · S/N 311Cancelled Oct 22, 1951 · Lowe Airmotive IncN21960Commonwealth REARWIN 9000-L DELUX · S/N 643-DCancelled Oct 22, 1951 · Built 1939 · Manderfield Edward LN25505Cessna T-50 · S/N 3891Cancelled Oct 22, 1951 · Doll O EN46761Aeronca 0-58B · S/N 058B-5182Cancelled Oct 22, 1951 · Romans Gleason DBA Gleason Flying ServiceN50652Taylorcraft/Bacher Scott N DC0-65/L2M · S/N 4418Cancelled Oct 22, 1951 · Tulsa Flying ServiceN9846Boeing F4B4 · S/N 9251Cancelled Oct 19, 1951 · Built 1929 · Stowell F MN6076KRepublic RC-3 · S/N 256Cancelled Oct 1, 1951 · Spartan Aircraft CoN9792KStinson 108-2 · S/N 108-2792Cancelled Oct 1, 1951 · Dewitt CoN39360Aeronca 65-TAF · S/N 4272Cancelled Sep 5, 1951 · Built 1942 · Air MartN54611Taylorcraft DCO-65 · S/N L-5770Cancelled May 2, 1951 · Mullis John VN72215Cessna 140 · S/N 9388Cancelled Apr 30, 1951 · Stanolind Pipe Line CoN75586Consolidated Vultee BT-13 · S/N 7813Cancelled Apr 30, 1951 · Built 1942 · Michealson Peter HN75594Consolidated Vultee SNV-1 · S/N 6289Cancelled Apr 30, 1951 · Built 1942 · Ross C NN2250EAeronca 7AC · S/N 7AC-5824Cancelled Apr 25, 1951 · Renken Elmer H & George J PearsonN2336MPiper PA-12 · S/N 12-1487Cancelled Apr 25, 1951 · Gleason Flying ServiceN53507Taylorcraft DCO-65 · S/N L-6290Cancelled Mar 22, 1951 · Tulsa Flying ServiceN3962MPiper PA-12 · S/N 12-2844Cancelled Mar 9, 1951 · Romans GleasonN41491Piper J3L-65 · S/N 8129Cancelled Jan 15, 1951 · Spartan Aircraft CoN49294Boeing A75N1 · S/N 75-559Cancelled Oct 6, 1950 · Exported to Mexico · Tulsa Flying ServiceN3571KPiper J3C-65 · S/N 22262Cancelled Sep 14, 1950 · Sellmeyer FrankN54524Cessna UC-78 · S/N 5322Cancelled Sep 5, 1950 · Doll O EN18057Monocoupe 90A · S/N A-766Cancelled May 1, 1950 · Built 1937 · Cloud J WN1663BLuscombe 11A · S/N 11-169Cancelled Apr 26, 1950 · Built 1948 · Harding C M
Back to Tulsa, OK