From Apple software perspective, Pages '09, Numbers '09, Keynote '09 were the last applications that could open AppleWorks v6 documents, and then only if they were pure word processing, spreadsheet, or presentation. If they incorporate multiple AppleWorks tools, then the opening probability drops.
Pages v5.6.2 (El Capitan) and Pages v6.2 (Sierra) can open Pages '06, '08, and '09 documents, but not earlier Pages formats.
LibreOffice v5.4.1 (you want the “fresh” version) was just released, and it has had the capability to open ClarisWorks 5/AppleWorks 6 documents for some time including word processing, spreadsheet, presentation, and database files as spreadsheets. Again, the degree of individual document complexity may alter your results. I have a bunch of AppleWorks documents here that present as:
As already stated, if an application associated with a document is no longer installed, you may see this icon, and it is not indicative that the content is necessarily an executable entity.
In the Finder, navigate to one of these icons, click once on it, and then press option+command+I (cap i). Unhide the extension if that is checked, and if it is .cwk, then you are dealing with an AppleWorks document. If it is a .pages extension, then you have an out of date, unsupported Pages document format. If the latter, there may be a way to salvage some content.