
                    STANDARD TERMINAL ARRIVAL FILE
                  STANDARD DEPARTURE PROCEDURE FILE
                          COMPLETE LISTING
                              (STAR/DP)
                        DATA BASE RECORD LAYOUT

INFORMATION EFFECTIVE DATE: 12/20/2007  
RECORD FORMAT: FIXED  
LOGICAL RECORD LENGTH: 221  

  GENERAL INFORMATION:  
  ===================  
  
    THIS FILE CONTAINS BOTH STANDARD TERMINAL ARRIVAL (STAR) AND
    STANDARD DEPARTURE PROCEDURE (DP) DATA. ALL STARS ARE  
    PRESENTED FIRST, FOLLOWED BY DP DATA. USERS MUST DETECT A  
    CHANGE IN THE FIRST CHARACTER OF A RECORD FROM 'S' TO 'D'  
    TO KNOW WHEN TO BEGIN DP RECORD FORMAT PROCESSING.  

    THIS FILE IS DIFFERENT FROM THE SSD SUBSCRIBER FILE IN THAT 
    IT CONTAINS A COMPLETE COMPREHENSIVE SET OF STAR AND DP 
    PROCEDURES, INCLUDING MULTIPLE MAIN BODY AND PROCEDURES WITHOUT
    COMPUTER IDS.
  
  
-----------------------------------------------------------------  
                     STANDARD TERMINAL ARRIVAL FILE  
                     ==============================  

