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 FDEA200912074363Seat Track · crackedAFT CARGO COMPARTMENT; DUMMY SEAT TRACK; OVERHEAD MAIN CABIN FLOOR STRUCTURE IS CRACKED IN THE RADIUS AT FRAME 60. STR 30R. REMOVED DUMMY SEAT TRACK IAW AMM 51-40-21, PG 7. LOCATED AND DRILLED HOLES IN THE NEW SEAT TRACK PN A5327828820300, PO NR 592553.5 IAW SDR C2XA09SH469Support · corrodedSHV - DURING C-CHECK LT UPPER SEAT TRACK SUPPORT CORRODED (LEVEL 3 LOCAL) AT FRAME 46 ATTACHMENT. MAINTENANCE REPAIRED LT UPPER SEAT TRACK SUPPORT AT FRAME 46 IAW EC5320-01512. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA09SH468Support · corrodedSHV - DURING C-CHECK LT UPPER SEAT TRACK SUPPORT CORRODED (LEVEL 3 LOCAL) AT FRAME 50 ATTACHMENT. MAINTENANCE REPAIRED LT UPPER SEAT TRACK SUPPORT AT FRAME 50 IAW EC5320-01512. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA09SH467Support · corrodedSHV - DURING C-CHECK RT UPPER SEAT TRACK SUPPORT CORRODED (LEVEL 2 LOCAL) AT FRAME 50 IAW EC5320-01512. MAINTENANCE REPAIRED RT UPPER SEAT TRACK SUPPORT AT FRAME 50 IAW EC5320-01512. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA09SH466Support · corrodedSHV - DURING C-CHECK RT UPPER SEAT TRACK SUPPORT CORRODED (LEVEL 2 LOCAL) AT FRAME 46. MAINTENANCE REPAIRED RT UPPER SEAT TRACK SUPPORT AT FRAME 46 IAW EC5320-01512. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR ASOA200901352Cargo Track · corrodedTRACK SEGMENTS IN THE CARGO BAY ARE CORRODED. REPAIRS MADE IAW SRM 51-41-02, STEP 1(A), SRM 53-61-49, SRM 53-61-49 AND AMM 20-21-00-910-801 STEPS 2A. A-B AND STEP 3A 1-6, IAW AMM 20-21-00-910-801 STEP 2A(1A).SDR ASOA200901351Seat Track · corrodedCARGO COMPT SEAT TRACK CORRODED APPROX FS559.0+85 TO FS559.0+94 AT RBL 9.0 (MARKED).SDR ASOA200901350Seat Track · corrodedCARGO COMPT SEAT TRACK CORRODED APPROX. FS559.0+79 TO FS559.0+96 AT RBL 27.0 (MARKED).SDR ASOA200901349Seat Track · corrodedCARGO COMPT SEAT TRACK CORRODED APPROX. FS559.0+111 TO FS574.0 AT RBL 9.0 (MARKED).SDR ASOA200901348Seat Track · corrodedCARGO COMPT SEAT TRACK CORRODED APPROX. FS 559.0+111 TO FS 574.0 AT LBL 9.0 (MARKED).SDR ASOA200901347Seat Track · corrodedCARGO COMPT SEAT TRACK CORRODED APPROX. FS 615.0 TO FS 618.0 AT LBL 9.0 (MARKED).SDR FDEA200912044361Seat Track · corrodedCORROSION ON SEAT TRACK FLANGES RBL 24 BETWEEN BS 1130 TO BS 1183. REMOVED SECTION OF SEAT TRACK IAW SRM 51-30-2, REV 101, FABRICATED NEW SEAT TRACK SECTION IAW DWG 53FX976, LOCATED AND DRILLED NEW SEAT TRACK IAW SRM 51-30-5 AND DWG 53FX976, TREATED AND PRISDR FDEA200912044359Seat Track · corrodedMAIN DECK, CARGO COMPT STA 1341-1361 X=75.5 SEAT TRACK FOUND CORRODED. MAIN DECK CARGO COMPT CORRODED SEAT TRACK AT STA 1341 TO STA 1361 X=-75.5 REPAIRED BY SECTIONAL SEAT TRACK REPLACEMENT FROM STA 1279 TO STA 1391 X=-75.5 IAW SRM 53-00-52, FIG 201 REPAIR SDR FDEA200912044356Seat Track · crackedFWD CARGO COMPARTMENT MAIN CABIN FLOOR SEAT TRACK IS CRACKED AT FRAME 29; LBL 30. REMOVED FLOORBOARDS 231UG; HH; JH AND YG IAW AMM 53-10-23-4. REMOVED SUBSTRUCTURE ANGLES; SPLICES AND DAMAGED SECTION OF SEAT TRACK FROM FRAME 26.5 TO FRAME 29.5, LBL 30 IAW SRSDR FDEA200912034346Seat Track · gougedMCD SEAT TRACK HAS NUMEROUS GOUGES APPROX BETWEEN STA 1180 TO STA 1280 AT RBL 25. BLENDED GOUGES IN SEAT TRACK IAW SRM 53-00-52. ORIGINAL MATERIAL THICKNESS; .250" /AFTER REWORK; .017"/ MATERIAL LOSS; .080". FOUND TO BE OUT OF LIMITS IAW SRM 53-00-52, PAGE 10SDR A6WA201040013Cargo Track · corrodedCARGO TIE DOWN TRACK BTW FS 559+96 AND 559+80, RBL 9.0 CORRODED. CARGO TIE DOWN TRACK BTW FS 559+80, RBL 9.0 CORROSION REMOVED IAW SRM 51-21-06.SDR ASOA200901363Cargo Track · corrodedCARGO BAY ALL SEAT TRACK SECTIONS CORRODED.SDR A6WA200940707Seat Track · corrodedCORROSION FOUND ON BAGGAGE RAIL BTW FS 559.00 +95 TO FS 567.00 AT LBL 9. ON BAGGAGE RAIL BTW FS 559.00 +95 TO FS 567.00 AT LBL 9 REPLACED IAW AMM 53-01-11-400-802. (K)SDR UHLA2009120100119Seat Track · corrodedRIGHT I/B SEAT TRACK HAS SEVERAL AREAS OF CORROSION AT TOP SURFACE, FRAMES 13 TO 17. REMOVED AND REPLACED SEAT TRACK SUPPORT BEAM FROM FR 12R TO FR 20R IAW EMB 170 SRM 51-41-01, 51-43-01, 51-43-02, AND 51-43-03.SDR FDEA200912014312Cargo Track · corrodedAFT CARGO COMPARTMENT BETWEEN STA 1380 AND 1620 TIE DOWN FITTINGS CORRODED AROUND NUTPLATES AND UPPER SURFACE. CORRODED TIE DOWN FITTINGS BETWEEN STA 1380 AND STA 1620 REMOVED AND REPLACED IAW SRM 51-40-02 REV 98. REPAIR IS CLASSIFIED AS MINOR IAW GMM 6-2-SDR FDEA200912014310Cargo Track · corrodedAFT CARGO COMPARTMENT TIE DOWN FITTINGS HAVE CORROSION AROUND NUTPLATES AND UPPER SURFACE CORROSION FROM STA 1220 TO 1380. TIE DOWN FITTING FROM STA 1220 TO STA 1380 REMOVED AND REPLACED IAW SRM 51-40-02 REV 98. REPAIR IS CLASSIFIED AS MINOR IAW GMM 6-2-10SDR FDEA200911304258Seat Track · gougedMAIN CABIN SEAT TRACK IS GOUGED AT FRAME 28; LBL 71. BLENDED OUT GOUGE AREA IAW SRM 53-10-16. REMOVED 0.009 OF MATERIAL. MAXIMUM ALLOWABLE MATERIAL LOSS IS 0.040. REMAINING MATERIAL WITHIN ALLOWABLE LIMITS IAW 53-10-16, FIG 102. ALODINED AND PRIMED IAW SRSDR FDEA200911304257Seat Track · corrodedMAIN CABIN SEAT TRACK IS CORRODED AT FRAME 20; LBL 88. REMOVED CORROSION IAW SRM 53-10-16. REMOVED 0.019 OF MATERIAL. MAXIMUM ALLOWABLE MATERIAL LOSS IS 0.040. REMAINING MATERIAL IS WITHIN ALLOWABLE LIMITS IAW SRM 53-10-16, FIG 101. ALODINED & PRIMED IAWSDR FDEA200911304256Seat Track · corrodedMAIN CABIN SEAT TRACK IS CORRODED FROM BS 3692 TO BS 3695; LBL 18. REMOVED CORROSION IAW SRM 53-10-16. REMOVED 0.019 OF MATERIAL. MAXIMUM ALLOWABLE MATERIAL LOSS IS 0.040. REMAINING MATERIAL IS WITHIN ALLOWABLE LIMITS IAW A300-600 SRM 53-10-16, FIG 101.SDR FDEA200911304255Seat Track · corrodedMAIN CABIN SEAT TRACK IS CORRODED FROM BS 4927 TO BS 4932; LBL 0. REMOVED CORROSION IAW SRM 53-10-16. REMOVED 0.019 OF MATERIAL. MAXIMUM ALLOWABLE MATERIAL LOSS IS 0.040. REMAINING MATERIAL IS WITHIN ALLOWABLE LIMITS IAW SRM 53-10-16, FIG 101. ALODINED SDR FDEA200911304301Cargo Track · corrodedAFT CARGO COMPARTMENT BETWEEN STATION 1380 AND 1620 HAS CORRODED TIEDOWNS AROUND NUTPLATES AND UPPER SURFACE AT STRINGER 26L. CORRODED TIE-DOWN FITTINGS FROM STA 1380 TO STA 1620 REMOVED AND REPLACED IAW SRM 51-40-02 REV.98. REPAIR IS CLASSIFIED AS MINOR IAW SDR FDEA200911304300Cargo Track · corrodedAFT CARGO COMPT TIE DOWN FITTING HAS CORROSION AROUND NUTPLATES AND UPPER SURFACE FROM STA 1220 TO 1380 LBL 23". CORRODED TIE-DOWN FITTING FROM STA 1220 TO STA 1380 REMOVED AND REPLACED IAW SERM 51-40-02 REV 98. REPAIR IS CLASSIFIED AS MINOR IAW GMM 6-2-100 CSDR KCSA091133Seat Track · corrodedMAIN DECK SEAT TRACK CORRODED AT BS 1301, LBL 75.SDR A6WA201040016Cargo Track · corrodedCARGO TIE DOWN TRACK BTW FS 559+112, LBL 9.00 CORRODED. CARGO TIE DOWN TRACK BTW FS 559+112, LBL 9.00 REPLACED IAW AMM 20-21-00-910-801.SDR A6WA201040015Cargo Track · corrodedCARGO TIE DOWN TRACK BTW FS 559+112, RBL 9.00 CORRODED. CARGO TIE DOWN TRACK BTW FS 559+112, RBL 9.0 REPLACED IAW AMM 20-21-00-910-801.SDR A6WA201040014Cargo Track · corrodedCARGO TIE DOWN TRACK AT FS 617.00, LBL 9.00 CORRODED. CARGO TIE DOWN TRACK AT FS 617.00, LBL 9.0. REPLACED IAW AMM 20-21-00-910-801.SDR F3LA2009120800247Seat Track · corrodedREF NON ROUTINE C075806. DURING DEN C4/S1 C-CHECK, INSP NOTED CORROSION ON THE SEAT TRACK LOCATED AT FRAMES 64 TO 66 AND STA Y1292. MX REMOVED AND REPLACED SEAT TRACK IAW SRM 51-42-11, SRM 53-41-14, SRM 51-44-11, SRM 51-21-00, SRM 51-75-00 AND SRM 51-72-11.SDR AALA20091127TUL02Support · crackedSUPPORT CASTING CRACKED BELOW NUMBER 5 SEAT TRACK AT RIGHT STATION 927. REMOVED AND INSTALLED NEW SEAT TRACK SUPPORT PER SRM 51-01.SDR FDEA200911274204Seat Track · crackedDURING SURVEILLENCE FOUND SEAT TRACK FLANGE CRACKED AT APROX STA 490, RBL 415.5. REPAIRED SEAT TRACK IAW SRM 53-00-52 FIG 1, REPAIR 1, THIS IS A CATEGORY A REPAIR NO FOLLOW-UP INSPECTIONS REQUIRED.SDR FDEA200911254171Seat Track · gougedSEAT TRACK STA 418-440 RBL 24 GOUGED. BLENDED AREA ORIG- MAT .125, AFTER REWORK .098, OUT OF LIMITS, 1 IN X 1 IN AREA, IAW SRM 51-10-02, 53-00-52, DETAIL VII. REMOVED DAMAGED SEAT TRACK IAW SRM 51-40-02. FABRICATED NEW SEAT TRACK IAW SRM 53-10-52, FIG I, TRESDR FDEA200911254170Seat Track · gougedSEAT TRACK STA 418-440 RBL 45 IS GOUGED. REMOVED SEAT TRACK STA 418-440, RBL 45, IAW SRM 51-40-02. BLENDED AREA IAW SRM 51-10- 02, ORIG-MAT .125 AFTER REWORK .098 OUT OF LIMITS, I IN BY 1.5 IN AREA, IAW SRM 53-00-52, DETAIL VII. FABRICATED NEW SEAT TRACK IAWSDR KCSA091131Seat Track · crackedSTA 2205 LBL 88 MAIN DECK SEAT TRACK CRACKED .5 INCH.SDR ASAA0977087Seat Track · gougedSEAT TRACK LT INBOARD HAS MECHANICAL DAMAGE ON UPPER CROWN FLANGE. INSTALLED NEW SEAT TRACK.SDR C77A207785Seat Track · corrodedDURING BASIC CHECK INSP, MX VISIT CORROSION WAS FOUND ON LT FLOOR TRACK PN 170-03264-001 FROM FR17 TO FR19. PERMANENT REPAIR IAW ETD 2009-170/09356 AND EO E175-53MR-019. FLOORTRACK TO BE REPLACED AT NEXT BASIC CHECK MAINTENANCE VISIT.SDR QXEA2009112300998Seat Track · corrodedCHECK - LT INBD SEAT TRACK HAS AREAS OF LIGHT CORROSION ON OTBD FLANGE INBETWEEN STA 1.00 TO 32.4. REMOVED CORROSION IAW RD8/4-53-884, FOUND TO BE OUT OF LIMITS IAW RD 8/4-53-884. REMOVED SEAT TRACK IAW SRM 51-40-07 AND 51-40-15-02-01. MATCH DRILLED NEW NRSDR QXEA2009112300997Seat Track · corrodedC-CHECK-LT INBD SEAT TRACK IS CORRODED AT APPROX X160 TO X170. BLENDED CORROSION ON LT INBD SEAT TRACK AT STA X160 TO X170. REMOVED .029" MATERIAL, ORIGINAL THICKNESS .265", WITHIN LIMITS IAW RD8/4-53-884 GENERAL NOTES NR1. HFEC INSPECTED BLENDED AREA FOR SDR QXEA2009112300996Seat Track · corrodedC-CHECK-LT INBD SEAT TRACK IS CORRODED AT X200. BLENDED CORROSION ON LT INBD SEAT TRACK AT STA X200. REMOVED .022" MATERIAL, ORIGINAL THICKNESS .265" WITHIN LIMITS IAW RD8/4-53-884 GENERAL NOTES NR 1. HFEC INSPECTED BLENDED AREA FOR CRACKS IAW RD 8/4-53-884SDR QXEA2009112300995Seat Track · corrodedC-CHECK - LT INBD SEAT TRACK IS CORRODED AT X331. BLENDED CORROSION ON LT INBD SEAT TRACK AT STA X331. REMOVED .020" MATERIAL, ORIGINAL THICKNESS .265" WITHIN LIMITS IAW RD8/4-53-884 GENERAL NOTES NR 1. HFEC INSPECTED BLENDED AREA FOR CRACKS IAW RD 8/4-53-SDR QXEA2009112300994Seat Track · corrodedC CHECK- LT INBD SEAT TRACK IS CORRODED AT X413. BLENDED CORROSION ON LT INBD SEAT TRACK AT STA X413. REMOVED .024" MATERIAL ORIGINAL THICKNESS .265" WITHIN LIMITS IAW RD8/4-53-884 GENERAL NOTES NR 1. HFEC INSPECTED BLENDED AREA FOR CRACKS IAW RD 8/4-53-884SDR QXEA2009112300993Seat Track · corrodedC-CHECK - LT INBD SEAT TRACK HAS LIGHT CORROSION ON INBD FLANGE AT X630 TO 640. BLENDED CORROSION AT INBD SEAT TRACK ON INBD FLANGE AT X630 TO STA X640. REMOVED .019 MATERIAL ORIGINAL THICKNESS .080" WITHIN LIMITS IAW Q400 RD8/4-53-884 GENERAL NOTES NR1. SDR QXEA2009112300992Seat Track · corrodedC-CHECK, SEVERAL AREAS OF CORROSION ON THE RT INBD SEAT TRACK LUG AND CHANNEL FROM STA X19.400 TO X71.20. BLENDED CORROSION FROM RT INBD SEAT TRACK UPPER LUG AT STA X 1.0 IAW RD 8/4-53-884. FOUND TO BE OUT OF LIMITS IAW RD 8/4 53-884. REMOVED NR 11 SEAT TSDR QXEA2009112300991Seat Track · corrodedC-CHECK - CORROSION ON THE RT INBD SEAT TRACK UPPER LUG AT STA X1.00. BLENDED CORROSION FROM RT INBD SEAT TRACK UPPER LUG AT STA X 1.0 IAW RD 8/4-53-884. FOUND TO BE WITHIN LIMITS IAW RD 8/4 53-2358. HFEC INSPECTED BLENDED AREA FOR CRACKS IAW NDTM PART 6, SDR FDEA200911204105Seat Track · crackedWEB BENEATH LBL 45 SEAT TRACK CRACKED ON BOTTOM FLANGE, STA 660 TO 680. REMOVED WEB AND SPLICE PLATE IAW SRM 51-40-02, FABRICATED NEW WEB IAW DWG 140N2506 AND SPLICE PLATE IAW DWG 140N2505, TREATED AND PRIMED AND TOP COATED IAW SRM 51-20-01 AND AMM 51-21-01. ISDR UHLA2009111900129Seat Track · corrodedFWD CABIN LT SEAT TRACK BEAM FRAME 17 HAS LEVEL 2 CORROSION. REMOVED AND REPLACED LT SEAT TRACK BEAM IAW EMB 170 SRM 51-41-00, 51-43-03, 51-43-04.SDR FDEA200911194069Cargo Track · corrodedFWD CARGO COMPARTMENT AT STA 780 NEAR S26R, TIE DOWN CORRODED. CORRODED TIE-DOWN FITTING AT STA 780 REMOVED AND REPLACED IAW SRM 51-40-02 REV 98. REPAIR IS CLASSIFIED AS MINOR IAW GMM 6-2-100 CRITERIA.
Back to JASC 5347