# AtcRmk

Remarks associated with ATC facilities, referencing specific tables and columns in the NASR database

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

> Ordered by FACILITY_ID, FACILITY_TYPE, REF_COL_NAME, REMARK_NO. The ordered by list is also the unique record key. Derived from legacy TWR6 and AFF2 records. ARPT_CTL_REMARKs are identified as ATC_REMARK; all other non-specific remarks are identified as GENERAL_REMARK.

## Example query

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

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. A unique identifying number. Not applicable to TRACON, ARTCC or CERAP. |  |  |
| `siteTypeCode` | `AtcRmkSiteTypeCode` | Facility Type Code indicating the type of landing facility |  | `A`=Airport; `B`=Balloonport; `C`=Seaplane Base; `H`=Heliport |
| `facilityType` | `AtcBaseFacilityType` | Facility Type describing the ATC facility classification |  | `ATCT`, `ATCT-A/C`, `ATCT-RAPCON`, … (9 values) |
| `stateCode` | `AtcBaseStateCode` | Associated State Post Office Code, standard two-letter abbreviation for US States and Territories |  | `AK`, `AL`, `AR`, … (58 values) |
| `facilityId` | `String` | Location Identifier. Unique 3-4 character alphanumeric identifier assigned to the Landing Facility or TRACON. |  |  |
| `city` | `String` | Airport Associated City Name |  |  |
| `countryCode` | `AtcRmkCountryCode` | Country Post Office Code for the country where the airport is located |  | `AI`, `BM`, `BS`, … (11 values) |
| `legacyElementNumber` | `LegacyElementNumber` | Legacy Remark Element number from the original TWR.txt or AFF.txt subscriber file format |  | `1`, `2`, `3`, … (20 values) |
| `tabName` | `AtcRmkTabName` | NASR Table name associated with the Remark |  | `AIRPORT`, `APCH_DEP_CTL_PROV`, `ARPT_APCH_DEP_CALL`, … (10 values) |
| `refColName` | `RefColName` | NASR Column name associated with the Remark. ARPT_CTL_REMARKs are identified as ATC_REMARK. All other non-specific remarks are identified as GENERAL_REMARK. |  | `APCH_DEP_CALL`, `ATC_REMARK`, `ATIS_HRS`, … (13 values) |
| `remarkNo` | `RemarkNo` | Sequence number assigned to Reference Column Remark, used to order multiple remarks for the same column |  | `1`, `2`, `3`, … (12 values) |
| `remark` | `String` | Remark Text - free form text that further describes a specific Information Item |  |  |

## Enum values

### `facilityType` (`AtcBaseFacilityType`)

| Code | Description |
|---|---|
| `ATCT` | Air Traffic Control Tower |
| `ATCT-A/C` | Air Traffic Control Tower plus Approach Control |
| `ATCT-RAPCON` | Air Traffic Control Tower plus Radar Approach Control (Air Force Operates ATCT/FAA Operates Approach Control) |
| `ATCT-RATCF` | Air Traffic Control Tower plus Radar Approach Control (Navy Operates ATCT/FAA Operates Approach Control) |
| `ATCT-TRACON` | Air Traffic Control Tower plus Terminal Radar Approach Control |
| `NON-ATCT` | Non-Air Traffic Control Tower |
| `TRACON` | Consolidated TRACON |
| `ARTCC` | Air Route Traffic Control Center |
| `CERAP` | Center Radar Approach Control Facility |

### `stateCode` (`AtcBaseStateCode`)

| 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 |
| `OH` | Ohio |
| `OK` | Oklahoma |
| `OR` | Oregon |
| `PA` | Pennsylvania |
| `PR` | Puerto Rico |
| `QM` | Kwajalein Atoll (US Army Kwajalein Atoll) |
| `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` (`AtcRmkCountryCode`)

| Code | Description |
|---|---|
| `AI` | Anguilla |
| `BM` | Bermuda |
| `BS` | Bahamas |
| `FM` | Federated States of Micronesia |
| `IO` | British Indian Ocean Territory |
| `MF` | Saint Martin |
| `MH` | Marshall Islands |
| `PW` | Palau |
| `SH` | Saint Helena |
| `TC` | Turks and Caicos Islands |
| `US` | United States |

