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 GAIA9728Seat Track · corrodedDURING CPC INSPECTION, THE FOLLOWING LEVEL 2 CORROSION ITEMS WERE NOTED W/C 0450, NR 4 SEAT TRACK AT STA 760 TO STA 848. CORRECTIVE ACTION WILL BE DONE WITH C-CHECK. ALL ITEMS REPAIRED PER SRM. REF OPERATOR CONTROL NR 97ZZZX2403 THROUGH 97ZZZX2416. (X)SDR GAIA9727Seat Track · corrodedDURING CPC INSPECTION, RTHE FOLLOWING LEVEL 2 CORROSIION ITEMS WERE NOTED W/C 79538. SEAT TRACK AT STA 1120 LBL 44.0. REFERENCE OPERATOR CONTROL NR 97ZZZX 2417 THROUGH 97ZZZX2419. (X)SDR C2XA97IA102Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE RIGHT WALL FORWARD SEAT TRACK WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED SEAT TRACK AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR 97ZZZX2407Seat Track · corrodedDURING CPC INSPECTION, THE FOLLOWING LEVEL 2 CORROSION ITEMS WERE NOTED W/C 0421, NR 1 SEAT TRACK AT STA 344 TO STA 480. CORRECTIVE ACTION WILL BE DONE WITH C-CHECK. REFERENCE OPERATOR CONTROL NR GAIA9728 AND 97ZZZX2403 THROUGH 97ZZZX2416.SDR 97ZZZX2406Seat Track · corrodedDURING CPC INSPECTION, THE FOLLOWING LEVEL 2 CORROSION ITEMS WERE NOTED W/C 0424, NR 1 SEAT TRACK AT STA 740 TO STA 760. CORRECTIVE ACTION WILL BE DONE WITH C-CHECK. REFERENCE OPERATOR CONTROL NR GAIA9728 AND 97ZZZX2403 THROUGH 97ZZZX2416.SDR 97ZZZX2405Seat Track · corrodedDURING CPC INSPECTION, THE FOLLOWING LEVEL 2 CORROSION ITEMS WERE NOTED W/C 0425, NR 1 SEAT TRACK AT STA 760 TO STA 848. CORRECTIVE ACTION WILL BE DONE WITH C-CHECK. REFERENCE OPERATOR CONTROL NR GAIA9728 AND 97ZZZX2403 THROUGH 97ZZZX2416.SDR 97ZZZX2404Seat Track · corrodedDURING CPC INSPECTION, THE FOLLOWING LEVEL 2 CORROSION ITEMS WERE NOTED W/C 0426, NR 1 SEAT TRACK AT STA 848 TO STA 870. CORRECTIVE ACTION WILL BE DONE WITH C-CHECK. REFERENCE OPERATOR CONTROL NR GAIA9728 AND 97ZZZX2403 THROUGH 97ZZZX2416.SDR 97ZZZX2403Seat Track · corrodedDURING CPC INSPECTION, THE FOLLOWING LEVEL 2 CORROSION ITEMS WERE NOTED W/C 0433, NR 2 SEAT TRACK AT STA 760 TO STA 848. CORRECTIVE ACTION WILL BE DONE WITH C-CHECK. REFERENCE OPERATOR CONTROL NR GAIA9728 AND 97ZZZX2404 THROUGH 97ZZZX2416.SDR SWIA97985Seat Track · corrodedAREA UNDER LAVATORY FLOOR PANEL SEAT TRACK IS SHOWING SIGNS OF CORROSION. REMOVED AND REPLACED BUTT STRAP UNDER LAVATORY WITH A NEW BUTT STRAP AIW MM 51-00-00.SDR AWXA9700194Seat Track · corrodedDURING ROUTINE MAINTENANCE CHECK, FOUND CORROSION ON SEAT TRACK BS 1320, LBL 24, WL 208. REPLACED SEAT TRACK FROM BS 1320 TO 1350, LBL 24, WL 208 PER SRM 53-00-52.SDR EISA97071Seat Track · corrodedRIGHT OUTBOARD SEAT TRACK CORRODED AT STATION 700. INSTALLED NEW TRACK SECTION PER SRM 51-30-2. (M)SDR EISA97066Seat Track · wornSEAT TRACK WORN MORE THAN 20 PERCENT MATERIAL LOSS AT FS 740. REPLACED SEAT TRACK SECTION PER SRM 51-30-2. (M)SDR EISA97065Seat Track · pitted corrosionPITTING CORROSION ON SEAT TRACK BETWEEN FS 443 AND 461 LBL 44. REMOVED AND REPLACED SEAT TRACK SECTION PER SRM 53-10-5. (M)SDR EISA97064Seat Track · crackedFOUND CRACKED SEAT TRACK FS 520-540 LBL 45.5. REPLACED SEAT TRACK SECTION FS 520-540 PER SRM 51-10-5 AND 51-30-2. (M)SDR EISA97060Seat Track · corrodedEXFOLIATED CORROSION ON SEAT TRACK, FS 680 RBL 45.5. REPLACED SEAT TRACK FROM FS 640 TO 680 PER SRM 51-30-02. (M)SDR DHL9771272DSeat Track · corrodedAT D-CHECK, CABIN SEAT TRACK FLANGE CORRODED AT STA 740 TO 760 LB 48. REMOVED AND REPLACED SEAT TRACK AND INSTALLED FASTENERS PER SRM 51-10-1.SDR TWAA9808903Seat Track · corrodedMCI - DURING OP 16 MAINTENANCE CHECK FOUND RT OTBD CHAIR TRACK CORRODED BEYOND REMOVAL LIMITS AT STA 200 TO STA 800. REMOVED AND REPLACED CHAIR TRACK FS 200 TO FS 800, RT OTBD PER SRM 53-05, FIG 4F, AND STD PRACTICES. (X)SDR TWAA9808814Seat Track · corrodedMCI - DURING OP 16 MAINTENANCE CHECK, THE MATERIAL REMOVED WAS BEYOND LIMITS ON CHAIR TRACK RBL 22, STATION 200 TO 212. REPLACED CHAIR TRACK PER SRM 51-01 PAGE 9, FROM FS 200 TO STATION 266. (M)SDR TWAA9737003Chair Track · corrodedMCI - DURING OP 16, FOUND CORROSION ON RT OUTBOARD CHAIR TRACK, STATION 200-800. REMOVED AND REPLACED CHAIR TRACK PER SRM 53-05, FIGURE 4F AND TWA STANDARD PRACTICES. (M)SDR PCAA9700355Seat Track · corrodedDURING A C-CHECK, THE RIGHT INBOARD FORWARD CABIN SEAT RAIL WAS DISCOVERED TO BE CORRODED UNDER THE LAVATORY. REMOVED AND REPLACED SEAT RAIL IAW DEHAVILLAND DRAWINGS AND STRUCTURAL REPAIR MANUAL PROCEDURES. A/C RETURNED TO SERVICE. (M)SDR PCAA9700354Seat Track · corrodedDURING A C-CHECK, THE LEFT FORWARD SECTION OF THE CABIN SEAT RAIL WAS FOUND TO HAVE MINOR CORROSION UNDER THE WARDROBE COMPARTMENT. BLENDED OUT AREAS OF CORROSION IAW RD8-53-2672. A/C RETURNED TO SERVICE. (M)SDR AALA970495Tie Down Track · corrodedTUL - EXFOLIATION CORROSION AT SEVERAL FASTENER HOLES WITH CORROSION AT ALL HOLES IN LT FORWARD TIE-DOWN TRACK. REMOVED AND INSTALLED NEW TIE-DOWN TRACK. INSTALLED PER SRM 51-00-00. TST: 33,555 HOURS. CYCLES, 19,141. (X)SDR TWAA9809605Seat Track · corrodedMCI - DURING OP 16 MAINTENANCE CHECK, FOUND CORROSION AT FS 1212 TO FS 1331 IN RT FLOOR TRACK. REPLACED WITH NEW FLOOR TRACK PER SRM 51-01, PG 1, ITEM C. TOTAL TIME: 42,544 HOURS. TOTAL CYCLES: 22,023. (X)SDR TWAA9808810Seat Track · corrodedMCI - DURING OP 16 MAINTENANCE CHECK, FOUND CORROSION ON LEFT FLOOR TRACK AT FS 1212 TO 1331. INSTALLED NEW TRACK PER SRM 51-01, AND STD PRACTICES. (M)SDR TWAA9808806Seat Track · corrodedMCI - DURING OP 16 MAINTENANCE CHECK, FOUND CHAIR TRACK CORROSION AT FS 1174 TO 1309, LBL 54 INCHES. REPLACED TRACK PER SRM 55-01, AND SRM 51-20-0. (M)SDR TWAA9808802Seat Track · corrodedDURING OP 16 MAINTENANCE CHECK, FOUND CORROSION ON RT TRACK AT STATION 1156 TO 1007. REPLACED TRACK FROM 1007 TO 1156, PER SRM 51-01. (M)SDR DHL9771271DSeat Track · corrodedAT D-CHECK, FOUND CABIN SEAT TRACK CORRODED AT STA 765 LB 48. REMOVED AND REPLACED SEAT TRACK FROM STA 760 TO STA 850 PER SRM 51-10-1.SDR C2XA97IA096Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE LEFT FLOOR SEAT TRACK WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED SEAT TRACK AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA97IA095Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE RIGHT FLOOR SEAT TRACK WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED SEAT TRACK AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA97IA094Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE LEFT WALL SEAT TRACK WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED SEAT TRACK AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR UPS97222393Seat Track · crackedINSPECTION TYPE-C, CRACK ON FLANGE OF SEAT TRACK AT BS 760 RBL 45.5. SEAT TRACK REPLACED IAW SRM 51-30-2.SDR 97ZZZX1120Seat Track · corrodedCORRODED SEAT TRACKS UNDER GALLEYS. FOUND DURING CPCP INSPECTION. SEAT TRACK SECTION REPLACED. SUBMITTER STATED SPECIAL ATTENTION TO SEALING AREA, UNDER GALLEY AND MAINTAINING ENVIRONMENTAL SEAL BETWEEN C-CHECKS.SDR 97ZZZX1119Seat Track · corrodedCORRODED SEAT TRACKS UNDER GALLEYS. FOUND DURING CPCP INSPECTION. SEAT TRACK SECTION REPLACED. SUBMITTER STATED SPECIAL ATTENTION TO SEALING AREA, UNDER GALLEY AND MAINTAINING ENVIRONMENTAL SEAL BETWEEN C-CHECKS.SDR C2XA97IA077Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE AFT SEAT TRACK ON THE RIGHT SIDE FRAME 39-40, WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA97IA075Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE LEFT FLIGHT ATTENDANT SEAT TRACK WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA97IA074Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE LEFT FLIGHT ATTENDANT SEAT TRACK WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA97IA072Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE RIGHT FLIGHT ATTENDANT SEAT TRACK WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA97IA070Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE RIGHT CENTER SEAT TRACK WAS FOUND TO BE CORRODED AT FRAME 36 ATTACHMENT. MAINTENANCE REMOVED THE DAMAGED SECTION AND PERFORMED A SPLICE REPAIR PER ATR SRM 53-53-00 AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR UPS97822322Cargo Track · corrosionINSPECTION TYPE: C. NR 1 CARGO PIT LT FORWARD CARGO TRACK AND SPLICE HAVE HEAVY CORROSION. REMOVED, FABRICATED AND INSTALLED REPLACEMENT TRACK AND SPLICE IAW DWG. 5759223 AND SRM 53-1-0.SDR MWEA97168Seat Track · corrodedDURING D/E CHECK, NR 2 SEAT TRACK CORRODED STA 1030 TO 1309. MAINT INSTALLED NEW SEAT TRACK IAW SRM 53-05 FIG 14.SDR DHL9771280DSeat Track · corrodedAT D-CHECK, CORROSION AROUND NUT PLATE ON SEAT TRACK FLANGE BS 553 LBL 19. REPLACED SECTION OF SEAT TRACK FROM 532 TO 590 PER SRM 53-10-5.SDR 9706166740Seat Track · corrodedDURING PERIODIC CHECK, FOUND CORROSION IN SEAT TRACK BEAM INBOARD FLANGE LOWER SURFACE FS 1160 TO 1200, LBL 11. REPAIRED PER EA 67-123514.SDR UPS97822356Cargo Track · corrosionINSPECTION TYPE-C, C-4 CARGO PIT RT AFT FLOOR TRACK HAS HEAVY CORROSION AND CRACKING. REMOVED, FABRICATED AND INSTALLED REPLACEMENT TRACK IAW SRM 51-3-0, 51-1-20 AND DWG 5759223.SDR UPS97822337Cargo Track · corrosionINSPECTION TYPE: C. C-4 CARGO PIT RT FORWARD CARGO TRACK HAS CORROSION IN TRACK AREA THE ENTIRE LENGTH STA 1330-1500. REMOVED, FABRICATED AND INSTALLED TRACK IAW DWG 5753229 AND SRM 51-3-0.SDR UPS97822328Cargo Track · corrodedINSPECTION TYPE: C. C-3 LOWER CARGO PIT LT FORWARD FLOOR TRACK CORRODED 2 EACH PLACES. REMOVED, FABRICATED AND INSTALLED REPLACEMENT TRACK FROM STA 1078 TO 1140 IAW SRM'S 53-2-3 AND 57-3-0.SDR UPS97822313Cargo Track · corrodedINSPECTION TYPE: D. NR 1 PIT FORWARD RT CARGO TRACK HAS HEAVY CORROSION AT FORWARD END. REMOVED AND REPLACED TRACK STA 75 TO 165 PER SRM 53-11-1.SDR UPS97222148Seat Track · corrodedINSPECTION TYPE-C, CORROSION ON CARGO SEAT TRACK, STA 538 RBL 12. CORROSION REMOVAL OUT OF LIMITS. REMOVED SEAT TRACK FROM BS 480 TO 540, FABRICATED NEW SECTION OF SEAT TRACK, INSTALLED PER SRM 51-10-06, 53-10-05.SDR UPS97222147Seat Track · crackedINSPECTION TYPE-C, WHILE WORKING CARD 509145 FUSEL 43 FOUND CARGO FLOOR TRACK CRACKED BETWEEN BS 558 AND BS 564 RBL 12. REMOVED CRACKED SECTION OF SEAT TRACK, FABRICATED REPLACEMENT PART, INSTALLED PER SRM 53-10-5, 51-10-6.SDR AALA970380Tie Down Track · corrodedTUL - TIE DOWN TRACK HAS NUMEROUS AREAS OF CORROSION STATION 1007 TO 1079, TOP AND BOTTOM. INSTALLED NEW LEFT FORWARD TIEDOWN TRACK STATION 1003 TO STATION 1220. INSTALLED PER SRM 51-00 AND STANDARD PRACTICES CHIP 20. (M)SDR 9706236740Seat Track · corrodedDURING PERIODIC CHECK, FOUND CORROSION ON SEAT TRACK BEAM OUTBOARD FLANGE FASTENER HOLES FS 1080 TO 1265, LBL 11. REPAIRED PER EA 67-123514.
Back to JASC 5347