PMA Parts Finder User Manual - DOC by mbl19456

VIEWS: 29 PAGES: 35

									                 The PMA Parts Finder

                              Version             Six
                            (Document Revised November 1,2004)


                       Product Description and Users’ Guide


                                      Produced by

                               Aviation Data Research
                                   P. O. Box 3691
                               Central Point, OR 97502
                                  1 + 541-664-2870
                                  http://www.aviationdata.com/




This file is best viewed using at least 1024 x 768 screen resolution with large fonts option
                     Table of Contents

Section I – Program Operation

Introduction ………………………………………………………             4
Installation ……………………………………………………… .           6
Program and Database Updates ………………………………      7

The Main Screen ………………………………………………..           8

Finding Parts and Holders
      Find PMA Parts ……………………………………………         8
      Parts Finding Wizard ……………………………………….    9
      PMA Parts Located ……………………………………….      11
      PMA Holders ……………………………………………….         12

Database Tools
     Parts Matching Wizard …………………………………      13
     Address Manager ………………………………………….        15
     List Manager ………………………………………………..        17
     Label Manager …………………………………………..…        18
     Reports and Data Export …………………………………    19

Database Information Screens
     MIDO List ……………………………………………………           20
     Total PMA Part Count ……………………………………..    20
     Database Statistics ………………………………………..    21
     Database Update Log ……………………………………...    21

Printed Reports
      Holder List Report …………………………………………     22
      Parts List Report …………………………………………..    23

Additional Information
      Database Limitations …………………………………….    24
      Disclaimer …………………………………………………          24




                                                   2
Section II – Program Help Screens

Find PMA Parts ……………………………………………………          25
PMA Holders ……………………………………………………….           26
Reports and Data Export …………………………………………     27
Program and Database Updates ……………………………….   28
Parts Finding Wizard ……………………………………………..     29
Parts Matching Wizard …………………………………………..     30
Address Manager …………………………………………………          31
List Manager ………………………………………………………           32
Label Manager ……………………………………………………           33
Glossary ……………………………………………………………             34




                                                  3
                                    Introduction
The purpose of the PMA Parts Finder computer program is to locate PMA parts and
their holders. The output of the program may be directed to screen view or printed lists,
machine readable data files or, in the case of PMA holders, to address labels or mail
merge data documents. Data and merge export documents may be imported into other
programs for creation of mass mailings or other purposes.

PMA Parts
Parts may be found by searching for part names, part numbers, aircraft, engine or
propeller of installation, PMA holder name, city, state, or database entry date. Parts may
also be located by searching for Original Equipment Manufacturer (OEM) part numbers
or company names. Lists developed by searches may be saved and printed or combined
with other lists developed with different criteria to form composite lists. Saved lists may
be used as the data basis for other searches giving the ability to combine criteria for more
definitive lists. Saved lists may also be searched by method of design approval.

Two broad methods of on-screen, search result display are used. They differ in the
information displayed, but not in the information available. The first method, which is
used for a search of all PMA parts delivers detailed information on the PMA part including
design criteria approval and installation data. The second display format is restricted to
just those PMA parts for which a known relationship to an OEM part exists. The
information displayed consists of just the part name and the corresponding OEM and
PMA manufacturer name and part number. Regardless of the display format, the other
information is available through printed lists of machine readable data export.

PMA Holders
PMA Holders when associated with the parts they manufacture are identified when PMA
parts are located. Detailed information on PMA holders, including contact information,
may be independently obtained and displayed by a section of the program dedicated to
that purpose.

Addresses
The program contains an address helper/converter called Address Manager. This
function tracks the movement of PMA parts as companies are merged and absorbed.
For example, searching for AeroResearch will take you to Honeywell International.
(AeroResearch was absorbed by Garrett who was then acquired by AlliedSignal who
subsequently purchased Honeywell and changed the name of the combined companies
to Honeywell International.) Additionally, the Address Manager finds companies located
at the same address, city and state, state or postcode.

Lists
Lists of parts and holders can be developed and saved. These saved lists are then used
as a data basis for mailing labels, printed reports or mail merge or data documents. Lists
can also be used as the source data for other lists including searches by design approval.

Back to the Table of Contents


                                                                                           4
Mailing Labels
One hundred fifty pre-formatted Avery brand labels are available for printing address
labels. The label data is taken from lists developed through criteria searches and then
saved. Labels may be individually added, deleted or edited before printing.

Mail Merge Documents
Mail merge is the term applied to the process of uniting two documents to produce mass
mailings. The first document, called the master, is the boilerplate text (usually a form
letter) that contains special codes for the insertion of variables. The variables are c on-
tained in a data document developed by the PMA Parts Finder. Mail merging via a word
processing program blends the documents to produce personalized mass mailings.

