N816SK
Service difficulty reports · 294
Matched to this aircraft by N-number and event date, checked against the reported serial number, make and model. Newest first.
Query with SQL
duckdb -csv -c "SELECT sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE n_number = 'N816SK' AND registry_match = 'registration' ORDER BY difficulty_date DESC"
Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE n_number = 'N816SK' AND registry_match = 'registration' ORDER BY difficulty_date DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
SDR SWIA2019051545875Striker · chafedPAX DOOR SURROUND STRUCTURE'S LOWER SEAL STRIKER IS CHAFED ON THE OUTBOARD LIP EDGE AT MULTIPLE LOCATIONS, AND HAS CORROSION ALONG THE INBOARD EDGE. (C-CHECK) RO: 05/13/2019 REMOVED AND REPLACED WITH NEW SERVICEABLE LOWER SEAL STRIKER IAW SRM. LEAK CHECK GOOD.SDR SWIA2019051545874Skin · dentedLT INBOARD FLAP UPPER SKIN HAS MULTIPLE DENTS/RIPPLES. (C-CHECK) RO: 05/13/2019 REPAIRED LT IB FLAP UPPER SKIN DENTS IAW SRM.SDR SWIA2018042044570Fadec · failedAPPROXIMTELY 10 KTS PRIOR TO V1, CREW HEARD A LOUD POP, FELT A SLIGHT YAW AND RECEIVED A LEFT ENGINE FLAME OUT CAUTION MESSAGE. ABORTED THE TAKE-OFF AND TAXIED BACK TO GATE. REMOVED AND REPLACED LT FADEC IAW AMM. OPS CHECKED GOOD.SDR SWIA201642149Frame · corrodedFRAME AT FS 847.00+16 REQUIRES REPAIR DUE TO CORROSION. R & R FRAME FS 847.0+16 BETWEEN STGR 25R AND STGR 25L IAW SRM, NO LEAKS NOTED LEAK CHECK GOOD.SDR SWIA201642148Frame · corrodedMAIN AVIONICS BAY LOWER FRAME AT FS 349 REQUIRES REPAIR DUE TO OUT OF LIMITS CORROSION. R & R BS 349 LOWER FRAME WITH NEW FRAME IAW REO. LEAK CHECK GOOD.SDR SWIA201642147Frame · corrodedMAIN AVIONICS BAY LOWER FRAME AT BS 333 HAS OUT OF LIMITS CORROSION. R & R THE FRAME IAW REO, LEAK CHECKED GOOD.SDR SWIA201642146Frame · corrodedMAIN AVIONICS BAY LOWER FRAME AT BS 319 HAS OUT OF LIMITS CORROSION. R & R THE FRAME IAW REO, LEAK CHECKED GOOD.SDR SWIA201642145Frame · corrodedMAIN AVIONICS BAY LOWER FRAME AT FS 295 HAS OUT OF LIMITS CORROSION. R & R THE FRAME SECTION IAW REO. LEAK CHECKED GOOD, NO LEAKS NOTED.SDR SWIA201642144Frame · corrodedMAIN AVIONICS BAY LOWER FRAME AT FS310 HAS OUT OF LIMITS CORROSION. R & R LOWER FRAME AT FS 310 WITH NEW FRAME AT FS 310 IAW REO, LEAK CHECK GOOD.SDR SWIA201642150Skin · chafedINBD FLAP L/E PANEL 684EB CHAFED. REPAIRED IAW SRM.SDR SWIA201540993Scuff Plate · dentedDENT BELOW THE AFT CARGO DOOR ON THE SCUFF PLATE. R & R SCUFF PLATE. NO DAMAGE TO FUSELAGE.SDR SWIA201540901Windshield · failedLT WINDOW HEAT CAUSE A SMOKE ODOR IN COCKPIT. R & R LT WINDSHIELD IAW AMM.SDR SWIA201439906Relay · failedEMERGENCY LIGHTS KEPT CYCLING ON AND OFF. R & R K-135 ON JB11, PCB5 IAW AMM. OPS CHECKED GOOD.SDR SWIA201438814Battery Pack · inoperativeAFT F/A FLASHLIGHT INOPERATIVE. R & R BATTERY IAW AMM.SDR SWIA201438655Light · crackedLEFT FORWARD GALLEY EMERGENCY LIGHT CRACKED. R & R LT FORWARD GALLEY EMERGENCY LIGHT IAW AMM.SDR SWIA201438048Bulb · burned outFWD STORAGE FLOOR LEVEL EMERGENCY FLOODLIGHT HAS BURNED OUT BULB. C-CHECK, REMOVED AND INSTALLED NEW BULBS IAW ESPM AND AMM.SDR SWIA201438047Lens · crackedEMERGENCY LIGHT LENS CRACKED ON FWD STORAGE BULKHEAD. C-CHECK, REMOVED CRACKED EMERGENCY LIGHT LENS BY UNSNAPPING FROM RECEPTACLE AND REPLACED BY SNAPPING A NEW EMER LIGHT LENS ONTO RECEPTACLE.SDR SWIA201438046Bulb · inoperativeGALLEY EMERGENCY LIGHT LENS COVER CRACKED AND HAS BURNED OUT BULBS. C-CHECK, REMOVED GALLEY NR 1 EMERGENCY LIGHT COVER BY UNSNAPPING FROM RECEPTACLE, REMOVED BURNED OUT BULBS, 2 EA, AND INSTALLED NEW BULBS BY SLIDING PINS INTO SOCKETS AND SNAPPED NEW EMERGENCSDR SWIA201438049Drag Angle · corrodedPAX DOOR FWD DRAG ANGLE CORRODED. C-CHECK, REMOVED DAMAGED PORTION OF PAX DOOR FWD DRAG ANGLE AND INSTALLED NEW FABRICATED PARTS IAW SRM AND EA.SDR SWIA201438055Seat Track · corrodedLEFT SIDE SEAT TRACK CORRODED. C-CHECK, REMOVED CORROSION IAW REO.SDR SWIA201438054Seat Track · corrodedRIGHT SIDE SEAT TRACK CORRODED. C-CHECK, REMOVED CORROSION IAW REO.SDR SWIA201438053Seat Track · corrodedLEFT SIDE SEAT TRACK CORRODED. C-CHECK, REPLACED SEAT TRACK IAW SRM.SDR SWIA201438052Seat Track · corrodedRT SIDE SEAT TRACK CORRODED. C-CHECK, BS 785.15 - 847 SEAT TRACK REPLACED WITH A NEW IAW AMM.SDR SWIA201438051Seat Track · corrodedLEFT SIDE SEAT TRACK HAS CORROSION IN TWO LOCATIONS. C-CHECK, REMOVED CORROSION IAW REO.SDR SWIA201438050Seat Track · corrodedRT SIDE SEAT TRACK HAS CORROSION IN TWO LOCATION. C-CHECK, REMOVED CORROSION FROM RT SIDE SEAT TRACK IAW REO.SDR SWIA201438060Floorbeam · corrodedBS 280 FLOORBEAM TOP STRAP HAS SIGNS OF CORROSION AND DELAMINATION. C-CHECK, R & R FLOORBEAM TOP STRAP IAW SRM AND REO.SDR SWIA201438059Floorbeam · corrodedAFT COCKPIT FLOORBEAM ANGLE HAS SIGNS OF CORROSION BS 280. C-CHECK, R & R FLOORBEAM ANGLE IAW SRM.SDR SWIA201438058Drag Angle · crackedCRACK ON PAX DOOR AFT DRAG ANGLE. C-CHECK, REMOVED AND REPACED.SDR SWIA201438057Web · corrodedTHE PASSENGER DOOR FWD SIDE WEB IS CORRODED AT THE UPPER DOOR OPEN, HAND RAIL ATTACH POINT. C-CHECK, REPAIRED PAX DOOR FWD SIDE WEB IAW EA.SDR SWIA201438056Former · corrodedPAX DOOR FWD FORMER HAS CORROSION AROUND TENSION BAR. C-CHECK REMOVED CORROSION AS REQUIRED IAW EA.SDR SWIA201438061Retainer · corrodedMAIN AVIONICS COMPARTMENT DOOR, SEAL RETAINER SHOWS SIGNS OF CORROSION. C-CHECK, REPLACED SEAL RETAINER IAW SRM.SDR SWIA201436343Service Door · out of adjustAIRCRAFT BUFFETING EXPERIENCED IN DESCENT BETWEEN 320 KIAS & 330 KIAS. BUFFETING CONTINUED WITH THE THROTTLES AT IDLE UNTIL WE DECELERATED THROUGH 320 KTS. AIRCRAFT WAS EMPTY, NO PASSENGERS & NO BAGS 4500 LBS FUEL. FLT 4863 ADJUSTED FUEL DOOR AS NEEDED. ALSDR SWIA201436341Door · lack of lubeMAIN CABIN DOOR WILL NOT OPEN FORM EITHER INSIDE OR OUTSIDE. FLT 4477 LUBED PASSENGER DOOR IAW AMM.SDR SWIA201334735Smoke Detector · faultySMOKE IN AFT LAVATORY ON DESCENT INTO SLC. NO SMOKE OBSERVED. FLT#4467 REPLACED SMOKE DETECTOR.SDR SWIA201333439Light · inoperativeAFT MOST EXTERIOR EMERGENCY LIGHT IS BURNED OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201332803Beam · cracked280 BEAM CRACKED BOTH SIDES. (C-CHECK) CW 280 BEAM REPLACEMENT (BOTH SIDES) IAW REO.SDR SWIA201232140Light · inoperativeEMERGENCY EXIT LIGHT AT FLOOR LEVEL IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201231682Spherical Bearin · corrodedRIGHT ENGINE FORWARD MOUNT YOKE ASSEMBLY SPHERICAL BEARING HAS PITTING CORROSION. (SERVICE) REPLACED RIGHT ENGINE FORWARD YOKE MOUNT IAW AMM.SDR SWIA201231681Spherical Bearin · corrodedRIGHT ENGINE FORWARD MOUNT YOKE LINK SPHERICAL BEARING HAS PITTING CORROSION. (SERVICE) REPLACED RIGHT ENGINE FORWARD MOUNT YOKE LINK IN REFERENCE TO AMM.SDR SWIA201231680Fitting · corrodedRIGHT ENGINE AFT MOUNT THRUST FITTING HAS CORROSION. (SERVICE) REPLACED RIGHT ENGINE AFT MOUNT THRUST FITTING IAW AMM.SDR SWIA201231415Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 18 IS OUT. (FLT 4582) RELAMPED EMERGENCY LIGHT.SDR SWIA201231053Light · inoperativeLAST ROW OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4608) RELAMPED EMERGENCY LIGHT.SDR SWIA201231052Light · inoperativeNR 6 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4771) RELAMPED EMERGENCY LIGHT.SDR SWIA201230951Acm · faultyLEFT AIR CONDITIONING PACK CAUSING BURNING SMELL. (FLT 4455) REPLACED LEFT ACM IN REFERENCE TO MM. P/N: GG670-95009-3, S/N OFF: 01077.SDR SWIA201230847Light · inoperativeNR 2 AND NR 7 OVERHEAD EMERGENCY LIGHTS ARE OUT. (FLT 4525) RELAMPED EMERGENCY LIGHTS.SDR SWIA201230705Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 13 AB IS OUT. (FLT 4662) RELAMPED EMERGENCY LIGHT.SDR SWIA201230677Light · inoperativeNR 7 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4464) RELAMPED EMERGENCY LIGHT.SDR SWIA201229734Light · inoperativeNR 1 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4536) RELAMPED EMERGENCY LIGHT.SDR SWIA201229561Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 14 IS OUT. (FLT 4703) RELAMPED EMERGENCY LIGHT.SDR SWIA201229371Light · inoperativeAFT OVERHEAD EMERGENCY LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.
Back to N816SK