FILE STRUCTURE DESCRIPTION:  
---------------------------  
  
    THERE ARE A VARIABLE NUMBER OF FIXED-LENGTH RECORDS FOR EACH  
    STANDARD TERMINAL ARRIVAL (STAR). EACH GROUP OF RECORDS FOR  
    A STAR IS ASSIGNED A 5 CHARACTER INTERNAL SEQUENCE NUMBER.  
    A STAR RECORD GROUP BEGINS WITH A POINT-TO-POINT DESCRIPTION  
    OF THE BASIC STAR BODIES FOLLOWED BY INDIVIDUAL RECORDS FOR EACH  
    AIRPORT ADAPTED FOR USE OF THE STAR. ADAPTED AIRPORTS ARE  
    FOLLOWED BY GROUPS OF RECORDS REPRESENTING  
    A POINT-TO-POINT DESCRIPTION OF EACH TRANSITION FROM THE  
    ENROUTE AIRSPACE SYSTEM TO THE BASIC STAR.    
  
    THE FILE IS SORTED BY STAR NAME. THIS FILE INCLUDES STARS THAT
    DO NOT HAVE AN ASSIGNED COMPUTER CODE. MULTIPLE MAIN BODY STARS 
    ARE INCLUDED IN THE FILE.  

    THE SEQUENCE OF RECORDS TO DESCRIBE A STAR ARE SUMMARIZED  
    AS FOLLOWS:  
  
      - FIRST RECORD OF THE BASIC STAR: IDENTIFIED BY A CHANGE  
        IN THE INTERNAL SEQUENCE NUMBER (E.G. S0010). IF THE ARRIVAL  
        IS DIRECT FROM THE ENROUTE AIRSPACE SYSTEM TO THE  
        TRANSITION FIX/NAVAID, THE FIRST RECORD SHALL CONTAIN THE  
        INITIAL FIX/NAVAID ON A PATH FROM THE ENROUTE SYSTEM TO  
        THE TRANSITION FIX/NAVAID.  OTHERWISE, (I.E. THERE ARE  
        MULTIPLE PATHS FROM THE ENROUTE SYSTEM TO THE TRANSITION  
        FIX/NAVAID), THE FIRST RECORD SHALL CONTAIN THE TRANSITION  
        FIX/NAVAID IDENTIFIER AND ITS POSITIONAL INFORMATION.  IN  
        EITHER CASE, THE FIRST RECORD WILL CONTAIN THE COMPUTER CODE  
        AND NAME OF THE BASIC STAR.  
  
      - THE FIRST RECORD OF THE BASIC STAR IS FOLLOWED BY A  
        VARIABLE NUMBER OF RECORDS THAT DESCRIBE A PATH,  
        IN POINT-TO-POINT ORDER, FROM THE ENROUTE AIRSPACE SYSTEM  
        TO THE TRANSITION FIX/NAVAID. FOR STARS WITH A SINGLE  
        TRANSITION PATH, THE FINAL RECORD OF THE BASIC STAR  
        WILL CONTAIN THE TRANSITION FIX/NAVAID IDENTIFIER.  

      - FOLLOWING THE DESCRIPTION OF THE BASIC STAR ARE  
        ONE OR MORE RECORDS DESCRIBING ALL AIRPORTS USING  
        THIS STAR. THE FIX/FACILITY TYPE CODE FIELD WILL CONTAIN  
        AN 'AA'.  

      - FOR STARS WITH MULTIPLE MAIN BODIES, THE ABOVE SEQUENCE
        WILL BE REPEATED FOR EACH BODY. I.E., THE FIRST RECORD OF THE
        STAR (CONTAINING THE STAR COMPUTER CODE AND STAR NAME) WILL 
        BE FOLLOWED BY A VARIABLE NUMBER OF RECORDS THAT 
        DESCRIBE A PATH IN POINT-TO-POINT ORDER. FOLLOWING THE 
        DESCRIPTION OF EACH BASIC STAR BODY ARE ONE OR MORE 
        RECORDS DESCRIBING ALL AIRPORTS USING THIS STAR. THE 
        FIX/FACILITY TYPE CODE FIELD WILL CONTAIN AN 'AA'. 
  
      - NEXT ARE RECORD GROUPS DESCRIBING ANY TRANSITIONS FROM  
        THE ENROUTE AIRSPACE SYSTEM TO THE TRANSITION FIX/NAVAID.  
        THE RECORD GROUP BEGINS WITH A RECORD FOR THE TRANSITION  
        FIX/NAVAID THAT WILL INCLUDE THE COMPUTER CODE AND  
        NAME OF THE TRANSITION.  
  
      - SUBSEQUENT RECORDS WITHIN A GROUP FOR A TRANSITION PROVIDE  
        A POINT-TO-POINT DESCRIPTION FROM THE ENROUTE AIRSPACE  
        SYSTEM TO THE TRANSITION FIX/NAVAID.  
  
      - THERE MAY BE MULTIPLE TRANSITION GROUPS FOR A STAR. THEY  
        WILL MAINTAIN THE SAME INTERNAL SEQUENCE NUMBER. PRESENCE  
        OF DATA IN THE COMPUTER CODE FIELD SIGNALS THE BEGINNING OF  
        A TRANSITION RECORD GROUP.  
  
      - DESCRIPTION OF A STAR IS COMPLETE WHEN A RECORD IS READ  
        THAT CONTAINS A DIFFERENT INTERNAL SEQUENCE NUMBER (I.E.  
        THE FIRST RECORD OF THE NEXT STAR).  

  
GENERAL INFORMATION:  
--------------------  
   
     1.  LEFT JUSTIFIED FIELDS HAVE TRAILING BLANKS  
     2.  RIGHT JUSTIFIED FIELDS HAVE LEADING BLANKS  
  
*********************************************************************  
  
            STANDARD TERMINAL ARRIVAL (STAR) DATA  
  
********************************************************************  
  
J  T   L   S L   E N  
U  Y   E   T O   L U  
S  P   N   A C   E M  
T  E   G   R A   M B  
       T   T T   E E  
       H     I   N R  
             O   T  
             N           FIELD DESCRIPTION  

L AN 0005 00001          INTERNAL SEQUENCE NUMBER  
                           A RANDOMLY ASSIGNED SEQUENCE NUMBER  
                           USED TO GROUP A SET OF RECORDS FOR A  
                           SPECIFIC STAR. THIS IS SUBJECT TO CHANGE.  
                             EX. S0010, S2070  
  
L AN 0005 00006          NOT USED  
  
