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.
N4620QCessna 152 · S/N 152-85042N41351Robinson Helicopter R44 II · S/N 12351N761BGCessna T210M · S/N 21062121N8142GCessna 210K · S/N 21059442N761QKCessna T210M · S/N 21062432N584PUCirrus Design SR20 · S/N 2044N585PUCirrus Design SR20 · S/N 2045N582PUCirrus Design SR20 · S/N 2042N456ALGulfstream American G-1159A · S/N 405N788SFDJI INSPIRE 1 · S/N W13DCC23030739N581PUCirrus Design SR20 · S/N 2041N7785ECessna 150 · S/N 17585N52GCYakovlev YAK 52 · S/N 844203N381DECirrus Design SR22 · S/N 4526N38410Piper J5A · S/N 5961N36517Aeronca 65-CA · S/N C16061N7385CCessna 210N · S/N 21063952N25296Cessna 152 · S/N 15280578N950NAGrumman American Avn. G-1159 · S/N 185N475KPCessna 172RG · S/N 172RG0431N5701PPiper PA-24-250 · S/N 24-774N57599Stinson L-5 · S/N 76496N9374CCessna 180 · S/N 31772N117MXCirrus Design SR22T · S/N 0177N93897Engineering & Research 415-C · S/N 1220N45157Ranger Cadet Gyrocopter A · S/N 1N26611Taylorcraft BF · S/N 1953N5828PPiper PA-24-180 · S/N 24-909N5987BCessna 182A · S/N 33987N6111PPiper PA-24-180 · S/N 24-1211N19WGGates Lear Jet 35 · S/N 031N5396WPiper PA-28-160 · S/N 28-464N47410Fairchild M-62A · S/N T423059N274WRolladen-Schneider LS 4A · S/N 4321N584TCDJI INSPIRE 1 · S/N W13DC105040102N3290EAeronca 11AC · S/N 11AC1661N27738Stinson 10A · S/N 7677N46424Cessna 152 · S/N 15283047N31090Piper J3C-65 · S/N 5317N67YCirrus Design SR20 · S/N 1286N2354NCessna 140 · S/N 12600N76PGPiper PA-31-310 · S/N 31-93N43508Taylorcraft BF · S/N 7167N39331Aeronca 65-CA · S/N C18442N708YHDJI PHANTOM 3 PROFESSION · S/N 58456500000006706589041N83631Aeronca 7AC · S/N 7AC2309N71210Luscombe 8A · S/N 2637N154MYDJI PHANTOM 3 PROFESSION · S/N P76DCH07016661N651ZADJI PHANTOM 2 VISION + · S/N PH645468122N9956NCessna T210N · S/N 21063258
Back to Tulsa, OK