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.

N4362ABeech B-55 · S/N TC-1333Cancelled Apr 15, 1970 · Exported to Australia · Air Capital International IncN4667ABeech V35B · S/N D-9132Cancelled Apr 15, 1970 · Exported to Australia · Air Capital International IncN3310XCessna 310L · S/N 310L0160Cancelled Apr 13, 1970 · Exported to Australia · Redwing Aviation IncN3680ABeech 95-B55 (T42A) · S/N TC-1334Cancelled Apr 9, 1970 · Exported to South Africa · Air Capital International IncN4085QCessna 402 · S/N 402-0185Cancelled Mar 25, 1970 · Exported to Australia · Built 1968 · Air Capital International IncN4271ABeech A36 · S/N E-208Cancelled Mar 25, 1970 · Exported to South Africa · Air Capital International IncN4089ABeech 70 · S/N LB-29Cancelled Mar 24, 1970 · Exported to Australia · Air Capital International IncN4187ABeech V35B · S/N D-9122Cancelled Mar 13, 1970 · Exported to South Africa · Air Capital International IncN4055ABeech E-55 · S/N TE-788Cancelled Mar 10, 1970 · Exported to Australia · Air Capital Intl IncN4090ABeech 95-B55 · S/N TC-1323Cancelled Mar 10, 1970 · Exported to Australia · Built 1970 · Air Capital International IncN4094ABeech E-55 · S/N TE-791Cancelled Mar 10, 1970 · Exported to Australia · Air Capital Intl IncN4160ABeech A36 · S/N E-205Cancelled Mar 10, 1970 · Exported to Australia · Air Capital International IncN2414ABeech 95-B55 (T42A) · S/N TC-1316Cancelled Feb 27, 1970 · Exported to Australia · Air Capital International IncN3529ABeech B-55 · S/N TC-1317Cancelled Feb 27, 1970 · Exported to Australia · Air Capital International IncN4049ABeech A36 · S/N E-197Cancelled Feb 27, 1970 · Exported to Australia · Air Capital International IncN4054ABeech V35B · S/N D-9100Cancelled Feb 27, 1970 · Exported to Australia · Air Capital International IncN4087ABeech V35B · S/N D-9105Cancelled Feb 27, 1970 · Exported to Australia · Air Capital International IncN4058ABeech 58 · S/N TH-10Cancelled Feb 26, 1970 · Exported to South Africa · Air Capital International IncN4154ABeech V35A · S/N D-9113Cancelled Feb 26, 1970 · Exported to South Africa · Air Capital International IncN8861Dehavilland DHC-6 TWIN OTTER · S/N 277Cancelled Feb 10, 1970 · Air Capital International IncN4067ABeech A36 · S/N E-198Cancelled Feb 3, 1970 · Exported to South Africa · Air Capital Intl IncN3469ABeech V35B · S/N D-9074Cancelled Jan 22, 1970 · Exported to South Africa · Air Capital International IncN3946ABeech V35B · S/N D-9085Cancelled Jan 20, 1970 · Exported to South Africa · Air Capital International IncN3953ABeech A36 · S/N E-192Cancelled Jan 20, 1970 · Exported to South Africa · Air Capital International IncN3507ABeech 95-B55 (T42A) · S/N TC-1303Cancelled Jan 19, 1970 · Exported to South Africa · Air Capital Intl IncN3465ABeech E-55 · S/N TE-773Cancelled Jan 8, 1970 · Exported to Australia · Air Capital International IncN3062ABeech 36 · S/N E-184Cancelled Dec 3, 1969 · Exported to Australia · Built 1969 · Air Capital International IncN2841ABeech 95-B55 · S/N TC-1295Cancelled Nov 26, 1969 · Exported to South Africa · Air Capital International IncN2906ABeech D55 · S/N TE-761Cancelled Nov 3, 1969 · Exported to South Africa · Air Capital Intl IncN2757ABeech 36 · S/N E-174Cancelled Oct 21, 1969 · Exported to South Africa · Air Capital International IncN925BABeech B90 · S/N LJ-402Cancelled Oct 10, 1969 · Exported to South Africa · Air Capital International IncN3170ABeech 70 · S/N LB-19Cancelled Oct 2, 1969 · Exported to Australia · Air Capital International IncN3426ABeech 65-B80 · S/N LD424Cancelled Sep 29, 1969 · Exported to Australia · Air Capital International IncN1082ABeech D55 · S/N TE-751Cancelled Sep 26, 1969 · Exported to Australia · Built 1969 · Air Capital International IncN1439ABeech 36 · S/N E-171Cancelled Sep 26, 1969 · Exported to South Africa · Built 1969 · Air Capital International IncN2326ABeech D55 · S/N TE-750Cancelled Sep 17, 1969 · Exported to Australia · Air Capital International IncN2109ABeech A23-24 · S/N MA-358Cancelled Sep 12, 1969 · Exported to South Africa · Air Capitalintl IncN8109RBeech D55 · S/N TE-742Cancelled Sep 8, 1969 · Exported to Australia · Built 1969 · Air Capital International IncN1632ABeech V35A · S/N D-9037Cancelled Sep 4, 1969 · Exported to South Africa · Air Capital Intl IncN2290ABeech D55 · S/N TE-749Cancelled Sep 4, 1969 · Exported to South Africa · Air Capital Intl IncN2627ABeech V35A · S/N D-9043Cancelled Sep 4, 1969 · Exported to South Africa · Air Capital International IncN1448ABeech D55 · S/N TE-737Cancelled Aug 29, 1969 · Exported to Australia · Air Capital International IncN8003RBeech D55 · S/N TE-728Cancelled Aug 26, 1969 · Exported to Australia · Air Capital International IncN7992RBeech 36 · S/N E-168Cancelled Aug 22, 1969 · Exported to Australia · Air Capital International IncN8098RBeech 36 · S/N E-169Cancelled Aug 22, 1969 · Exported to Australia · Air Capital International IncN1223ABeech D55 · S/N TE-734Cancelled Aug 1, 1969 · Exported to Australia · Built 1969 · Air Capital International IncN8114RBeech V35A · S/N D-9025Cancelled Jul 31, 1969 · Exported to Australia · Air Capital International IncN1134ABeech V35A · S/N D-9005Cancelled Jul 16, 1969 · Exported to South Africa · Built 1969 · Air Capital International IncN7984RBeech D55 · S/N TE-713Cancelled Jul 9, 1969 · Exported to Australia · Air Capital International IncN7988RBeech 95-B55 (T42A) · S/N TC-1239Cancelled Jul 8, 1969 · Exported to Australia · Air Capital International Inc
Back to Augusta, KS