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 QXEA0001437Seat Track · damagedPDX- RIGHT HAND SEAT TRACK HAS IMPACT DAMAGE ALONG RUNNER GROOVE AFT OF FORWARD EDGE OF SEAT TRACK. REPAIRED IAW FOKKER SRM 51-10-04 AND FOKKER MM 53-40-01, PAGE 202.SDR CALA0000805Seat Track · corrodedINSPECTION FOUND LEFT O/B SEAT TRACK CORRODED AT STA 1155 - 1309. THE SEAT TRACK WAS REMOVED AND A NEW SEAT TRACK WAS INSTALLED IAW SRM 51-30-1, 51-30-2, 51-10-4, AND 53-30-5.SDR CALA0000796Cargo Track · corrodedINSPECTION FOUND AFT CARGO RT TIE DOWN TRACK CORRODED BETWEEN FS 1007 AND 1155. THE TIE DOWN TRACK WAS REMOVED AND REPLACED IAW SRM 51-30-05 AND 53-05, FIGURE 46.SDR CALA0000794Galley Track · corrodedINSPECTION FOUND G-2 GALLEY SUPPORT CORRODED AT FS 209, RBL 14. THE SUPPORT WAS REMOVED AND A NEW SUPPORT WAS INSTALLED IAW SRM 51-10-4, 51-10-3, AND 51-10-5.SDR ASAA0080352Seat Track · corrodedPHX: DURING 30K CHECK CORROSION WAS FOUND SEAT TRACK, FS 200 TO 237, RBL 45.REMOVED AND REPLACED SEAT TRACK SECTION IAW DC9 SRM 53-05, FIG 4.SDR AALA20001014Seat Track · wornTUL - FOUND NR 4 SEAT TRACK EDGES WORN. INSTALLED REPAIR PLUG PER AARD 53-20-00-10 PAGE 1. (M)SDR USAA000773Galley Track · corrodedCLT - FOUND GALLEY FLOOR FITTING CORRODED 1.5 INCH BY 3.5 INCH, STATION 371, RBL 10.5. INSTALLED GALLEY MOUNT PER BOEING DWG 141N5160. (M)SDR F3LA00113Seat Track · crackedDEN - DURING C-7 CHECK, INSPECTION REPORTED CRACKS AT FOUR SEAT TRACK ATTACH POINTS AT BS 520. MAINTENANCE REPAIRED FLOORBEAM PER EA 53-737-073, PAGES 1, 2 AND 3, EA 53-737-070, SRM 51-30-2, SRM 51-30-05 AND SRM 53-10-9. (M)SDR USAA000766Track · crackedCLT - FOUND O/H BIN RAIL CRACKED .5 INCH, STATION 827, LEFT O/H BIN RAIL ATTACH STRINGER 8 TO 9. INSTALLED DOUBLER PER TR 53-10-14A. (M)SDR QXEA0001606Seat Track · corrodedYYC- BLEND CORROISON AND MEASURE REMAINING MATERIAL ON CABIN SEAT TRACKS. REPAIRED IAW FOKKER SRM 53-01-01 AND 53-40-01.SDR UPS00832957Seat Track · corrodedINSPECTION TYPE:C2, CORROSION IN SEAT TRACK AT APPROX FS 815. REMOVED DAMAGE, INSTALLED PLUG REPAIR IAW DC8 SRM 53-2-3.SDR UPS00832955Seat Track · corrodedINSPECTION TYPE:C2, CORROSION ON SEAT TRACK A BETWEEN FS 40 TO 70. CUT OUT DAMAGED SECTION OF TRACK, SPLICED IN NEW SECTION IAW DC8 SRM 51-1-24 & UP EO DC8-53B-003.SDR USAA000741Seat Track · crackedCLT - FOUND SEAT TRACK ANGLE CRACKED .5 INCH, BS 520 AND RBL 24.75. INSTALLED REPAIR ANGLE PER EA 67167. (M)SDR COMA0010128Seat Track · corrodedUPON COMPLIANCE OF 2C INSPECTION THE FOLLOWING P/N SEAT TRACKS WERE FOUND WITH CORROSION AND REPLACED WITH FACTORY REPLACEMENT PARTS: 120-26865-005, 120-15997-603, 120-26864-005 , 120-15994-003 , 120-47507-001, 120-16000-603, 120-15996-005, 120-15995-007, 12SDR DHL2000801152Cargo Track · wornMAIN CARGO COMPT 4 LT TRACK LUGS WORN AT STA 130.000. CUT OUT DAMAGED AREA PER SRM 53-2-3. CONDITIONED NEW TRACK PER SRM 53-2-3. CLEANED, TREATED AND PRIMED PER SRM 51-1-8B. FABRICATED SPLICES AND INSTALLED SPLICES AND NEW TRACK PER SRM 53-2-3.SDR DHL2000801151Cargo Track · wornMAIN CARGO COMPT 2 RT TRACK LUGS WORN AT STA 1130.00. CUT OUT DAMAGED AREA PER SRM 53-2-3. CONDITIONED NEW TRACK PER SRM 53-22-3. FABRICATED SPLICES PER SRM 53-2-3. TREATED AND PRIMED PER SRM 51-1-8B. INSTALLED SPLICES AND TRACK PER SRM 53-2-3.SDR DHL2000801145Cargo Track · wornMAIN CARGO COMPT FLOOR TRACK RT LUGS WORN OUT AT STA 400.000. CUT OUT DAMAGED SECTION OF TRACK PER SRM 53-2-3. CONDITIONED NEW TRACK PER SRM 53-2-3. FABRICATED SPLICES PER SRM 53-2-3. TREATED AND PRIMED PER SRM 51-1-8B. INSTALLED TRACK AND SPLICES PER SRMSDR DHL2000801141Cargo Track · wornMAIN CARGO COMPT FLOOR TRACK 2 RT LUGS WORN STA 326.000. CUT OUT DAMAGED AREA PER SRM 53-2-3. FABRICATED SPLICES (3 EA) PER SRM 53-2-3. FABRICATED CHANNEL PER SRM 53-2-3. CLEANED, TREATED AND PRIMED PER SRM 51-1-8B. INSTALLED CHANNEL AND SPLICES PER SRM 5SDR DHL2000801137Cargo Track · wornMAIN CARGO COMPT NR 3 RT TRACK CORRODED AND WORN AT STA 1030.000. CUT OUT DAMAGED AREA OF TRACK PER SRM 53-2-3. FABRICATED CHANNEL AND SPLICES PER SRM 53-2-3. CLEANED, TREATED AND PRIMED PER SRM 51-1-8B. INSTALLED CHANNEL AND SPLICES PER SRM 53-2-3.SDR DHL2000801125Cargo Track · wornMAIN CARGO COMPT 3 RT TRACK LUGS WORN FROM STA 160.0 TO STA 280.0. REMOVED DAMAGED TRACK PER SRM 51-3-0. CLEANED, TREATED AND PRIMED AREA PER SRM 51-1-8B. INSTALLED NEW TRACK PER SRM 51-3-0.SDR DHL2000801124Cargo Track · wornMAIN CARGO COMPT 3 RT FLOOR TRACK WORN AND CORRODED FROM STA 1490.0 TO STA 1540.0. REMOVED DAMAGED TRACK PER SRM 51-3-0. CLEANED AND TREATED AND PRIMED PER SRM 51-1-8B. INSTALLED NEW TRACK PER SRM 51-30.SDR DHL2000801123Cargo Track · wornMAIN CARGO COMPT 3 RT TRACK LUGS WORN FROM STA 160.0 TO STA 280.0. REMOVED DAMAGED TRACK PER SRM 51-3-0. CLEANED, TREATED AND PRIMED PER SRM 51-1-8B. INSTALLED NEW TRACK PER SRM 51-3-0.SDR DHL2000801120Cargo Track · corrodedMAIN CARGO COMPT 3 RT TRACK WORN AND CORRODED FROM STA 1490.0 TO STA 1540. REMOVED DAMAGED TRACK PER SRM 51-3-0. CLEANED, TREATED AND PRIMED AREA PER SRM 51-1-8B. INSTALLED NEW TRACK PER SRM 51-3-0.SDR DHL2000801115Cargo Track · wornMAIN CARGO COMPT 2 RT TRACK LUGS WORN AT STA 600.0 TO 490.0. REMOVED WORN TRACK PER SRM 51-3-0. CLEANED, TREATED AND PRIMED PER SRM 51-1-8B. INSTALLED NEW TRACK PER SRM 51-3-0.SDR EIA2000201Seat Track · corrodedC2-CHECK, FOUND BS 1416 RBL 98 SEAT TRACK INBOARD FLANGE CORROSION. BS 1265-1480 RBL 98 SEAT TRACK REPLACED PER SRM 51-10-01 PAGE 18. (M)SDR EIA2000207Seat Track · corrodedFOUND BS 610 LBL 100 SEAT TRACK CORRODED. REPAIRED BS 610 LBL 100 SEAT TRACK PER SRM 53-10-05 FIG 8. (M)SDR EIA2000205Seat Track · corrodedFOUND BS 2120 - BS 2140 RBL 33.99 SEAT TRACK CROWN AND FLANGE AREA CORRODED. BS 2110-2230 RBL 33.99 SEAT TRACK REPAIRED PER SRM 53-10-05 FIG 1A. (M)SDR EIA2000204Seat Track · crackedFOUND BS 2157 RBL 11 INBOARD SEAT TRACK FLANGE CRACKED. REPAIRED SEAT TRACK PER SRM 53-10-05 FIG 16. (M)SDR EIA2000189Seat Track · corrodedFOUND BS 1450-1460 BL RBL 74R SEAT TRACK FLANGE CORRODED. SEAT TRACK REPAIRED PER SRM 53-10-05 FIG 32 AND SRWS 917282. (M)SDR AALA20000842Track · corrodedTUL - TRACK ''D'', LEFT, IS CORRODED FORWARD OF FRAME 74. BLENDED OUT CORROSION TO A DEPTH OF .065 INCH. REPAIRED PER ESO 30595 DATED 5-18-00. (X)SDR CALA0000778Seat Track · corrodedINSPECTION FOUND RT CABIN I/B SEAT TRACK CORRODED AROUND NUT PLATES FROM STA 200 - 260. A REPLACEMENT TRACK WAS INSTALLED IAW SRM 51-10-3, 53-05, FIGURES 4F & 5, 51-30-2, AND 53-04, FIGURE 4.SDR AALA20000908Seat Track · corrodedTUL - CORROSION ON AFT LAVATORY MOUNT OUTBOARD FRAME 33 TRACK NR 1. REMOVED CORROSION AND BLENDED. INSTALLED DOUBLER STRAP PER A300 AARD 53-20-00. ALODINED, PRIMED AND PAINTED. (X)SDR AALA20000909Seat Track · corrodedTUL - CORROSION ON NR 1 SEAT TRACK AT FOWARD OUTBOARD LAVATORY MOUNT. REMOVED AND BLENDED OUT CORROSION PER SRM 51-74-10. ALODINED, PRIMED, AND PAINTED FORWARD OUTBOARD MOUNT HOLE. (X)SDR CALA0000775Seat Track · corrodedINSPECTION FOUND RIGHT O/B SEAT TRACK CORRODED AND CHAFED AT STA 470 - 490. THE SEAT TRACK WAS REMOVED AND A NEW TRACK WAS INSTALLED IAW SRM 51-30-1 AND 53-05, FIGURE 4.SDR CALA0000754Seat Track · corrodedINSPECTION FOUND RIGHT I/B SEAT TRACK CORRODED AT STA 1193. THE SEAT TRACK WAS REMOVED AND A NEW TRACK WAS INSTALLED IAW SRM 53-05, PAGE 106.SDR RRXA002339Seat Track · gougedDURING A MAINTENANCE VISIT FOUND A GOUGED SEAT TRACK AT FUSELAGE STA FS 425 XCW 22.5, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. BLENDED DAMAGED AREA IAW DC-8 SRM 53-2-3 AND EO NR 00-047 WITH APPROVSDR RRXA002299Seat Track · damagedDURING A MAINTENANCE VISIT FOUND ELONGATED HOLES IN THE SEAT TRACK AT STA 1250 - 1460 AND XCW 47 RT, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. RECEIVED AND INSTALLED REPAIRED SEAT TRACK IAW DC-8 SRSDR SIMA1461Seat Track · corrodedABI - FOUND SEAT TRACK BL 18.3L WAS FOUND TO BE CORRODED BEYOND SRM LIMITS FROM STATION 297-329. REMOVED 32 INCH OF CORRODED SEAT TRACK BL 18.3L. WORK DONE IAW SAAB 340 SRM 53-70-60 PAGE 201-205 AND SAAB REPAIR STATEMENT NR72SDS0795. AIRCRAFT OK FOR SERVICESDR 20000703AP011Seat Track · corrodedABI - SEAT TRACK BL 18.3L WAS FOUND TO BE CORRODED BEYOND SRM LIMITS FROM STATION 297-329. REMOVED 32 INCH OF CORRODED SEAT TRACK BL 18.3L. WORK DONE IAW SAAB 340 SRM 53-70-60 PAGE 201-205 AND SAAB REPAIR STATEMENT NR 72SDS0795. AIRCRAFT OK FOR SERVICE. (MSDR TWAA0008804Seat Track · gougedDURING CHECK-C MAINT, CHAIR TRACK HAD GOUGES AT STA 356 TO 389, RBL 22, AND AT STA 243 TO 313 RBL 22. REMOVED AND BLENDED GOUGES PER SRM 53-05, FIG 4B-1, AND SPM 6-80-01. PRIMED, SANDED AREA PER SRM 51-10-3.SDR AWXA0000343Seat Track · corrodedC-CHECK, SEAT TRACK AT GALLEY ATTACH POINT CORRODED AT BS 340 RBL 44. REMOVED, FABRICATED REPLACEMENT TRACK AND INSTALLED IAW 737 SRM 53-00-52 FIG 202 AND SRM 51-40-01 MATERIAL 7075 T6 .125 QQA/250/13.SDR CALA0000743Cargo Track · corrodedINSPECTION FOUND AFT CARGO LT TIE DOWN TRACK CORRODED FROM STA 1003 - 1212. THE TIE DOWN TRACK WAS REMOVED AND REPLACED IAW SRM 51-30-1 AND 51-30-2.SDR RRXA002460Seat Track · damagedDURING A MAINTENANCE VISIT FOUND GOUGED AND ELONGATED HOLES TO THE SEAT TRACK AT FS 925 - 962 XCW 47 LT, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. RECEIVED NEW PART AND INSTALLED IAW DC-8 SRM 53-2-3, FIG 12, SDR RRXA002439Seat Track · damagedDURING A MAINTENANCE VISIT FOUND ELONGATED HOLES TO THE SEAT TRACK AT FS 1500 - 1560 XCW 0, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. RECEIVED AND INSTALLED NEW TRACK IAW EO NR 77-995CF DATED 5-22-00 AND ROSESDR RRXA002438Seat Track · crackedDURING A MAINTENANCE VISIT FOUND A CRACKED SEAT TRACK AT FS 1540 - 1560 XCW 22 LT, DAMAGE EXCEEDED LIMITATION IAW DC-8 SRM. REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. RECEIVED AND INSTALLED NEW TRACK IAW ROSENBALM DWG NR 24300 AND EA NR 77-995CF DATEDSDR RRXA002437Seat Track · misdrilledDURING A MAINTENANCE VISIT FOUND ELONGATED AND MISDRILLED HOLES TO THE SEAT TRACK AT FS 1360 - 1430, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. RECEIVED AND INSTALLED NEW TRACK IAW ROSENBALM DWG NR 24300 AND ESDR RRXA002436Seat Track · damagedDURING A MAINTENANCE VISIT FOUND ELONGATED HOLES ON THE SEAT TRACK AT FS 1060-XCW 47 LT, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. RECEIVED AND INSTALLED NEW TRACK IAW EA NR 77-995CF DATED 5-22-00 AND ROSENBASDR RRXA002435Seat Track · damagedDURING A MAINTENANCE VISIT FOUND ELONGATED HOLES TO THE SEAT TRACK AT FS 1530 - 1560 XCW 22 RT, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. RECEIVED AND INSTALLED NEW TRACK IAW DC-8 SRM 53-2-0, FIG 12, EA NR 77SDR RRXA002434Seat Track · misdrilledDURING A MAINTENANCE VISIT FOUND MISDRILLED HOLES TO THE SEAT TRACK AT FS 1380 - 1400, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. RECEIVED AND INSTALLED NEW TRACK IAW ROSENBALM DWG NR 24300 AND EA NR 77-995CF SDR RRXA002433Seat Track · damagedDURING A MAINTENANCE VISIT FOUND ELONGATED HOLES TO THE SEAT TRACK AT FS 1300 - 1380 XCW 59.5 RT, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. RECEIVED AND INSTALLED REPAIR IAW EO NR 00-047 WITH APPRO
Back to JASC 5347