JASC 5347
Service difficulty reports · 66,435
Reports filed under 5347 · Fuselage, Seat/Cargo Attach Fittings, 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 jasc_code = '5347' 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 jasc_code = '5347' 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 CALA0300535Cargo Track · damagedINSPECTION FOUND IMPACT DAMAGE TO AFT BAGGAGE BIN LT TIE DOWN RAIL AT BS 787. REPLACED TIE DOWN RAIL IAW SRM 53-00-53.SDR 2004F00132Seat Track · corrodedAT C-CHECK, FOUND SEAT TRACK CORRODED BETWEEN FRAMES 20 AND 21 AT RBL 32. REMOVED AND REPLACED SEAT TRACK FROM RBL 32, FRAME 12 TO 24. (M)SDR AWXA200301099Seat Track · corrodedDURING C-07 CHECK CORROSION WAS FOUND ON LT DUMMY RAIL AFT OF FR 66 AT FLIGHT ATTENDANT SEAT ATTACH HOLE. MAINTENANCE REMOVED CORROSION AND FOUND MATERIAL LOSS TO BE OUT OF LIMITS; REMOVED LT DUMMY RAIL AFT OF FR 66; RECEIVED NEW REPLACEMENT DUMMY RAIL; INSTALSDR IXXA060580SSeat Track · gougedDURING ROUTINE C CHECK, FOUND SEAT TRACK "F" GOUGED FROM STATION 1390 TO STATION 1455. REMOVED GOUGED SEAT TRACK. FABRICATED, DRILLED, TRIMMED, TREATED, PRIMED, AND INSTALLED NEW SEAT TRACK IAW DC8 SRM 51-1-8, 53-2-3, AND 51-3-0.SDR IXXA060577SSeat Track · brokenDURING ROUTINE C CHECK, FOUND SEAT TRACK "B" TANG BROKEN AT STATION 260. REMOVED DAMAGED SEAT TRACK. FABRICATED, DRILLED, TRIMMED, TREATED, PRIMED, AND INSTALLED NEW SEAT TRACK IAW DC8 SRM 51-1-8, 53-2-3, AND 51-3-0.SDR IXXA060576SSeat Track · wornDURING ROUTINE C CHECK, FOUND SEAT TRACK "G" WORN AT STATION 670. REMOVED WORN SEAT TRACK. FABRICATED, DRILLED, TRIMMED, TREATED, PRIMED, AND INSTALLED NEW SEAT TRACK IAW DC8 SRM 51-1-8, 53-2-3, AND 51-3-0.SDR IXXA060535SSeat Track · gougedDURING ROUTINE C CHECK, FOUND SEAT TRACK "F" GOUGED AT STATION 830. REMOVED DAMAGED SEAT TRACK SECTION. FABRICATED NEW SEAT TRACK SECTION AND SPLICES, LOCATED, DRILLED, TRIMMED, TREATED, PRIMED, AND INSTALLED NEW SEAT TRACK SECTION AND SPLICES IAW DC8 SRM 51SDR IXXA060534SSeat Track · gougedDURING ROUTINE C CHECK, FOUND SEAT TRACK "F" GOUGED AT STATION 860. REMOVED DAMAGED SEAT TRACK SECTION. FABRICATED SEAT TRACK SECTION, AND SPLICES, LOCATED, DRILLED, TRIMMED, TREATED, PRIMED, AND INSTALLED NEW SEAT TRACK SECTION, AND SPLICES IAW DC8 SRM 51-1SDR GAIA03083Seat Track · corrodedDURING B-2 CHECK, FOUND MAIN CABIN SEAT TRACK CORRODED AT BS 344 TO BS 360, RBL 45.5. REF FASI N/R 50403. FABRICATED REPAIR FROM BAC 1520-792 MATERIAL. LENGTH 14 INCHES REPAIRED IAW B727 SRM 53-10-05, FIGURE 7 AND 53-10-2, FIGURE 7. (M)SDR GAIA03103Seat Track · corrodedDURING B-2, FOUND MAIN CABIN SEAT TRACK CORRODED BS 360 BL0. ERF FASI N/R 53268, REPLACED SEAT TRACK BS 344-480 BL 0 PER B727 SRM 53-10-5 FIG 7. (M)SDR GAIA03102Seat Track · corrodedDURING B-2 CHECK, FOUND MAIN CARGO SEAT TRACK CORRODED BS 360, LBL 25.5. REF FASI N/R 53267, REPLACED SEAT TRACK LBL 25.5 BS 344 TO 480 PER B727 SRM 53-10-2 FIG 7 AND 53-10-5 FIG 7. (M)SDR GAIA03101Seat Track · corrodedDURING B-2 CHECK, FOUND MAIN CARGO SEAT TRACK CORRODED AT BS 760, RBL 45.5. REF FASI N/R 53265, REPLACED SEAT TRACK RBL 45.5, BS 760 TO 840 PER B727 SRM 51-30-2. (M)SDR GAIA03082Seat Track · corrodedDURING B-2 CHECK, FOUND MAIN CABIN SEAT TRACK CORRODED AT BS 360 TO BS 344, RBL 25.5. REF FASI N/R 50402, FABRICATED REPAIR FROM BAC 1520-792 MATERIAL. LENGTH 140 INCHES REPAIRED IAW B727 SRM 53-10-5, FIGURE 7 AND 53-10-2, FIGURE 7. (M)SDR ASOA03449Floorbeam · corrodedDURING A C-CHECK IN MC, THE LEFT AND RIGHT 9.00 AND 27.00 FLOORBEAMS BETWEEN FS 280.00 AND FS 409.00 PLUS 5.00 IAW ASA EO 600-53-0052A. (M)SDR C1HA200386014Seat Track · corrodedAFT CABIN SEAT TRACK IS CORRODED AT BS 1034 LBL 25SDR IXXA060575SSeat Track · gougedDURING ROUTINE C CHECK, FOUND SEAT TRACK "B" GOUGED AT STATION 244. REMOVED GOUGED SEAT TRACK. FABRICATED, DRILLED, TRIMMED, TREATED, PRIMED, AND INSTALLED NEW SEAT TRACK IAW DC8 SRM 51-1-8, 53-2-3, AND 51-3-0.SDR IXXA060574SSeat Track · brokenDURING ROUTINE C CHECK, FOUND SEAT TRACK "B" TANG BROKEN AT STATION 240. REMOVED DAMAGED SEAT TRACK. FABRICATED, DRILLED, TRIMMED, TREATED, PRIMED, AND INSTALLED NEW SEAT TRACK IAW DC8 SRM 51-1-8, 53-2-3, AND 51-3-0.SDR IXXA060572SSeat Track · gougedDURING ROUTINE C CHECK, FOUND SEAT TRACK "E" GOUGED AT STATION 150. REMOVED GOUGED SEAT TRACK. FABRICATED, DRILLED, TRIMMED, TREATED, PRIMED, AND INSTALLED NEW SEAT TRACK IAW DC8 SRM 51-1-8, 51-1-21, 53-2-3, AND 51-3-0.SDR IXXA060538SSeat Track · brokenDURING ROUTINE C CHECK, FOUND SEAT TRACK "D" TANG BROKEN AT STATION 150. FABRICATED REPAIR PARTS, LOCATED, DRILLED, TRIMMED, TREATED, PRIMED, AND INSTALLED NEW REPAIR PARTS IAW DC8 SRM 53-2-3, 51-1-8, AND 51-1-21.SDR C1HA200386012Seat Track · corrodedCORROSION ON SEAT TRACK BS 1130 LBL 25.SDR C1HA200386011Seat Track · corrodedSEAT TRACK CORRODED BS 1090/1130 RBL 25.SDR C1HA200386010Seat Track · corrodedLITE CORROSION ON SEAT TRACK BS 990-1030 LBL 22.SDR C1HA200386009Seat Track · gougedSEAT TRACK GOUGED AND SCRATCHED AT BS 344 RBL 50.SDR C1HA200386008Seat Track · corrodedCORROSION AROUND SEAT TRACK FASTENERS AT BS 420-480 RBL 50.SDR GTIA030701Seat Track · corrodedFTW - FOUND FORWARD CABIN, STATION 200, LBL 22 INCHES HAS CORROSION AT SUPPORT END FITTING INBOARD SEAT TRACK ATTACH. REMOVED TRACK STATION 200 TO 234. FABRICATED NEW TRACK. FABRICATED ATTACH FITTING. INSTALLED NEW TRACK AND ATTACH FITTING. (M)SDR AWXA200301070Seat Track · corrodedDURING C-04 CHECK EXFOLIATION CORROSION WAS FOUND ON UPPER SURFACE OF Y1292 SEAT TRACK AT FR 66. MAINTENANCE REMOVED CORROSION AND FOUND MATERIAL LOSS TO BE OUT OF LIMITS. REMOVED CORRODED Y1292 SEAT TRACK FR 64-66; FABRICATED A NEW REPLACEMENT SEAT TRACK; ISDR 03FDEA01537Cargo Track · wornMAIN DECK CARGO COMPARTMENT , CARGO TRACK AT STA 755, X = 47 INCHES FOUND CROWN WORN.SDR C1HA200386007Seat Track · corrodedBS 480 LBL 25 SEAT TRACK HAS CORROSION AROUND FASTENER.SDR GTIA030803Seat Track · corrodedFOUND SEAT TRACKS LEFT STA 826 TO 1307 BARE METAL, NICKS LIGHT CORROSION, ALL THREE TRACKS. REMVOED OUTBOARD SEAT TRACK STA 826-1307 LOCATED AND DRILLED OUTBOARD SEAT TRACK AND LOCATED AND DRILLED SPLICES INSTALLED OUTBOARD SEAT TRACK AND SPLICES. REMOVED INSDR GTIA030804Seat Track · corrodedFOUND SEAT TRACKS RIGHT STA 200-826 BARE METAL, NICKS LIGHT CORROSION. SEAT TRACKS COMMON TO RBL 22 & 54 FROM STA 200-826 OUT OF LIMITS. REMOVED OUTBOARD SEAT TRACK RBL 54 FROM STA 200-826. REMOVED INBOARD SEAT TRACK RBL 22 FROM STA 200-826. FABBED SEAT TRSDR GTIA030810Seat Track · corrodedFOUND SEAT TRACKS RIGHT STATION 826 TO STATION 1307 BARE METAL, NICKS, LIGHT CORRODED, ALL THREE TRACKS. SEAT TRACK RBL 22 AND RBL 54 FROM 826 TO 1307 IS OUT OF LIMITS. REMOVED OUTBOARD SEAT TRACK STATION 826 TO 1307 RBL 54. REMOVED SEAT TRACK STATION 200 TOSDR GTIA030855Seat Track · corrodedFTW - FOUND SEAT TRACKS LEFT STATION 200 TO STATION 826 BARE METAL, NICKS, LIGHT CORRODED. INBOARD SEAT TRACK LBL 24 STATION 226-826 OUT OF LIMITS. OUTBOARD SEAT TRACK LBL 54 STATION 465-826 OUT OF LIMITS. REMOVED DAMAGED SEAT TRACK LBL 54 STATION 200-826. SDR AWXA200301084Seat Track · corrodedDURING C-04 CORROSION WAS FOUND ON THE FORWARD OUTBOARD END OF THE RT OUTBOARD SEAT TRACK AT FR 20. MAINTENANCE REMOVED CORROSION AND FOUND MATERIAL LOSS TO BE OUT OF LIMITS; REMOVED DAMAGED SEAT TRACK FROM FS 6053 TO FS 9766, Y1292; FABRICATED A NEW REPLACESDR IXXA060592SSeat Track · wornDURING ROUTINE C CHECK, FOUND CAPTAINS LEFT FORWARD SEAT TRACK WORN. REMOVED WORN SEAT TRACK. FABRICATED, DRILLED, TRIMMED, TREATED, PRIMED, AND INSTALLED NEW SEAT TRACK IAW DC8 SRM 51-1-8, 51-1-21, AND 51-3-0.SDR IXXA060567SSeat Track · wornDURING ROUTINE C CHECK, FOUND CAPTAINS RIGHT FORWARD SEAT TRACK WORN. REMOVED WORN SEAT TRACK. FABRICATED, DRILLED, TRIMMED, TREATED, PRIMED, AND INSTALLED NEW SEAT TRACK IAW DC8 SRM 51-1-21, AND 51-3-0.SDR 03FDEA01463Cargo Track · crackedMAIN DECK CARGO COMPT. FLOOR TRACK AT STA 635, X = -8.5 FOUND CRACKED, APPROX. 3 INCHES LONG.SDR 03FDEA01464Cargo Track · crackedMAIN DECK CARGO COMPT. FLOOR TRACK AT STA 635, X = 27.5 FOUND CRACKED APPROX. 3 INCHES LONG.SDR ASOA03444Seat Track · corrodedDURING A C-CHECK IN BNA, THE LEFT AND RIGHT SEAT TRACKS AT FS 36 TO FS 39 WERE FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE LEFT AND RIGHT SEAT TRACKS AT FS 36 TO FS 39 IAW SRM 51-25-02. (M)SDR ASOA03445Seat Track · corrodedDURING A C-CHECK IN BNA, THE LEFT SEAT TRACK AT FS 39 TO FS 41 WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE LEFT SEAT TRACK AT FS 39 TO FS 41 IAW SRM 51-25-02. (M)SDR ASOA03446Seat Track · corrodedDURING A C-CHECK IN BNA, THE RT SEAT TRACK AT FS 39 TO FS 40 WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE RIGHT SEAT TRACK AT FS 39 TO FS 40 IAW SRM 51-25-02. (M)SDR UPS03441234Cargo Track · corrodedBS 554 RBL 46 TIE DOWN TRACK LT FLANGE CORRODED. CORROSION REMOVED IAW SRM 51-10-01. CORROSION BLEND OUT 0.045 X 1 X 3 EXCEED SRM 53-10-01 FIG 1 LIMITS , FOR REPAIR REFER TO SRM FIG 53-10-05 FIG 6. CIC APPLIED IAW EO M-5100-2780-ESDR GTIA030698Seat Track · corrodedFTW - FOUND SEAT TRACKS LEFT INBOARD FROM STATION 1079-1174, STATION 1212-1250, STATION 1271-1309, CORRODED. REMOVED SEAT TRACK FROM STATION 1079 TO 1309. FABRICATED NEW TRACK. INSTALLED NEW TRACK. DRILLED AND LOCATED NEW SPLICES STATION1070, 1130 AND 1220SDR 03FDEA01433Seat Track · wornMAINDECK - SEAT TRACK AT STA 1701, LBL 47 FOUND WORN. MAINDECK - SEAT TRACK AREA SMOOTHEN BY HAND CLEAN AS PER SRM 51-21- 01 VOL. 2 FOUND WITH IN LIMIT AS PER SRM 53-70-00 VOL. 1.SDR UPS03441235Cargo Track · corrodedINSPECTION TYPE: C, BS 500 - 520 RBL 46 TIE DOWN TRACK RT FLANGE CORRODED. CORROSION REMOVED IAW SRM 51-10-01. CORROSION BLEND OUT 0.040 X 1 X 10 EXCEED SRM 53-10-01 FIG 1 LIMITS FOR REPAIR REFER TO SRM FIG 53-10-05 FIG 6. CIC APPLIED IAW EO M5100-2780-ESDR UPS03441232Cargo Track · corrodedINSPECTION TYPE: C U/D, BS 480 - 500 RBL 65 TIE DOWN TRACK LT FLANGE CORRODED. CORROSION BLEND OUT 0.045 INCH X 1 INCH X 12 INCH EXCEED SRM 53-10-01 FIG 1 LIMITS. CORROSION REMOVED IAW SRM 51-10-01. SEAT TRACK REPAIRED REFER TO SRM 53-10-05 FIG 6. CIC APPSDR CALA0300513Cargo Track · corrodedINSPECTION FOUND LT TIE DOWN RAIL CORRODED AT FASTENERS ON LOWER SURFACE AT STA 947 IN THE AFT CARGO COMPARTMENT. THE TIE DOWN RAIL WAS REMOVED AND REPLACED IAW SRM 53-00-53.SDR GTIA030697Seat Track · corrodedFTW - FOUND RIGHT INBOARD SEAT TRACK NUMEROUS AREAS OF CORROSION, GOUGES AND BARE METAL FROM STATION 210-207. (M)SDR GTIA030692Seat Track · corrodedFTW - FOUND SEAT TRACKS RIGHT OUTBOARD BETWEEN STATION 927-1003, STATION 1022-1098, STATION 1098-1155, STATION 1174-1250, STATION 1271-1309 CORRODED. REMOVED SEAT TRACK RIGHT OUTBOARD STATION 927-1309. FABRICATED NEW SEAT TRACK. INSTALLED NEW SEAT TRACK. (SDR UPS03441264Seat Track · corrodedINSPECTION TYPE: C, M/D SEAT TRACK FOUND CORRODED AT SEVERIAL LOCATIONS AS MARKED. REF WAN NR 796157. CORROSION BLEND OUT 0.039 INCH X 1 INCH X 4 INCHES EXCEED SRM 53-10-01 FIG 1 LIMITS, CORROSION REMOVED IAW SRM 51-10-01 AND SEAT TRACK REPAIRED REFER TO SRSDR ASOA03454Seat Track · corrodedDURING A C-CHECK IN MCN, THE FORWARD LONG SEAT TRACKS AT LBL 9 AND RBL 9 WERE FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE FORWARD LONG SEAT TRACKS AT LBL 9 AND RBL 9 IAW WITH SRM 51-00. (M)
Back to JASC 5347