N817SK
Service difficulty reports · 223
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 = 'N817SK' 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 = 'N817SK' 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 SWIA201439309Rib · gougedVERTICAL STABILIZER RIB, HAS A GOUGE ON THE TOP SURFACE BEHIND L/E PANEL. BLENDED DAMAGE TO SMOOTH CONTOUR AND FOUND TO BE WITHIN LIMITS. NDT REPORTED NO DEFECTS. ROTO PEENED TO 200 PERCENT INTENSITY AND RESTORED THE FINISH. WORK DONE IAW EA.SDR SWIA201439308Seat Track · corrodedRT CENTER SEAT TRACK RBL 9, HAS CORROSION. BLENDED DAMAGED AREA AND FOUND TO BE WITHIN LIMITS IAW REO.SDR SWIA201439307Seat Track · gougedLEFT CENTER SEAT TRACK LBL 9, IS GOUGED. BLENDED DAMAGED AREA AND IS WITHIN LIMITS IAW REO.SDR SWIA201439306Seat Track · corrodedRIGHT SEAT TRACK RBL 9, HAS CORROSION IN TWO MAJOR LOCATIONS. BLENDED DAMAGED AND FOUND NOT WITHIN LIMITS IAW REO. REPLACED THE SEAT TRACK.SDR SWIA201439305Skin · chafedRIGHT AILERON CHAFED. REMOVED DAMAGE FROM LT AILERON TOPSIDE IAW SRM AND FOUND TO BE WITHIN LIMITS AND RESTORED FINISH IAW REO.SDR SWIA201439304Seat Track · corrodedRIGHT SEAT TRACK HAS CORROSION BETWEEN BS 743 - 763. BLENDED CORROSION AND WAS FOUND TO BE WITHIN LIMITS IAW REO.SDR SWIA201439303Seat Track · corrodedRIGHT SEAT TRACK CORRODED BS 784 - 847+14. BLENDED CORROSION AND WAS FOUND TO BE OUT OF LIMITS IAW REO. SEAT TRACK REPLACED.SDR SWIA201439302Seat Track · corrodedLEFT SEAT TRACK CORRODED BS 672 - 722. BLENDED CORROSION AND FOUND WITHIN LIMITS IAW REO.SDR SWIA201439301Seat Track · corrodedLEFT SEAT TRACK CORRODED BS 907 - 986. BLENDED CORROSION AND FOUND WITHIN LIMITS IAW REO.SDR SWIA201439300Seat Track · corrodedLEFT SEAT TRACK CORRODED BS 890. BLENDED CORROSION AND FOUND WITHIN LIMITS IAW REO.SDR SWIA201439299Seat Track · corrodedLEFT SEAT TRACK CORRODED BS 784 - 847+14. BLENDED CORROSION AND FOUND WITHIN LIMITS IAW REO:SDR SWIA201439298Seat Track · corrodedLEFT SEAT TRACK CORRODED BS 743 - 763. BLENDED CORROSION AND FOUND WITHIN LIMITS IAW REO.SDR SWIA201439297Seat Track · corrodedRT SIDE SEAT TRACK CORRODED BS 672 - 722. FOUND TO BE OUT OF LIMITS IAW REO. REPLACED THE SEAT TRACK IAW AMM.SDR SWIA201439296Stringer · crackedFWD END OF STRINGER 3L CRACKED AT BS 281. REPAIRED THE STRINGER IAW REO SB 67BA-53-040 .SDR SWIA201439295Retainer · damagedCENTER BAGGAGE BAY DOOR, THE LOWER FWD AND AFT SECTIONS OF THE SEAL RETAINER ARE DAMAGED, MARKED W/GREEN TAPE. REPAIRED CENTER BAGGAGE BAY DOOR, THE LOWER FWD AND AFT SECTIONS OF THE SEAL RETAINER. PERMANENT REPAIR "DENTS" STEPS 1 THRU 4. (2014NM060066)SDR SWIA201439294Floorbeam · damagedBS 280 FLOORBEAM CORRODED AND CRACKED. REPAIRED THE FLOORBEAM IAW REO.SDR SWIA201436647Battery · dischargedEMERGENCY LIGHTS DO NOT ILLUMINATE. FLT 4731 CHARGED EMERGENCY LIGHTS.SDR SWIA201334021Light · inoperativeEMERGENCY OVERHEAD LIGHT SECOND FROM REAR IS BURNED OUT. FLT#4611 RELAMPED.SDR SWIA201333739Light · inoperativeSECOND TO LAST EMERGENCY OVERHEAD LIGHT IS BURNED OUT. FLT#4745 RELAMPED.SDR SWIA201333244Unknown · malfunctionedESTABLISHED ON FINAL, FULLY CONFIGURED AT THE FINAL APPROACH FIX, THE FLIGHT DIRECTOR SWITCHED OVER TO B/C MODE & PITCH MODE. THE AIRCRAFT TURNED 15° TO THE RIGHT. PILOT DISCONNECTED THE AUTO PILOT AND FLEW THE REST OF THE APPROACH. (FLT 4474) PERFORMED FSDR SWIA201332969Light · inoperativeEMERGENCY OVERHEAD LIGHT AFT OF OVERWING EXITS DOES NOT ILLUMINATE. (FLT 4645) RELAMPED EMERGENCY LIGHT.SDR SWIA201332879Axle · corrodedNR 4 MLG AXLE ROOT IS CORRODED. (C-CHECK) REPAIRED NR 4 MLG AXLE ROOT RADIUS IAW REO.SDR SWIA201332878Axle · corrodedNR 3 MLG AXLE ROOT IS CORRODED. (C-CHECK) REPAIRED NR 3 MLG AXLE ROOT RADIUS IAW REO.SDR SWIA201332877Axle · corrodedNR 2 MLG AXLE ROOT IS CORRODED. (C-CHECK) REPAIRED NR 2 MLG AXLE ROOT RADIUS IAW REO.SDR SWIA201332876Axle · corrodedNR 1 MLG AXLE ROOT IS CORRODED. (C-CHECK) REPAIRED NR 1 MLG AXLE ROOT RADIUS IAW REO.SDR SWIA201332875Beam · crackedFS 274 RBL 13 BEAM CRACKED AT DIAGONAL. (C-CHECK) REPLACED FS 274 RBL 12 BEAM IAW REO.SDR SWIA201332874Beam · crackedFS 280 BEAM CORRODED AND CRACKED. (C-CHECK ) REPAIRED FS 280.00 BEAM IAW REO.SDR SWIA201232190Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 14 IS OUT. (FLT 4487) RELAMPED EMERGENCY LIGHT.SDR SWIA201232065Light · inoperativeREAR EMERGENCY OVERHEAD LIGHT BURNED OUT. (FLT 4474) RELAMPED EMERGENCY LIGHT.SDR SWIA201231896Light · inoperativeFLOOR LEVEL EMERGENCY EXIT SIGN AT ROW 12A AND 12D EACH HAVE A LIGHT OUT. (FLT 4678) RELAMPED EMERGENCY LIGHTS.SDR SWIA201231842Light · inoperativeAFT OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4521) RELAMPED EMRGENCY LIGHT.SDR SWIA201231757Light · inoperativeTWO OVERHEAD EMERGENCY LIGHTS ARE OUT AT ROW 13 AND 19. (FLT 4356) RELAMPED EMERGENCY LIGHTS.SDR SWIA201231599Light · inoperativeLIGHT BULB IN EXIT SIGN AT SERVICE DOOR IS OUT. (FLT 4469) RELAMPED EXIT SIGN.SDR SWIA201231028Light · inoperativeNR 2 OVERHEAD EMERGENCY LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201230959Light · inoperativeOVERHEAD EMERGENCY LIGHT AT AISLE 17 IS OUT. (FLT 4596) RELAMPED EMERGENCY LIGHT.SDR SWIA201230650Actuator · failedMAIN CABIN DOOR HANGS UP, BOTH OPENING AND CLOSING. (FLT 4455) REPLACED PASSENGER DOOR ACUTATOR ASSEMBLY AND CABLE IN REFERENCE TO AMM. PN OFF: 601R94556-3 SN OFF A1098SDR SWIA201230446Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 14 IS OUT. (FLT 4479) RELAMPED EMERGENCY LIGHT.SDR SWIA201230243Light · inoperativeFLOOR LEVEL EMERGENCY LIGHT NEAR MAIN CABIN DOOR IS OUT. (FLT 4846) RELAMPED EMERGENCY LIGHT.SDR SWIA201229993Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 3 IS OUT. (FLT 4638) RELAMPED EMERGENCY LIGHT.SDR SWIA201229735Light · inoperativeFORWARD FLOOR LEVEL EMERGENCY LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201229227Light · inoperativeAFT OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4820) RELAMPED EMERGENCY LIGHT.SDR SWIA201128802Light · inoperativeNR 6 EMERGENCY CEILING LIGHT INOPERATIVE. (FLT 4619) RELAMPED EMERGENCY LIGHT.SDR SWIA201128136Light · inoperativeOVERHEAD EMERGENCY LIGHTS ABOVE ROWS 14 & 20 ARE OUT. (FLT 4797) RELAMPED EMERGENCY LIGHTS.SDR SWIA201128076Light · inoperativeNR 1 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4606) RELAMPED EMERGENCY LIGHT.SDR SWIA201127879Light · inoperativeOVERHEAD EMERGENCY LIGHTS ARE OUT AT ROWS 14 AND 18. (FLT 4813) RELAMPED EMERGENCY LIGHTS.SDR SWIA201127672Light · inoperativeAFT OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4663) RELAMPED EMERGENCY LIGHT.SDR SWIA201127648Light · inoperativeAFT & 3RD TO AFT CEILING EMERGENCY LIGHTS ARE OUT. (SERVICE) RELAMPED EMERGENCY LIGHTS.SDR SWIA201127414Light · inoperativeNR 1 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4723) RELAMPED EMERGENCY LIGHT.SDR SWIA201127057Light · inoperativeNR 7 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4583) RELAMPED EMERGENCY LIGHT.SDR SWIA201127058Light · inoperativeNR 1 OVERHEAD EMERGENCY LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.
Back to N817SK