L AN 0002 00011          FIX/FACILITY TYPE CODE  
                           THIS CODE REPRESENTS THE TYPE OF FIX OR  
                           FACILITY DESCRIBED IN THE LATITUDE,  
                           LONGITUDE, AND IDENTIFIER FIELDS OF  
                           THIS RECORD.  
  
                          CODE     DESCRIPTION  
                          ----     -----------  
                           AA      ADAPTED AIRPORT  
                           B       BREAK IN ROUTE  
                           C       COORDINATED FIX  
                           CN      COMPUTER NAVIGATION FIX
                           D       DISTANCE MEASURING EQUIPMENT (DME)  
                           E       ENTRY (ARTCC)  
                           I       BEARING INTERSECTION  
                           IB      AIR ROUTES BEARING INTERSECTION  
                           IS      SEGMENT BEARING INTERSECTION  
                           NA      NAVAID - AIRPORT  
                           ND      NAVAID - VOR WITH DME  
                           NV      NAVAID - VOR  
                           NW      NAVAID - VORTAC  
                           NX      NAVAID - RBN  
                           NT      NAVAID - TACAN  
                           NZ      NAVAID - ILS  
                           N7      NAVAID - LFR  
                           N8      NAVAID - VHFRBN  
                           N9      NAVAID - VHFRBN  
                           P       WAYPOINT  
                           R       REPORTING POINT   
                           SS      START STARS DEPARTING  
                           ST      START STARS TRANSITION  
                           T       TURNING POINT  
                           TA      TURNING POINT  
                           TP      TURNING POINT  
                           TT      TRAINING POINT  
                           U       ARTCC BOUNDARY POINT  
                           XA      AIRWAY CROSSING  
                           XT      TRANSITION CROSSING  
                           Z       ARTCC BOUNDARY CROSSING  
  
L AN 0001 00013          NOT USED  
  
L AN 0008 00014          FIX/NAVAID/AIRPORT LATITUDE  
                           FORMAT: XDDMMSST  
                           WHERE X IS THE DECLINATION (N OR S)  
                                 DD - DEGREES  
                                 MM - MINUTES  
                                 SS - SECONDS  
                                 T  - TENTHS OF SECONDS  
                                      (DECIMAL POINT IS IMPLIED)  
                           EX. N3353229  
  
L AN 0009 00022          FIX/NAVAID/AIRPORT LONGITUDE  
                           FORMAT: XDDDMMSST  
                           WHERE X IS THE DECLINATION (E OR W)  
                                DDD - DEGREES  
                                 MM - MINUTES  
                                 SS - SECONDS  
                                 T  - TENTHS OF SECONDS  
                                      (DECIMAL POINT IS IMPLIED)  
                           EX. W11651012  
  
L AN 0006 00031          FIX/NAVAID/AIRPORT IDENTIFIER  
                           THIS FIELD PROVIDES THE IDENTIFIER OF THE  
                           ADAPTED AIRPORT, FIX, OR NAVAID  
                           (FOR BASIC STAR AND TRANSITION  
                           POINT-TO-POINT DATA). THIS FIELD RELATES  
                           TO THE FIX TYPE CODE AND LATITUDE AND  
                           LONGITUDE VALUES PROVIDED EARLIER IN  
                           THE RECORD.  
                           EX. PSP  GARNE  21525  
  
L AN 0013 00037          STAR COMPUTER CODE  
                           FAA-ASSIGNED COMPUTER IDENTIFIER FOR THE  
                           STAR/TRANSITION. DATA WILL BE PRESENT IN 
                           THE FIRST RECORD OF EACH BASIC STAR BODY
                           AND THE FIRST RECORD OF EACH TRANSITION.  
                             EX. GLAND.BLUMS5 (BASIC STAR)  
                                 AUS.BLUMS5   (TRANSITION)  
                                 ELA.BLUMS5   (TRANSITION)  
                                 SAT.BLUMS5   (TRANSITION)  
  
                           STARS WITHOUT AN ASSIGNED COMPUTER CODE 
                           ARE INDICATED WITH THE TEXT "NOT ASSIGNED"

