OpenAirDocs.org
Austin, TX

Cancelled registrations · 608

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 = 'AUSTIN'
  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.

N5553RRaven Industries RALLY RX7 · S/N RX7107Cancelled Apr 21, 1997 · Triennial form not returned · Grief EnterprisesN206JRBell 206B · S/N 3416Cancelled Mar 10, 1997 · Exported to El Salvador · Aero Star International IncN333MMBeech A23-24 · S/N MA130Cancelled Feb 18, 1997 · Triennial form not returned · Knolle William MN5138JCessna 172N · S/N 17273712Cancelled Dec 11, 1996 · Exported to Czech Republic · Slator C HN1133CHughes 369HS · S/N 910353SCancelled Nov 18, 1996 · Exported to Australia · Autorotate IncN201YRMooney M20J · S/N 240734Cancelled Oct 7, 1996 · Triennial form not returned · Kissock D CraigN11348Hughes 369HS · S/N 1010357SCancelled Oct 2, 1996 · Exported to New Zealand · Autorotate IncN1119SSchweizer SGS 1-26E · S/N 509Cancelled Aug 27, 1996 · Triennial form not returned · Peet Charles E JrN6253THughes 369HS · S/N 910345SCancelled Aug 22, 1996 · Exported to New Zealand · Autorotate IncN456ABell 206B · S/N 933Cancelled Jul 19, 1996 · Exported to Philippines · Koch Virginia EN2205XBell 206B · S/N 3529Cancelled Jun 13, 1996 · Triennial form not returned · Haufler UdoN60RGRobbins Thomas F RUTAN LONG-EZ · S/N 620Cancelled May 8, 1996 · Triennial form not returned · Robbins Thomas FN6253DHughes 369HS · S/N 410319SCancelled Mar 5, 1996 · Exported to New Zealand · Autorotate IncN6253MHughes 369HS · S/N 910341SCancelled Mar 5, 1996 · Exported to New Zealand · Autorotate IncN6253ZHughes 369HS · S/N 1030531SCancelled Mar 5, 1996 · Exported to New Zealand · Autorotate IncN76AJBell 206-L4 · S/N 52077Cancelled Jan 18, 1996 · Exported to India · Austin Jet Helicopters IncN119AJBell 206B · S/N 2359Cancelled Nov 14, 1995 · Exported to Germany · Austin Jet Helicopters IncN3223SHughes 369HS · S/N 110291SCancelled Jun 2, 1995 · Exported to New Zealand · Autorotate IncN55AJBell 206B · S/N 4323Cancelled May 22, 1995 · Exported to Argentina · Austin Jet Helicopters IncN468RFGrumman G-164 · S/N 213Cancelled May 3, 1995 · Triennial form not returned · Perez Patrick QuinnN5379DBell 206-L4 · S/N 52103Cancelled Apr 27, 1995 · Exported to India · Austin Jet Helicopters IncN84AJBell 206B · S/N 4317Cancelled Apr 4, 1995 · Exported to El Salvador · Austin Jet Helicopters IncN6491Livingston MUSTANG II · S/N 149Cancelled Mar 30, 1995 · Triennial form not returned · Glader John HN91763Cessna 172M · S/N 17261511Cancelled Mar 30, 1995 · Triennial form not returned · Canelas Intl Aviation IncN8020GBell 206B · S/N 4239Cancelled Mar 24, 1995 · Exported to Argentina · Austin Jet Helicopters IncN414FSNorth American F-100F · S/N 563826Cancelled Mar 15, 1995 · Triennial form not returned · Tracor Flight Systems IncN2250CBell 206L-3 · S/N 51342Cancelled Mar 10, 1995 · Exported to El Salvador · Austin Jet Helicopters IncN7027ACessna 172 · S/N 29127Cancelled Feb 21, 1995 · Triennial form not returned · Coltman Peter ON86200Cessna 337D · S/N 3371110Cancelled Jan 31, 1995 · Triennial form not returned · Wilkov Melvin AN187TBingelis T-40 · S/N 145Cancelled Dec 21, 1994 · Triennial form not returned · Smith Frank WN21868Hughes 369HS · S/N 410318SCancelled Sep 12, 1994 · Exported to New Zealand · Autorotate IncN108JWBell 206B · S/N 4178Cancelled Aug 16, 1994 · Exported to Mexico · Austin Jet CorporationN14773Bellanca 17-30A · S/N 7530772Cancelled Jul 14, 1994 · Nixon Penolope DBAN21872Hughes 369HS · S/N 710332SCancelled Jul 6, 1994 · Exported to New Zealand · Built 1971 · Autorotate IncN2188JHughes 369HS · S/N 710330SCancelled Jul 6, 1994 · Exported to New Zealand · Built 1971 · Autorotate IncN4945VBellanca 17-30 · S/N 30147Cancelled Jun 27, 1994 · Second triennial mailing, no response · Clark Brent RN93AJBell 206B · S/N 3852Cancelled May 31, 1994 · Exported to Canada · Austin Jet CorporationN97AJBell 206B-III · S/N 4297Cancelled May 23, 1994 · Exported to Mexico · Austin Jet CorporationN112AJBell 206B · S/N 4302Cancelled May 2, 1994 · Exported to Switzerland · Austin Jet CorporationN5975Cessna 310A · S/N 38127Cancelled Mar 25, 1994 · Triennial form not returned · Elli BradN75AJBell Helicopter Textron 206L-1 · S/N 45635Cancelled Feb 15, 1994 · Exported to Argentina · Austin Jet CorporationN263ALCessna 500 · S/N 5000263Cancelled Dec 28, 1993 · Exported to Australia · Austin Jet CorporationN2016WBell 206-L4 · S/N 52042Cancelled Dec 15, 1993 · Exported to Malaysia · Built 1993 · Austin Jet CorpN3035PPiper PA-23 · S/N 23946Cancelled Dec 9, 1993 · Triennial form not returned · Hargett James MN65NBell 206B · S/N 4136Cancelled Nov 29, 1993 · Exported to Nigeria · Austin Jet CorpN54AJBell 206B-III · S/N 2922Cancelled Nov 9, 1993 · Exported to United Kingdom · Austin Jet CorpN97AJBell 206B · S/N 3202Cancelled Oct 28, 1993 · Exported to Mexico · Austin Jet CorporationN92BCBell 206B · S/N 3175Cancelled Aug 13, 1993 · Exported to Chile · Austin Jet CorporationN5308XCessna U206G · S/N U20605627Cancelled Jul 8, 1993 · Exported to Botswana · Smith Allen WN1085YBell 206B · S/N 2970Cancelled Jun 9, 1993 · Exported to Guatemala · Austin Jet Corporation
Back to Austin, TX