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.

N6078HPiper PA-28-161 · S/N 28-7816219Cancelled Feb 2, 1982 · Exported to Canada · Aviation Training Center IncN2211CCessna 180 · S/N 30511Cancelled Dec 21, 1981 · Built 1953 · Segall Bernard E JrN803WRWindecker A/C7 · S/N 002Cancelled Dec 17, 1981 · University Of Texas At AustinN87302Cessna 310R · S/N 310R0507Cancelled Sep 16, 1980 · Ausco IIN58144Bell 206B · S/N 1109Cancelled Sep 5, 1980 · Exported to Canada · Haufler Trucking IncN111MKBeech 65-A80 · S/N LD-229Cancelled Jul 11, 1980 · Built 1965 · Texas Dept Of Public SafetyN87599Grumman American Avn. AA-1A · S/N AA1A-0086Cancelled Feb 14, 1980 · Exported to United Kingdom · Huntley LeeN4564HMooney M20K · S/N 25-0027Cancelled Feb 7, 1980 · Exported to Switzerland · Built 1979 · Goldstern Peter PN13606Cessna 172M · S/N 17262878Cancelled Jan 29, 1980 · Exported to Paraguay · Built 1974 · La Rue Travis LN92179North American NAVION A · S/N NAV4604Cancelled Jan 23, 1980 · Hinkle James DN80448Cessna 172M · S/N 17266590Cancelled Oct 12, 1979 · Exported to Belize · Kommand Aire Klub IncN4089XAero Commander 100-180 · S/N 5189Cancelled Jul 3, 1979 · Exported to Canada · Built 1971 · Aviation Training Center IncqN4563HMooney M20K · S/N 25-0017Cancelled Apr 24, 1979 · Exported to Germany · Built 1978 · Goldstern PeterN6693PPiper PA-24-250 · S/N 24-1817Cancelled Jan 23, 1978 · Turner James TN1074HCessna T337C · S/N 337-0858Cancelled Nov 23, 1977 · Francis Hospitels IncN54204Piper PA-23-250 (6PCLM) · S/N 27-7554002Cancelled Aug 8, 1977 · Exported to Mexico · Aviation Training Centers IncN11941Cessna 150L · S/N 15075719Cancelled Feb 1, 1977 · Kommand Aire Klub IncN5596YPiper PA-23-250 (6PCLM) · S/N 27-2703Cancelled Nov 29, 1976 · Exported to Canada · Malernee James K JrN187ANewman MINI-PLANE · S/N J-101-NCancelled Sep 8, 1976 · Built 1974 · Godwin CodyN2244GCessna 182A · S/N 51544Cancelled Aug 6, 1976 · Austin Equipment Rentals IncN1710Glasflugel BS-1 · S/N 9Cancelled May 20, 1976 · Built 1967 · University Of TexasN97757Piper PA-28R-200 · S/N 28R-7535119Cancelled Dec 15, 1975 · Exported to Canada · Haufler ExcavatingN4373QCessna 172L · S/N 17260273Cancelled May 30, 1975 · Exported to Canada · Built 1971 · Kommand Aire Klub IncN1955QCessna 177RG · S/N 177RG0355Cancelled May 7, 1975 · Built 1973 · Ragsdale Aviation IncN52891Cessna 182P · S/N 182-62930Cancelled Oct 15, 1974 · Exported to Mexico · Built 1974 · Ragsdale Aviation IncN7234YPiper PA-30 · S/N 30-258Cancelled Jul 2, 1974 · Capital Credit CoN8461RPiper PA-28-140 · S/N 28-22364Cancelled Apr 24, 1974 · Built 1966 · Bergstrom Aero ClubN2005UMaule M-4-220C · S/N 2007CCancelled Feb 5, 1974 · Goff Elbert WN6001RCessna 172G · S/N 17253670Cancelled Jul 9, 1973 · Exported to Canada · Rogers Edwin JN177RHBeech V35 · S/N D-8141Cancelled Jun 25, 1973 · Joe Duckworth And Thomas Mcelhenney DBA Ausco IIN3319SCessna 210J · S/N 21059119Cancelled Apr 4, 1973 · Kommand Aire Klub IncN3929GCessna TU206C · S/N TU206-0929Cancelled May 11, 1972 · Exported to France · Ragsdale Aviation IncN1436WBell 206A · S/N 382Cancelled May 2, 1972 · Texas Dept Of Public SafteyN5269QCessna 150L · S/N 15073169Cancelled Mar 3, 1972 · Exported to Mexico · Ragsdale Aviation IncN36457Taylorcraft BF-65 · S/N 3273Cancelled Jan 28, 1972 · Built 1941 · Womack Rob LeeN3466WPiper PA-32-260 · S/N 32-339Cancelled May 16, 1971 · Cotton Bill Webb B T And Hibbert Jr William AN3973ABeech A45 · S/N G-102Cancelled Apr 1, 1971 · United States Air ForceN97325Stinson 108-3 · S/N 108-4433Cancelled Apr 1, 1971 · Built 1948 · Haverlah Dennis WN75545Fairchild PT-26 · S/N FV 653Cancelled Feb 9, 1971 · Ragsdale Flying ServiceN875BMooney M20 · S/N 1037Cancelled Sep 18, 1970 · King LesN36420Taylorcraft DC-65 · S/N 4161Cancelled Jul 13, 1970 · Ragsdale Flying ServiceN2184HEngineering & Research ERCOUPE 415-C · S/N 2807Cancelled Jul 2, 1970 · Allen H RummelN1661Beech D50C · S/N DH257Cancelled May 11, 1970 · Davis Tom HN6375SCessna 150G · S/N 15067175Cancelled Dec 31, 1969 · Longhorn Flying Club IncN95155Taylorcraft BC12-D · S/N 9555Cancelled Aug 23, 1968 · Tims Airpark IncN4792ZPiper PA-22-108 · S/N 22-8356Cancelled Jun 27, 1968 · Built 1961 · Kirtley Lloyd WN5942PPiper PA-24-250 · S/N 24-1032Cancelled Jun 17, 1968 · Hidell R RN1118QCessna 310H · S/N 310H0118Cancelled Jan 22, 1968 · Ragsdale Aviation IncN9622SChampion 7GCAA · S/N 7GCAA-55Cancelled Nov 13, 1967 · Built 1966 · Longhorn Aerobatic Club IncN33LAero Commander 520 · S/N 52Cancelled Feb 23, 1966 · Kramer J Fred
Back to Austin, TX