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.
N1255YCessna 150B · S/N 15059655N5651ECessna 150 · S/N 17151N5857ECessna 150 · S/N 17357N5995ECessna 150 · S/N 17495N7306XCessna 150B · S/N 15059406N7864ECessna 150 · S/N 17664N60311Cessna 150J · S/N 15070217N71503Cessna 182M · S/N 18259645N8131Denney JEANIES TEENIE · S/N ED-001N6505NBellanca 14-13-3 · S/N 1623N45507Douglas DC-6A · S/N 44074N1651APiper PA-22 · S/N 22-414N12CADouglas DC3C · S/N 12332N76029Cessna 140 · S/N 10423N5222BMooney M20 · S/N 1085N6323GCessna 150K · S/N 15071823N2281BLuscombe 8E · S/N 6708N45500Douglas DC-6A · S/N 45500N5918DPiper PA-22-150 · S/N 22-4580N6521CDouglas DC-6B · S/N 43521N1820HCessna 310C · S/N 35920N7195PPiper PA-24-250 · S/N PA24-2366N50605Taylorcraft DCO-65 · S/N L-4598N42701Piper J3C-65 · S/N 14998N15LBensen B-8MC · S/N WC-1N352WBBeech G50 · S/N GH-102N6518CDouglas DC-6B · S/N 43518N122MDouglas DC-6B · S/N 45078N8612WPiper PA-25-235 · S/N 28-10128N6712TCessna 310C · S/N 39012N5020ZPiper PA-22-108 · S/N 22-8635N919PDouglas A-26B · S/N 28056N8736WPiper PA-28-235 · S/N 28-10276N86525Lockheed 749A-79 · S/N 2662N74007Hall CHEROKEE II · S/N MPR-1N163JDouglas DC3C-S1C3G · S/N 19402N71830Luscombe 8A · S/N 3257N5927YPiper PA-23-250 · S/N 27-3087N29582Cessna 177 · S/N 17700973N6102TCessna 150E · S/N 15060802N7702PPiper PA-24-250 · S/N 24-2914N4855UCessna 210-5A(205A) · S/N 205-0555N59565Taylorcraft DC-65 · S/N 6094N820Beech E18S · S/N BA-185N7156XCessna 150A · S/N 15059256N399XLockheed 12A · S/N 1223N45894Luscombe 8A · S/N 2421N26613Taylorcraft BL-65 · S/N 1955N51706Langley 2-4-90 · S/N 3N720TTemco D-16A · S/N TTN88
Back to Tulsa, OK