OpenAirDocs.org
Concord, NC

Cancelled registrations · 62

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 = 'NC' AND d.registrant_city = 'CONCORD'
  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.

N66690Cessna 150M · S/N 15076213Cancelled Nov 5, 2022 · Registration expired, pending cancellation · Built 1974 · Fournier Michael EN988SFFessler Steven W ULTIMATE · S/N 44Cancelled Jul 3, 2021 · Registration expired, pending cancellation · Locklear Jonathan RN32584Piper J3L-65 · S/N 5473Cancelled Jun 9, 2021 · Registration expired, pending cancellation · Built 1940 · Mcgee Ralph WN604FJCanadair CL-600-2B16 · S/N 5001Cancelled May 29, 2020 · Registration expired, pending cancellation · Built 1986 · Pollard Aircraft Sales IncN230BTDassault-Breguet FALCON 50 · S/N 62Cancelled Mar 16, 2019 · Registration expired, pending cancellation · Built 1981 · Pollard Aircraft Sales IncN258KTBritish Aerospace BAE 125 SERIES 800A · S/N 258007Cancelled Mar 16, 2019 · Registration expired, pending cancellation · Pollard Aircraft Sales IncN27RDassault FALCON 2000 · S/N 05Cancelled Dec 15, 2018 · Registration expired, pending cancellation · Built 1995 · Pollard Aircraft Sales IncN604SHCanadair CL-600-1A11 · S/N 1008Cancelled Apr 18, 2018 · Registration expired, pending cancellation · Built 1980 · Pollard Aircraft Sales IncN9056WPiper PA-28-235 · S/N 28-10650Cancelled Mar 16, 2018 · Revoked, canceled · Built 1965 · Shannon William RN25VGGulfstream Aerospace G-IV · S/N 1018Cancelled Mar 12, 2018 · Registration expired, pending cancellation · Built 1987 · Pollard Spares LLCN133KTCessna 525 · S/N 525-0133Cancelled Feb 28, 2018 · Registration expired, pending cancellation · Pollard Aircraft Sales IncN78CTBeech 200 · S/N BB-761Cancelled Jan 9, 2018 · Registration expired, pending cancellation · Built 1980 · Pollard Aircraft Sales IncN688GRNorth American T-28C · S/N 140581Cancelled Jan 8, 2018 · Registration expired, pending cancellation · Built 1958 · Mangan John WN52984Consolidated Vultee BT-13 · S/N 241Cancelled Nov 20, 2017 · Revoked, canceled · Lewetta Avia Svc IncN19418Rearwin 9000 · S/N 596SCancelled Oct 28, 2017 · Revoked, canceled · Built 1938 · Goodwin Paul FN209WWNorth American T-28B · S/N 138209Cancelled Oct 24, 2017 · Registration expired, pending cancellation · Built 1954 · Boursse Pierre GN988CCBeech 200 · S/N BB490Cancelled Jul 21, 2017 · Exported to Canada · Built 1979 · Apogee Finance LLCN5605MDestiny Powered Parachutes XLT · S/N 1B0161Cancelled Jul 14, 2017 · Registration expired, pending cancellation · Simpson Kevin BN46444Taylorcraft DCO-65 · S/N L-6311Cancelled Jul 12, 2017 · Registration expired, pending cancellation · Built 1944 · Morris Thomas EN2220HEngineering & Research 415-C · S/N 2843Cancelled Jul 7, 2017 · Registration expired, pending cancellation · Built 1946 · Morris Thomas EN2825APiper PA-28RT-201 · S/N 28R-7918162Cancelled Jul 3, 2017 · Registration expired, pending cancellation · Built 1979 · O'Neale Robert IIIN30489Morris Thomas E MORRIS DRIFTER · S/N M-103Cancelled Mar 6, 2017 · Registration expired, pending cancellation · Morris Thomas EN1022EBellanca 8KCAB · S/N 295-77Cancelled Nov 23, 2016 · Exported to Uruguay · Erochenko Rey Alexis GordieyN41ESHesterlee David R VARIEZE · S/N 676Cancelled May 15, 2015 · Registration expired, pending cancellation · Built 1980 · Stamper Edward K JrN44117Taylorcraft BC12-D1 · S/N 9917Cancelled Dec 17, 2014 · Registration expired, pending cancellation · Built 1946 · Bumgarner Dennis CN340JBBeech A45 · S/N G-791Cancelled Jul 16, 2013 · Sale reported, canceledN5945UPiper PA-28-140 · S/N 28-26845Cancelled Apr 25, 2013 · Registration expired, pending cancellation · Built 1970 · Mcgee Ralph WayneN5972SBeech A23-24 · S/N MA-58Cancelled Apr 25, 2013 · Registration expired, pending cancellation · Built 1966 · Cabarrus Flying Service IncN57SCBeech B300 · S/N FL-34Cancelled Jan 22, 2013 · Exported to Canada · Built 1990 · Pollard Aircraft Sales IncN448CHHeyn Russell RANS S-6 · S/N 03991308Cancelled Nov 27, 2012 · Sale reported, canceled · Built 1999N280TTBeech 200 · S/N BB-280Cancelled Aug 30, 2012 · Exported to Brazil · Built 1977 · Pollard Aircraft Sales IncN3116UTaylorcraft BC12-D1 · S/N 9936Cancelled Aug 15, 2012 · Registration pending, canceled · Built 1946N699TTRaytheon C90A · S/N LJ-1606Cancelled Sep 21, 2011 · Exported to New Zealand · Built 2000 · Carolina Turbine Sales IncN6JRRaytheon 390 · S/N RB-161Cancelled Dec 20, 2010 · Roush Fenway Racing LLCN4542UCessna 150D · S/N 15060542Cancelled Oct 27, 2009 · Triennial form not returned · Built 1964 · Gitts John Martin JrN8171APiper PA-34-200T · S/N 34-8070150Cancelled Jul 24, 2009 · Exported to Guatemala · Built 1980 · Aircraft Propeller DepotN405JBeech B300 · S/N FL-112Cancelled Sep 30, 2008 · Exported to Canada · Built 1993 · Carolina Turbine Sales IncN602DADiamond Aircraft Ind DA20-A1 · S/N 10302Cancelled Jan 23, 2008 · Exported to Thailand · Built 1997 · Lancaster Aviation IncN340EBBell 206B · S/N 1817Cancelled Sep 24, 2007 · Exported to Australia · Built 1975 · David Drye Co LLCN5774CCessna 402C · S/N 402C0039Cancelled Jun 22, 2007 · Triennial form not returned · Built 1979 · Race City Air LLCN440WABeech 200 · S/N BB-700Cancelled May 22, 2007 · Exported to United Kingdom · Built 1980 · Carolina Turbine Sales IncN364BWPiper PA-32-300 · S/N 32-7240005Cancelled Jan 30, 2007 · Triennial form not returned · Built 1972 · Race City Air LLCN96758Taylorcraft BC12-D · S/N 9058Cancelled Dec 4, 2006 · Built 1946 · Jewell James MN421LLCessna 421C · S/N 421C0305Cancelled Mar 20, 2002 · Triennial form not returned · David Drye Company LLCN283JPBeech 200 · S/N BB283Cancelled Mar 11, 2002 · Exported to Canada · Built 1977 · Spitfire Aviation IncN632DBeech C35 · S/N D-2894Cancelled Oct 27, 2000 · Triennial form not returned · Farbo Raymond AN704ETCessna 150M · S/N 15078559Cancelled Aug 10, 2000 · Triennial form not returned · Farbo Gregory WN12LDBeech B200 · S/N BB1125Cancelled Jun 18, 1997 · Exported to Australia · Niles Air IncN714ZJCessna 152 · S/N 15279559Cancelled May 14, 1991 · Exported to France · Rahilly Bob HN7032DPiper PA-22-150 · S/N 22-4926Cancelled Sep 15, 1976 · Carawan Henry L
Back to Concord, NC