APL/AEL Search

When you perform a search in the Navy APL/AEL Database, the search results allow you to view current and historical data from the same detail results page. You begin by entering a RIC/APL/AEL or NSN/NIIN number in the associated search field on the Search page. You can also search using Nomenclature Keywords, a CAGE Code, Part Number, Plan Number, Publication/Manual Number, Reference Symbol/Circuit Number, Hull Number, or Ship Name.

In most cases, you will enter a partial RIC/APL/AEL or NSN/NIIN number with a wildcard, and then if you want to filter your search results further, you can enter criteria in the other fields.

In addition, you have the option of clicking the Advanced Search button to open criteria fields, which represent a single line of data from Segment B. The criteria fields narrow your search further.

The first search results page, referred to as the Brief page and the APL File List, returns a list of RIC/APL/AEL numbers and associated Part Number/Manufacturer IDs, Manufacturer Name, and Nomenclature. (If you entered a complete RIC/APL/AEL number, Haystack will take you to the details results page and skip the Brief page because it is one number.)

From the Brief page, you can select a RIC/APL/AEL linked number, which takes you to the current details of the RIC/APL/AEL with access to Segments A, B, C, D, E, F, and MAPL.

To view the historical details of the RIC/APL, click the Historical APL tab. This summary gives you access to Segments A, B, C, D, E, F, G, H, and MAPL.

Color Schematics

The color schematics on the detail pages use three colors to differentiate the tabs within the APL/AEL results. A bright blue tab indicates an active tab and highlights the data you are viewing. A light blue tab indicates that there is data available within the tab; however, you are not in view mode. A gray tab indicates that there is no data available for that tab.

	Current APL Content
	Historical APL Content
	No data available

FLSIP Views

You can easily access FLSIP data from the Historical ALP view. Tabs for FLSIP data appear above the header information on the right side of the page and contain FLSIP .25 and .5, Conventional, Modified FLSIP, AEL, Trident FLSIP/APL, and Trident AEL.

Access to the MAPL is included with the Segment tabs.

Reporting

Microfiche reports and Custom APL reports can be accessed from both the Current and Historical APL views. Reports are specific to the tab you are viewing and will only contain the applicable segments for each.

Batch reporting is available for the current and historical APL content. The default batch reports contain both sets of data.

Code Definitions and Descriptions

When you hover the mouse over a value in the details result list, a popup is displayed with a definition and explanation of the code.

Hover your mouse over the graphic examples to see examples.

 To perform an APL/AEL search

1. Click the Database menu, highlight US Navy, and then click APL/AEL.
2. At the bottom of the screen click the Advanced Search button to expand the screen and view the available Criteria fields that are similar to the Criteria fields on the FLIS screen. To return to a basic APL search, click the Return to Basic Search button.
3. Enter 00003064 in the RIC/APL/AEL field.  
4. Place your cursor in the Ship Name field and begin typing in USS Ronald Reagan. The pull-down menu uses "type ahead" functionality to display a list of ship names that includes the USS Ronald Reagan. Select USS Boston, and then press Search.
5. The results display Segment D data by default.

To view code information or refine your search

1. Hover over or click any of the underlined codes, such as the 9B Cog code or 4320 FSC code to view the definitions for those codes.
2. Enter 5310 in the FSC field at the top of the FSC column in the list, and then press Enter on your keyboard or press the Go! button to refine your list to just the items with that FSC code.
3. To clear the FSC sort, highlight the field, and then press the Clear button in the COG column.
4. To view Segment B data, click the [B] Component Characteristics [19] tab. The number of records is displayed. You will notice that the [D] Component Parts button shows the number of records in Segment D data when you click the other Segment buttons.
5. To view Segment F data, click the Historical APL tab, and then click the [F] Multiple Ref. Numbers [60]tab. In our example, Segment G has no data available, and the tab is gray.

To view or build reports

1. Click the Microfiche Report link to display a PDF image of the component, which includes Segment B and D data and can include other segmental information.
2. Close the Microfiche Report window to return to your APL data.
3. Click the Custom APL Report button to go to the selectable segment data you would like to use to build a custom report. Click the Default Report button if you want to use all available segments for your report.
4. Click the Display/Print Report button to compile your report.

To view other ships and other FLSIP, Trident, or MAPL views

1. Click the Ship/Hull link to view other ships that use that component.
2. Click the Back To Summary button to return to the results list.
3. Click the Back To Brief link to go to the APL File List screen where you can select other available FLSIP, Trident, or MAPL views.
   
   Note: You can sort the search results in the MFR ID and Nomenclature columns as well as the RIC/APL column.
4. Click the MAPL tab in the Historical APL display to view the Master Allowance Parts List.

To export segment data

1. To export any of the major segments [B, C, D, E, F] to an Excel spreadsheet or text format, select the component, and then click Print List below the table.
   
   The screen opens with a new table and an Export Report Data box.
2. Click the Export to Excel format icon button or the Export to text format icon button to download the table to your computer.
   
   Note:  You will be able to download the first 2,500 items listed in the segment.

Related topics: