# AptAtt

Airport attendance schedule data describing when the facility is attended

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

> Ordered by SITE_NO, SITE_TYPE_CODE, SKED_SEQ_NO

## Example query

```graphql
# Introspect the AptAtt 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 |  |  |
| `skedSeqNo` | `Int` | Attendance schedule sequence number; together with site number uniquely identifies the attendance schedule component |  |  |
| `month` | `String` | Describes the months that the facility is attended; may also contain UNATNDD for unattended facilities |  |  |
| `day` | `String` | Describes the days of the week that the facility is open |  |  |
| `hour` | `String` | Describes the hours within the day that the facility is attended |  |  |

## Column provenance

Every field maps 1:1 to a column in the `APT_ATT` 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` |
| `skedSeqNo` | `SKED_SEQ_NO` |
| `month` | `MONTH` |
| `day` | `DAY` |
| `hour` | `HOUR` |