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 Y2PA200600019Seat Track · corrodedDURING VISUAL INSPECTION PER CPCP WORK CARD 46.53305 FOUND RIGHT HAND CENTER SEAT TRACK STA 200-320, RIGHT HAND OUTBOARD SEAT TRACK STA 200-210, LEFT HAND CENTER SEAT TRACK STA 200-323 AND LEFT HAND OUTBOARD SEAT TRACK STA 237-272 CORRODED. REPAIR PENDING.SDR QXEA200602534Seat Track · corrodedC4 YYC - RIGHT INBOARD SEAT TRACK HAS CORROSION AT STATION X 218 AROUND THE GALLEY TIE DOWN POINT. REPAIRED IAW SRM 51-40-11 AND RD8-53-1339.SDR QXEA200602531Seat Track · corrodedC4 YYC - FUSELAGE INTERIOR, LEFT INBOARD SEAT TRACK HAS CORROSION ON THE TOP SURFACE AT STATION X545. REPAIRED IAW SRM 51-20-16 AND RD8-53-4936.SDR SIMA200626118Seat Track · corrodedFOUND LEFT OUTBOARD SEAT TRACK CORRODED. RAI SEAT TRACK IAW EMB AMM 53-01-06. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA200626113Seat Track · corrodedFOUND LEFT OUTBOARD SEAT TRACK CORRODED. RAI SEAT TRACK, AIW EMB AMM 53-01-06. AIRCRAFT RETURNED TO SERVICE. (M)SDR DJFA2006320Seat Track · crackedDURING A SCHEDULED MAINTENANCE VISIT WHILE PERFORMING A B, C, AND D INSPECTION A CRACK WAS DISCOVERED IN THE CO-PILOTS RT COCKPIT SEAT RAIL WEB BETWEEN FRAMES 5 AND 7.SDR MALA060550Seat Track · corrodedDURING CHECK IN BNA FOUND SEAT TRACK AT LBL 18.3, AT FS 339, IS CORRODED OUT OF LIMITS ON THE HORIZONTAL FLANGE. THE DAMAGE HAS BEEN REPAIRED IAW EO NR S53342.SDR EIA2006251Seat Track · corrodedMAIN DECK STA 1762, L BUTT LINE 99, SEAT TRACK FOUND CRACKED. REPAIRED MAIN DECK SEAT TRACK STA 1730 TO 1790 REPAIRED IAW SRM 53-10-05 FIG 1A.SDR QXEA200602533Seat Track · corrodedC4 YYC - LEFT INBOARD SEAT TRACK HAS CORROSION ON THE TOP SURFACE AT STATION X234 AND AT A CAMLOC LOCATION ON THE FLOORBOARD FLANGE AT STATION X236. REPAIRED IAW RD8-53-1339 AND RD8-53-7833.SDR QXEA200602532Seat Track · corrodedC4 YYC - LEFT INBOARD SEAT TRACK HAS CORROSION ON THE TOP SURFACE FROM STATION X276 TO X296. REPAIRED IAW RD8-53-1339 AND SRM 51-20-16, 51-20-36.SDR QXEA200602511Seat Track · wornC4 YYC - FUSELAGE INTERIOR, STATION X3760, RIGHT OUTBOARD SEAT TRACK HAS WEAR MARKS ON SURFACE. REPAIRED IAW RD8-53-1342 AND SRM 51-20-16.SDR QXEA200602509Seat Track · corrodedC4 YYC - FUSELAGE INTERIOR, STATION X488, RIGHT OUTBOARD SEAT TRACK TOP SURFACE HAS CORROSION. REPAIRED IAW RD8-53-1342 AND SRM 51-20-36.SDR QXEA200602483Seat Track · corrodedC3 PDX - RIGHT OUTBOARD SEAT TRACK PITTED AT X602. REPAIRED IAW RD-84-53-884.SDR DHL2006745530Seat Track · corrodedMAIN CARGO DECK 45R SEAT TRACK AT BS 950 SHOWS SURFACE CORROSION. REMOVED CORRODED SEAT TRACK BS 950-1030, RBL 45 IAW B727 SRM 51-30-2, FAB NEW SEAT TRACK FROM P/N BAC1520-792, PO 9003091APPROX DIM 16' IAW B727 SRM 53-10-5 FIG 1 & SRM 53-10-2 FIG 7, FAB REPAISDR 06FDEA03232Seat Track · wornMAIN DECK CARGO, FOUND WORN SEAT TRACK AT STA 715 RBL 27. REPAIR CARRIED OUT AT STA 715 RBL 27 AS PER SRM 53-70- 00 VOLUME I. REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-100. REFER TO SNRM N00661 FOR REPAIR DETAILS.SDR TRAX200600713Seat Track · corrodedETNRC 100-43, SEAT TRACK CORRODED BETWEEN FRAME 34 AND 36 LEFT.SDR 06FDEA03219Seat Track · wornMAIN DECK CARGO, FOUND SEAT TRACK WORN AT STA 755 RBL 33.SDR 06FDEA03215Seat Track · wornMAIN DECK CARGO, FOUND SEAT TRACK WORN AT RBL 67 JUST AFT OF LAVATORY LOCATION. CARRIED OUT REPAIR AS PER SRM 53-70-00 FIGURE 7 VOLUME I. REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-100.SDR SIMA200626121Seat Track · corrodedSAW - FOUND RIGHT INBOARD SEAT TRACK CORRODED FROM FRAME 36-47. RAI SEAT TRACK IAW EMB AMM 53-01-06. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA200626117Seat Track · corrodedSAW - FOUND LEFT INBOARD SEAT TRACK CORRODED FROM FRAME 17-23. RAI SEAT TRACK IAW EMB AMM 53-01-06. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA200626116Seat Track · corrodedSAW - FOUND RIGHT INBOARD SEAT TRACK CORRODED FROM FRAME 36-47. RAI SEAT TRACK IAW EMB AMM 53-01-06. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA200626122Seat Track · corrodedFOUND LEFT INBOARD SEAT TRACK CORRODED FROM FRAME 17-23. RAI SEAT TRACK IAW EMB AMM 53-01-06. AIRCRAFT RETURNED TO SERVICE. (M)SDR DJFA2006311Seat Track · crackedDURING A SCHEDULED MAINTENANCE VISIT A CRACK WAS DISCOVERED IN THE CO-PILOTS RIGHT COCKPIT SEAT RAIL WEB BETWEEN FRAMES 5 AND 7.SDR UIEA200600224Seat Track · crackedN415MC AT PIK FOR MSG-3, CHECK C-4 & A-4. AS PER N/ROUTINE 163 FWD CARGO SEAT TRACK AT BS 560 LBL 45.5 HAS 6 INCH CRACK AND N/ROUTINE 188 FWD CARGO SEAT TRACK AT BS 560, LBL 25 HAS TWO HOLES. NR 4453A083 WAS GENERATED. FOR N/ROUTINE 163 REPAIR ACCOMPLISHED SDR 06FDEA03187Seat Track · wornMAIN DECK CARGO, FOUND SEAT TRACK WORN AT STA 700 RBL 55. CARRIED OUT REPAIR AS PER SRM 53-70-00 FIGURE 1 VOLUME I. REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-100. REFER TO SNRM N00591 FOR REPAIR DETAILS.SDR 06FDEA03186Seat Track · wornMAIN DECK CARGO, FOUND SEAT TRACK WORN AT STA 675 RBL 55. CARRIED OUT REPAIR AS PER SRM 53-70-00 FIGURE 1 VOLUME I. REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-100.SDR 06FDEA03185Seat Track · wornMAIN DECK CARGO, FOUND SEAT TRACK WORN AT STA 755 LBL 33. CARRIED OUT REPAIR AS PER SRM 53-70-00 FIGURE 1 VOLUME I. REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-100.SDR SIMA200626120Seat Track · corrodedFOUND LEFT INBOARD SEAT TRACK CORRODED FROM FRAME 36-47. RAI SEAT TRACK IAW EMB AMM 53-01-06. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA200626115Seat Track · corrodedFOUND LEFT INBOARD SEAT TRACK CORRODED FROM FRAME 36-47. RAI SEAT TRACK IAW EMB AMM 53-01-06. AIRCRAFT RETURNED TO SERVICE. (M)SDR COMA0670189Seat Track · gougedTWO GOUGES ON RIGHT FLOOR SEAT TRACK EXCEED DAMAGE LIMITATIONS PER SRM 53-11-49. REPLACED SEAT TRACK IAW REO 670-53-00-074.SDR MALA060541Seat Track · corrodedSEAT TRACK AT LBL 18.3, AND FS 630, ON THE INBOARD VERTICAL FLANGE, IS CORRODED OUT OF LIMITS. THE DAMAGE HAS BEEN REPAIRED IAW MESABA EO S53077. REF: EAMS WORK ORDER 214375 TASK 1508.SDR MALA060540Seat Track · corrodedSEAT TRACK AT LBL 18.3, BETWEEN FS 299 AND 317 IS CORRODED OUT OF LIMITS ON THE INBOARD VERTICAL FLANGE. THE DAMAGE HAS BEEN REPAIRED IAW MESABA EO S53342. REF: EAMS WORK ORDER 214375 TASK 1502.SDR MALA060542Seat Track · corrodedSEAT TRACK AT BL 0, FROM FS 630 TO 649, LT VERTICAL FLANGE, IS CORRODED OUT OF LIMITS ON A PREVIOUS REPAIR. THE PREVIOUS REPAIR HAS BEEN REMOVED AND REPLACED IAW MESABA EO S53077. REF: EAMS WORK ORDER 214375 TASK 1510.SDR DHL2006745525Seat Track · corrodedMC DECK, 24L SEAT TRACK FROM BS 460 TO BS 660 SHOWS SURFACE CORROSION. REMOVED SEAT TRACK BS 460-660, RBL 24 FOR REPLACEMENT IAW B727 SRM 51-30-2, FAB NEW SEAT TRACK FROM P/N BAC1520-792, PO NR 9003607 APPROX DIM 17' 5" IAW B727 SRM 53-10-5, FIG 1, TREATED ANSDR KCSA061291Seat Track · brokenFWD PIT BS 700 RT SIDE RAIL SUPPORT EAR BROKEN OFF ABOVE STR 40R.SDR F3LA200600112Mount · corrodedDURING C-4 CHECK, INSPECTION REPORTED CORROSION ON LAV MOUNT HOLE AT Y1292, FR16, IN FWD LAV AREA. REMOVED CORROSION FOUND TO BE OUT OF LIMITS IAW SRM 53-11-14. REPAIRED DAMAGED AREA IAW SRM'S 53-00-15, FIG.202(A)(B)(C)(D), 53-11-15, FIG. 202 (ITEM 5), 53-11SDR 06FDEA03118Seat Track · corrodedAFT CABIN CORROSION ON SEAT TRACK CROWN AT STA 1341 TO STA 1358 X=- 75. REMOVED CORROSION AND FOUND EXCEED LIMIT AS PER SRM 53-70-00 FIG.3 VOL.1 AND CARRIED OUT REPAIR BY FABRICATING NEW SEAT TRACK AND SPLICE AS PER SRM 53-70-00 FIG.1 VOL.I. REPAIR CLSDR 06FDEA03117Seat Track · corrodedMID-CABIN CORROSION ON SEAT TRACK BASE AND CROWN AT STA 745 TO STA 832 RBL 27.5". REMOVED CORROSION AND FOUND EXCEED LIMIT AS PER SRM 53-70-00 FIG.3 VOL.I AND CARRY OUT REPAIR BY FABRICATING NEW SEAT TRACK AND SPLICE AS PER SRM 53-70-00 FIG.1 VOL.I. SDR 06FDEA03116Seat Track · corrodedFOUND CABIN SEAT TRACK FLANGE, BASE AND CROWN FOUND CORRODED AT STA 808 TO STA 859 RBL 8.5". CORROSION REMOVED AND FOUND EXCEEDED LIMIT AS PER SRM 53-70-00 FIG.3 VOL.I AND CARRIED OUT REPAIR BY FABRICATING NEW SEAT TRACK AND SPLICE AS PER SRM 53-70-00 FIGSDR CALA0600309Seat Track · corrodedINSPECTION FOUND RT OB SEAT TRACK CORRODED AT STA 540-727, RBL 24. THE SEAT TRACK WAS REPLACED IAW SRM 53-00-52, REPAIR 2, FIGURE 201.SDR TRAX200600664Seat Track · corrodedRANRC 402 - SEAT TRACK RAIL AT LBL 9.0 BETWEEN FS 559 & 80 AND FS 559 & 96 HAS CORROSION BEYOND LIMITS.SDR AWXA200601545Seat Track · corrodedSAL - FOUND CORROSION ON LONGITUDINAL BEAM -Y1292, AT FS 20. REPAIRED SEAT TRACK LOCATED BETWEEN FS 19 TO FS 24, -Y1292 IAW A319 SRM 53-11-15, PAGE 206, 211/212, FIG 16.SDR TRAX200600652Seat Track · corrodedFOUND SEAT TRACK RAIL AT RBL 9.0 BETWEEN FS 559 AND 25 AND FS 559 AND 96 HAS CORROSION BEYOND LIMITS.SDR TRAX200600651Seat Track · corrodedFOUND SEAT TRACK RAIL AT RBL 27.0 BETWEEN FS 559 AND 80 AND FS 559 AND 96 HAS CORROSION BEYOND LIMITS.SDR TRAX200600650Seat Track · corrodedRANRC NR 402 SEAT TRACK RAIL AT LBL 9.0 BETWEEN FS 559 AND 80 AND FS 559 AND 96. HAS CORROSION BEYOND LIMITS.SDR MALA060530Seat Track · corrodedDURING 2 YEAR CHECK IN BNA, FOUND SEAT TRACK AT BLO BETWEEN FS 294 AND 300 IS CORRODED OUT OF LIMITS. THE DAMAGE HAS BEEN REPAIRED IAW MESABA EO NR S53342. REF: EAMS WORK ORDER 214335 TASK 1507.SDR MALA060529Seat Track · corrodedDURING 2 YEAR CHECK IN BNA, FOUND SEAT TRACK AT LBL 18.3, BETWEEN FS 294 AND 300 IS CORRODED OUT OF LIMITS. THE DAMAGE HAS BEEN REPAIRED IAW MESABA EO NR S53342. REF: EAMS WORK ORDER 214335 TASK 1508.SDR MWEA060178Seat Track · corrodedFOUND CORROSION ON INBOARD FLANGE OF SEAT TRACK AT FRAME STATION 1136 TO 1146, X +44. Z 0, AROUND BOARD FASTENER HOLES. FABRICATED AND INSTALLED SEAT TRACK.SDR MWEA060170Seat Track · corrodedFOUND SEAT TRACK IS CORRODED AT NUTPLATE AS VIEWED FROM AFT CARGO BAY Y 1267 AND X +24, Z 0. FABRICATED AND INSTALLED SEAT TRACK.SDR SIMA200624105Seat Track · corrodedDURING MBV INSPECTION, FOUND LEFT FORWARD SEAT TRACK CORRODED. RAI SEAT TRACK IAW EMB AMM 53-01-06. AIRCRAFT RETURNED TO SERVICE. (M)
Back to JASC 5347