# AptRmk

Remarks associated with airport data elements across all airport tables

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

> Ordered by SITE_NO, SITE_TYPE_CODE, TAB_NAME, REF_COL_NAME, ELEMENT, REF_COL_SEQ_NO. Non-specific remarks are identified as GENERAL_REMARK in REF_COL_NAME.

## Example query

```graphql
# Introspect the AptRmk type in GraphiQL at https://api.nav.sortie.co/graphql
# Example shape (pair with a compatible root query field):
{
  # ...rootQuery... {
    effDate
    siteNo
    siteTypeCode
    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 |  |  |
| `siteNo` | `String` | Landing facility site number; references SITE_NO in APT_BASE |  |  |
| `siteTypeCode` | `SiteTypeCode` | Landing facility type code |  | `A`=AIRPORT; `B`=BALLOONPORT; `C`=SEAPLANE BASE; `G`=GLIDERPORT; `H`=HELIPORT; `U`=ULTRALIGHT |
| `stateCode` | `String` | Associated state post office code |  |  |
| `arptId` | `String` | Location identifier; references ARPT_ID in APT_BASE |  |  |
| `city` | `String` | Airport associated city name |  |  |
| `countryCode` | `String` | Country post office code where airport is located |  |  |
| `legacyElementNumber` | `String` | Legacy remark element number; equivalent to the LEGACY_ELEMENT_NAME field in the legacy APT.txt NASR subscriber file |  |  |
| `tabName` | `TabName` | NASR table name associated with the remark |  | `AIRPORT`, `AIRPORT_ATTEND_SCHED`, `AIRPORT_CONTACT`, … (10 values) |
| `refColName` | `String` | NASR column name associated with the remark; non-specific remarks are identified as GENERAL_REMARK |  |  |
| `element` | `String` | Specific element that remark text pertains to; for AIRPORT ATTEND SCHED this is SKED_SEQ_NO; for AIRPORT CONTACT this is TITLE; for AIRPORT SERVICE this is SERVICE_TYPE_CODE; for ARRESTING DEVICE this is RWY_END_ID_ARREST_DEVICE_CODE; for FUEL TYPE this is FUEL_TYPE; for RUNWAY this is RWY_ID; for RUNWAY END this is RWY_END_ID; for RUNWAY END OBSTN this is RWY_END_ID; for RUNWAY SURFACE TYPE this is RWY_ID |  |  |
| `refColSeqNo` | `Int` | Sequence number assigned to the reference column remark |  |  |
| `remark` | `String` | Remark text; free-form text that further describes a specific information item |  |  |

## Enum values

### `tabName` (`TabName`)

| Code | Description |
|---|---|
| `AIRPORT` | Airport base table |
| `AIRPORT_ATTEND_SCHED` | Airport attendance schedule table |
| `AIRPORT_CONTACT` | Airport contact table |
| `AIRPORT_SERVICE` | Airport service table |
| `ARRESTING_DEVICE` | Arresting device table |
| `FUEL_TYPE` | Fuel type table |
| `RUNWAY` | Runway table |
| `RUNWAY_END` | Runway end table |
| `RUNWAY_END_OBSTN` | Runway end obstruction table |
| `RUNWAY_SURFACE_TYPE` | Runway surface type table |

## Column provenance

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

| GraphQL field | SQLite column |
|---|---|
| `effDate` | `EFF_DATE` |
| `siteNo` | `SITE_NO` |
| `siteTypeCode` | `SITE_TYPE_CODE` |
| `stateCode` | `STATE_CODE` |
| `arptId` | `ARPT_ID` |
| `city` | `CITY` |
| `countryCode` | `COUNTRY_CODE` |
| `legacyElementNumber` | `LEGACY_ELEMENT_NUMBER` |
| `tabName` | `TAB_NAME` |
| `refColName` | `REF_COL_NAME` |
| `element` | `ELEMENT` |
| `refColSeqNo` | `REF_COL_SEQ_NO` |
| `remark` | `REMARK` |