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 08FDEA01180Seat Track · corrodedDURING MD10 ACF MODIFICATION IN UPPER FUSELAGE AT STA 1099 BETWEEN SEAT TRACK X= -78 AND X=-81 FOUND CORROSION ON FLOOR SUPPORT REMOVED CORROSION IS OUT LIMIT THE REWORK. REPLACED SUPPORT FOR DWG ADA3615 AND SRM 51-35-01 VOL II.SDR CPCP20080019Seat Track · corrodedCORROSION FOUND ON LT O/B SEAT TRACK BTW FR 29-35. REPLACED LT O/B SEAT TRACK BTW FR 29-35 IAW SRM 51-25-04.SDR ASAA0892839Seat Track · corrodedCARGO FLOOR TRACK CORRODED ON UPPER AND LOWER SURFACE MOSTLY AROUND NUT PLATE HOLES RBL 13 TO RBL 14 STA 802 TO STA 846. REMOVED DAMAGED CARGO TRACK SECTION STA 767 TO STA 887, LOCATED, FABRICATED A REPLACEMENT TRACK AND SPLICE DRILLED AND INSTALLED IAW B737 SDR 08FDEA01161Seat Track · corrodedMCDD FLOOR SEAT TRACK NR 3 RT INBD FLANGE HAS CORROSION 4 AREAS BETWEEN FR 40 AND FR 42 REMOVED LEVEL 1 CORROSION BY REMOVED AND REPLACED SEAT TRACK SECTION FROM FR 40 TO FRAME 46, NR 3 RT.SDR 08FDEA01159Seat Track · gougedMDCC SEAT TRACK NR 1 HAS 1 EA GOUGED SCALLOP BETWEEN FRAMES 48 AND 49 ACCOMPLISHED SEAT TRACK REPAIR IAW A300-600 SRM 53-10-16,FIG 201SDR UPS08M52192Seat Track · corrodedINSPECTION TYPE:C AFT CABIN - CORROSION IN SEAT TRACK CHANNEL AT STA 1841 X=107. CORROSION AT AFFECTED AREA REMOVED MATL THK:0.100" (CHANNEL) MATL REMOVED:0.05 0" (STA1841-1853), MATL REMN:0.050". FOUND OUT OF LIMIT. DISCREPANT SEA TRACK AT STA1831 X=107, TSDR KCSA081206Seat Track · corrodedMAIN DECK SEAT TRACK CORRODED AT BS 1800, LBL-99.SDR UPS08M52246Seat Track · corrodedINSPECTION TYPE:C CABIN - SEAT TRACK AT STA 791 - 909 X=+75.25 FOUND CORROSION. CORR ON AFFECTED AREA REMOVED MAT'L THK:0.145"(CROWN), MAT'L REMOVED: 0.045"(STA.869-896), MAT'L REMN:0.100". FOUND OUT OF LIMIT. DISCREPANT SEAT TRACK ON EXISTING SPLICE HAT SESDR UPS08M52162Seat Track · corrodedINSPECTION TYPE:C CABIN SEAT TRACK AT STA 859 - 919 X=+8.5 FOUND CORROSION. CORROSION ON AFFECTED AREA REMOVED MAT'L THK: 0.080" (FLANGE), MAT'L REMOVED: 0.050", MAT'L REMN: 0.030 INCH (STA 880) FOUND OUT OF LIMIT. DISCREPANT SEAT TRACK AT STA 849 AND STA929SDR UPS08M52135Seat Track · corrodedINSPECTION TYPE:C CABIN SEAT TRACK AT STA 929 - 979 X=+8.5, FOUND CORROSION. CORROSION ON SEAT TRACK AT AFFECTED AREA REMOVED MAT'L THK: 0.100"(BASE) MAT'L REMOVED: 0.040", MAT'L REMN: 0.060"(STA959), FOUND OUT OF LIMIT. DISCREPANT SEAT TRACK AT STA 929-989 SDR UPS08M52100Seat Track · corrodedINSPECTION TYPE:C CABIN SEAT TRACK AT STA 859 - 909 X=+27.5 FOUND CORROSION. CORROSION ON AFFECTED AREA REMOVED MAT'L THK: 0.145", MAT'L REMOVED: 0.040" (STA899), MAT'L REMN: 0.105". FOUND OUT OF LIMIT. DISCREPANT SEAT TRACK AT STA 849 TO 929 X=+27.5 TRIMMESDR UPS08M52081Seat Track · corrodedINSPECTION TYPE:C CABIN, SEAT TRACK AT STA 919 - 969 X=-75.25 FOUND CORROSION. CORROSION AT AFFECTED AREA REMOVED. MAT'L THK:0.145", MAT'L REMOVED 0.040 INCH (STA 939), MAT'L REMOVED: 0.105 INCH. FOUND OUT OF LIMIT. DISCREPANT SEAT TRACK TRIM OUT. C HFEC SDR DALA1123539223Cargo Track · corrodedPERFORMED TASK CARD 65064990, CORROSION ON RIGHT TRACK BETWEEN STA 579 AND STA 693 IN FWD CARGO COMPARTMENT. SPLICE REPAIR PER SRM VOL 1 53-40-01 FIG 7, C/W TASK CARD 65064990.SDR WRNA20080033Seat Track · corrodedDURING C CHECK, WHILE ACCOMPLISHING CPCP TASK C53-210-01, LEVEL LL CORROSION WAS FOUND AT SEAT TRACK SPLICE AT STATION 778 LBL 47. INSTALLED SEAT TRACK SPLICE AND ANGLES IAW SRM 53-10-05 FIGURE 1A DETAIL LLL AND SRM 51-30-02.SDR WRNA20080035Seat Track · damagedDURING C CHECK, WHILE ACCOMPLISHING CPCP TASK C53-210-01, SEAT TRACK AT STATION 1900 LBL 99 WAS FOUND DAMAGED. REMOVED DAMAGED SEAT TRACK FROM STATION 1890 - 1905 AT LBL 99. INSTALLED SEAT TRACK IAW SRM 53-10-01 FIGURE 1A.SDR WRNA20080034Seat Track · corrodedDURING C CHECK, WHILE ACCOMPLISHING CPCP TASK C53-210-01, LEVEL II CORROSION WAS FOUND AT SEAT TRACK BETWEEN STATION 500 - 540 RBL 48. REMOVE CORRODED SEAT TRACK SECTION. INSTALLED SEAT TRACK SECTION IAW SRM 53-10-05 FIG 6 AND SRM 51-30-02.SDR COEA0801914Seat Track · damagedFOUND DURING HEAVY CHECK. MAJOR REPAIR. FOUND TOOL DAMAGE (MISDRILLED HOLE) (2) PLACES ON UPPER FLANGE OF LT OB SEAT TRACK AT FLOOR CROSSBEAMS 20 AND 21. REMOVED AND REPLACED DAMAGED SECTION OF SEAT TRACK FROM END AT FRAME 23 TO PREVIOUSLY INSTALLED SPLICE SDR FDKA200803132Seat Track · corrodedLEFT OUTBOARD SEAT TRACK AT FRAME 30 TO 36 IS CORRODED OUT OF LIMITS. REMOVED AND REPLACED SEAT TRACK (145-32606-003).SDR FDKA200803130Seat Track · corrodedLEFT OUTBOARD SEAT TRACK AT FRAME 24 TO 30 IS CORRODED OUT OF LIMITS. REMOVED AND REPLACED SEAT TRACK.SDR DLM90080425Seat Track · damagedCABIN SEAT TRACK LBL 54.5 IS OUT OF LIMITS AT FUSELAGE STA 972-1090. REMOVED AND REPLACED SEAT TRACK FS 899 TO 1090, IAW MD90 SRM 53-40-01 FIG 6.SDR DLM90080424Seat Track · damagedCABIN SEAT TRACK LBL 54.5 IS OUT OF LIMITS AT FUSELAGE STA 760-899. REMOVED AND REPLACED SEAT TRACK FS 760-899, IAW MD90 SRM 53-40-01 FIG 6.SDR DLM90080414Seat Track · damagedCABIN SEAT TRACK RBL 54.5 OUT OF LIMITS, FS 731. REPAIRED SEAT TRACK, IAW MD90 SRM 53-40-01 VOL I.SDR DLM90080413Seat Track · damagedCABIN SEAT TRK RBL 54.5 OUT OF LIMITS FS 1144-1316. REPAIRED SEAT TRACK, IAW MD90 SRM 53-40-01 VOL I.SDR DHL2008805537Cargo Track · wornUPPER CARGO COMPT NR 7 TRACK LUG WORN (STA 290.000 - 340.000) MAJOR REPAIR. PERFORMED MAJOR REPAIR IAW SRM 53-2-3 PG 49-50. REMOVED TRACK DAMAGED SEGMENT IAW SRM 53-2-3. CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B. INSTALLED NEW TRACK SEGMENT IAW SRM SDR DHL2008805536Cargo Track · wornUPPER CARGO COMPT NR 3 TRACK LUG WORN (STA 590.000 - 620.000) MAJOR REPAIR. CUT OUT TRACK SEGMENT AND FABRICATED (3EA) SPLICES (AL7075T6 0.100", 0.125" AND 0.160") IAW SRM 53-2-3 PG 49-50 FIG 14. CLEANED, TREATED AND PRIMED AREA AND SPLICES IAW SRM 51-1-8B. SDR DLM90080417Seat Track · damagedFOUND CABIN SEAT TRACK RBL 54.5 OUT OF LIMITS, 590-674.SDR DLM90080416Seat Track · damagedFOUND CABIN SEAT TRACK RBL 54.5 OUT OF LIMITS, 1022-1050. REPAIRED SEAT TRACK, IAW MD90 SRM 53-40-01 VOL I.SDR DLM90080415Seat Track · damagedCABIN SEAT TRACK RBL 22 OUT OF LIMITS, 1210-1364. REPAIRED SEAT TRACK, IAW MD90 SRM 53-40-01 VOL I.SDR 08FDEA01112Seat Track · corrodedMAIN CABIN COMPARTMENT, SEAT TRACK CORRODED AT BS 950C, 8 BL 0. REMOVED SEAT TRACK SECTION- OUT OF LIMITS BL 0 STA 950C TO STA 1010 IAW SRM 51-30-2. FABRICATED, LOCATED AND DRILLED NEW SEAT TRACK IAW SRM ER 01-049 AND SRM 53-10-5 FIG7. TREATED AND PRIMED IASDR TRAX200800458Seat Track · corrodedFLOOR SEAT RAIL IS CORRODED AT FS 364.00, RBL 9. DRILLED, REMOVED AND REPLACED SEAT FLOOR RAIL AT FS 364.00 RBL 9 SRM 51-41-00 CRJ 700. JOB COMPLETED. SUPPLEMENTAL SDR CLOSED 3/28/08.SDR USAA920080710Seat Track · corrodedSAL - MAJOR REPAIR - C6 CHECK - CORROSION ON CABIN SEAT TRACK, BS 1483/FR 34, -Y765. REPAIRED CABIN SEAT TRACK, BS 1483/FR 34, -Y765 IAW A320 SRM 53-00-15.SDR UPS08M52173Seat Track · corrodedINSPECTION TYPE:C CABIN CORROSION ON SEAT TRACK CROWN AND FLANGE AT STA 824-865 X=-27. CORROSION ON AFFECTED AREA REMOVED. MATL THK:0.145 INCH (CROWN), MATL REMVD:0.060" (STA 859-861), MATL REMAINED:0.085 INCH FOUND OUT OF LIMIT. DISCREPANT SEAT TRACK REMOVSDR UPS08M52079Seat Track · corrodedINSPECTION TYPE:C CABIN - CORROSION ON SEAT TRACK CROWN & CHANNEL AT STA 830-899 X=-75. CORR AT AFFECTED AREA REMVD. MAT'L THK:0.145"(CROWN), MAT'L REMVD:0.05 0" (STA840), MAT'L REMN:0.095". FOUND OUT OF LMT. DISCREPANT SEAT TRAC K (STA830-929) TRIMMED OUTSDR QXEA200800333Seat Track · corrodedPDX - C4 - LT INBD SEAT TRACK NR 4 HAS SEVERAL AREAS OF CORROSION AT STA X209, X228, X240, X250, X268. REMOVED SEAT TRACK AND INSTALL NEW SEAT TRACK IAW DHC 8 (200) SRM 51-40-00 AND 51-40-11.SDR QXEA200800334Seat Track · corrodedPDX - C4- RT INBD SEAT TRACK NR 7 HAS SEVERAL AREAS OF CORROSION AT STA X214 TO X228. REMOVED SEAT TRACK AND INSTALL NEW SEAT TRACK IAW SRM 51-40-00 AND 51-40-11.SDR QXEA20080033Seat Track · corrodedPDX - C4- LT INBD SEAT TRACK NR 4 HAS SEVERAL AREAS OF CORROSION AT STA X209, X228, X240, X250, X268. REMOVED SEAT TRACK AND INSTALL NEW SEAT TRACK IAW DHC 8 (200) SRM 51-40-00 AND 51-40-11.SDR 08FDEA01080Seat Track · corrodedMAIN DECK FLOOR SEAT TRACK, BS 1124 - 1125, LBL 45 - 46, HAS CORROSION AROUND FASTENER HOLE, UPPER AND LOWER SURFACE. REMOVED AND REPLACED SEAT TRACK, IAW SRM 53-10-5. THIS IS CLASSIFIED AS A MINOR REPAIR.SDR DLM90080432Seat Track · corrodedCABIN SEAT TRACK LBL 54.5 HAS AREAS WITH NICKS, GOUGES, CORROSION AND BARE METAL FROM FS 196.25 TO FS 1364. REMOVED DAMAGE, FOUND THE FOLLOWING OUT OF SRM LIMITS: FS 421-620, 761-890 AND 1051-1090. ALL OTHER AREAS WITHIN SRM LIMITS, 53-40-01 FIG 4. ALL REPASDR DLM90080421Seat Track · corrodedCABIN SEAT TRACK RBL 22 OUT OF LIMITS, 588-864. REMOVED AND REPLACED DAMAGED SEAT TRACK RBL22 588-864, IAW MD90 SRM 53-40-01.SDR DLM90080420Seat Track · corrodedCABIN SEAT TRACK RBL 54.4 OUT OF LIMITS FS 503-550. REMOVED AND REPLACED SEAT TRACK, IAW MD90 SRM 53-40-01 VOL I.SDR 08FDEA01016Seat Track · corrodedMAIN DECK ZONE 221, FORWARD CABIN SEAT TRACK 37.5 LBL HAS STRUCTURAL DAMAGE (HEAVY CORROSION EXFOLIATED) BETWEEN FR 15A THRU FR 19. REMOVED SEAT TRACK IAW SRM 51-40-21, LOCATED AND DRILLED NEW SEAT TRACK IAW SRM 51-40-44. INSTALLED NEW SEAT TRACK IAW SRM 5SDR DLM90080465Seat Track · gougedFOUND CABIN SEAT TRACK RBL 22 OUT OF LIMITS FS 1145-1153. REPAIRED SEAT TRACK, IAW MD90 SRM 53-40-01 FIG 6 VOL 1.SDR UPS08851908Seat Track · corrodedINSPECTION TYPE:C2 LOWER FLANGE OF SEAT TRACK EXTRUSION EXFOLIATED IN MAIN CABIN, STA 1455-1462 LBL 60. REPAIRED CABIN SEAT TRACK AT STA 1455-1462 LBL 60 IAW SRM 53-02-03-0, AND SRM 53-02-03-0 FIG 008A.SDR DLM90080423Seat Track · damagedCABIN SEAT TRACK LBL 22 OUT OF LIMITS 3 AREAS FS 731 TO 769. REPAIRED CABIN SEAT TRACK, IAW MD90 SRM 53-40-01 FIG 6.SDR UPS08851909Seat Track · corrodedINSPECTION TYPE:C2 CORROSION ON SEAT TRACK AT STA 1470 LBL 45. FABRICATED AND REPLACED CABIN SEAT TRACK SECTION AT STA 1470 AND LBL 45 IAW SRM 51-03-00, SRM 51-03-02, SRM 51-03-01 AND SRM 51-1-8.SDR P5CA0801549Cargo Track · crackedMAIN DECK CARGO TRACK HAS A CRACK AT BS 1800 LBL 98.5 MEASURING 10.0 INCHES. TIME LIMITED REPAIR WAS ACCOMPLISHED PER EO NR 4453A138 PART 1.SDR A6WA200840207Cargo Track · corrodedONE CARGO TRACK CORRODED IN CARGO BAY AT FS 567 LBL 9. CORROSION REMOVED IAW CRJ 200 SRM 51-21-06 OUT OF LIMITS IAW CRJ 200 SRM 53-61-49 THEREFORE SEAT RAIL AT FS 567 RBL 9. REPLACED IAW CRJ 200 SRM 51-40-11 AND 51-41-02. (M)SDR UIEA200800086Seat Track · corrodedMAIN DECK STA 1720 TO 1740 RBL 11 SEAT TRACK FOUND LEVEL 1 CORROSION. CORROSION REMOVED IAW SRM 51-10-01.
SDR DHL2008763518Seat Track · corrodedFOUND SEAT TRACK CORRODED AT BS 480-600, RBL 24. REMOVED, FABRICATED FROM BAC 1520-792, PO NR 9006020, 209" LONG, AND INSTALLED PER B727 SRM 53-10-2 FIG 7 AND 53-10-5 FIG 1.SDR 08FDEA00974Rail · bentFWD CARGO COMPARTMENT; ROLLER TRAY SIDE RAIL IS BENT; BY CARGO DOOR OPENING JUST ABOVE DOOR SPOOL NR 3. ROLLER TRAY FOUND TO BE OUT OF LIMITS IAW SRM 53-10-00 REMOVED AND REPLACED IAW AMM 25-52-21-4 PARA 2B & 2D. FABBED IAW DWG. A25771256. ALODINED IAW SRM 51
Back to JASC 5347