Skip to content

Cancelled registrations · 424

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

N489VRGulfstream Aerospace G-IV · S/N 1389Cancelled Oct 20, 2026 · Exported to Turkey · Built 1999 · Business Aircraft Leasing Inc N556RBell 206-L4 · S/N 52184Cancelled Jun 1, 2026 · Exported to South Africa · Built 1996 · Rogers Group Inc N237XJCessna 421C · S/N 421C0261Cancelled May 23, 2026 · Sale reported, canceled N12847Great Lakes 2T-1E · S/N 257Cancelled Jan 31, 2026 · Registration pending, canceled · Built 1932 N17796Aeronca K · S/N K63Cancelled Jan 31, 2026 · Registration pending, canceled · Built 1937 N121JEGulfstream Aerospace G-IV · S/N 1397Cancelled Oct 31, 2025 · Exported to Turkey · Built 2000 · Business Aviation Leasing Inc N1561DCessna 195A · S/N 7783Cancelled Jun 1, 2024 · Sale reported, canceled · Built 1952 N89382Cessna 140 · S/N 8414Cancelled Jun 1, 2024 · Sale reported, canceled · Built 1946 N921MSchleicher ASW-20B · S/N 20622Cancelled Apr 15, 2024 · Sale reported, canceled · Built 1983 N5740FPiper PA-28-140 · S/N 28-25042Cancelled Jul 26, 2023 · Built 1968 · Agni Flight LLC N1249NFairchild 24 G · S/N 2940Cancelled Apr 1, 2023 · Registration expired, pending cancellation · Built 1938 · Tennessee Flying Machines LLC N28EFairchild 24 G · S/N 2930Cancelled Apr 1, 2023 · Registration expired, pending cancellation · Built 1938 · Tennessee Flying Machines LLC N34765Funk B75L · S/N 213Cancelled Apr 1, 2023 · Registration expired, pending cancellation · Built 1942 · Tennessee Flying Machines LLC N60377Cessna 150J · S/N 15070267Cancelled Apr 1, 2023 · Registration expired, pending cancellation · Built 1969 · Boyles Jessica M N874JSBeech F33A · S/N CE-1453Cancelled Apr 1, 2023 · Registration expired, pending cancellation · Built 1990 · Polk William H N133CCRobinson Helicopter R44 · S/N 2247Cancelled Mar 16, 2023 · Built 2012 · Apruda Andrei Trustee N215RAPiper PA-28-151 · S/N 28-7415200Cancelled Mar 4, 2023 · Registration expired, pending cancellation · Built 1974 · Caldwell Randy E N945WWBrown Ronald L ZODIAK 601 XL · S/N 6-5261Cancelled Mar 4, 2023 · Registration expired, pending cancellation · Built 2006 · Sturdivant Charles N N8693SCessna 150F · S/N 15061993Cancelled Feb 4, 2023 · Registration expired, pending cancellation · Built 1965 · N8693s LLC N701MPBell OH-58A · S/N 72-21270Cancelled Jan 16, 2023 · Registration expired, pending cancellation · Metro-Nashville P D N624ZAFourthwing VIREO · S/N F172Cancelled Dec 7, 2022 · Sale reported, canceled N30170Firefly Balloons 2010 FIREFLY 8B-15 · S/N F8B-2122Cancelled Dec 3, 2022 · Registration expired, pending cancellation · Above The Trees LLC N6957ACessna 172 · S/N 29057Cancelled Nov 5, 2022 · Registration expired, pending cancellation · Built 1956 · Kilburn Darrell D N2475EAeronca 7AC · S/N 7AC6054Cancelled Oct 6, 2022 · Sale reported, canceled · Built 1955 N625DAFourthwing VIREO · S/N F136Cancelled Oct 6, 2022 · Sale reported, canceled N648FWFourthwing VIREO · S/N F143Cancelled Oct 5, 2022 · Sale reported, canceled N152PCDJI INSPIRE 1 · S/N W13DCD25030988Cancelled Sep 3, 2022 · Registration expired, pending cancellation · Power Consulting Associates Inc N745WADJI INSPIRE 1 · S/N W13DCB05020082Cancelled Sep 3, 2022 · Registration expired, pending cancellation · Albani John N735HCGulfstream Aerospace GIV-X (G450) · S/N 4141Cancelled Aug 15, 2022 · Exported to Turkey · Built 2008 · Business Aircraft Leasing Inc N5803CLockheed Martin INDAGO · S/N IDGV1AG061820151058Cancelled Aug 3, 2022 · Sale reported, canceled N744NAFourthwing VIREO · S/N F188Cancelled Aug 3, 2022 · Sale reported, canceled N213MMPiper PA-28-140 · S/N 28-24143Cancelled Jul 30, 2022 · Registration expired, pending cancellation · Built 1968 · Hall Norris Ronald N286PCCessna 501 · S/N 501-0164Cancelled Jul 13, 2022 · Third renewal notice · Msr Investment Properties LLC N6365SCessna 150G · S/N 15067165Cancelled Jul 2, 2022 · Registration expired, pending cancellation · Built 1967 · Caldwell James E N138PCDJI PHANTOM 2 · S/N PH645145149Cancelled Jun 4, 2022 · Registration expired, pending cancellation · Power Consulting Associates Inc N450APCirrus Design SR22 · S/N 1028Cancelled Jun 4, 2022 · Registration expired, pending cancellation · Built 2004 · Donnellan William N311RVTestement J/Dodd Pa VANS RV-10 · S/N 40321Cancelled Mar 5, 2022 · Registration expired, pending cancellation · Built 2009 · Cohen David S N535SRCirrus Design SR22 · S/N 2326Cancelled Jan 8, 2022 · Registration expired, pending cancellation · Built 2007 · Cornman Aviation LLC N18SDRolladen-Schneider LS-4 · S/N 4356Cancelled Dec 4, 2021 · Registration expired, pending cancellation · Built 1983 · Wilson Harvey E N257DACirrus Design SR22T · S/N 1049Cancelled Oct 30, 2021 · Registration expired, pending cancellation · Built 2015 · Dude Air LLC N155WMooney M20J · S/N 24-3271Cancelled Jul 3, 2021 · Registration expired, pending cancellation · Built 1992 · Kramer James E N501FTCirrus Design SR22 · S/N 3654Cancelled Jul 3, 2021 · Registration expired, pending cancellation · Built 2010 · Danda Aviation LLC N55866Piper PA-28-140 · S/N 28-7325510Cancelled Jul 3, 2021 · Registration expired, pending cancellation · Built 1973 · Ddgs LLC N404JRaytheon B200 · S/N BB-1793Cancelled Jun 16, 2021 · Exported to Canada · Apruda Andrei Trustee N341RAS+ AC 4 · S/N 41Cancelled May 29, 2021 · Sale reported, canceled · Built 1999 N8983SCessna 150F · S/N 15062283Cancelled May 8, 2021 · Registration expired, pending cancellation · Built 1965 · Woodrick Norman E N5146RCessna 172M · S/N 17263363Cancelled Jan 9, 2021 · Registration expired, pending cancellation · Built 1974 · Nashville Flight School LLC N733RRCessna 172N · S/N 17268494Cancelled Nov 13, 2020 · Built 1976 · Zev Aviation LLC N792LGPilatus PC-12/47E · S/N 1792Cancelled Oct 20, 2020 · Built 2018 · Delta Leasing LLC N755MCCessna R182 · S/N R18201166Cancelled Oct 5, 2020 · First renewal notice · Built 1979 · Cisneros Joe Michael

Back to Nashville, TN