L AN 0110 00050          STAR/TRANSITION NAME  
                           REPRESENTS THE NAME ASSIGNED TO THE  
                           STAR OR TRANSITION BEING DESCRIBED.  
                           DATA WILL BE PRESENT IN THE FIRST  
                           RECORD OF EACH BASIC STAR BODY AND THE 
                           FIRST RECORD OF EACH TRANSITION.  
                             EX. BLUMS FIVE       (BASIC STAR)  
                                 AUSTIN           (TRANSITION)  
                                 EAGLE LAKE       (TRANSITION)  
                                 SAN ANTONIO      (TRANSITION)  
  
L AN 0062 00160          AIRWAYS/NAVAIDS USING NUMBERED FIX  
                           FOR SOME NUMBERED FIXES, THIS FIELD WILL  
                           CONTAIN IDENTIFIERS OF NAVAIDS OR 
                           JET/VICTOR AIRWAYS THAT USE THE NUMBERED 
                           FIX. THERE MAY BE MULTIPLE AIRWAYS OR 
                           NAVAIDS ENTERED.  
                             EX.: J27  
                                  V407 V070  
                                  GMN PMD  
   
                   STANDARD INSTRUMENT DEPARTURE PROCEDURE FILE  
                   ============================================  

FILE STRUCTURE DESCRIPTION:  
---------------------------  
  
    THERE ARE A VARIABLE NUMBER OF FIXED-LENGTH RECORDS FOR EACH  
    STANDARD INSTRUMENT DEPARTURE PROCEDURE (DP). EACH GROUP OF 
    RECORDS FOR A DP IS ASSIGNED A 5 CHARACTER INTERNAL SEQUENCE 
    NUMBER. A DP RECORD GROUP BEGINS WITH A POINT-TO-POINT 
    DESCRIPTION OF THE BASIC DP FOLLOWED BY INDIVIDUAL RECORDS FOR 
    EACH AIRPORT ADAPTED FOR USE OF THE DP. ADAPTED AIRPORTS ARE  
    FOLLOWED BY GROUPS OF RECORDS REPRESENTING  
    A POINT-TO-POINT DESCRIPTION OF EACH TRANSITION  
    FROM THE BASIC DP TO THE ENROUTE AIRSPACE SYSTEM.  

    THE FILE IS SORTED BY DP NAME THEN TRANSITION NAMES  
    WITHIN THE DP RECORD GROUP. THIS FILE INCLUDES DPS THAT DO NOT
    HAVE AN ASSIGNED COMPUTER CODE. MULTIPLE MAIN  
    BODY DPS ARE INCLUDED IN THE FILE.  

    THE SEQUENCE OF RECORDS TO DESCRIBE A DP ARE SUMMARIZED  
    AS FOLLOWS:  
  
      - FIRST RECORD OF THE BASIC DP: IDENTIFIED BY A CHANGE  
        IN THE INTERNAL SEQUENCE NUMBER (E.G. D0040). IF THE  
        DEPARTURE IS DIRECTLY TO THE TRANSITION FIX, THE FIX/NAVAID  
        IDENTIFIER FIELD WILL BE THE TRANSITION FIX; OTHERWISE,  
        THE FIX/NAVAID WILL BE THE FIRST POINT ON A PATH TO  
        THE TRANSITION FIX/NAVAID.  THIS RECORD WILL CONTAIN  
        THE COMPUTER CODE AND NAME OF THE BASIC DP.  
  
      - IF THE DEPARTURE IS NOT DIRECTLY TO THE TRANSITION FIX,  
        THERE WILL BE A VARIABLE NUMBER OF RECORDS THAT DESCRIBE  
        A PATH, IN POINT-TO-POINT ORDER, FROM THE DEPARTURE  
        FACILITY TO THE TRANSITION FIX. THE FINAL RECORD IN THIS  
        GROUP WILL BE THE TRANSITION FIX.  
  
      - FOLLOWING THE DESCRIPTION OF THE BASIC DP ARE  
        ONE OR MORE RECORDS DESCRIBING ALL AIRPORTS USING  
        THIS DP. THE FIX/FACILITY TYPE CODE FIELD WILL  
        CONTAIN AN 'AA'.  
  
      - IF THERE ARE MULTIPLE MAIN BODIES TO THE BASIC DP, EACH 
        PATH WILL BE DESCRIBED FOLLOWING THE ABOVE AIRPORTS RECORDS. 
        EACH PATH WILL CONTAIN A VARIABLE NUMBER OR RECORDS, IN 
        POINT TO POINT ORDER, FROM THE DEPARTURE FACILITY TO THE 
        TRANSITION FIX. THE FINAL RECORD IN EACH PATH WILL BE THE 
        TRANSITION FIX. 

      - NEXT ARE RECORD GROUPS DESCRIBING ANY TRANSITIONS FROM  
        THE TRANSITION FIX TO THE ENROUTE AIRSPACE SYSTEM.  
        THE RECORD GROUP BEGINS WITH A RECORD FOR THE TRANSITION  
        FIX THAT WILL INCLUDE THE COMPUTER CODE AND NAME OF THE  
        TRANSITION.  
  
      - SUBSEQUENT RECORDS WITHIN A GROUP FOR A TRANSITION PROVIDE  
        A POINT TO POINT DESCRIPTION FROM THE TRANSITION FIX  
        TO THE ENROUTE AIRSPACE SYSTEM.  
  
      - THERE MAY BE MULTIPLE TRANSITION GROUPS FOR A DP. THEY  
        WILL MAINTAIN THE SAME INTERNAL SEQUENCE NUMBER. PRESENCE  
        OF DATA IN THE COMPUTER CODE FIELD SIGNALS THE BEGINNING OF  
        A TRANSITION RECORD GROUP.  
  
      - DESCRIPTION OF A DP IS COMPLETE WHEN A RECORD IS READ  
        THAT CONTAINS A DIFFERENT INTERNAL SEQUENCE NUMBER (I.E.  
        THE FIRST RECORD OF THE NEXT DP).  

