# FssRmk

Remarks associated with specific FSS_BASE columns or general remarks for Flight Service Stations

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

> Ordered by FSS_ID, REF_COL_NAME, REF_COL_SEQ_NO which together form the unique record key. Non-specific remarks are identified as GENERAL_REMARK.

## Example query

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

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 |  |  |
| `fssId` | `FssRmkFssId` | Flight Service Station Identifier; references FSS_ID in FSS_BASE |  | `BRW`, `DLG`, `ENA`, … (9 values) |
| `name` | `String` | Flight Service Station Name |  |  |
| `city` | `String` | Associated city name where the FSS is located |  |  |
| `stateCode` | `FssRmkStateCode` | Associated state using standard two-letter US Post Office code abbreviation |  | `AK`=Alaska; `HI`=Hawaii |
| `countryCode` | `String` | Country Post Office Code for the country where the FSS is located |  |  |
| `refColName` | `FssRmkRefColName` | NASR column name in FSS_BASE associated with this remark; non-specific remarks are identified as GENERAL_REMARK |  | `GENERAL_REMARK`=General non-specific remark about the FSS; `PHONE_NO`=Remark pertaining to the FSS telephone number |
| `refColSeqNo` | `Int` | Sequence number assigned to the remark for the referenced column, used to order multiple remarks for the same column |  |  |
| `remark` | `String` | Free form remark text that further describes a specific information item for the FSS |  |  |

## Enum values

### `fssId` (`FssRmkFssId`)

| Code | Description |
|---|---|
| `BRW` | Barrow |
| `DLG` | Dillingham |
| `ENA` | Kenai |
| `FAI` | Fairbanks |
| `HNL` | Honolulu |
| `ILI` | Iliamna |
| `JNU` | Juneau |
| `OME` | Nome |
| `OTZ` | Kotzebue |

## Column provenance

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

| GraphQL field | SQLite column |
|---|---|
| `effDate` | `EFF_DATE` |
| `fssId` | `FSS_ID` |
| `name` | `NAME` |
| `city` | `CITY` |
| `stateCode` | `STATE_CODE` |
| `countryCode` | `COUNTRY_CODE` |
| `refColName` | `REF_COL_NAME` |
| `refColSeqNo` | `REF_COL_SEQ_NO` |
| `remark` | `REMARK` |