Cancelled registrations · 21

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 = 'MA' AND d.registrant_city = 'ORANGE' 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 = 'MA' AND d.registrant_city = 'ORANGE'
  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 = 'MA' AND d.registrant_city = 'ORANGE'
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.

N1112WWolfe EAA BIPLANE P1 · S/N 002Cancelled Jul 30, 2022 · Registration expired, pending cancellation · Built 1976 · Blackbird Cain J N524TRMaule MX-7-180A · S/N 20022CCancelled Dec 16, 2019 · Sale reported, canceled N699AASimsbury High School STARDUSTER II SA 300 · S/N 2144Cancelled Jun 26, 2018 · Registration pending, canceled · Built 1996 N707YStockwell CHUM · S/N 1Cancelled Jul 9, 2013 · Registration expired, pending cancellation · Built 1980 · Stockwell Erwin E N1995LLeonard Raymond RL-1 · S/N 1676Cancelled Jun 11, 2013 · Exported to Canada · Built 1995 · Blackbird Cain J N4370Wright VP-1 VOLKSPLANE · S/N HW70Cancelled Nov 21, 2012 · Registration expired, pending cancellation · Built 1970 · Gordon Milton D N3486APiper PA-22-135 · S/N 22-1756Cancelled Sep 12, 2012 · Sale reported, canceled · Built 1953 N6DAPiper PA-23-250 · S/N 27-3273Cancelled Mar 29, 2011 · Expired dealer · City Engines Inc N69795Noorduyn UC-64A · S/N 667Cancelled Oct 19, 1981 · Parachutes Inc N64629Volksplane VP-1 · S/N 1Cancelled Sep 22, 1980 · Gordon Milton D N1207Noorduyn UC-64 · S/N 841Cancelled Dec 8, 1971 · Parachutes Inc N9044CCessna 180 · S/N 31092Cancelled Jan 4, 1971 · Parachutes Incorporated N2168BLuscombe T-8F · S/N 6595Cancelled Jun 17, 1966 · Built 1949 · Sanborn Lewis B N736Noorduyn UC-64AS · S/N 670Cancelled Jul 18, 1961 · Exported to Chile · Parachutes Inc N26532Taylorcraft BL-65 · S/N 1873Cancelled Feb 21, 1956 · Pioneer Valley Aviation N913CStinson 108-3 · S/N 108-3913Cancelled May 21, 1953 · Exported to Canada · Dexter Frederick A N3325NPiper J3C-65 · S/N 22526Cancelled Apr 18, 1950 · Built 1946 · Pioneer Valley Aviation Co N4764MPiper PA-11 · S/N 11-276Cancelled Jan 18, 1950 · Pioneer Valley Aviation Co N75721Cessna T-50 · S/N 2937Cancelled May 13, 1949 · Mealand Fred A N21070Aeronca 50-C · S/N C-1018Cancelled Aug 25, 1948 · Built 1938 · Newcomb Stanley Stowell N20834Piper J-3 · S/N 2134Cancelled Aug 24, 1948 · Built 1938 · Athol-Orange Aero Club Inc

Back to Orange, MA