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.

N207CBRobinson Helicopter R44 II · S/N 11368Cancelled Dec 29, 2009 · Exported to Canada · Built 2006 · Perry Thomas R JrN9KEEurocopter AS 350 B3 · S/N 3857Cancelled Dec 21, 2009 · Exported to India · Built 2004 · Friedkin Aviation IncN37737Douglas DC3C · S/N 44-76881Cancelled Nov 12, 2009 · Registration revoked · Built 1944 · Air Transport IncN803BGHawker Beechcraft HS-125-800-A · S/N 258064Cancelled Nov 12, 2009 · Exported to Philippines · Priority 1 Aviation IncN52353Cessna 182P · S/N 18262547Cancelled Oct 27, 2009 · Exported to Russia · Built 1973 · Aircraft Guaranty Trust LLC TrusteeN54AGBoeing 737-7JF · S/N 37592Cancelled Oct 16, 2009 · Exported to Aruba · Built 2008 · Aircraft Guaranty Corp TrusteeN240EBeech D18S · S/N A-84Cancelled Oct 9, 2009 · Registration revoked · Built 1946 · Western Air ExpressN17321Boeing 737-3TO · S/N 23372Cancelled Oct 8, 2009 · Built 1986 · Continental Airlines IncN223AWRobinson Helicopter R44 · S/N 1876Cancelled Oct 8, 2009 · Exported to Turkey · Built 2008 · Metco IncN349JMRobinson Helicopter R44 · S/N 1881Cancelled Oct 8, 2009 · Exported to Turkey · Built 2008 · Metco IncN726AMCessna 550 · S/N 550-0726Cancelled Oct 7, 2009 · Exported to Mexico · Built 1993 · Aircraft Guaranty Corp TrusteeN40120Harms Robert M KIT FOX SERIES 5 · S/N S9909-0215Cancelled Sep 23, 2009 · Triennial form not returned · Built 1999 · Harms Robert M TrusteeN1060CMooney M20A · S/N 1331Cancelled Sep 18, 2009 · Registration revoked · Built 1958 · Cummings Aviation IncN1592UCessna 207 · S/N 20700192Cancelled Sep 18, 2009 · Registration revoked · Built 1970 · Air International IncN968WSmith Miniplane DSA-1-EW · S/N 6550Cancelled Sep 18, 2009 · Registration revoked · Built 1972 · Brown Ramon BN1785XCessna 210L · S/N 21060805Cancelled Sep 17, 2009 · Registration revoked · Built 1975 · Schuett Harold NN141RCCessna 172S · S/N 172S10320Cancelled Sep 16, 2009 · Exported to Germany · Built 2006 · Aircraft Guaranty Trust LLC TrusteeN1551ABeech B300 · S/N FL-24Cancelled Sep 15, 2009 · Triennial form not returned · Built 1990 · Oso-Rio LLCN652APBoeing 747-200 · S/N 23652Cancelled Sep 15, 2009 · Exported to Pakistan · Aircraft Guaranty Corp TrusteeN87SJPiper PA-31T · S/N 31T-7820077Cancelled Sep 8, 2009 · Exported to Mexico · Built 1978 · Gulf Air Group CorpN7790QCessna 340 · S/N 340-0216Cancelled Sep 4, 2009 · Exported to Mexico · Built 1973 · Aircraft Guaranty Title & Trust LLC TrusteeN111TBCessna 310G · S/N 310G0007Cancelled Sep 1, 2009 · Exported to Brazil · Built 1961 · Aircraft Guaranty Management LLC TrusteeN41890Robinson Helicopter R44 II · S/N 12502Cancelled Sep 1, 2009 · Exported to Mexico · Built 2008 · Aircraft Guaranty Corp TrusteeN350RVHawker Beechcraft B300 · S/N FL-585Cancelled Aug 31, 2009 · Exported to Nigeria · Built 2008 · Aerosmith/Penny IncN96SGHawker Siddeley DH.125-1A · S/N 25060Cancelled Aug 25, 2009 · Expired dealer · Gulf Air Group CorpN17345Boeing 737-3TO · S/N 23583Cancelled Aug 21, 2009 · Built 1987 · Continental Airlines IncN39343Boeing 737-3TO · S/N 23581Cancelled Aug 21, 2009 · Built 1987 · Continental Airlines IncN97GMDassault FALCON 2000EX · S/N 15Cancelled Aug 19, 2009 · Exported to Slovenia · Aircraft Guaranty Title And Trust LLC TrusteeN710WSCessna 402B · S/N 402B0558Cancelled Aug 18, 2009 · Exported to Venezuela · Built 1974 · Aircraft Guaranty Title LLC TrusteeN14609Boeing 737-524 · S/N 27322Cancelled Aug 7, 2009 · Exported to Bermuda · Built 1994 · Continental Airlines IncN331APIsrael Aircraft Industries 1124 · S/N 205Cancelled Aug 4, 2009 · Exported to Venezuela · Built 1977 · Aircraft Guaranty Management LLC TrusteeN163CSCirrus Design SR22 · S/N 3475Cancelled Jul 23, 2009 · Exported to South Africa · Built 2009 · Aircraft Guaranty Corp TrusteeN764KFGates Learjet 25D · S/N 234Cancelled Jul 23, 2009 · Exported to Venezuela · Built 1977 · Aircraft Guaranty Title Corp TrusteeN14337Boeing 737-3TO · S/N 23575Cancelled Jul 21, 2009 · Built 1987 · Continental Airlines IncN14342Boeing 737-3TO · S/N 23580Cancelled Jul 21, 2009 · Built 1987 · Continental Airlines IncN161CSCirrus Design SR22 · S/N 3397Cancelled Jul 15, 2009 · Exported to South Africa · Built 2009 · Aircraft Guaranty Corp TrusteeN246XSchempp-Hirth STANDARD AUSTRIA SH1 · S/N 70Cancelled Jul 15, 2009 · Registration revoked · Built 1965 · Parrish Allen WN1732PPiper PA-22-150 · S/N 22-2522Cancelled Jul 9, 2009 · Registration revoked · Built 1954 · Nicotra BobN18JGGalpin STARDUSTER TOO · S/N 1343Cancelled Jul 9, 2009 · Registration revoked · Built 1974 · Galpin James J JrN114FSCessna 411 · S/N 4110098Cancelled Jun 30, 2009 · Registration revoked · Built 1965 · Learstar IncN1435CPiper PA-22-135 · S/N 22-1235Cancelled Jun 30, 2009 · Registration revoked · Built 1953 · Morris Irma DN1518TPiper PA-32-260 · S/N 32-7200044Cancelled Jun 30, 2009 · Registration revoked · Built 1972 · Graves James R TrusteeN666FHCessna 680 · S/N 680-0125Cancelled Jun 26, 2009 · Exported to Germany · Built 2007 · Aircraft Guaranty Corporation TrusteeN2112XCessna 560XLS · S/N 560-5830Cancelled Jun 16, 2009 · Exported to Nigeria · Built 2008 · Airlog International LtdN3903GCessna 340A · S/N 340A0227Cancelled Jun 12, 2009 · Exported to Romania · Built 1977 · Aircraft Guaranty Title Corp TrusteeN254JMCirrus Design SR22 · S/N 1918Cancelled Jun 11, 2009 · Exported to Japan · Built 2006 · Aircraft Guaranty Corp TrusteeN25945Cessna 152 · S/N 15280873Cancelled Jun 11, 2009 · Built 1977 · Paradis Jason MN12747Columbia Aircraft Mfg LC41-550FG · S/N 41639Cancelled Jun 1, 2009 · Exported to Germany · Built 2006 · Aircraft Guaranty Title & Trust LLC TrusteeN179TSDiamond Aircraft Ind DA 42 · S/N 42.279Cancelled May 28, 2009 · Exported to Poland · Built 2008 · Aircraft Guaranty Corp TrusteeN489DSDiamond Aircraft Ind DA 40 · S/N 40.489Cancelled May 26, 2009 · Exported to Austria · Built 2005 · Aircraft Guaranty Title & Trust LLC Trustee
Back to Houston, TX