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.
N140TCCreekmore Thomas D TEAM ROCKET F-1 · S/N 030N3731JCessna 150G · S/N 15065031N9010PPiper PA-24-260 · S/N 24-4471N9044ZRobinson Helicopter R22 · S/N 0114N1062LAdams Balloon A55 · S/N 063N86088Cessna 337D · S/N 337-1073N8646GCessna 150F · S/N 15062746N87755Cessna 337A · S/N 337-0334N87766Hiller UH-12D · S/N 1090N87USPiccard AX-6 · S/N 687N8876EPiper PA-28-181 · S/N 28-7690228N2962MPiper PA-12 · S/N 12-1356N824QBeech 65 · S/N LC-28N8335GCessna 150F · S/N 15062435N8387EMooney M20A · S/N 1586N8522GCessna 150F · S/N 15062622N642CBCessna 421B · S/N 421B0010N8071ECessna 172N · S/N 17272127N81355Fairchild 24W-46 · S/N W46255N817GBeech 65 · S/N LC-31N5435LGrumman American Avn. AA-5 · S/N AA5-0335N714WKCessna 152 · S/N 15279488N777BPDeland-Keller COUGAR I · S/N JPB-1N78USPiccard AX-6 · S/N 678N758PSCessna R172K · S/N R1723257N76388Cessna 140 · S/N 10809N1388KBallard Bobby J QUICKIE I · S/N 0386N731TTCessna P210N · S/N P21000547N73849Cessna 172N · S/N 17267720N7216LPiper PA-25-235 · S/N 25-7405583N418LGCessna 421B · S/N 421B0541N711BRLockheed 18-56 · S/N 2208N68796Cessna 152 · S/N 15282379N6913VMooney M20F · S/N 22-1293N92FChilmonik Robert RV-6A · S/N 20456N67RCCessna T210L · S/N 21059935N6426WPiper PA-28-140 · S/N 28-20496N6169QCessna 152 · S/N 15285181N2114EBeechcraft-Hawker BH-125-600A · S/N 256022N25056Cessna 152 · S/N 15280519N6009NStevens AKRO · S/N 0002BN6052XMooney M20A · S/N 1643N605FLPiper PA-28-140 · S/N 28-7125481N60911Cessna 150J · S/N 15070662N5912VPiper PA-34-200T · S/N 34-7770270N5719TRaven Industries RALLY RX7 · S/N RX7-260N5831CBeech C35 · S/N D-2783N53979Bellanca 7ECA · S/N 1156-76N43191Piper PA-34-200 · S/N 34-7450182N3172Haselwood TEENIE TWO · S/N 510565
Back to Houston, TX