Augusta, KS

Cancelled registrations · 218

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 = 'KS' AND d.registrant_city = 'AUGUSTA'
  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.

N6274VBeech D55 · S/N TE456Cancelled Jan 17, 1968 · Exported to South Africa · Air Capital Intl IncN6279VBeech D55 · S/N TE-460Cancelled Jan 17, 1968 · Exported to Australia · Built 1967 · Air Capital International IncN7033NBeech D55 · S/N TE-478Cancelled Jan 17, 1968 · Exported to Australia · Built 1967 · Air Capital International IncN7051NBeech D55 · S/N TE-481Cancelled Jan 17, 1968 · Exported to Australia · Built 1967 · Air Capital International IncN6217VBeech 56TC · S/N TG-41Cancelled Jan 3, 1968 · Exported to Australia · Built 1967 · Air Capital International IncN6266VBeech A65-8200 · S/N LC-273Cancelled Dec 11, 1967 · Exported to Australia · Air Capital International IncN16430Dehavilland DHC 6 TWIN OTTER 210 · S/N 71Cancelled Dec 6, 1967 · Exported to Australia · Air Capital International IncN6258VBeech 95-C55 · S/N TE-446Cancelled Nov 15, 1967 · Exported to Australia · Air Capital International IncN6289VBeech 95-C55 · S/N TE-448Cancelled Nov 15, 1967 · Exported to Australia · Air Capital International IncN6290VBeech 95-C55 · S/N TE-449Cancelled Nov 15, 1967 · Exported to Australia · Air Capital International IncN5414UBeech 95-C55 · S/N TE-434Cancelled Oct 6, 1967 · Exported to Australia · Air Capital International IncN5446UBeech 95-C55 · S/N TE-430Cancelled Oct 6, 1967 · Exported to Australia · Air Capital International IncN2780TBeech 35-C33 · S/N CD-1080Cancelled Apr 24, 1967 · Exported to Australia · Aircraft Ferry Co IncN2715TBeech 95-C55 · S/N TE-352Cancelled Apr 18, 1967 · Exported to Australia · Aircraft Ferry Co IncN2958KLuscombe 8A · S/N 5685Cancelled Jul 1, 1957 · Fowler Wallace WN50478Fairchild M-62A · S/N T42-3220Cancelled Nov 21, 1955 · Drouillard Jr Joe SN54646Aeronca 0-58B · S/N 058B3062Cancelled Jan 16, 1952 · Alley LawrenceN48458Ryan Aeronautical ST3KR · S/N 1072Cancelled Jan 24, 1951 · Ratliff Doyle E & Ronald Grissom
Back to Augusta, KS