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 CALA9800287Track · corrodedINSPECTION FOUND AFT CARGO COMPARTMENT LT SIDE TIE DOWN TRACK CORRODED FROM FRONT TO BACK AND DRAIN HOLE WAS FOUND CLOGGED. A NEW TIE DOWN TRACK WAS FABRICATED AND INSTALLED IAW SRM 51-00-01.SDR DHL9872468CSeat Track · corrodedAT C-CHECK, FOUND HEAVY CORROSION ON FLOOR TRACK FLANGES AT STA 660, BL 0 TO 24L. CUT OUT DAMAGED SECTION, INSTALLED SEAT TRACK REPAIR PER SRM 53-10-5, 10.5 LONG. N/R 5157.SDR 98ZZZM396Seat Track · corrodedSAW - DURING C-CHECK INSPECTION, MAINTENANCE REPORTED LEFT OUTBOARD AFT SEAT TRACK CORRODED. INSTALLED NEW LEFT OUTBOARD AFT SEAT TRACK IAW ASA EO 72-53-0044. AIRCRAFT RETURNED TO SERVICE. (M)SDR UPS98225859Seat Track · corrodedINSPECTION TYPE-SI, CORROSION ON CARGO TRACK IN WELL OF TRACK AT BS 675 TO 680, WL 155, RBL 15. REMOVED DAMAGED SECTION OF CARGO TRACK, FABRICATED AND INSTALLED REPLACEMENT SECTION IAW SRM 53-10-5.SDR EIAA980135Track · crackedDURING 'C5/D' CHECK INSPECTION, FORWARD CARGO COMPARTMENT TIE-DOWN TRACK FOUND CRACKED AT BS 570 RBL 25. REPAIRED TRACK IAW SRM 53-10-05 FIG 5. (X)SDR UPS98226021Seat Track · corrodedINSPECTION TYPE:SI CORROSION (4-25-02) ON MAIN DECK SEAT TRACK FLANGE FASTENER HOLES, AS MARKED AT BS 595-BS 684 RBL 23, WL 208. REMOVED OUT OF LIMITS SECTION OF SEAT TRACK, FABRICATED AND INSTALLED NEW SECTION OF SEAT TRACK AND REPAIR PARTS IAW SRM 51-10-2, SDR UPS98225855Seat Track · corrodedINSPECTION TYPE-SI, CORROSION AROUND NUT PLATES BS 861, RBL 24, WL 208. REMOVED AND REPLACED SECTION OF SEAT TRACK AND EXPANSION LINK IAW SRM 51-30-2.SDR UPS98225854Seat Track · corrodedINSPECTION TYPE-SI, WHILE WORKING CUST ID 2-224-22B FOUND CORROSION ON SEAT TRACK INBD FLANGE STA 730, LBL 65, WL 208. REMOVED DAMAGED SECTION OF SEAT TACK AND SPLICED IN NEW SECTION IAW SRM 53-10-5.SDR CKSA98089Seat Track · damagedDURING NON-ROUTINE MAINTENANCE FOUND, CENTER SEAT TRACK IN MAIN CARGO REQUIRES SPLICE AT FS 660. REMOVED AND REPLACED CENTER SEAT TRACK IAW DC8 SRM 53-2-3. NON-ROUTINE ITEM NUMBER 30.SDR AALA980362Roller Tray · corrodedROLLER TRAY NR 5 HAS CORROSION ON LOWER SURFACE AFT OF STA 859 (X +166). CORRODED SECTION OF TRAY REPLACED PER AARD 51-01-00-5 AND ALODINED, TREATED, PRIMED AND PAINTED PER SRM 51-21-01 VOL II. TST: 60,422.53 HOURS. CYCLES: 20,166. (X)SDR AALA980361Roller Tray · corrodedCORROSION ON ROLLER TRAY NR 5 JUST FORWARD OF STA 879 (X +66). CORRODED SECTION OF TRAY REPLACED PER AARD 51-10-00-05 AND ALODINED, TREATED, PRIMED, AND PAINTED PER SRM 51-21-01 VOL II. TST: 60,422.53 HOURS. CYCLES: 20,166. (X)SDR AALA980360Roller Tray · corrodedTUL - NR 2 ROLLER TRAY HAS CORROSION FROM STA 595 - STA 745. SPLICED IN NEW TRAY SECTION PER SRM 53-70-00. TST: 60,422.53 HOURS. CYCLES: 20,166. (X)SDR QXEA9800367Seat Track · gougedPDX - LEFT INBOARD SEAT TRACK HAS TWO GOUGES ON THE TOP FLANGE SEVEN INCHES BEHIND FRAME 10346 THAT HAVE BEEN BLENDED BEYOND LIMITS. BLENDING EXTENDS .030 TO .040 DOWN INTO RADIUS OF SEAT TRACK MOUNTING HOLE. REPAIRED IAW FOKKER SRM 53-02-15SDR QXEA9800366Seat Track · damagedPDX - DAMAGE IN SEAT TRACK SIX INCHES FORWARD OF FRAME 5805, MEASURED .289 DEEP, LEFT INBOARD SEAT TRACK. REPAIRED IAW FOKKER SRM 53-02-15, PAGE 3, FIGURE 1.SDR DHL9872469CSeat Track · corrodedAT C-CHECK, SEAT TRACK FLANGE CORRODED AT LBL 45 BETWEEN STA 560 AND 620. CUT OUT CORRODED AREA STA 560 TO 580. INSTALLED NEW SECTION PER SRM 53-10-5. N/R 5143.SDR AALA98363Seat Track · corrodedTUL - FOUND CORROSION ON SEAT TRACK. REMOVED AND REPLACED SECTION OF TRACK STANDARD SEAT TRACK REPAIR PER 53-70-00-0 VOL I. (M)SDR AALA980337Roller Tray · corrodedTUL - CORROSION UNDER LT SLIDING DOOR AFT SIDE ANGLE STA 876 FORWARD AND INBOARD OF ROLLER TRAY NR 2 IN CARGO. REMOVED CORRODED PIECE, FABRICATED NEW AND INSTALLED PER SRM 51-10-00-01 AND 51-01-00-05 OF AARD AND SRM CHAPTER 51. TST: 60,422.53 HOURS. CYCLES:SDR AALA980336Roller Tray · corrodedTUL - NR 4 ROLLER TRAY HAS NUMEROUS SPOTS OF CORROSION FROM STA 760 TO STA 595. REMOVED CORRODED TRACK, FABRICATED NEW TRACK AND REINSTALLED PER SRM 51-01-05. TST: 60,422.53 HOURS. CYCLES: 20,166. (X)SDR AALA980335Roller Tray · corrodedTUL - NUMEROUS SPOTS OF CORROSION IN ROLLER TRAY NR 4 BETWEEN STA 879 AND STA 769. REMOVED CORRODED SECTION OF TRACK, FABRICATED NEW AND INSTALLED PER SRM 51-01-05. TST: 60,422.53 HOURS. CYCLES: 20,166. (X)SDR AALA980334Roller Tray · corrodedTUL - CORROSION IN ROLLER TRAY NR 4 STA 859 TO STA 865. REMOVED CORRODED SECTION OF TRACK, FABRICATED NEW AND INSTALLED PER SRM 51-01-05. TST: 60,422.53 HOURS. CYCLES: 20,166. (X)SDR AALA980341Roller Tray · corrodedTUL - NR 2 ROLLER TRAY HAS NUMEROUS AREAS OF CORROSION STA 745 - STA 875. SPLICED IN NEW TRAY FROM STA 840 - STA 875 PER SRM 53-70-00 VOL I. TST: 60,422.53 HOURS. CYCLES: 20,166. (X)SDR AALA980330Roller Tray · corrodedTUL - AREAS OF CORROSION ON ROLLER TRAY NR 1 FROM STA 770 - STA 879. SPLICED IN NEW TRACK PER SRM 53-70-00. TST: 60,422.53 HOURS. CYCLES: 20,166. (X)SDR CALA9800258Track · holeINSPECTION FOUND A HOLE ON FLOOR TRACK IN AFT CARGO BILGE AREA AT STA 1841, RBL 25. A NEW SPLICE ANGLE AND STRAP WERE FABRICATED AND INSTALLED IAW MF MAN D10-53-86784.SDR UPS98825895Seat Track · corrodedINSPECTION TYPE:C F/S 1024 LBL 59 - SEAT TRACK HAS HEAVY CORROSION. REMOVED, FABRICATED, AND INSTALLED REPLACEMENT SECTION OF TRACK IAW SRM ADDN DC8-5320-5167-C.SDR UPS98825894Seat Track · corrodedINSPECTION TYPE:C F/S 1207 LBL 59, SEAT TRACK HAS HEAVY CORROSION. REMOVED, FABRICATED, AND INSTALLED REPLACEMENT SECTION OF TRACK IAW SRM 53-7-2.SDR UPS98825893Seat Track · corrodedINSPECTION TYPE:C F/S 260 RBL 48 - SEAT TRACK HAS HEAVY CORROSION. REMOVED, FABRICATED, AND INSTALLED REPLACEMENT SECTION OF TRACK IAW SRM ADDM DC8-5320-8309.SDR UPS98226022Seat Track · corrodedINSPECTION TYPE:SI CORROSION (C53-224-01.00-03) ON SEAT TRACK UPPER FLANGE BS 1125-BS 1130,, LBL 55, WL 208. REMOVE CORROSION AND OUT OF LIMITS IAW SRM 53-10-1. REPLACED TRACK IAW SRM 51-30-2, SRM 51-10-1, 51-10-1, 51-10-6 AND MM 51-20-151.SDR SIMA980404Seat Track · corrodedSAW - DURING CPCP-4 INSPECTION MAINTENANCE REPORTED THE FOLLOWING SEAT TRACKS WERE CORRODED. THE LEFT OUTBOARD, LEFT AFT INBOARD, RIGHT AFT OUTBOARD, RIGHT AFT INBOARD. MAINTENANCE REMOVED AND REPLACED SEAT TRACKS IAW SRM 51-25-04. A/C WAS RETURNED TO SERVISDR SIMA980403Seat Track · corrodedSAW - DURNG CPCP-4 INSPECTION MAINTENANCE REPORTED THE FOLLOWING SEAT TRACKS WERE CORRODED. THE LEFT AFT OUTBOARD, LEFT AFT INBOARD, RIGHT AFT OUTBOARD, RIGHT AFT INBOARD, RIGHT AFT CARGO, RIGHT FLIGHT ATTENDANT AND LEFT FLIGHT ATTENDANT. MAINTENANCE REMOVEDSDR MWEA98149Seat Track · corrodedDURING INSPECTION, FOUND HEAVY CORROSION ON GALLEY SEAT TRACK NR 4 FROM STATION 200 TO 240. MTC REPAIRED IAW SRM 51-30-2 AND SRM 53-05 FIG 4F.SDR GAIA9815Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS ON THE FLOOR SEAT TRACKS AT BS 383 LBL 44.5. (M)SDR EISA98030Seat Track · corrodedDURING C-CHECK, FOUND CORROSION ON SEAT TRACK, LEFT SIDE FROM FS 750 TO 950E ON MAIN CARGO DECK. REMOVED TRACK AND INSTALLED NEW SEAT TRACK IAW SRM 53-10-05. (M)SDR EISA98024Seat Track · corrodedDURING C-CHECK, FOUND CORROSION ON FLOORBEAM AND SEAT TRACK AT FS 560-580. SURFACE CORROSION REMOVED ON FLOORBEAM. FOUND IN LIMITS PER SRM 53-10-1. INSTALLED NEW SECTION OF SEAT TRACK. (M)SDR EISA98023Seat Track · corrodedDURING C-CHECK, FOUND FS 580 RT AND 620 CORROSION ON CENTER BEAM AND SIDE OF SEAT TRACK. REMOVED SURFACE CORROSION ON FLOORBEAM AND FOUND TO BE IN LIMITS. REMOVED AND REPLACED SEAT TRACK PER 53-10-1 DUE TO CORROSION OUT OF LIMITS. (M)SDR 98ZZZM316Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS ON THE FLOOR SEAT TRACKS AT BS 604 RBL 44.5. (M)SDR 98ZZZM315Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS ON THE FLOOR SEAT TRACKS AT BS 784 RBL 22. (M)SDR 98ZZZM314Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS ON THE FLOOR SEAT TRACKS AT BS 675 RBL 22. (M)SDR 98ZZZM313Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS ON THE FLOOR SEAT TRACKS AT BS 674 RBL 22. (M)SDR 98ZZZM312Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS ON THE FLOOR SEAT TRACKS AT BS 519 RBL 22. (M)SDR 98ZZZM311Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS ON THE FLOOR SEAT TRACKS AT BS 764 LBL 22. (M)SDR 98ZZZM310Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS ON THE FLOOR SEAT TRACKS. (M)SDR 98ZZZM309Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS ON THE FLOOR SEAT TRACKS AT BS 680 LBL 22. (M)SDR 98ZZZM308Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS ON THE FLOOR SEAT TRACKS AT BS 585 LBL 22. (M)SDR 98ZZZM307Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS ON THE FLOOR SEAT TRACKS AT BS 568 LBL 22. (M)SDR 98ZZZM306Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS ON THE FLOOR SEAT TRACKS AT BS 517 LBL 22. (M)SDR 98ZZZM305Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS ON THE FLOOR SEAT TRACKS AT BS 695 LBL 44.5. (M)SDR 98ZZZM304Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS ON THE FLOOR SEAT TRACKS AT BS 634 LBL 44.5. (M)SDR 98ZZZM303Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS ON THE FLOOR SEAT TRACKS AT BS 602 LBL 44.5. (M)SDR 98ZZZM302Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS ON THE FLOOR SEAT TRACKS AT BS 516 LBL 44.5. (M)SDR 98ZZZM301Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS ON THE FLOOR SEAT TRACKS AT BS 428 LBL 44.5. (M)
Back to JASC 5347