OpenAirDocs.org
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.

N759FSCessna 182Q · S/N 18265964Cancelled Jun 28, 1977 · Exported to New Zealand · World Air LtdN5450GCessna 404 · S/N 4040067Cancelled Apr 21, 1977 · Exported to New Zealand · World Air LtdN7391NCessna U206G · S/N U20603648Cancelled Apr 13, 1977 · Exported to New Zealand · World Air LtdN7386SCessna 182Q · S/N 18265177Cancelled Jan 18, 1977 · Exported to New Zealand · World Air LtdN8772QCessna U206G · S/N U20603525Cancelled Dec 30, 1976 · Exported to New Zealand · World Air LtdN5303JCessna 421C · S/N 421C0167Cancelled Dec 23, 1976 · Exported to South Africa · World Air LtdN8798QCessna U206G · S/N U20603550Cancelled Dec 23, 1976 · Exported to New Zealand · World Air LtdN23867Beech A36 · S/N E-933Cancelled Dec 13, 1976 · Exported to New Zealand · Built 1976 · World Air LtdN1539LBeech A36 · S/N E-871Cancelled Sep 15, 1976 · Exported to Japan · Built 1976 · World Air LtdN1522LBeech A36 · S/N E-828Cancelled Apr 16, 1976 · Exported to Japan · Built 1976 · World Air LtdN1518LBeech A36 · S/N E-817Cancelled Apr 2, 1976 · Exported to Japan · World Air LtdN9390SBeech A36 · S/N E-759Cancelled Nov 4, 1975 · Exported to New Zealand · Built 1975 · World Air LtdN9730SBeech 200 · S/N BB-74Cancelled Aug 22, 1975 · Exported to Australia · World Air LimitedN8182RBeech 58 · S/N TH-526Cancelled Nov 12, 1974 · Exported to Australia · World Air LtdN91110Cessna 207 · S/N 20700076Cancelled Jan 14, 1971 · Aircraft Facilities International IncN3422QCessna 320E · S/N 320E0022Cancelled Dec 23, 1970 · Built 1966 · Aircraft Ferry Co IncN4572QCessna 402A · S/N 402A0072Cancelled Oct 27, 1970 · Exported to Australia · Air Capital Intl IncN976EBeech 95-B55 (T42A) · S/N TC-1282Cancelled Sep 24, 1970 · Exported to South Africa · Air Capital International IncN6201QCessna 401A · S/N 401A0001Cancelled Sep 11, 1970 · Exported to Australia · Air Capital InternationN975EBeech 95-B55 (T42A) · S/N TC-1281Cancelled Sep 11, 1970 · Exported to South Africa · Air Capital International IncN335TBeech 58 · S/N TH-48Cancelled Sep 9, 1970 · Exported to South Africa · Air Capital International IncN8339Dehavilland DHC-6-300 · S/N 283Cancelled Aug 25, 1970 · Exported to Australia · Built 1970 · Air Capital International IncN9389QBeech 58 · S/N TH-51Cancelled Jul 15, 1970 · Exported to Australia · Air Capital International IncN4614ABeech 58 · S/N TH-55Cancelled Jul 7, 1970 · Exported to South Africa · Air Capital Intl IncN9388QBeech E-55 · S/N TE-820Cancelled Jul 2, 1970 · Exported to Australia · Air Capital International IncN4545ABeech A36 · S/N E-226Cancelled Jun 26, 1970 · Exported to South Africa · Air Capital International IncN9398QBeech 58 · S/N TH-59Cancelled Jun 26, 1970 · Exported to South Africa · Air Capital International IncN4630ABeech A36 · S/N E-219Cancelled Jun 23, 1970 · Exported to Australia · Air Capital Intl IncN9387QBeech A36 · S/N E-222Cancelled Jun 23, 1970 · Exported to Australia · Air Capital International IncN4674ABeech E-55 · S/N TE-816Cancelled Jun 19, 1970 · Air Capital International IncN4686ABeech 95-B55 · S/N TC-1345Cancelled Jun 19, 1970 · Exported to South Africa · Air Capital Intl IncN9391QBeech 95-B55 · S/N TC-1348Cancelled Jun 19, 1970 · Exported to South Africa · Air Capital International IncN8336Dehavilland DHC-6 · S/N 281Cancelled Jun 13, 1970 · Exported to Australia · Capital International IncN4071ABeech 70 · S/N LB-30Cancelled Jun 8, 1970 · Exported to Australia · Air Capital International IncN4677ABeech 58 · S/N TH-37Cancelled Jun 8, 1970 · Exported to Australia · Air Capital International IncN4621ABeech A36 · S/N E-218Cancelled Jun 5, 1970 · Exported to Australia · Air Capital International IncN4639ABeech 70 · S/N LB-32Cancelled Jun 4, 1970 · Exported to South Africa · Air Capital International IncN1989UCessna A185E · S/N 18501749Cancelled May 27, 1970 · Exported to Ecuador · Air Capital Intl IncN4248ABeech 58 · S/N TH-42Cancelled May 20, 1970 · Exported to South Africa · Air Capital International IncN4645ABeech E-55 · S/N TE-812Cancelled May 12, 1970 · Exported to Australia · Air Capital International IncN4649ABeech V35B · S/N D-9159Cancelled May 12, 1970 · Exported to South Africa · Air Capital International IncN4669ABeech A36 · S/N E-215Cancelled May 12, 1970 · Exported to Australia · Air Capital Intl IncN4596ABeech V35B · S/N D-9148Cancelled May 4, 1970 · Exported to South Africa · Air Capital International IncN1970JBeech F33A · S/N CE-290Cancelled May 1, 1970 · Exported to South Africa · Air Capital Intl IncN4612ABeech 95-B55 (T42A) · S/N TC-1338Cancelled May 1, 1970 · Exported to South Africa · Air Capital International IncN4541ABeech 58 · S/N TH-27Cancelled Apr 23, 1970 · Exported to Australia · Air Capital International IncN4374ABeech E-55 · S/N TE-804Cancelled Apr 21, 1970 · Exported to Australia · Air Capital International IncN4575QCessna 402A · S/N 402A 0075Cancelled Apr 21, 1970 · Exported to Australia · Air Capital International IncN4662ABeech V35B · S/N D9137Cancelled Apr 20, 1970 · Exported to South Africa · Air Capital International IncN4529QCessna 402A · S/N 402A0029Cancelled Apr 17, 1970 · Exported to Australia · Redwing Aviation Inc
Back to Augusta, KS