Houston, TX
Cancelled registrations · 2,439
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 = 'HOUSTON' 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 = 'HOUSTON' 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.
N442MTCessna 337A · S/N 337-0331N80151Beech D18S · S/N A-116N225CFGates Learjet 35A · S/N 225N5461GCessna 404 · S/N 404-0078N72849Cessna 140 · S/N 10036N81953Aeronca 7AC · S/N 7AC578N5729QRaven S-50A · S/N S50A-287N802ACSwearingen SA26-T · S/N T26-21N2504GCessna 182B · S/N 51804N26869Gulfstream American AA-5A · S/N AA5A0775N3858KPiper PA-28-140 · S/N 28-23751N5681KMooney M20J · S/N 24-1398N8294TPiper PA-28-161 · S/N 28-8316012N2909WCameron Balloons O-77 · S/N 5045N303GMGulfstream AM Corp Comm Div 695A · S/N 96042N3278XJohnson Douglas R ROTEC RALLY 3-B · S/N 64625N37550Ottmer James M BENSEN B8M · S/N 9116N3785WWhite Glen A QUICKSILVER MX II · S/N 1200N993DStinson 108-2 · S/N 108-2993N99959Let BLANIK L-13 · S/N 025916N2508EGeneral Balloon AX-6 · S/N 513N25HTSeipman Allan Paul BABY ACE D · S/N BA25DMN94796Ercoupe 415-E · S/N 4909N951DStinson 108-2 · S/N 108-2951N95417Piper PA-28-140 · S/N 28-25935N60784Cessna 150J · S/N 15070577N84620Miller MODEL A · S/N 2577N8802GCessna 150F · S/N 15062902N8826BCessna 172 · S/N 36526N894BMooney M20 · S/N 1057N9014YPiper PA-31-310 · S/N 31-19N80777Globe GC-1B · S/N 180N7330FPiper PA-28-140 · S/N 28-25068N736HJCessna R172K · S/N R1722537N7374BBeech E35 · S/N D-3837N7397NCessna 182P · S/N 18263180N700EHBell 206B · S/N 2273N3610FBeech D-50 · S/N DH-55N64927Cessna 152 · S/N 15281480N6510SCessna 150H · S/N 15067310N662BAero Commander 680FL · S/N 1347-28N61517Piper PA-31-350 · S/N 31-7552021N69TTCrane C W T2 · S/N 01N362YLSikorsky S-58 · S/N 581336N411GAHawker Siddeley HS-125-600A · S/N 256024N43767Piper PA-32R-300 · S/N 32R-7780525N33510Bell 47G · S/N 52-7879N3984KPiper PA-28-140 · S/N 28-23873N4166Mooney M-18C 55 · S/N 331N70HMMills Howard E LONG-EZ · S/N 283
Back to Houston, TX