Dallas, TX
Cancelled registrations · 2,333
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 = 'TX' AND d.registrant_city = 'DALLAS' 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 = 'TX' AND d.registrant_city = 'DALLAS' 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.
N3935GCessna TU206C · S/N U206-0935N4174PRobinson Helicopter R44 II · S/N 12512N3220QCessna 401 · S/N 401-0020N405TECessna 401 · S/N 401-0121N406TECessna 402B · S/N 402B1366N409TECessna 401A · S/N 401A0118N8736YPiper PA-30 · S/N 30-1890N211VVIndus T-211 THORPEDO · S/N 017SN211ZZIndus T-211 THORPEDO · S/N 0803D0353N1248HPiper PA-28-181 · S/N 28-7790299N12TXDassault-Breguet FALCON 10 · S/N 90N137VGeneva Aerospace DAKOTA · S/N 013N799MDBeech 100 · S/N B8N720JRBoeing 720-047B · S/N 18451N347SWBoeing 737-3H4 · S/N 24374N350SWBoeing 737-3H4 · S/N 24409N334SWBoeing 737-3H4 · S/N 23938N335SWBoeing 737-3H4 · S/N 23939N586WFFreefly Systems ALTA · S/N 2184960513N874BABombardier BD-700-1A11 · S/N 9693N897CWBritish Aerospace BAE 125 SERIES 800A · S/N 258077N2837MPiper PA-12 · S/N 12-1274N89975Cessna 140 · S/N 9027N99359Engineering & Research 415-C · S/N 1982N645SWBoeing 737-3H4 · S/N 28330N646SWBoeing 737-3H4 · S/N 28331N4114CStinson 108 · S/N 1085114N41615Culver LFA · S/N 374N650SWBoeing 737-3H4 · S/N 27720N1766BBoeing A75N1(PT17) · S/N 756682N1753BNorth American F-51D · S/N 12239932N3349BPiper PA-22-135 · S/N 22-2164N84526Aeronca 7AC · S/N 7AC3230N343SWBoeing 737-3H4 · S/N 24151N504SWBoeing 737-5H4 · S/N 24181N505SWBoeing 737-5H4 · S/N 24182N303SWBoeing 737-3H4 · S/N 22943N328SWBoeing 737-3H4 · S/N 23692N342SWBoeing 737-3H4 · S/N 24133N344SWBoeing 737-3H4 · S/N 24152N6501QCessna 152 · S/N 15285264N676SWBoeing 737-3A4 · S/N 23288N2395QBeech 23 · S/N M-474N401JMCessna 210D · S/N 21058348N329SWBoeing 737-3H4 · S/N 23693N313SWBoeing 737-3H4 · S/N 23335N351SWBoeing 737-3H4 · S/N 24572N692SWBoeing 737-3T5 · S/N 23062N69JNRockwell International NA-265-80 · S/N 380-65N1318CPiper PA-22-135 · S/N 22-1114
Back to Dallas, TX