# FixNav

NAVAID reference table associating fixes with the NAVAIDs used to define them, including bearing and distance information

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

> Ordered by FIX_ID, ICAO_REGION_CODE, NAV_ID, NAV_TYPE. This ordering also serves as the unique record key. Replaces legacy FIX.txt Subscriber File.

## Example query

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

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 |  |  |
| `fixId` | `String` | Fixed Geographical Position Identifier. References FIX_ID in FIX_BASE. |  |  |
| `icaoRegionCode` | `FixNavIcaoRegionCode` | International Civil Aviation Organization (ICAO) Code. In general, the first letter refers to the country, the second letter discerns the region within the country. References ICAO_REGION_CODE in FIX_BASE. |  | `CY`, `K`, `K1`, … (19 values) |
| `stateCode` | `FixNavStateCode` | Associated State Post Office Code - standard two letter abbreviation for US States and Territories |  | `AK`, `AL`, `AR`, … (60 values) |
| `countryCode` | `FixNavCountryCode` | Country Post Office Code identifying the country associated with the fix |  | `AS`, `BS`, `CA`, … (11 values) |
| `navId` | `String` | NAVAID Identifier - the identifier of the navigation aid used to define the fix position |  |  |
| `navType` | `FixNavNavType` | NAVAID Facility Type indicating the type of navigation aid used to define the fix |  | `DME`, `LOC`, `MM`, … (10 values) |
| `bearing` | `Float` | Bearing, Radial, Direction or Course from the NAVAID to the fix, depending on the facility type | degrees |  |
| `distance` | `Float` | DME distance from the NAVAID facility to the fix | nautical miles |  |

## Enum values

### `icaoRegionCode` (`FixNavIcaoRegionCode`)

| Code | Description |
|---|---|
| `CY` | Canada |
| `K` | Contiguous United States |
| `K1` | Contiguous United States Region 1 |
| `K2` | Contiguous United States Region 2 |
| `K3` | Contiguous United States Region 3 |
| `K4` | Contiguous United States Region 4 |
| `K5` | Contiguous United States Region 5 |
| `K6` | Contiguous United States Region 6 |
| `K7` | Contiguous United States Region 7 |
| `MD` | Maryland/Mid-Atlantic |
| `MM` | Mexico |
| `MY` | Bahamas |
| `NZ` | New Zealand |
| `P` | North Pacific |
| `PA` | Alaska |
| `PG` | Guam/Mariana Islands |
| `PH` | Hawaii |
| `TI` | US Virgin Islands |
| `TJ` | Puerto Rico |

### `stateCode` (`FixNavStateCode`)

| Code | Description |
|---|---|
| `AK` | Alaska |
| `AL` | Alabama |
| `AR` | Arkansas |
| `AS` | American Samoa |
| `AZ` | Arizona |
| `CA` | California |
| `CO` | Colorado |
| `CT` | Connecticut |
| `DC` | District of Columbia |
| `DE` | Delaware |
| `FL` | Florida |
| `GA` | Georgia |
| `GU` | Guam |
| `HI` | Hawaii |
| `IA` | Iowa |
| `ID` | Idaho |
| `IL` | Illinois |
| `IN` | Indiana |
| `KS` | Kansas |
| `KY` | Kentucky |
| `LA` | Louisiana |
| `MA` | Massachusetts |
| `MD` | Maryland |
| `ME` | Maine |
| `MI` | Michigan |
| `MN` | Minnesota |
| `MO` | Missouri |
| `MP` | Northern Mariana Islands |
| `MS` | Mississippi |
| `MT` | Montana |
| `NC` | North Carolina |
| `ND` | North Dakota |
| `NE` | Nebraska |
| `NH` | New Hampshire |
| `NJ` | New Jersey |
| `NM` | New Mexico |
| `NV` | Nevada |
| `NY` | New York |
| `OA` | Pacific Ocean Area |
| `OG` | Gulf of Mexico Area |
| `OH` | Ohio |
| `OK` | Oklahoma |
| `OP` | Pacific Ocean |
| `OR` | Oregon |
| `PA` | Pennsylvania |
| `PR` | Puerto Rico |
| `QW` | Atlantic Ocean |
| `RI` | Rhode Island |
| `SC` | South Carolina |
| `SD` | South Dakota |
| `TN` | Tennessee |
| `TX` | Texas |
| `UT` | Utah |
| `VA` | Virginia |
| `VI` | US Virgin Islands |
| `VT` | Vermont |
| `WA` | Washington |
| `WI` | Wisconsin |
| `WV` | West Virginia |
| `WY` | Wyoming |

### `countryCode` (`FixNavCountryCode`)

| Code | Description |
|---|---|
| `AS` | American Samoa |
| `BS` | Bahamas |
| `CA` | Canada |
| `DO` | Dominican Republic |
| `FM` | Federated States of Micronesia |
| `IB` | International/High Seas |
| `MH` | Marshall Islands |
| `MX` | Mexico |
| `PW` | Palau |
| `TC` | Turks and Caicos Islands |
| `US` | United States |

### `navType` (`FixNavNavType`)

| Code | Description |
|---|---|
| `DME` | Distance Measuring Equipment |
| `LOC` | Localizer |
| `MM` | Middle Marker |
| `NDB` | Non-Directional Beacon |
| `NDB/DME` | Non-Directional Beacon with Distance Measuring Equipment |
| `OM` | Outer Marker |
| `TACAN` | Tactical Air Navigation |
| `VOR` | VHF Omnidirectional Range |
| `VOR/DME` | VHF Omnidirectional Range with Distance Measuring Equipment |
| `VORTAC` | VOR and TACAN collocated |

## Column provenance

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

| GraphQL field | SQLite column |
|---|---|
| `effDate` | `EFF_DATE` |
| `fixId` | `FIX_ID` |
| `icaoRegionCode` | `ICAO_REGION_CODE` |
| `stateCode` | `STATE_CODE` |
| `countryCode` | `COUNTRY_CODE` |
| `navId` | `NAV_ID` |
| `navType` | `NAV_TYPE` |
| `bearing` | `BEARING` |
| `distance` | `DISTANCE` |