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 97ZZZX2491Track · corrodedFWD GALLEY NR 1 INBD SEAT TRACK CORRODED. INSTALLED SEAT TRACK IAW 727 SRM 51-30-2.SDR UPS97823153Seat Track · wornINSPECTION TYPE:C, F/S 322 TO 327 BL 0 SEAT TRACK IS WORN BEYOND LIMITS IN 2 PLACES. FABRICATED AND INSTALLED REPAIR IAW SRM 51-3-0 AND DC8-5320-5167.SDR DHL9770148CSeat Track · corrodedDURING C-CHECK, CORROSION AT CABIN SEAT TRACK NR 2, BS 758 TO 762. CUT OUT DAMAGED AREA PER AVITAS ENGINEERING DRAWINGS NR 97PMSI152D-1. REPAIR SIZE 4 BY 1.250. INSTALLED REPAIR AT CABIN SEAT TRACK BEAM SUPPORT NR 2, BS 760, LBL 45.5 PER AVITAS ENGINEERING SDR ABXA9700976Seat Track · corrodedDURING C-CHECK, FOUND SEAT TRACK CORRODED AT F/STA 200 RBL 44. REPLACED SEAT TRACK IAW DC9 SRM 51-30-1, 51-30-5, AND 51-30-4.SDR MWEA97359Seat Track · corrosionDURING D-CHECK, STA 200 TO 237 NR 2 SEAT TRACK LWR SURF UP FLANG CORRODED. MAINT REPAIRED IAW SRM 53-05 FIG 4D AND INSTALLED IAW SRM 51-30.SDR SCNA97154Seat Track · corrodedDURING HEAVY MAINTENANCE VISIT, SEAT TRACK WAS FOUND CORRODED AND GOUGED FROM STATIONS 740.00 TO 757.45, LBL 45.50. REMOVED AND INSTALLED NEW SEAT TRACK IAW B727 SRM 53-10-1, 51-10-2, AND MAINTENANCE MANUAL 51-20-11.SDR SCNA97149Seat Track · corrodedDURING HEAVY MAINTENANCE VISIT, SEAT TRACK WAS FOUND CORRODED AND GOUGED FROM STATIONS 852.45 TO 868.45, RBL 45.5. REMOVED AND INSTALLED NEW SEAT TRACK IAW B727 SRM 53-10-1, 51-10-2, AND MAINTENANCE MANUAL 51-20-11.SDR SCNA97148Seat Track · corrodedDURING HEAVY MAINTENANCE VISIT, SEAT TRACK WAS FOUND CORRODED AND GOUGED FROM STATIONS 757.45 TO 852.45, LBL 45.5. REMOVED AND INSTALLED NEW SEAT TRACK IAW B727 SRM 51-30-2.SDR SWIA97948Seat Track · corrodedFORWARD SEAT TRACKS AT AISLE LEFT AND RIGHT HAVE CORROSION AT FORWARD END. REMOVED CORROSION IAW SRM 51-21-00 AND TESTED BY PRESSURE AND PAINTED BOTTOMS OF TRACKS.SDR SCNA97202Seat Track · corrodedDURING HEAVY MAINTENANCE VISIT, SEAT TRACK WAS FOUND CORRODED AND GOUGED FROM STATIONS 740.00 TO 757.45, RBL 24.75 AND RBL 45.5. REMOVED, FABRICATED AND INSTALLED NEW SEAT TRACK IAW B727 SRM 51-20-2, 53-10-5, AND 51-30-2.SDR SCNA97188Seat Track · corrodedDURING HEAVY MAINTENANCE VISIT, SEAT TRACK AT STATIONS 689.45 TO 740, 757.45 TO 852.45 AND 959.45 TO 1130.00, RBL 24.75 WAS FOUND CORRODED AND GOUGED. REMOVED, FABRICATED AND INSTALLED SEAT TRACK IAW B727 SRM 53-10-5, 51-30-2, AND 51-10-2.SDR SCNA97185Seat Track · corrodedDURING HEAVY MAINTENANCE VISIT, CORROSION AND GOUGES WERE FOUND ON SEAT TRACK STATION 852 TO 870, LEFT OUTBOARD. REMOVED, FABRICATED AND INSTALLED SEAT TRACK IAW B727 SRM 53-10-5, 51-30-2, AND 51-10-2.SDR SCNA97184Seat Track · corrodedDURING HEAVY MAINTENANCE VISI, CORROSION AND GOUGES WERE FOUND ON SEAT TRACK STATION 480 TO 689.45, RBL 22.09. REMOVED, FABRICATED AND INSTALLED SEAT TRACK IAW B727 SRM 53-10-5, 51-30-2, AND 51-10-2.SDR SCNA97183Seat Track · corrodedDURING HEAVY MAINTENANCE VISIT, CORROSION AND GOUGES WERE FOUND ON SEAT TRACK STATION 959.45 TO 1070.00, LBL 45.50. REMOVED, FABRICATED AND INSTALLED SEAT TRACK IAW B727 SRM 53-10-5, 51-30-2, AND 51-10-2.SDR SCNA97182Seat Track · corrodedDURING HEAVY MAINTENANCE VISIT, CORROSION AND GOUGES WERE FOUND ON SEAT TRACK STATION 344 TO 480, RBL 22.09. REMOVED, FABRICATED AND INSTALLED SEAT TRACK IAW B727 SRM 53-10-5, 51-30-2, AND 51-10-2.SDR SCNA97181Seat Track · corrodedDURING HEAVY MAINTENANCE VISIT, CORROSION AND GOUGES WERE FOUND ON SEAT TRACK STATION 344 TO 480, RBL 42.8. REMOVED, FABRICATED AND INSTALLED SEAT TRACK IAW B727 SRM 53-10-5, 51-30-2, AND 51-10-2.SDR SCNA97157Seat Track · corrodedDURING HEAVY MAINTENANCE VISIT, SEAT TRACK WAS FOUND CORRODED AND GOUGED FROM STATIONS 740.00 TO 757.45, LBL 24.75. REMOVED AND INSTALLED NEW SEAT TRACK IAW B727 SRM 51-30-2.SDR SCNA97156Seat Track · corrodedDURING HEAVY MAINTENANCE VISIT, SEAT TRACK WAS FOUND CORRODED AND GOUGED FROM STATIONS 480.00 TO 689.45, LBL 22.09. REMOVED, FABRICATED, AND INSTALLED NEW SEAT TRACK IAW B727 SRM 51-30-2, 53-10-5, AND 51-10-1.SDR SCNA97155Seat Track · corrodedDURING HEAVY MAINTENANCE VISIT, SEAT TRACK WAS FOUND CORRODED AND GOUGED FROM STATIONS 740.00 TO 757.45, LBL 24.75. REMOVED AND INSTALLED NEW SEAT TRACK IAW B727 51-30-2.SDR SCNA97153Seat Track · corrodedDURING HEAVY MAINTENANCE VISIT, SEAT TRACK WAS FOUND CORRODED AND GOUGED FROM STATIONS 689.45 TO 740.00, LBL 24.75. REMOVED AND INSTALLED NEW SEAT TRACK IAW B727 SRM 53-10-5, 51-10-1, AND 51-30-2.SDR SCNA97152Seat Track · corrodedDURING HEAVY MAINTENANCE VISIT, SEAT TRACK WAS FOUND CORRODED AND GOUGED FROM STATIONS 868.45 TO 959.45, LBL 24.75. REMOVED AND INSTALLED NEW SEAT TRACK IAW B727 SRM 53-10-5, 51-10-1, AND 51-30-2.SDR SCNA97151Seat Track · corrodedDURING HEAVY MAINTENANCE VISIT, SEAT TRACK WAS FOUND CORRODED AND GOUGED FROM STATIONS 959.45 TO 1070.00, RBL 24.75. REMOVED AND INSTALLED NEW SEAT TRACK IAW B727 SRM 53-10-1, 51-10-2, AND 51-30-2.SDR SCNA97150Seat Track · corrodedDURING HEAVY MAINTENANCE VISIT, SEAT TRACK WAS FOUND CORRODED AND GOUGED FROM STATIONS 620.00 AND 689.45 AND FROM 852.45 TO 959.45, RBL 24.75. REMOVED AND INSTALLED NEW SEAT TRACK IAW B727 SRM 53-10-1, 51-10-2, AND MAINTENANCE MANUAL 51-20-11.SDR DHL9780120CSeat Track · wornAT C-CHECK, SEAT TRACK WORN AT FS 260 , LT NR 2. REMOVED DAMAGED SECTION (80.5) AND INSTALLED NEW TRACK PER SRM 51-3-0.SDR DHL9780119CSeat Track · wornAT C-CHECK, SEAT TRACK WORN AT STA 280 NR 2 WORN. REMOVED DAMAGED SECTION FROM STA 230 TO 310 (80.5) . INSTALLED TRACK PER SRM 53-2-3.SDR DHL9770132CSeat Track · corrodedDURING C-CHECK, CORROSION ON UNDERSIDE OF INBOARD FLANGE OF SEAT TRACK LBL 45 BS 560 TO 640. INSTALLED NEW TRACK LBL 45 FROM BS 480 TO 590 PER SRM 53-10-5, SPLICE 17 LONG. REMOVED LIGHT CORROSION ON UNDERSIDE OF INBOARD FLANGE TRACK LBL 45 FROM BS 590 TO 670SDR DHL9770131CSeat Track · corrodedDURING C-CHECK, CORROSION ON UNDERSIDE OF INBOARD AND OUTBOARD SIDE OF SEAT TRACK, LBL 45, BS 480 TO 560. REMOVED SECTION OF TRACK FROM BS 480 TO 590, LBL 45 PER SRM 51-30-2. INSTALLED NEW SECTION OF TRACK PER SRM 51-30-2. SPLICE LENGTH 17, N/R 3631.SDR AALA970873Seat Track · corrodedAFW - SEAT TRACK AT STA 377, LBL 45, HAS CORROSION REMOVAL MATERIAL REMAINING BEYOND SRMS LIMITS. REF E 58 NR 1697043. TST: 15,516.36 HOURS. CYCLES: 5,712. (X)SDR ORJA9786Seat Track · corrodedCORROSION ON LEFT SEAT TRACK X-44, BS 1136. REMOVED CORROSION TRACK CUT NEW TRACK AND INSTALLED IAW 51-10-2 AND 51-30-1. (M)SDR ORJA9785Seat Track · corrodedSEAT TRACK X-22L CORRODED AT FS 1155. REMOVED CORRODED SEAT TRACK AND INSTALLED NEW SEAT TRACK IAW MD-80 SRM 53-05, PAGE 10G FIG 4F AND 53-05, FIG 4 SHEET 1. (M)SDR C2XA97IA150Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, RT INBD SEAT TRACK WAS FOUND CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED PORTION OF SEAT TRACK IAW CONTINENTAL EXPRESS ENGINEERING CHANGE/ REPAIR AUTHORIZATION EC5340-01019. THE AIRCRAFT WAS THEN APPROVED FOR RETUSDR DHL9780130CSeat Track · corrodedAT C-CHECK, EXFOLIATED CORROSION ON CABIN FLOOR PANEL STA 240 C/L. REMOVED DAMAGED SECTION OF SEAT TRACK FROM STA 230 TO 290. INSTALLED REPAIR AND SEAT TRACK PER SRM 53-2-3.SDR DHL9780118CSeat Track · wornAT C-CHECK, AT FS 280 NR 1 SEAT TRACK WORN. CUT OUT SEAT TRACK AND REINSTALLED PER SRM 53-2-0.SDR DHL9770140CSeat Track · corrodedDURING C-CHECK, CORROSION AT FLOOR TRACK RBL 62, BS 1130. CUT OUT DAMAGED SECTION OF SEAT TRACK RBL 62 FROM BS 1130 TO 1000. CORROSION WAS BEYOND LIMITS PER SRM 53-10-1 AND 53-10-5 FIG 1. INSTALLED NEW SEAT TRACK PER SRM 53-10-5 FIG 1. LENGTH OF SPLICE 17, SDR DHL9770135CSeat Track · corrodedDURING C-CHECK, CORROSION ON CABIN SEAT TRACK, BS 1110 TO 1130, RT OUTBOARD. REMOVED FASTENERS AND CUT OUT DAMAGED SECTION OF SEAT TRACK BS 1110 TO 1130 PER SRM 53-10-5 FIG 7. INSTALLED NEW SEAT TRACK PER SRM 53-10-5 FIG 7, N/R5055.SDR 97ZZZX2342Seat Rail · corrodedRIGHT OUTBOARD SEAT TRACK SEVERELY CORRODED UNDER LIP OF TRACK. SUSPECT CAUSE OF CORROSION WAS TRAPPED WATER IN THE CARPET FROM ENTRY INTO AIRCRAFT. ALSO, CARPET WAS NOT OF AIRCRAFT QUALITY OR TYPE (HOME SHAG CARPET). TO PREVENT RECURRENCE OF CORROSION, INSSDR DHL9770138CSeat Track · corrodedDURING C-CHECK, CORROSION FOUND ON CABIN SEAT TRACK FROM BS 870 TO 1010 NR 7. REMOVED SEAT TRACK FROM BS 870 TO 1020 PER SRM 51-30-2 DUE TO CORROSION BEYOND LIMITS. INSTALLED NEW SEAT TRACK FROM BS 870 TO 1020 PER SRM 53-10-5 FIG 1. SPLICE LENGTH 17, N/R510SDR DHL9770137CSeat Track · corrodedDURING C-CHECK, CORROSION WAS FOUND ON CABIN SEAT TRACK NR 7, OUTBOARD FLANGE BS 900 TO 920. REMOVED SEAT TRACK NR 7 FROM BS 870 TO 1020 PER SRM 51-30-2, CORROSION BEYOND LIMITS PER SRM 53-10-1. REPLACED SEAT TRACK FROM BS 870 TO 1020, NR 7 TRACK PER SRM 53-SDR DHL9770136CSeat Track · corrodedDURING C-CHECK, CORROSION FOUND ON CABIN SEAT TRACK NR 7 BS 910 TO 940. REMOVED SEAT TRACK NR 7 FROM BS 870 TO 1020 PER SRM 51-30-2, CORROSION BEYOND LIMITS PER SRM 53-10-1. INSTALLED NEW SEAT TRACK FROM BS 870 TO 1020 PER 53-10-5 FIG 1 AND 51-30-2. LENGTH SDR DHL9770126CSeat Track · corrodedDURING C-CHECK, OUTBOARD FLANGE OF SEAT TRACK HAS HEAVY CORROSION AT BS 360 TO 380, LBL 65 STRAP ON TOP OF SEAT TRACK FLANGE. REMOVED SECTION OF SEAT TRACK AND INSTALLED NEW SECTION OF TRACK FROM BS 360 TO 380, LBL 65, N/R 3617.SDR AWXA9700298Seat Track · corrodedDURING ROUTINE MAINTENANCE CHECK, FOUND CORROSION ON SEAT TRACK RBL 45, STA 338 TO 340, WL 208. REMOVED AND REPLACED SEAT TRACK RBL 45, STA 338 TO 340 PER SRM 53-00-52.SDR AWXA9700297Seat Track · corrodedDURING ROUTINE MAINTENANCE CHECK, FOUND CORROSION ON SEAT TRACK RBL 25, STA 335 TO 340, WL 208. FABRICATED REPAIR PARTS AND INSTALLED AT BS 328 TO BS 380, RBL 25, WL 208 PER SRM 53-00-52.SDR AWXA9700296Seat Track · corrodedDURING ROUTINE MAINTENANCE CHECK, FOUND CORROSION ON SEAT TRACK FLANGE STA 329, RBL 50, WL 208. FABRICATED AND INSTALLED SEAT TRACK PER SRM 51-40-02.SDR AALA970827Seat Track · corrodedTUL - DUE TO EXCESSIVE CORROSION ON ENTIRE LENGTH OF SEAT TRACK, REPLACEMENT WAS NECESSARY. REPLACED ENTIRE LENGTH OF NR 6 TRACK PER SRM 51. 42,301 HOURS. CYCLES, 23,692. (X)SDR AALA970826Seat Track · corrodedTUL - NR 8 SEAT TRACK CORRODED AROUND FLOORBOARD ATTACHMENT HOLES. REMOVED CORROSION AND REPAIRED DAMAGED AREA PER ESO 7349 4-24-97. TST: 59,206.24 HOURS. CYCLES: 20,343. (X)SDR F3LA97118Cargo Track · corrodedPAE - WHILE WORKING FUSELAGE 00069, FOUND CORROSION ON AFT CARGO BAY CARGO TRACK BS 771 - BS 867, RBL 15. REMOVED AND REPLACED AFT CARGO TRACK AT BS 771 - BS 867, RBL 15 PER SRM 53-10-3, SRM 51-30-2. (X)SDR UPS97823099Seat Track · corrodedINSPECTION TYPE:D, SEAT TRACK CORRODED FROM F/S 1548 TO 1560 BL 0. REMOVED, FABRICATED AND INSTALLED REPAIR PARTS FROM F/S 1530 TO 1610 IAW SRM 51-1-20D, 51-3-0, AND DC8-5320-5167C.SDR SCNA97099Seat Track · corrodedDURING HEAVY MAINTENANCE, FOUND FLANGE CORRODED ON SEAT TRACK AT BS 1070 TO 1130, LBL 49. REMOVED AND INSTALLED NEW SEAT TRACK IAW B727 SRM 51-30-02 AND 53-10-02.SDR DHL97717003Seat Track · wornPALLET LOCK IS LOOSE AND WILL NOT STAY IN SEAT TRACK, DEFERRED POSITION. REMOVED SECTION OF SEAT TRACK AND REPLACED PER SRM 53-10-5, REINSTALLED PALLET LOCK, SECTION 6 FT 8.SDR SCNA97098Seat Track · corrodedDURING HEAVY MAINTENANCE, FOUND PITTING CORROSION ON SEAT TRACK FLANGE FROM BS 1070 TO 1130, LBL 56. REMOVED SEAT TRACK, DRILLED NEW SEAT TRACK, AND INSTALLED IAW B727 53-10-05, 51-30-02, AND 53-10-03.
Back to JASC 5347