# StarApt

Associates airports and runway ends with specific STAR body segments

**Source:** NASR table `STAR_APT` · version `e25086c3e952` · effective 2026-04-16

> Ordered by STAR_COMPUTER_CODE, BODY_NAME, BODY_SEQ, ARPT_ID, RWY_END_ID. The ordered-by list is also the unique record key.

## Example query

```graphql
# Introspect the StarApt type in GraphiQL at https://api.nav.sortie.co/graphql
# Example shape (pair with a compatible root query field):
{
  # ...rootQuery... {
    effDate
    starComputerCode
    artcc
    bodyName
  # }
}
```

Run at https://api.nav.sortie.co/graphql (GraphiQL available in-browser).

## Fields

| Field | Type | Description | Units | Enum |
|---|---|---|---|---|
| `effDate` | `String` | The 28-day NASR subscription effective date in format YYYY/MM/DD |  |  |
| `starComputerCode` | `String` | FAA-assigned computer identifier for the STAR; references STAR_COMPUTER_CODE in STAR_BASE |  |  |
| `artcc` | `StarAptArtcc` | List of all responsible ARTCCs based on airports served |  | `ZAB`, `ZAN`, `ZAU`, … (26 values) |
| `bodyName` | `String` | The name of the body segment with which the airport/runway end are associated; typically the first and last fix of the segment |  |  |
| `bodySeq` | `CifpPathPointContinuationRecordNo` | Sequence number to uniquely identify a body segment in the rare case that BODY_NAME is not unique for a given STAR |  | `1`=First body segment; `2`=Second body segment |
| `arptId` | `String` | The associated airport identifier |  |  |
| `rwyEndId` | `StarAptRwyEndId` | The runway end identifier associated with the STAR body segment, if applicable |  | `01`, `01C`, `01L`, … (121 values) |

## Enum values

### `artcc` (`StarAptArtcc`)

| Code | Description |
|---|---|
| `ZAB` | Albuquerque ARTCC |
| `ZAN` | Anchorage ARTCC |
| `ZAU` | Chicago ARTCC |
| `ZBW` | Boston ARTCC |
| `ZBW ZNY` | Boston and New York ARTCCs |
| `ZDC` | Washington ARTCC |
| `ZDC ZNY` | Washington and New York ARTCCs |
| `ZDV` | Denver ARTCC |
| `ZFW` | Fort Worth ARTCC |
| `ZHN` | Honolulu ARTCC |
| `ZHU` | Houston ARTCC |
| `ZID` | Indianapolis ARTCC |
| `ZJX` | Jacksonville ARTCC |
| `ZKC` | Kansas City ARTCC |
| `ZLA` | Los Angeles ARTCC |
| `ZLC` | Salt Lake City ARTCC |
| `ZMA` | Miami ARTCC |
| `ZME` | Memphis ARTCC |
| `ZMP` | Minneapolis ARTCC |
| `ZNY` | New York ARTCC |
| `ZOA` | Oakland ARTCC |
| `ZOB` | Cleveland ARTCC |
| `ZSE` | Seattle ARTCC |
| `ZSU` | San Juan ARTCC |
| `ZTL` | Atlanta ARTCC |
| `ZVR` | Vancouver (Canadian) ARTCC |

### `rwyEndId` (`StarAptRwyEndId`)

