Skip to content

Cancelled registrations · 27

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 = 'TX' AND d.registrant_city = 'KELLER' 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 = 'TX' AND d.registrant_city = 'KELLER'
  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 = 'TX' AND d.registrant_city = 'KELLER'
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.

N7872XCessna 172B · S/N 17248372Cancelled Feb 5, 2022 · Registration expired, pending cancellation · Built 1961 · Pate Joshua S N5484ACessna 310B · S/N 35684Cancelled Sep 4, 2021 · Registration expired, pending cancellation · Built 1958 · Parker Robert M N76WSSutton William J STITS PLAYMATE SA11A · S/N 75Cancelled Mar 6, 2018 · Registration expired, pending cancellation · Built 1975 · Fallis Robert P N63KMMcdavid Monte R VANS RV-6 · S/N 60104Cancelled Feb 20, 2018 · Registration expired, pending cancellation · Mcdavid Monte R N8758ABeech A35 · S/N D-2180Cancelled Feb 7, 2018 · Registration expired, pending cancellation · Built 1949 · Conner Bruce H N5830NCessna 305A · S/N 22709Cancelled Jan 25, 2018 · Registration expired, pending cancellation · Donelan R N6678BCessna 310C · S/N 35778Cancelled Jan 25, 2018 · Registration expired, pending cancellation · Built 1959 · Murray Arnold B N6896TCessna 310D · S/N 39196Cancelled Jan 8, 2018 · Registration expired, pending cancellation · Built 1960 · Sheehan John N124CDCirrus Design SR20 · S/N 1011Cancelled Feb 24, 2015 · Exported to Germany · Built 1999 · Cavok Inc N2141ZPiper PA-28-201T · S/N 28-7921017Cancelled Sep 16, 2014 · Registration expired, pending cancellation · Built 1979 · Westfall Kathleen B N104RRobertson SPECIAL · S/N 1Cancelled Sep 8, 2014 · Registration expired, pending cancellation · Built 1963 · Robertson V K N7334JPiper PA-28-140 · S/N 28-24689Cancelled Aug 20, 2013 · Sale reported, canceled · Built 1968 N4743VBellanca 17-30 · S/N 30072Cancelled Aug 15, 2013 · Registration expired, pending cancellation · Built 1967 · Enckhausen William E Jr N7413ACessna 172 · S/N 29513Cancelled Aug 8, 2013 · Sale reported, canceled · Built 1956 N7262TCessna 172A · S/N 46862Cancelled Aug 6, 2013 · Sale reported, canceled · Built 1959 N48569Boeing D75N1 · S/N 75-3786Cancelled Jul 30, 2013 · Sale reported, canceled · Built 1942 N5790HPiper PA-16 · S/N 16-406Cancelled Jul 19, 2013 · Registration expired, pending cancellation · Built 1949 · Freeman Gary D N3446BBeech D35 · S/N D-3684Cancelled Mar 7, 2013 · Registration expired, pending cancellation · Built 1953 · Buckingham Robert E III N74464Bellanca 14-13-2 · S/N 1577Cancelled Jul 9, 2012 · Registration pending, canceled · Built 1948 N11BMMckinley TURNER T-40 · S/N 101Cancelled May 24, 2012 · Registration expired, pending cancellation · Built 1971 · Travis Vince K N601JVVaghy Jonathan VAGHY BENSEN B8M · S/N JV-2Cancelled Sep 16, 2008 · Triennial form not returned · Built 1999 · Vaghy Jonathan N8649UCessna 172F · S/N 17252551Cancelled Aug 23, 2006 · Triennial form not returned · Built 1965 · Spannagel Dale R N5730BCessna 182 · S/N 33730Cancelled May 14, 1999 · Triennial form not returned · Williams Benny J N93534Bellanca 17-30A · S/N 74-30674Cancelled Oct 14, 1982 · Administratively canceled · Steward Stevenson Sales N84651Cessna 172K · S/N 17258562Cancelled Apr 19, 1976 · Exported to Canada · Built 1969 · Robertson Phillip D N27971Piper J5A · S/N 5-67Cancelled Apr 19, 1974 · Morris Donald Gene N30760Piper J3C-65 · S/N 5093Cancellation date not recorded · Built 1940

Back to Keller, TX