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 ASOA05193Seat Track · corrodedDURING A C-CHECK IN YUL, THE OUTBOARD SEAT TRACK BETWEEN FRAME 25-26 LEFT WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE OUTBOARD SEAT TRACK BETWEEN FRAME 25-26 LEFT IAW SRM 51-25-04. (M)SDR ASOA05194Seat Track · corrodedDURING A C-CHECK IN YUL, THE OUTBOARD SEAT TRACK BETWEEN FRAME 29-36 LEFT WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE OUTBOARD SEAT TRACK BETWEEN FRAME 29-36 LEFT IAW SRM 51-25-04. (M)SDR ASOA05190Seat Track · corrodedDURING A C-CHECK IN YUL, THE OUTBOARD SEAT TRACK BETWEEN FRAME 29-36, RBL 40 WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE OUTBOARD SEAT TRACK BETWEEN FRAME 29-36, RBL 40 IAW SRM 51-25-04. (M)SDR ASOA05192Seat Track · corrodedDURING A C-CHECK IN YUL, THE INBOARD AND OUTBOARD SEAT TRACKS BETWEEN FRAME 28-29 RT WERE FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE INBOARD AND OUTBOARD SEAT TRACKS BETWEEN FRAME 28-29 RT IAW SRM 53-00-00 FIG 434. (M)SDR ASOA05191Seat Track · corrodedDURING A C-CHECK IN YUL, THE INBOARD SEAT TRACKS BETWEEN FRAME 31-31 LEFT/RIGHT WERE FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE INBOARD SEAT TRACKS BETWEEN FRAME 31-32 LT/RT IAW SRM 51-25-04. (M)SDR QXEA200500211Seat Track · corrodedPDX - RIGHTHAND INBOARD SEAT TRACK CORROSION APPROXIMATELY X705 TO X712. REPAIRED IAW RD 8/4-53-884.SDR AWXA200500189Seat Track · corrodedSAL - MAJOR REPAIR - DURING BC-4 CHECK EXFOLIATION CORROSION WAS FOUND ON FLOORBEAM SEAT RAIL Y765, AT FR 66. MAINTENANCE REMOVED CORRODED FLOORBEAM SEAT RAIL Y765, FROM FR 64 TO FR 66; FABRICATED A NEW REPLACEMENT FLOORBEAM SEAT RAIL PER DWG 18D53472040; INSSDR IXXA0500204SSeat Track · crackedDURING ROUTINE C-CHECK FOUND FLIGHT DECK COUIER SEAT TRACK AFT TRACK CRACKED ON END. REMOVED DAMAGE, MANUFACTURED REPAIR PARTS, LOCATED, DRILLED, TREATED, PRIMED, AND INSTALLED REPAIR PARTS IAW DC8 SRM 53-2-0, 51-1-8, AND 51-1-21.SDR USAA050243Seat Track · corrodedBFM - FOUND SEAT TRACK, 1 INCH WIDE BY 2 INCHES LONG, BY .032 INCH DEEP AND 1 INCH WIDE BY 2.75 INCH LONG BY .030 INCH, FRAME 55-58, -Y450 MAIN CABIN FLOOR. REMOVED AND REPLACED SEAT TRACK PER SRM 53-00-15, 51-42-11. (M)SDR USAA050244Seat Track · corrodedBFM - FOUND SEAT TRACK, CORRODED 2 INCHES LONG BY 1.20 INCHES WIDE BY .035 INCHES DEEP AND 4 INCHES LONG BY 1 INCH WIDE BY .037 INCH, FRAME 39.2-47, +Y450 MAIN CABIN FLOOR. REMOVED AND REPLACED SEAT TRACK PER SRM 53-31-15, 51-42-11. (M)SDR USAA050242Seat Track · gougedBFM - FOUND SEAT TRACK GOUGED 6 INCHES LONG BY 1.20 INCHES WIDE BY .032 INCH DEEP, FRAME 39.2, Y=-450. SPLICED NEW TRACK SECTION PER SRM 53-31-15 FIG 101 SHEET 8, FIG 201, SHEET 1. (M)SDR USAA050267Seat Track · corrodedBFM - FOUND SEAT TRACK CORRODED, 2 INCHES LONG BY .25 INCHES WIDE BY .067 INCH DEEP, FRAME 17 PLUS Y450 MAIN CABIN FLOOR. REMOVED AND REPLACED SEAT TRACK PER SRM 53-11-15 FIG 101 SH 7, 51-42-11. (M)SDR USAA050266Seat Track · corrodedBFM - FOUND SEAT TRACK CORRODED 2 INCHES LONG BY .5 INCHES WIDE BY .036 INCH DEEP AND 1 INCH LONG BY .5 INCH WIDE BY .029 DEEP, FRAME 37 PLUS Y450 MAIN CARGO FLOOR. CORROSION LEVEL 2, TASK C533170-01. SPLICED IN SECTION OF SEAT TRACK PER SRM 53-31-15, 53-00-1SDR ASOA05186Seat Track · corrodedDURING A C-CHECK IN YUL, THE SEAT TRACK BETWEEN FRAME 39 AND 40 RIGHT WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK BETWEEN FRAME 39 AND 40 RT IAW SRM 51-25-04. (M)SDR ASOA05185Seat Track · corrodedDURING A C-CHECK IN YUL, THE SEAT TRACKS BETWEEN FRAME 36 AND 39 LEFT/RIGHT WERE FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACKS BETWEEN FRAME 36 AND 39 LT/RT IAW SRM 51-25-04. (M)SDR ASOA05197Seat Track · corrodedDURING A C-CHECK IN YUL, THE SEAT TRACK BETWEEN FRAME 41 AND 44 RT WAS FOUND TO BE CORRODED IN THE CROWN BETWEEN FRAME 41-42 BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK BETWEEN FRAME 41 AND 44 RIGHT IAW SRM 51-25-04. (M)SDR MALA050173Seat Track · corrodedDURING 4K CHECK IN BNA FOUND SEAT TRACK AT LBL 18.3 IS CORRODED OUT OF LIMITS FROM FS 298 TO FS 345 AND WILL BE REPLACED IAW MESABA EOS53060.SDR IXXA0500188SSeat Track · gougedDURING ROUTINE C-CHECK FOUND MAIN CABIN SEAT TRACK GOUGED AT STATION 235 LEFT BUTT LINE 45.5. GOUGE IS OUT OF LIMITS. REMOVED DAMAGED AREA. FABRICATED REPAIR PARTS. LOCATED, DRILLED, TREATED, PRIMED, AND INSTALLED REPAIR PARTS AND FASTENERS IAW DC8 SRM 53-SDR SWIA200514890Seat Track · corrodedLT INBOARD SEAT TRACK HAS AN AREA AT APPROX FS 324 THAT HAS CORROSION, (ITEM FOUND AT C-CHECK INSPECTION.) INSTALLED SEAT TRACK IAW CRJ 200 SRM 51-41-02 PG 1 AND 5.SDR USAA050246Seat Track · corrodedBFM - FOUND SEAT TRACK CORRODED .34 INCH DEEP BY 1.75 INCH BY .5 INCH WIDE/.050 INCH DEEP BY 1.5 INCH LONG BY .5 INCH, FRAME 47-53.2, Y-450 MAIN CABIN FLOOR. REMOVED AND REPLACED SEAT TRACK PER SRM 53-31-15 FIG 101, 51-42-11. (M)SDR USAA050265Seat Track · corrodedBFM - FOUND SEAT TRACK CORRODED 1.4 INCH LONG BY 1.2 INCH WIDE BY .050 INCH DEEP, FRAME C 64, -Y 1560 MAIN CABIN FLOOR. REMOVED AND REPLACED SEAT TRACK PER SRM 53-41-15 FIG 101, SRM 51-42-11. (M)SDR 05FDEA00236Seat Track · wornMAIN DECK - SEAT TRACK CROWN AREA AT APPROXIMATE STA Y= 715, X= 47.5 FOUND WORN. MAIN DECK - SEAT TRACK CROWN AREA AT APPROXIMATE STA Y= 715, X= 47.5 REPAIR PARTS FABRICATED AND INSTALLED AS PER SRM 53-70-00 VOLUME I, FIGURE 1.SDR QXEA200500153Seat Track · corrodedPDX - RIGHT HAND FORWARD INBOARD SEAT TRACK HAS HEAVY CORROSION IN NUMEROUS LOCATIONS. REPLACED IAW DHC-8 SRM 51-42-00 AND SRM 51-40-15.SDR 05FDEA00235Seat Track · wornSEAT TRACK CROWN AREA AT APPROXIMATE STA Y= 1701, X= 27.5 FOUND WORN. SMOOTHENED, MATERIAL REMOVED= 0.006", ORIGINAL THICKNESS= 0.414", REMAINING THICKNESS= 0.408" WITHIN PER SRM 53-10-00 VOLUME I, FIGURE 3.SDR LR7A05004Cargo Track · crackedDURING SCHEDULED B2 INSPECTION PER JOB CARD HSP53262 FOUND LT FS 617 25000 LB TIE DOWN FITTING CRACKED APPROX .25 INCH AT LBL 61, WL 143. REPLACED FITTING IAW SRM SMP 583 51-70. NR 2004.SDR USAA050245Seat Track · corrodedBFM - FOUND SEAT TRACK CORRODED 5 SQUARE INCHES BY .040 INCH DEEP, FRAME 47-49, Y450 MAIN CABIN FLOOR. REMOVED AND REPLACED SEAT TRACK PER SRM 53-31-15 FIG 101. CORROSION 2 AREAS. (M)SDR USAA050249Seat Track · corrodedBFM - FOUND SEAT TRACK CORRODED 4 INCHES BY 1.2 INCHES BY .042 INCH DEEP, FRAME 54, Y450 MAIN CABIN FLOOR. REMOVED DAMAGED SECTION, INSTALLED NEW SECTION OF TRACK AND SPLICES PER SRM 53-31-15 FIG 101. (M)SDR USAA050247Seat Track · corrodedBFM - FOUND RAIL CORRODED 4 INCHES BY 2 INCHES BY .27 INCH DEEP, BETWEEN FRAME 13/14, -Y730, MAIN CABIN FLOOR. REMOVED AND REPLACED RAIL PER SRM 53-11-14 FIG 101. CORROSION LEVEL 2, TASK C531172-01. REMOVED AND REPLACED RAIL PER SRM 53-11-14 FIG 101. (M)SDR USAA050248Seat Track · corrodedBFM - FOUND RAIL CORRODED 1 INCH BY .25 INCH BY .046 INCH DEEP, FRAME 17, -450, MAIN CABIN FLOOR. REMOVED AND REPLACED RAIL PER SRM 53-11-15 FIG 101. CORROSION LEVEL 2, TASK C531172-01. (M)SDR USAA050258Seat Track · corrodedBFM - FOUND SEAT TRACK CORRODED, 3 FT BY 2 INCHES BY .047 INCH DEEP, BETWEEN FS 32-33, Y1456, MAIN CABIN FLOOR. FABRICATED SEAT TRACK SPLICES, NEW SECTION OF SEAT TRACK, INSTALLED REPAIR PARTS PER SRM 53-00-15. (M)SDR 0500285521Seat Track · corrodedDURING "H" CHECK, FOUND CORROSION ON SEAT TRACK AT BS 378 LBL 25. REPAIRED PER EA 55-202113.SDR QXEA200500209Cargo Track · corrodedPDX - AFT CARGO RIGHTHAND INBOARD TRACK CORROSION ON OUTBOARD FLANGE APPROXIMATELY X672 TO X692. REPAIRED IAW DHC-8-4- SRM 51-42-05 AND SRM 51-40-10.SDR QXEA200500213Seat Track · corrodedPDX - RIGHTHAND INBOARD SEAT TRACK CORROSION APPROXIMATELY X721 TO X732. REPAIRED IAW RD 8/4-53-884.SDR QXEA200500210Seat Track · corrodedPDX - RT INBOARD SEAT TRACK CORROSION APPROXIMATELY X696. REPAIRED IAW RD 8/4-53-884.SDR 05FDEA00222Seat Track · wornMAIN DECK - SEAT TRACK CROWN AREA AT APPROXIMATE STA Y= 1304, X= - 75.5 FOUND WORN. CUT AND REMOVED PER SRM 53-70-00 VOLUME I, FIGURE 1. NEW SEAT TRACK AND REPAIR PARTS FABRICATED AND INSTALLED PER SRM 53-70-00 VOLUME I, FIGURE 1.SDR 05FDEA00220Seat Track · wornMAIN DECK, SEAT TRACK CROWN AREA AT APPROXIMATE STA Y= 1092 TO Y= 1095, X= -47.5 FOUND WORN. SEAT TRACK REMOVED FROM EXISTING SPLICE AT STA Y= 1129 AND CUT AT Y= 1159, X= -47.5 PER SRM 53-70-00 VOLUME I, FIGURE 1. NEW SEAT TRACK AND REPAIR PARTS FABRICATEDSDR 05FDEA00219Seat Track · wornMAIN DECK - SEAT TRACK CROWN AREA AT APPROXIMATE STA Y= 1049, X= -8.5 FOUND WORN. SEAT TRACK CUT AND REMOVED FROM EXISTING SPLICE AT STA Y= 1069 AND Y= 1129, X= -8.5 PER SRM 53-70-00 VOLUME I, FIGURE 1. NEW SET TRACK AND REPAIR PARTS FABRICATED AND INSTALLESDR 05FDEA00221Seat Track · wornMAIN DECK, SEAT TRACK CROWN AREA AT APPROXIMATE STA Y= 1238 TO Y= 1286, X= -47.5 FOUND WORN. CUT AND REMOVED PER SRM 53-70-00 VOLUME I, FIGURE 1. NEW SEAT TRACK AND REPAIR PARTS FABRICATED AND INSTALLED PER SRM 53-70-00 VOLUME I, FIGURE 1.SDR ASAA0540075Cargo Track · corrodedPAE - CORROSION ON CARGO TRACK, AFT CARGO BAY, BSTA 947-940, WL 156. REMOVED CARGO TRACK AND INSTALLED NEW CARGO TRACK IAW SRM. (K)SDR WRLA2005019Seat Track · corrodedDURING "C2" CHECK FOUND CABIN SEAT TRACK CORROSION BETWEEN STA 858 AND STA 873 X=27.5. CUT AND REMOVED CORRODED SECTION BETWEEN STA 832 AND 909 X=27.5, FABRICATED AND INSTALLED NEW SEAT TRACK SECTION AND SPLICE HAT. CONDITION CHECK SATISFACTORY REF MD11 SRM SDR WRLA2005018Seat Track · corrodedDURING "C2" CHECK, FOUND CABIN SEAT TRACK CORROSION BETWEEN STA 858 AND STA 873 X=27.5. CUT AND REMOVED CORRODED SECTION BETWEEN STA 816 AND 909 X=75.25, FABRICATED AND INSTALLED NEW SEAT TRACK SECTION AND SPLICE HAT. CONDITION CHECK SATISFACTORY REF MD11 SRSDR WRLA2005015Seat Track · corrodedDURING "C2" CHECK FOUND CABIN SEAT TRACK CORROSION BETWEEN STA 840 AND STA 870 X=-27.5. CUT AND REMOVED CORRODED SECTION BETWEEN STA 832 AND 869 X=-27.5, FABRICATED AND INSTALLED NEW SEAT TRACK SECTION AND SPLICE HAT PER MD11 SRM 53-70-00 FIG 1 REV 36 VOL I. SDR WRLA2005014Seat Track · corrodedDURING "C2" CHECK FOUND CABIN SEAT TRACK CORROSION BETWEEN STA 840 AND STA 860 X=-44.5. CUT AND REMOVED CORRODED SECTION BETWEEN STA 832 AND 909 X=-44.5, FABRICATED AND INSTALLED NEW SEAT TRACK SECTION AND SPLICE HAT. CONDITION CHECK SATISFACTORY REF MD11 SRSDR WRLA2005013Seat Track · corrodedDURING "C2" CHECK, FOUND CABIN SEAT TRACK CORROSION BETWEEN STA 865 AND STA 880 X=-8.5. CUT AND REMOVED SECTION BETWEEN STA 832 AND 929 X=-8.5, FABRICATED AND INSTALLED NEW SEAT TRACK SECTION AND SPLICE HAT. CONDITION CHECK SATISFACTORY REF MD11 SRM 53-70-00SDR WRLA2005012Seat Track · corrodedDURING "C2" CHECK, FOUND SEAT TRACK CORROSION BETWEEN STA 1371 AND STA 1521 X=-75.25. CUTOUT AND REMOVED CORRODED SECTION BETWEEN STA 1371 AND 1531 X=-75.25, FABRICATED AND INSTALLED NEW SEAT TRACK SECTION AND SPLICE HAT. CONDITION CHECK SATISFACTORY REF MD1SDR MALA050204Seat Track · corrodedDURING 4Y/2Y CHECK IN BNA, FOUND SEAT TRACK AT LBL 18.3 IS CORRODED FROM FS 294 TO FS 319. DAMAGED AREAS HAVE BEEN REPAIRED IAW SRM 53-70-60 REF. EAMS WORK ORDER 211546 TASK 1516.SDR MALA050203Seat Track · corrodedDURING 4Y/2Y CHECK IN BNA, FOUND SEAT TRACK AT BLO IS CORRODED OUT OF LIMITS FROM FS 294 TO FS 319 AND HAS BEEN REPAIRED IAW SRM 53-70-60. REF EAMS WORK ORDER 211546 TASK 1515.SDR MALA050200Seat Track · corrodedGALLEY SEAT TRACK AND PROFILE PN 7253721-459 AND 7253721-495 ARE CORRODED OUT OF LIMITS AND HAVE BEEN REPLACED WITH NEW PARTS IAW SRM 51-40-21 AND SRM 51-40-27. REF EAMS WORK ORDER 211546 TASK 1507, FOUND DURING 4Y/2Y CHECK IN BNA.SDR MALA505201Seat Track · corrodedSEAT TRACK AT BLO IS CORRODED FROM FS 630 TO FS 686. DAMAGE HAS BEEN REPAIRED IAW MESABA EO NR S53076. REF EAMS WORK ORDER 211546 TASK 1505, FOUND DURING 4Y/2Y CHECK.SDR USAA050250Seat Track · corrodedBFM - FOUND TRACK 1.5 INCH BY 1.2 INCH BY .025 INCH DEEP, FRAME 72, Y450, MAIN CABIN FLOOR SEAT TRACK. REMOVED AND REPLACED SEAT TRACK PER SRM 53-00-15. (M)
Back to JASC 5347