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.
N757WACessna 152 · S/N 15280051N95493Cessna 152 · S/N 15285905N12GPBeech A36 · S/N E1786N8173MPebbles Richard D CHRISTAVIA · S/N 443N312RSBell 206B-III · S/N 2999N8770NPiper PA-28-140 · S/N 2825593N49431Cessna 152 · S/N 15281261N600TPHughes Helicopters 369E · S/N 0128EN1976TPiper PA-28-181 · S/N 287690462N2318PPiper PA-38-112 · S/N 3879A0943N6013NCessna 210M · S/N 21062881N65HSBell 206B · S/N 1206N7636UBoeing 727-222 · S/N 19909N425JADassault/Sud FAN JET FALCON · S/N 51N702FNMitsubishi MU-2B-25 · S/N 249N106DPMitsubishi MU-2B-35 · S/N 571N17610Goodhead George COLLIER AMBASSADOR-1 · S/N 101N8840ABeech 300 · S/N FA182N727DMMitsubishi MU-2B-25 · S/N 242N39RECessna 500 · S/N 5000311N800TPHughes Helicopters HUGHES 369D · S/N 610993DN681WWWright Richard C W A R P47 · S/N 102N7633UBoeing 727-222 · S/N 19906N4608TCessna R182 · S/N R18201717N4202MMitsubishi MU-2B-35 · S/N 628N96108Helio H-395 · S/N 635N761TACessna A152 · S/N A1520984N94817Cessna 152 · S/N 15285793N73571Cessna 172M · S/N 17267548N5381BCessna 182 · S/N 33381N82089Harrigill Richard B HAGSRAG · S/N 0001N6633YPiper PA-23-250 · S/N 273945N756ERCessna TU206G · S/N U20604036N608RGrumman G-159 · S/N 103N71FNSwearingen SA-226T · S/N T384N11753Cessna 150L · S/N 15075613N4205KNavion NAVION A · S/N NAV41205N7062FCessna 150F · S/N 15063662N18XRockwell International NA-265-60 · S/N 306137N577NKBeech 65-90 · S/N LJ80N2024ECessna 172N · S/N 17271122N2037JStiles Casey MONOFUN · S/N 0001N19083Cessna 150L · S/N 15074154N101ADHawker Siddeley BH.125-400A · S/N NA777N64474Cessna 172M · S/N 17265255N94324Cessna 152 · S/N 15285649N9235ZPiper PA-32-300 · S/N 3240368N11AUAeromet AURA · S/N 001N94370Cessna 152 · S/N 15285657N2381BPiper PA-38-112 · S/N 3879A0030
Back to Tulsa, OK