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.

N91511North American NAVION · S/N NAV-4-306Cancelled May 8, 2021 · Registration expired, pending cancellation · Built 1946 · Ingram SkotN104RKBeech A36 · S/N E-1450Cancelled Mar 6, 2021 · Registration expired, pending cancellation · Built 1979 · F H L S LLCN131TXCirrus Design SR22T · S/N 0230Cancelled Mar 6, 2021 · Registration expired, pending cancellation · Built 2011 · Twr Business Services LLCN245GGear UP Of SC JUST ACFT HIGHLANDER · S/N JA416-09-14Cancelled Feb 4, 2021 · Sale reported, pending cancellation · Built 2015N199TWWitham Timothy D RAF 2000 GTX SE · S/N H2-98-9-392Cancelled Oct 3, 2020 · Registration expired, pending cancellation · Built 1999 · Witham Timothy DN990TGBoeing 737-75C · S/N 29085Cancelled Aug 20, 2020 · First renewal notice · Spectre Air Capital LLCN707KCBoeing 737-75C · S/N 29086Cancelled Aug 19, 2020 · Exported to China · Spectre Air Capital LLCN7228TBeech 300 · S/N FA-20Cancelled Aug 8, 2020 · Exported to Canada · Built 1984 · Aetg LLCN491SK3D Robotics SOLO · S/N S111A6A06139Cancelled Aug 2, 2020 · Registration expired, pending cancellation · Seekops IncN345BBAerospatiale AS350B · S/N 1566Cancelled Jul 22, 2020 · First renewal notice · Built 1982 · Byram BlakeN746CSAirbus Industrie A340-313 · S/N 146Cancelled Jul 10, 2020 · Registration expired, pending cancellation · Aero Capital Solutions IncN794BFDJI PHANTOM 2 VISION + · S/N BF323110304924Cancelled Apr 3, 2020 · Registration expired, pending cancellation · Texas Department Of InsuranceN794DTDJI PHANTOM 2 VISION PLU · S/N BF230936188679Cancelled Apr 3, 2020 · Registration expired, pending cancellation · Texas Department Of InsuranceN909AWBoeing 757-2G7 · S/N 24522Cancelled Apr 3, 2020 · Registration expired, pending cancellation · Built 1989 · Reliance Aircraft International IncN512WTHarmening High Flyer DELUXE · S/N 005998Cancelled Feb 28, 2020 · Registration expired, pending cancellation · Built 1999 · Krejca Jean KN455CJAerospatiale/Atr ATR 72 202 · S/N 455Cancelled Feb 25, 2020 · Exported to Canada · Texas Aviation Group LLCN794UWYuneec TYPHOON H · S/N YU16221698B08A01Cancelled Feb 3, 2020 · Registration expired, pending cancellation · Winston Glen MN3192Abresch R J/Abresch N B CAPELLA · S/N 01Cancelled Jan 31, 2020 · Registration expired, pending cancellation · Abresch Nellie JN53813Fairchild M-62A · S/N T437336Cancelled Jan 21, 2020 · Revoked, canceled · Built 1944 · Ragsdale Robert L Flying SvcN760NJDJI PHANTOM 2 VISION · S/N PH645476905Cancelled Jan 6, 2020 · Registration expired, pending cancellation · American Constructors IncN790SLDJI PHANTOM 2 VISION + · S/N PH645396784Cancelled Jan 6, 2020 · Registration expired, pending cancellation · Lower Colorado River AuthorityN1610TDJI PHANTOM 3 PROFESSION · S/N P76DCG27016414Cancelled Nov 29, 2019 · Registration expired, pending cancellation · 360aerialimages LLCN763PTArch Aerial ATLAS 1 QUADCOPTER · S/N AA13100Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Texas Parks And Wildlife DepartmentN22006Cessna 150H · S/N 15068004Cancelled Oct 25, 2019 · Revoked, canceled · Built 1967 · Longhorn Flying Club IncN220KHBeech E-90 · S/N LW-142Cancelled Oct 15, 2019 · Built 1975 · Httrr LLCN610CSBoeing 737-758 · S/N 29961Cancelled Oct 5, 2019 · Registration expired, pending cancellation · Aero Capital Solutions IncN826SAlexander Schleicher ASH 26 E · S/N 26256Cancelled Oct 1, 2019 · Exported to Canada · Built 2008 · Rose Ronald VN684XDDJI INSPIRE 1 PRO · S/N W21ADA11021632Cancelled Sep 9, 2019 · Registration expired, pending cancellation · Daedalus Drone Services LLCN6906DDJI PHANTOM 2 · S/N PH645171315Cancelled Sep 9, 2019 · Registration expired, pending cancellation · Daedalus Drone Services LLCN665FSSensefly EXOM · S/N EX0108324Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Surveying And Mapping LLCN667KS3D Robotics AERO-M · S/N AE M152290001Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Surveying And Mapping LLCN667LM3D Robotics AERO-M · S/N AEM150920008Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Surveying And Mapping LLCN679KD3D Robotics AERO · S/N 7664337Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Daedalus Drone Services LLCN709YTDJI PHANTOM 2 VISION PLU · S/N BF230925542491Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Texas Dept Of InsuranceN679LDDJI PHANTOM 2 · S/N PH645354435Cancelled Sep 4, 2019 · Registration expired, pending cancellation · Daedalus Drone Services LLCN420GDJI PHANTOM 3 PROFESSION · S/N P76DCH22A26617Cancelled Jul 26, 2019 · Registration expired, pending cancellation · Dolan Patrick FN990PPBoeing 737-75C · S/N 29084Cancelled Jul 15, 2019 · Exported to India · Spectre Air Capital LLCN665JSSensefly EXOM · S/N EX01-04045Cancelled Jul 2, 2019 · Registration expired, pending cancellation · Surveying And Mapping LLCN646RMDJI PHANTOM 3 PROFESSION · S/N P77DCI16011336Cancelled Jun 29, 2019 · Registration expired, pending cancellation · Mort Raymond W IIIN291EZSommer John A VARIEZE · S/N 1671Cancelled Jun 5, 2019 · Registration expired, pending cancellation · Sommer John PN6870RCessna T210G · S/N T210-0270Cancelled Jun 3, 2019 · Exported to Mexico · Peraza JavierN18FJCornell W F/Sahakian J A JR GILES 202 (G202) · S/N 018Cancelled May 6, 2019 · Registration expired, pending cancellation · Built 1998 · Wright Andrew KN238LCDraganfly Innovations GUARDIAN · S/N 5A4C1ECancelled May 4, 2019 · Registration expired, pending cancellation · Lower Colorado River AuthorityN817FAXactsense MAX-8 · S/N XSMX8-00002Cancelled May 4, 2019 · Registration expired, pending cancellation · Ferrovial Agroman US CorpN597YBDJI PHANTOM 2 · S/N PH645343143Cancelled May 1, 2019 · Registration expired, pending cancellation · Brual LLCN601FB3D Robotics SOLO · S/N S111A5501566Cancelled Apr 19, 2019 · Registration expired, pending cancellation · Brual LLCN151RRBeech B200 · S/N BB-1395Cancelled Mar 15, 2019 · Exported to Canada · Built 1991 · Fifty One Air LLCN622GCDJI INSPIRE 1 PRO · S/N W21ACI16011846Cancelled Mar 12, 2019 · Registration expired, pending cancellation · Cloud9drones LLCN5430UBeech V35 · S/N D-8513Cancelled Mar 9, 2019 · Registration expired, pending cancellation · Built 1967 · Hardy Robert CN905HDAscending Technologies ASCTEC FALCON 8 · S/N 31192Cancelled Mar 5, 2019 · Registration expired, pending cancellation · Huvrdata LLC
Back to Austin, TX