Cancelled registrations · 16

Query with SQL

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 = 'CO' AND d.registrant_city = 'RANGELY' ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

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 = 'CO' AND d.registrant_city = 'RANGELY'
  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.

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 = 'CO' AND d.registrant_city = 'RANGELY'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N3174ACessna 170B · S/N 25818Cancelled Dec 19, 2023 · Built 1954 · Colorado Northwestern Community College N7129MCessna 175 · S/N 55429Cancelled May 11, 2015 · Sale reported, canceled · Built 1958 N6946TCessna 310D · S/N 39246Cancelled Aug 23, 2013 · Sale reported, canceled · Built 1960 N5578ZHiller OH-23C · S/N 64-15144Cancelled Apr 22, 2013 · Registration expired, pending cancellation · Roper Loyd B N1044AUniversal TAYLORCRAFT BC12-D · S/N 10554Cancelled Apr 10, 2013 · Registration expired, pending cancellation · Built 1950 · Denton Ernest R N3966TPiper PA-28R-180 · S/N 28R-30312Cancelled Jul 26, 2011 · Revoked, canceled · Built 1967 · Rangely Flying Service Inc N2657LBeech U-8D · S/N 581342Cancelled Sep 27, 1995 · Administratively canceled · Colorado Northwestern Community Clg N65316Cessna O-2A · S/N 697657Cancelled Sep 27, 1995 · Triennial form not returned · Colorado Northwestern Community Coll N65618North American T-39A · S/N 624489Cancelled Sep 27, 1995 · Triennial form not returned · Colorado Northwestern Comm College N9316TPiper PA-38-112 · S/N 3878A0026Cancelled Sep 27, 1995 · Triennial form not returned · Colorado Northwstrn Community Colge N758JMCessna R172K · S/N R1723133Cancelled Jan 28, 1985 · Rangely Jr College District N114CWBeech 65-A90 · S/N LJ-114Cancelled Jul 24, 1984 · Administratively canceled · Crc Colorado Well Service Inc N59174Consolidated Vultee BT-13 · S/N 5492Cancelled Dec 5, 1977 · Pratt William J N59192Consolidated Vultee BT-13 · S/N 7351Cancelled Dec 5, 1977 · Pratt William J N6807ECessna 175A · S/N 56307Cancelled Jul 8, 1971 · Thomas George Warren N81906Aeronca 7AC · S/N 7AC-529Cancelled Feb 18, 1964 · Thomas Leon

Back to Rangely, CO