OpenAirDocs.org
Temple, TX

Cancelled registrations · 38

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

N407EECessna 310F · S/N 310-0022Cancelled Jun 4, 2022 · Registration expired, pending cancellation · Built 1960 · Taylor Aaron LN45036Naval Aircraft Factory N3N-3 · S/N 4493Cancelled Oct 3, 2020 · Sale reported, canceledN1283TEipper QUICKSILVER GT · S/N GT2801064Cancelled Nov 1, 2019 · Registration expired, pending cancellation · Built 1985 · Redwine John LN1701YWard Steven J ROTORWAY EXEC · S/N W1A2R3DCancelled Sep 13, 2018 · Registration expired, pending cancellation · Ward Steven JN75379Powrachute PEGASUS · S/N A-230-PEGCancelled May 31, 2018 · Sale reported, canceled · Built 2004N902CPSchweizer 269C · S/N S1715Cancelled Apr 4, 2018 · Registration expired, pending cancellation · Built 1995 · Kachemak Bay Flying Service IncN1684TPiper PA-28-140 · S/N 28-7125001Cancelled Mar 13, 2018 · Registration expired, pending cancellation · Built 1970 · Campbell Alan JN50561Butterfly GOLDEN BUTTERFLY · S/N GB2001Cancelled Feb 8, 2018 · Registration expired, pending cancellation · Built 2008 · Summit Aviation IncN242JPPrudhomme Jean Joseph VELOCITY RG173 · S/N DM0230Cancelled Jan 16, 2018 · Registration expired, pending cancellation · Built 1994 · Olivieri Damian LN59151Consolidated Vultee BT-13A · S/N 2030Cancelled Oct 28, 2017 · Revoked, pending cancellation · Built 1941 · Jackson WilburnN7663YPiper PA-30 · S/N 30-741Cancelled Oct 6, 2017 · Built 1965 · Walters Jeremy KN7052ZHughes 269A · S/N 67-16707Cancelled Jul 7, 2017 · Registration expired, pending cancellation · Built 1968 · Vista Aviation LLCN5116XBeevers David R SKY RAIDER · S/N 001Cancelled Jul 6, 2017 · Registration expired, pending cancellation · Beevers David RN9064NHughes 269A · S/N 96-0657Cancelled Nov 25, 2014 · Registration expired, pending cancellation · Built 1966 · Vista Aviation LLCN73272Bell 47J-2 · S/N 2853Cancelled Nov 17, 2014 · Registration expired, pending cancellation · Built 1963 · Vista Aviation LLCN2311BTemco GC-1B · S/N 3611Cancelled Nov 12, 2013 · Registration expired, pending cancellation · Built 1948 · Maddox Roy DBA Cat EntN277DBSud SA 318C ALOUETTE AST · S/N 2027Cancelled Nov 4, 2013 · Third renewal notice · Built 1968 · Vista Aviation LLCN8109QDennis Donald H PTERODACTYL ACENDER · S/N 110757DACCancelled Sep 20, 2013 · Registration expired, pending cancellation · Built 1989 · Dennis Donald HN55642Piper PA-32-300 · S/N 32-7340130Cancelled Jun 13, 2013 · Registration expired, pending cancellation · Built 1973 · Glover Jimmy CN9224FHughes 369HS · S/N 1040658SCancelled May 22, 2013 · Registration expired, pending cancellation · Built 1975 · Bandas Helo IncN1070NHughes 269A · S/N 970719Cancelled Mar 19, 2013 · Registration expired, pending cancellation · Built 1967 · Vista Aviation LLCN30350Piper J4A · S/N 41178Cancelled Sep 5, 2012 · Sale reported, canceled · Built 1940N9583LGrumman American Avn. AA-5 · S/N AA5-0583Cancelled Nov 5, 2009 · Triennial form not returned · Built 1974 · Tidball Jon PN1BBPiper PA-34-200 · S/N 34-7250085Cancelled Feb 22, 2008 · Exported to Canada · Built 1972 · Twintime LLCN61198Cessna 150J · S/N 15070882Cancelled May 20, 1995 · Second triennial mailing, no response · Baldridge Nathan EN222MMPiper PA-28-180 · S/N 287305352Cancelled Nov 12, 1992 · Exported to Germany · Brown V E JrN46357Greiner BIRDMAN TL-1A · S/N 258Cancelled Aug 22, 1984 · Built 1977 · Greiner John H JrN52070Cessna 172P · S/N 17274405Cancelled Jan 30, 1982 · Thornton David CN3647APiper PA-22-135 · S/N 22-1907Cancelled May 20, 1965 · Cearley DaleN1105CPiper PA-22-135 · S/N 22-952Cancelled May 18, 1965 · Jones Maxwell CN75588Beech C18S · S/N 5647Cancelled Apr 15, 1965 · Tomecek W JN6845ACessna 172 · S/N 28945Cancelled Nov 25, 1959 · Wendland ErrellN8647ABeech A35 · S/N D-2057Cancelled Mar 7, 1956 · Exported to Mexico · Built 1949 · Reed Elmer GN4649NConsolidated Vultee BT-13A · S/N 10149Cancelled Feb 25, 1953 · Herndon Charles DN4449NConsolidated Vultee BT-13A · S/N 5322Cancelled Jan 5, 1953 · Lt Herndon Charles DN75711Cessna T-50 · S/N 3033Cancelled Feb 16, 1949 · Allen AirwaysN852HTexas Aero TEMPLE COMMERCIAL WG · S/N S-102Cancelled Sep 26, 1930 · Built 1929 · Texas Aero CorpN7458Texas Aero TEMPLE C4 · S/N X101Cancelled Oct 17, 1929 · Texas Aero Corp
Back to Temple, TX