Cancelled registrations · 28

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 = 'KS' AND d.registrant_city = 'MCPHERSON' 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 = 'KS' AND d.registrant_city = 'MCPHERSON'
  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 = 'KS' AND d.registrant_city = 'MCPHERSON'
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.

N105FSMalm Russell KOLB FIRESTAR II · S/N F.S.-0-669Cancelled Feb 24, 2024 · Sale reported, canceled · Built 1997 N216HZGulfstream Aerospace G-IV · S/N 1147Cancelled Feb 3, 2024 · Built 1990 · Central Christian College Holdings LLC N666BCColle Britt HUMMEL BIRD · S/N BCEARC1Cancelled Jan 25, 2018 · Registration expired, pending cancellation · Colle Britt N714GCCessna 150M · S/N 15079156Cancelled May 17, 2017 · Third renewal notice · Built 1976 · Mcdaniel Stephen N61240Boeing B75N1 · S/N 757994Cancelled Feb 4, 2017 · Revoked, canceled · Built 1943 · Mcpherson Spraying Svc Inc N8285NPiper PA-28-140 · S/N 28-25502Cancelled May 14, 2013 · Registration expired, pending cancellation · Built 1969 · Ward Robert N757PFCessna 152 · S/N 15279890Cancelled May 8, 2013 · Registration expired, pending cancellation · Built 1977 · Fisher Dennis E N493Satterlee VOLKSPLANE VP-1 · S/N KS2Cancelled May 19, 2007 · Triennial form not returned · Built 1973 · Smith David W N7960FCessna 150F · S/N 15064060Cancelled Apr 26, 2002 · Triennial form not returned · Built 1966 · Macair Corp N11319Cessna 150L · S/N 15075325Cancelled Aug 12, 1982 · Administratively canceled · Fisher Aviation Inc N65335Boeing A75N1 · S/N 75-3286Cancelled Nov 5, 1979 · Exported to Canada · Rogers Flying Service Inc N5463FAlon A-2A · S/N B-263Cancelled Oct 3, 1967 · Exported to Canada · Alon Aircraft Inc N5645FAlon A2 · S/N A-245Cancelled May 18, 1967 · Exported to Canada · Alon Inc N5633FAlon A2 · S/N A-233Cancelled May 10, 1967 · Exported to Canada · Alon Inc N5639FAlon A2 · S/N A-239Cancelled Apr 18, 1967 · Exported to Canada · Alon Inc N5628FAlon A2 · S/N A-228Cancelled Mar 2, 1967 · Exported to Canada · Alon Inc N5630FAlon A2 · S/N A-230Cancelled Feb 24, 1967 · Exported to Canada · Alon Inc N5605FAlon A2 · S/N A-205Cancelled Feb 8, 1967 · Exported to Venezuela · Alon Inc N6352VAlon A2 · S/N A-28Cancelled Jul 8, 1965 · Exported to South Africa · Alon Inc N85485Aeronca 7AC · S/N 7AC-4225Cancelled Mar 1, 1965 · Mcpherson Spraying Service Inc N3434CCessna 170B · S/N 26477Cancelled Jan 24, 1956 · Mcpherson Eagles Flying Club Inc N94713Ercoupe 415-CD · S/N 4824Cancelled Oct 14, 1955 · Built 1947 · Johnson Carl Et Al N53350Consolidated Vultee BT-13A · S/N 11574Cancelled Feb 7, 1952 · Built 1943 · Carlson And Rankin Imp Co N88623Piper J3C-65 · S/N 16251Cancelled Feb 1, 1952 · Hoover Harold N53763Taylorcraft DCO-65 · S/N L-5250Cancelled May 31, 1950 · Built 1943 · Mcallaster Ansel N92959Commonwealth 185 · S/N 1692Cancelled Apr 29, 1949 · Mcpherson Eagles Flying Club Inc N54642Fairchild M-62A · S/N T42-1589Cancelled Dec 29, 1948 · Janssen Skytel & Flying Service N54610Fairchild M-62A · S/N T42-1693Cancelled Sep 11, 1947 · Glazier Roy W

Back to Mcpherson, KS