Cancelled registrations · 18

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 = 'GOLD BEACH' 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 = 'GOLD BEACH'
  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 = 'GOLD BEACH'
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.

N3762CCasper Robert H CUBY · S/N RC-1-0235Cancelled May 29, 2020 · Registration expired, pending cancellation · Built 1980 · Mcginnis Ryan F N175RSSmith Robert C CASSUTT SPORT RACER · S/N 11-111Cancelled May 15, 2015 · Registration expired, pending cancellation · Smith Robert C N8358HPiper J3C-65 · S/N 43-1376Cancelled Dec 22, 2014 · Registration expired, pending cancellation · Larsson Larry J N4533NNiles Daneil TIERRA II · S/N 3271Cancelled Dec 17, 2014 · Registration expired, pending cancellation · Niles Daniel J N6644UMooney M20C · S/N 139Cancelled Nov 12, 2014 · Registration expired, pending cancellation · Built 1963 · Bloomfield Michael I N342LBell 47D1 · S/N 611Cancelled Aug 14, 2013 · Registration pending, canceled · Built 1952 N772SXMadaris Michael G SONEX · S/N 772Cancelled Dec 19, 2007 · Exported to Norway · Madaris Michael G N24PCessna TU206F · S/N U20602157Cancelled Oct 10, 1997 · Exported to Mexico · Wassom Bruce C N2TEMorane-Saulnier MS760B · S/N 5Cancelled Mar 12, 1997 · Morris Robert E J N3178MPiper PA-12 · S/N 122020Cancelled Aug 19, 1992 · Triennial form not returned · Boice Alden N1390Wayne Dickerson B-8M · S/N WD-1Cancelled Sep 12, 1980 · Dickerson Wayne N8571TCessna 182C · S/N 52471Cancelled Jun 18, 1971 · Bettis O W N5860PPiper PA-24 · S/N 24-942Cancelled Feb 5, 1971 · Built 1959 · Degross Robert E N4548HPiper PA-15 · S/N 15-322Cancelled Nov 21, 1962 · Built 1948 · Whitman Leonard And Bennet E L N3436APiper PA-22 · S/N 22-1701Cancelled Jan 30, 1959 · Elmer R Costelloe N49016Aeronca L-3 · S/N 058B-10813Cancelled Oct 11, 1955 · John Kenneth Curry N84571Aeronca 7AC · S/N 7AC-3271Cancelled Nov 6, 1951 · Leith James C N3110EAeronca 7AC · S/N 6707Cancelled Jun 8, 1950 · Leith James C

Back to Gold Beach, OR