...
QUICK SEARCH - this is rarely used. You need The User needs to know the ID number
...
2. ADVANCED SEARCH - more commonly used
...
DATA ELEMENT | FIELD NAME | TABLE(s) | DESCRIPTION |
SIG_number | SIG_NUMBER | Y57_SIG | Sequential number allocated to each new SIG entry |
SIG_Type | SIG_TYPE_CD | Y57_SIG , TR40_SIG_TYPE | 1 CAA - Civil Aviation Authorities (ICAO members) |
Name | Y56.NAME_COMMON_NM , Y57.PARTY_SIG_ID | Y57_SIG, Y56_ORGANIZATION | Company/Organization name |
Address | Y57.PARTY_SIG_ID, Y90.ADDRESS_ID, A90.ADDRESS_LINE1_TXT | Y90_PARTY_CONTACT, A90_ADDRESS | addressing info |
Address 2 | Y57.PARTY_SIG_ID, Y90.ADDRESS_ID, A90.ADDRESS_LINE2_TXT | Y90_PARTY_CONTACT, A90_ADDRESS | addressing info |
City/Town | Y57.PARTY_SIG_ID, Y90.ADDRESS_ID, A90.CITY_TXT | Y90_PARTY_CONTACT, A90_ADDRESS | addressing info |
Country | Y57.PARTY_SIG_ID, Y90.ADDRESS_ID, A90.COUNTRY_CD , TR21_COUNTRY | Y90_PARTY_CONTACT, A90_ADDRESS | country code |
Postal Code | Y57.PARTY_SIG_ID, Y90.ADDRESS_ID, A90.POSTAL_CODE_ID | Y90_PARTY_CONTACT, A90_ADDRESS | Postal code required for Canadian Addresses. Zip code required for American addresses. Optional for other countries |
Province/State | Y57.PARTY_SIG_ID, Y90.ADDRESS_ID, A90.PROVINCE_CD, TR01_PROVINCE | Y90_PARTY_CONTACT, A90_ADDRESS | Provinces for Canada. States for America. Not defined for other countries |
Mail Property | MAILING_PROPERTY_CD | Y57_SIG | values 1-MAIL - will receive notification of all documents pertaining to models associated with this entity, whenever SIGS is included as part of the mailing query |
AFTN No | AFTN_TXT | Y57_SIG | https://en.wikipedia.org/wiki/Aeronautical_Fixed_Telecommunication_Network Historical AFTN data - this transmission method has not been used since the early 1990’s |
Notes | NOTES_TXT | Y57_SIG | Notes/Emails from from each SIGS entry. Mostly pertains to physical address changes and email-addresses |
Phone Number(s) | Y57.PARTY_SIG_ID, Y90.ADDRESS_ID, A92.ADDRESS_PROPERTY_TXT | Y90_PARTY_CONTACT, A92_ADDRESS_PROPERTY | |
FAX Number(s) | Y57.PARTY_SIG_ID, Y90.ADDRESS_ID, A92.ADDRESS_PROPERTY_TXT | Y90_PARTY_CONTACT, A92_ADDRESS_PROPERTY | |
Y57.PARTY_SIG_ID, Y90.ADDRESS_ID, A92.ADDRESS_PROPERTY_TXT | Y90_PARTY_CONTACT, A92_ADDRESS_PROPERTY | ||
Product Type | PRODUCT_CD | Y63_SIG_PRODUCT_MAKE_MODEL | |
Manufacturer | Y63.MANUFACTURER_ID, Y60.PARTY_ID, Y56.NAME_COMMON_NM | Y63_SIG_PRODUCT_MAKE_MODEL | |
Model | MODEL_ID | Y63_SIG_PRODUCT_MAKE_MODEL |