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.

N11039Cessna T182T · S/N T18208638Cancelled Nov 16, 2016 · Exported to Belize · Built 2006 · Schulte Steve PaulN899ABHawker Siddeley HS.125 SERIES 700A · S/N NA-0230Cancelled Oct 3, 2016 · Exported to Mexico · Projets IncN303SEBritish Aerospace BAE 125 SERIES 800A · S/N 258060Cancelled Sep 30, 2016 · Projets IncN1110NHughes 269C · S/N 611064Cancelled Sep 8, 2016 · Third renewal notice · Built 1981 · Go Helicopters IncN37731Bell 47J-2A · S/N 3702Cancelled Sep 8, 2016 · Registration pending, canceled · Built 1965N1093NHughes 269C · S/N 100882Cancelled Sep 1, 2016 · Third renewal notice · Built 1980 · Go Helicopters IncN3LHGrumman G-1159 · S/N 5Cancelled Aug 26, 2016 · Built 1968 · Lockton Enterprises IncN534BCessna T206H · S/N T20609071Cancelled Jul 20, 2016 · Exported to Mexico · Built 2012 · Tejas Aviation Services IncN7030QCessna 172L · S/N 17260330Cancelled Jul 12, 2016 · Built 1971 · Phillips Dwight WN189WSGrumman American Avn. G-1159 · S/N 228Cancelled May 3, 2016 · Third renewal notice · Built 1978 · Demovial LLCN20FMHawker Siddeley HS-125-600A · S/N 256058Cancelled Mar 16, 2016 · Third renewal notice · Built 1976 · Hawker N20fm LLCN375DSCessna 525A · S/N 525A0506Cancelled Jan 15, 2016 · Exported to United Kingdom · Built 2013 · Starbase Aviation LLCN875ANBeech 58 · S/N TH-1682Cancelled Jan 6, 2016 · Exported to Paraguay · Built 1993 · West Houston Airport CorpN185XXCessna A185E · S/N 1851261Cancelled Dec 23, 2015 · Third renewal notice · Hoelke Frederick FN27680Bell Helicopter Textron 206L-1 · S/N 45288Cancelled Oct 20, 2015 · Third renewal notice · Horizon Helicopters IncN276MBell 206B · S/N 1876Cancelled Oct 19, 2015 · Third renewal notice · Horizon Helicopters IncN879ACBeech 58 · S/N TH-1777Cancelled Oct 8, 2015 · Exported to Paraguay · Built 1996 · West Houston Airport CorpN911NABoeing 747-SR-46 · S/N 20781Cancelled Sep 28, 2015 · Third renewal notice · Built 1973 · National Aeronautics And Space AdministrationN277RGGates Learjet 25D · S/N 277Cancelled May 22, 2015 · Exported to Mexico · Aronson Aircraft And Marine Service IncN511NANorthrop T-38A · S/N 65-10329Cancelled May 21, 2015 · Registration expired, pending cancellation · Built 1969 · National Aeronautics And Space AdministrationN1073ZBell 206B · S/N 2886Cancelled May 20, 2015 · Registration expired, pending cancellation · Built 1979 · Behne Edward LN1080ARaytheon A36 · S/N E-3025Cancelled May 20, 2015 · Registration expired, pending cancellation · Built 1996 · Litz Aviation LLCN2327QBeech 23 · S/N M-391Cancelled May 20, 2015 · Registration expired, pending cancellation · Built 1963 · Hassanein Hany EsmatN404CGMartin 404 · S/N 14235Cancelled May 20, 2015 · Registration expired, pending cancellation · Built 1952 · Eastern Martin LLCN5417UBeech 95-C55 · S/N TE-396Cancelled May 19, 2015 · Registration expired, pending cancellation · Built 1967 · Martinez Leonidas SanchezN6717SBeech 77 · S/N WA-69Cancelled May 19, 2015 · Registration expired, pending cancellation · Built 1979 · Ware StevenN2439KPiper PA-38-112 · S/N 38-79A0635Cancelled May 15, 2015 · Registration expired, pending cancellation · Built 1979 · Guthrie Larry CN2663FHughes Aero PREDATOR "C" · S/N PC010853W402Cancelled May 15, 2015 · Registration expired, pending cancellation · Built 2008 · Hughes Scott AN30KMCessna 401 · S/N 401-0288Cancelled May 15, 2015 · Registration expired, pending cancellation · Built 1968 · Circle E Aviation LLCN5595Nall COUGAR-1 · S/N 2-1Cancelled May 15, 2015 · Registration expired, pending cancellation · Built 1976 · Cowan Carl GN781KBeech 95-B55 (T42A) · S/N TC-921Cancelled May 11, 2015 · Registration expired, pending cancellation · Built 1965 · Worldwide Business Consultants IncN111MGGrumman American Avn. AA-1C · S/N AA1C0031Cancelled May 8, 2015 · Registration expired, pending cancellation · Built 1977 · Gallien Matthew J JrN421AMNew Piper PA-28-181 · S/N 2843045Cancelled May 8, 2015 · Revoked, pending cancellation · American International Aviation Club IncN200KSRaven S55A · S/N S55A-932Cancelled May 6, 2015 · Registration expired, pending cancellation · Built 1982 · Bowman Helen RN3175DStarner Grayson D DRAGON FLY · S/N 582Cancelled May 6, 2015 · Registration expired, pending cancellation · Built 1994 · Starner Grayson DN3773WGulfstream American AA-5B · S/N AA5B-1232Cancelled May 6, 2015 · Registration expired, pending cancellation · Built 1979 · Stanton Paul MN10AXStallings Jerry J AIR MASTER 2 · S/N 001Cancelled May 5, 2015 · Registration expired, pending cancellation · Stallings Jerry JN945NAGrumman G-1159 · S/N 118Cancelled May 5, 2015 · Registration expired, pending cancellation · Built 1972 · National Aeronautics And Space AdministrationN111ASStone Anthony AZTEZ · S/N 001Cancelled May 4, 2015 · Registration expired, pending cancellation · Stone AnthonyN16LLockheed 18-56 · S/N 2457Cancelled May 4, 2015 · Registration expired, pending cancellation · Built 1949 · Fountain Ronald GN3163Bryant Ray J HURRICANE · S/N 910315Cancelled May 4, 2015 · Registration expired, pending cancellation · Bryant Ray JN41953Hawker Siddeley HS125 SERIES 400A · S/N 25268Cancelled May 4, 2015 · Registration expired, pending cancellation · Built 1971 · Arnoni Aviation IncN1716SSnow 600 S-2D · S/N 600-1346DCancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1966 · Nordic Greatwestern Family LpN52JWWells Jim R SONERAI-II · S/N 00275Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1982 · Wells Jim RN6809MStinson 108-3 · S/N 108-4809Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1948 · Gray William Loyd JrN761KQCessna 210M · S/N 21062320Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1977 · Simpson Donald KN948NAGrumman American Avn. G-1159 · S/N 222Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1978 · National Aeronautics And Space AdministrationN12007Cessna P206D · S/N P206-0586Cancelled Apr 24, 2015 · Registration expired, pending cancellation · Built 1969 · Webb Doyle LN477WGGulfstream Aerospace G-III · S/N 477Cancelled Apr 15, 2015 · Second renewal notice · Built 1986 · Granger J Weldon DBAN337SMCessna 337G · S/N 33701709Cancelled Mar 23, 2015 · First renewal notice · Built 1976 · Euram Inc
Back to Houston, TX