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.

N10003Spartan C-3 · S/N 73Cancelled Mar 20, 1930 · Spartan School Of Aeronautics IncN4018Curtiss Airplane & Motor CURTISS JN · S/N 44410Cancelled Mar 14, 1930 · Mcintyre D AN66ESpartan C3-120 · S/N 80Cancelled Feb 28, 1930 · Spartan School Of Aeronautics IncN9532Waco 10 · S/N A-30Cancelled Feb 20, 1930 · Martin Truman JN579KSpartan C3-120 · S/N 503Cancelled Jan 16, 1930 · Spartan School Of Aeronautics IncN408KFleet 1 · S/N 131Cancelled Dec 19, 1929 · Built 1929 · Garland Aircraft CorporationN4208Spartan C-3 · S/N 57Cancelled Oct 11, 1929 · Built 1928 · Sparten Aircraft Company IncN8078Spartan SPARTAN · S/N 106Cancelled Aug 30, 1929 · Spartan Aircraft CoN1557Advance WACO 10 · S/N 899Cancelled Aug 16, 1929 · Summit Drilling CompanyN6254Stearman C3-B · S/N 147Cancelled Aug 16, 1929 · The Mid Continent Airways IncN7892Roy Wallace LINCOLN SPORT · S/N 135Cancelled Jul 30, 1929 · Wallace RoyN9227Curtiss Robertson Airplane Mfg CURTISS ROBIN · S/N 300Cancelled May 24, 1929 · Garland-Clevenger Aircraft CorpN2327Swallow Aeroplane Mfg LAND PLANE · S/N 594Cancelled Apr 15, 1927 · Chouteau Stewart JamesN1897KLuscombe 8E · S/N 4624Cancellation date not recorded · Dossey James GN270FCorben JR. Ace E · S/N 1Cancellation date not recorded · John E FieldN4785PPiper PA-23-250 · S/N 27-341Cancellation date not recorded · Aircraft Company Of AmericaN57815Cessna T-50 · S/N 4930Cancellation date not recorded · Southwestern Aero ExchangeN65419Lockheed P-38 · S/N 8206Cancellation date not recorded · Ortman Mighton Aviation CoN65470Cessna UC-78 · S/N 2639Cancellation date not recorded · Stamps EarlN65474Cessna T-50 · S/N 2728Cancellation date not recorded · Rainbow EdN6LLockheed 18-56 · S/N 2424Cancellation date not recorded · Parker Drilling Co
Back to Tulsa, OK