# StarBase

Base record for each Standard Terminal Arrival (STAR) procedure, one record per STAR

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

> Ordered by STAR_COMPUTER_CODE. The ordered-by list is also the unique record key.

## Example query

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

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 |  |  |
| `arrivalName` | `String` | Name assigned to the Standard Terminal Arrival (STAR name) |  |  |
| `amendmentNo` | `AmendmentNo` | Amendment number (spelled out) of the STAR that will be active on the effective date |  | `ONE`, `TWO`, `THREE`, … (9 values) |
| `artcc` | `StarAptArtcc` | List of all responsible ARTCCs based on airports served |  | `ZAB`, `ZAN`, `ZAU`, … (26 values) |
| `starAmendEffDate` | `String` | The first effective date for which the STAR amendment became active, in format YYYY/MM/DD |  |  |
| `rnavFlag` | `ContrFuelAvbl` | Flag indicating whether the STAR requires RNAV equipment |  | `Y`=RNAV required; `N`=RNAV not required |
| `starComputerCode` | `String` | FAA-assigned computer identifier for the STAR (e.g., GLAND.BLUMS5) |  |  |
| `servedArpt` | `String` | List of airports served by the STAR |  |  |

## Enum values

### `amendmentNo` (`AmendmentNo`)

| Code | Description |
|---|---|
| `ONE` | Amendment number one |
| `TWO` | Amendment number two |
| `THREE` | Amendment number three |
| `FOUR` | Amendment number four |
| `FIVE` | Amendment number five |
| `SIX` | Amendment number six |
| `SEVEN` | Amendment number seven |
| `EIGHT` | Amendment number eight |
| `NINE` | Amendment number nine |

### `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 |

## Relationships

| Field | Returns | Joined on |
|---|---|---|
| `starApt` | [`[StarApt]`](./StarApt.md) | `STAR_COMPUTER_CODE` |
| `starRte` | [`[StarRte]`](./StarRte.md) | `STAR_COMPUTER_CODE` |

## Column provenance

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

| GraphQL field | SQLite column |
|---|---|
| `effDate` | `EFF_DATE` |
| `arrivalName` | `ARRIVAL_NAME` |
| `amendmentNo` | `AMENDMENT_NO` |
| `artcc` | `ARTCC` |
| `starAmendEffDate` | `STAR_AMEND_EFF_DATE` |
| `rnavFlag` | `RNAV_FLAG` |
| `starComputerCode` | `STAR_COMPUTER_CODE` |
| `servedArpt` | `SERVED_ARPT` |