Cancelled registrations · 19

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 = 'IL' AND d.registrant_city = 'PARK RIDGE' 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 = 'IL' AND d.registrant_city = 'PARK RIDGE'
  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 = 'IL' AND d.registrant_city = 'PARK RIDGE'
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.

N442GFLindstrand Balloons 90A · S/N 143Cancelled Jul 7, 2017 · Registration expired, pending cancellation · Built 1994 · Hot Air Ascensions Inc N6197YStengel Robin H RH-1 FALCON · S/N RH-001ACancelled May 11, 2015 · Registration expired, pending cancellation · Stengel Robin H N6127YCameron Balloons US N-105 · S/N 5534Cancelled Oct 14, 2014 · Registration expired, pending cancellation · Built 1989 · Hot Air Ascension Inc N1323SCessna 182P · S/N 18264887Cancelled Sep 3, 2014 · Registration expired, pending cancellation · Built 1976 · American Mid States Inc N4025GRaven Industries RALLY RX7 · S/N RX7-270Cancelled Nov 7, 2013 · Registration expired, pending cancellation · Built 1981 · Anderson Neil J N4624NCessna 402B · S/N 402B1376Cancelled Jul 19, 2013 · Registration expired, pending cancellation · Built 1978 · Bevans Jim M III N1107RRaven S55A · S/N S55A299Cancelled Mar 31, 1998 · Triennial form not returned · Keefe Matthew J N60604Beech A36 · S/N E-1538Cancelled Jul 20, 1983 · Holz William H N6061UBeech 58 · S/N TH-1046Cancelled Mar 14, 1980 · Exported to United Kingdom · Holz William H N4857MBeech 58 · S/N TH-987Cancelled May 7, 1979 · Exported to Kenya · Built 1978 · Holz William H N1409CPiper PA-22-135 · S/N 22-1164Cancelled May 13, 1976 · Peacock Robert A N97579Stinson 108-1 · S/N 108-579Cancelled Apr 3, 1964 · Snodgress Harry A III N50138Cessna T-50 · S/N 5824Cancelled May 23, 1955 · Built 1945 · Skymotive Sales Inc N9849HFairchild M-62A-3 · S/N FT-763Cancelled Apr 11, 1950 · Built 1943 · Ross John A N905VSavoia Marchetti S-56 · S/N 35Cancelled Oct 14, 1948 · Dowell Maynard N13468Stinson JR. SR · S/N 8722Cancelled Jul 20, 1948 · Dowell Maynard N26601Taylorcraft BL · S/N 1943Cancelled Jul 15, 1948 · Built 1940 · Dowell Maynard DBA N29386Culver LCA · S/N 175Cancelled Jul 19, 1943 · Roen Louis B N61516Cessna T-50 · S/N 4622Cancellation date not recorded · Lloyd Richard E

Back to Park Ridge, IL