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 UPS97224902Seat Track · corrodedINSPECTION TYPE-SI, CORROSION UNDER NUT PLATE STA 510 RBL 45 WL 208. REMOVED CORROSION FOUND TO BE OUT OF LIMITS PER SRM 53-10-1. REPLACED SEAT TRACK PER SRM 51-30-02 AND 51-30-8.SDR 98ZZZX3Seat Rail · wornDURING PHASE 5 INSPECTION, FOUND HOLES WORN TO LIMITS AT CO-PILOT'S RIGHT SEAT RAIL HATCH. SPLICED IN NEW SECTION OF SEAT RAIL IAW CESSNA 550 SRM FIGURE 801.SDR 97ZZZX5009Seat Track · corrodedDURING C-CHECK, CORROSION NOTED ON CABIN SEAT TRACK AT LBL 24 AT STA 1050.SDR 97ZZZX5008Seat Track · corrodedDURING C-CHECK, CORROSION NOTED ON CABIN SEAT TRACK RIGHT HAND OUTBOARD FROM STA 1010 TO STA 1030.SDR 97ZZZX4981Seat Track · corrodedDURING C-CHECK, CORROSION WAS NOTED ON CABIN SEAT TRACK BETWEEN STA 1010 - STA 1030 AT LBL 45.SDR 97ZZZX4980Seat Track · corrodedDURING C-CHECK, CORROSION NOTED ON CABIN SEAT TRACK, STA 1060 TO STA 1070 AT RBL 45.SDR 97ZZZX4923Seat Track · corrodedDURING C-CHECK, CORROSION NOTED ON CABIN LEFT HAND INBOARD SEAT TRACK FROM STA 1000 TO STA 1030.SDR 97ZZZX4922Seat Track · corrodedDURING C-CHECK, CORROSION WAS NOTED ON CABIN SEAT TRACK AT LBL 24 FROM STA 344 TO STA 480.SDR 97ZZZX4921Seat Track · corrodedDURING C-CHECK, CORROSION NOTED ON CABIN SEAT TRACK AT LBL 24 FROM STA 990 TO STA 1030.SDR 97ZZZX4916Seat Track · corrodedDURING C-CHECK, CORROSION NOTED ON CABIN SEAT TRACK FROM STA 344 TO STA 480 AT LBL 45.SDR SIMA973041Seat Track · corrodedSAW - DURING CPCP-4 INSPECTION MAINTENANCE DISCOVERED, THE LEFT FORWARD OUTBOARD SEAT TRACK CORRODED OUT OF LIMITS. MAINTENANCE REMOVED, AND INSTALLED NEW SEAT TRACK IAW SRM 51-25-04. AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR PCAA9700606Seat Track · wornCAPTAINS LEFT SEAT TRACK SHOWING WEAR. REPAIRED SEAT RAILS IAW DHC SERVICE BULLETIN 8-53-53 AND RD8-53-2658. A/C RETURNED TO SERVICE. (M)SDR PCAA9700595Seat Track · wornCAPTAIN'S LEFT SEAT TRACK SHOWING WEAR. MAINTENANCE PERFORMED S/B 8-53-53 TO AIRCRAFT. AIRCRAFT RETURNED TO SERVICE. (M)SDR AALA972087Seat Track · corrodedTUL - SEAT TRACK 8A HAS CORROSION FROM FRAME 30 TO FRAME 33. REMOVED AND REPLACED SEAT TRACK 8A FROM FRAME 30 TO FRAME 33 PER SRM 51-72-10. (M)SDR AALA972086Seat Track · corrodedTUL - FRAME 33 BETWEEN SEAT TRACKS 2 AND 3 HAS CORROSION. REMOVED AND BLENDED OUT CORROSION PER SRM 51-74-10-2 AND REPAIRED PER ESO 368813. (M)SDR AALA972084Seat Track · corrodedTUL - SEAT TRACK (BEAM) 2A AT FRAME 30, BARREL NUT HOLE CORRODED AND CORROSION ON TRACK. REMOVED AND BLENDED OUT CORROSION PER SRM 51-74-10-2. REPLACED 2A SEAT TRACK PER SRM 51-72-10-0. (M)SDR AALA972091Seat Track · corrodedTUL - SEAT TRACK 9 HAS CORROSION FROM FRAME 26 TO FRAME 29. REMOVED AND REPLACED NR 9 SEAT TRACK FROM FRAME 26 TO FRAME 30 PER SRM 51-72-10-0. (M)SDR AALA972076Seat Track · corrodedTUL - SEAT TRACK 10 HAS CORROSION FROM FRAME 26 TO FRAME 30. REPLACED SEAT TRACK NR 10 FROM FRAME 26 TO FRAME 30 REF 51-72-10-0 SRM. (M)SDR AALA972074Seat Track · corrodedTUL - FOUND SEAT TRACK NR 8 HAS NUMEROUS AREAS OF CORROSION FRAME FRAME 26 TO FRAME 33. INSTALLED NEW SEAT TRACK FROM FRAME 28 TO 33.5 PER SRM 51-72-10-0. (M)SDR AALA972073Seat Track · corrodedTUL - SEAT TRACK NR 8 FROM FRAME 25-26 CORRODED INBOARD FLANGE. REPAIRED SEAT TRACK NR 8 BETWEEN FRAME 25/26 PER ESO 30595, DATED 10-28-97. (M)SDR AALA971871Seat Track · corrodedTUL - FOUND CORROSION ON SEAT TRACK NR 4 FORWARD OF STATION 879. REMOVED AND REPLACED NR 4 SEAT TRACK FROM STATION 837 TO 879 IAW SRM 53-70-00. (M)SDR SIMA973021Seat Track · corrodedSAW - DURING CPCP-4 INSPECTION MAINTENANCE DISCOVERED, THE RIGHT AND LEFT FLIGHT ATTENDANT SEAT TRACKS CORRODED OUT OF LIMITS. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACKS IAW SRM 51-25-04 AND 51-21-27. AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR AALA972053Seat Track · corrodedTUL - TRACK IS CORRODED BETWEEN FRAME 13 AND 14. MANUFACTURED REPAIR STRAP AND INSTALLED PER AARD 53-20-00-00-2 PAGE 1 AND 2. (M)SDR SIMA973015Seat Track · corrodedSAW - DURING CPCP-4 INSPECTION MAINTENANCE DISCOVERED THE FOLLOWING SEAT TRACKS CORRODED OUT OF LIMITS, LEFT AND RIGHT FLIGHT ATTENDANT. MAINTENANCE REMOVED AND REPLACED SEAT TRACKS IAW SRM 51-25-04. AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR SIMA973014Seat Track · corrodedSAW - DURING CPCP-4 INSPECTION MAINTENANCE DISCOVERED THE FOLLOWING SEAT TRACKS CORRODED OUT OF LIMITS, RIGHT AFT OUTBOARD, RT AFT INBOARD, LEFT AFT INBOARD, LEFT AFT OUTBOARD. MAINTENANCE REMOVED AND REPLACED SEAT TRACKS IAW SRM 51-25-04. AIRCRAFT WAS RETURSDR AALA972075Seat Track · corrodedTUL - SEAT TRACK NR 3 HAS CORROSION FROM FRAME 30 TO FRAME 31. REMOVED AND REPLACED SEAT TRACK NR 3 PER SRM 51-72-10-0. (M)SDR 97ZZZM1189Seat Track · corrodedDURING C-CHECK, FOUND MAIN CABIN FS 344 LEFT, OUTBOARD SEAT TRACK, INBOARD FLANGE HAS IG CORROSION. REMOVED SEAT TRACK SECTION FROM FS 344-360, FABRICATED, DRILLED UP, DEBURRED, ALODINED, AND PRIMED NEW SEAT TRACK. INSTALLED NEW SEAT TRACK IAW 737 SRM 53-10-SDR 97ZZZM1161Seat Track · corrodedSAW - DURING CPCP-4 INSPECTION MAINTENANCE DISCOVERED THE FOLLOWING SEAT TRACKS CORRODED OUT OF LIMITS, RIGHT AFT OUTBOARD, RT AFT INBOARD, LEFT AFT INBOARD, LEFT AFT OUTBOARD. MAINTENANCE REMOVED AND REPLACED SEAT TRACKS IAW SRM 51-25-04. AIRCRAFT WAS RETURSDR 97ZZZM1160Seat Track · corrodedSAW - DURING CPCP-4 INSPECTION MAINTENANCE DISCOVERED THE FOLLOWING SEAT TRACKS CORRODED OUT OF LIMITS, RIGHT AFT OUTBOARD, RT AFT INBOARD, LEFT AFT INBOARD, LEFT AFT OUTBOARD. MAINTENANCE REMOVED AND REPLACED SEAT TRACKS IAW SRM 51-25-04. AIRCRAFT WAS RETURSDR DHL9780227CSeat Track · wornAT C-CHECK, FUSELAGE STATION 600 LINE 2 FLOOR TRACK WORN. CUT OUT DAMAGED SECTION FROM 560 TO 610, INSTALLED NEW SECTION OF SEAT TRACK PER SRM 53-2-3.SDR AALA972058Seat Track · corrodedTUL - SEAT TRACK NR 6 AT FRAME 14-15 IS CORRODED. REMOVED CORROSION AND BLENDED REF SRM 51-74-10-2. INSTALLED STRAP ON NR 6 SEAT TRACK FROM FRAME 14 AND 15 PER AA 53-20-00-2. (M)SDR AALA972019Seat Track · corrodedTUL - SEAT TRACK NR 2 CORRODED AFT OF FRAME 73. REPLACED SEAT TRACK NR 2 PER SRM 51-72-10-0. (M)SDR 97ZZZM1186Seat Track · corrodedDURING C-CHECK, FOUND MAIN CABIN CORROSION ON SEAT TRACK FLANGE LBL 21 FS 344-360. REMOVED SEAT TRACK SECTION FS 344-360 LBL 21. FABRICATED, DRILLED, DEBURRED, ALODINED, AND PRIMED SEW SEAT SECTION. INSTALLED NEW SEAT TRACK SECTION FS 344-360 IAW 737 SRM 53SDR WRLA97128Seat Track · corrodedDURING SCHEDULED MAINTENANCE (B-CHECK), MAINTENANCE CONTRACTOR IDENTIFIED CORROSION ON THE AFT FUSELAGE SEAT TRACK, AT STA 1887 - STA 2007, LEFT, OUTBOARD. MAINTENANCE CONTRACTOR REPLACED CORRODED SEAT TRACK PER SRM 51-31-01. AIRCRAFT RETURNED TO SERVICE. (SDR WRLA97119Seat Track · corrodedDURING SCHEDULED MAINTENANCE (B-CHECK), MAINTENANCE CONTRACTOR IDENTIFIED CORROSION ON THE AFT FUSELAGE SEAT TRACK AT STA 1887, LBL 60. MAINTENANCE CONTRACTOR REPLACED CORRODED SEAT TRACK PER SRM 51-33-01. AIRCRAFT RETURNED TO SERVICE. (X)SDR UPS97224770Seat Track · corrodedINSPECTION TYPE-SI, CORROSION ON SEAT TRACK FLANGE AT BS 562 LBL 65. FOUND CORROSION TO BE OUT OF LIMITS PER SRM 53-10-1. REMOVED AND REPLACED SEAT TRACK FROM BS 540 TO 580 LBL 65 WL 208.SDR UPS97224759Seat Track · corrodedINSPECTION TYPE:SI CORROSION UNDER NUT PLATES AT STA 458 TO 500 WL 208 LBL 65. REMOVED AND REPLACED SEAT TRACK STA 445-500 LBL 65 WL 208 IAW SRM 51-30-2, 51-30-5, 53-10-5, 51-30-8 CORROSION REWORK OUT OF LIMITS IAW SRM 53-10-1.SDR ABXA9701741Seat Track · corrosionSTA 980 TO 1000 LBL 44.5 BOTH SEAT TRACK ENDS HAVE HEAVY CORROSION. REPLACED SEAT TRACK FROM STA 970 TO 1030 LBL 44.5 IAW DC-8 53-2-3, FIGURE 14.SDR ABXA9701731Seat Track · corrosionSTA 580 - 600 RBL 44.5, THE SEAT TRACK IS CORRODED ON BOTH ENDS. REPLACED SEAT TRACK FROM FS 550 TO FS 620 RBL 44 IAW DC-8 SRM 53-2-3.SDR UPS97224734Seat Track · corrodedINSPECTION TYPE-SI, CORROSION ON SEAT TRACK SEGMENT BETWEEN BS 1130 TO 1134 LBL 64 WL 208 CORROSION OUT OF LIMITS IAW SRM 53-10-1. REMOVED AND REPLACED SEAT TRACK SEGMENT IAW SRM 51-30-2, 51-30-8.SDR IXXA9700153Seat Track · crackedDURING ROUTINE C-CHECK INSPECTION, FOUND SEAT TRACK TO BE CRACKED IN MAIN CARGO COMPARTMENT BETWEEN FUSELAGE STATIONS 240 AND 247, BUTT LINE X-25. REPAIR ACCOMPLISHED REMOVAL OF DAMAGED TRACK, FABRICATION AND INSTALLATION OF NEW SEAT TRACK PLUG IN ACCORDANCESDR UPS97224735Seat Track · corrodedINSPECTION TYPE-SI, CORROSION UNDER NUT PLATE AT STA 579 LBL 25 WL 208. CORROSION REWORK OUT OF LIMITS IAW SRM 53-10-1. REMOVED AND REPLACED SEAT TRACK FROM STA 480 TO 580 LBL 25 WL 208 IAW SRM 51-30-5, 51-30-2, 53-10-5.SDR UPS97824910Seat Track · corrodedINSPECTION TYPE-C, SEAT TRACK LWR FLANGE CORRODED BEYOND LIMITS FS 703 RBL 58. REMOVED, FABRICATED, AND INSTALLED REPLACEMENT SECTION OF TRACK IAW SRM ADDN DC8-5320-5167C.SDR UPS97824893Seat Track · corrodedINSPECTION TYPE-C, SEAT TRACK AT LBL 24 FS 855 EXFOLIATED. REMOVED, FABRICATED AND INSTALLED SUPPORT ANGLE IAW SRM 53-7-3, 51-1-21 AND 51-3-0.SDR UPS97824797Seat Track · corrodedINSPECTION TYPE:C SEAT TRACK AT BL-0 F/S 825 HAS HEAVY EXFOLIATED CORROSION. REMOVED, FABRICATED, AND INSTALLED REPLACEMENT SECTION OF TRACK IAW SRM 53-2-3.SDR UPS97824895Seat Track · corrodedINSPECTION TYPE-C, MAIN CABIN FS 1470 LBL 44 - THE SEAT TRACK HAS HEAVY CORROSION. REMOVED, FABRICATED AND INSTALLED REPLACEMENT SECTION OF TRACK IAW SRM ADDN DC8-5320-8309.SDR UPS97824822Seat Track · corrodedINSPECTION TYPE-C, MAIN CABIN AT STA 440, RBL 44 - THE SEAT TRACK HAS HEAVY CORROSION. REMOVED, FABRICATED AND INSTALLED REPLACEMENT SECTION OF TRACK IAW SRM ADDN DC8-5320-8309A.SDR UPS97824796Seat Track · corrodedINSPECTION TYPE:C MAIN CABIN AT F/S 594, LBL 44 TO 48. THE SEAT TRACK HAS SEVERE CORROSION. REMOVED, FABRICATED, AND INSTALLED REPLACEMENT SECTION OF TRACK IAW UPS E.O. DC8-5320-8309A.SDR COMA9710429Seat Tracks · corrodedDURING 4C INSPECTION MRB TASK 5320-151-01I, REVEALED MODERATE CORROSION AROUND SCREW HEAD ON THE PAX SEAT TRACKS. REMOVED CORRODED SEAT TRACKS AND INSTALLED SERVICEABLE SEAT TRACKS USING MASTINOX ON ALL SCREWS. ALL DONE IAW AERODESIGN REPORT NR 2141-1.SDR AALA974053Seat Track · corrodedAFW - FOUND AND BLENDED TWO AREAS OF CORROSION ON THE UPPER SURFACE OF THE UPPER FLANGE AT THE SEAT TRACK. REFINISHED THE BLENDOUTS PER SRM 53-00-52 FIG 101. APPROVED FOR CONTINUED SERVICE WITH NOTED CONDITION BY ENGINEERING PER MRB 767-1495. (M)
Back to JASC 5347