Printed Reports
Three standard lists can be prepared and printed:
      1. Parts list without application data
      2. Parts list with application data, and
      3. Holder lists

An additional parts list (OEM-PMA Matches) can be printed.




Back to the Table of Contents




                                                                                          5
                                Program Installation
The PMA Parts Finder program is supplied on CD ROM and/or by download from the
Internet. The program may be installed on any Windows platform machine including 95,
98, 2000, XP, and NT 3.5x, 4 or 5 platforms.

 An automated installation program is included to install the program to c omputer hard
drive. The program and data files will occupy about 100 MB of hard drive storage space.
The program will also grow in size if lists are created and saved.

The installation program will create a group with a title of PMA Parts Finder and place in
it startup shortcuts for the program and the database optimization utility. A start icon will
also be placed on the desktop. Use these icons to start the program.

ADR recommends the use of 1024 x 768 screen resolution, or better, with the Large
Fonts option selected. See your Windows guide for the method of changing between
large and small fonts in your particular system.

Object colors will vary depending on the Windows platform installed on the host
computer. Windows 98 and 2000 installations will resolve most screen objects to a
default gray color while XP machines will see the same objects as buff colored. This
manual was created with images obtained from an XP machine and are therefore buff
colored.

Program Registration
The PMA Parts Finder is a controlled access application. This means it must be
activated before it can be used. There are two levels of activation: (1) A demonstration
mode that is limited in function and will automatically expire thirty days after installation
and, (2) a permanent installation mode.

The activation process consists of collecting an unique computer identification code
generated by the PMA Parts Finder from hardware items on the installation machine.
The machine identification code is called a “Fingerprint.” The Fingerprint is submitted to
obtain an installation unlock code that is entered into the machine to permit the PMA
Parts Finder to function.

Both the demonstration mode and the permanent use mode require activation.




Back to the Table of Contents


                                                                                                6
Program and Database Updates
The PMA Parts Finder undergoes continual refinement as parts are added, duplicate
information removed and improvements to the program occur. These updates are
obtained via electronic transfer or by monthly issuance of a new CD-ROM.




Updates are continuously available though download from the ADR website. A Live
Update process provides one-click access to updating of the database.

Data updates are packaged in monthly increments for convenience in identification and
classification. A monthly update is begun on the first business day of the month and
builds until the last business day of the month. At that time an advisement is sent to all
subscribers notifying them of the availability of the completed monthly update. In the
case of CD-ROM subscribers, a new disk is issued at that time.

The PMA Parts Finder consists of two main modules. The first, and larger, contains the
data. The second, much smaller file the program intelligence. When program changes
occur they almost invariably involve the smaller file. This file may be upgraded or
replaced at any time by use on an icon within the PMA Parts Finder shortcut group.



Back to the Table of Contents


                                                                                         7
The Main Screen
The Main screen is a tab-control driven screen window from which the main functions of
the PMA Parts Finder can be invoked. A series of tabs at the top of the screen window
may be selected to gain access to the PMA Parts Finder’s controls. Context sensitive
HELP is available via a button at the bottom of the Main Screen.

Find PMA Parts
The first tab position of the Main Screen is the Find PMA Parts tab. The controls on this
window permit the selection and entry of criteria to be applied against the PMA Parts
Finder database. The results of a search (also called query results) are displayed on one
of two search output screens depending on the criteria input. You may choose to query
the entire database or a previously developed and save parts list. Additionally, you may
choose between all parts in the data source or just those with a known OEM/PMA
substitution relationship. Database search options:




Select the item upon which to query and click the FIND button. Some query items permit
you to specify whether to search for an exact match, for items that begin with the input
text, or for items where the input text appears anywhere in the field.

All searches require an input of some criteria. Certain items may be selected from a list,
such as PMA holder names, while others, such as part numbers, require keyboard input.
After selecting the criteria element, a text box or drop down list will open for selection or
input of criteria.




Back to the Table of Contents


                                                                                            8
The Parts Finding Wizard
If you are new to the PMA Parts Finder then you may be intimidated or confused by the
number of available choices for entering search criteria. To ease the pain of learning, an
automated search criteria selection process, called a Wizard, is employed. The Wizard
provides a series of easy to understand panels that will step you through the process of
building the search query.




Once the query is built just click the FIND button to locate the parts you want to see.




Back to the Table of Contents


                                                                                             9
PMA Parts Located (All PMA Parts Option)




The search results are displayed in a new window that contains three sections: The top
section contains part identification information. If more than one part has been located
the display will show a scrolling list. The Switch View button toggles between the
scrolling list and a form view that details the part indicated by the black triangle on the left
side of the list.

The middle section of the window shows application information for the part selected in
the upper section. When more than one application is found, the view may be changed
from scrolling to detail on the application by the second Switch View button.

The bottom portion identifies OEM parts, if any, for which the PMA part is an approved
substitute.

You may save any search results as a list that you name. The list can then be used as a
basis for additional searches. For example, a primary search can be for parts than can
be installed on a Boeing 747. Then the saved list can be searched a design approval
method of Licensing to find parts manufactured under license from Boeing. By using this
technique you can gradually narrow the search to find a highly discrete grouping of parts
that involves extensive and involved criteria.




Back to the Table of Contents


                                                                                             10
PMA Parts Located (Replacement Parts Option)




The display format of this search is different from the All Parts view. This is because the
focus is on the replacement relationship that exists between the OEM part and the PMA
part rather than on the PMA part itself. You may save the results of this search as a
named list within the PMA Parts Finder or print with a system printer or export in machine
readable format as either delimited text or in Microsoft Excel format.

The display results may be sorted simply by clicking in any column by which you want to
sort by. The sort order is ascending.

You can view the results of this search format in the alternative All PMA Parts view by
first saving the list with a name. Then use the List Manager and recall the list. The list
will then be displayed in the All PMA Parts view.

If you choose to export the list to XLS format be careful to insure that your list does not
exceed 64k (65,536) entries. For larger lists use text delimited format and export as text.




Back to the Table of Contents


                                                                                             11
PMA Holders




You may obtain information on any listed PMA holder from this tab. Information supplied
is the name and address with phone and FAX numbers for many holders. Also shown is
the MIDO for the PMA producer, PQ number (FAA issued PMA identification number
appearing on all supplement sheets), CAGE code (if known), and Email and WebSite
addresses. The number of approved PMA parts in the database and the earliest date of
PMA issuance are also displayed. Notes or comments are included and perhaps Internet
links to interesting or background references that discuss this particular PMA Holder.



                                                                A popup window will
                                                                display the name,
                                                                address, phone and
                                                                FAX number of the
                                                                cognizant MIDO for
                                                                the selected PMA
                                                                holder.




Back to the Table of Contents


                                                                                      12
Database Tools:

The Parts Matching Wizard




The PMA Parts Finder has the ability to match internal or external lists of part numbers
against its lists of PMA or OEM parts. There are two basic reasons for matching part
numbers each generally specific to an industry segment. Parts users are mainly
interested in obtaining information on PMA alternatives to OEM parts. On the other hand,
parts producers are interested in PMA parts that may compete with the part producer’s
own product line. The Wizard addresses both of these situations.

External lists of up to 65,536 parts may be composed in Microsoft Excel. Larger lists
need to be compiled in a database program and exported to a text delimited format. The
size limitation is an Excel limitation and not a limitation of the Wizard. Another limitation
is that the Excel list may be only one column and the first entry in the list have double
quote marks around it, e.g. “123456-54”. The list is “typed” from the first entry and must
be textual. That means an expression such as 123456-54 can mean 123456 minus 54,
is numeric expression and without the quotes the data translation will fail.

If the external list is composed of OEM part numbers, the Wizard will match that list
against its internal cross-reference of OEM/PMA numbers. Additional fields are added to
the matched results and then exported in the same format of the import file. (i.e. If the
source file is XLS then the output file will also be XLS.) The exported list will contain only
listings for which a match between the source list OEM part number and a PMA part has
been identified.




Back to the Table of Contents

                                                                                            13
If the list is composed of PMA part numbers, the Wizard will match that list against its
internal cross-reference of OEM/PMA numbers in order to find OEM numbers that match.
Then the OEM numbers are matched again against the cross-reference to find any
additional PMA numbers that also match the OEM part. The list that is exported contains
only PMA alternatives to the parts on the original PMA parts list. This section also
permits the use of a list developed within the PMA Parts Finder and saved with a name.
This function thus permits developing a list of PMA parts and then finding alternatives to
these PMA parts all without ever leaving the program.

The Imported Parts List Matching Wizard is a series of screens that walk you through the
importation of a list of parts to compare against the PMA Parts Finder database. The
steps are as follows:

       1. Create a file of parts numbers. Lists of up to 65,536 parts can be in native
