Remarks associated with airport data elements across all airport tables
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.
# 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 is available in-browser.
| Field | Type | Description | Units | Enum |
|---|---|---|---|---|
| effDate ← EFF_DATE | String | The 28-day NASR subscription effective date in format YYYY/MM/DD | ||
| siteNo ← SITE_NO | String | Landing facility site number; references SITE_NO in APT_BASE | ||
| siteTypeCode ← SITE_TYPE_CODE | SiteTypeCode | Landing facility type code |
| |
| stateCode ← STATE_CODE | String | Associated state post office code | ||
| arptId ← ARPT_ID | String | Location identifier; references ARPT_ID in APT_BASE | ||
| city ← CITY | String | Airport associated city name | ||
| countryCode ← COUNTRY_CODE | String | Country post office code where airport is located | ||
| legacyElementNumber ← LEGACY_ELEMENT_NUMBER | String | Legacy remark element number; equivalent to the LEGACY_ELEMENT_NAME field in the legacy APT.txt NASR subscriber file | ||
| tabName ← TAB_NAME | TabName | NASR table name associated with the remark | 10 values
| |
| refColName ← REF_COL_NAME | String | NASR column name associated with the remark; non-specific remarks are identified as GENERAL_REMARK | ||
| element ← 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 ← REF_COL_SEQ_NO | Int | Sequence number assigned to the reference column remark | ||
| remark ← REMARK | String | Remark text; free-form text that further describes a specific information item |