OpenAirDocs.org
Clarksville, TN

Cancelled registrations · 81

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

N97KVVaughn James Keith CHALLENGER SPECIAL · S/N CH20297CW1548Cancelled Sep 4, 2021 · Registration expired, pending cancellation · Built 1997 · Morris PhillipN251CDCessna T182T · S/N T18208818Cancelled Apr 12, 2021 · Sale reported · Built 2008N6242XTubbs Randall E TITAN TORNADO · S/N D96912COHK0242Cancelled Oct 31, 2020 · Registration expired, pending cancellation · Built 1997 · Morris BillyN3904HErcoupe 415-CD · S/N 4605Cancelled Oct 10, 2020 · Sale reported, canceled · Built 1947N928RAKrzysik Scott P CARRERA 140 · S/N 001Cancelled Oct 3, 2020 · Registration expired, pending cancellation · Built 1996 · Merriman John JN76CLBeech C23 · S/N M-1415Cancelled Aug 2, 2020 · Registration expired, pending cancellation · Built 1972 · Smith ShaneN3988HErcoupe 415-D · S/N 4689Cancelled May 8, 2020 · Registration pending, canceledN9695QDavis William E AVID COMMUTER · S/N 895Cancelled Jun 18, 2019 · Exported to Canada · Built 2016 · Irving Stephen HN23814Taylorcraft BL · S/N 1448Cancelled Dec 6, 2018 · Revoked, pending cancellation · Built 1939 · Mcgregor Donald CN5115MTaylorcraft BF · S/N 10415Cancelled Nov 18, 2017 · Revoked, canceled · Built 1946 · Robertson Thomas WN111ERCessna T303 · S/N T303-00238Cancelled Nov 30, 2015 · Built 1983 · Outlaw Aircraft Sales IncN2320ZBeech 23 · S/N M-42Cancelled May 8, 2015 · Registration expired, pending cancellation · Built 1962 · Allen Clyde WN5003JWalker Greg/Goad Jackie CHALLENGER II · S/N CH2-0487-R0245Cancelled Apr 27, 2015 · Registration expired, pending cancellation · Walker GregN3272PWork Robert D KR 2 · S/N 000.101.102BCancelled Nov 26, 2014 · Registration expired, pending cancellation · Work Robert DN4468VCessna 152 · S/N 15284752Cancelled Oct 27, 2014 · Registration expired, pending cancellation · Built 1981 · Tenair LLCN4771GSchleicher Alexander K 7 · S/N 7227Cancelled Oct 14, 2014 · Registration expired, pending cancellation · Built 1965 · Tuttle David ON58497Taylorcraft DCO-65 · S/N 5680Cancelled Oct 9, 2014 · Registration expired, pending cancellation · Braman William PN6660BMoravan ZLIN Z50 LA · S/N 0004Cancelled Sep 22, 2014 · Sale reported, canceled · Built 1976N903XCBowles Chris KITFOX 5 · S/N 10903Cancelled Oct 28, 2013 · Sale reported, pending cancellation · Built 2008N94726Crockarell Erle CHALLENGER II · S/N CH2-0787-0262Cancelled Oct 21, 2013 · Registration expired, pending cancellation · Built 1988 · Buck David GN2321RRobinson Helicopter R22 BETA · S/N 2027Cancelled Aug 22, 2013 · Sale reported, canceled · Built 1991N64877Bell 47G · S/N 1674Cancelled Aug 20, 2013 · Sale reported, canceled · Built 1956N7907ECessna 150 · S/N 17707Cancelled Jul 8, 2013 · Registration expired, pending cancellation · Built 1960 · Zanis Jon PN115TGGill Tyler EIPPER MXLII HP · S/N 1151Cancelled Jul 2, 2013 · Registration expired, pending cancellation · Panosh John EN686DHHerron David D EIPPER GT 400S · S/N 1198Cancelled Jul 2, 2013 · Registration expired, pending cancellation · Herron David DemontN319AHBandy James R III KITFOX III · S/N 818Cancelled May 21, 2013 · Registration expired, pending cancellation · Built 1992 · Bandy James R IIIN72631Cessna 140 · S/N 9807Cancelled May 7, 2013 · Registration expired, pending cancellation · Built 1946 · Saluzzo Thomas AN739RJCessna 172N · S/N 17270742Cancelled May 7, 2013 · Registration expired, pending cancellation · Built 1978 · Mullins Michael FN6337FCessna 337A · S/N 337-0337Cancelled Apr 29, 2013 · Registration expired, pending cancellation · Built 1966 · Arrow Aviation IncN80532Cameron Balloons US Z-105 · S/N 6307Cancelled Apr 22, 2013 · Registration expired, pending cancellation · Built 2002 · Gammons Everett MN133MEAero Commander 1121 · S/N 50Cancelled Nov 27, 2012 · Sale reported, pending cancellation · Built 1966N3665DCessna 310 · S/N 35365Cancelled Sep 20, 2012 · Sale reported, canceled · Built 1956N3908UCessna 150E · S/N 15061308Cancelled Sep 12, 2012 · Built 1965 · Williams Cecil RN48143Ollice KEN RAND KR-1 · S/N 1Cancelled Sep 12, 2012 · Revoked, canceled · Built 1975 · Ollice Lawrence DN3473APiper PA-22 · S/N 22-1742Cancelled Jun 16, 2011 · Revoked, canceled · Built 1953 · Clark JonN46884Bell VH-1B · S/N 64-14057Cancelled Apr 5, 2011 · Expired dealer · Continental Jet Of Tennessee IncN11269Cessna 150L · S/N 15075287Cancelled Jan 5, 2011 · Sale reported, pending cancellation · Built 1973N4180DPiper PA-28-181 · S/N 2843350Cancelled Apr 25, 2007 · Exported to South Africa · Built 2000 · Whitford Ronald E DvmN11382Cessna 340A · S/N 340A0214Cancelled Oct 18, 2002 · Triennial form not returned · Built 1976 · Outlaw Aircraft Sales IncN81587Eighmy Earl E ACROSPORT II · S/N 832Cancelled Aug 27, 2002 · Triennial form not returned · Built 1991 · Eighmy Earl EN40JLCessna 421 · S/N 4210075Cancelled Mar 13, 1998 · Exported to Latvia · Outlaw Aircraft Sales IncN5359RCessna 172RG · S/N 172RG0057Cancelled Jan 28, 1997 · Exported to Belgium · Outlaw Aircraft Sales IncN404GBCessna 404 · S/N 4040613Cancelled Mar 1, 1996 · Exported to Mexico · Outlaw Aircraft Sales IncN8086SCessna 150F · S/N 15061686Cancelled Sep 7, 1995 · Exported to Canada · Salmon Gregoire YN59911Piper PA-31-350 · S/N 317552033Cancelled Feb 1, 1995 · Exported to Guatemala · Outlaw Aircraft Sales IncN6498ACessna T210N · S/N 21063537Cancelled Apr 25, 1994 · Exported to Guyana · Outlaw Aircraft Sales IncN4867HCessna 152 · S/N 15283990Cancelled Feb 14, 1994 · Triennial form not returned · Volunteer Flight Training IncN2137ECessna 421B · S/N 421B-0248Cancelled Jan 10, 1994 · Exported to Lithuania · Built 1994 · Outlaw Aircraft Sales IncN9391TCessna T303 · S/N T30300010Cancelled Jul 26, 1993 · Exported to Colombia · Outlaw Aircraft Sales IncN256FRCessna 172N · S/N 17273915Cancelled Apr 9, 1993 · Exported to Germany · Outlaw Aircraft Sales Inc
Back to Clarksville, TN