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.
N357MTravel Air S-6000-B · S/N 6B-2018N13994Spartan 7W · S/N 7W-3N232YLockheed ORION 9D · S/N 204N14449Porterfield 35-70 · S/N 119N13992Spartan 7W · S/N 7W-1N14416Beech B17L · S/N B17L-29N145KMono MONOSPORT MODEL ONE · S/N 2011N437WCurtiss Wright TRAVEL AIR 12K · S/N 12K-2003N499WBuckley LC 4 · S/N 1N58YBeech 17R · S/N 17R2N3102Waco GXE · S/N 957N161VTravel Air A-6000-A · S/N 2007N7390Lincoln LINCOLN PAGE 3 · S/N 247N11906Spartan C2-60 · S/N J-13N3347Stinson SM-1 · S/N M-213N431WTravel Air S-6000-B · S/N 6B-2038N270KSpartan C3-120 · S/N 93N8056Spartan C3-120 · S/N 83N8058Spartan C3-120 · S/N 85N8064Spartan C-3 · S/N 91N8050Spartan C3-120 · S/N 78N11460Waco QDC · S/N 3510N1278Lincoln STANDARD 5 · S/N 633N457NTravel Air A-6000-A · S/N 2004N2758Curtiss Wright JN4D · S/N 10N559MHeath PARASOL SPECIAL · S/N 50N8054Spartan C3-120 · S/N 81N8057Spartan C3-120 · S/N 84N2186Waco 9 · S/N 266N2723Curtiss Wright JN4C · S/N 38574N8055Spartan C3-120 · S/N 82N425KFleet 1 · S/N 148N597HButler BLACK HAWK · S/N 108N808YGreat Lakes 2T-1A · S/N 177N702NSpartan C3-165 · S/N 146N865HSpartan C3-165 · S/N 117N109EW S Collier MONOPLANE · S/N 3N571MSpartan C3-165 · S/N 125N8061Spartan C3-120 · S/N 88N8077Spartan C3 · S/N 104N57EDehavilland DH-4B · S/N 395N715NSpartan C3-225 · S/N A-9N10482Spartan C4-300 · S/N B-4N338NFokker SUPER UNIVERSAL · S/N 868N707NSpartan C3-165 · S/N 151N8071Spartan C3-5 · S/N 114N808HSpartan C-3 · S/N 97N4929Spartan C-3 · S/N 58N550VH F Wilcox WILCOX SPORT TRAINER · S/N 100N243HFleet 1 · S/N 111
Back to Tulsa, OK