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.

N3005UCameron Balloons US A-210 · S/N 6036Cancelled Jan 17, 2018 · Registration expired, pending cancellation · Built 1996 · Muir Allan KN305AJAero Commander 1121 · S/N 100Cancelled Jan 17, 2018 · Registration expired, pending cancellation · Aviex Jet IncN520TSSartorius Tom C AIR COMMAND-COMMANDR · S/N X7106Cancelled Jan 17, 2018 · Registration expired, pending cancellation · Built 2006 · Sartorius Tom CN88WLLivesay Wallace R III PITTS SPECIAL S-1 · S/N WBL-0001Cancelled Jan 17, 2018 · Registration expired, pending cancellation · Livesay Wallace B IIIN8934RChampion AERONCA 7FC · S/N 7FC-378Cancelled Jan 17, 2018 · Registration expired, pending cancellation · Built 1960 · Langhorne Michele AN26MRRountree Michael H SR BAKENG DEUCE · S/N 001Cancelled Jan 12, 2018 · Registration expired, pending cancellation · Built 2009 · Rountree Michael H SrN172BPCessna 172M · S/N 17263801Cancelled Jan 11, 2018 · Registration expired, pending cancellation · Built 1974 · J & D Aircraft LLCN217AHawker Siddeley HS-125-600A · S/N 256030Cancelled Jan 11, 2018 · Registration expired, pending cancellation · Arnoni Aviation IncN452CSCessna T240 · S/N T24002052Cancelled Jan 10, 2018 · Second renewal notice · Built 2014 · H2 Aviation LLCN940NSBoeing 377 SG · S/N 15938Cancelled Jan 10, 2018 · Registration expired, pending cancellation · Built 1949 · National Aeronautics And Space AdministrationN947NAGrumman G-1159 · S/N 147Cancelled Jan 10, 2018 · Registration expired, pending cancellation · Built 1974 · Nasa Johnson Space CenterN893CASocata TBM 700 · S/N 393Cancelled Jan 8, 2018 · First renewal notice · Built 2007 · Oso Rio LLCN6465Nichols James Scott SOPWITH PUP · S/N 6465Cancelled Jan 5, 2018 · Registration expired, pending cancellation · Nichols James ScottN45464Luscombe 8A · S/N 1991Cancelled Jan 4, 2018 · Registration expired, pending cancellation · Built 1945 · Borden Lance SN1525ZBalloon Works FIREFLY 7-B · S/N 10329Cancelled Jan 2, 2018 · Registration expired, pending cancellation · Built 1981 · Smallen Thomas GN3103BCessna 208B · S/N 208B5114Cancelled Dec 13, 2017 · Exported to Belize · Built 2014 · Schutte Steven PN25946Piper J3C-65 · S/N 3901Cancelled Nov 22, 2017 · Revoked, canceled · Built 1939 · Capps Stanley BN3355TCessna 177 · S/N 17700655Cancelled Nov 22, 2017 · Revoked, canceled · Built 1967 · Space City Aircraft IncN6225LAmerican AA-1 · S/N AA1-0425Cancelled Nov 21, 2017 · Revoked, canceled · Built 1970 · Alvin Aero ClubN72304Cessna 140 · S/N 9481Cancelled Nov 21, 2017 · Revoked, canceled · Built 1946 · Mills J TN80793Globe GC-1A · S/N 196Cancelled Nov 21, 2017 · Revoked, canceled · Built 1946 · Sanders HaroldN8916FHughes 269A · S/N 0297Cancelled Nov 21, 2017 · Revoked, canceled · Built 1964 · Hel Sales IncN94363Engineering & Research ERCOUPE 415-C · S/N 1586Cancelled Nov 21, 2017 · Revoked, canceled · Droemer AlbertN36920Aeronca 65-CA · S/N C-17871Cancelled Nov 18, 2017 · Revoked, canceled · Built 1941 · Follette RobertN3730APiper PA-22-135 · S/N 22-1973Cancelled Nov 18, 2017 · Revoked, canceled · Built 1953 · Mcdougall BillN1768APiper PA-22 · S/N 22-496Cancelled Oct 28, 2017 · Revoked, canceled · Built 1952 · Madrid Oil & Gas CorpN20ARKeleher Lark TIGER LARK JK-1C · S/N 139MARCancelled Oct 28, 2017 · Revoked, canceled · Ronay A GN3801HEngineering & Research ERCOUPE 415-CD · S/N 4502Cancelled Oct 28, 2017 · Revoked, pending cancellation · Built 1947 · Seinfeld RichardN26067Grumman American Avn. AA-5A · S/N AA5A0410Cancelled Oct 27, 2017 · Registration expired, pending cancellation · Built 1977 · Kirkwood Ronald WN299WACessna 172M · S/N 17267395Cancelled Oct 26, 2017 · Registration expired, pending cancellation · Built 1976 · J & D Aircraft LLCN5TFVickers Supermarineltd SPITFIRE VC · S/N JG891Cancelled Oct 25, 2017 · Exported to United Kingdom · Built 1943 · Comanche Fighters LLCN944NAGulfstream American G-1159 · S/N 144Cancelled Oct 20, 2017 · Registration expired, pending cancellation · Built 1974 · National Aeronautics And Space AdministrationN3899Let L-13 BLANIK · S/N 026928Cancelled Oct 17, 2017 · Gregg Ronald SN70108Piper J3C-65 · S/N 17082Cancelled Oct 6, 2017 · Registration expired, pending cancellation · Built 1946 · Robinson Thomas W JrN4991SPiper PA-28R-200 · S/N 28R-35707Cancelled Sep 27, 2017 · Registration expired, pending cancellation · Built 1970 · Widak Thomas DN8570EChampion 7FC · S/N 7FC-358Cancelled Sep 26, 2017 · Registration expired, pending cancellation · Built 1959 · Feltis Alan JamesN28225Gulfstream American AA-5B · S/N AA5B0947Cancelled Sep 18, 2017 · Registration expired, pending cancellation · Built 1978 · Behrndt Eric AN26699Grumman American Avn. AA-5A · S/N AA5A0654Cancelled Jul 20, 2017 · Registration expired, pending cancellation · Yawitz Steven MN119SCBell 206B · S/N 3151Cancelled Jul 18, 2017 · Registration expired, pending cancellation · Built 1980 · Aop Supply CorpN82079Douglas A-4Q · S/N 144989Cancelled Jul 14, 2017 · Registration expired, pending cancellation · Aircraft Charter Services LLCN888RGrumman American Avn. AA-5B · S/N AA5B0332Cancelled Jul 12, 2017 · Registration expired, pending cancellation · Built 1976 · Cheyenne Air IncN9547PCameron Balloons US V-77 · S/N 5580Cancelled Jul 12, 2017 · Registration expired, pending cancellation · Built 1990 · Ortiz Christopher JN776CADJI INSPIRE 1 · S/N W130CD16031883Cancelled Jul 10, 2017 · Exported to United Kingdom · Strat Aero International IncN198CFBeech 200 · S/N BC-44Cancelled Jul 7, 2017 · Registration expired, pending cancellation · Built 1978 · Otdl CorpN381MMBell 206B-III · S/N 3446Cancelled Jul 7, 2017 · Registration expired, pending cancellation · Built 1981 · Aop Supply CorpN85DPPiccard AX-6 · S/N 732Cancelled Jul 7, 2017 · Registration expired, pending cancellation · Built 1975 · Murtorff MaryN777PZLockheed 1329-23E · S/N 5128Cancelled Jul 6, 2017 · Registration expired, pending cancellation · Built 1968 · Accrued Investments IncN18EECessna 172 · S/N 29816Cancelled Jun 30, 2017 · Registration expired, pending cancellation · Built 1957 · Baird Jack ON20042Arias Alvaro ZODIAC CH 601 HDS · S/N 63816Cancelled Jun 30, 2017 · Registration expired, pending cancellation · Built 2002 · Arias AlvaroN947AKRolladen-Schneider OHG LS3-A · S/N 3374Cancelled Jun 30, 2017 · Registration expired, pending cancellation · Built 1979 · Shea Raymond P Jr
Back to Houston, TX