OpenAirDocs.org
Franklin, TN

Cancelled registrations · 53

Query with SQL
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 = 'FRANKLIN'
  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.

N21432Piper J3F-50 · S/N 2281Cancelled May 1, 2025 · Revoked, canceled · Built 1938 · Mcgee WadeN615WCBell OH-58A · S/N 72-21328Cancelled Dec 20, 2023 · Williamson County Sheriff OfficeN4101VLindstrand Balloons 77A · S/N 5049Cancelled May 27, 2023 · Expired dealer · Aerostation Ltd IncN564HKJetstream JETSTREAM 4101 · S/N 41081Cancelled Feb 7, 2023 · Exported to Honduras · Built 1996 · Jetstream Leasing Group LLCN217GBCirrus Design SF50 · S/N 0137Cancelled Dec 31, 2022 · Registration expired, pending cancellation · Built 2019 · Bbr Air LLCN735UWCessna 182Q · S/N 18265704Cancelled May 9, 2022 · Registration expired, pending cancellation · Lawler Mark AN1041VMorgan Carl BD 17 · S/N 018Cancelled Oct 18, 2021 · Sale reported, canceled · Built 2003N98LLCessna 340A · S/N 340A0743Cancelled Mar 6, 2021 · Registration expired, pending cancellation · Built 1979 · Ivy Air LLCN1151FCessna 172G · S/N 17254746Cancelled Oct 3, 2020 · Registration expired, pending cancellation · Built 1966 · Barber J KirkN804TCThunder & Colt Airborne Amer COLT 77A · S/N 2455USACancelled May 29, 2020 · Registration expired, pending cancellation · Built 1994 · Aerostation Ltd IncN915CFCessna 510 · S/N 5100328Cancelled Apr 27, 2020 · Built 2010 · Advantage Leasing LLCN753VQYuneec International TYPHOON Q500 4K · S/N YU15210167B04B01Cancelled Oct 5, 2019 · Registration expired, pending cancellation · Paoletta Martin EN905SRFreefly Systems ALTA · S/N 337142Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Snaproll Media LLCN906SRFreefly Systems ALTA · S/N 439987Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Snaproll Media LLCN907SRDJI INSPIRE 1 PRO · S/N W21ACI16010292Cancelled Jul 11, 2019 · Registration expired, pending cancellation · Snaproll Media LLCN899SRDJI PHANTOM 2 · S/N PH646070317Cancelled Feb 26, 2019 · Registration expired, pending cancellation · Snaproll Media LLCN904SRDJI PHANTOM 3 PROFESSION · S/N P76DCF17013797Cancelled Feb 6, 2019 · Registration expired, pending cancellation · Snaproll Media LLCN557QDDJI S1000 · S/N 02Q0010003Cancelled Dec 28, 2018 · Registration expired, pending cancellation · Building 10 LLCN896SRDJI S1000+ · S/N 030011552Cancelled Oct 23, 2018 · Registration expired, pending cancellation · Snaproll Media LLCN897SRDJI S1000+ · S/N 03P0011396Cancelled Oct 23, 2018 · Registration expired, pending cancellation · Snaproll Media LLCN6850HCessna 172M · S/N 17265606Cancelled Sep 13, 2018 · Registration expired, pending cancellation · Built 1975 · Dust Up Partners LLCN51674Bell OH-58A · S/N 72-21267Cancelled Jun 26, 2018 · Registration pending, canceledN209JHHall Jeffrey S AIRBIKE · S/N AB-209Cancelled Jan 16, 2018 · Registration expired, pending cancellation · Built 2003 · Hall Jeffrey SN223LLIsrael Larry L MINIMAX II · S/N 22Cancelled Jan 12, 2018 · Registration expired, pending cancellation · Built 1987 · Lewis Thomas CN689MWWilliams Larry M VARIEZE · S/N 689Cancelled Jun 1, 2017 · Registration expired, pending cancellation · Williams Larry MN9014LChampion 7GCBC · S/N 245-70Cancelled Mar 24, 2017 · Registration expired, pending cancellation · Built 1970 · Lacy David MN6044VLindstrand Balloons 77A · S/N 5138Cancelled Feb 6, 2015 · Third renewal notice · Built 2000 · Aerostation Ltd IncN39RBEiriavion PIK 20D · S/N 20597Cancelled Dec 5, 2014 · First renewal notice · Built 1978 · Miller Douglas L JrN9165RWillis Briegleb BG-12A · S/N 1Cancelled Nov 24, 2014 · Registration expired, pending cancellation · Built 1961 · Ivey William JamesN8002JCameron Balloons US N-145 · S/N 6255Cancelled Aug 20, 2013 · Sale reported, canceled · Built 2000N870MAArgo Michael L AIRBIKE · S/N 001Cancelled Aug 13, 2013 · Registration expired, pending cancellation · Built 2000 · Argo Michael LN74163Balloon Works FIREFLY 7 · S/N F7-293Cancelled Jul 8, 2013 · Registration expired, pending cancellation · Bedford HenryN71105Balloon Works FIREFLY 7 · S/N F7-406Cancelled Jun 18, 2013 · Registration expired, pending cancellation · Built 1987 · Aerostation Limited IncN7868PPiper PA-24 · S/N 24-3093Cancelled May 9, 2013 · Registration expired, pending cancellation · Built 1962 · Norton John GN5561YRaven S55A · S/N S55A-536Cancelled Jan 31, 2013 · Sale reported, canceled · Built 1979N1916RRaven S55A · S/N S55A-396Cancelled Oct 16, 2012 · Registration expired, pending cancellation · Built 1978 · Anderson Gerald DBAN8263CPiper PA-32-301T · S/N 32-8024045Cancelled Jun 14, 2012 · Registration expired, pending cancellation · Built 1980 · Cartwright Michael TN1189Schleicher ASW-20 · S/N 20674Cancelled Mar 24, 2010 · Built 1984 · Poe Michael TN761ZVCessna T210M · S/N 21062657Cancelled Jan 6, 2009 · Triennial form not returned · Built 1978 · Swank DarrellN1704BRolladen-Schneider LS 4-B · S/N 41046Cancelled Jul 16, 2008 · Exported to Canada · Built 2001N739EWCessna 172N · S/N 17270494Cancelled Aug 28, 2004 · Triennial form not returned · Built 1978 · Flymasters IncN8114QOrrick Michael L TEAM MINI MAX 1600 · S/N 753Cancelled Apr 11, 2002 · Triennial form not returned · Orrick Michael LN2159XOrrick Michael L FLIGHTSTAR II · S/N 233Cancelled Feb 27, 2001 · Orrick Michael LN21CDBalloon Works FIREFLY 7 · S/N 7798Cancelled Jun 13, 1996 · Triennial form not returned · Aerostation Limited IncN63255Cessna 150M · S/N 15077206Cancelled Nov 14, 1995 · Triennial form not returned · Matthew Air IncN8034EBeech A36 · S/N E2703Cancelled Oct 11, 1995 · Exported to Brazil · Lynx Properties IncN1033RRaven Industries RX6 · S/N RX6193Cancelled May 11, 1993 · Triennial form not returned · Jones Russell AN4663BCessna 152 · S/N 15283571Cancelled Apr 14, 1993 · Triennial form not returned · B And J Leasing IncN82MAMitsubishi MU-2B-36 · S/N 665Cancelled Jan 22, 1993 · Triennial form not returned · B And J Leasing IncN60CCessna 172G · S/N 17253572Cancelled Oct 10, 1991 · Triennial form not returned · White Frank
Back to Franklin, TN