Excel format. Larger lists must be in delimited text which can be created in just about
any database program. Delimited text files are exported from the database program in
TXT format. Or use a list named and saved within the PMA Parts Finder.

       2. Import the list into the PMA Parts Finder by specifying the file to the Wizard.

     3. Designate whether the imported list is composed of OEM or PMA part
numbers.

       4. Set the fields that you want to see in the output. The OEM and PMA company
names and the PMA part number are included by default. You must select at least one
additional field.

       5. Set the sort order. Choices are: PMA part number, OEM part number or PMA
holder first followed by PMA part number.

        6. Set the export path and file name of the file to be created and exported. The
file suffix will be automatically matched to the import file type, i.e. XLS to XLS and TXT to
TXT.

Matching large lists makes substantial demands on a computer’s resources. A modern
Pentium P-III or better based machine with 512 MB of memory and ample disc space
should handle lists of 150,000 or more parts. (The largest “real-case” we’ve tried is
275,000 and that ran successfully.) If your computer “freezes” during a match process
then you may have overwhelmed its resources. If this does occur, try splitting your parts
list into smaller pieces and proceed with multiple searches.




Back to the Table of Contents


                                                                                            14
Address Manager

The Address Manager attempts to track the progression of ownership of PMA transfers.
STC owners are included with PMA holders for a more comprehensive scope. It can also
show multiple listings for the same address, city and state, state and postcode as below.




Phone and FAX entries are linked to an autodialer that will dial the number when double-
clicked. Clicking an E-Mail link will launch the computer’s E-Mail package with the
indicated address in the To: line. Clicking a website link will open the computer’s web
browser to the indicated page provided the computer is connected to the Internet.

A powerful feature of the Address Manager is its ability to locate entries with identical
address components. It is sometimes valuable to learn that a target company shares
facilities with 3 other companies and may be de facto the same company, or at least have
an intimate relationship with the other companies. See illustration on next page.




Back to the Table of Contents


                                                                                       15
Address Manager showing the results of an address matching query.




Address matches may be made on:

Street Address
City
State
Postal Code (Zip), or
Country if other than U.S.




Back to the Table of Contents



                                                                    16
The List Manager




The List Manager permits recalling, deleting, renaming and merging of lists. Lists are
central to the operation of the PMA Parts Finder as most after-search functions depend
on saved lists. The general procedure is:

1. Develop criteria for a search

2. Perform the search

3. Save the search results as a named list

4. Recall the list from other sections of the program such as viewing or printing list
reports.

Searches within results depend on the saving of named lists. For example, suppose you
want a list of all turbine components on CF6 engines that have been approved this year.
To proceed you would first search for all CF6 approved parts and save the resulting list
as CF6. Then you would search the CF6 list for parts entered into the database after the
first of the year and save the resulting list as New_CF6. Finally, you would search the
New_CF6 list for any part containing the word “turbine” in the nomenclature to find new,
CF6, turbine related parts.

Parts in each saved list are linked to their manufacturer so it is unnecessary to save
different part and holder lists; they are the same. In the above example, you could easily
view the PMA holders of the parts in the New_CF6_Turbine list or print mailing labels to
them.

Lists may also be combined to group the results of different parts or holder searches.



Back to the Table of Contents



                                                                                         17
The Label Manager




You can create mailing labels from any saved list. Choose any one of 150 preformatted
Avery brand labels. You may edit, add or delete individual labels before printing. For
more information see the Label Manager Help Screen.




Back to the Table of Contents



                                                                                         18
Reports and Data Export




The Reports and Data Export Screen permits the preview and printing of PMA parts and
holder lists. Parts lists may be printed as reports either with or without application data.
The Holder List Report allocates a single line to each holder. The Parts List Report either
with or without application data allocates a variable number of lines depending on the
length or part and application data fields and number of applications.

You may also create merge and/or delimited data files that are exported from the PMA
Parts Finder. These text files can be used as data sources for mail merge operations or
imported into other programs such as Microsoft Excel for other purposes. Parts lists
exported from the PMA Parts Finder are limited to part identification information only;
application data and parts substitution information can not be exported. The exception to
this is the parts lists developed with the Find OEM Part function.

Another useful feature is the ability to export any save list as an Excel file in FAA data
format. This means the data in the Excel spreadsheet is conformed in the same manner
as the FAA data tables of PMA parts available for download from the Internet.




Back to the Table of Contents


                                                                                          19
Database Information Screens
Certain database informational screens are available from the Utilities tab.

Manufacturing District Inspection Office (MIDO) List




All 19 MIDO offices are listed in the database.

Total PMA Parts Count by PMA Holder




