You are browsing sample data. Buy download of full dataset or subscribe to API access with one of our member plans.
{ "sample": { "is_sample": "TRUE", "limit_total": 400 }, "api": { "title": "Airport In USA Information", "desc": "Airport detail information in USA data set", "point": { "title": "By Table", "desc": "Each API function returns data from a specific database table. " } }, "input": { "url": false, "get": false, "post": false }, "links": { "up": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/airport_in_usa_information/by_table/" }, "home": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/airport_in_usa_information/by_table/remark/?app=html-json&manifest=row" }, "prev": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/airport_in_usa_information/by_table/remark/2/?app=html-json&manifest=row" }, "next": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/airport_in_usa_information/by_table/remark/4/?app=html-json&manifest=row" } }, "meta": { "query": { "page": 3, "limit": 100, "limit_total": 400, "time": 0.00088999999999999994913790768436001599184237420558929443359375 }, "stats": { "raw_rows": 100, "rows": 100, "rows_total": 25399, "pages_total": 254 }, "struct": { "stem": { "0": "remark" }, "leaf": "remark.id", "leaf_stem": {}, "leaf_stem_leaf": null } }, "output": { "rows": { "252": { "remark.id": 252, "remark.ts": "2017-10-24 22:04:43", "remark.value": "OPERATIONS NW OF ARPT ARE PROHIBITED. ACFT ARE TO REMAIN WELL CLEAR OF SNOWSHOE ELEMENTARY SCHOOL AT ALL TIMES." }, "253": { "remark.id": 253, "remark.ts": "2017-10-24 22:04:43", "remark.value": "ARRIVALS/DEPARTURES TO REMAIN SOUTH OF FAIRVIEW LOOP ROAD UNTIL WELL CLEAR OF THE JACKFISH LANDING AIRSTRIP TRAFFIC PATTERN." }, "255": { "remark.id": 255, "remark.ts": "2017-10-24 22:04:49", "remark.value": "RY PLOWED IN WINTER." }, "257": { "remark.id": 257, "remark.ts": "2017-10-24 22:05:01", "remark.value": "AIRSTRIP LOCATED INSIDE CHUGACH STATE PARK." }, "258": { "remark.id": 258, "remark.ts": "2017-10-24 22:05:01", "remark.value": "HIKERS & VEHICLES INVOF AIRSTRIP." }, "259": { "remark.id": 259, "remark.ts": "2017-10-24 22:05:01", "remark.value": "SHARPLY RISING TERRAIN EAST; SOUTH & WEST QUADRANTS." }, "260": { "remark.id": 260, "remark.ts": "2017-10-24 22:05:01", "remark.value": "LANDINGS NOT ALLOWED ON LAKE." }, "261": { "remark.id": 261, "remark.ts": "2017-10-24 22:05:01", "remark.value": "DETERMINATION PENDING." }, "262": { "remark.id": 262, "remark.ts": "2017-10-24 22:05:10", "remark.value": "RY 12, LIGHT ON SHORE BREEZE CREATES 4 TO 5 KNOT TAIL WIND MOST SUMMER DAYS." }, "264": { "remark.id": 264, "remark.ts": "2017-10-24 22:05:29", "remark.value": "PPR REQUIRED FROM ALASCOM." }, "265": { "remark.id": 265, "remark.ts": "2017-10-24 22:05:29", "remark.value": "TURBULENCE LIKELY WHEN WIND GREATER THAN 10 KTS FM ANY DIRECTION." }, "266": { "remark.id": 266, "remark.ts": "2017-10-24 22:05:29", "remark.value": "NO WINTER MAINTENANCE." }, "267": { "remark.id": 267, "remark.ts": "2017-10-24 22:05:31", "remark.value": "NO WINTER MAINT; SKI EQUIPPED ACFT ONLY." }, "268": { "remark.id": 268, "remark.ts": "2017-10-24 22:05:31", "remark.value": "RY COND NOT MONITORED; RCMD VISUAL INSPECTION PRIOR TO LANDING." }, "269": { "remark.id": 269, "remark.ts": "2017-10-24 22:05:31", "remark.value": "RY 05/23 HAS DITCHES ALONG EACH SIDE." }, "270": { "remark.id": 270, "remark.ts": "2017-10-24 22:05:31", "remark.value": "RY 05/23 HAS SLIGHT DIP IN MIDDLE." }, "271": { "remark.id": 271, "remark.ts": "2017-10-24 22:05:31", "remark.value": "SUAIS - 125.3(1-800-758-8723)." }, "272": { "remark.id": 272, "remark.ts": "2017-10-24 22:05:31", "remark.value": "RYS 5 & 23 THLDS MKD WITH REFLECTIVE PANELS & CONES." }, "274": { "remark.id": 274, "remark.ts": "2017-10-24 22:05:38", "remark.value": "BE ALERT: ULTRALIGHT AND GLIDER ACTIVITY ON & INOV ARPT." }, "275": { "remark.id": 275, "remark.ts": "2017-10-24 22:05:38", "remark.value": "FOR NOISE ABATEMENT OWNER REQUESTS PILOTS MAINT MAXIMUM FEASIBLE ALTITUDE WHEN LNDG ON RWY 15." }, "276": { "remark.id": 276, "remark.ts": "2017-10-24 22:05:38", "remark.value": "DIRT ROADS CROSS APCHS TO RYS 15 & 33." }, "278": { "remark.id": 278, "remark.ts": "2017-10-24 22:05:38", "remark.value": "RECOMMEND VISUAL INSPECTION PRIOR LANDING." }, "279": { "remark.id": 279, "remark.ts": "2017-10-24 22:05:38", "remark.value": "HARD PACKED SNOW SURFACE IS MAINTAINED ON RY NOV-APR." }, "280": { "remark.id": 280, "remark.ts": "2017-10-24 22:05:38", "remark.value": "RY 15/33 THLD MKD WITH PANELS." }, "282": { "remark.id": 282, "remark.ts": "2017-10-24 22:05:53", "remark.value": "250 FT TWR .5 NM NW; 250 FT TWR 1 NM SE & 200 FT TWR 1 NM W OF RY 17/35." }, "283": { "remark.id": 283, "remark.ts": "2017-10-24 22:05:53", "remark.value": "PILOT USE OF FREQ 122.9 MANDATORY." }, "284": { "remark.id": 284, "remark.ts": "2017-10-24 22:05:53", "remark.value": "PRVDD VFR OPNS, PVT USE, RGT TRAFFIC RY 35. MANDATORY USE CTAF 122.9." }, "285": { "remark.id": 285, "remark.ts": "2017-10-24 22:06:00", "remark.value": "RY COND NOT MONITORED; RCMD VISUAL INSPECTION PRIOR TO LDNG." }, "288": { "remark.id": 288, "remark.ts": "2017-10-24 22:06:06", "remark.value": "PUBLIC ACCESS AT NORTH END OF LAKE. NO DESIGNATED TRANSIENT AREAS." }, "290": { "remark.id": 290, "remark.ts": "2017-10-24 22:06:08", "remark.value": "ALL ACFT MONITOR AND ANNOUNCE INTENTIONS ON FREQ 122.8." }, "291": { "remark.id": 291, "remark.ts": "2017-10-24 22:06:08", "remark.value": "PRVDD PVT USE ONLY; ALL ACFT MONITOR AND ANNOUNCE INTENTIONS ON ASSIGNED FREQ." }, "292": { "remark.id": 292, "remark.ts": "2017-10-24 22:06:20", "remark.value": "RECOMMEND VISUAL INSPECTION OF RY." }, "293": { "remark.id": 293, "remark.ts": "2017-10-24 22:06:20", "remark.value": "MOOSE OCCASIONALLY ON OR NEAR RY." }, "295": { "remark.id": 295, "remark.ts": "2017-10-24 22:06:20", "remark.value": "RY 17/35 TFC PAT R/W 1100 FT MSL; FIXED WING 1900 FT MSL." }, "296": { "remark.id": 296, "remark.ts": "2017-10-24 22:06:20", "remark.value": "LGTD 190 FT ANTENNAS AT NATIONAL GUARD ARMORY E OF RY 17/35." }, "297": { "remark.id": 297, "remark.ts": "2017-10-24 22:06:20", "remark.value": "ARMY AVIATION SUPPORT FACILITY C907-428-6333." }, "298": { "remark.id": 298, "remark.ts": "2017-10-24 22:06:20", "remark.value": "24 HR PPR. 96 HR PPR FOR SVCS." }, "300": { "remark.id": 300, "remark.ts": "2017-10-24 22:06:27", "remark.value": "LAND AT OWN RISK, ARPT INACTIVE, NOT MAINTAINED." }, "302": { "remark.id": 302, "remark.ts": "2017-10-24 22:06:34", "remark.value": "RWY SUBJECT TO TURBULENT CROSSWINDS IN SUMMER MONTHS." }, "304": { "remark.id": 304, "remark.ts": "2017-10-24 22:06:34", "remark.value": "MIGRATORY WATERFOWL INVOF ARPT SPRING THROUGH FALL." }, "306": { "remark.id": 306, "remark.ts": "2017-10-24 22:06:40", "remark.value": "PRVDD OWNERS OF BUFFALO ROW HELIPORT AND ALLEN ARMY AIRFIELD ENTER INTO A LOA TO DEFINE OPERATING PROCEDURES AND CONDITIONS OF USE FOR BUFFALO ROW HELIPORT." }, "307": { "remark.id": 307, "remark.ts": "2017-10-24 22:06:53", "remark.value": "ALL ACFT OPERATORS SHALL OBTAIN A PPR NUMBER AT LEAST 24 HRS PRIOR TO INTENDED LNDG." }, "308": { "remark.id": 308, "remark.ts": "2017-10-24 22:06:53", "remark.value": "US AIR FORCE INSTALLATION. ALL CIVIL ACFT OPERATORS MUST HAVE A CURRENT CIVIL AIRCRAFT LANDING PERMIT (CALP) BEFORE A PPR CAN BE ISSUED. IAW AIR FORCE INSTRUCTION 10-1001 (HTTP://STATIC.E-PUBLISHING.AF.MIL/PRODUCTION/1/AF_A3_5/PUBLICATION/AFI10-1001/AFI10" }, "309": { "remark.id": 309, "remark.ts": "2017-10-24 22:06:53", "remark.value": "FAILURE TO OBTAIN AND HAVE ONBOARD APPROVED CALP WILL RESULT IN FINES LEVIED AGAINST VIOLATORS AND REPORTS FORWARDED TO THE FAA FSDO AND US ATTORNEY'S OFFICE IAW 32 CFR 855 AND USAF OPERATING INSTRUCTIONS." }, "311": { "remark.id": 311, "remark.ts": "2017-10-24 22:06:53", "remark.value": "CAUTION: RWY & HELI NOT MAINTAINED, COND UNKN. RCMD VISUAL INSP PRIOR TO LNDG." }, "312": { "remark.id": 312, "remark.ts": "2017-10-24 22:06:57", "remark.value": "RWY HAS DIP IN CENTER." }, "313": { "remark.id": 313, "remark.ts": "2017-10-24 22:07:14", "remark.value": "ROAD RUNS ALONG NORTH & SOUTH SIDE OF RY." }, "314": { "remark.id": 314, "remark.ts": "2017-10-24 22:07:14", "remark.value": "RY SAFETY AREA CLEARED 1800 FT X 200 FT." }, "316": { "remark.id": 316, "remark.ts": "2017-10-24 22:07:14", "remark.value": "RY 07/25 CONDITIONS NOT MONITORED, VISUAL INSPECTION RECOMMENDED PRIOR TO LDG." }, "317": { "remark.id": 317, "remark.ts": "2017-10-24 22:07:14", "remark.value": "400 FT SAFETY AREA ON RY 07 END." }, "318": { "remark.id": 318, "remark.ts": "2017-10-24 22:07:54", "remark.value": "USE PERMITTED ONLY WITH PRIOR PERMISSION OF BLM SOUTHERN ALASKA AVIATION OFFICER 267-1378." }, "319": { "remark.id": 319, "remark.ts": "2017-10-24 22:07:54", "remark.value": "ALL TFC PTRNS SE OF FIELD; AUTHORIZED ACFT CTC FREQ 127.45 PRIOR TO LNDG." }, "320": { "remark.id": 320, "remark.ts": "2017-10-24 22:07:54", "remark.value": "FOR WSO PHONE 271-3491." }, "324": { "remark.id": 324, "remark.ts": "2017-10-24 22:08:03", "remark.value": "RESTRICTED TO BLM USE ONLY." }, "325": { "remark.id": 325, "remark.ts": "2017-10-24 22:08:04", "remark.value": "PREPLANNED PATTERN TO THE WEST, UNLESS SE WIND DICTATES E APCH/DEP." }, "326": { "remark.id": 326, "remark.ts": "2017-10-24 22:08:04", "remark.value": "ANCHORAGE WX CAMERA AVBL ON INTERNET AT HTTP://AKWEATHERCAMS.FAA.GOV" }, "327": { "remark.id": 327, "remark.ts": "2017-10-24 22:08:04", "remark.value": "NO SERVICE TO TRANSIENT AIRCRAFT." }, "328": { "remark.id": 328, "remark.ts": "2017-10-24 22:08:08", "remark.value": "BOTH SIDES RWY USED AS ROAD." }, "329": { "remark.id": 329, "remark.ts": "2017-10-24 22:08:08", "remark.value": "NOT MAINTAINED IN WINTER." }, "330": { "remark.id": 330, "remark.ts": "2017-10-24 22:08:08", "remark.value": "DUMPSTER LOCATED WITHIN 20 FT OF R EDGE - RY 02 200 FT FROM THR." }, "331": { "remark.id": 331, "remark.ts": "2017-10-24 22:08:08", "remark.value": "RIDGES 30-50 FT RUN ALONG BOTH SIDES RY 02/20." }, "332": { "remark.id": 332, "remark.ts": "2017-10-24 22:08:08", "remark.value": "FUEL FARM LOCATED WITHIN 20 FT OF LEFT EDGE RY20." }, "333": { "remark.id": 333, "remark.ts": "2017-10-24 22:08:08", "remark.value": "PPR TO LND CALL 435-487-9252 OR 801-455-5200." }, "336": { "remark.id": 336, "remark.ts": "2017-10-24 22:08:14", "remark.value": "RY SUBJECT TO TURBULENT WINDS;HIGH TERRAIN TO THE NE; SW APPROACH FAVORED." }, "337": { "remark.id": 337, "remark.ts": "2017-10-24 22:08:14", "remark.value": "RY CONDITION MONITORED IREGLY; RECOMMEND VISUAL INSPECTION PRIOR TO LANDING." }, "338": { "remark.id": 338, "remark.ts": "2017-10-24 22:08:14", "remark.value": "RY 04 REQUIRES DOGLEG APPROACH DUE TO MOUNTAINOUS TERRAIN." }, "339": { "remark.id": 339, "remark.ts": "2017-10-24 22:08:14", "remark.value": "WHEN AVBL WEA RPRTS HRLY ONLY." }, "340": { "remark.id": 340, "remark.ts": "2017-10-24 22:08:14", "remark.value": "RY 04 SLOPE AT 2% UPHILL NORTH." }, "341": { "remark.id": 341, "remark.ts": "2017-10-24 22:08:14", "remark.value": "NORTH RY EDGE MARKED WITH CONES, OTHERWISE UNMARKED. RY SOFT AND PUDDLES AFTER RAIN." }, "343": { "remark.id": 343, "remark.ts": "2017-10-24 22:08:14", "remark.value": "ALL ACFT LAND EAST OF CONES." }, "344": { "remark.id": 344, "remark.ts": "2017-10-24 22:08:27", "remark.value": "CAUTION: RY LOCATED AT BASE OF STEEP MOUNTAIN. MOUNTAIN SLOPES IN APCH ZONE BOTH ENDS OF RY." }, "345": { "remark.id": 345, "remark.ts": "2017-10-24 22:08:27", "remark.value": "CAUTION: SURFACE WINDS OVER 10 KTS MAY PRODUCE SEVERE TURBULENCE." }, "346": { "remark.id": 346, "remark.ts": "2017-10-24 22:08:27", "remark.value": "CAUTION: NUMEROUS BIRD NESTS IN CLIFF INVOF ARPT." }, "347": { "remark.id": 347, "remark.ts": "2017-10-24 22:08:27", "remark.value": "ALL MILITARY, GOVERNMENT, AND CIVILIAN AIRCRAFT MUST OBTAIN A PPR NUMBER 24 HRS PRIOR TO SCHEDULED ARRIVAL BUT NO LATER THAN 1 HR PRIOR TO DEPARTURE FOR THE SITE. CONTACT SITE PERSONNEL AT DSN 317-552-9730/9637 OR C (907) 552-9730/9637." }, "348": { "remark.id": 348, "remark.ts": "2017-10-24 22:08:27", "remark.value": "ALL CIVIL ACFT OPERATORS MUST HAVE A CURRENT CIVIL AIRCRAFT LANDING PERMIT (CALP) BEFORE A PPR CAN BE ISSUED. IAW AIR FORCE INSTRUCTION 10-1001 (HTTP://STATIC.E-PUBLISHING.AF.MIL/PRODUCTION/1/AF_A3_5/PUBLICATION/AFI10-1001/AFI10-1001.PDF) AT LEAST 30 DAYS" }, "350": { "remark.id": 350, "remark.ts": "2017-10-24 22:08:27", "remark.value": "ESTABLISH RADIO CONTACT AS SOON AS POSSIBLE PRIOR TO LANDING." }, "351": { "remark.id": 351, "remark.ts": "2017-10-24 22:08:40", "remark.value": "CAUTION: RWY LOCATED ON SLOPE OF 2305 FT MOUNTAIN." }, "352": { "remark.id": 352, "remark.ts": "2017-10-24 22:08:40", "remark.value": "ALL MILITARY, GOVERNMENT AND CIVILIAN AIRCRAFT MUST OBTAIN A PPR NUMBER 24 HRS PRIOR TO SCHEDULED ARRIVAL BUT NO LATER THAN 1 HR PRIOR TO DEPARTURE FOR THE SITE. CONTACT SITE PERSONNEL AT: DSN 317-552-9419/9370, C907-552-9419/9370." }, "353": { "remark.id": 353, "remark.ts": "2017-10-24 22:08:40", "remark.value": "PASSENGERS MUST COORDINATE ALL TRAVEL WITH ARS PROGRAM MANAGEMENT (DSN 317-552-4400/1989 OR C907-552-4400/1989) ON ALL NON-EMERGENCY TRAVEL TO SITE." }, "355": { "remark.id": 355, "remark.ts": "2017-10-24 22:08:40", "remark.value": "APCH FM NW, LAND RWY 14 ONLY. TKOF RWY 32 ONLY. HIGH TERRAIN BOTH SIDES & S END. SUCCESSFUL GO AROUND IMPROBABLE." }, "356": { "remark.id": 356, "remark.ts": "2017-10-24 22:08:40", "remark.value": "RWY AND PARKING APRON ON 7.9% GRADE. LAST 200 FT RWY 14 MAY CONTAIN PARKED ACFT." }, "357": { "remark.id": 357, "remark.ts": "2017-10-24 22:08:40", "remark.value": "ESTABLISH RADIO CONTACT AS SOON AS POSSIBLE PRIOR TO LANDING. AFTER INITIAL CONTACT ON FREQ 126.2 OR 121.5 EXPECT A 30 MIN DELAY FOR CURRENT AIRSTRIP CONDITIONS." }, "358": { "remark.id": 358, "remark.ts": "2017-10-24 22:08:40", "remark.value": "RADOME WINDS NOT ALWAYS AVBL." }, "359": { "remark.id": 359, "remark.ts": "2017-10-24 22:08:40", "remark.value": "USAF INSTALLATION. ALL CIVIL ACFT OPERATORS MUST HAVE A CURRENT CIVIL AIRCRAFT LANDING PERMIT (CALP) BEFORE A PPR CAN BE ISSUED. IAW AIR FORCE INSTRUCTION 10-1001 (HTTP://STATIC.E-PUBLISHING.AF.MIL/PRODUCTION/1/AF_A3_5/PUBLICATION/AFI10-1001/AFI10-1001.PD" }, "360": { "remark.id": 360, "remark.ts": "2017-10-24 22:08:48", "remark.value": "OPERG AREA IN FISHERMANS HARBOR; ROCKS IN ENTRANCE; HEAVY SEAS ARE FREQUENT." }, "361": { "remark.id": 361, "remark.ts": "2017-10-24 22:08:48", "remark.value": "NO LONGER USED AS LOGGING/SEAPLANE OPNS. THERE IS LINE ACROSS INLET AT FLOAT." }, "362": { "remark.id": 362, "remark.ts": "2017-10-24 22:08:48", "remark.value": "BEACH CONTAINS LARGE ROCKS UNSAFE FOR SEAPLANE FLOATS." }, "363": { "remark.id": 363, "remark.ts": "2017-10-24 22:08:52", "remark.value": "RWY LCTD ON SIDE OF 2100' MTN; APCH FM SW LND RWY 02 ONLY; TKOF RWY 20 ONLY; HIGH TERRAIN BOTH SIDES & N END RWY; SUCCESSFUL GO-AROUND IMPROBABLE." }, "366": { "remark.id": 366, "remark.ts": "2017-10-24 22:08:52", "remark.value": "CAUTION; WNDS IN EXCESS OF 20 KTS MAY PRODUCE SEVERE TURBULANCE." }, "367": { "remark.id": 367, "remark.ts": "2017-10-24 22:08:52", "remark.value": "BE ALERT: SHARP DROP OFF WEST SIDE OF RY. RESTRICT 180 DEG TURNS TO N END OF RY, AT APRON AREA" }, "369": { "remark.id": 369, "remark.ts": "2017-10-24 22:08:52", "remark.value": "CAUTION: NON-STANDARD AIRFIELD MARKINGS." }, "370": { "remark.id": 370, "remark.ts": "2017-10-24 22:08:52", "remark.value": "WX MEASURING EQUIP ON APCH END RY 02 RIGHT SIDE. MKRS 250' APART ENTIRE LENGTH." }, "371": { "remark.id": 371, "remark.ts": "2017-10-24 22:08:52", "remark.value": "DUE TO TERRAIN; WINDS FROM 070-150 DEG (MAG) MAY BE STRONGER THAN REPORTED WINDS." }, "372": { "remark.id": 372, "remark.ts": "2017-10-24 22:08:52", "remark.value": "DAYLGT OPNS ONLY." }, "373": { "remark.id": 373, "remark.ts": "2017-10-24 22:08:52", "remark.value": "AFTER INITIAL RADIO CONTACT ON FREQ 126.2 OR 121.5 EXPECT A 30 MIN DELAY FOR CURRENT AIRSTRIP CONDITION." }, "375": { "remark.id": 375, "remark.ts": "2017-10-24 22:08:52", "remark.value": "BE ALERT: POSSIBLY LARGE NRS OF 'GLAUCOUS GULLS' MAY BE PRESENT IN THE AREA OF CAPE ROMANZOF LRRS AIRFIELD DURING EARLY TO MID JUNE. ALSO CANADA GEESE, & TUNDRA SWANS DURING MID AUG TO EARLY SEP." }, "376": { "remark.id": 376, "remark.ts": "2017-10-24 22:08:52", "remark.value": "DURING LCL COMMERCIAL & SUBSISTENCE HERRING FISHERY ACTIVITIES, GULLS HAVE BEEN OBSERVED IN HIGH NRS (500-1000) ON THE BEACH BLO THE APCH TO THE RY." }, "377": { "remark.id": 377, "remark.ts": "2017-10-24 22:08:52", "remark.value": "THE INCRD BIRD & GULL ACTIVITY IS IN ADDITION TO THE BIRD ACTIVITIES IN THE RISK ANALYSIS OF WILDLIFE HAZARDS TO ACFT AT CAPE ROMANZOF. DILIGENCE BY ALL PERSONNEL IS RECOMMENDED THROUGHOUT THE SEASON." }, "378": { "remark.id": 378, "remark.ts": "2017-10-24 22:09:05", "remark.value": "RY NOT MAINTAINED; RECOMMEND VISUAL INSPECTION PRIOR TO USING." }, "379": { "remark.id": 379, "remark.ts": "2017-10-24 22:09:38", "remark.value": "ARPT NOT MAINTAINED IN WINTER." } } } }