OpenAirDocs.org
University Of Colorado

Earlier aircraft under this name · 17

Cancelled registrations that named this owner when they ended, newest first.

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_name = 'UNIVERSITY OF COLORADO' OR list_contains(d.other_registrant_names, 'UNIVERSITY OF COLORADO')
  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.

N125CUUniversity Of Colorado DATAHAWK 2 · S/N CU-DH2-03Cancelled Oct 30, 2021 · Registration expired, pending cancellation · Boulder, CON74CUUniversity Of Colorado DATAHAWK 2 · S/N CU-DH2-04Cancelled Oct 2, 2021 · Registration expired, pending cancellation · Boulder, CON75CUUniversity Of Colorado DATAHAWK 2 · S/N CU-DH2-05Cancelled Oct 2, 2021 · Registration expired, pending cancellation · Boulder, CON77CUUniversity Of Colorado DATAHAWK 2 · S/N CU-DH2-07Cancelled Oct 2, 2021 · Registration expired, pending cancellation · Boulder, CON78CUUniversity Of Colorado DATAHAWK 2 · S/N CU-DH2-08Cancelled Oct 2, 2021 · Registration expired, pending cancellation · Boulder, CON79CUUniversity Of Colorado DATAHAWK 2 · S/N CU-DH2-09Cancelled Oct 2, 2021 · Registration expired, pending cancellation · Boulder, CON113CUUniversity Of Colorado BERGEN OBSERVER · S/N CU/113Cancelled Feb 7, 2019 · Registration expired, pending cancellation · Boulder, CON126CUUniversity Of Colorado FX79 BUFFALO · S/N CU/126Cancelled Jan 15, 2019 · Registration expired, pending cancellation · Boulder, CON670CUUniversity Of Colorado FX79 BUFFALO · S/N CU/670Cancelled Jul 12, 2018 · Registration expired, pending cancellation · Boulder, CON671CUUniversity Of Colorado TECHPOD UAS · S/N CU/671Cancelled Jul 12, 2018 · Registration expired, pending cancellation · Boulder, CON672CUUniversity Of Colorado TEMPEST UAS · S/N CU/672Cancelled Jul 12, 2018 · Registration expired, pending cancellation · Boulder, CON673CUUniversity Of Colorado TEMPEST UAS · S/N CU/673Cancelled Jul 12, 2018 · Registration expired, pending cancellation · Boulder, CON674CUUniversity Of Colorado SKYWALKER X-8 · S/N CU/674Cancelled Jul 12, 2018 · Registration expired, pending cancellation · Boulder, CON675CUUniversity Of Colorado P-1A UAS · S/N CU/675Cancelled Jul 12, 2018 · Registration expired, pending cancellation · Boulder, CON667CUUniversity Of Colorado SKYWALKER X-8 · S/N CU/001Cancelled Jun 8, 2018 · Registration expired, pending cancellation · Boulder, CON668CUUniversity Of Colorado SKYWALKER X-8 · S/N CU/002Cancelled Jun 8, 2018 · Registration expired, pending cancellation · Boulder, CON669CUUniversity Of Colorado SKYWALKER X-8 · S/N CU/003Cancelled Jun 8, 2018 · Registration expired, pending cancellation · Boulder, CO
Back to University Of Colorado