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.
N8445QCessna TU206F · S/N U20603303N46009Cessna 152 · S/N 15282983N46073Cessna 152 · S/N 15282994N47125Cessna 152 · S/N 152-83175N75KABeech 200 · S/N BB100N4683UCessna U206G · S/N U20605053N69439Cessna 340 · S/N 3400259N5306UCessna U206G · S/N U20605187N89686Cessna 152 · S/N 15282826N46463Cessna 152 · S/N 15283054N68153Cessna 152 · S/N 15282151N4085CCessna T310R · S/N 310R1366N8028UDouglas DC-8-21 · S/N 45297N5NWMitsubishi MU-2B-35 · S/N 597N68187Cessna 152 · S/N 152-82172N75854Cessna 172N · S/N 17268002N97022Cessna 182Q · S/N 18266939N68169Cessna 152 · S/N 15282161N9890ECessna 172N · S/N 17272284N8566QCessna TU206F · S/N U20603422N6512NCessna 210N · S/N 21063077N733EFCessna U206G · S/N U20604760N8547GCessna 310R · S/N 310R0935N153AFDouglas DC-8-54 · S/N 45682N25040Cessna 152 · S/N 15280512N95629Cessna 182Q · S/N 18266583N2694CCessna R182 · S/N R18200217N94412Cessna 182Q · S/N 18266425N8949FPiper PA-28-151 · S/N 28-7715296N9837CCessna R182 · S/N R18200457N1795XCessna 210L · S/N 21060815N761WECessna 210M · S/N 21062570N739MUCessna 172N · S/N 17270657N67529Cessna 152 · S/N 15281894N67538Cessna 152 · S/N 15281900N67742Cessna 152 · S/N 15281989N739EMCessna 172N · S/N 17270485N759SHCessna 182Q · S/N 18266219N94550Cessna 182Q · S/N 18266444N73821Cessna 172N · S/N 172-6770N756LGCessna U206G · S/N U20604171N80143Cessna 172M · S/N 17266399N732HYCessna 210L · S/N 21061537N759SFCessna 182Q · S/N 18266217N80558Cessna 172M · S/N 66652N88680Cessna 404 · S/N 404-0219N756TGCessna U206G · S/N U20604339N756RJCessna U206G · S/N U20604293N1185QCessna A185F · S/N 18503468N5376RCessna 172M · S/N 17263528
Back to Tulsa, OK