Brentwood, TN

Cancelled registrations · 47

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

N5134RCessna 172M · S/N 17263351Cancelled Oct 7, 2026 · Sale reported, canceled · Built 1974N841SRCirrus Design SR22 · S/N 2255Cancelled Jun 4, 2022 · Registration expired, pending cancellation · Built 2006 · 841sr LLCN669CTFlight Design CTLS · S/N F-08-06-11Cancelled Mar 21, 2022 · Registration expired, pending cancellation · Built 2008 · Arcturus Aviation LLCN822GKKing Harvey M EXPRESS 90 · S/N HK920Cancelled Dec 4, 2021 · Registration expired, pending cancellation · Built 1997 · Cloud Dancer LLCN223ATCirrus Design SF50 · S/N 0092Cancelled Jun 15, 2021 · Built 2018 · Aerion IncN31SZCessna 172N · S/N 17267732Cancelled Feb 2, 2021 · Registration expired, pending cancellation · Built 1976 · Frenzel Aviation Investments LLCN4943DCessna 172N · S/N 17272406Cancelled Oct 2, 2020 · Built 1979 · Frenzel Aviation Investments LLCN903CCRobinson Helicopter R44 II · S/N 12871Cancelled Apr 27, 2020 · Built 2010 · Parkland Aviation LLCN70TEDJI PHANTOM 3 PROFESSION · S/N P78DCI24061458Cancelled Feb 28, 2020 · Registration expired, pending cancellation · T-Square Engineering IncN335LADJI INSPIRE 1 · S/N CD11205222864CCancelled Jul 18, 2019 · Registration expired, pending cancellation · Limitless Aerial Solutions LLCN63135Cessna 150M · S/N 15077127Cancelled Mar 15, 2019 · Registration expired, pending cancellation · Built 1975 · Freeman James DN11SFJones-Adams BABY ACE C/D · S/N HC11Cancelled Jan 30, 2019 · Registration expired, pending cancellation · Built 1970 · Adams David LN93589Cessna 152 · S/N 15285523Cancelled Jan 30, 2018 · Registration expired, pending cancellation · Built 1982 · Air Lease IncN7317PPiper PA-24-180 · S/N 24-2494Cancelled Jan 26, 2018 · Registration expired, pending cancellation · Built 1961 · Songbird Aviation LLCN48882Cessna 152 · S/N 15283384Cancelled Jan 25, 2018 · Registration expired, pending cancellation · Built 1979 · Air Lease IncN65419Cessna 152 · S/N 15281541Cancelled Jan 25, 2018 · Registration expired, pending cancellation · Built 1978 · Air Lease IncN40LJames John H JR AVID FLYER MK IV · S/N 1195DCancelled Jan 19, 2018 · Registration expired, pending cancellation · Built 2000 · James John H JrN60043Cessna 150J · S/N 15070029Cancelled Apr 4, 2017 · Registration expired, pending cancellation · Built 1968 · Gropp Robert JN66320Farrar V-1 · S/N 1Cancelled May 20, 2015 · Registration expired, pending cancellation · Built 1962 · Farrar D F JrN9882VCessna 172M · S/N 17264545Cancelled May 4, 2015 · Registration expired, pending cancellation · Built 1974 · Air Lease IncN757NPCessna 152 · S/N 15279875Cancelled Nov 18, 2014 · Registration expired, pending cancellation · Built 1977 · Air Lease IncN68327Cessna 152 · S/N 15282259Cancelled Nov 13, 2014 · Registration expired, pending cancellation · Built 1978 · Air Lease IncN3705RCessna 172H · S/N 17255505Cancelled Oct 2, 2014 · Registration expired, pending cancellation · Built 1966 · Jayne William EN41LYLancair LC42-550FG · S/N 42018Cancelled May 21, 2014 · Exported to Canada · Built 2003 · Yolo Aviation LLCN29736Caler THUNDERBUG · S/N 1Cancelled Oct 23, 2013 · Registration expired, pending cancellation · Built 1976 · King Robert CN388KLLittle Keith C CHALLENGER TWO PLACE · S/N CH20391CW0654Cancelled Aug 23, 2013 · Sale reported, canceledN60427Beech C23 · S/N M-2166Cancelled Aug 20, 2013 · Sale reported, canceled · Built 1979N297AGBoeing 737-376 · S/N 24297Cancelled Aug 7, 2013 · Sale reported, canceledN5308MCoplen Randy SPARROWHAWK · S/N SH2003027KCancelled Jun 11, 2013 · Registration expired, pending cancellation · Built 2005 · American Autogyro Of Nashville LLCN6437Farrar LSG-1 · S/N V-2Cancelled Apr 29, 2013 · Registration expired, pending cancellation · Built 1969 · Farrar Demetrius F JrN861CPCessna 337D · S/N 337-1060Cancelled Mar 7, 2013 · Registration expired, pending cancellation · Built 1969 · Plateau Aviation IncN4863GCessna 172N · S/N 17273410Cancelled Dec 18, 2012 · Registration expired, pending cancellation · Built 1979 · Jordan William RobertN278QEnstrom F-28A · S/N 286Cancelled Sep 21, 2012 · Registration expired, pending cancellation · Built 1975 · Sun Ray Helicopters IncN86RWWhitney WAR SCALE CORSAIR · S/N 107Cancelled Sep 10, 2012 · Revoked, canceled · Whitney R WN721FABeech 400 · S/N RJ-21Cancelled Aug 27, 2012 · Built 1987 · Fish Fly LLCN5256WCessna P210N · S/N P21000664Cancelled Jan 24, 2012 · Registration pending, pending cancellation · Built 1981N565SMCameron Balloons Z-90 · S/N 6367Cancelled Oct 12, 2011 · First renewal notice · Built 2004 · B & L Ballooning IncN35TJGates Learjet 35A · S/N 137Cancelled May 10, 2011 · Triennial form not returned · Built 1977 · Aston Aviation Leasing LLCN295AGBoeing 737-376 · S/N 24295Cancelled Nov 6, 2009 · Sale reportedN7712KCessna 180J · S/N 18052707Cancelled Oct 20, 2008 · Exported to Canada · Built 1976 · Thunderhook Camp IncN6407CMoore Dana A DANAMITE · S/N 001Cancelled Apr 22, 2003 · Triennial form not returned · Moore Dana AN23HDCessna 172P · S/N 17276258Cancelled Aug 26, 2002 · Triennial form not returned · Built 1984 · Roads Aircraft Leasing LLCN666RHBeech B300 · S/N FL21Cancelled Jun 30, 1998 · Exported to Peru · Airbank IncN65514Cessna 152 · S/N 15281597Cancelled Apr 9, 1997 · Air Lease IncN4392KRaven S55A · S/N S55A1046Cancelled Oct 7, 1996 · Triennial form not returned · Company Stores Development CorpN739MWCessna 172N · S/N 17270659Cancelled Jan 31, 1985 · St John James O JrN222MYBell 206B · S/N 1346Cancelled Apr 26, 1978 · Exported to Canada · The Murray Ohio Manufacturing Co
Back to Brentwood, TN