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.

N33186Piper J5A · S/N 5461Cancelled Aug 19, 2011 · Revoked, pending cancellation · Built 1940 · Allison Leslie WayneN442AAMcdonnell Douglas DC-9-82(MD-82) · S/N 49468Cancelled Jul 20, 2011 · Sale reported · Built 1987N44956Partenavia P 68 OBSERVER · S/N 318-13/OBCancelled Jul 6, 2011 · Triennial form not returned · Texas Parks And Wildlife DeptN56028Ryan Aeronautical ST3KR · S/N 2014Cancelled Jul 6, 2011 · Exported to Netherlands · Built 1942 · Tornbjerg ThomasN13CWCessna T210M · S/N 21062241Cancelled Jul 5, 2011 · Exported to Mexico · Built 1977 · Young Investment Enterprizes LlpN9348WPiper PA-28-235 · S/N 28-11035Cancelled Mar 18, 2011 · Expired dealer · Built 1968 · First Executive Air IncN468SGBeech A36TC · S/N EA-147Cancelled Mar 16, 2011 · First renewal notice · Built 1980 · Knolle Guy E JrN2360ECessna 206H · S/N 20608017Cancelled Jan 31, 2011 · Exported to Australia · Wallace H DaltonN20374Eurocopter Deutschland BO-105CBS4 · S/N 881Cancelled Dec 9, 2010 · Exported to Colombia · Jmn LLCN761AVCessna T210M · S/N 21062110Cancelled Dec 8, 2010 · Exported to Mexico · Built 1977 · Campbell David JrN224CAS.A.Centrair PEGASE 101 · S/N 10100224Cancelled Nov 30, 2010 · Exported to Argentina · Miller Charles LN7FXCirrus Design SR22 · S/N 2524Cancelled Jul 13, 2010 · Exported to Brazil · Built 2007 · Walking Rain LLCN2038FEurocopter Deutschland BO-105CBS4 · S/N 887Cancelled Apr 27, 2010 · Built 1992 · Jmn LLCN601XXDrzymala Peter ZODIAC 601XL · S/N 64720Cancelled Sep 14, 2009 · Triennial form not returned · Built 2003 · Central Texas Aviation Society LLCN107SBMitsubishi MU-2B-20 · S/N 226Cancelled Aug 27, 2009 · Exported to New Zealand · Built 1972 · Flight Director IncN755QMitsubishi MU-2B-20 · S/N 131Cancelled Aug 27, 2009 · Exported to New Zealand · Built 1968 · Flight Director IncN12RAMitsubishi MU-2B-20 · S/N 177Cancelled Aug 25, 2009 · Exported to New Zealand · Built 1969 · Flight Director IncN720JKMitsubishi MU-2B-20 · S/N 154Cancelled Aug 25, 2009 · Exported to New Zealand · Built 1969 · Flight Director IncN3000HEngineering & Research 415-C · S/N 3625Cancelled Jul 27, 2009 · Registration revoked · Built 1946 · Cootes V GlennN215MMcdonnell Douglas Helicopter 600N · S/N RN016Cancelled Apr 28, 2009 · Exported to Kazakhstan · Built 1997 · Blanco 600 LLCN724TLWillis T/Rocket Flyers TURBINE LEGEND · S/N 7Cancelled Apr 1, 2009 · Triennial form not returned · Rocket Flyers LLCN91RBBarthelemy Ronnie P KR-2 · S/N RB-1Cancelled Nov 6, 2008 · Triennial form not returned · Gilmore John EN410MRRitter Mark T RV-10 · S/N 40043Cancelled Jul 25, 2008 · Ritter Mark TN18JEPiper PA-34-200T · S/N 34-8070225Cancelled Feb 8, 2008 · Exported to Israel · Built 1980 · Bernard Frank MN881GTRaytheon A36 · S/N E-3250Cancelled Nov 26, 2007 · Exported to Canada · Built 1999 · Lastrapes David MN18TACessna 207 · S/N 20700317Cancelled Jul 18, 2007 · Exported to Canada · Built 1975 · Mcaden Cumby Leasing LLCN187WWAerospatiale AS350B · S/N 1984Cancelled Jun 22, 2007 · Exported to Canada · Built 1986 · Byram Asgar Aviation LLCN36317Piper PA-32RT-300T · S/N 32R-7887034Cancelled May 19, 2007 · Triennial form not returned · Built 1978 · Abraham And Associates IncN123CKRobinson Helicopter R44 II · S/N 10190Cancelled Mar 13, 2007 · Triennial form not returned · Built 2003 · Il Falconiere Holdings LLCN8029WButler Roy JR CH-7 · S/N 99Cancelled Mar 1, 2007 · Triennial form not returned · Built 2004 · Butler Roy JrN556UHBell 412 · S/N 33178Cancelled Jan 23, 2007 · Exported to Australia · Built 1988 · Austin Jet Aircraft Sales IncN202XSBeckley Robert B G-202 · S/N 202-032Cancelled Nov 28, 2006 · Triennial form not returned · Built 1998 · Wright Andrew KN9877ZBell Helicopter Textron 206L-1 · S/N 45339Cancelled Nov 14, 2006 · Exported to Venezuela · Built 1973 · Bdb AviationN954RMRaytheon B200 · S/N BB-1868Cancelled Oct 30, 2006 · Exported to Norway · Built 2004 · Mayesair LLCN6737SCessna 150H · S/N 15067537Cancelled Oct 19, 2006 · Triennial form not returned · Built 1967 · Lupher John HN3986KCameron Balloons US N-77 · S/N 5690Cancelled Oct 17, 2006 · Triennial form not returned · Built 1991 · Goss Richard LN6372ACessna 182 · S/N 33172Cancelled Sep 28, 2006 · Triennial form not returned · Built 1956 · Jbls Enterprises IncN53385Christen Industries PITTS S-2B · S/N 5076Cancelled Sep 12, 2006 · Exported to Kenya · Pitts Air Fun IncN68SFAmerican Champion 8KCAB · S/N 816-98Cancelled Sep 11, 2006 · Exported to Chile · Built 1998 · Acrobatic Training Com IncN6066PCameron Balloons US A-105 · S/N 5489Cancelled Jun 29, 2006 · Triennial form not returned · Built 1988 · Goss Richard LN14TPSwearingen SA-226T · S/N T-220Cancelled Dec 15, 2005 · Exported to Mexico · Built 1972 · Bradford W Lee Investments IncN407TRBell 407 · S/N 53524Cancelled Nov 15, 2005 · Exported to Canada · Built 2002 · Austin Jet Aircraft Sales IncN7813VMooney M20C · S/N 2797Cancelled Sep 9, 2005 · Registration revoked · Built 1964 · Briggs Clifford AN427LMHard Jim G CAPELLA XLS · S/N FW2C80TR172962Cancelled Jan 31, 2005 · Triennial form not returned · Built 1999 · Hard Jim GN1137VHughes 369HS · S/N 730496SCancelled Jan 6, 2005 · Second triennial mailing, no response · Autorotate IncN533AJBell 407 · S/N 53362Cancelled Dec 21, 2004 · Exported to Canada · Austin Jet Aircraft Sales IncN401TACessna 172RG · S/N 172RG0142Cancelled Aug 20, 2004 · Triennial form not returned · Built 1979 · Topnotch Aviation IncN6388FCessna 172N · S/N 17273215Cancelled Aug 20, 2004 · Triennial form not returned · Built 1979 · Topnotch Aviation IncN374FDAirbus Industrie A300-600 · S/N 374Cancelled Aug 11, 2004 · Triennial form not returned · Flight Director IncN10549Maule M-7-235C · S/N 25023CCancelled Jun 25, 2004 · Exported to Canada · Built 1998 · Neely Byron D Md
Back to Austin, TX