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 QXEA200700476Seat Track · damagedC4 PDX - SCRATCHES AND BARE METAL ON SEAT TRACK NR 2 BETWEEN STATION 429 AND 504. REPAIRED IAW RD8-53-1342.SDR QXEA200700478Seat Track · damagedC4 PDX - FOUND SEAT TRACK NR 12 HAS SCRATCHES AT STATION X525, X540. REPAIRED IAW RD8-53-3644 AND RD8-53-1342.SDR QXEA200700477Seat Track · damagedC4 PDX - SEAT TRACK NR 11 HAS SCRATCHES AT STATION X438, X456, X467, X492. REPAIRED IAW RD8-53-1342.SDR QXEA200700475Seat Track · chafedC4 PDX - SEAT TRACK NR 10 HAS CHAFE, SCRATCHES, NICKS AT STATION X260, X306, X376, X430. REPAIRED IAW RD8-53-1342.SDR KCSA071084Seat Track · corrodedMAIN DECK SEAT TRACK CORRODED AT BS 1930, RBL 11.SDR QXEA200700472Seat Track · damagedC4 PDX - FOUND SEAT TRACK NR 9 HAS SCRATCHES AT STATION X535 TO X545. REPAIRED IAW RD8-53-784.SDR 07FDEA01123Floorbeam · corrodedCABIN FLOORBEAM FS 720A, RBL 24.75 TO BL -0, HAS CORROSION ON UPPER SURFACE. REMOVED CORROSION, REMOVED FLOORBEAM DAMAGE IAW SRZ 27-53-034. FABED NEW ANGLES AND FILLER REPAIR IAW SRZ 27-53-034. INSTALLED REPAIR PARTS IAW SRM 51-30-2. MINOR REPAIR.SDR CPCP20070016Seat Track · corrodedCORROSION FOUND ON LT I/B SEAT TRACK AT FRAME 36. TRACK LT I/B AT FRAME 36 REPAIRED IAW SRM 53-00-00 FIG 434.SDR CPCP20070018Seat Track · corrodedCORROSION FOUND ON RT SEAT TRACK BETWEEN FRAME 36 AND 39. RT SEAT TRACK BETWEEN FRAME 36 AND 39 REPLACED AS PER SRM 51-25-04.SDR CPCP20070017Seat Track · corrodedCORROSION FOUND ON LT SEAT TRACK BETWEEN FRAME 36 AND 39. LT SEAT TRACK BETWEEN FRAME 36 AND 39, REPLACED AS PER SRM 51-25-04.SDR CPCP20070019Seat Track · corrodedCORROSION FOUND ON LT SEAT TRACK BETWEEN 39 AND 41. LT SEAT TRACK BETWEEN FRAME 39 AND 41 REPLACED AS PER SRM 51-25-04.SDR QXEA200700533Seat Track · damagedC4 PDX - SCRATCHES ON SEAT TRACK NR 5 BETWEEN STATION 500 AND 512. REPAIRED IAW RD8-53-1339.SDR QXEA200700532Seat Track · damagedC4 PDX - SCRATCHES ON SEAT TRACK NR 5 BETWEEN STATION 472 AND 484. REPAIRED IAW RD8-53-1339.SDR QXEA200700531Seat Track · damagedC4 PDX - FOUND SEAT TRACK NR 5 HAS SCRATCHES AT STATIONS X433, X436 - X456, X467 - X488, X495 - X525. REPAIRED IAW RD8-53-1339.SDR QXEA200700530Seat Track · damagedC4 PDX - SCRATCHES ON SEAT TRACK NR 5 BETWEEN STATION 440 AND 452. REPAIRED IAW RD8-53-1339.SDR KCSA071077Seat Track · damagedSTA 1903 RBL 25 SEAT TRACK HAS FLANGE PORTION BLENDED OUT WL 118.SDR EIA2007082Seat Track · corrodedSEAT TRACK FOUND CORRODED AT LBL 11 STA 470. SEAT TRACK REMOVED AS PER SRM 51-30-01. SEAT TRACK TRIMMED AND PRIMER APPLIED PER SOPM 20-41-01. SEAT TRACK INSTALLED PER SRM 53-10-05 FIGURE 4.SDR EIA2007076Seat Track · corrodedSEAT TRACK FOUND CORRODED AT LBL11 STA 470. SEAT TRACK REMOVED AS PER B747 SRM 51-30-02. SEAT TRACK TRIMMED AND PRIMER APPLIED AS PER B747 SOPM 20-41-02. SEAT TRACK INSTALLED PER B747 SRM 53-10-05 FIG 4.SDR 07FDEA01096Seat Track · corrodedMAIN CABIN SEAT TRACK CORRODED FROM FRAME 38.2 TO 40 RBL 77 REMOVED AND REPLACED SEAT TRACK ASSY IAW A300-600 SRM 51-40-21 PARA 6 AND A300-600 SRM 41-40-21 PARA 7, MINOR REPAIR PO 565247.1.SDR KCSA071074Seat Track · corrodedCORROSION ON MAIN DECK SEAT TRACK FLANGE AT BS 1700, RBL 12, WL 200.SDR MALA070045Seat Track · corrodedDOUBLER ON SEAT TRACK, AT LBL 18.3 AND STA 296 TO 305 WAS CORRODED OUT OF LIMITS. REMOVED EXISTING REPAIR DOUBLER AND INSTALLED NEW DOUBLER IAW MESABA EOS 53342, REF: EAMS WORK ORDER 215882 TASK 1521.SDR MALA070043Seat Track · corrodedDOUBLER ON SEAT TRACK, AT BL0.0 AND STA 296 TO 305 WAS CORRODED OUT OF LIMITS. REMOVED EXISTING REPAIR DOUBLER AND INSTALLED NEW DOUBLER IAW MESABA EOS 53342 REF: EAMS WORK ORDER 215882 TASK 1520.SDR CALA0700150Seat Track · corrodedINSPECTION FOUND SEAT TRACK CORRODED AT STA 1510-1586, RBL 108. REPAIRED IAW SRM 53-00-52, REPAIR 4, FIGURE 202.SDR 07FDEA01072Seat Track · wornMDCC DUMMY TRACK NR 1 FR 38.2 - FR 40 CENTER LINE OF AIRPLANE IS WORN MORE THAN .039 IAW EO6-5310-7-3322, WORN LESS THAN .078 REMOVED AND REINSTALLED FLOOR BOARDS PER A310-200 SRM 51-40-21. REMOVED AND REINSTALLED DUMMY TRACK PER A310-200 SRM 51-40-21. REPAISDR 07FDEA01064Seat Track · damagedMAIN CARGO COMPT SEAT TRACK AT STA 1541-1681 LBL 8 DAMAGED BEYOND REPAIRABLE LIMITS. REMOVED AND REPLACED DAMAGED SEAT TRACK.SDR 07FDEA01060Seat Track · corrodedMAIN CABIN SEAT TRACK CORROSION SEVERAL AREAS BETWEEN FRAME 38.2 AND 40, LBL 57. BLENDED AREAS OF CORROSION IAW A300-600 SRM 51-22-00. FOUND TO BE OUT OF LIMITS IAW A300-600 SRM 53-10-16. RECEIVED NEW SEAT TRACK, PO NR 566271.1. REMOVED AND REPLACED SEAT TSDR DHL2007806501Cargo Track · wornUPPER CARGO COMPT NR 3 TRACK LUG WORN (STA 1670.000 - 1705.000). CUT OUT NR 3 TRACK DAMAGED SEGMENT IAW SRM 53-2-3 PG 49-50 FIG 14. FABRICATED SPLICES (AL7075T6 0.100"/ 0.125"/ 0.160") IAW SRM 53-2-3 PG 49-50 FIG 14. CLEANED, TREATED AND PRIMED AREA IAW SRMSDR KCSA071072Seat Track · crackedFWD BILGE SEAT TRACK AT STA 570 HAS 1 INCH CRACK.SDR UPS07M49767Seat Track · corrodedINSPECTION TYPE:C MID CABIN - SEAT TRACK CROWN CORROSION AT STA 745 - 1129 LBL 8.5 AT SEVERAL LOC AS MARKED. CORROSION ON SEAT TRACK REMOVED PER SRM 51-21-01VIIR38 ORI THK 0.145" MATL REMOVED 0. 030" MATL REMAIN 0.115" EXCEED LIMIT PER SRM 53-70-00 FIG 3 VIR3SDR UPS07M49769Seat Track · corrodedINSPECTION TYPE:C MID CABIN-SEAT TRACK CROWN CORROSION AT SEVERAL LOC AS MARKED FROM STA 745 TO STA 1129 RBL 8.5. CORR ON S/TRACK CROWN STA 879 RBL 8.5" RMV SRM 51-21-01VIIR38 ORI THK 0 .145" MATL RMV 0.025" MATL RMD 0.070" OUT OF LIMIT SRM 53-70-00 FIG 3VIR SDR 07FDEA00996Seat Track · gougedMAIN CARGO COMPARTMENT SEAT TRACK HAS GOUGED AREAS AT F/S 909 - 1039 RBL 75. BLENDED AREA IAW SRM 53-70-00 FIG 5. SEAT TRACK EXCEEDED LIMITS IAW SRM 53-70-00 FIG 5. REMOVED DAMAGED AREA STA 930-1030 RBL 75 IAW SRM 53-70-00 FIG 4. FABRICATED NEW SEAT TRACK SDR 07FDEA00995Seat Track · gougedMAIN CARGO COMPARTMENT SEAT TRACK HAS GOUGED AREAS AT FS 1139 - 1239 RBL 8. BLENDED SEAT TRACK IAW SRM 53-70-00 FIG 5, FOUND TO BE OUT OF LIMITS. REPLACED SEAT TRACK IAW SRM 53-70-00 FIG 1. SEAT TRACK FABRICATED ON MAE TRAVELER NR T7/666718. SPLICE PLATE ASDR 07FDEA00994Seat Track · gougedMAIN CARGO COMPARTMENT SEAT TRACK HAS GOUGED AREAS AT F/S 1079 - 1109 LBL8 BLENDED AREA IAW SRM 53-70-00 FIG 5. BEGINNING THICKNESS OF MATERIAL 0.145; REMOVED 0.060; OUT OF LIMITS IAW SRM 53-70-00 FIG 5. RECIEVED FROM FAB ON MAE TRAVLER NR T7/666714, SEAT TRSDR WRLA2007052Seat Track · corrodedDURING C-04 CHECK IN TPE, CORROSION FOUND CABIN SEAT TRACK STA Y=855-860, X=10, Z=-18. INSTALLED SEAT TRACK AND SPLICE PER MD-11 SRM VOL.II 51-33-01 REV.38.SDR WRLA2007051Seat Track · corrodedDURING C-04 CHECK IN TPE, CORROSION FOUND CABIN SEAT TRACK STA Y=460-470, X=-27, Z=-18. INSTALLED SEAT TRACK AND SPLICE PER MD-11 SRM VOL.II 51-33-01 REV.38.SDR SIMA200707806Seat Track · corrodedLT FWD IB SEAT TRACK CORRODED FROM FRAME 17 TO 24. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-01-06. RETURNED AIRCRAFT TO SERVICESDR 07FDEA00979Seat Track · damagedUPPER CARGO DOOR COMPARTMENT SEAT TRACK SCALLOPS DAMAGED BETWEEN STA 1086 AND STA 1095, RBL 48. REMOVED DAMAGED SEAT TRACK IAW DC/MD10-10 SRM 51-31-01 VOL 11 PG 1. FAB`D NEW SEAT TRACK IAW DC/MD10-10 SRM 53-70-00 VOL 1 AND DWG SP10S10179 REV`D, ALODINED AND SDR 07FDEA00978Seat Track · crackedMAIN CABIN COMPT SEAT TRACK AT STA 1079, RBL 27.5 IS CRACK. REMOVED DAMAGED SECTION OF SEAT TRACK AND SPLICED IAW DC10/MD10 SRM 53-70-00. FAB`D NEW EXTRUSION IAW DRG ADA8019 REV J. INSTALLED EXTRUSION IAW DC10/MD10 SRM 51-33-01 VOL. 11. ALODINED AND PRIMEDSDR DHL2007786512Seat Track · gougedCUTOUT AREA OF SEAT TRACK GOUGED AND WORN AT LT BS 994, LBL 25. REMOVED FLOOR BOARDS AND SEAT TRACK AT STA 950 TO 1130 IAW B727 SRM 51-30-2. FABRICATED AND TRIMMED AS REQUIRED NEW SEAT TRACK SECTION, P/N BAC 1520-792 IAW B727 SRM 53-10-5, FIG 1. TREATED, PRSDR DHL2007786509Seat Track · corrodedPITTING CORROSION IN LWR SECTION OF SEAT TRACK CUTOUT AT RT BS 486 TO 492.5, RBL 45. EVAL FOUND SEAT TRACK PITTING CORROSION BEYOND LIMITS. REMOVED SEAT TRACK FROM BS 480 TO 690 IAW B727 SRM 53-10-5, FIG 1. FABRICATED AND TRIMMED AS REQUIRED NEW SEAT TRACK SDR DHL2007786508Seat Track · gougedNUMEROUS DENTS AN GOUGES IN RT SEAT TRACK AT RT STA 1096-1103. MARKED IN RED. REMOVED SEAT TRACK AT RT RBL 45-STA 1050-1130 IAW B727 SRM 51-30-2. FABBED NEW SEAT TRACK SECTION MAT USED BAC 1520-792-792-7178T6511. PO NR 9003963, DIM 5 FT. 7" LONG IAW B727 SSDR KCSA071067Seat Track · damagedMAIN DECK SEAT TRACK IS DAMAGED AT STA 1600, RBL 65.SDR UPS07M49710Seat Track · corrodedINSPECTION TYPE:C AFT CABIN, RHS CURVED SEAT TRACK I/B AND O/B FLANGE UPPER AND LOWER SURFACE FOUND CORROSION FROM STA 1921 - STA 2007. (-107.5"). CORROSION REMOVED PER SRM 51-21-01 VOLIIR38 ORI THK 0.080" MATL REMOVED 0.030" MAT`L REMAIN 0.050" FOUND OUT OF SDR UPS07M49709Seat Track · corrodedINSPECTION TYPE:C AFT CABIN, LT CURVED SEAT TRACK I/B AND O/B FLANGE UPPER AND LOWER SURFACE FOUND CORROSION BETWEEN STA 1931 - STA 2007 LT 107.5". CORROSION REMOVED PER SRM 51-21-01 VIIR38. ORI THK 0.080" MATL REMOVED 0.040" MATL REMAIN 0.040" OUT OF LIMIT SDR UPS07M49622Seat Track · corrodedINSPECTION TYPE:C AFT CABIN - SEAT TRACK CORROSION ON FLANGES & CROWN FROM STA 1331 - ST A 1361 RIGHT RBL 75 AS MARKED. CORROSION ON SEAT TRACK FLANGES & CROWN REMOVED PER SRM 51-21-01 VOL II REV 38. ORI THK 0.080" (FLANGE AREA) STA 1351 MATL REMOVED 0.020",SDR NWAA071155635Seat Track · corrodedDURING "M" CHECK, FOUND CORROSION ON SEAT TRACK AT BS 685-740 RBL 45. REPAIRED PER EA 56-208812.SDR 2007UALA00780Seat Track · gougedMAIN CABIN SEAT TRACK GOUGED AT BS 488 AND LBL 11. MAJOR REPAIR ACCOMPLISHED: REMOVED DAMAGED SECTION OF SEAT TRACK AND EXISTING FWD REPAIR SPLICE AT BS 422. FABRICATED NEW SEAT TRACK AND REPAIR SPLICES.SDR 07FDEA00892Seat Track · corrodedMAIN CARGO DECK SEAT TRACK ADAPTER AT FR61/Y-1456 IS CRACKED REMOVED SEAT TRACK ADAPTER AT FR 61,Y-1456 REF TO A300-600 SRM 51-40-21 PARAGRAPH 7 LOCATED AND DRILLED NEW SEAT TRACK ADAPTER REF TO A300600 SRM 51-40-44 PAR 2. ALODINED, PRIMED NEW SEAT TRACK ADAPSDR 07FDEA00886Seat Track · corrodedMAIN CABIN SEAT TRACK CORRODED IN AREAS FROM FRAME 40 TO FRAME 45 RBL 77. REMOVED CORROSION ORIGINAL THICKNESS .145 REMOVED .033 REMAINING MAT IS .112. FOUND TO BE OUT OF LIMITS IAW A300-600 53-10-16 TOOL NR TWS 58329B. REMOVED SEAT TRACK IAW FEDEX A300-600SDR 07FDEA00882Seat Track · damagedFOUND UPPER FUSELAGE CABIN SEAT TRACK AT LBL 47 STA 910 GOUGED. REMOVED DAMAGED SEAT TRACK SECTION AND INSTALLED NEW SEAT TRACK SECTION FROM STA 908 TO STA 949, LBL 47 IAW DC10/MD10 SRM 53-70-00 FIG 1 VOL 1, AND D RW SP10510179 REV D ZONE F-8.
Back to JASC 5347