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 DHL9780402CSeat Track · wornAT C-CHECK, FLOOR TRACK NR 1 FROM STA 150 TO 300 WORN. CUT OUT DAMAGED AREA FABRICATED AND INSTALLED SPLICES AND NEW SEAT TRACK PER SRM 53-2-3.SDR W8PA970040Floor Track · corrodedDURING C-CHECK, FOUND CORROSION ON CARGO FLOOR TRACK, BS 847, RBL 14, WL 161. REMOVED CORROSION, FOUND TO BE OUT OF LIMITS, FABRICATED AND INSTALLED NEW FLOOR TRACK PER SRM. (M)SDR DHL9780410CSeat Track · brokenAT C-CHECK, SEAT TRACK BROKEN OFF AT STA 1585. CUT OFF DAMAGED TRACK AND INSTALLED NEW PER SRM 53-2-3.SDR W8PA970024Floor Track · corrodedDURING C-CHECK, FOUND CORROSION ON CARGO FLOOR TRACK, BS 847, RBL 14, WL 161. REMOVED CORROSION, FOUND TO BE OUT OF LIMITS. FABRICATED AND INSTALL NEW FLOOR TRACK IAW SRM. (M)SDR 9701696303Seat Track · corrodedDURING C-CHECK, FOUND CORROSION ON CROWNLESS SEAT TRACK (P/N 140V5617-12/28) UPPER CHORD AT BS 510 AND RBL 40.55. REPAIRED PER EA 63-121345.SDR W8PA970026Cargo Track · corrodedDURING C-CHECK, FOUND CORROSION ON CARGO TRACK AT BS 500C - BS 500D, RBL 18, WL 155. REMOVED DAMAGED SECTION, FABRICATED NEW PART AND INSTALL IAW SRM. (M)SDR P5CA9700053Seat Track · corrodedLEVEL 1 CORROSION ON SEAT TRACK INBOARD OF L1 DOOR AT BS 420. REMOVED CORROSION AND TREATED AREA PER BAC SRM 51-10-01 AND SRM 51-10-02.SDR DHL9780321CSeat Track · damagedAT C-CHECK, MAIN CARGO COMPT BS 359, 2ND SEAT TRACK FROM LEFT DAMAGED. CUT OUT SEAT TRACK AND INSTALLED NEW TRACK PER SRM 53-2-3.SDR DHL9780320CSeat Track · damagedAT C-CHECK, MAIN CARGO COMPT AT BS 329 SEAT TRACK, 2ND FROM LEFT IS DAMAGED. CUT OUT DAMAGED SECTION OF SEAT TRACK AND REINSTALLED NEW SECTION PER SRM 51-1-8, FROM STA 230 TO 360.SDR C2XA97IA031Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE SEAT TRACKS FOR THE FLIGHT ATTENDANTS SEAT WERE FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED SEAT TRACKS, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA97IA030Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE RIGHT INBOARD SEAT TRACK AT FRAME 33 TO 36 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED SEAT TRACK, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR TWAA9710012Tie Down Track · corrodedMCI - DURING OP-16, FOUND CORROSION AT MOUNT SCREW HOLES ON AFT CARGO RT TIEDOWN TRACK, FROM 1007 TO 1155. REPLACED TRACK PER SRM 51-01, PAGE 1 AND TWA STANDARD PRACTICES. (M)SDR TWAA9710007Chair Track · corrodedMCI - DURING OP-16, FOUND CORROSION ON CHAIR TRACK, FS 1240 TO FS 1309, LBL 45. REPLACED TRACK LBL 45 FROM FS 1222 TO FS 1309 PER SRM 53-05, FIGURE 4F, AND SRM 51-60-0. (M)SDR DHL9780314CSeat Track · wornAT C-CHECK, MAIN CARGO COMP STA 155 SEAT TRACK WORN. CUT OUT DAMAGED SEAT TRACK AND INSTALLED NEW SEAT TRACK PER SRM 53-2-3.SDR DHL9780323CSeat Track · damagedAT C-CHECK, MAIN CARGO COMPT BS 1600, 2ND SEAT TRACK FROM LEFT HAS SEVERAL AREAS OF DAMAGE. CUT OUT DAMAGED AREA AND INSTALLED NEW SEAT TRACK PER SRM 53-2-3.SDR DHL9780322CSeat Track · damagedAT C-CHECK, MAIN CARGO COMPT SEAT TRACK AT BS 685, 3RD TRACK FROM LEFT HAS DAMAGE AT PALLET LOCK. CUT OUT DAMAGED SECTION AND REPLACED WITH REPAIR CHANNEL AND PLUG PER SRM 53-2-3 AND 51-3-0.SDR UPS97221818Seat Track · corrodedINSPECTION TYPE-C, BS 480 TO 500 RBL 65 WL 208 THERE IS CORROSION IN THE SEAT TRACK WELL. REPLACED SEAT TRACK PER SRM 53-10-5, 51-30-2.SDR TWAA9708015Floor Track · corrodedMCI - DURING OP-16, FOUND CORROSION IN CABIN ON FLOOR TRACK, STATION 1208, LBL 55. REPLACED FLOOR TRACK PER SRM 51-60-0 AND SRM 51-00. (M)SDR TWAA9708013Floor Track · gougedMCI - DURING OP-16, FOUND FLOOR TRACK MID-CARGO BIN GROUNDED AND GOUGED, STATION 527-786, BL 17L. REMOVED AND INSTALLED NEW FLOOR TRACK PER SRM 53-05. (M)SDR TWAA9708011Floor Track · corrodedMCI - DURING OP-16, FOUND CORROSION ON FLOOR TRACK, LBL 36 STATION 1117-1136. REMOVED AND REPLACED TRACK PER SRM 51-10-3 AND SRM 20-10-13. (M)SDR TWAA9708010Floor Track · corrodedMCI - DURING OP-16, FOUND CORROSION ON AFT BAGGAGE COMPARTMENT FLOOR TRACK, STATION 1193-1211, LEFT SIDE. INSTALLED NEW SECTION OF TRACK PER SRM 53-05, FIGURE 4. (M)SDR TWAA9708009Floor Track · corrodedMCI - DURING OP-16, FOUND CORROSION ON CABIN FLOOR TRACK, RBL 22, STATION 200-237. REPLACED PER SRM 51-00 FROM STATION 200-225, AND INSTALLED SEAT TRACK PER SRM 53-05, AT STATION 275, RBL 22. (M)SDR TWAA9708007Floor Track · corrodedDURING CHECK 'C', FOUND CORROSION ON LEFT AND RIGHT HAND FLOOR TRACKS, STA 1007 - STA 1167. REMOVED AND REPLACED DAMAGED SEAT TRACK PER SRM 51-30-1 AND SRM 53-05-4G. AIRCRAFT TOTAL TIME: 19,271 HOURS; 15,595 CYCLES.SDR UPS97222165Seat Track · corrodedINSPECTION TYPE-C, SEAT TRACK BS 760 TO 850 IS SEVERELY CORRODED. REMOVED AND REPLACED SEAT TRACK PER SRM 51-30-2 AND 51-10-1.SDR GTIA9700100Seat Track · corrodedMHV - OUTBOARD SEAT TRACK RIGHT SIDE AT STATION 200-237 IS CORRODED BEYOND LIMITS. FABRICATED NEW SEAT CHANNEL FROM EXISTING SEAT TRACK MATERIAL INSTALLED SEAT TRACK IAW 53-05 FIG 4A-1 PAGE 8E. (M)SDR F3LA97006Seat Tracks · corrodedPAE - FOUND CORROSION (53-107-02) ON SEAT TRACK BS 328 TO 360, RBL 22 WL 208. REMOVED CORRODED SEAT TRACK AT BS 328 TO 360 RBL 22 WL 208 AND REPLACED WITH NEW SEAT TRACK IAW SRM 51-30-2, MM 51-21-1 AND 51-21-171. (M)SDR AALA970136Roller Track · corrodedTUL - THE LEFT INBOARD GALLEY ROLLER TRACK HAS CORROSION WHERE THE ROLLER CLIPS USED TO BE BETWEEN STATION 695 AND 879. REMOVED CORRODED TRACK, FABRICATED NEW TRACK AND INSTALLED PER AARD 51-01-00-05. (M)SDR MWEA97063Seat Track · corrodedDURING D-CHECK, FOUND NR 2 SEAT TRACK FWD END HAD AREA OF LIGHT CORROSION ON BOTTOM CENTER. MAINT FAB AND INSTALLED A NEW SECTION OF SEAT TRACK IAW 53-05 FIG 4.SDR MWEA97045Seat Track · corrodedDURING D-CHECK, FOUND NR 1 SEAT TRACK CORRODED BEYOND LIMITS AT STA 952 LOWER INBD RAIL. MAINTENANCE INSTALLED SPLICE REPAIR IAW SRM 53-05 FIG 4F AND 4D.SDR MWEA97044Seat Track · wornDURING D-CHECK, FOUND NR 2 SEAT TRACK WORN BEYOND LIMITS AT STA 888. MAINTENANCE INSTALLED SPLICE REPAIR AT STA 888 IAW SRM 53-05 FIG 4A.SDR MWEA97043Seat Track · wornDURING D-CHECK, FOUND NR 3 SEAT TRACK WORN BEYOND LIMITS AT STA 870 AND 879. MAINTENANCE INSTALLED SPLICE REPAIR IAW SRM 53-05 FIG 4A.SDR MWEA97041Seat Track · corrodedDURING D-CHECK, FOUND NR 4 SEAT TRACK HAS CORROSION AT FWD END STA 200. MAINTENANCE SPLICED IN NEW SECTION OF SEAT TRACK IAW SRM 53-05 FIG 4-F.SDR PCAA9700337Seat Track · corrodedDURING A SCHEDULED C-CHECK, THE LEFT INBOARD CABIN SEAT RAIL WAS FOUND CORRODED ON FORWARD SECTION, STATION X198-X22. REPAIRED CORRODED AREAS IAW DHC REPAIR DRAWING, (RD) 8-53-2565. A/C RETURNED TO SERVICE. (M)SDR PCAA9700336Seat Track · corrodedDURING A SCHEDULED C-CHECK, THE RIGHT INBOARD CABIN SEAT RAIL, FORWARD SECTION, WAS FOUND CORRODED. REMOVED AND REPLACED RIGHT INBOARD FORWARD SEAT RAIL IAW DHC DRAWINGS. A/C RETURNED TO SERVICE. (M)SDR C2XA97IA024Seat Track · corrodedDURING A ROUTINE INSPECTION, THE AFT CABIN RT OUTBOARD SEAT TRACK WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE PERFORMED A SPLICE REPAIR AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA97IA023Seat Track · corrodedDURING A ROUTINE INSPECTION, THE AFT CABIN RIGHT INBOARD SEAT TRACK WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE PERFORMED A SPLICE REPAIR AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA97IA022Seat Track · corrodedDURING A ROUTINE INSPECTION, THE FLIGHT ATTENDANT SEAT ATTACHMENT FLOOR TRACKS WERE FOUND TO HAVE CORROSION BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACKS AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR 9700826625Seat Track · corrodedDURING PERIODIC CHECK, FOUND CORROSION ON SEAT TRACK FLANGE. REPAIRED PER EA 66-121308.SDR C2XA97IA010Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE RIGHT AFT WALL SEAT TRACK WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED SEAT TRACK, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA97IA009Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE LEFT FORWARD SIDE WALL SEAT TRACK WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED SEAT TRACK, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA97IA008Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE RIGHT FORWARD SIDEWALL SEAT TRACK WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED SEAT TRACK, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA97IA007Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE RIGHT FORWARD FLOOR SEAT TRACK WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED SEAT TRACK, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA97IA006Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE LEFT FORWARD SEAT TRACK WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED SEAT TRACK, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA97IA005Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE LEFT AFT FLOOR SEAT TRACK WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED SEAT TRACK, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR AALA970021Seat Track · corrodedTUL - FOUND CORROSION AROUND FASTENERS IN THE RIGHT OUTBOARD SEAT TRACK AT STATION 440. REMOVED AND REPLACED RIGHT OUTBOARD SEAT TRACK, FS 344 TO 480 PER SRM 53-0-5. (M)SDR GTIA9700092Seat Track · corrodedMHV - FORWARD CABIN SEAT TRACK AT RBL 22 FS 200 THROUGH 230 AT STATION 200 HAS CRACKS, DRILL START AND CORROSION. REMOVED OLD SENT TRACK, FABRICATED AND INSTALLED NEW SEAT TRACK IAW 51-10-3, 51-10-2 AND 53-05. (M)SDR AALA970032Seat Track · corrodedTUL - FOUND CORROSION IN NR 8 SEAT TRACK AT LAV B OUTBOARD AFT TIEDOWN. ACCOMPLISHED A STANDARD SEAT TRACK REPAIR PER SRM 53-70-00-0 VOL 1 PAGE 3 AND 4. (M)SDR RAIA961264Seat Track · corrosionSTL - FOUND CORROSION ON FLIGHT ATTEND SEAT TRACK LEFT SIDE FROM FRAME 36 TO 38. MAINTENANCE REPLACED LEFT FLIGHT ATTEND SEAT TRACK FROM FRAME 36 YO 38 IAW ATR 42 SRM 53-53-00. (M)SDR RAIA961263Seat Track · corrosionSTL - FOUND CORROSION ON FLIGHT ATTENDANT SEAT TRACK RIGHT SIDE FROM FRAME 36 TO 38. MAINTENANCE REPLACED RIGHT FLIGHT ATTEND SEAT TRACK FROM FRAME 36 TO 38 IAW ATR 42 SRM 53-53-00. (M)SDR RAIA961262Seat Track · corrosionSTL - FOUND CORROSION ON RIGHT OUTBOARD SEAT TRACK FLOOR BEAM 35 AND 36. MAINTENANCE REPLACED AFT SECTION OF RIGHT OUTBOARD SEAT TRACK FROM FLOOR BEAM 36 FORWARD IAW ATR 42 SRM 53-53-00. (M)
Back to JASC 5347