Skip to content

Cancelled registrations · 23

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 = 'OR' AND d.registrant_city = 'BRIGHTWOOD' 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 = 'OR' AND d.registrant_city = 'BRIGHTWOOD'
  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 = 'OR' AND d.registrant_city = 'BRIGHTWOOD'
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.

N9696DKeller Doug HUSKY CUB · S/N 001Cancelled Dec 5, 2020 · Registration expired, pending cancellation · Built 2006 · Reese Travis N5315GDehavilland BEAVER DHC-2 MK.1 · S/N 980Cancelled Sep 14, 2017 · Exported to Russia · Built 1955 · Jettview Corp N178RPiper PA-23-250 · S/N 27-7954115Cancelled May 22, 2015 · Exported to Russia · Built 1979 · Jettview Corp N25SXRobertson T E/Heisdorffer R SH-IIS · S/N 2072Cancelled May 14, 2015 · Exported to Russia · Built 1995 · Jettview Corp N58510Cessna 182P · S/N 18262112Cancelled Mar 12, 2015 · Built 1973 · Jettview Corporation N288CSSands Christopher W RV-8 · S/N 81616Cancelled Jul 17, 2014 · Exported to Russia · Built 2003 · Jettview Corp N69CFCessna 182P · S/N 18264229Cancelled Jul 17, 2014 · Exported to Russia · Built 1975 · Jettview Corp N704JYCessna 150M · S/N 15078659Cancelled May 31, 2013 · Exported to Russia · Built 1976 · Jettview Corp N9344GCessna 182P · S/N 18260884Cancelled May 31, 2013 · Exported to Russia · Built 1971 N38ECessna 337G · S/N 33701798Cancelled Apr 19, 2013 · Exported to Russia · Built 1977 · Jettview Corp N1047TMaule MX-7-180C · S/N 28006CCancelled Mar 18, 2013 · Exported to Russia N4958GCessna 172N · S/N 17273505Cancelled Mar 18, 2013 · Exported to Russia · Built 1979 · Jettview Corp N4276CMaule M-7-235B · S/N 23079CCancelled Sep 12, 2011 · Exported to Russia · Built 2001 · Jetview Corp N704BACessna 150M · S/N 15078472Cancelled Jun 27, 2011 · Exported to Russia · Built 1976 N5512NMaule M-7-235C · S/N 25090CCancelled Sep 30, 2010 · Exported to Russia N11848Cessna 150L · S/N 15075674Cancelled May 13, 2010 · Exported to Russia · Built 1974 · Jettview Corp N3608VCessna 150M · S/N 15076561Cancelled Jun 17, 2008 · Exported to Russia · Built 1975 N182LCCessna 182Q · S/N 18267112Cancelled Jun 10, 2008 · Exported to Russia · Built 1979 · Jettview Corp N95983Cessna 182Q · S/N 18266698Cancelled Apr 25, 2008 · Exported to Russia · Built 1978 · Jettview Corp N7069CPiper PA-28R-200 · S/N 28R-7635093Cancelled Mar 3, 2008 · Exported to Russia · Built 1975 · Jettview Corp N9839CCessna R182 · S/N R18200459Cancelled Mar 3, 2008 · Exported to Russia · Built 1978 · Jettview Corp N4820Bell 47G-3B-2 · S/N 6757Cancelled May 14, 1975 · Exported to Venezuela · Calkins Dick N3331Boon Special GYROCOPTER · S/N X333Cancelled Jun 25, 1970 · Smith Daniel W

Back to Brightwood, OR