Cancelled registrations · 23

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 = 'WY' AND d.registrant_city = 'WORLAND' 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 = 'WY' AND d.registrant_city = 'WORLAND'
  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 = 'WY' AND d.registrant_city = 'WORLAND'
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.

N463WYBoeing CH-46E · S/N 156452Cancelled Sep 18, 2024 · Sky Aviation Corp N464WYBoeing CH-46E · S/N 157710Cancelled Sep 18, 2024 · Sky Aviation Corp N9385EAeronca 11AC · S/N 11AC-1022Cancelled Feb 5, 2022 · Registration expired, pending cancellation · Mcelhinny Clare D N131DVCessna P206 · S/N P2060131Cancelled Jul 31, 2021 · Registration expired, pending cancellation · Built 1965 · Clark Kerry V N3690MPiper PA-12 · S/N 12-2637Cancelled Nov 18, 2017 · Revoked, canceled · Built 1947 · Manning Frank N582MCCrabtree Merrit E EVANS VP-1 · S/N V-582MCCancelled Jun 30, 2017 · Registration expired, pending cancellation · Roessing Rusty M N48100Interstate S-1B1 · S/N 101Cancelled Apr 10, 2017 · Third renewal notice · Built 1943 · Sky Aviation Corporation N67095Hiller UH-12E · S/N 1085Cancelled Nov 7, 2014 · Registration expired, pending cancellation · Built 1959 · Cayuse Inc N40161Stinson 108 · S/N 108-91Cancelled Aug 14, 2013 · Registration expired, pending cancellation · Built 1946 · Woodward Thomas D N73WYArctic S-1B2 · S/N 1028Cancelled Dec 8, 2010 · First renewal notice · Ts Aviation Inc N1675QCessna 150L · S/N 15072975Cancelled Mar 1, 2007 · Exported to Philippines · Built 1971 · Stinson David J N15418Piper PA-28R-200 · S/N 28R-733507Cancelled May 19, 1975 · Sky Aviation Corp N4332NCessna 195 · S/N 7077Cancelled Oct 18, 1973 · Arbuckle Fred Alled N22097Cessna 150H · S/N 15068061Cancelled Feb 23, 1972 · Tolman Gerald C & Tolman C E N7662CDouglas B-26B · S/N 44-34724Cancelled Jul 1, 1970 · Kem Air Inc N9959CCallair A-5 · S/N 214Cancelled Jun 26, 1970 · Kem Air Inc N8929SCessna 150F · S/N 15062229Cancelled Jun 27, 1967 · Exported to Canada · Built 1965 · Frisbee Clyde E N2493APiper PA-18 · S/N 18-1960Cancelled Jul 31, 1959 · Farmers Aviation Co N73339Fairchild PT-26 M62A3 · S/N T42-4077Cancelled Feb 20, 1956 · Cook Ernest L N2937NCessna 140 · S/N 13198Cancelled Sep 22, 1950 · Worland Flying Service Inc N460WWatkins SL II · S/N 106Cancelled Jan 1, 1940 · Built 1930 · Beadle Henry E N191VCessna CG-2 · S/N 63Cancelled Mar 8, 1933 · Goodmont Motor Co N635KCessna DC-6A · S/N 207Cancelled Dec 4, 1930 · Goodmont Motor Co Inc

Back to Worland, WY