# NavRmk

Remarks associated with NAVAID records, providing free-form text that further describes specific information items

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

> Ordered by NAV_ID, NAV_TYPE, COUNTRY_CODE, CITY, TAB_NAME, REF_COL_NAME, REF_COL_SEQ_NO. Shares common key fields with NAV_BASE.

## Example query

```graphql
# Introspect the NavRmk type in GraphiQL at https://api.nav.sortie.co/graphql
# Example shape (pair with a compatible root query field):
{
  # ...rootQuery... {
    effDate
    navId
    navType
    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 |  |  |
| `navId` | `String` | NAVAID Facility Identifier. References NAV_ID in NAV_BASE. |  |  |
| `navType` | `NavBaseNavType` | NAVAID Facility Type. References NAV_TYPE in NAV_BASE. |  | `DME`, `FAN MARKER`, `MARINE NDB`, … (10 values) |
| `stateCode` | `NavRmkStateCode` | Associated State Post Office Code. References STATE_CODE in NAV_BASE. |  | `AK`, `AL`, `AR`, … (57 values) |
| `city` | `String` | NAVAID Associated City Name. References CITY in NAV_BASE. |  |  |
| `countryCode` | `NavRmkCountryCode` | Country Post Office Code for country where NAVAID is located. References COUNTRY_CODE in NAV_BASE. |  | `AG`, `BB`, `BM`, … (11 values) |
| `tabName` | `NavRmkTabName` | NASR table name associated with the remark |  | `NAVIGATION_AID`=Remark associated with the Navigation Aid base table; `NAVIGATION_USE`=Remark associated with navigation use data; `TACAN_DME_TYPE`=Remark associated with TACAN/DME type data; `VOR_RECEIVER_CHKPT`=Remark associated with VOR Receiver Checkpoint data |
| `refColName` | `NavRmkRefColName` | NASR column name associated with the remark; non-specific remarks are identified as GENERAL_REMARK |  | `AIR_GND_CODE`, `CHAN`, `ELEV`, … (9 values) |
| `refColSeqNo` | `Int` | Sequence number assigned to the Reference Column Remark, allowing multiple remarks per column |  |  |
| `remark` | `String` | Remark text as free-form text that further describes a specific information item |  |  |

## Enum values

### `navType` (`NavBaseNavType`)

| Code | Description |
|---|---|
| `DME` | Distance Measuring Equipment only |
| `FAN MARKER` | Fan Marker beacon |
| `MARINE NDB` | Marine Non-Directional Beacon |
| `NDB` | Non-Directional Beacon |
| `NDB/DME` | Non-Directional Beacon with DME |
| `TACAN` | Tactical Air Navigation System |
| `VOR` | VHF Omni-Directional Range |
| `VOR/DME` | VHF Omni-Directional Range with DME |
| `VORTAC` | Combined VOR and TACAN facility |
| `VOT` | FAA VOR Test Facility |

### `stateCode` (`NavRmkStateCode`)

| 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` | N 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 |
| `OH` | Ohio |
| `OK` | Oklahoma |
| `OR` | Oregon |
| `PA` | Pennsylvania |
| `PR` | Puerto Rico |
| `QW` | Wake Island |
| `RI` | Rhode Island |
| `SC` | South Carolina |
| `SD` | South Dakota |
| `TN` | Tennessee |
| `TX` | Texas |
| `UT` | Utah |
| `VA` | Virginia |
| `VI` | Virgin Islands |
| `VT` | Vermont |
| `WA` | Washington |
| `WI` | Wisconsin |
| `WV` | West Virginia |
| `WY` | Wyoming |

### `countryCode` (`NavRmkCountryCode`)

| Code | Description |
|---|---|
| `AG` | Antigua and Barbuda |
| `BB` | Barbados |
| `BM` | Bermuda |
| `BS` | Bahamas |
| `CA` | Canada |
| `DO` | Dominican Republic |
| `FM` | Micronesia, Fed States of |
| `MH` | Marshall Islands |
| `MQ` | Martinique |
| `PW` | Palau |
| `US` | United States |

### `refColName` (`NavRmkRefColName`)

| Code | Description |
|---|---|
| `AIR_GND_CODE` | Remark references the Air/Ground Code column |
| `CHAN` | Remark references the Channel column |
| `ELEV` | Remark references the Elevation column |
| `GENERAL_REMARK` | Non-specific general remark not tied to a specific column |
| `LAT_LONG_SOURCE_CODE` | Remark references the Lat/Long Source Code column |
| `MAG_VARN` | Remark references the Magnetic Variation column |
| `MNT_CAT_CODE` | Remark references the Monitoring Category Code column |
| `NAV_STATUS` | Remark references the Navigation Aid Status column |
| `OPER_HOURS` | Remark references the Operating Hours column |

## Column provenance

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

| GraphQL field | SQLite column |
|---|---|
| `effDate` | `EFF_DATE` |
| `navId` | `NAV_ID` |
| `navType` | `NAV_TYPE` |
| `stateCode` | `STATE_CODE` |
| `city` | `CITY` |
| `countryCode` | `COUNTRY_CODE` |
| `tabName` | `TAB_NAME` |
| `refColName` | `REF_COL_NAME` |
| `refColSeqNo` | `REF_COL_SEQ_NO` |
| `remark` | `REMARK` |