GENERAL INFORMATION:  
--------------------  
     1.  LEFT JUSTIFIED FIELDS HAVE TRAILING BLANKS  
     2.  RIGHT JUSTIFIED FIELDS HAVE LEADING BLANKS  

*********************************************************************  
  
            STANDARD INSTRUMENT DEPARTURE PROCEDURE (DP) DATA  
********************************************************************  
  
J  T   L   S L   E N  
U  Y   E   T O   L U  
S  P   N   A C   E M  
T  E   G   R A   M B  
       T   T T   E E  
       H     I   N R  
             O   T  
             N           FIELD DESCRIPTION  
  
L AN 0005 00001          INTERNAL SEQUENCE NUMBER  
                           A RANDOMLY ASSIGNED SEQUENCE NUMBER  
                           USED TO GROUP A SET OF RECORDS FOR A  
                           SPECIFIC DP. THIS IS SUBJECT TO CHANGE.  
                             EX. D0430, D2320    
L AN 0005 00006          NOT USED    
L AN 0002 00011          FIX/FACILITY TYPE CODE  
                           THIS CODE REPRESENTS THE TYPE OF FIX OR  
                           FACILITY DESCRIBED IN THE LATITUDE,  
                           LONGITUDE, AND IDENTIFIER FIELDS OF  
                           THIS RECORD.  
  
                          CODE     DESCRIPTION  
                          ----     -----------  
                           AA      ADAPTED AIRPORT  
                           B       BREAK IN ROUTE  
                           C       COORDINATED FIX  
                           CN      COMPUTER NAVIGATION FIX
                           D       DISTANCE MEASURING EQUIPMENT (DME)  
                           E       ENTRY (ARTCC)  
                           I       BEARING INTERSECTION  
                           IB      AIR ROUTES BEARING INTERSECTION  
                           IS      SEGMENT BEARING INTERSECTION  
                           NA      NAVAID - AIRPORT  
                           ND      NAVAID - VOR WITH DME  
                           NV      NAVAID - VOR  
                           NW      NAVAID - VORTAC  
                           NX      NAVAID - RBN  
                           NT      NAVAID - TACAN  
                           NZ      NAVAID - ILS  
                           N7      NAVAID - LFR  
                           N8      NAVAID - VHFRBN  
                           N9      NAVAID - VHFRBN  
                           P       WAYPOINT  
                           R       REPORTING POINT  
                           SS      START DPS DEPARTING  
                           ST      START DPS TRANSITION  
                           T       TURNING POINT  
                           TA      TURNING POINT  
                           TP      TURNING POINT  
                           TT      TRAINING POINT  
                           U       ARTCC BOUNDARY POINT  
                           XA      AIRWAY CROSSING  
                           XT      TRANSITION CROSSING  
                           Z       ARTCC BOUNDARY CROSSING  
  

