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 CALA0000706Seat Track · corrodedINSPECTION FOUND LEFT O/B SEAT TRACK CORRODED AT STA 470, LBL 44.5. THE SEAT TRACK WAS REMOVED AND A NEW SECTION WAS INSTALLED IAW SRM 51-30-3, 51-10-3, AND 53-05, FIGURE 4.SDR CALA0000705Seat Track · corrodedINSPECTION FOUND RIGHT O/B SEAT TRACK CORRODED AT STA 798 - 807 AND RIGHT I/B SEAT TRACK CORRODED AT STA 503 - 508, RBL 22. THE CORRODED SECTIONS OF SEAT TRACK WERE REMOVED AND REPLACED IAW SRM 53-05, FIGURE 4, 51-30-2, 51-10-3, AND 51-30-05.SDR ASAA0080316Seat Track · corrodedPHX - DURING 30K CHECK, FOUND CORROSION AND GOUGES ON SEAT TRACK, FS 1032 TO 1309, LBL 44. REMOVED AND REPLACED SEAT TRACK IAW DC9 SRM 53-24. (M)SDR ASAA0080315Seat Track · corrodedPHX - DURING 30K CHECK, FOUND CORROSION ON SEAT TRACK, FS 1098 TO 1106, LBL 24. REMOVED AND REPLACED SECTION OF SEAT TRACK IAW DC9 SRM 53-05. (M)SDR ASAA0080314Seat Track · corrodedPHX - DURIGN 30K CHECK, FOUND CORROSION WAS FOUND ON SEAT TRACK, FS 1104, BL 0. REMOVED AND REPLACED SECTION OF SEAT TRACK IAW DC9 SRM 53-14-03, FIG 12. (M)SDR QXEA0001347Seat Track · corrodedPDX- LEFT HAND END SEAT TRACK IS CORRODED BEYOND LIMITS. REPAIRED IAW DASH 8 SRM 51-40-11 AND SRM 51-40-00.SDR QXEA0001346Seat Track · corrodedPDX- RIGHT HAND INBOARD SEAT TRACK AT END POSITION IS CORRODED BEYOND LIMITS. REPAIRED IAW DASH 8 SRM 51-40-11 AND SRM 51-40-00.SDR CALA0000695Seat Track · corrodedINSPECTION FOUND LEFT I/B SEAT TRACK CORRODED AT GALLEY AREA, BS 907 - 947. A NEW SEAT TRACK SECTION WAS INSTALLED IAW SRM 53-00-52.SDR CALA0000693Seat Track · corrodedINSPECTION FOUND SEAT TRACK CORRODED IN RT FORWARD GALLEY AREA BETWEEN BS 277 AND 294. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 53-00-52.SDR CALA0000692Seat Track · corrodedINSPECTION FOUND CENTER SEAT TRACK CORRODED AT STA 228, RBL 22.5. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 53-05, FIGURE 4F.SDR AALA20000879Seat Track · corrodedTUL - FOUND CORROSION ON NR 6 SEAT TRACK FS 215-FS 275. SPLICED IN NEW SECTION OF SEAT TRACK NR 6 FS 215 TO FS 275 SRM 51-01 USED 16 NAS623-3-4 SUBSTITUTE FASTENERS FOR TRACK TO FLOOR BEAM ATTACHMENT SRM 53-40 ATTACH ANGLES PER 53-05 PART 1 FIG 4F. (M)SDR USAA000705Seat Track · crackedCLT - Q-4, SEAT TRACK HAD .50 INCH CRACK, BS 520 AND LBL 24.75, SEAT TRACK SUPPORT ANGLE. REPLACED REPAIR ANGLE PER SRM 51-30-2. (X)SDR DHL200070713CSeat Track · wornSEAT TRACK LBL 24 HAS LOCK LUG WORN STA 850. REMOVED SEAT TRACK PER SRM 51-30-2. INSTALLED NEW SEAT TRACK FROM STA 850 TO 870 PER SRM 53-10-5. ALODINED AND PRIMED PER SRM 51-10-2.SDR DHL200070712CSeat Track · wornSEAT TRACK AT LBL 45 HAS LOCK LUG WORN AT STA 860. REMOVED SEAT TRACK AT BS 860 LBL 45 PER SRM 51-30-2. INSTALLED SEAT TRACK SECTION PER M/M 53-4-0 AND SRM 51030-2. MATERIAL USED SEAT TRACK 91 IN 1778 T6 511. ALODINED AND PRIMED PER SRM 51-10-2.SDR CALA0000681Cargo Track · corrodedINSPECTION FOUND FORWARD CARGO LT TIE DOWN TRACK CORRODED AROUND CLIP NUTS FROM FS 218 - 522. THE TRACK WAS REMOVED AND REPLACED IAW SRM 51-10-3 AND 51-30-1.SDR UPS00832709Seat Track · corrodedINSPECTION TYPE:C2, SEAT TRACK ''I'' CORRODED ON BOTTOM SIDE, STA 1380 - 1540. REMOVED SEAT TRACK, FOUND TO BE OUT OF LIMITS IAW DC8 SRM 53-2-3. FABRICATED AND INSTALLED NEW SEAT TRACK AT STA 1380 - 1540 WITH TWO SPLICES PER UPS EO REF DC8 5320-5167 AND DC8 SDR UPS00832723Seat Track · corrodedINSPECTION TYPE:C2, SEAT TRACK B AT STA 1060 - 1330 HAS CORROSION UNDER O/B FLANGE. REMOVED CORROSION IAW DC8 SRM 53-2-0, FOUND OUT OF LIMITS. REMOVED DAMAGED SECTION OF TRACK, LOCATED AND DRILLED NEW SECTION IAW DC8 SRM 51-1-24. FABBED SPLICES IAW UPS EO 5SDR AWXA0000309Seat Track · corrodedC-CHECK, SEAT TRACK HAS CORROSION BEYOND LIMITS AT STA 277 - 299 LBL 41. REMOVED AND REPLACED SEAT TRACK (NEW PART) IAW 737 SRM 51-40-2.SDR QXEA0001391Seat Track · corrodedPDX- EXFOLIATION CORROSION ON THE RIGHT HAND INBOARD SEAT TRACK 11 INCHES AFT OF FRAME 9805 ON TOP OF TRACK. REPAIRED IAW FOKKER SRM 51-10-4 PAGE 8 AND 53-40-01.SDR AWXA0000302Seat Track · corrodedNON-ROUTINE LINE, CORROSION. FWD RT WIND SCREEN FLOOR TRACKS BETWEEN FR 20 AND FR 24, Y 765 CORRODED BEYOND LIMITS. REMOVED AND REPLACED SEAT TRACKS IAW A320 SRM 51-72-11, DUMMY RAIL IAW A320 SRM 51-72-16. PRIMED AND PAINTED REWORK AREA IAW A320 SRM 51-70-0SDR 20000801SH006Fitting · corrodedDURING A C-CHECK, CORROSION WAS NOTED ON NR 2 CARGO DOOR SILL TIE DOWNS. (X)SDR QXEA0001393Seat Track · corrodedPDX- LEFT HAND INBOARD SEAT TRACK INBOARD FLANGE IS EXFOLIATED IN TWO SPOTS BETWEEN FRAMES 4900 AND 5305. REPAIRED IAW FOKKER SRM 51-31-01 PAGE 13 AND 53-40-01.SDR UPS00832705Seat Track · gougedINSPECTION TYPE:C2, SEAT TRACK ''B'' IS WORN AND GOUGED FROM FS 610 - 850; OUT OF LIMITS RT & LT FS 620. ROUTED OUT DAMAGE RT & LT FS 620 WHERE THE TRACK WAS OUT OF LIMITS. INSTALLED 4 HOLE PLUG AND 4 HOLE CHANNEL IAW DC8 SRM 53-2-2, 53-2-3, 51-1-8 & 51-3-0.SDR UPS00832704Seat Track · gougedINSPECTION TYPE:C2, SEAT TRACK ''F'' IS WORN, GOUGED AND HAS BARE METAL STA 810 - 1010. BLENDED GOUGES STA 810 - 920. REMOVED AND REPLACED TRACK STA 970 - 1010 IAW DC8 SRM 53-2-3 & UPS EO DC8 5320-5167C. ALODINED AND PRIMED IAW DC 8 SRM 51-1-8.SDR UPS00832684Seat Track · gougedINSPECTION TYPE:C2, SEAT TRACK G SCALLOPS GOUGED BETWEEN STA 160 & STA 180. BLENDED GOUGES, FOUND TO BE OUT OF LIMITS IAW DC8 SRM 53-2-3. REMOVED SEAT TRACK STA 130 - 180 IAW DC8 SRM 51-3-0. LOCATED, DRILLED AND DEBURRED SEAT TRACK AND SPLICE FITTING IAW DCSDR 00FDEA00330Seat Track · corrodedSEAT TRACK CROWN AND FLANGE AREA CORRODED BS 1917 TO BS 1987, RBL 88. SEAT TRACK CROWN AND FLANGE AREA CORRODED BS 415 TO BS 465, RBL 28. *S/D* REMOVED AND REPLACED PER SRM 51-35-01 & 51-32-02 VOL II & 53-70-00 FIG 1 VOL I. REMOVED AND REPLACED PER SRM 53-SDR CALA0000661Seat Track · corrodedINSPECTION FOUND LEFT O/B SEAT TRACK CORRODED AT STA 1136, LBL 54 (LOWER LEG OF TRACK AT CUSP WEB). THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 51-30-01.SDR CALA0000660Cargo Track · corrodedINSPECTION FOUND MID CARGO LT TIE DOWN TRACK CORRODED AT FS 674 - 788. THE TIE DOWN TRACK WAS REMOVED AND REPLACED IAW SRM 51-30-1 AND 51-30-2.SDR CALA0000652Cargo Track · corrodedINSPECTION FOUND AFT CARGO LT TIE DOWN TRACK CORRODED AT STA 1007 - 1211. THE TIE DOWN TRACK WAS REMOVED AND REPLACED IAW SRM 51-30-1 AND 51-30-2.SDR AALA2000827Cargo Track · corrodedTUL - FOUND CORROSION ON RIGHT TIE DOWN TRACK FROM STATION 1041 TO 1155. REPLACED TIE DOWN TRACK SRM 51-01. (M)SDR MALA00328Seat Track · corrodedFOUND DURING C-CHECK, SEAT TRACK AT BL-0 LOWER FLOOR PANEL FLANGE AND VERTICAL SIDE IS CORRODED FROM STA 297 TO 389. REFER TO CELSIUS TASK CARD 1506.SDR MALA000335Seat Track · chafedFOUND DURING C-CHECK, SEAT TRACK BL-0 FROM STA 297 TO 686 AREAS OF CHAFING DAMAGE AND BARE METAL. REFER TO CELSIUS TASK CARD 1511.SDR MALA000334Seat Track · chafedFOUND DURING C-CHECK, SEAT TRACK LBL 18 FROM STA 297 TO 686 HAS AREA OF CHAFING DAMAGE AND BARE METAL. REFER TO CELSIUS TASK CARD 1512.SDR MALA000333Seat Track · corrodedFOUND DURING C-CHECK, SEAT TRACK AT LBL-18 LOWER FLOOR PANEL FLANGE AND VERTICAL SIDE IS CORRODED FROM STA 297.0 TO 389.0. REFER TO CELSIUS TASK CARD 1507.SDR MALA000331Seat Track · corrodedFOUND DURING C-CHECK, SEAT TRACK CORRODED BETWEEN STA 258.0 THRU 294.0 AT RBL 15. REFER CELSIUS TASK CARD 1521.SDR CALA0000649Galley Track · corrodedINSPECTION FOUND CENTRAL GALLEY SUPPORT CORRODED AT STA 449. THE SUPPORT WAS REPLACED IAW SRM 51-31-01.SDR MWEA00426Seat Track · damagedFIRST OFFICER I/B SEAT TRACK HOLES ELONGATED BEYOND .375 INCHES. FABRICATED AND INSTALLED DOUBLER. FABRICATED AND INSTALLED SEAT TRACK.SDR C2XA00IA128Seat Track · corrodedDURING CONTINENTAL EXPRESS C-CHECK, THE LEFT SEAT TRACK WAS FOUND TO BE CORRODED FROM FRAME 33 TO FRAME 39. MAINTENANCE REMOVED AND REPLACED THE AFFECTED SECTION OF SEAT TRACK IAW EMB120 SRM 53-20-11, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR QXEA0001390Seat Track · corrodedPDX- PITTING CORROSION IN RADIUS OF RIGHT HAND INBOARD SEAT TRACK 7 INCHES FROM FRAME 13815. REPAIRED IAW FOKKER SRM 51-10-4 PAGE 8 AND 53-40-01.SDR QXEA0001389Seat Track · corrodedPDX- PITTING CORROSIN IN RADIUS OF THE RIGHT HAND INBOARD SEAT TRACK 5 INCHES AFT OF FRAME 13815. REPAIRED IAW FOKKER SRM 51-10-4 PAGE 8 AND 53-40-01.SDR QXEA0001388Seat Track · corrodedPDX- PITTING CORROSION IN RIGHT HAND INBOARD SEAT TRACK 6 INCHES AFT OF FRAME 13815A. REPAIRED IAW FOKKER SRM 51-10-4 PAGE 8 AND 53-40-01.SDR QXEA0001387Seat Track · corrodedPDX- LIGHT CORROSION ON THE RIGHT HAND INBOARD SEAT TRACK LOCATED 6.5 INCHES AFT OF FRAME 15205. REPAIRED IAW FOKKER SRM 51-10-4 PAGE 8 AND 53-40-01.SDR QXEA0001386Seat Track · corrodedPDX- CORROSION ON RIGHT HAND OUTBOARD SEAT TRACK AFT OF FRAME 3820. REPAIRED IAW FOKKER SRM 50-10-4 PAGE 8.SDR QXEA0001384Seat Track · corrodedPDX- PITTING CORROSION ON RIGHT HAND OUTBOARD SEAT TRACK, CORROSION LOCATED APPROXIMTELY 5 AFT OF FRAME 11905. REPAIRED IAW FOKKER SRM 51-10-4 PAGE 8 AND 53-40-01.SDR QXEA0001381Seat Track · corrodedPDX- LEFT HAND INBOARD SEAT TRACK HAS CORROSION AT STATION 13853, FRAME 12405. REPAIRED IAW FOKKER SRM 51-10-4 PAGE 8 AND 53-40-01.SDR QXEA0001380Seat Track · corrodedPDX- LEFT HAND SEAT TRACK HAS CORROSION AT STATION 14323, FRAME 12875. REPAIRED IAW FOKKER SRM 51-10-4 PAGE 8.SDR QXEA0001379Seat Track · corrodedPDX- LEFT HAND SEAT TRACK HAS CORROSION AT STATION 15263 (FRAME 13815). REPAIRED IAW FOKKER SRM 51-10-4, 53-40-01 PAGE 8.SDR QXEA0001378Seat Track · nickedPDX- LEFT HAND INBOARD SEAT TRACK HAS NICKS FROM FRAME 4900 TO FRAME 4805. REPAIRED IAW FOKKER SRM 53-40-01 AND 51-10-4 PAGE 8.SDR QXEA0001377Seat Track · nickedPDX- LEFT HAND INBOARD SEAT TRACK HAS NICKS FROM FRAME 9805 TO FRAME 14285. REPAIRED IAW FOKKER SRM 53-40-01, 53-01-01, AND 51-10-4 PAGE 8.SDR QXEA0001376Seat Track · nickedPDX- NICK .001 INCH DEEP ACROSS TOP INBOARD OF LEFT HAND SEAT TRACK AT STATION 16202 AND FRAME 13815B. REPAIRED IAW FOKKER SRM 53-40-01 AND 51-10-4 PAGE 8.
Back to JASC 5347