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 FDEA201001140147Seat Track · damagedEXISTING SEAT TRACK HAS SCALLOPS PREVIOUSLY REMOVED AT STA 1635-1640, RBL 24 WHICH WILL INTERFERE WITH INSTALLATION OF CARGO HANDLING SYS. R & R SEAT TRACK BETWEEN STA 1540 TO 1640, RBL 24.75 IAW SRM 51-40- 02. MAJOR REPAIR.SDR AALA20100113TUL12Seat Track · corrodedNUMBER 1 SEAT TRACK CORRODED OUT OF LIMITS BETWEEN STATION 1174 AND 1309. REPLACED SECTION OF SEAT TRACK PER SRM 51-01 MPN AA74-A-12.SDR AALA20100113TUL01Track · corrodedCORROSION FOUND ON AFT CARGO LEFT TIE DOWN TRACK AROUND FASTENER HOLES BETWEEN STATION 1212 AND 1322. REPLACE AFT CARGO TIE DOWN TRACK PER SRM 51-30-01 AND 51-30-05.SDR FDEA201001130134Seat Track · corrodedCORROSION RBL 45 SEAT TRACK FLANGES AND SPLICE HARDWARE STA 950. REMOVED CORROSION & FOUND TO BE OUT OF LIMITS IAW SRM 51-10-6, REMOVED SEAT TRACK SECTION BS 950 TO 1020 IAW SRM 51-30-2. FABRICATED NEW SEAT TRACK IAW SRM 53-10-5, TREATED AND PRIMED SEAT TRACSDR FDEA201001130133Seat Track · corrodedCORROSION RBL 45 SEAT TRACK STA 870 - 910 FWD END OF TRACK HAS LIFTED METAL IN CHANNEL AT STA 870. REMOVED DAMAGED SEAT TRACK IAW SRM 51-30-2. FABRICATED NEW SPLICES & SEAT TRACK IAW SRM 53-10-5 FIG 1. TREATED & PRIMED SEAT TRACK & SPLICES IAW SRM 51-30-2.SDR FDEA201001130102Seat Track · corrodedCORROSION SEAT TRACK MAIN CABIN BS 990 LBL 45. REMOVED SEAT TRACK SECTION, FABRICATED NEW SEAT TRACK IAW SRM 53-10-5 FIG 1, ALODINE & PRIME IAW SRM 51-10-2, INSTALLED NEW SEAT TRACK SECTION IAW SRM 51-30-2.SDR FDEA201001130097Seat Track · corrodedMCD SEAT TRACK CROWN HAS NUMEROUS GOUGES BETWEEN STA 780 TO STA 820 AT LBL 46. REMOVED AND REPLACED SEAT TRACK FROM SPLICE AT STA 780, TO SPLICE AT STA 879, LBL 46, IAW SRM 51-40-02. CATEGORY "A", MAJOR REPAIR.SDR FDEA201001130096Seat Track · corrodedMCD SEAT TRACK CROWN HAS NUMEROUS CORROSIONS BETWEEN STA 980 TO STA 1005 AT LBL 46. CAPTURED THE CLASS "A" MAJOR REPAIR THAT R & R SEAT TRACK PN BAC1520841 IAW SRM'S 53-00-52, 51-40-02, 51-20-01. SEAT TRACK CORROSION WAS OUT OF LIMITS, MAT LOSS WAS MORE THAN SDR FDEA201001130095Seat Track · corrodedNUMEROUS GOUGES AND CORROSION FOUND ON MCD SEAT TRACK BETWEEN STA 900 TO STA 1076 AT LBL 25. R & R SEAT TRACK IAW SRM 51-40-02/ 51-20-05. GOUGES AND CORROSION FOUND TO BE OUT OF LIMITS IAW SRM 53-00-52, FIG 101. NEW SEAT TRACK FABRICATED ON SHOP TRAVELER NR SDR AALA20100112TUL15Seat Track · damagedGOUGE AT STATION 1294. INSTALLED NEW SECTION AT SPLICE AFT UNDER SRM 53-05-00.SDR DL757100397Seat Track · gougedLT INBD SEAT TRACK UPPER SURFACE IS GOUGED AT STA1478 - 1489. REPLACE SECTION OF TRACK IAW SRM 53-00-52.SDR AALA20100112TUL11Seat Track · damagedDAMAGE TO SEAT TRACK NUMBER 4 AT STATION 1098. INSTALLED SEAT TRACK SPLICE AT STATION 1080 TO 1127 UNDER SRM 53-05-00.SDR AALA20100112TUL08Seat Track · corrodedSEAT TRACK NUMBER SIX HAS CORROSION REMOVAL BEYOND MATERIAL LIMITS AT STATION 597. REMOVED AND INSTALLED NEW SEAT TRACK FROM STATION 589 TO 798 PER SRM 51-30-01.SDR AALA20100112TUL07Seat Track · corrodedNUMBER 2 SEAT TRACK CORROSION REMOVAL OUT OF LIMITS AT STATION 1206. INSTALLED SEAT TRACK PLUG REPAIR PER SRM 53-05 FIG 4A.SDR AALA20100112TUL02Seat Track · corrodedSEAT TRACK NUMBER 5 CORROSION REMOVAL OUT OF MATERIAL LIMITS AT STATION 1300 TO 1307. REPLACED WITH NEW SEAT TRACK AND SPLICE PER SRM 53-05-00 FIG 4F.SDR FDEA201001120092Seat Track · corrodedCORRODED SEAT TRACK AT LT STA 869 TO 889 X=8.5. CORRODED SEAT TRACK REPAIRED BY SECTIONAL SEAT TRACK REPLACEMENT IAW SRM 53-00-52 REPAIR 1, FIG 201, REV 42. REPAIR IS CLASSIFIED AS MAJOR IAW GMM 6-2-100 REV 109.SDR FDEA201001120084Seat Track · corrodedCORROSION SEAT TRACK MAIN CABIN BS 610 TO BS 578 LBL 24 REMOVED CORRODED SEAT TRACK SECTION IAW SRM 51-30-2. FABRICATED NEW SEAT TRACK, ANGLE SPLICES, & STRAP SPLICE IAW SRM 53-10-5 FIG 1. TREATED AND PRIMED SEAT TRACK AND SPLICES IAW SRM 51-10-2. INSTALLESDR A6WA201040161Seat Track · corrodedRT NR 2 FLOOR SEAT TRACK CORRODED BEYOND LIMITS REQUIRES REPLACEMENT. REPLACED RT NR 2 FLOOR SEAT TRACK.SDR AALA20100111TUL11Seat Track · corrodedTHE NUMBER 3 SEAT TRACK IS CORRODED AT STATION 682. REPLACED NR 3 SEAT TRACK STATION 640 TO 780.SDR AALA20100110TUL07Seat Track · corrodedCORROSION FOUND SEAT TRACK NUMBER 6, STATION 373. REMOVED CORROSION AND INSTALLED SEAT TRACK PLUG PER SRM 53-05-00 FIG 4A.SDR FDEA201001100083Seat Track · corrodedCORROSION SEAT TRACK BS 540 TO BS 510 LBL 45 REMOVED DAMAGED SEAT TRACK SECTION FROM BS 480-720A 10 IN LBL 45. FABRICATED NEW SEAT TRACK SECTION, ANGLE SPLICES AND STRAP SPLICE IAW SRM 53-10-5 FIG 1. TREATED AND PRIMED SEAT TRACK & SPLICES IAW SRM 51-10-2 ASDR R61A20100004Seat Track · corrodedLEVEL TWO CORROSION FOUND DURING HEAVY CHECK. FWD CABIN LT SEAT TRACK BEAM AT FRAME 18 HAS LEVEL TWO CORROSION. MAINTENANCE REQUESTED EMB ENGINEERING SUPPORT AND RECEIVED ETD2010-170/00155. MAINTENANCE PERFORMED REPAIR PER THE ETD, AC STILL OUT OF SERVICE FSDR HALA2010010900037Seat Track · corrodedLEVEL 2 CORROSION FOUND ON FWD CABIN SEAT TRACK, BETWEEN STA 203-242 RBL 21 INCH. REMOVED CORROSION AT FWD CABIN SEAT TRACK BETWEEN STA 203 TO STA 242 RBL 21 INCH. FOUND TO BE OUT OF LIMITS PER REF B717 SRM 53-20-52. REMOVED SEAT TRACK AT STA 203 - 265.5 RBSDR AALA20100107TUL16Track · corrodedCORROSION ALONG TIE DOWN TRACK AT STATION 1220. INSTALLED NEW TIE DOWN TRACK AT STATION 1220 UNDER SRM 51-30-05.SDR SWIA201023557Seat Track · corrodedRIGHT SIDE FORWARD FLOOR SEAT TRACK CORRODED. (C CHECK) REPLACED TRACK PER AMM.SDR C77A225142Seat Track · corrodedDURING BASIC CHECK INSP, MX VISIT CORROSION WAS FOUND ON LT FLOOR TRACK, PN 170-03264-001 PERMANENT REPAIR WAS MADE IAW ETD 2010-170/00030 AND COMPASS EO E175-53MR-020. MUST BE REPLACED AT NEXT BASIC CHECK.SDR FDEA201001060036Seat Track · corrodedCORROSION SEAT TRACK MAIN CABIN BS 680 TO BS 620, BL 0. REMOVED SEAT TRACK SECTION IAW SRM 51-30-2. FABRICATED NEW SECTION SEAT TRACK IAW SRM 53-10-5 REV 102 TREATED AND PRIMED SEAT TRACK & AREA IAW SRM 51-10-2. INSTALLED SEAT TRACK SECTION IAW SRM 51-30-2.SDR FDEA201001060020Seat Track · gougedCABIN SEAT TRACK STA 1180 TO 1225 RBL45.5 GOUGED ON CROWN. REMOVED CORROSION MATERIAL LOSS .030 AREA FOUND TO BE OUT OF LIMITS TAW SRM 53- 00-52 FIG. 101, DETAIL I REMOVED SEAT TRACK STA 1180 TO 1280 RBL 45.5 IAW SRM 51-40-02. FABRICATED NEW SEAT TRACK IAWSDR FDEA201001060019Seat Track · gougedUPPER CABIN FS 900 TO 1040 SEAT TRACK RBL 45.5 HAS NUMEROUS GOUGES, SCRATCHES AND AREAS OF CORROSION. FOUND TO BE OUT OF LIMITS IAW SRM 53-00-50, FIG 101. REMOVED DAMAGED SEAT TRACK IAW SRM 51-40-02. RECEIVED NEW SEAT TRACK ON TRAVELER NR T10/816705. LOCATED,SDR FDEA201001060018Seat Track · corrodedNUMEROUS CORROSION FOUND ON SEAT TRACK FLANGE UPPER AND LWR SURFACES AT FASTENER HOLES FROM STA 680 TO STA 780 AT LBL 46. REMOVED DAMAGED SEAT TRACK, WAS OUT OF LIMITS, IAW SRM 53-00-52, IAW SRM 51-40-02. RECIVED NEW SEAT TRACK PER TRAV T10/817022. INSTALLESDR FDEA201001060017Seat Track · gougedNUMEROUS GOUGES FOUND ON SEAT TRACK BETWEEN STA 440 TO 480 AT LBL 25. REMOVED GOUGES AND FOUND TO BE OUT OF LIMITS IAW SRM 51-10-02, 53-00-52. FABBED REPLACEMENT SEAT TRACK MAE TRAV NR T10/816680. INSTALLED SEAT TRACK STA 440-680, LBL 25, IAW SRM 51-40-02. SDR AALA20100105TUL04Seat Track · corrodedCORROSION ON NUMBER 2 SEAT TRACK AT STATION 1240 LEFT BEYOND LIMITS. REPAIRED PER SRM 51-30-02.SDR AALA20100105TUL07Seat Track · corrodedCORROSION ON NUMBER 2 SEAT TRACK AT STATION 1240 LEFT. INSTALLED NEW NUMBER 2 SEAT TRACK AT STATION 1220-1309.SDR FDEA201001050030Seat Track · corrodedCORROSION SEAT TRACK 2 EA AREAS BS 1110 TO BS 1070 RBL 45. REMOVED SEAT TRACK SECTION FROM BS 1020 TO BS 1134 RBL 45 IAW B727 SRM 53-10-5 FIG 1 AND 51-30-2. FABRICATED NEW SEAT TRACK IAW SRM 53-10-5 FIG 1. TREATED AND PRIMED NEW SEAT TRACK IAW SRM 51-10-2. SDR FDEA201001050035Seat Track · corrodedCORROSION SEAT TRACK MAIN CABIN BS 720, 12 IN, RBL 45. WORK ACCOMPLISHED ON WO NR 00046937, NR N00775.SDR FDEA201001050034Seat Track · corrodedCORROSION SEAT TRACK BS 600 TO BS 620 RBL 24 MAIN CABIN. REMOVED SEAT TRACK. FABRICATED NEW SEAT TRACK IAW SRM 53-10-5 FIG 1 REV 102. TREATED AND PRIMED SEAT TRACK IAW SRM 51-10-2 AND INSTALLED SEAT TRACK IAW SRM 53-10-5 FIG 1 REV 102 & 51-30-2.SDR FDEA201001050033Seat Track · corrodedCORROSION SHORT SECTION OF FLOATING SEAT TRACK LBL 25 STA 848.5 TO 870. REMOVED SHORT SEAT TRACK IAW SRM 51-30-2. FABRICATED NEW SEAT TRACK SECTION IAW SRM 53-10-5 FIG 1. ALODINED & PRIMED IAW SRM 51-10-2. INSTALLED IAW SRM 51-30-2.SDR FDEA201001050032Seat Track · corrodedCORROSION SEAT TRACK MAIN CABIN BS 530, RBL 45 TO BS 538, RBL 45. REMOVED SEAT TRACK AT RBL 45 BETWEEN BS 480 TO BS 740. FABRICATED SEAT TRACK REPAIR IN 2 SECTIONS (1) FROM BS 480 TO BS 720B PLUS 10" (2) FROM BS 720B PLUS 10" TO BS 740 RBL 45. FABRICATED SESDR FDEA201001050031Seat Track · corrodedCORROSION SEAT TRACK MAIN CABIN BS 390 RBL 45. REMOVED DAMAGED SEAT TRACK SECTION, FABRICATED NEW SEAT TRACK SECTION, LOWER SPLICE, & 2 ANGLES. TREATED AND PRIMED PARTS IAW SRM 51-10-2. INSTALLED NEW SEAT TRACK & SPLICES IAW SRM 51-30-2, SRM 53-10-5 FIG SDR A6WA201040162Seat Track · corrodedLT NR 1 FLOOR SEAT TRACK CORRODED. R & R SEAT TRACK.SDR A6WA201040160Seat Track · corrodedRT FLOOR SEAT TRACK CORRODED, R & R TRACK.SDR FDEA201001040007Seat Track · damagedUPPER CABIN SEAT TRACK FS 1320-1540 RBL 45.5 HAS SCRATCHES AND TOOL MARKS WITH CORROSION IN NUMEROUS AREAS. BLEND OUT SCRATCHES, TOOL MARKS AND CLEAN UP CORRODED AREAS PREVIOUSLY MARKED ON TOP FLANGE SURFACES OF SEAT TRACK, FOUND 3 EA SPOTS OUT OF LIMITS STASDR C2XA10SH003Support Angle · corrodedSHV - DURING C-CHECK (FRAME 45) LT UPPER SEAT TRACK SUPPORT ANGLE CORRODED (LEVEL 2 LOCAL) IN CURVE. MAINTENANCE PERFORMED REPAIR OF LT UPPER SEAT TRACK SUPPORT IAW EC5320-01515 ORIG AND IAW ETD 2009-145/10245. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICESDR UHLA2009123100155Seat Track · corrodedLEVEL 2 CORROSION ON RT SEAT TRACK BEAM AT FR 12 THROUGH FR 17. REPAIRED SEAT TRACK BEAM IAW ETD 2009-170/10421.SDR FDEA200912314574Seat Track · scratchedUPPER CABIN RT SIDE FS 843 TO 823 SEAT TRACK 24.75 HAS SCRATCHES. REMOVED SCRATCHES ON SEAT TRACK STA 823 TO 843 RBL24.75 IAW SRM 53-00-52. MAX CLEAN UP 0.020 AT STA 823 MAT LOSS .025 AT STA 843 MAT LOSS .029 FOUND TO BE OUT OF LIMITS IAW SRM 53-00-52. RESDR FDEA200912314573Seat Track · gougedNUMEROUS GOUGES FOUND ON SEAT TRACK FROM STA 1120 TO STA 1180 AT LBL 25. FOUND OUT OF LIMITS IAW SRM 53-00-52 FIG. 101, DET I, PG 102. R & R SEAT TRACK IAW SRM 51-40-02 CLASSIFIED AS MAJOR REPAIRSDR UHLA2009123000154Seat Track · corrodedLEVEL 2 CORROSION ON LT SEAT TRACK BEAM AT FRAME LOC 17, 18, 19. REPAIRED AREAS OF LT SEAT TRACK BEAM IAW ETD 2009-170/10421.SDR USAA2009123193454Seat Track · corrodedBFM - MAJOR REPAIR - C4 CHECK - CORROSION ON CABIN SEAT TRACK, BS 347, LBL 54.75, WL 200. REPLACED CABIN SEAT TRACK, BS 347, LBL 54.75, WL 200 IAW B767 SRM 53-10-52 AND 51-40-02. UPON FURTHER EVALUATION THIS DISCEPANCY SHOULD BE DOCUMENTED AS LEVEL 2 CORROSDR FDEA200912304568Seat Track · corrodedUPPER CABIN FS 900 TO 1040R SEAT TRACK RBL 24.75 HAS AREAS OF SCRATCHES GOUGES AND AREAS OF CORROSION. R & R SEAT TRACK IAW SRM 51-40-02 / 51-20-05. GOUGES AND CORROSION WERE OUT OF LIMITS IAW SRM 53-00-52, FIG. 101. NEW SEAT TRACK FABRICATED ON SHOP TRAVELESDR FDEA200912304567Seat Track · damagedUPPER CABIN SEAT TRACK RBL 45.5 FS 680 TO 730 HAS TOOL MARKS AND SCRATCHES. REMOVED AND REPLACED SEAT TRACK AT RBL 45.5 FS 640 TO 780 IAW SRM 51-40-02. REPAIR CLASSIFIED AS MAJOR.
Back to JASC 5347