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 FDEA200907272767Seat Track · corrodedMAIN DECK CARGO - SEAT TRACK STA 785, X = 8.5 FOUND WITH SURFACE CORROSION. REPAIRED BY SECTIONAL SEAT TRACK REPLACEMENT AS PER SRM 53-70-00 FIGURE 1 VOLUME I, REVISION 40. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100, REVISION 107.SDR FDEA200907272766Seat Track · corrodedMAIN DECK CARGO - SEAT TRACK STA 1621, X = -27.5 FOUND WITH SURFACE CORROSION. REPAIRED BY SECTIONAL SEAT TRACK REPLACEMENT FROM STA 1591 TO STA 1631, X = -27.5 AS PER SRM 53-70-00 FIGURE 1 VOLUME I, REVISION 40. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100,SDR FDEA200907272765Seat Track · corrodedMAIN DECK CARGO - SEAT TRACK STA 795, X = 8.5 FOUND WITH SURFACE CORROSION. REPAIRED BY SECTIONAL SEAT TRACK REPLACEMENT FROM STA 745 TO STA 800, X = 8.5 AS PER SRM 53-70-00 FIGURE 1 VOLUME I, REVISION 40. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100, REVSDR FDEA200907272764Seat Track · corrodedMAIN DECK CARGO - SEAT TRACK STA 1229, X = -75.5 FOUND WITH SURFACE CORROSION. REPAIRED AS PER SRM 53-70-00 FIGURE 6 VOLUME I, REVISION 40. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100, REVISION 107.SDR FDEA200907272763Seat Track · corrodedMAIN DECK CARGO - SEAT TRACK STA 735, X = 8.5 FOUND WITH CORROSION. REPAIRED BY SECTIONAL SEAT TRACK REPLACEMENT FROM STA 685 TO STA 745, X = 8.5 AS PER SRM 53-70-00 FIGURE 1 VOLUME I, REVISION 40. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100, REVISIONSDR ASAA0946256Seat Track · corrodedSEAT TRACK CORRODED. REPAIRED SEAT TRACK.SDR AALA20090730TUL27Seat Track · corrodedTUL - CORROSION IN NUMBER SIX SEAT TRACK GALLEY MOUNT. REMOVED AND REPLACED GALLEY MOUNT UNDER SRM 51-30-02.SDR AALA20090730TUL24Cargo Track · corrodedTUL - CORROSION IN AFT CARGO TIE DOWN TRACK. INSTALLED NEW TRACK UNDER AARD 51-00-00-012.SDR AALA20090730TUL20Cargo Track · corrodedTUL - CORROSION IN AFT CARGO RIGHT TIE DOWN TRACK. INSTALLED NEW TRACK UNDER SRM 51-30-01.SDR FDEA200907242734Seat Track · corrodedSTA 377-418, SEAT TRACK SUPPORT IS CORRODED AT LBL 24. REMOVED CORROSION IAW SRM 53-00-52, DETAIL7 AND FOUND OUT OF LIMITS. ORIG MAT.=.070 INCH, AFTER REWORK=.054 INCH, REMOVED .016 INCH. REMOVED AND FABRICATED NEW SUPPORT, PN BAC1508-237, IAW BATCH NR 161SDR AALA20090724TUL30Cargo Track · corrodedTUL - AFT CARGO HAS CORROSION IN LEFT TIE DOWN TRACK BETWEEN STATION 1220 TO 1320. REPLACED LEFT TIE DOWN TRACK IN AFT CARGO UNDER SRM 51-30-2 AND 51-30-05.SDR ASAA0946229Seat Track · corrodedSEAT TRACK CORRODED BS 346 AND 351 LBL 24 WL 208. REPLACED SEAT TRACK.SDR FDEA200907232710Seat Track · chafedDEEPLY CHAFED SEAT TRACK STA 1411 X=-47.5 IN MAIN DECK CARGO. REPAIRED BY SECTIONAL SEAT TRACK REPLACEMENT AS PER SRM 53-70-00 FIGURE 1 VOLUME I, REVISION 40. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100, REVISION 107.SDR USAA2009081792144Seat Track · corrodedPIT - S-4 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON SEAT RAIL BEAM AT FR66, -Y705. REPLACED SEAT RAIL BEAM AT FR66, -Y705 IAW A319 SRM 51-72-11.SDR A6WA200940429Cargo Track · corrodedRAILS IN CARGO COMPARTMENT AT FS 574, LBL 9 AND RBL 9 ARE CORRODED BEYOND SRM LIMITS. RAILS IN CARGO COMPARTMENT AT FS 574, LBL 9 AND RBL 9 REPLACED IAW SRM 51-41-04. (K)SDR FDEA200907202669Seat Track · corrodedAFT CARGO COMPT FOUND SEVERE CORROSION ON SEAT TRACK. REPAIRED AREA IAW SRM 53-70-00 FIG 5 VOL I.SDR C77A 148915270Seat Track · corrodedCORROSION WAS FOUND DURING THE BASIC CHECK 1 AT LT FLOOR TRACK BETWEEN FR16 AND FR19 AND RT FLOOR TRACK AT BL 265R BETWEEN FR14 AND FR 17.SDR QXEA2009072000545Seat Track · corrodedAN AREA OF LIGHT CORROSION ON THE LT INBD SEAT TRACK AT FS 379.0 AND TOP OF THE TRACK. REMOVED CORROSION IAW REO 670-53-00-013 NOTES 1 AND 2. MEASURED BLENDED AREA AND FOUND NO MORE THAT .010" MATERIAL REMOVED, REMAINING THICKNESS IS .490 TRACK WITHIN LIMITSSDR QXEA2009072000543Seat Track · corrodedLEFT INBD SEAT TRACK LOCATED BETWEEN FS 485 AND FS 581 IS CORRODED IN MULTIPLE AREAS. BLENDED OUT CORROSION IAW REO 670-53-00-013 NOTES 1 AND 2. MEASURED BLENDED AREA AND FOUND LESS THAN .013" MATERIAL REMOVED. REMAINING MATERIAL IS .097" TRACK WITHIN LIMISDR AALA20090730TUL01Cargo Track · corrodedTUL - CORROSION IN AFT CARGO TIE DOWN TRACK. INSTALLED NEW TIE DOWN TRACK.SDR QXEA2009072000544Seat Track · corrodedLEFT INBD SEAT TRACK LOCATED BETWEEN FS 847 AND FS 1031 IS CORRODED IN MULTIPLE AREAS. REMOVED CORROSION FROM AFFECTED AREAS OF LT INBD SEAT TRACK BETWEEN FS 847 AND 1031 BY BLENDING IAW REO 670-53-00-013 NOTES 1,4 AND 6-7. MAX DEPTH AT DIMENSION "U" IS .01SDR K11A2009071572305Seat Track · corrodedSEAT TRACK CROWN CORRODED.SDR K11A2009071572304Seat Track · corrodedSEAT TRACK CROWN CORRODED.SDR K11A2009071572303Seat Track · corrodedSEAT TRACK CROWN CORRODED.SDR K11A2009071572302Seat Track · corrodedSEAT TRACK CROWN CORRODED.SDR AALA20090723TUL09Track · corrodedCORROSION ON RIGHT TIE DOWN TRACK STATION 1212-1217. INSTALLED TIE DOWN TRACK SPLICE REPAIR PER SRM 51-30-05.SDR AALA20090723TUL08Track · corrodedCORROSION ON LEFT TIE DOWN TRACK STATION 1098-1212. REPLACED LEFT TIE DOWN TRACK PER SRM 51-30-01.SDR AALA20090723TUL07Track · corrodedCORROSION ON RIGHT TIE DOWN TRACK STATION 1117-1155. REPLACED TIE DOWN TRACK IN ACCORDANCE WITH SRM 51-30-01.SDR FDEA200907152623Track · corrodedFOUND CORROSION IN ROLLER TRACK C 54.3-56, AT Y1470. REPAIR PERFORMED BY SPLICE REPAIR IAW. SRM 53-10-15 FIG.202 WITH DEVIATION IAW RAS/EFW/9000196/2009 ISS.A , APPROVED BY EA 6-5310-131208.SDR ASOA200900792Seat Track · damagedFIVE (5EA) RIVNUTS ON FLOORBEAM FS 559+4 AND FS 559+64 NEED REPLACED IAW SRM 51-42-34 RBL 9. UPON INVESTIGATION, FOUND FASTENERS TO BE BLIND NUTS NOT RIVNUTS. REPLACE 6 EACH BLIND NUTS. DRILLED 6 EACH AND REMOVED PER SRM 51-42-34. INSTALLED 6 NEW BLIND NUTSDR MZZA2009071400090Seat Track · corrodedFWD PASSENGER COMPARTMENT FLOOR STRUCTURE WET AREA BELOW G7 MOUNTING POINT INBOARD SEAT TRACK FOUND CORRODED AT BS 375.5, LBL 21.5. SEAT TRACK REMOVED AND REPLACED IAW SRM 51-10-02 REV.3 5. SEAT TRACK SUBSTITUTED PER EC/RA 5321-01379.SDR MZZA2009071400089Seat Track · corrodedFWD PASSENGER COMPARTMENT FLOOR STRUCTURE WET AREA SEAT TRACK AT BS 371-378, LBL 43 FOUND CORRODED. SEAT TRACK REMOVED AND REPLACED IAW SRM 51-10-02. SEAT TRACK SUBSTITUTED PER EC/RA 5321-01379.SDR ASOA200900771Seat Track · corrodedCABIN SEAT TRACK CORRODED. REMOVED CORROSION FROM LBL 9 SEAT RAIL BETWEEN FS 409 + 126 AND 559 + 4 IAW SRM 51-21-06, AREA IS OUT OF LIMITS IAW SRM 53-21-49 FIG 101.SDR ASOA200900770Seat Track · corrodedSEAT RAIL AT LBL 9 BETWEEN FS 399.5 AND FS 409 + 126 CORROSION IS BEYOND LIMITS IAW CRJ 200 SRM 53-21-49 FIG 101. REF MWC 1-188.SDR ASOA200900769Seat Track · corrodedSEAT RAIL AT RBL 9 BETWEEN FS 399.5 AND FS 409 + 126 CORROSION IS BEYOND LIMITS IAW SRM 53-21-49 FIG 101. REF MWC 1-188. REMOVED SEAT RAIL IAW SRM 51-41-02. DRILLED IAW SRM 51-40-11, INSTALLED SEAT TRACK PER AMM 53-01-11.SDR ASOA200900768Seat Track · corrodedSEAT RAIL AT LBL 9 BETWEEN FS 409 + 126 AND FS 559 + 4 CORROSION IS BEYOND LIMITS IAW SRM 53-21-49 FIG 101. REF MWC 1-188. REMOVED SEAT RAIL IAW SRM 51-41-02. INSTALLED NEW RAIL IAW AMM 53-01-11-400-802. LOCATED AND COUNTERSUNK FASTENER HOLES IN NEW RAIL IASDR ASOA200900767Seat Track · corrodedSEAT RAIL AT RBL 9 BETWEEN FS 559 + 4 AND FS 559 + 64 CORROSION IS OUT OF LIMITS IAW CRJ 200 SRM 53-21-49 FIG 101. REF MWC 1-188. LOCATED HOLES IN NEW SEAT RAIL IAW SRM 51-40-11. INSTALLED NEW SEAT TRACK. AFTER REMOVING OLD SEAT TRACK IAW AMM 53-01-11-400-SDR ASOA200900766Seat Track · corrodedSEAT RAIL AT RBL 9 BETWEEN FS 409 + 126 AND FS 559 + 4 CORROSION IS BEYOND LIMITS IAW CRJ 200 SRM 53-21-49 FIG 101. REF MWC 1-188. REMOVED SEAT RAIL IAW SRM 51-41-02. LOCATED AND COUNTERSUNK NEW RAIL IAW SRM 51-40-11, 51-41-02. INSTALLED SEAT TRACK IAW AMMSDR ASOA200900765Seat Track · corrodedSEAT RAIL AT RBL 9 BETWEEN FS 364 AND FS 399.5 CORROSION IS BEYOND LIMITS IAW CRJ 200 SRM 53-21-49 FIG 101. REF MWC 1-188.SDR ASOA200900764Seat Track · corrodedSEAT RAIL AT LBL 9 BETWEEN FS 364 AND FS 399.5 CORROSION IS BEYOND LIMITS IAW CRJ 200 SRM 53-21-49 FIG 101. REF MWC 1-188.SDR FDEA200907102566Seat Track · corrodedCABIN - SEAT TRACK FLANGE AT STA 1655 X= -107 FOUND EXFOLIATION CORROSION. CABIN - SEAT TRACK FLANGE AT STA 1655 X= -107 REPAIRED IAW SRM 53-70-00 FIG 6, VOL I, REV. 40. REPAIR CLASSIFIED AS MAJOR IAW GMM 6-2-100 REV. 107.SDR FDEA200907102565Seat Track · corrodedCABIN - RT STA 1259 TO STA 1301 X= -107 SEAT TRACK FOUND CORROSION. CABIN CORRODED SEAT TRACK AT RT STA 1259 TO STA 1301 X= -107, REPAIRED BY SECTIONAL SEAT TRACK REPLACEMENT FROM STA 1229 TO STA 1331 X= -107 IAW SRM 53-70-00 FIG. 1, VOL I, REV. 40. REPAIRSDR DHLA2009873583Cargo Track · wornUPPER CARGO COMP NR 5 TRACK LUGS WORN BS 52.000-130.000 MAJOR REPAIR. REMOVED FLOOR PANEL CUT OUT TRACK DAMAGE SEGMENT, FABRICATED NEW SEAT TRACK SEGMENT PN 54889185 AND 2 SPLICES AND 4 SPLICES PLUS 2 SPLICES CLEANED TREATED AND PRIMED AREA AND REPAIR PARTS, ISDR WRLA2009191Seat Track · crackedDURING C-CHECK AT TPE, MAINTENANCE DISCOVERED A CRACK IN THE SEAT TRACK AT STA 755 AND X=+75.5. REFERENCE EGAT NRC NUMBER U05055. REPAIRED SEAT TRACK IN ACCORDANCE WITH MD11F SRM 53-70-00, PAGE 2 REV 40.SDR QXEA2009071000519Seat Track · corrodedPDX - C5 - LT INBOARD SEAT TRACK NR 5 CORROSION AROUND N/P ON TOP OF OUTBOARD FLANGE AT APPROX X 21.0. REMOVED NR 5 SEAT TRACK BY REMOVING KICK PLATE, DRIP TRAY FWD AND AFT SPLICE AND FWD WEB. DRILLED UP NEW SEAT TRACK FROM STOCK COUNTERSUNK, DEBURRED AND ALSDR QXEA2009071000518Seat Track · corrodedPDX - C5 - NR 5 SEAT TRACK HAS LITE SURFACE CORROSION ON THE INBOARD FLOORBOARD SUPPORT FLANGE. NR 5 SEAT TRACK HAS CORROSION RIGHT UP TO FASTENERS AND FOUND TO BE OUT OF LIMITS REF RD 8/4-53-884, NOTES ON PAGE 2. BLENDED AREA OF CORROSION TO REMOVE DAMAGE ISDR UALA2009071001993Seat Track · corrodedMAIN CABIN FLOOR SEAT TRACK CORRODED AT FLOORBEAM BS 323 - BS 329, LBL 12 - LBL 14. REMOVED DAMAGED SEAT TRACK, P/N AN 141T5121-109 AND FABRICATED AND INSTALLED NEW SEAT TRACK AND PRODUCTION SPLICES.SDR UALA2009071001992Seat Track · corrodedMAIN CABIN FLOOR SEAT TRACK CORRODED AT FLOORBEAM BS 323-BS 329, RBL 12- RBL 14. ZERO MATERIAL REMAINING AND OUT OF LIMITS. REMOVED 141T5121-108 SEAT TRACK AND FABRICATED A NEW SEAT TRACK AND PRODUCTION SPLICES.SDR FDEA200907092558Seat Track · crackedSEAT TRACK FLANGE CRACKED AT LBL-45, STA 1230. REMOVED, FABRICATED NEW TRACK WITH PN 60-6549/24, AND INSTALLED SEAT TRACK LBL-45, STA 1180- 1240, IAW SRM 51-40-02, CATEGORY "A" MAJOR REPAIR.SDR ASOA200900791Seat Track · corrodedCABIN FLOOR SEAT TRACKS FROM FS 364.00 TO FS 559.00+64 LBL 9 AND RBL 9 HAVE MINOR SURFACE CORROSION.
Back to JASC 5347