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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N79057Douglas DC3C-S1C3G · S/N 10088N2701EAeronca 7AC · S/N 7AC-6281N9265ACessna 170A · S/N 19026N8469ABeech A35 · S/N D-1887N3359VBeech 35 · S/N D-824N53730Fairchild M-62A · S/N T42-1645N73715North American 047B · S/N 3895N73717North American 047B · S/N 51-981N73718North American 047B · S/N 51-1032N73719North American 047B · S/N 51-103N73720North American 047B · S/N 51-1015N73721North American 047B · S/N 51-1030N73723North American 047B · S/N 51-1022N47515Aeronca 0-58B · S/N 058B-10183N2721VBeech 35 · S/N D-98N75566Boeing B75N1 · S/N 75-2673N75550Boeing N2S-3 · S/N 75-7978N75552Consolidated Vultee BT-13A · S/N 9871N75565Consolidated Vultee BT-15 · S/N 1156N47759Taylorcraft ST-100 · S/N 6042N65421Cessna T-50 · S/N 2689N54592Boeing A75N1 · S/N 75-1008N53737Consolidated Vultee BT-13A · S/N 2993N51793Douglas DC3C · S/N 19276N3113KCulver V · S/N V-332N54589Boeing A75N1 · S/N 75-988N47543Fairchild M-62A · S/N T42-3671N40170Stinson 108 · S/N 180-100N5027NNorth American P-51C · S/N 10226222N18789Beech D17R · S/N 214N16261Aeronca C-3 · S/N 649N1213Curtiss JN4D · S/N NONEN94081Ercoupe 415-C · S/N 1404N89079Cessna 140 · S/N 8083N59571Consolidated Vultee BT-13A · S/N 1490N21903Beech D17S · S/N 417N28684Fairchild M-62A · S/N T40368N29002Fairchild M-62A · S/N T40361N572MSpartan C3-165 · S/N 126N721NSpartan C3-225 · S/N 155N17612Spartan 8W · S/N 8W-1N10483Spartan SPARTAN C4-225 · S/N B-5N17634Spartan NS-1 · S/N 1N403WCessna EC-2 · S/N 251N993NSpartan SPARTAN · S/N D-1N13984Spartan 7X · S/N 0N17622Aeronca BL-7AC · S/N B-1N17603Spartan 7W · S/N 7W-8N12382Monocoupe MONOCOUPE 90-J · S/N 6J57N8080Spartan C3 · S/N 108
Back to Tulsa, OK