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.

N2098ABeech 95-B55 · S/N TC-1217Cancelled Jul 1, 1969 · Exported to South Africa · Air Capital Intl IncN6458VHelio H-295 · S/N 1410Cancelled Jun 27, 1969 · Exported to South Africa · Air Capitol International IncN7648NBeech 60 · S/N P-45Cancelled Jun 24, 1969 · Exported to Australia · Air Capital International IncN7991RBeech 36 · S/N E-151Cancelled Jun 4, 1969 · Exported to Australia · Air Capital International IncN7974RBeech V35A · S/N D-8970Cancelled May 21, 1969 · Exported to Australia · Air Capital International IncN7982RBeech V35A · S/N D-8971Cancelled May 21, 1969 · Exported to Australia · Air Capital International IncN8070RBeech 70 · S/N LB-2Cancelled Apr 24, 1969 · Exported to Australia · Air Capital International IncN7723RBeech D55 · S/N TE-638Cancelled Mar 26, 1969 · Exported to Australia · Air Capital International IncN7727RBeech D55 · S/N TE646Cancelled Mar 26, 1969 · Exported to Australia · Air Capital International IncN7751RBeech 95-B55 (T42A) · S/N TC-1177Cancelled Mar 26, 1969 · Exported to Australia · Air Capital International IncN7717RBeech D55 · S/N TE-642Cancelled Mar 10, 1969 · Exported to Australia · Air Capital International IncN7808RBeech E33 · S/N CD-1172Cancelled Feb 19, 1969 · Exported to South Africa · Air Capital International IncN7718RBeech 95-B55 (T42A) · S/N TC-1162Cancelled Feb 14, 1969 · Exported to Australia · Air Capital International IncN7778RBeech 36 · S/N E-123Cancelled Feb 14, 1969 · Exported to Australia · Air Capital International IncN7787RBeech 36 · S/N E-124Cancelled Feb 14, 1969 · Exported to Australia · Air Capital International IncN7868RBeech V35A · S/N D-8863Cancelled Feb 14, 1969 · Exported to Australia · Air Capital International IncN7885RBeech V35A · S/N D-8864Cancelled Feb 14, 1969 · Exported to Australia · Air Capital International IncN8482NBeech B90 · S/N LJ-397Cancelled Dec 13, 1968 · Exported to South Africa · Air Capital International IncN7702RBeech D55 · S/N TE-631Cancelled Nov 20, 1968 · Exported to South Africa · Air Capital Int'L IncN7649NBeech 95-B55 (T42A) · S/N TC-1155Cancelled Nov 14, 1968 · Exported to Australia · Air Capital International IncN7628NBeech D55 · S/N TE-619Cancelled Nov 1, 1968 · Exported to Australia · Air Capital International IncN7720RBeech 36 · S/N E-84Cancelled Nov 1, 1968 · Exported to Australia · Air Capital International IncN8439NBeech A65-8200 · S/N LC-300Cancelled Nov 1, 1968 · Exported to Australia · Air Capital International IncN8438NBeech A65 · S/N LC-298Cancelled Oct 21, 1968 · Exported to Australia · Air Capital International IncN7627NBeech D55 · S/N TE-624Cancelled Oct 18, 1968 · Exported to Australia · Air Capital International IncN8416NBeech D55 · S/N TE-592Cancelled Oct 18, 1968 · Exported to Australia · Air Capital International IncN7520NBeech E33A · S/N CE-233Cancelled Oct 17, 1968 · Exported to South Africa · Air Capital International IncN7667NBeech D55 · S/N TE-618Cancelled Oct 7, 1968 · Exported to Australia · Air Capital International IncN8338NBeech 95-B55 (T42A) · S/N TC-1124Cancelled Oct 7, 1968 · Exported to Australia · Air Capital International IncN7662NBeech 36 · S/N E-50Cancelled Oct 4, 1968 · Exported to Australia · Air Capital Intl IncN146JBeech 95-B55 · S/N TC-688Cancelled Sep 23, 1968 · Exported to Australia · Air Capital Intl IncN8467NBeech D55 · S/N TE-578Cancelled Sep 17, 1968 · Exported to Australia · Air Capital International IncN7481NBeech 36 · S/N E-25Cancelled Sep 16, 1968 · Exported to Australia · Air Capital International IncN7482NBeech 36 · S/N E-30Cancelled Sep 16, 1968 · Exported to Australia · Air Capital International IncN7483NBeech 36 · S/N E-35Cancelled Sep 16, 1968 · Exported to Australia · Air Capital International IncN7489NBeech 95-B55 · S/N TC-1133Cancelled Sep 13, 1968 · Exported to Australia · Air Capital International IncN3700QBeech A65-8200 · S/N LC-295Cancelled Sep 12, 1968 · Exported to Australia · Air Capital International IncN7748RBeech V35A · S/N D-8860Cancelled Sep 12, 1968 · Exported to South Africa · Air Capital International IncN8349NBeech B-55 · S/N TC-1086Cancelled Jun 7, 1968 · Exported to Australia · Air Capital International IncN6246VBeech 56TC · S/N TG-51Cancelled Jun 4, 1968 · Exported to South Africa · Air Capital International IncN7139NBeech D55 · S/N TE-514Cancelled Apr 15, 1968 · Exported to Australia · Air Capital International IncN7024NBeech D55 · S/N TE-469Cancelled Mar 22, 1968 · Exported to Australia · Air Capital International IncN7137NBeech B-55 · S/N TC-1061Cancelled Mar 20, 1968 · Exported to Australia · Built 1968 · Air Capital International IncN8365NBeech V35 · S/N D-8521Cancelled Mar 6, 1968 · Exported to South Africa · Air Capital International IncN7161NBeech D55 · S/N TE-505Cancelled Feb 23, 1968 · Exported to Australia · Air Capital International IncN7060NBeech D55 · S/N TE-502Cancelled Feb 15, 1968 · Exported to Australia · Air Capital International IncN7037NBeech D55 · S/N TE-471Cancelled Feb 7, 1968 · Exported to Australia · Air Capital International IncN7056NBeech A65 · S/N LC-277Cancelled Feb 6, 1968 · Exported to Australia · Air Capital International IncN7120NBeech D55 · S/N TE-498Cancelled Feb 6, 1968 · Exported to Australia · Air Capital International IncN1566Dehavilland DHC-6 · S/N 80Cancelled Jan 18, 1968 · Exported to Australia · Air Capital International Inc
Back to Augusta, KS