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.
N5182Scheutzow B · S/N 103N5269CBeech B35 · S/N D-2663N5524ZPiper PA-22-108 · S/N 22-9312N13RLLindsey CA-65A · S/N 1N4400EHawker Siddeley DH.125-1A · S/N 25026N4808ZPiper PA-22-108 · S/N 22-8377N3528QQuicksilver GT-400 · S/N 2801462N3411Convair 640-340D · S/N 31N34530Aeronca 65-TC · S/N C15181N302SWBoeing 737-3H4 · S/N 22942N26075Piper PA-28-161 · S/N 28-8516087N2700SCessna 414A · S/N 414A0607N2755HAero Commander 680T · S/N 1628N281FPLearjet 24D · S/N 281N28364Douglas DC3A · S/N 4108N2325HBalloon Works FIREFLY 7 · S/N 7739N23384Piper PA-38-112 · S/N 38-81A0120N2381HErcoupe 415-C · S/N 3006N555SGLockheed 1329 · S/N 5090N17GACessna 402 · S/N 402-0139N29NRAerovodochody L-29 DELFIN · S/N 194144N12KVAero Commander 680T · S/N 1675-58N69147North American AT-6D · S/N 88-14152N900ADHawker Siddeley BH.125-400A · S/N NA769N961TXAviat A-1C-180 · S/N 3078N7198URobinson Helicopter R22 BETA · S/N 3251N5470VBeech A36 · S/N E-1712N604TESmith AEROSTAR 600 · S/N 60-0206-091N6542JCessna 172N · S/N 17273887N8096FCessna 150F · S/N 15064196N304FWPiper PA-32R-301T · S/N 32R-8129063N37620Balloon Works FIREFLY 7 · S/N F7-154N311SWBoeing 737-3H4 · S/N 23333N507JRCessna 172N · S/N 17270378N1024VCessna 206H · S/N 20608170N403TECessna 401 · S/N 401-0008N7686CNorth American T-28A · S/N 49-1687N1408PPiper PA-23 · S/N 23-463N56BLGreer William B RUTAN VARIEZE · S/N 1425N7RJHandley Page HP-137 MK1 · S/N 231N80RHHuffman Raymond A BUSHBY MUSTANG II · S/N 494N83WBBowman Willis F AMERICAN EAGLET · S/N 0402N129DMLearjet 24B · S/N 187N99GSAero Commander 1121 · S/N 31N8485XCessna 172C · S/N 17248985N7037SCessna 150H · S/N 15067737N24MLLyeth SHOESTRING K-10 · S/N 27N2547SSouthern Powered Parachutes CONDOR · S/N 6140719N8793BCessna 172 · S/N 36493N9418NPiper PA-28R-200 · S/N 28R-35130
Back to Dallas, TX