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.
N11039Cessna T182T · S/N T18208638N899ABHawker Siddeley HS.125 SERIES 700A · S/N NA-0230N303SEBritish Aerospace BAE 125 SERIES 800A · S/N 258060N1110NHughes 269C · S/N 611064N37731Bell 47J-2A · S/N 3702N1093NHughes 269C · S/N 100882N3LHGrumman G-1159 · S/N 5N534BCessna T206H · S/N T20609071N7030QCessna 172L · S/N 17260330N189WSGrumman American Avn. G-1159 · S/N 228N20FMHawker Siddeley HS-125-600A · S/N 256058N375DSCessna 525A · S/N 525A0506N875ANBeech 58 · S/N TH-1682N185XXCessna A185E · S/N 1851261N27680Bell Helicopter Textron 206L-1 · S/N 45288N276MBell 206B · S/N 1876N879ACBeech 58 · S/N TH-1777N911NABoeing 747-SR-46 · S/N 20781N277RGGates Learjet 25D · S/N 277N511NANorthrop T-38A · S/N 65-10329N1073ZBell 206B · S/N 2886N1080ARaytheon A36 · S/N E-3025N2327QBeech 23 · S/N M-391N404CGMartin 404 · S/N 14235N5417UBeech 95-C55 · S/N TE-396N6717SBeech 77 · S/N WA-69N2439KPiper PA-38-112 · S/N 38-79A0635N2663FHughes Aero PREDATOR "C" · S/N PC010853W402N30KMCessna 401 · S/N 401-0288N5595Nall COUGAR-1 · S/N 2-1N781KBeech 95-B55 (T42A) · S/N TC-921N111MGGrumman American Avn. AA-1C · S/N AA1C0031N421AMNew Piper PA-28-181 · S/N 2843045N200KSRaven S55A · S/N S55A-932N3175DStarner Grayson D DRAGON FLY · S/N 582N3773WGulfstream American AA-5B · S/N AA5B-1232N10AXStallings Jerry J AIR MASTER 2 · S/N 001N945NAGrumman G-1159 · S/N 118N111ASStone Anthony AZTEZ · S/N 001N16LLockheed 18-56 · S/N 2457N3163Bryant Ray J HURRICANE · S/N 910315N41953Hawker Siddeley HS125 SERIES 400A · S/N 25268N1716SSnow 600 S-2D · S/N 600-1346DN52JWWells Jim R SONERAI-II · S/N 00275N6809MStinson 108-3 · S/N 108-4809N761KQCessna 210M · S/N 21062320N948NAGrumman American Avn. G-1159 · S/N 222N12007Cessna P206D · S/N P206-0586N477WGGulfstream Aerospace G-III · S/N 477N337SMCessna 337G · S/N 33701709
Back to Houston, TX