# AwyBase

Base airway identification and designation data, one record per airway

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

> Ordered by and unique key: AWY_ID, AWY_LOCATION. Designed to replace legacy ATS.txt and AWY.txt Subscriber Files.

## Example query

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

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 |  |  |
| `regulatory` | `ContrFuelAvbl` | Identifies Airways published under 14 CFR (Code of Federal Regulation) Part-71 and Part-95 |  | `Y`=Regulatory airway published under 14 CFR Part-71 and Part-95; `N`=Non-regulatory airway |
| `awyDesignation` | `AwyDesignation` | Airway Designation type |  | `A`, `AT`, `B`, … (11 values) |
| `awyLocation` | `AwyLocation` | Airway Type identifying the General Location of the Airway |  | `A`=ALASKA AIRWAY; `H`=HAWAII AIRWAY; `C`=U.S. CONTIGUOUS AIRWAY |
| `awyId` | `String` | Airway Identifier |  |  |
| `updateDate` | `String` | The Last Date for which the AIRWAY Data was amended |  |  |
| `remark` | `String` | Remark Text (Free Form Text that further describes a specific Information Item) |  |  |
| `airwayString` | `String` | List of FIX and NAVAID identifiers that make up the AIRWAY in the order adapted |  |  |

## Enum values

### `awyDesignation` (`AwyDesignation`)

| Code | Description |
|---|---|
| `A` | AMBER COLORED AIRWAY |
| `AT` | ATLANTIC AIRWAY |
| `B` | BLUE COLORED AIRWAY |
| `BF` | BAHAMA AIRWAY |
| `G` | GREEN COLORED AIRWAY |
| `J` | JET AIRWAY |
| `PA` | PACIFIC AIRWAY |
| `PR` | PUERTO RICO AIRWAY |
| `R` | RED COLORED AIRWAY |
| `RN` | GPS RNAV AIRWAY |
| `V` | VOR AIRWAY |

## Relationships

| Field | Returns | Joined on |
|---|---|---|
| `awySegAlt` | [`[AwySegAlt]`](./AwySegAlt.md) | `AWY_ID` |

## Column provenance

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

| GraphQL field | SQLite column |
|---|---|
| `effDate` | `EFF_DATE` |
| `regulatory` | `REGULATORY` |
| `awyDesignation` | `AWY_DESIGNATION` |
| `awyLocation` | `AWY_LOCATION` |
| `awyId` | `AWY_ID` |
| `updateDate` | `UPDATE_DATE` |
| `remark` | `REMARK` |
| `airwayString` | `AIRWAY_STRING` |