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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N697RACessna 414A · S/N 414A0517N3679RPiper PA-28-180 · S/N 285780N810GFRockwell International 690B · S/N 11358N1656WBeech 95-B55 (T42A) · S/N TC1470N4541QCessna 310Q · S/N 310Q0727N761MTCessna 210M · S/N 21062370N88668Cessna 404 · S/N 4040210N12ZBBalsoy Zeki RV-4 · S/N 1460N872TADouglas DC-6A · S/N 44668N3890TPiper PA-28R-180 · S/N 28R-30218N3724WPiper PA-32-260 · S/N 32-636N17SMMayhew CASSUTT-IIIM · S/N 1-SMN6048TCessna 150D · S/N 15060748N986QBeech 95-A55 · S/N TC-204N88530Piper J3C-65 · S/N 16155N26926Piper J3C-65 · S/N 4253N3941JCessna 150G · S/N 15065241N9221Vertol H21C · S/N 52-8634N1789GCessna 310R · S/N 310R0047N60533Cessna 150J · S/N 15070380N7975LBeech A23-19 · S/N MB-156N6906GCessna 150 · S/N 15072406N5047TPiper PA-28-180 · S/N 28-7205242N39293Taylorcraft BC12-D · S/N 6546N7953DBeech H35 · S/N D5291N4571Bensen Gyrocoper B-8M · S/N 1N3916Pietenpol AIR CAMPER · S/N HR1N6127UCougar 1 · S/N 63062N6625MStinson 108-3 · S/N 108-4625N47647Taylorcraft DCO-65 · S/N L-5409N3795EAeronca 7AC · S/N 7AC-7074N6746TCessna 310D · S/N 39046N81682Aeronca 7AC · S/N 7AC-301N64664Stinson L-5 · S/N 76-214N65170Consolidated Vultee SNV-1 · S/N 10427N62170Consolidated Vultee BT-13A · S/N 1800N3127EAeronca 7AC · S/N 7AC-6724N1732NCessna 120 · S/N 11976N1441EAeronca 7AC · S/N 7AC-5004N4489NConsolidated Vultee SNV-1 · S/N 7488N4400NFairchild M-62A-3 · S/N FZ332N22286Taylorcraft BF · S/N 1236N36841Aeronca 65-CA · S/N CA17751N91072Consolidated Vultee BT-15 · S/N 7674N1864VCessna 140 · S/N 14044N75445Stinson SR-8B · S/N 9814N75479Cessna T-50 · S/N 6344N47694Taylorcraft DCO-65 · S/N 4526N33958Taylorcraft BC12-65 · S/N 2810N16279Aeronautical Corp Of America AERONCA LA · S/N 2024
Back to Waco, TX