L AN 0001 00013          NOT USED  

L AN 0008 00014          FIX/NAVAID/AIRPORT LATITUDE  
                           FORMAT: XDDMMSST  
                           WHERE X IS THE DECLINATION (N OR S)  
                                 DD - DEGREES  
                                 MM - MINUTES  
                                 SS - SECONDS  
                                 T  - TENTHS OF SECONDS  
                                      (DECIMAL POINT IS IMPLIED)  
                           EX. N3353229  
  
L AN 0009 00022          FIX/NAVAID/AIRPORT LONGITUDE  
                           FORMAT: XDDDMMSST  
                           WHERE X IS THE DECLINATION (E OR W)  
                                DDD - DEGREES  
                                 MM - MINUTES  
                                 SS - SECONDS  
                                 T  - TENTHS OF SECONDS  
                                      (DECIMAL POINT IS IMPLIED)  
                           EX. W11651012  
  
L AN 0006 00031          FIX/NAVAID/AIRPORT IDENTIFIER  
                           THIS FIELD PROVIDES THE IDENTIFIER OF THE  
                           ADAPTED AIRPORT, FIX, OR NAVAID  
                           (FOR BASIC DP AND TRANSITION  
                           POINT-TO-POINT DATA). THIS FIELD RELATES  
                           TO THE FIX TYPE CODE AND LATITUDE AND  
                           LONGITUDE VALUES PROVIDED EARLIER IN  
                           THE RECORD.  
                           EX. PSP  GARNE  21525  

L AN 0013 00037          DP COMPUTER CODE  
                           FAA-ASSIGNED COMPUTER IDENTIFIER FOR THE  
                           DP/TRANSITION. DATA WILL ONLY BE PRESENT  
                           IN THE FIRST RECORD OF THE BASIC DP AND  
                           THE FIRST RECORD OF EACH TRANSITION.  
                             EX. CATH4.PSP (BASIC DP)  
                                 CATH4.PDZ (TRANSITION)  
                                 CATH4.BLH (TRANSITION)  
                                 CATH4.TNP (TRANSITION)  
  
                           DPS WITHOUT AN ASSIGNED COMPUTER CODE 
                           ARE INDICATED WITH THE TEXT "NOT ASSIGNED"
  
L AN 0110 00050          DP/TRANSITION/BODY NAME  
                           REPRESENTS THE NAME ASSIGNED TO THE  
                           DP, TRANSITION, OR BODY BEING DESCRIBED.  
                           DATA WILL ONLY BE PRESENT IN THE FIRST  
                           RECORD OF THE BASIC DP, THE FIRST RECORD
                           OF EACH BASIC BODY, AND THE FIRST  
                           RECORD OF EACH TRANSITION.  
                             EX. CATHEDRAL FOUR   (BASIC DP)  
                                 PARADISE         (TRANSITION)  
                                 BLYTHE           (TRANSITION)  
                                 TWENTYNINE PALMS (TRANSITION)  
  
L AN 0062 00160          AIRWAYS/NAVAIDS USING NUMBERED FIX  
                           FOR SOME NUMBERED FIXES, THIS FIELD WILL  
                           CONTAIN IDENTIFIERS OF NAVAIDS OR 
                           JET/VICTOR AIRWAYS THAT USE THE NUMBERED 
                           FIX. THERE MAY BE MULTIPLE AIRWAYS OR 
                           NAVAIDS ENTERED.  
                             EX.: J014  
                                  V407 V070  
                                  GMN PMD 