| Code | Description |
|---|---|
| `01` | Runway 01 |
| `01C` | Runway 01 Center |
| `01L` | Runway 01 Left |
| `01R` | Runway 01 Right |
| `02` | Runway 02 |
| `02C` | Runway 02 Center |
| `02L` | Runway 02 Left |
| `02R` | Runway 02 Right |
| `03` | Runway 03 |
| `03L` | Runway 03 Left |
| `03R` | Runway 03 Right |
| `04` | Runway 04 |
| `04L` | Runway 04 Left |
| `04R` | Runway 04 Right |
| `05` | Runway 05 |
| `05L` | Runway 05 Left |
| `05R` | Runway 05 Right |
| `06` | Runway 06 |
| `06L` | Runway 06 Left |
| `06R` | Runway 06 Right |
| `07` | Runway 07 |
| `07L` | Runway 07 Left |
| `07R` | Runway 07 Right |
| `08` | Runway 08 |
| `08L` | Runway 08 Left |
| `08R` | Runway 08 Right |
| `09` | Runway 09 |
| `09C` | Runway 09 Center |
| `09L` | Runway 09 Left |
| `09R` | Runway 09 Right |
| `10` | Runway 10 |
| `10C` | Runway 10 Center |
| `10L` | Runway 10 Left |
| `10R` | Runway 10 Right |
| `11` | Runway 11 |
| `11L` | Runway 11 Left |
| `12` | Runway 12 |
| `12L` | Runway 12 Left |
| `12R` | Runway 12 Right |
| `13` | Runway 13 |
| `13L` | Runway 13 Left |
| `13R` | Runway 13 Right |
| `14` | Runway 14 |
| `14L` | Runway 14 Left |
| `14R` | Runway 14 Right |
| `15` | Runway 15 |
| `15L` | Runway 15 Left |
| `15R` | Runway 15 Right |
| `16` | Runway 16 |
| `16C` | Runway 16 Center |
| `16L` | Runway 16 Left |
| `16R` | Runway 16 Right |
| `17` | Runway 17 |
| `17C` | Runway 17 Center |
| `17L` | Runway 17 Left |
| `17R` | Runway 17 Right |
| `18` | Runway 18 |
| `18C` | Runway 18 Center |
| `18L` | Runway 18 Left |
| `18R` | Runway 18 Right |
| `19` | Runway 19 |
| `19C` | Runway 19 Center |
| `19L` | Runway 19 Left |
| `19R` | Runway 19 Right |
| `20` | Runway 20 |
| `20C` | Runway 20 Center |
| `20L` | Runway 20 Left |
| `20R` | Runway 20 Right |
| `21` | Runway 21 |
| `21L` | Runway 21 Left |
| `21R` | Runway 21 Right |
| `22` | Runway 22 |
| `22L` | Runway 22 Left |
| `22R` | Runway 22 Right |
| `23` | Runway 23 |
| `23L` | Runway 23 Left |
| `23R` | Runway 23 Right |
| `24` | Runway 24 |
| `24L` | Runway 24 Left |
| `24R` | Runway 24 Right |
| `25` | Runway 25 |
| `25L` | Runway 25 Left |
| `25R` | Runway 25 Right |
| `26` | Runway 26 |
| `26L` | Runway 26 Left |
| `26R` | Runway 26 Right |
| `27` | Runway 27 |
| `27C` | Runway 27 Center |
| `27L` | Runway 27 Left |
| `27R` | Runway 27 Right |
| `28` | Runway 28 |
| `28C` | Runway 28 Center |
| `28L` | Runway 28 Left |
| `28R` | Runway 28 Right |
| `29` | Runway 29 |
| `29R` | Runway 29 Right |
| `30` | Runway 30 |
| `30L` | Runway 30 Left |
| `30R` | Runway 30 Right |
| `31` | Runway 31 |
| `31L` | Runway 31 Left |
| `31R` | Runway 31 Right |
| `32` | Runway 32 |
| `32L` | Runway 32 Left |
| `32R` | Runway 32 Right |
| `33` | Runway 33 |
| `33L` | Runway 33 Left |
| `33R` | Runway 33 Right |
| `34` | Runway 34 |
| `34C` | Runway 34 Center |
| `34L` | Runway 34 Left |
| `34R` | Runway 34 Right |
| `35` | Runway 35 |
| `35C` | Runway 35 Center |
| `35L` | Runway 35 Left |
| `35R` | Runway 35 Right |
| `36` | Runway 36 |
| `36C` | Runway 36 Center |
| `36L` | Runway 36 Left |
| `36R` | Runway 36 Right |
| `ALL` | All runway ends |

## Column provenance

Every field maps 1:1 to a column in the `STAR_APT` table of `nasr.db`. Original FAA column names:

| GraphQL field | SQLite column |
|---|---|
| `effDate` | `EFF_DATE` |
| `starComputerCode` | `STAR_COMPUTER_CODE` |
| `artcc` | `ARTCC` |
| `bodyName` | `BODY_NAME` |
| `bodySeq` | `BODY_SEQ` |
| `arptId` | `ARPT_ID` |
| `rwyEndId` | `RWY_END_ID` |