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 = 'CO' AND d.registrant_city = 'LA JUNTA' 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 = 'CO' AND d.registrant_city = 'LA JUNTA'
  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 = 'CO' AND d.registrant_city = 'LA JUNTA'
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.

N2175DBeech D35 · S/N D-3522Cancelled Sep 20, 2013 · Registration expired, pending cancellation · Built 1953 · Roeske Leo W N99737Ercoupe 415-C · S/N 2360Cancelled Jul 8, 2013 · Registration expired, pending cancellation · Built 1946 · Roeske Scott A N59137Boeing A75N1(PT17) · S/N 75-3827Cancelled Apr 24, 2013 · Registration expired, pending cancellation · Built 1942 · Robinson Dennis R N5225Jaynes B-8-M · S/N 522Cancelled Apr 2, 2013 · Registration expired, pending cancellation · Built 1969 · Andrews Lester E N4697Andrews AUTOGYRO · S/N 24Cancelled Dec 11, 2012 · Registration expired, pending cancellation · Built 1970 · Andrews Lester E N7308EAir Tractor AT-301 · S/N 301-0625Cancelled Apr 6, 2005 · Registration pending · Built 1985 N6904XCessna 172B · S/N 17247804Cancelled Aug 5, 1991 · Sweet Anthony E N759GKCessna 182Q · S/N 18265981Cancelled Mar 2, 1982 · Western Food Products Co Inc N30385Cessna 177A · S/N 17701225Cancelled Feb 25, 1982 · Hutchins Don T Et Al N8465RPiper PA-28-140 · S/N 28-22369Cancelled May 28, 1975 · Exported to Canada · Built 1966 · Variety Aircraft Inc N2456JCessna 150G · S/N 15065556Cancelled Jul 31, 1972 · Exported to Canada · Lyddon K William N3766NBeech 35 · S/N D-987Cancelled Nov 15, 1955 · Built 1947 · Varah Ken N73450Consolidated Vultee BT-13A · S/N 10792Cancelled Jul 26, 1955 · Earl Showalter Jr N3578KPiper J3C-65 · S/N 22264Cancelled Jun 17, 1949 · Carter Elvis Cressy N16429Monocoupe 90A · S/N A-756Cancelled Feb 7, 1949 · Built 1937 · Clifton Fred T N37244Interstate S-1A · S/N 87Cancelled Dec 28, 1942 · The Cadet Flying Club N37207Interstate S-1A · S/N 51Cancelled Mar 31, 1942 · Hawkins Joe A N1708Alexander COMBINATION EAGLEROC · S/N 185Cancelled Apr 1, 1938 · Shasteen Murl H

Back to La Junta, CO