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 CALA9900611Seat Track · corrodedINSPECTION FOUND LT SEAT TRACK CORRODED FROM STA 1866 TO 1856 AT POSITION X = 0.74L. THE SECTION OF SEAT TRACK WAS REPAIRED IAW SRM 53-70-00, FIGURE 6.SDR SIMA991521Seat Track · corrodedSAW - DURING CPCP-1 INSPECTION, FOUND THE RIGHT AFT INBOARD AND OUTBOARD, AND THE RIGHT FLIGHT ATTENDANT SEAT TRACK CORRODED. REMOVED AND REPLACED THE SEAT TRACK IAW EO E9-5300-013. AIRCRAFT RETURNED TO SERVICE. (M)SDR QXEA9901302Seat Track · gougedPDX - LEFT OUTBOARD SEAT TRACK HAS A .5 INCH LONG GOUGE 7 FORWARD OF FRAME 6805 ON INBOARD FLANGE. REPAIRED IAW HORIZON AIR EA 4-53-813.SDR QXEA9901262Seat Track · crackedPDX - RIGHT-HAND INBOARD PASSENGER SEAT TRACK HAS 2 SUPPORT RISERS AT THE INBOARD AND OUTBOARD FLANGES AT FRAME 4610 TIE IN TABS CRACKED, UNDERSIDE OF FLANGES. REPAIRED IAW FOKKER SRM 51-31-01, PAGE 13, PARAGRAPH 7A, STEPS 1-5.SDR QXEA9901134Seat Track · corrodedPDX - RIGHT INBOARD SEAT TRACK HAS A SMALL AREA OF FRETTING CORROSION ADJACENT TO FRAME 10966 ON INBOARD FLANGE. REPAIRED IAW FOKKER SRM 51-10-04 AND HORIZON AIR EA 4-53-813.SDR QXEA9901126Seat Track · corrodedPDX - RIGHT INBOARD SEAT TRACK HAS FRETTING CORROSION AROUND CAMLOC RECEPTACLE 2 AFT OF FRAME 11905. REPAIRED IAW FOKKER SRM 51-10-04, PAGE 8, PARAGRAPH 4 BAND HORIZON AIR EA 4-53-813SDR QXEA9901124Seat Track · corrodedPDX - LEFT INBOARD SEAT TRACK HAS CORROSION 5 FORWARD OF FRAME 7805 ON THE OUTBOARD FLANGE. REPAIRED IAW FOKKER SRM 51-10-04, PAGE 8, PARAGRAPH 3,C,4.SDR QXEA9901120Seat Track · corrodedPDX - LEFT INBOARD SEAT TRACK HAS CORROSION ON OUTBOARD FLANGE BETWEEN STATION 9550 AND 9700. REPAIRED IAW FOKKER SRM 51-10-04, PAGE 9, PARAGRAPH 4,A,1 AND HORIZON AIR EA 4-53-813.SDR MZZA99131Seat Track · corrodedTNN - DURING D-CHECK INSPECTION ON AIRCRAFT AT AIR ASIA, A IG CORROSION WAS FOUND ON BS 1130 AND LBL 46 SEAT TRACK. THE CORRODED AREA WAS TRIMMED OUT AND REPAIRED PER B727 SRM CHAPTER 55-10-05 FIG 1. (M)SDR CALA9900607Seat Track · corrodedINSPECTION FOUND RT SEAT TRACK CORRODED FROM STA 1876-1866 AT POSITION X = 0.60R AND X = 0.60L. THE SEAT TRACK SECTIONS WERE REPAIRED IAW SRM 53-70-00, FIGURE 6.SDR CALA9900606Seat Track · corrodedINSPECTION FOUND RT SEAT TRACK CORRODED FROM STA 1866 TO 1856 AT POSITION X = 0.74R. THE CORRODED SECTION FOR SEAT TRACK WAS REPLACED IAW SRM 53-70-00, FIGURE 6.SDR 99ZZZM374Seat Track · corrodedSAW - DURING CPCP-1 INSPECTION, FOUND THE RIGHT AFT INBOARD AND OUTBOARD, AND THE RIGHT FLIGHT ATTENDANT SEAT TRACK CORRODED. REMOVED AND REPLACED THE SEAT TRACK IAW EO E9-5300-013. AIRCRAFT RETURNED TO SERVICE. (M)SDR 99ZZZM373Seat Track · corrodedSAW - DURING CPCP-1 INSPECTION, FOUND THE RIGHT AFT INBOARD AND OUTBOARD, AND THE RIGHT FLIGHT ATTENDANT SEAT TRACK CORRODED. REMOVED AND REPLACED THE SEAT TRACK IAW EO E9-5300-013. AIRCRAFT RETURNED TO SERVICE. (M)SDR UPS99229785Seat Track · corrodedINSPECTION TYPE:SI, CORROSION ON SEAT TRACK FLANGE BS 444 TO BS 457 LBL 45. SEAT TRACK FLANGE FOUND TO BE OUT OF LIMITS IAW SRM 53-10-1. REMOVED DAMAGED SECTION OF SEAT TRACK, FABRICATED NEW SEAT TRACK PER SRM 53-10-5. INSTALLED NEW SEAT TRACK PER MM SRM 53SDR QXEA9901131Seat Track · corrodedPDX - RIGHT INBOARD SEAT TRACK HAS CORROSION AT FRAME 9305C AND EXTENDS 3 FORWARD OF FRAME 9305C. REPAIRED IAW FOKKER SRM 51-10-04, PAGE 9, PARAGRAPH 4B.SDR QXEA9901118Seat Track · corrodedPDX - LEFT INBOARD SEAT TRACK HAS CORROSION ON INBOARD FLANGE AND IN CHANNEL AT FRAME 9305C AND EXTENDS 6 AFT OF FRAME 9305C. REPAIRED IAW FOKKER SRM 51-10-04, PAGE 8, PARAGRAPH 3C.SDR QXEA9901117Seat Track · corrodedPDX - LEFT INBOARD SEAT TRACK HAS FRETTING CORROSION 2 INCHES AFT OF FRAME 10966. REPAIRED IAW FOKKER SRM 51-10-04.SDR CALA9900584Seat Track · corrodedINSPECTION FOUND SEAT TRACK CORRODED AT STA 344-360, LBL 40. A NEW SECTION OF SEAT TRACK WAS INSTALLED IAW SRM 53-00-52, FIGURE 202.SDR UPS99229869Cargo Track · crackedINSPECTION TYPE:C&SI AFT CARGO BAY CARGO TRACK AT BS 1090 RBL 14 IS CRACKED. REPAIR CARRIED OUT IAW SRM 53-10-5 FIG 5.SDR UPS99229868Cargo Track · crackedINSPECTION TYPE:C&SI AFT CARGO BAY CARGO TRACK AT BS 1070 RBL 14 IS CRACKED. REPAIR CARRIED OUT IAW SRM 53-10-5 FIG 5.SDR UPS99229865Cargo Track · crackedINSPECTION TYPE:C&SI AFT CARGO BAY CARGO TRACK AT BS 1070 LBL 18 IS CRACKED. REPAIRED IAW SRM 53-10-5.SDR QXEA9901136Seat Track · corrodedPDX - RIGHT INBOARD SEAT TRACK HAS CORROSION ON INBOARD FLANGE AT FRAME 4850. REPAIRED IAW FOKKER SRM 51-10-04, PAGE 8, PARAGRAPH 3C AND 4B.SDR QXEA9901130Seat Track · corrodedPDX - RIGHT INBOARD SEAT TRACK HAS FRETTING CORROSION ON INBOARD FLANGE 4 FORWARD OF FRAME 9305A. REPAIRED IAW FOKKER SRM 51-10-04, PAGE 9, PARAGRAPH 4B AND HORIZON AIR EA 4-53-813.SDR QXEA9901128Seat Track · corrodedPDX - RIGHT INBOARD SEAT TRACK HAS 3 SMALL AREAS OF FRETTING CORROSION BETWEEN STATION 7800 AND 8000 ON INBOARD FLANGE. REPAIRED IAW HORIZON AIR EA 4-53-813 AND FOKKER SRM 51-10-04, PAGE 8, PARAGRAPH 3,C,4.SDR CALA9900639Seat Track · corrodedINSPECTION FOUND SEAT TRACKS CORRODED AT STA 824, LT AND RT SIDES. THE SEAT TRACKS WERE REPLACED IAW MM 53-20-00.SDR AWXA9900211Seat Track · gougedFS 380-520 RBL 45, SEAT TRACK GOUGED BEYOND LIMITS. REMOVED SEAT TRACK FS 380-520 RBL 45 IAW SRM 51-40-02. FABRICATED REPLACEMENT SEAT TRACKS PER SRM 53-30-52, FIG 1. TREATED AND PRIMED SEAT TRACKS IAW SRM 51-20-01. INSTALLED SEAT TRACKS FS 380-520 RBL IAWSDR AWXA9900210Seat Track · misinstalledLBL 45, SEAT TRACK SECTIONS AT BS 520 SPLICE AREA ARE MIS-MATCHED. REMOVED BAD SEAT TRACK IAW SRM 51-40-02. FABRICATED NEW SEAT TRACK IAW SRM 53-30-52, FIG 1. TREATED AND PRIMED NEW SEAT TRACK IAW SRM 51-20-01. REINSTALLED NEW SEAT TRACK IAW SRM 51-40-02.SDR UPS99229701Seat Track · corrodedINSPECTION TYPE:SI, CORROSION ON SEAT TRACK FLANGE BS 806, LBL 26, WL 208. REMOVED CORROSION AND TREATED AREA PER MM 51-20-00.SDR UPS99229698Seat Track · corrodedINSPECTION TYPE:SI, CORROSION ON SEAT TRACK FLANGE BS 826, LBL 26, WL 208. REMOVED CORROSION 2 X 4 X 0.001 WITHIN LIMITS PER SRM 53-10-1, ALODINED AND PRIMED.SDR UPS99229697Seat Track · corrodedINSPECTION TYPE:SI, CORROSION ON SEAT TRACK FLANGE BS 848, WL 208, LBL 26. REMOVED CORROSION TREATED AND PAINTED AREA PER MM 51-20-00.SDR CALA9900577Seat Track · corrodedINSPECTION FOUND LT CENTER SEAT TRACK CORRODED AT STA 200. THE CORRODED SECTION OF SEAT TRACK WAS REMOVED AND A NEW SECTION WAS SPLICED IN IAW SRM 53-05, FIGURE 4F.SDR RRXA991582Seat Track · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION, FUSELAGE, TO MAIN DECK SEAT TRACK BETWEEN STA 560 AND STA 660 AT BL 45 LEFT. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED NEW SEAT TRACK IAW DC8 SDR RRXA991581Seat Track · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION, FUSELAGE, TO MAIN DECK SEAT TRACK BETWEEN STA 500 AND STA 560 AT BL 56 LEFT. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED NEW SEAT TRACK IAW DC8 SDR RRXA991579Seat Track · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION, FUSELAGE, TO MAIN DECK SEAT TRACK BETWEEN STA 270 AND STA 340 AT BL 0. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED NEW SEAT TRACK IAW DC8 SRM 5SDR RRXA991571Seat Track · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION, FUSELAGE, TO MAIN DECK SEAT TRACK BETWEEN STA 580 AND STA 620 AT BL 0. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED NEW SEAT TRACK IAW DC8 SRM 5SDR RRXA991570Seat Track · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION, FUSELAGE, TO MAIN DECK SEAT TRACK BETWEEN STA 560 AND STA 660 AT BL 56 LEFT. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED NEW SEAT TRACK IAW DC8 SDR RRXA991569Seat Track · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION, FUSELAGE, TO MAIN DECK SEAT TRACK BETWEEN STA 500 AND STA 560 AT BL 22 LEFT. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED NEW SEAT TRACK IAW DC8 SDR RRXA991567Seat Track · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION, FUSELAGE, TO MAIN DECK SEAT TRACK BETWEEN STA 400 AND STA 500 AT BL 22 LEFT. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED NEW SEAT TRACK IAW DC8 SDR UPS99829830Seat Track · corrodedINSPECTION TYPE:C1, STA 1520 AT RBL 59, THE SEAT TRACK MOUNTING FLANGE HAS HEAVY CORROSION. REPAIRED AREA IAW DH SK 705-154.SDR RRXA991578Seat Track · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION, FUSELAGE, TO MAIN DECK SEAT TRACK BETWEEN STA 1420 AND STA 1440 AT BL 0.. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED NEW SEAT TRACK IAW DC8 SRSDR RRXA991576Seat Track · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION, FUSELAGE, TO MAIN DECK SEAT TRACK BETWEEN STA 1320 AND STA 1340 AT BL 0.. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED NEW SEAT TRACK IAW DC8 SRSDR RRXA991575Seat Track · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION, FUSELAGE, TO MAIN DECK SEAT TRACK BETWEEN STA 1060 AND STA 1080 AT BL 56 LEFT. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED NEW SEAT TRACK IAW DCSDR RRXA991572Seat Track · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION, FUSELAGE, TO MAIN DECK SEAT TRACK BETWEEN STA 690 AND STA 640 AT BL 56 RIGHT. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED NEW SEAT TRACK IAW DC8SDR RRXA991565Seat Track · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION, FUSELAGE, TO MAIN DECK SEAT TRACK BETWEEN STA 270 AND STA 340, AT BL 56 LEFT, DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED NEW SEAT TRACK IAW DC8 SDR DLM11991148Seat Track · corrodedRIGHT AFT O/B SEAT TRACK WAS FOUND WITH EXTENSIVE CORROSION. THE REPLACEMENT SECTION OBTAINED FROM OEM DID NOT MEET B/P SPECS. REWORKED PER ERA 333185-14.SDR CALA9900571Seat Track · corrodedINSPECTION FOUND LEFT CENTER SEAT TRACK CORRODED FROM STA 1079 TO 1231. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 53-05, FIGURE 4F.SDR RRXA991577Seat Track · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION, FUSELAGE, TO MAIN DECK SEAT TRACK BETWEEN STA 1360 AND STA 1380 AT BL 22 LEFT. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED NEW SEAT TRACK IAW DCSDR RRXA991574Seat Track · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION, FUSELAGE, TO MAIN DECK SEAT TRACK BETWEEN STA 1020 AND STA 1040 AT BL 58 LEFT. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED NEW SEAT TRACK IAW DCSDR RRXA991573Seat Track · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION, FUSELAGE, TO MAIN DECK SEAT TRACK BETWEEN STA 1015 AND STA 1090 AT BL 0.. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED NEW SEAT TRACK IAW DC8 SRSDR QXEA9901301Seat Track · corrodedPDX - LEFT OUTBOARD SEAT TRACK HAS FRETTING CORROSION 3 AFT OF FRAME 6305, ON OUTBOARD FLANGE. REPAIRED IAW FOKKER SRM 51-10-04, PAGE 8, PARAGRAPH 3, C, 4.
Back to JASC 5347