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.

N23535Beech A36 · S/N E-1177Cancelled Jun 21, 2017 · Registration expired, pending cancellation · Built 1977 · Big Red Aviation IncN5079PPiper PA-24-180 · S/N 24-85Cancelled Jun 15, 2017 · Registration expired, pending cancellation · Built 1958 · Lentz Flying Service LLCN9627QCessna 172M · S/N 17265711Cancelled Jun 15, 2017 · Registration expired, pending cancellation · Built 1975 · United Helicopters DBAN29297Cessna 172M · S/N 17264115Cancelled Jun 14, 2017 · Registration expired, pending cancellation · Built 1974 · United Helicopters Inc DBAN64512Cessna 172M · S/N 17265271Cancelled Jun 14, 2017 · Registration expired, pending cancellation · Built 1975 · United Helicopters Inc DBAN140MLPiper PA-28-140 · S/N 28-7525017Cancelled Jun 7, 2017 · Registration expired, pending cancellation · Built 1974 · Lentz Gary RN41753Rhett Edmund Middleton TOM CAN · S/N TC001Cancelled Jun 7, 2017 · Registration expired, pending cancellation · Rhett Edmund M JrN999FFVerdev PITTS S1-S · S/N PV-00684Cancelled Jun 7, 2017 · Registration expired, pending cancellation · Built 1979 · West Randy LN712MQGulfstream Aerospace G1159B · S/N 104Cancelled Jun 1, 2017 · Registration expired, pending cancellation · Built 1971 · Abco Aviation IncN7344VBellanca 17-30 · S/N 30221Cancelled Jun 1, 2017 · Registration expired, pending cancellation · Built 1969 · Roman Nick EN121BSStrange Robert F JR RUTAN LONGE EZ · S/N 226Cancelled May 22, 2017 · Registration expired, pending cancellation · Strange Robert F JrN2111UBrantly B-2 · S/N 157Cancelled May 22, 2017 · Registration expired, pending cancellation · Built 1962 · Turcotte Enterprises IncN4397TPiper PA-28-140 · S/N 28-7225163Cancelled May 22, 2017 · Registration expired, pending cancellation · Built 1972 · Spaniol Mark CN9872LGrumman American Avn. AA-1B · S/N AA1B-0472Cancelled May 15, 2017 · Registration expired, pending cancellation · Built 1974 · Martinez Marid CN32KKPiper PA-32R-300 · S/N 32R-7680117Cancelled Apr 24, 2017 · Wilson Richard KN7742RDJI PHANTOM 3 PROFESSION · S/N P76DCF12013300Cancelled Apr 24, 2017 · Rudisill Darmie N JrN39821Bellanca 17-30A · S/N 73-30494Cancelled Apr 13, 2017 · Registration expired, pending cancellation · Built 1972 · Miller Michael RN5892LAmerican AA-5 · S/N AA5-0092Cancelled Apr 13, 2017 · Registration expired, pending cancellation · Built 1972 · Seale Marsha KN2547APiper PA-38-112 · S/N 38-78A0747Cancelled Apr 7, 2017 · Registration expired, pending cancellation · Built 1978 · Campbell D KN2014ACameron Balloons US V-77 · S/N 5359Cancelled Apr 4, 2017 · Registration expired, pending cancellation · Built 1988 · Perkins Donna SN2893Wickson Stuart BENSEN B-8M · S/N 4457034Cancelled Apr 4, 2017 · Registration expired, pending cancellation · Built 1971 · Vintage Aircraft (Lelystad) IncN828TCThunder & Colt Airborne Amer AX8-90 S 2 · S/N 2473USACancelled Apr 4, 2017 · Registration expired, pending cancellation · Built 1994 · Busch Kit DN9497XCessna 210A · S/N 21057797Cancelled Apr 4, 2017 · Registration expired, pending cancellation · Built 1961 · Pratt Peter E Jr ReceiverN33626Briegleb BG-12BD · S/N IR230Cancelled Mar 24, 2017 · Registration expired, pending cancellation · Built 1973 · Millar Russell EN3983ECameron Balloons US V-90 · S/N 5672Cancelled Mar 24, 2017 · Registration expired, pending cancellation · Built 1991 · Watson Vaughn JrN9983LCessna 182P · S/N 18264043Cancelled Mar 24, 2017 · Registration expired, pending cancellation · Built 1975 · Javelin Conversions IncN7277ECessna 182B · S/N 52277Cancelled Mar 21, 2017 · Registration expired, pending cancellation · Built 1959 · Williams Charles StewartN696MHPiaggio Aero Industries P180 · S/N 1172Cancelled Mar 9, 2017 · Exported to Canada · Built 2008 · Blue Ridge Mountain Resources IncN8184VCessna A188 · S/N 188-0434Cancelled Mar 6, 2017 · Registration expired, pending cancellation · Built 1968 · Jacobs Samuel JN6253ZSells Lloyd D AIR COMMAND 532 · S/N 532LSCancelled Feb 28, 2017 · Registration expired, pending cancellation · Built 1997 · Moreland Ed H JrN39HTTurner H C SA 102.5 · S/N SNOOP-3Cancelled Feb 17, 2017 · Registration expired, pending cancellation · Built 1991 · King CurtisN51878Cook AX-3 · S/N 001Cancelled Feb 17, 2017 · Registration expired, pending cancellation · Built 1978 · Cook Wayne FN995LBeech C18S · S/N 6029Cancelled Feb 14, 2017 · Revoked, canceled · Built 1944 · Whittenburg E LN950WSiai-Marchetti S.205/22R · S/N 4-150Cancelled Feb 13, 2017 · Revoked, canceled · Built 1968 · Tex-Flite IncN1285KLuscombe 8A · S/N 4012Cancelled Feb 4, 2017 · Revoked, canceled · Built 1946 · Stovall Peter FN71559Luscombe 8A · S/N 2986Cancelled Feb 4, 2017 · Revoked, canceled · Built 1946 · Poole Paul JN72964Cessna 120 · S/N 10162Cancelled Feb 4, 2017 · Revoked, canceled · Built 1946 · Laudan Aerial CoN736TNCessna R172K · S/N R1722777Cancelled Feb 4, 2017 · Revoked, canceled · Built 1977 · Loughnane B PN74SFBeech E18S · S/N BA-258Cancelled Feb 4, 2017 · Revoked, canceled · Built 1957 · Air International IncN7559HCessna A185F · S/N 18503395Cancelled Feb 4, 2017 · Revoked, canceled · Built 1977 · Pruett James HN76EZBrewer KR-1 · S/N 14538214Cancelled Feb 4, 2017 · Revoked, canceled · Built 1974 · Robbins Billy JN7769PPiper PA-24-250 · S/N 24-2985Cancelled Feb 4, 2017 · Revoked, canceled · Built 1962 · Houston Acft Sales IncN777AEBeech 70 · S/N LB-34Cancelled Feb 4, 2017 · Revoked, canceled · Built 1970 · N777ae GroupN777KMPiper PA-34-200T · S/N 34-7770221Cancelled Feb 4, 2017 · Revoked, canceled · Built 1977 · Molina Marcel DrN8246GCessna A188B · S/N 18801264Cancelled Feb 4, 2017 · Revoked, canceled · Built 1973 · Agcontrol IncN88868Lockheed 149-46 · S/N 2067Cancelled Feb 4, 2017 · Revoked, canceled · Built 1946 · Tex Hou IncorporatedN421PKCessna 421B · S/N 421B0830Cancelled Feb 3, 2017 · First renewal notice · Built 1975 · Hendee Edd CN5262NThomas James W J-3 KITTEN · S/N 178Cancelled Jan 25, 2017 · Built 2004 · Thomas James WN557CLRoe Cleo WITTMAN TAILWIND W10 · S/N 557Cancelled Jan 23, 2017 · Built 1992 · Ryan Jared BN302CTFlight Design CTSW · S/N 07-06-06Cancelled Dec 12, 2016 · Built 2007 · Mayionos Spiro
Back to Houston, TX