Waco, TX

Cancelled registrations · 159

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

N697RACessna 414A · S/N 414A0517Cancelled Jan 14, 1998 · Exported to Mexico · Ram Aircraft CorporationN3679RPiper PA-28-180 · S/N 285780Cancelled Jun 19, 1995 · Triennial form not returned · Phillips James WN810GFRockwell International 690B · S/N 11358Cancelled Feb 19, 1993 · Exported to Venezuela · Golconda Capital CorporationN1656WBeech 95-B55 (T42A) · S/N TC1470Cancelled Jun 3, 1992 · Exported to South Africa · C And S Air Spares IncN4541QCessna 310Q · S/N 310Q0727Cancelled May 14, 1992 · Exported to Namibia · C & S Air Spares IncN761MTCessna 210M · S/N 21062370Cancelled Dec 12, 1991 · Exported to Namibia · C And S Air Spares IncN88668Cessna 404 · S/N 4040210Cancelled Sep 26, 1991 · Exported to Namibia · C & S Air Spares IncN12ZBBalsoy Zeki RV-4 · S/N 1460Cancelled May 13, 1991 · Exported to Turkey · Balsoy ZekiN872TADouglas DC-6A · S/N 44668Cancelled Apr 25, 1991 · Exported to Namibia · C & S Air Spares IncN3890TPiper PA-28R-180 · S/N 28R-30218Cancelled Nov 5, 1979 · Exported to Canada · Miller BuddyN3724WPiper PA-32-260 · S/N 32-636Cancelled Jul 6, 1977 · Built 1966 · Broussard Alvin RN17SMMayhew CASSUTT-IIIM · S/N 1-SMCancelled Oct 12, 1976 · Mayhew Sammy PN6048TCessna 150D · S/N 15060748Cancelled May 26, 1976 · Stahl Joseph AN986QBeech 95-A55 · S/N TC-204Cancelled Aug 27, 1975 · Grossenbacher Clyde RN88530Piper J3C-65 · S/N 16155Cancelled Jun 10, 1975 · Built 1946 · Texas State Technical InstituteN26926Piper J3C-65 · S/N 4253Cancelled May 8, 1975 · Texas State Technical InstituteN3941JCessna 150G · S/N 15065241Cancelled May 8, 1975 · Built 1966 · Professional Flight IncN9221Vertol H21C · S/N 52-8634Cancelled May 5, 1975 · James Connally Technical InstituteN1789GCessna 310R · S/N 310R0047Cancelled Apr 9, 1975 · Exported to Brazil · Riley Turbostream CorpN60533Cessna 150J · S/N 15070380Cancelled Jul 3, 1974 · Exported to Canada · Raburn Aviation IncN7975LBeech A23-19 · S/N MB-156Cancelled Dec 6, 1973 · Exported to Canada · Waco-Aire IncN6906GCessna 150 · S/N 15072406Cancelled Oct 2, 1973 · Waco AireincN5047TPiper PA-28-180 · S/N 28-7205242Cancelled Oct 1, 1973 · Built 1972 · Raburn Aviation Inc DBA Waco AireN39293Taylorcraft BC12-D · S/N 6546Cancelled Nov 5, 1971 · Julian AronsonN7953DBeech H35 · S/N D5291Cancelled Jun 8, 1971 · Steakley R W JrN4571Bensen Gyrocoper B-8M · S/N 1Cancelled Jul 15, 1970 · Tanner Bobbie JN3916Pietenpol AIR CAMPER · S/N HR1Cancelled Jun 26, 1970 · Ricks Homer LN6127UCougar 1 · S/N 63062Cancelled Aug 12, 1969 · Clough Leroy DN6625MStinson 108-3 · S/N 108-4625Cancelled Nov 9, 1967 · Ralph B Payne Jr & Cecil A PalmerN47647Taylorcraft DCO-65 · S/N L-5409Cancelled Jun 23, 1965 · Built 1944 · Connally Aero ClubN3795EAeronca 7AC · S/N 7AC-7074Cancelled May 25, 1965 · Waco Aviation School IncN6746TCessna 310D · S/N 39046Cancelled Jan 19, 1965 · Exported to Mexico · Servion CorporationN81682Aeronca 7AC · S/N 7AC-301Cancelled Mar 19, 1956 · Niswanger Paul WN64664Stinson L-5 · S/N 76-214Cancelled Feb 17, 1956 · Aircraft Services CoN65170Consolidated Vultee SNV-1 · S/N 10427Cancelled Feb 17, 1956 · Acker Charles IrvinN62170Consolidated Vultee BT-13A · S/N 1800Cancelled Feb 15, 1956 · Tubb BillyN3127EAeronca 7AC · S/N 7AC-6724Cancelled Oct 7, 1953 · Waco Aviation School IncN1732NCessna 120 · S/N 11976Cancelled Apr 15, 1953 · Byrne J HN1441EAeronca 7AC · S/N 7AC-5004Cancelled Aug 27, 1952 · Built 1946 · Waco Aviation School IncN4489NConsolidated Vultee SNV-1 · S/N 7488Cancelled Apr 24, 1951 · Aircraft Services CoN4400NFairchild M-62A-3 · S/N FZ332Cancelled Mar 2, 1951 · Waco Aviation School IncN22286Taylorcraft BF · S/N 1236Cancelled May 5, 1950 · Adamek Theadore JN36841Aeronca 65-CA · S/N CA17751Cancelled Nov 2, 1949 · Built 1941 · Curton RalphN91072Consolidated Vultee BT-15 · S/N 7674Cancelled Apr 29, 1949 · Waco Aero Sales And ServiceN1864VCessna 140 · S/N 14044Cancelled Apr 14, 1949 · Exported to Mexico · Acker Flying ServiceN75445Stinson SR-8B · S/N 9814Cancelled Feb 18, 1949 · Sims-Walker Aviation CoN75479Cessna T-50 · S/N 6344Cancelled Feb 18, 1949 · Sims Walker Aviation CoN47694Taylorcraft DCO-65 · S/N 4526Cancelled Nov 3, 1948 · Built 1945 · Johnson George W & Johnson Layton WoodrowN33958Taylorcraft BC12-65 · S/N 2810Cancelled Aug 13, 1948 · Exported to Mexico · Rose Mary SpeightN16279Aeronautical Corp Of America AERONCA LA · S/N 2024Cancelled Aug 4, 1948 · Ruble Angier
Back to Waco, TX