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 USAA050144Seat Track · corrodedBFM - FOUND SEAT TRACK CORRODED, FS 53.4-53-5 -Y1959 -Z240. REPLACED SECTION OF SEAT TRACK AND ADDED SPLICES PER SRM 53-31-15 FIG 101 AND 201 SHT 1. CORROSION LEVEL 2, TASK NR J7-260-53500-001. REPLACED SECTION OF SEAT TRACK AND ADDED SPLICES PER SRM 53-31-SDR USAA050143Seat Track · corrodedBFM - FOUND FALSE RAIL CORRODED, MAIN CABIN BETWEEN FRAME 12-13, Y+1456. CORROSION LEVEL 2, TASK NR J7-220-53500. REMOVED AND REPLACED FALSE RAIL PER SRM 53-11-14, 51-42-11, 51-72-00, 51-44-11. (M)SDR ASOA05084Seat Track · corrodedDURING A C-CHECK, THE LT SEAT TRACK BETWEEN FR 39 AND 41 WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE LT SEAT TRACK BETWEEN FR 39 AND 41 IAW SRM. (K)SDR AWXA200500098Seat Track · corrodedSAL - MAJOR REPAIR - DURING C-04 CHECK, CORROSION WAS FOUND ON SEAT RAIL BEAM ASSEMBLY -Y765 AT FR 64+14". MAINTENANCE REMOVED DAMAGED AREA OF SEAT RAIL UPPER FLANGE -Y765 FROM FS 64 TO FS 65; FABRICATED A REPAIR ANGLE; INSTALLED REPAIR PART IAW ER 26-5341-05SDR AWXA200500083Seat Track · corrodedSAL - MAJOR REPAIR - DURING C-04 CHECK EXFOLIATION CORROSION WAS FOUND ON LT INBOARD SEAT TRACK BETWEEN FR 38 AND FR 40. MAINTENANCE REMOVED AND REPLACED LT INBOARD SEAT TRACK FROM FR 38 TO FR 40 IAW A320 SRM 51-72-11 PG 1 & 2.SDR AWXA200500061Seat Track · corrodedSAL - MAJOR REPAIR - DURING C-04 CHECK GALVANIC CORROSION WAS FOUND ON RT OUTBOARD SEAT TRACK BETWEEN FR 44 AND FR 46. MAINTENANCE REMOVED CORRODED SECTION OF RT OUTBOARD SEAT TRACK FROM FR 40 TO FR 46; FABRICATED A NEW REPLACEMENT SECTION OF SEAT TRACK; INSTSDR AWXA200500058Seat Track · corrodedSAL - MAJOR REPAIR - DURING C-04 CHECK GALVANIC CORROSION WAS FOUND ON RT INBOARD SEAT TRACK BETWEEN FS 42 AND FS 44. MAINTENANCE REMOVED CORRODED RT INBOARD SEAT TRACK FROM FS 42 TO FS 44; FABRICATED A NEW REPLACEMENT SEAT TRACK; INSTALLED REPAIR PART IAW A3SDR USAA050141Seat Track · corrodedBFM - FOUND SEAT TRACK CORRODED, 1.5 INCHES LONG BY 1.1 INCH WIDE BY .048 INCH DEEP, MAIN CABIN FLOOR -450, FRAME 47-53. REMOVED AND REPLACED SEAT TRACK PER SRM 53-31-15, FIG 101. (M)SDR USAA050129Seat Track · corrodedBFM - FOUND SEAT TRACK CORRODED 2 INCHES BY 1 INCH BY .35 INCH AND 3.5 INCH BY 1 INCH .036 INCH, Y1959 FRAME 54-58 Z-240. INSTALLED NEW SEAT TRACK PER SRM 53-00-15 FIG 101 SHT 2 AND SRM 51-42-11. CORROSION LEVEL 2, TASK NR J7-200-2580C-030. (M)SDR USAA050139Seat Track · corrodedBFM - FOUND TRACK CORRODED TRACK, FRAME 32-33, -Y1552 S, MAIN CABIN FLOOR. REMOVED AND REPLACED TRACK PER SRM 53-00-15 SH 2, FIG 101. CORROSION LEVEL 2, TASK NR J7-230-53500. REMOVED AND REPLACED TRACK PER SRM 53-00-15 SH 2, FIG 101. (M)SDR USAA050140Seat Track · corrodedBFM - FOUND SEAT TRACK CORRODED, MAIN CABIN FLOOR -450 FRAME 58-68. REMOVED AND REPLACED SEAT TRACK PER SRM 53-00-15, FIG 101 SHT 2. CORROSION LEVEL 2, TASK NR J7-200-2580C. (M)SDR USAA050124Seat Track · corrodedBFM - FOUND SEAT TRACK CORRODED, 2.20 INCH LONG BY 1.1 INCH WIDE BY .050 INCH DEEP, MAIN DECK CABIN -450 FRAME 54-59. REMOVED AND REPLACED SEAT TRACK PER SRM 53-00-15, FIG 101. CORROSION LEVEL 2, TASK NR J7-200-25806. REMOVED AND REPLACED SEAT TRACK PER SRMSDR USAA050133Seat Track · corrodedBFM - FOUND SEAT TRACK CORRODED 2 INCH LONG BY 1 INCH WIDE BY .040 INCH DEEP, MAIN CABIN +Y450, FRAME 40-56. REMOVED AND REPLACED SEAT TRACK PER SRM 53-31-15 FIG 101. CORROSION LEVEL 2, TASK NR J7-200-2578C. (M)SDR USAA050132Seat Track · corrodedBFM - FOUND SEAT TRACK CORRODED 1 INCH BY 1 INCH BY .042 INCH AREA, BETWEEN FRAME 72-75, -Y450 - Z240. REMOVED AND REPLACED WITH NEW SEAT TRACK PER SRM 53-00-15 FIG 101 SH 2 AND 51-42--11. (M)SDR USAA050131Seat Track · corrodedBFM - FOUND SEAT TRACK CORRODED .500 INCH BY .375 INCH BY .040 INCH AREA, FRAME 73-74 -Y1147.8 -Z240. REMOVED AND REPLACED WITH NEW SEAT TRACK PER SRM 53-00-15 AND 51-42-11. CORROSION LEVEL 2, TASK NR J7-150-53502-002. (M)SDR USAA050150Seat Track · corrodedBFM, S1 CK, SEAT TRACK, (3 INCHES L X 1 INCH X .040 INCH D) CORROSION; LEVEL 2; TASK NR J7-200-2580C, MAIN CABIN FLOOR Y=450, FR 55-58. REMOVED AND REPLACED SEAT TRACK IAW SRM. (K)SDR UPS05443802Seat Track · corrodedINSPECTION TYPE:C M/D - BS 1180 RBL 97 I/B SEAT TRACK SUPPORT FOUND CORRODED. CORROSION BLEND OUT 0.050 X 1 X 1 INCH, EXCEED SRM LIMIT. SEAT TRACK REPAIR PARTS FABRICATED PER SRM 53-10-05 FIG 34.SDR UPS05443801Seat Track · corrodedINSPECTION TYPE:C - BS 1160 - 1220 RBL 97 SEAT TRACK I/B FLANGE FOUND CORRODED. CORROSION BLEND OUT 0.050 X 1 X 2 INCH. SEAT TRACK CUT OFF AT BS 1070 RBL 98 AS PER SRM 51-10-01. REPROTECTED AS PER SRM 51-10-02. SEAT TRACK REPAIR PARTS FABRICATED PER SRM 53SDR UPS05443667Seat Track · corrodedINSPECTION TYPE:C - BS 1000 LBL 33 O/B SEAT TRACK FLANGE CORRODED. M/D BS 990 - 1000 LBL 33 SEAT TRACK REPAIR PARTS FABRICATED AS PER SRM 53-10-05 FIG 1A. CORROSION BLEND OUT 0.050 X 1 X 1 INCH EXCEED SRM LIMIT.SDR UPS05443654Seat Track · corrodedINSPECTION TYPE:C - BS 520 - 540 LBL 46 SEAT TRACK CORRODED AS MARKED. U/D BS 520 - 560 LBL 46 SEAT TRACK REPAIR PARTS FABRICATED AS PER SRM 53-10-05 FIG 6. CORROSION BLEND OUT 0.060 X 1 X 1 INCHES EXCEED SRM LIMIT.SDR UPS05443653Seat Track · corrodedINSPECTION TYPE:C U/D - BS 480 LBL 46 SEAT TRACK CORRODED AS MARKED. U/D BS 480 - 500 LBL 46 SEAT TRACK REPAIR PARTS FABRICATED AS PER SRM 53-10-05 FIG 6. CORROSION BLEND OUT 0.050 X 1 X 2 INCHES EXCEED SRM LIMIT.SDR UPS05443650Seat Track · corrodedBS 480 - 500 RBL 66 SEAT TRACK CORRODED AS MARKED. SEAT TRACK PART FABRICATED AS PER SRM 51-10-01 PG 9. CORROSION BLEND OUT 0.050 X 2 X 2 INCHES EXCEED SRM LIMIT.SDR 05FDEA00060Seat Track · wornMAIN DECK CARGO, SEAT TRACK BETWEEN STA Y= 1099 TO Y= 1129, X= 27.50V FOUND WORN. REPAIRED PER SRM 53-70-00 VOLUME I, FIGURE 1SDR USAA050138Seat Track · corrodedBFM - FOUND SEAT TRACK CORRODED 2.75 INCH BY .350 INCH BY .025 INCH BY 1 INCH BY 1.5 INCH BY .028 INCH, -Y450 FRAME 53.2-54 MAIN CABIN FLOOR. INSTALLED NEW SEAT TRACK PER SRM 51-74-00, 53-31-15 FIG 101 SH 1. (M)SDR USAA050137Seat Track · corrodedBFM - FOUND SEAT TRACK ASSEMBLY CORRODED 1.100 INCH BY .375 INCH BY .025 INCH AND .600 INCH BY .375 INCH BY .040 INCH DEEP, Y-1447 BETWEEN FRAME 73/74 CABIN FLOOR. CORROSION LEVEL 2, TASK J7-150-53502. REMOVED AND REPLACED SEAT TRACK ASSEMBLY PER SRM 51-42-1SDR MALA050120Seat Track · corrodedDURING 4Y/2Y CHECK IN BNA, SEAT TRACK AT LBL 18.3 BETWEEN FS 294-319 IS CORRODED OUT OF LIMITS AND HAS BEEN REPAIRED IAW MESABA EO NR S53079. REFER EAMS WO NR 211363, TASK 1511 FOR ADDITIONAL INFORMATION. AIRCRAFT WAS RELEASED 1/11/05.SDR MALA050119Seat Track · corrodedDURING 4Y/2Y CHECK IN BNA, SEAT TRACK AT BL0 BETWEEN FS 294 AND FS 319 IS CORRODED OUT OF LIMITS AND HAS BEEN REPAIRED IAW MESABA EO NR 53079. REFER EAMS WO NR 211363, TASK 1512 FOR ADDITIONAL INFORMATION. AIRCRAFT WAS RELEASED 1/11/05.SDR MALA050122Seat Track · corrodedDURING 4Y/2Y CHECK IN BNA, GALLEY SEAT TRACK PROFILE PN 7253721-495 IS CORRODED OUT OF LIMITS AT FS 272. DAMAGED PART WILL BE REMOVED AND REPLACED IAW SRM NR 514021. REFER EAMS WO NR 211363, TASK 1514 FOR ADDITIONAL INFORMATION. AIRCRAFT WAS RELEASED 1/11/0SDR MALA050123Seat Track · corrodedDURING 4Y/2Y CHECK IN BNA, SEAT TRACK AT LBL 18.3 BETWEEN FS 294-319 IS CORRODED OUT OF LIMITS AND HAS BEEN REMOVED AND REPLACED AS NEEDED IAW MESABA EO NR S53060. REFER EAMS WO NR 211363, TASK 1511 FOR ADDITIONAL INFORMATION. AIRCRAFT WAS RELEASED 1/11/05.SDR MALA050121Seat Track · corrodedDURING 4Y/2Y CHECK IN BNA, GALLEY SEAT TRACK IS CORRODED OUT OF LIMITS AND HAS BEEN REPLACED PN 7253721-459 IAW SRM 51-40-27. REFER EAMS WO NR 211363, TASK 1503 FOR ADDITIONAL INFORMATION. AIRCRAFT WAS RELEASED 1/11/05.SDR QXEA200500094Seat Track · gougedPDX - LEFT HAND CENTER SEAT TRACK NR 4 HAS GOUGE AT FRAME 282 TO FRAME 299. REPAIRED IAW SRM 51-40-11.SDR QXEA200500089Seat Track · gougedPDX - RIGHT HAND CENTER SEAT TRACK NR 7 HAS PITTING AND GOUGES FROM FRAME 262.50 TO FRAME 214.400. REPAIRED IAW SRM 51-40-11.SDR QXEA200500092Seat Track · gougedPDX - RIGHT HAND CENTER SEAT TRACK NR 7 HAS GOUGES AT FRAME 397 TO 412. REPAIRED IAW SRM 51-40-11.SDR QXEA200500091Seat Track · gougedPDX - RIGHT HAND CENTER SEAT TRACK NR 7 HAS GOUGES IN TRACK FROM STATION FRAME 350.00 TO FRAME 374. REPAIRED IAW SRM 51-40-11.SDR QXEA200500093Seat Track · corrodedPDX - LEFT HAND CENTER SEAT TRACK NR 4 HAS CORROSION ON FLANGE AT STATION 234.500. REPAIRED IAW SRM 51-40-11.SDR QXEA200500090Seat Track · corrodedPDX - RIGHT HAND CENTER TRACK NR 7 HAS LITE CORROSION AT X210.100 TO FRAME 234.500. REPAIRED IAW SRM 51-40-11.SDR QXEA200500098Seat Track · gougedPDX - LEFT HAND CENTER SEAT TRACK NR 4 HAS GOUGES AT FRAME 405 TO 417. REPAIRED IAW SRM 51-40-11.SDR QXEA200500097Seat Track · corrodedPDX - LEFT HAND CENTER SEAT TRACK NR 4 HAS GOUGES AND CORROSION AT FRAME 378 TO 330 TO 395. REPAIRED IAW SRM 51-40-11.SDR QXEA200500096Seat Track · gougedPDX - LEFT HAND CENTER SEAT TRACK NR 4 HAS GOUGES AT FRAME 350 TO 364. REPAIRED IAW SRM 51-40-11.SDR QXEA200500095Seat Track · gougedPDX - LEFT HAND CENTER SEAT TRACK NR 4 HAS GOUGES AT FRAME 313 AND 330. REPAIRED IAW SRM 51-40-11.SDR QXEA200500088Seat Track · gougedPDX - RIGHT HAND SEAT TRACK NR 7 HAS GOUGES AT STATION 312.350 FRAME TO 333.300 FRAME. REPAIRED IAW SRM 521-40-11.SDR 05FDEA00055Seat Track · wornMAIN DECK CARGO, SEAT TRACK BETWEEN STA Y= 710 TO Y= 715, X= -8.50 SCALLOP FOUND WORN. REPAIRED PER SRM 53-70-00 VOLUME I, FIGURE 1.SDR 05FDEA00054Seat Track · damagedMAIN DECK, SEAT TRACK HORIZONTAL FLANGE UPPER SURFACE AT STA Y= 5-11 TO Y= 5-53, X= -75.25 FOUND FLOOR PANEL MOUNTING HOLE SHORT OF EDGE MARGIN. REPAIRED IAW SRM 53-70-00 VOLUME I, FIGURE 1.SDR DHL2005749024Seat Track · corrodedFOUND CORROSION ON SEAT TRACK AT RBL 45 BS 520-580. REMOVED SEAT TRACK RBL 45.5 BS 480-590 IAW B727 SRM 51-30-2 AND 53-10-5 FIG 1. REPLACED SEAT TRACK P/N BAC1520-792 PO 9002389 LOCATED AND DRILLED IAW B727 SRM 53-10-5 FIG1 DIM 110". TREATED AND PRIMED SEATSDR USAA050136Seat Track · corrodedBFM - FOUND SEAT TRACK CORRODED, 1.5 INCHES BY 1 INCH BY .21 INCH, 1.5 INCH BY 1 INCH BY .035 INCH, 2 INCH BY 1 INCH BY .040 INCH, -450 FRAME 67-72 MAIN CABIN FLOOR. INSTALLED NEW SEAT TRACK PER SRM 53-00-15 FIG 101 SH 2 AND SRM 51-42-11. CORROSION 3 AREAS, SDR UPS05443764Seat Track · corrodedINSPECTION TYPE:C - BS 1480 - 1500 RBL 11 SEAT TRACK O/B FLANGE FOUND CORRODED. SEAT TRACK REPAIR PARTS FABRICATED PER SRM 53-10-05 FIG 14. CORROSION BLEND OUT 0.040 X 1 X 3 INCHES EXCEED SRM LIMIT.SDR UPS05443696Seat Track · corrodedINSPECTION TYPE:C - STA 1482 LBL 99 SEAT TRACK FLANGE CORROSION. CORROSION REMOVED IAW SRM 51-10-01. CORROSION BLEND OUT 0.050 INCH BY 1 INCH BY 1 INCH. CORROSION BLEND OUT EXCEED SRM 53-10-01 FIG 1 LIMITS, REPAIR REFER TO SRM 53-10-05 FIG 1A.SDR 05FDEA00045Seat Track · corrodedMAIN DECK CARGO, SEAT TRACK BETWEEN STA Y= 1841 TO Y= 1871, X= - 8.50 FOUND CORRODED. REMOVED AND REPAIRED PER SRM SRM 53-70-00 VOLUME I, FIGURE 1.SDR 05FDEA00040Seat Track · wornMAIN DECK, SEAT TRACK BETWEEN STA Y= 1219 TO Y= 1239, X= -47.50 FOUND WORN. SPLICED AND REPAIRED PER SRM 53-70-00 VOLUME I, FIGURE 1.SDR 05FDEA00042Seat Track · wornMAIN DECK CARGO, SEAT TRACK BETWEEN STA Y= 1501 TO Y= 5-11, X= 8.50 FOUND WORN. SPLICED AND TRIMMED PER SRM 51-33-01 VOLUME II; AND REPAIRED PER SRM 53-70- 00 VOLUME I, FIGURE 1.
Back to JASC 5347