### `legacyElementNumber` (`LegacyElementNumber`)

| Code | Description |
|---|---|
| `1` | Legacy element 1 |
| `2` | Legacy element 2 |
| `3` | Legacy element 3 |
| `4` | Legacy element 4 |
| `5` | Legacy element 5 |
| `6` | Legacy element 6 |
| `7` | Legacy element 7 |
| `8` | Legacy element 8 |
| `9` | Legacy element 9 |
| `10` | Legacy element 10 |
| `11` | Legacy element 11 |
| `12` | Legacy element 12 |
| `TA9` | Legacy AFF element TA9 |
| `TA11` | Legacy AFF element TA11 |
| `TA15` | Legacy AFF element TA15 |
| `TA19` | Legacy AFF element TA19 |
| `TA21` | Legacy AFF element TA21 |
| `TA35` | Legacy AFF element TA35 |
| `TA43` | Legacy AFF element TA43 |
| `TA55` | Legacy AFF element TA55 |

### `tabName` (`AtcRmkTabName`)

| Code | Description |
|---|---|
| `AIRPORT` | Airport table |
| `APCH_DEP_CTL_PROV` | Approach/Departure Control Provider table |
| `ARPT_APCH_DEP_CALL` | Airport Approach/Departure Call table |
| `ARPT_CTL_REMARK` | Airport Control Remark table |
| `ARPT_CTL_SVC` | Airport Control Service table |
| `ARTCC` | Air Route Traffic Control Center table |
| `ATIS` | ATIS table |
| `CTL_PRVDING_ARPT` | Control Providing Airport table |
| `TRACON` | TRACON table |
| `TWR_AIRPORT` | Tower Airport table |

### `refColName` (`RefColName`)

| Code | Description |
|---|---|
| `APCH_DEP_CALL` | Approach/Departure Call column |
| `ATC_REMARK` | ATC Control Remark (ARPT_CTL_REMARK type) |
| `ATIS_HRS` | ATIS Hours of Operation column |
| `ATIS_PHONE_NO` | ATIS Phone Number column |
| `CTL_PRVDING_HRS` | Control Providing Hours column |
| `CTL_SVC` | Control Service column |
| `CTL_TYPE_CODE` | Control Type Code column |
| `DESCRIPTION` | Description column |
| `GENERAL_REMARK` | General non-specific remark |
| `NO_DAILY_OPS_HRS` | Number of Daily Operations Hours column |
| `TWR_HRS` | Tower Hours column |
| `TWR_OPERATOR_CODE` | Tower Operator Code column |
| `TWR_TYPE_CODE` | Tower Type Code column |

### `remarkNo` (`RemarkNo`)

| Code | Description |
|---|---|
| `1` | First remark |
| `2` | Second remark |
| `3` | Third remark |
| `4` | Fourth remark |
| `5` | Fifth remark |
| `6` | Sixth remark |
| `7` | Seventh remark |
| `8` | Eighth remark |
| `9` | Ninth remark |
| `10` | Tenth remark |
| `11` | Eleventh remark |
| `12` | Twelfth remark |

## Column provenance

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

| GraphQL field | SQLite column |
|---|---|
| `effDate` | `EFF_DATE` |
| `siteNo` | `SITE_NO` |
| `siteTypeCode` | `SITE_TYPE_CODE` |
| `facilityType` | `FACILITY_TYPE` |
| `stateCode` | `STATE_CODE` |
| `facilityId` | `FACILITY_ID` |
| `city` | `CITY` |
| `countryCode` | `COUNTRY_CODE` |
| `legacyElementNumber` | `LEGACY_ELEMENT_NUMBER` |
| `tabName` | `TAB_NAME` |
| `refColName` | `REF_COL_NAME` |
| `remarkNo` | `REMARK_NO` |
| `remark` | `REMARK` |