Skip to content

Cancelled registrations · 26

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 = 'TN' AND d.registrant_city = 'ATHENS' 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 = 'TN' AND d.registrant_city = 'ATHENS'
  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 = 'TN' AND d.registrant_city = 'ATHENS'
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.

N162RWProctor E Ray EXEC 162F · S/N 6988Cancelled Dec 14, 2025 · Built 2010 · Anderson Dal S N300SStevens James K STARDUSTER TOO SA300 · S/N 932Cancelled Feb 7, 2019 · Registration expired, pending cancellation · Montgomery Andreas M N78172Globe GC-1B · S/N 2172Cancelled May 31, 2018 · Sale reported, canceled · Built 1946 N4288SQuad City CHALLENGER II · S/N GC6151954Cancelled Mar 13, 2018 · Registration expired, pending cancellation · Built 1996 · Church Gary W N19ZXBuckeye DREAM MACHINE · S/N 16402Cancelled Feb 27, 2018 · Registration expired, pending cancellation · Built 2004 · Womack Jimmy D N5626RKolb SLINGSHOT · S/N 111-11Cancelled Feb 15, 2018 · Sale reported, canceled · Built 1999 N2499DPhantom-Vr PHANTOM 1 · S/N 369Cancelled Feb 7, 2018 · Registration expired, pending cancellation · Built 1986 · Church Gary W N78128Globe GC-1B · S/N 2128Cancelled May 11, 2015 · Registration expired, pending cancellation · Built 1946 · Anderson Dal S N9637JPiper PA-28-180 · S/N 28-3866Cancelled Dec 22, 2014 · Registration expired, pending cancellation · Built 1967 · Athens Air Inc N7418WPiper PA-28-180 · S/N 28-1306Cancelled Nov 17, 2014 · Registration expired, pending cancellation · Built 1963 · On Site Grading Inc N757CBCessna 152 · S/N 15279623Cancelled Aug 28, 2013 · Registration expired, pending cancellation · Built 1977 · Athens Air Inc N4342HPiper PA-15 · S/N 15-127Cancelled Aug 21, 2013 · Sale reported, canceled · Built 1948 N88013Globe GC-1B · S/N 1055Cancelled Jul 1, 2013 · Registration expired, pending cancellation · Built 1972 · Swift Museum Foundation Inc N168SACessna 402 · S/N 402-0229Cancelled Sep 21, 2007 · Built 1967 · Athens Air Inc N430LPCessna 172S · S/N 172S9430Cancelled Dec 15, 2006 · Exported to Poland · Built 2003 · Jtp Aviation LLC N2EQCessna 414 · S/N 414-0373Cancelled Feb 2, 2006 · Built 1972 · Jtp Aviation LLC N2132CPiper PA-28-181 · S/N 287990145Cancelled May 27, 1994 · Exported to United Kingdom · Athens Air Inc N24931Cessna 152 · S/N 15280455Cancelled Nov 20, 1991 · Exported to United Kingdom · Athens Air Inc N64047Cessna 172M · S/N 17264985Cancelled May 15, 1991 · Exported to United Kingdom · Athens Air Inc N738PYCessna 172N · S/N 17270142Cancelled May 4, 1982 · Exported to Iceland · Davis James E Jr N5690SBeech A23-24 · S/N MA-87Cancelled Dec 23, 1981 · Holmes Curtis G N54419Piper PA-28-140 · S/N 287425127Cancelled Mar 10, 1981 · Exported to Canada · Athens Air Inc N78080Globe GC-1B · S/N 2080Cancelled Dec 21, 1979 · Exported to Canada · Wilson Charlie R N8033NPiper PA-28-140 · S/N 28-25158Cancelled Jan 25, 1977 · Larry Womac N84102Aeronca 7AC · S/N 7AC-2789Cancelled Oct 6, 1970 · Proffitt John M N38567Piper J4E · S/N 4-1580Cancelled May 21, 1965 · Winston C Stansell

Back to Athens, TN