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 UPS99830059Seat Track · corrodedINSPECTION TYPE:C2 FS 789 TO 834, RBL 60, THE SEAT TRACK HAS HEAVY CORROSION. CUT OUT DAMAGED SEAT TRACK FROM FS 750 TO 842, FABRICATED AND INSTALLED IAW SRM 53-2-3 AND EO DC8-5320-5167C.SDR UPS99529980Seat Track · corrodedINSPECTION TYPE:C, MAIN DECK SEAT TRACK ON EXPANSION LINK HAS CORROSION ON TOP SURFACE LT FLANGE LBL 46, BS 892 AND BS 895. CORROSION FOUND TO BE OUT OF LIMITS. REMOVED OLD SEAT TRACK AND INSTALLED NEW SEAT TRACK AT EXPANSION LINK BS 880 TO BS 900 IAW SRM 53SDR AT9900590Cargo Track · corrodedDURING A ROUTINE INSPECTION AT TIMCO LAKE CITY FL, FOUND RT FWD CARGO PIT TRACK AT BS 560-588 CORRODED. DRILLED AND COUNTERSUNK NEW TRACK IAW DC9 SRM 51-10-4.SDR UPS99830058Seat Track · corrodedINSPECTION TYPE:C2 FS 50 TO 70, RBL 48, THE SEAT TRACK HAS HEAVY CORROSION AROUND THE CLIPNUTS. CUT OUT DAMAGED AREA FROM FS 50 TO 100, FABRICATED REPLACEMENT TRACK AND INSTALLED IAW SRM 53-2-3 FIG 14.SDR UPS99229874Seat Track · corrodedINSPECTION TYPE:SI, CORROSION ON SEAT TRACK FLANGE BS 630 TO BS 638 RBL 45. REPLACED PER SRM 51-10-1.SDR UPS99229873Seat Track · corrodedINSPECTION TYPE:SI, CORROSION ON SEAT TRACK FLANGE BS 705 TO BS 708 RBL 95 WL 208. REPLACED TRACK PER SRM 51-10-1.SDR CALA9900707Seat Track · corrodedINSPECTION FOUND LT O/B SEAT TRACK CORRODED UNDER GALLEY AREAS NR 3 AND NR 4 AT STA 1030-1305. THE CORRODED SECTION OF SEAT TRACK WAS REMOVED AND A NEW SECTION OF SEAT TRACK WAS INSTALLED IAW SRM 51-30-2 AND 51-30-5.SDR 99ZZZX2920Seat Track · corrodedDURING A C-CHECK, CORROSION WAS NOTED ON RIGHT INBOARD SEAT TRACK FORWARD OF BS 460.SDR 99ZZZX2919Seat Track · corrodedDURING A C-CHECK, CORROSION WAS NOTED ON RIGHT INBOARD SEAT TRACK, BS 1070.SDR 99ZZZX2913Seat Track · corrodedDURING A C-CHECK, CORROSION WAS NOTED ON SEAT TRACK RT CENTER BS 344 - BS 460. (ALSO ON LT INBOARD).SDR 99ZZZX2912Seat Track · corrodedDURING A C-CHECK, CORROSION WAS NOTED ON SEAT TRACK BS 1070- BS 1130 LBL 48 AND LBL 25.SDR CALA9900700Seat Track · corrodedINSPECTION FOUND RT O/B SEAT TRACK CORRODED AT STA 200-250. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 53-01, FIGURE 4, SHEET 1.SDR C2XA99IA391Seat Track · corrodedDURING CONTINENTAL EXPRESS C-CHECK, FOUND CARGO BAY LT SEAT RAIL CORRODED FROM FRAMES 39 TO 41. REMOVED AND REPLACED SEAT TRACK IAW SRM 51-25-05. AIRCRAFT APPROVED FOR RETURN TO SERVICE. TAT: 23,946.4 HOURS. TAC: 27,645. (X)SDR USAA990587Seat Track · corrodedCLT - DURING C-4 CHECK VISUAL INSPECTION, FOUND CORROSION ON END OF SEAT TRACK STATION 377.7 AT LBBL 45.5, CORROSION LEVEL 2. INSTALLED NEW SEAT TRACK PER SRM 51-40-02. (M)SDR UPS99229875Seat Track · corrodedINSPECTION TYPE:SI, CORROSION ON SEAT TRACK FLANGE BS 690 LBL 45, WL 208. REMOVED AND REPLACED SEAT TRACK PER SRM 53-10-5 PG 4.SDR CALA9900686Seat Track · corrodedINSPECTION FOUND THE LEFT O/B SEAT TRACK CORRODED FROM STA 1174-1202, LBL 48. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 51-30-1 AND 53-05-04.SDR CALA9900685Seat Track · corrodedINSPECTION FOUND LEFT CENTER SEAT TRACK CORRODED FROM STA 1200-1215, LBL 24. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 51-30-1.SDR CALA9900684Seat Track · corrodedINSPECTION FOUND THE LEFT I/B SEAT TRACK CORRODED FROM STA 1117-1136, LBL 24. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 53-30-2.SDR CALA9900683Seat Track · corrodedINSPECTION FOUND THE RIGHT O/B SEAT TRACK CORRODED IN TWO PLACES AT STA 210 & 229, RBL 48. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 51-30-1 AND SRM 53-05, FIGURE 4A.SDR CALA9900682Seat Track · corrodedINSPECTION FOUND RIGHT I/B SEAT TRACK CORRODED IN TWO PLACES AT STA 210 AND 229, RBL 24. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 51-30-2 AND 53-05, FIGURE 4F.SDR AALA990893Seat Track · corrodedTUL - FOUND CORROSION ON SEAT TRACK AT STATION 58 LEFT. REMOVED AND REPLACED SEAT TRACK IN ACCORDANCE WITH SRM 51-72-10-0. (M)SDR CALA9900681Seat Track · corrodedINSPECTION FOUND LEFT I/B SEAT TRACK CORRODED FROM STA 1271-1300, LBL 24. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 51-30-1.SDR CALA9900680Seat Track · corrodedINSPECTION FOUND THE RIGHT O/B SEAT TRACK CORRODED FROM STA 598-760, RBL 48. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 53-05, FIGURE 4, VIEW E.SDR CALA9900679Cargo Track · corrodedINSPECTION FOUND AFT CARGO RT FRAME TRACK CORRODED AT FS 1022-1155, LONGERON 27R. THE CARGO TRACK WAS REMOVED AND REPLACED IAW SRM 53-24-0.SDR SIMA991651Seat Track · corrodedABI - DURING MBV INSPECTION, FOUND SEAT TRACK AT BL ZERO FROM STA 373.0 FWD TO THE END OF THE TRACK AT STA 297 CORRODED. REMOVED THE DAMAGED AREA. CUT SECTION OF REPAIR EXTRUSION, AND INSERTED U-BEAM INTO EXISITNG SEAT TRACK AND EXTRUSION. DRILLED REPAIR PISDR CALA9900671Seat Track · corrodedINSPECTION FOUND RIGHT I/B SEAT TRACK CORRODED AT STA 230. THE SEAT TRACK WAS REPLACED IAW SRM 51-30-1.SDR AALA990877unknownTUL - FOUND CORROSION ON SEAT TRACK AT STATION 65 RIGHT. REMOVED AND REPLACED PER SRM 51-74. (M)SDR AALA990876Seat Track · corrodedTUL - FOUND CORROSION ON SEAT TRACK AT STATION 49 RIGHT. REMOVED AND REPLACED SEAT TRACK PER SRM 51-74. (M)SDR AALA990869Track · corrodedTUL - LAV TIE DOWN TRACK CORRODED BETWEEN FRAME 73-74, LEFT INBOARD SHORT TRACK. TRACK WAS REPLACED PER SRM 51-72-10-0. (M)SDR AALA990868Seat Track · corrodedTUL - FOUND OUTBOARD SEAT TRACK FOR LAV 'Z' CORRODED. SEAT TRACK WAS REPLACED PER 51-72. (M)SDR HNAA9900079Seat Track · corrodedRT CENTER SEAT RAIL AT FS 134 HAS DRILL HOLE DAMAGE. A DRILL HOLE MEASURING .100 DEEP ON TOP FLANGE (APPROX) REMAINING MATERIAL THICKNESS .042- OUT OF LIMITS. REMOVED AND REPLACED SEAT RAIL AND SPLICE.SDR HNAA9900078Seat Track · corrodedRT CENTER SEAT RAIL AT FS 130.0 (APPROX) HAS PITTING CORROSION ON TOP FLANGE APPROX .015 DEEP. .010 ALLOWABLE - OUT OF LIMITS. REMOVED AND REPLACED RAIL AND SPLICE.SDR HNAA9900077Seat Track · corrodedRT CENTER SEAT RAIL HAS SEVERE PITTING CORROSION ON I/B WHICH HAS COMPLETELY CORRODED THROUGH THE METAL - OUT OF LIMITS. REMOVED AND REPLACED RAIL SECTION AND SPLICE.SDR AALA990936Seat Track · corrodedTUL - SEAT TRACK NR 2 HAS CORROSION, STATION 1300-1304. REPLACED SEAT TRACK SECTION FROM STATION 126 TO 1304 PER SRM 53-05. (M)SDR AALA990935Seat Track · corrodedTUL - NR 3 SEAT TRACK CORRODED STATION 1300-1304. INSTALLED NEW SEAT TRACK SECTION FROM STATION 1260 TO 1304 PER SRM 53-05. (M)SDR AT9900488Tie Down · corrodedSCHEDULED INSPECTION AT TIMCO LAKE CITY, FL. FOUND THE AFT CARGO TIE DOWN CLOSE OUT RING CORRODED AT BS 889. FABRICATED NEW CLOSE OUT RING IAW DC9 SRM 53-01 FIG 1 AND 51-10-4.SDR UPS99229844Seat Track · corrodedINSPECTION TYPE:SI, SEAT TRACK CORRODED AND DAMAGED TSS 1029 TO BS 1031 RBL 24 WL 208. AFTER REMOVAL OF CORROSION, FOUND THE SEAT TRACK TO GO BEYOND ALLOWABLE LIMITS PER SRM 53-10-1. FABRICATED NEW SEAT TRACK, ALODINED, PRIMED AND PAINTED AND INSTALLED SEAT SDR SIMA991622Seat Track · corrodedSAW - DURING MBV-2 INSPECTION, FOUND THE LEFT MIDDLE INBOARD, LEFT AFT OUTBOARD, AND THE RIGHT MIDDLE OUTBOARD SEAT TRACKS CORRODED. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACKS IAW EO E9-5300-013. AIRCRAFT RETURNED TO SERVICE. (M)SDR MZZA99140Seat Track · corrodedTNN - DURING D-CHECK INSPECTION ON AIRCRAFT AT AIR ASIA, A 1 INCH BY 4 INCH AREA IG CORROSION WAS FOUND ON PASSENGER FLOOR SEAT TRACK AT BS 395 AND RBL 40. THE CORRODED AREA WAS TRIMMED OUT AND REPAIRED PER B727 SRM CHAPTER 53-10-05 FIG 1. (M)SDR CALA9900665Seat Track · corrodedINSPECTION FOUND LEFT I/B SEAT TRACK CORRODED UNDER GALLEY AREAS NUMBER 3 AND 4 AT STA 1030-1305. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 53-05, FIGURE 4F.SDR 99ZZZM617Seat Track · corrodedSAW - DURING MBV-2 INSPECTION, FOUND THE LEFT MIDDLE INBOARD, LEFT AFT OUTBOARD, AND THE RIGHT MIDDLE OUTBOARD SEAT TRACKS CORRODED. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACKS IAW EO E9-5300-013. AIRCRAFT RETURNED TO SERVICE. (M)SDR 99ZZZM616Seat Track · corrodedSAW - DURING MBV-2 INSPECTION, FOUND THE LEFT MIDDLE INBOARD, LEFT AFT OUTBOARD, AND THE RIGHT MIDDLE OUTBOARD SEAT TRACKS CORRODED. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACKS IAW EO E9-5300-013. AIRCRAFT RETURNED TO SERVICE. (M)SDR RRXA991390Cargo Track · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION, FUSELAGE, AFT LOWER CARGO COMPARTMENT BETWEEN STA 980 AND STA 1100 TRACK. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED NEW TRACK IAW DC8 SRM 51-1SDR RRXA991389Cargo Track · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION, FUSELAGE, AFT LOWER CARGO COMPARTMENT BETWEEN STA 1020 AND STA 1140, FLOOR TRACK. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED NEW TRACK IAW DC8 SDR MZZA99133Seat Track · corrodedTNN - DURING D-CHECK INSPECTION ON AIRCRAFT AT AIR ASIA, A IG CORROSION WAS FOUND ON PASSENGER CABIN FLOOR SEAT TRACK BETWEEN BS 360/380 ALONG RBL 18. THE DAMGED AREA WAS TRIMMED OUT AND REPAIRED PER B727 SRM CHAPTER 53-10-05 FIG 1. (M)SDR MZZA99132Seat Track · corrodedTNN - DURING D-CHECK INSPECTON ON AIRCRAFT AT AIR ASIA, A 1 INCH BY 20 INCH AREA IG CORROSION WAS FOUND ON PASSENGER CABIN FLOOR SEAT TRACK BETWEEN BS 360 AND 380 ALONG RBL 22 AND RBL 24. THE DAMAGED AREA WAS TRIMMED OUT AND REPAIRED PER B727 SRM CHAPTER 53-1SDR UPS99829964Seat Track · corrodedINSPECTION TYPE:C-1, SEAT TRACK AT STA 870, BL O.O CORR DOT E560. REMOVED CORROSION IAW DC8 SRM 51-1-8 NOT WITHIN LIMITS IAW DC8 SRM 5 3-2-3. REMOVED DAMAGED SECTION OF TRACK STA 850-890 IAW DC8 SRM 53- 2-3. INSTALLED NEW TRACK SECTION IAW DC8 SRM 53-2-3.SDR CALA9900661Seat Track · corrodedINSPECTION FOUND SEAT TRACK CORRODED AT STA 1212, LBL 60. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 51-20-3.SDR DHL9970520CSeat Track · brokenAT C CHECK, NR 2 SEAT TRACK LOCK FLANGES BROKEN OFF AT STA 599 LBL 48. REMOVED SEAT TRACK FROM BS 530 TO 660. INSTALLED NEW TRACK PER SRM 53-10-5, N/R 5069.SDR DHL9970503CSeat Track · corrodedAT C CHECK, CENTER SEAT TRACK STA 600 CORRODED. REMOVED DAMAGED AREA AND INSTALLED TRACK FROM BS 550 TO 630 PER SRM 53-10-5. FABRICATED AND INSTALLED SPLICE AT BS 630 PER AVITAS EO 99AVHM033D1, N/R 5070.
Back to JASC 5347