Cancelled registrations · 24

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 = 'OK' AND d.registrant_city = 'GUYMON' 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 = 'OK' AND d.registrant_city = 'GUYMON'
  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 = 'OK' AND d.registrant_city = 'GUYMON'
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.

N651DCBeryl G Rich RV-3B · S/N 11511Cancelled Feb 4, 2023 · Registration expired, pending cancellation · Built 2018 · Chain Dan N5615XAero Commander S2R · S/N 1815RCancelled Jan 23, 2018 · Registration expired, pending cancellation · Built 1973 · Valley Flying Service Inc N777WGGlasgow Michael L C-52 · S/N M1Cancelled Dec 12, 2015 · Built 1994 · Miller Royce D N85015Piper PA-25 · S/N 25-134Cancelled Jun 5, 2013 · Registration expired, pending cancellation · Valley Flying Service Inc N8653LPiper PA-25-235 · S/N 25-5096Cancelled May 15, 2013 · Registration expired, pending cancellation · Built 1969 · Valley Flying Service Inc N4748MPiper PA-11 · S/N 11356Cancelled Aug 6, 2012 · Revoked, canceled · Built 1947 · Hiller Gladys N1006TAir Tractor AT-501 · S/N 501-0030Cancelled Jul 25, 2002 · Second triennial mailing, no response · Built 1988 · Kokendoffer Earl J N4922RCessna A188B · S/N 18802439TCancelled Jul 25, 2002 · Second triennial mailing, no response · Built 1975 · Kokendoffer Earl N9485TCessna 210 · S/N 57285Cancelled Aug 22, 2001 · Triennial form not returned · Downing Lori L N315PFAir Tractor AT-400 · S/N 4000315Cancelled Feb 18, 1997 · Triennial form not returned · Kokendoffer Earl N3549WPiper PA-32-260 · S/N 32436Cancelled Jun 5, 1991 · Ramirez M Joseph N9301FHughes 269B · S/N 0003Cancelled Feb 13, 1984 · Administratively canceled · Harrington Vet Service Inc N9760EAeronca 11AC · S/N 11AC-1379Cancelled Dec 15, 1981 · Triennial form not returned · Miller Clyde N9649ZIntermountain CALLAIR A-9 · S/N 1039Cancelled Sep 5, 1975 · James Leo N6759JPiper PA-28-140 · S/N 28-24482Cancelled Jun 26, 1973 · Rigby Airmotive Inc N70874Piper J3C-65 · S/N 17897Cancelled Feb 4, 1971 · Harley Boyd N2181APiper PA-22 · S/N 22-599Cancelled Jun 29, 1970 · Wilmot Marshall N1664VCessna 120 · S/N 13836Cancelled Mar 29, 1956 · Pritchard Herschell C N24242Aeronca 65-C · S/N C7099Cancelled Mar 4, 1955 · Built 1939 · Wyatt Edward N52645Fairchild PT-19 · S/N T42-3130Cancelled Feb 1, 1952 · Thoreson Arthur N3639HEngineering & Research 415-C · S/N 4264Cancelled Oct 4, 1951 · Built 1946 · Thrall Albert D N3600HEngineering & Research 415-C · S/N 4225Cancelled May 3, 1951 · Built 1946 · Odom A M N1811Travel Air Mfg 2000 · S/N 237Cancelled Jul 12, 1948 · Built 1927 · Noonan John N114Curtiss Wright JN4C · S/N M-5198Cancelled May 2, 1930 · Wilmeth Cam S

Back to Guymon, OK