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.

N528FDAirbus Industrie A310-304 · S/N 528Cancelled Mar 5, 2004 · Triennial form not returned · Flight Director IncN4038JBalloon Works FIREFLY 6 · S/N 636Cancelled Feb 17, 2004 · Triennial form not returned · Built 1978 · Locke Robert MN1068CBell 206B · S/N 2843Cancelled Dec 15, 2003 · Exported to Sweden · Built 1979 · North American Racing CorporationN8123RBeech V35B · S/N D-9653Cancelled Dec 12, 2003 · Exported to Canada · Built 1974 · Rosales A ScottN99570Cessna 172P · S/N 17276470Cancelled Dec 2, 2003 · Triennial form not returned · Built 1985 · Hamilton Enterprises CorporationN510AUBoeing 737-3B7 · S/N 23385Cancelled Jun 4, 2003 · Flight Director IncN704NPdps Pzl-Bielsko SZD-50-3 · S/N B-2090Cancelled May 7, 2003 · Exported to Canada · Built 1994 · Neely B DN3201RBell 206B · S/N 3925Cancelled Dec 26, 2002 · Exported to Canada · Built 1986 · Gulf Plains Pipeline Company IncN6VYBeech D-45 · S/N BG-221Cancelled Aug 28, 2002 · Triennial form not returned · Pinder Stan DN6622XBeech C23 · S/N M-2383Cancelled Jul 11, 2002 · Triennial form not returned · Built 1983 · Thomas Alfred CN47SRJackson Steven Reagan HARMON ROCKET · S/N 3702Cancelled May 29, 2002 · Triennial form not returned · Built 1995 · Rocket Flyers LLCN7130BCessna 320B · S/N 320B0055Cancelled May 10, 2002 · Wood Julia AN76073Mcdonnell-Douglas DC-10-30 · S/N 46940Cancelled Mar 29, 2002 · Sale reported · Built 1974N43334Piper PA-28-181 · S/N 28-8490035Cancelled Mar 4, 2002 · Triennial form not returned · Built 1984 · Wilson Howard CN53122Cameron Balloons U S N 120 · S/N 6187Cancelled Dec 5, 2001 · Exported to Mexico · Built 1998 · Goss DickN145AWBoeing 737-2A6 · S/N 20194Cancelled Jun 21, 2001 · Flight Director IncN20SWBoeing 737-2H4 · S/N 21337Cancelled Jun 21, 2001 · Flight Director IncN23SWBoeing 737-2H4 · S/N 21338Cancelled Jun 21, 2001 · Flight Director IncN707HTBoeing 707-321C · S/N 19271Cancelled Jun 21, 2001 · Flight Director IncN811GBDouglas DC-8-61 · S/N 46038Cancelled Jun 21, 2001 · Flight Director IncN8956EDouglas DC-9-31 · S/N 47214Cancelled Jun 21, 2001 · Flight Director IncN6204DSmith James A JR TEAM TANGO TANGO 2 · S/N TT006Cancelled May 31, 2001 · Smith James A JrN2569RCessna 182K · S/N 18258269Cancelled Jan 25, 2001 · Triennial form not returned · Hunt Lawrence AN4005ABeech 95-B55 (T42A) · S/N TC-1318Cancelled Oct 23, 2000 · Triennial form not returned · Chatagnier Kent JN127MHughes Helicopters 369E · S/N 0219ECancelled Jun 28, 2000 · Exported to Australia · Mike Green & AssociatesN134MBell 206B · S/N 2569Cancelled May 1, 2000 · Exported to Canada · Mike Green & AssociatesN6407NCessna T210N · S/N 21062983Cancelled Apr 12, 2000 · Triennial form not returned · Leboeuf DavidN39780I.C.A.-Brasov IS-28B2 · S/N 127Cancelled Feb 1, 2000 · Exported to Colombia · Reniska KimN141MMesserschmitt-Boelkow-Blohm BO-105S · S/N S749Cancelled Jan 31, 2000 · Exported to Panama · Aerostar International Inc DBAN398AGIsrael Aircraft Industries ASTRA SPX · S/N 088Cancelled Aug 18, 1999 · Tracor IncN399AGIsrael Aircraft Industries ASTRA SPX · S/N 090Cancelled Aug 18, 1999 · Tracor IncN937MHughes Helicopters HUGHES 369D · S/N 811060DCancelled Jun 14, 1999 · Exported to South Korea · Mike Green & AssociatesN206KTBell 206B · S/N 3410Cancelled May 3, 1999 · Exported to Colombia · Aero Star International IncN1152JAero Commander 112 · S/N 171Cancelled Feb 12, 1999 · Triennial form not returned · Mitchell Gary DN7734ABell 206B · S/N 1768Cancelled Oct 31, 1998 · Autorotate IncN2065XCessna 182H · S/N 18256165Cancelled Sep 8, 1998 · Second triennial mailing, no response · Balch Mike LN30891Cessna 210L · S/N 21059972Cancelled Sep 1, 1998 · Robinson DonN819TXSimpson Kenneth L RV-4 · S/N 819Cancelled Aug 22, 1998 · Triennial form not returned · Simpson Kenneth LN53359Cessna 172P · S/N 17274726Cancelled Jul 11, 1998 · Triennial form not returned · Built 1981 · Trevino Andres JoseN47SMBeech 95-B55 (T42A) · S/N TC775Cancelled Apr 6, 1998 · Fenton Donald LN3040PPiper PA-23 · S/N 23951Cancelled Apr 1, 1998 · Triennial form not returned · State Aircraft Pooling BoardN43027Bell Helicopter Textron 206L-1 · S/N 45227Cancelled Feb 3, 1998 · Exported to Guatemala · Aerostar International IncN101CDBell 206B · S/N 2310Cancelled Jan 26, 1998 · Exported to Canada · Aerostar International IncN8358CRobinson Helicopter R22 · S/N 0263Cancelled Jan 8, 1998 · Triennial form not returned · Green Charles MichaelN94534Cessna 152 · S/N 15285709Cancelled Oct 23, 1997 · Triennial form not returned · State Of TexasN206JRBell 206B-III · S/N 4041Cancelled Sep 5, 1997 · Exported to United Kingdom · Aerostar International IncN6601DCessna 172N · S/N 17272888Cancelled Sep 5, 1997 · Triennial form not returned · Trevino Andres JN888CGRobinson Helicopter R22 BETA · S/N 0536Cancelled Aug 27, 1997 · Triennial form not returned · Rotorwing Services IncN1606ZMcdonnell Douglas Helicopter 369E · S/N 0347ECancelled Jun 20, 1997 · Exported to AustraliaN226ECBell 206B · S/N 3527Cancelled Jun 10, 1997 · Exported to Canada · Aero Star International Inc
Back to Austin, TX