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.

N211SSShannon Stan RV-6 · S/N 21620Cancelled Oct 12, 2011 · Exported to Argentina · Built 1995 · Iglesias Hector EN89YCDehavilland DHC-2 MK. I(L20A) · S/N 1264Cancelled Oct 12, 2011 · Exported to Poland · Honover Enterprises IncN432AQBritish Aerospace BAE 125 SERIES 800A · S/N NA0434Cancelled Sep 21, 2011 · Exported to Mexico · Projets IncN190DJJones 190-A3 · S/N 1401Cancelled Aug 12, 2011 · Built 1986 · Jackson Bobby RN1034UPiper PA-34-200 · S/N 34-7250015Cancelled Jul 15, 2011 · Sale reported, canceled · Built 1971N751CWWood Coleman VANS RV-7 · S/N 71648Cancelled Jun 2, 2011 · Exported to Lithuania · Wood Coleman WN2665AClapp Daniel W GT 400 · S/N 082197HCancelled May 26, 2011 · Built 2001 · Long Ronald JN759ADehavilland DHC-8-202 · S/N 435Cancelled May 20, 2011 · Exported to Norway · Aramco Associated CompanyN724ADehavilland DHC-8-202 · S/N 440Cancelled May 17, 2011 · Exported to Norway · Built 1996 · Aramco Associated CompanyN725ADehavilland DHC-8-202 · S/N 441Cancelled May 16, 2011 · Exported to Norway · Built 1996 · Aramco Associated CoN76XEIglesias Hector Eduardo VANS RV7 · S/N 72622Cancelled Apr 21, 2011 · Exported to Argentina · Built 2010 · Iglesias Hector EduardoN254SNSpriggle Richard J SONEX · S/N 0419Cancelled Mar 31, 2011 · Exported to Canada · Hess AmirN282DHDehavilland DH82A · S/N A17-64Cancelled Mar 29, 2011 · Exported to Israel · Built 1940 · Banham Anthony PN5337JCessna 404 · S/N 404-0659Cancelled Mar 17, 2011 · Expired dealer · Built 1980 · Cruse Aviation IncN739TECessna 172N · S/N 17270786Cancelled Mar 16, 2011 · Exported to Argentina · Built 1978 · Iglesias Hector EN181RReed Farn VANS ACFT RV-6 · S/N 21880Cancelled Feb 15, 2011 · Exported to Argentina · Built 1994 · Iglesias Hector EN8838FPiper PA-34-200T · S/N 34-7770095Cancelled Jan 21, 2011 · Exported to Guatemala · Grimm John H IIN4520SBeech 58 · S/N TH-660Cancelled Jan 14, 2011 · Exported to Brazil · Built 1975 · Apui U S A LLCN727BTLearjet 31A · S/N 082Cancelled Jan 13, 2011 · Exported to Mexico · Built 1993 · Pertino IncN75671Boeing E75N1 · S/N 75-5303Cancelled Jan 5, 2011 · Exported to United Kingdom · Built 1945 · Jfc Flyers I IncN708HBell Helicopter Textron Canada 412EP · S/N 36198Cancelled Jan 4, 2011 · Exported to Qatar · Built 1998 · Aramco Associated CompanyN709HBell 412EP · S/N 36199Cancelled Jan 4, 2011 · Exported to Qatar · Aramco Associated CompanyN34435Aeronca 65-CA · S/N C14571Cancelled Dec 16, 2010 · Revoked, pending cancellation · Built 1941 · Nelson William TN142DDouglas DC3A-S4C4G · S/N 1946Cancelled Dec 1, 2010 · Revoked, pending cancellation · Built 1937 · Avion IncN1015RRaven Industries RX6 · S/N RX6-174Cancelled Nov 30, 2010 · Sale reported, pending cancellation · Built 1975N339CAHawker Siddeley HS.125 SERIES 700A · S/N NA0213Cancelled Nov 19, 2010 · Exported to Mexico · Built 1977 · Projets IncN20PJHawker Siddeley DH.125-400A · S/N NA734Cancelled Nov 18, 2010 · Exported to Mexico · Projets IncN102BPHawker Siddeley HS.125 SERIES 700A · S/N NA0226Cancelled Nov 17, 2010 · Exported to Mexico · Built 1978 · Projets IncN817ALBoeing 737-2X6C · S/N 23292Cancelled Nov 16, 2010 · Exported to South Africa · Built 1982 · Bjet IncN56KSDouglas DC3C · S/N 25769Cancelled Nov 12, 2010 · Exported to Canada · Built 1944 · Bell Geospace Aviation IncN722ABritish Aerospace BAE 125 SERIES 800A · S/N 258200Cancelled Nov 9, 2010 · Exported to Bangladesh · Built 1982 · Priority 1 Aviation IncN487TCCessna 182T · S/N 18281486Cancelled Oct 4, 2010 · Triennial form not returned · Built 2004 · Kaleta Smith LLCN211LSIndus T211 THORPEDO · S/N 001SCancelled Aug 9, 2010 · Second triennial mailing, no response · Built 2005 · Hood Aircraft CorpN105GKRobinson Helicopter R44 II · S/N 10527Cancelled Jul 28, 2010 · Exported to Australia · Built 2004 · Coates Tyrone AN1458UCessna 172M · S/N 17267125Cancelled Jul 14, 2010 · Triennial form not returned · Built 1976 · J & D Aircraft LLCN6383WHowes Rodney H RV-6 · S/N 22415Cancelled Jun 21, 2010 · Triennial form not returned · Built 1999 · Jarvis Curtis LN601JTSwearingen SA-226T · S/N T319Cancelled Jun 4, 2010 · Triennial form not returned · Built 1979 · Excalibur International Aviation IncN2256QCessna 411 · S/N 411-0134Cancelled May 27, 2010 · Triennial form not returned · Built 1965 · Koonce E Ray DBAN800THHelio H800 · S/N H-17Cancelled May 27, 2010 · Exported to Russia · Built 1984 · Nordic Greatwestern Family Ltd PartnershipN19QQFokker F.27MK 600 · S/N 10349Cancelled Apr 30, 2010 · Exported to Indonesia · Built 1968 · Precision Aero Lease LLCN19NNFokker F.27MK 600 · S/N 10385Cancelled Apr 28, 2010 · Exported to Indonesia · Built 1968 · Precision Aero Lease LLCN644EMMitsubishi MU-2B-60 · S/N 1534 S.A.Cancelled Apr 27, 2010 · Triennial form not returned · Martin Earle PN906AHAgusta A109E · S/N 11644Cancelled Mar 31, 2010 · Triennial form not returned · Built 2005 · Aramco Associated CoN397RACessna 340A · S/N 340A0009Cancelled Mar 30, 2010 · Triennial form not returned · Built 1975 · Norris Albert AN38RSCessna 401A · S/N 401A0086Cancelled Mar 2, 2010 · Exported to El Salvador · Built 1969 · Leonidas Martinez SanchezN65482Cessna 172P · S/N 17275761Cancelled Feb 12, 2010 · Exported to Ghana · Built 1982 · Aerosmith/Penny IncN98483Cessna 172P · S/N 17276298Cancelled Feb 12, 2010 · Exported to Ghana · Built 1985 · Aerosmith/Penny IncN91454North American NAVION · S/N NAV-4-99Cancelled Jan 20, 2010 · Triennial form not returned · Built 1946 · Mcbryde Neal DoakN216LJBeech 65-A90 · S/N LJ-190Cancelled Jan 19, 2010 · Exported to Mexico · Built 1966 · Cns Ventures LLCN37078Mcdonnell-Douglas DC-10-30 · S/N 46926Cancelled Jan 14, 2010 · Triennial form not returned · Built 1973 · Continental Airlines Purchasing Services Lp
Back to Houston, TX