Skip to content

Cancelled registrations · 52

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 = 'SEMINOLE' 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 = 'SEMINOLE'
  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 = 'SEMINOLE'
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.

N8386RPiper PA-28-140 · S/N 28-22340Cancelled Oct 17, 2026 · Sale reported, canceled · Built 1966 N3836YCessna 210D · S/N 21058336Cancelled Jan 31, 2026 · Registration pending, canceled N8058SHughes TH-55 · S/N 860641Cancelled Dec 15, 2025 · Sale reported, canceled N64JNTextron B200GT · S/N BY-462Cancelled Aug 9, 2024 · Exported to Germany · Built 2023 · South Plains Flying Inc N66SXGainfort Gordon D S6ES · S/N 1292399Cancelled Jun 8, 2024 · Sale reported, canceled N565PKEvolution REVOLT · S/N 001018Cancelled Mar 4, 2023 · Registration expired, pending cancellation · Built 2019 · Klassen Peter N8591WPiper PA-28-235 · S/N 28-10103Cancelled Feb 4, 2023 · Registration expired, pending cancellation · Neufeld Henry W N5986ACessna 172 · S/N 28586Cancelled May 9, 2022 · Registration expired, pending cancellation · Built 1956 · Aero Clinic Inc N8784WPiper PA-28-235 · S/N 28-10330Cancelled Dec 5, 2020 · Registration expired, pending cancellation · Built 1964 · Shaw Franklin S N14LXHinds Lex STEEN SKYBOLT · S/N LH001Cancelled Oct 3, 2020 · Registration expired, pending cancellation · Hinds Lex A N180BJJackson MA 5 CHARGER · S/N 69-2Cancelled Aug 2, 2020 · Registration expired, pending cancellation · Built 1987 · Calgonaire LLC N472YGrumman G-164 · S/N 117Cancelled Jan 6, 2020 · Registration expired, pending cancellation · Built 1962 · Letkeman John K N9673SChampion 7ECA · S/N 398Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 1966 · Letkeman John K N2583VCessna R172K · S/N R1722224Cancelled Sep 3, 2019 · Built 1976 · Banman Henry K N6115RCessna T210F · S/N T210-0015Cancelled Aug 28, 2019 · Exported to Mexico · Built 1965 · Portillo Jesus Manuel Jr N8131CPiper PA-22-135 · S/N 22-2277Cancelled Apr 17, 2019 · Revoked, canceled · Built 1954 · Seminole Flying Club Inc N26980Aeronca 7AC · S/N 7AC-2231Cancelled Mar 1, 2018 · Registration expired, pending cancellation · Letkeman John K N3538APiper PA-22 · S/N 22-1812Cancelled Jan 18, 2018 · Registration expired, pending cancellation · Built 1953 · Johnson Dale M N4034QPhantom Aeronautics X-1 · S/N 240Cancelled Jun 20, 2017 · Registration expired, pending cancellation · Built 2007 · Wieler David K N90262Robinson Helicopter R22 · S/N 0044Cancelled Jun 19, 2017 · Registration expired, pending cancellation · Hilco Aviation N81699WSK PZL Mielec M-18A · S/N 1Z020-11Cancelled May 31, 2017 · Registration expired, pending cancellation · Davis James R N1460KLuscombe 8A · S/N 4187Cancelled Apr 7, 2017 · Registration expired, pending cancellation · Built 1946 · Lee Forest Jr N731BVCessna A188B · S/N 18802776TCancelled Feb 28, 2017 · Registration expired, pending cancellation · Built 1976 · Davis James R N452TCWSK PZL Mielec M-18A · S/N 1Z020-23Cancelled Feb 16, 2017 · Registration expired, pending cancellation · Built 1989 · Davis James R N5259ZPiper PA-22-108 · S/N 22-8944Cancelled Oct 27, 2014 · Registration expired, pending cancellation · Built 1961 · Johnson Pat N307CMCoggins Bob J TITAN TORNADO II · S/N D94503SAZK0087Cancelled Jun 6, 2013 · Registration expired, pending cancellation · Built 2007 · Loeppky Neal K N9075YRobinson Helicopter R22 · S/N 0252Cancelled Mar 18, 2013 · Sale reported, canceled · Built 1982 N1749PPiper PA-22-150 · S/N 22-2540Cancelled Aug 10, 2012 · Registration expired, pending cancellation · Built 1954 · Martin Instrumentation & Const Corp N1549GAir Tractor AT-502 · S/N 502-0184Cancelled Aug 30, 2005 · Exported to Brazil · Built 1992 · Addison Flying Service Inc N402ZAir Tractor AT-402 · S/N 402-0788Cancelled May 27, 2005 · Exported to Australia · Built 1990 · Kubecka Donald N47889Piper J3C-65 · S/N 10721Cancelled Oct 7, 2004 · Exported to South Africa · Built 1943 · Kubecka Donald N6090YCorcoran Leo J TAYLOR MONOPLANE · S/N 98Cancelled May 17, 2004 · Built 1999 · Letkeman John K N4629JCessna T188C · S/N T18803757TCancelled Apr 9, 2004 · Exported to Brazil · Built 1980 · Addison John Wesley N84410Cessna A188B · S/N 18801983TCancelled Sep 29, 2003 · Exported to South Africa · Built 1974 · Kubecka Donald N4803RCessna A188B · S/N 18802324TCancelled Oct 28, 2002 · Exported to South Africa · Built 1975 · Kubecka Donald P N4502RAir Tractor AT-502 · S/N 502-0087Cancelled Mar 13, 2002 · Exported to Brazil · Addison Flying Services Inc N9940JCessna T188C · S/N T18803875TCancelled Mar 13, 2002 · Exported to Brazil · Built 1981 · Addison Ag Operating & Leasing Inc N72062Cessna A188B · S/N 18801942TCancelled Jun 26, 2000 · Triennial form not returned · Addison John Wesley N731JYCessna A188B · S/N 18802941TCancelled Jun 26, 2000 · Triennial form not returned · Addison John Wesley N8857QAero Commander S2R · S/N 1657RCancelled Mar 26, 1982 · Seminole Spraying Service N4802ACessna A152 · S/N A1520895Cancelled Aug 13, 1981 · Exported to Mexico · Hilco Aviation Inc N4522NBoeing B75N1 · S/N 75-6701Cancelled Jan 18, 1972 · Jack F Hamilton N9913DPiper PA-18A 150 · S/N 18-6954Cancelled May 20, 1965 · Seminole Aero Service N8690DPiper PA-18A 150 · S/N 18-6296Cancelled Dec 14, 1961 · Freeman Willard L N3988PPiper PA-18A 150 · S/N 18-4748Cancelled Jun 23, 1958 · Exported to Sweden · Built 1956 · Olmstead Virgil N8175CPiper PA-18A · S/N 18-3631Cancelled May 21, 1956 · Exported to Mexico · Olmstead Virgil L N5475HPiper PA-18 · S/N 1868Cancelled Apr 26, 1956 · Exported to Mexico · Olmstead V L N77571Piper J3C-65 · S/N 22062Cancelled Aug 3, 1955 · Built 1946 · Yoas E Jaxon N2483APiper PA-18-135 · S/N 18-1951Cancelled Feb 10, 1953 · Exported to Canada · Olmstead Virgil N85847Aeronca 11AC · S/N 11AC-273Cancelled Oct 28, 1952 · Ogle Jim W

Back to Seminole, TX