# AptArs

Aircraft arresting system data associated with runway ends at landing facilities

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

> Ordered by SITE_NO, SITE_TYPE_CODE, RWY_ID, RWY_END_ID, ARREST_DEVICE_CODE

## Example query

```graphql
# Introspect the AptArs 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 |  |  |
| `rwyId` | `String` | Runway identification |  |  |
| `rwyEndId` | `String` | Runway end identifier; the runway end described by the arresting system information |  |  |
| `arrestDeviceCode` | `ArrestDeviceCode` | Type of aircraft arresting device; indicates type of jet arresting barrier installed at the far end |  | `BAK-6`, `BAK-9`, `BAK-12`, … (18 values) |

## Enum values

### `arrestDeviceCode` (`ArrestDeviceCode`)

| Code | Description |
|---|---|
| `BAK-6` | BAK-6 arresting system |
| `BAK-9` | BAK-9 arresting system |
| `BAK-12` | BAK-12 arresting system |
| `BAK-12B` | BAK-12B arresting system |
| `BAK-13` | BAK-13 arresting system |
| `BAK-14` | BAK-14 arresting system |
| `E5` | E5 arresting system |
| `E5-1` | E5-1 arresting system |
| `E27` | E27 arresting system |
| `E27B` | E27B arresting system |
| `E28` | E28 arresting system |
| `E28B` | E28B arresting system |
| `EMAS` | Engineered Materials Arresting System |
| `M21` | M21 arresting system |
| `MA-1` | MA-1 arresting system |
| `MA-1A` | MA-1A arresting system |
| `MA-1A MOD` | MA-1A Modified arresting system |
| `MB60` | MB60 arresting system |

## Column provenance

Every field maps 1:1 to a column in the `APT_ARS` 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` |
| `rwyId` | `RWY_ID` |
| `rwyEndId` | `RWY_END_ID` |
| `arrestDeviceCode` | `ARREST_DEVICE_CODE` |