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 = 'IA' AND d.registrant_city = 'RED OAK' 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 = 'IA' AND d.registrant_city = 'RED OAK'
  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 = 'IA' AND d.registrant_city = 'RED OAK'
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.

N89LARobinson Helicopter R44 II · S/N 10984Cancelled Nov 25, 2020 · Built 2005 · Mills County Choppers Inc N40917Piper J3C-65 · S/N 7602Cancelled May 4, 2019 · Revoked, canceled · Built 1941 · Nease Harold A N699TQRobinson Helicopter R44 II · S/N 10385Cancelled Mar 2, 2018 · Registration expired, pending cancellation · Built 2004 · Mills County Choppers Inc N35131Piper J3C-65 · S/N 6143Cancelled Jan 18, 2018 · Registration expired, pending cancellation · Nicks Inc N6256DAero Commander 680 · S/N 680-524-194Cancelled Sep 12, 2013 · Registration expired, pending cancellation · Built 1957 · Valley Aircraft Parts Inc N1163KLuscombe 8A · S/N 3890Cancelled Aug 13, 2012 · Registration expired, pending cancellation · Built 1946 · Safety Fliers Inc N160CStinson 108-2 · S/N 108-3160Cancelled Aug 9, 2012 · Registration expired, pending cancellation · Built 1947 · Classic Aero Inc N6802WPiper PA-28-140 · S/N 28-20936Cancelled May 14, 2003 · Triennial form not returned · Built 1965 · Wagner Aero Service Inc N88260Piper J3C-65 · S/N 15876Cancelled Jun 7, 1971 · Donald L Chase / Richard O Willett N4675TGamble 6-64 GYROCOPTER · S/N GG1Cancelled Sep 3, 1970 · G R Gamble N9256EAeronca 11AC · S/N 11AC-890Cancelled May 26, 1965 · Built 1946 · Boyington Ives G N70936Piper J3C-65 · S/N 17960Cancelled May 22, 1965 · Carder John B N55896Cessna T-50 · S/N 2812Cancelled May 20, 1965 · Built 1943 · Belt R K N64510Cessna T-50 · S/N 5631Cancelled Feb 17, 1956 · Laire Jerald D N54724Fairchild M-62A · S/N T41-443Cancelled Oct 11, 1955 · Wyant Charles O N96707Taylorcraft BC12-D · S/N 9007Cancelled Apr 27, 1951 · Racine C E N31632Howard DGA-18 · S/N 632Cancelled Apr 17, 1951 · Racine C E DBA N54787Convair BT-13B · S/N 1425Cancelled Mar 4, 1949 · Mcquown Earl Jr

Back to Red Oak, IA