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.
N690RCessna 310 · S/N 35249N6940TCessna 310D · S/N 39240N3656FBell 47D1 · S/N 307N9766KPiper PA-28R-201T · S/N 28R-7803066N525ZPiper PA-28 · S/N 28-301N6607MStinson 108-3 · S/N 108-4607N110AESikorsky S-76C · S/N 760385N6712WBeech C23 · S/N M-2251N200SLBeech C90A · S/N LJ-1189N551RHale Greg MINI 500 · S/N 455N3059WBeech V35B · S/N D-9552N29571Cessna 177 · S/N 17700968N494DLSmith H David MARCETTI AVENGER · S/N 1N2872NBeech E50 · S/N 57-6059N5077NCessna 310 · S/N 38072N2423PPiper PA-38-112 · S/N 38-79A0991N9940LGrumman American Avn. AA-1B · S/N AA1B-0450N3329APiper PA-22-135 · S/N 22-1604N425DWRobinson Helicopter R44 · S/N 0222N12085Bell 47G · S/N 829N100HCBeech A100 · S/N B-229N62487Evans Ted C SUPER CAT · S/N 110792N60KGMitsubishi MU-2B-30 · S/N 511N8862PPiper PA-24-260 · S/N 244319N33322Piper PA-28R-200 · S/N 28R7535134N147AAMcdonnell Douglas DC-10-10 · S/N 46702N4095SBeech C90 · S/N LJ655N1680VCessna 120 · S/N 13882N44PAGates Lear Jet 25B · S/N 144N4056QBalloon Works FIREFLY 7 · S/N 10075N3223QKinsler/Cooper K1K · S/N K1K001N94AAPiper PA-28RT-201 · S/N 28R8118040N28698Beech E50 · S/N 581362N28715Beech E50 · S/N 576033N2871JBeech E50 · S/N 583052N93139Cessna 152 · S/N 15285414N112RSGraves William S MITCHELL WING B-10 · S/N 488N1858GBeech 58P · S/N TJ383N106TDStephenson Charles R TEENIE TWO · S/N 510674N74067Bell/Alcopters 47G2 MODIFIED · S/N 1N182XCessna 182R · S/N 18267956N2558WBeech A36 · S/N E2306N94526Cessna 152 · S/N 15285704N353WGBritish Aerospace BAE 125 SERIES 800A · S/N NA0416N98003Cessna 172P · S/N 17276247N25TCPiper PA-31P · S/N 31P7400223N105MAMitsubishi MU-2B-20 · S/N 123N106MAMitsubishi MU-2B-20 · S/N 184N95012Cessna 152 · S/N 15285837N6487LCessna 152 · S/N 15284415
Back to Tulsa, OK