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.
N17103Cessna 150L · S/N 15073625N2577FPiper PA-38-112 · S/N 38-79A0486N96868Cessna 172P · S/N 17276125N99515Cessna 172P · S/N 17276458N121BTCessna 421C · S/N 421C0806N3819DBeech 76 · S/N ME-392N3850ABeech 77 · S/N WA-247N5429BCessna 182 · S/N 33429N6782YPiper PA-23-250 · S/N 27-4118N702TSBeech M35 · S/N D-6479N9629XCessna 210B · S/N 21057929N9674UGrumman American Avn. AA-1C · S/N AA1C0093N92252Cessna 182N · S/N 18260112N9240TPiper PA-38-112 · S/N 38-78A0288N9400CPiper PA-28R-201 · S/N 28R-7837196N89100Cessna 140 · S/N 8104N89892Cessna 152 · S/N 15282905N905CLDouglas DC-8-31 · S/N 45274N8853LGrumman American Avn. AA-1B · S/N AA1B-0353N88659Cessna 404 · S/N 404-0208N81MCGates Lear Jet 24F · S/N 344N835CBeech D55 · S/N TE-588N8392QCessna U206F · S/N U20603253N8RJPiper PA-28-180 · S/N 28-7305528N5617KBeech 95-B55 (T42A) · S/N TC-606N3722GBalloon Works FIREFLY 7-B · S/N F7B-087N76541Cessna 140 · S/N 10977N7765Bell-K-Copter 47G · S/N K7015N7774Pinwheel HELICOPTER · S/N RH-1N7800NPiper PA-28-180 · S/N 28-5250N7917XCessna 172B · S/N 17248417N7929ECessna 150 · S/N 17729N741BBeech A35 · S/N D-1747N74316Bellanca 14-13-2 · S/N 1429N7602RCessna R182 · S/N R18200655N7327BBeech E35 · S/N D-3790N732RNCessna T210M · S/N 21061715N150PCCessna 150H · S/N 15067751N68000Douglas DC3C · S/N 13847N67069Convair 440 · S/N 488N3628GBell 47G · S/N 808N6606SCessna 150H · S/N 15067406N6631DBeech C23 · S/N M-2189N6670XCessna 210A · S/N 21057670N7168JSeveren Scott QUICKSILVER MX 2A · S/N 2043N92FZMair F N LITTLE TOOT · S/N FM-2N6318YCessna T210N · S/N 21064335N6320APiper PA-38-112 · S/N 38-78A0384N6369LAmerican AA-1A · S/N AA1A-0369N63900Piper PA-23-250 · S/N 27-7854046
Back to Dallas, TX