You may generate at any time a listing of the PMA holders ordered by the total number of
known approved part listings. The word “known” is emphasized here because we have
discovered that there are many PMA parts not contained in official PMA part compilations
released by the FAA. Some of these are in the PMA Parts Finder, but, we suspect,
there are many more that are not.


Back to the Table of Contents



                                                                                      20
Database Statistics




The PMA Parts Finder displays its own internal statistics through a special popup utility
window.

Database Update Log




Back to the Table of Contents



                                                                                            21
Printed Reports
The Printed Holder List Report




Back to the Table of Contents


                                 22
The Printed Parts List Report

Two printed lists are possible, both derived from the same saved parts list. The first is for
PMA parts without application data:




and the second is for PMA parts with application data:




Back to the Table of Contents

                                                                                           23
The data in this database is about 70% obtained from the FAA with the remaining
information derived directly or indirectly from industry. The FAA data contains a great
many errors and/or omissions as well as simple typographical and other errors.
Refinement of the database is a constant and continuous effort to ensure the highest
reliability possible.

If you notice something in the database that is incorrect, or if you have information not
contained in the database, please contact Aviation Data Research (ADR) as we
appreciate all input.

Disclaimer
ADR has used reasonable care in the creation of this software product and in the
preparation of the data included in it. Users should not, however, assume that the data
presented herein are accurate or complete. Only information obtained from official
government agencies should be relied upon. Therefore, the data provided in this
program should be regarded as informational and advisory only. ADR assumes no
liability for errors or omissions




Back to the Table of Contents




                                                                                            24
The Program Help Screens

Find PMA Parts




Back to the Table of Contents


                                25
PMA Holders




Back to the Table of Contents


                                26
Reports and Data Export




Back to the Table of Contents


                                27
Program and Database Updates




Back to the Table of Contents



                                28
Parts Finding Wizard




Back to the Table of Contents


                                29
Parts Matching Wizard




Back to the Table of Contents


                                30
Address Manager




Back to the Table of Contents




                                31
List Manager




Back to the Table of Contents



                                32
Label Manager




Back to the Table of Contents




                                33
                       Glossary of Terms and Acronyms

ADR – Acronym for Aviation Data Research, the manufacturer of the PMA Parts Finder
program.

ADR P/N – The manufacturer’s part identification number assigned to a part for
identification in this program. This number is often, but not always the same, as the FAA
P/N. See FAA P/N for examples.

FAA – Acronym for the Federal Aviation Administration.

FAA P/N – The part identification descriptor for a line entry in the FAA parts lists. The
FAA P/N is often the same as the PMA P/N, but may differ when multiple parts or lengthy
descriptions are used by the FAA.

Examples of differences between FAA P/N and PMA P/N:

FAA P/N – Those parts listed on Master Dwg List: IF-MD1004-001
ADR P/N – IF-MD1004-001

FAA P/N - 13251-10-10D, 13251-12-12D
ADR P/N - 13251-10-10D
ADR P/N - 13251-12-12D

FAA P/N - Dwg Parts Contained in PATS Inc. Master Drawing List (MDL) 300-5-000,
Rev. X dated 07-17-01
ADR P/N – 300-5-000

Identicality – An invented word used by the FAA to signify that a PMA part has design
approval based upon a showing that the PMA part is identical to an OEM part which it
replaces.

OEM – Acronym for Original Equipment Manufacturer used most often within this
program to refer to the company that manufactured an aircraft or engine part for which
there is a corresponding PMA substitute.

PMA - Acronym for Parts Manufacturing Approval which is an FAA approval granted to
an entity to manufacture and market parts for type certificated item installation. A PMA
manufactured part may be installed without other approvals.

PMA Holder – The name of an individual or entity that has obtained PMA approval for
one or more PMA parts. A PMA holder may not always be the manufacturer or marketer
of the PMA approved part. For example, a person may obtain a PMA approval as an
individual and then license the manufacture and/or marketing of the part to different
entities.




                                                                                         34
Query – A method of applying criteria to a database to select a set of records. Also the
criteria used to select a set of records.

STC – Acronym for Supplemental Type Certificate, a design approval for a modification
and/or installation to a type certificated item.

Term of Art – A word or phrase that has a particular meaning within the context of its
usage that may differ from a strictly grammatical or traditional interpretation of the term.

Tests and Computation – A term of art used to signify that a PMA part has design
approval based upon testing criteria substantially the same as that used for certification
of the original OEM part.

Type Certificate – A document issued by the FAA that approves an airframe, engine, or
propeller for use in civil transport.

Type Certificated Item – An airframe, engine, or propeller for which a type certificate
has been issued by the FAA.




                                                                                               35

								
To top