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 QXEA0001837Seat Track · corrodedPDX- FRETTING CORROSION ON LEFT HAND INBOARD SEAT TRACK AT FRAME 13815A. REPAIRED IAW FOKKER SRM 51-10-4, AND SRM 53-40-01.SDR CALA0000992Seat Track · corrodedINSPECTION FOUND LT CENTER SEAT TRACK CORRODED ON FLOOR PANEL FLANGES AT STA 1145-1175, LBL 44. THE SEAT TRACK WAS REMOVED AND A NEW SEAT TRACK WAS INSTALLED IAW SRM 53-05, FIGURE 4, 51-10-4, AND 51-10-3.SDR 00FDEA00414Cargo Track · crackedUPPER CARGO COMP BALLMAT AREA, FLOOR TRACK AT BS 635 X=8.5L CRACKED. UPPER CARGO COMP BALLMAT AREA, FLOOR TRACK AT BS 635 X=8.5R CRACKED. *S/D* REMOVED AND REPLACED PER SRM 53-70-00 VOL 1.SDR AWXA0000433Seat Track · corrodedAT C-CHECK; SEAT TRACK FLANGE CORRODED AT FS 727B, LBL 44. REMOVED DAMAGE IAW 737 SRM 53-00-51 FIG 203, REPAIRED SEAT TRACK IAW 737 SRM 51-70-12, TREATED PARTS IAW 737 SRM 51-20-01, INSTALLED PART IAW 737 SRM 51-20-12.SDR SIMA1781Seat Track · corrodedDURING CPCP-2 INSPECTION, MAINTENANCE REPORTED THE LEFT FORWARD OUTBOARD, LEFT FORWARD INBOARD, LEFT MIDDLE INBOARD, LEFT MIDDLE OUTBOARD, LEFT AFT OUTBOARD, LEFT AFT INBOARD LAVATORY, AFT CARGO RIGHT AFT OUTBOARD, RIGHT AFT INBOARD, RIGHT MIDDLE INBOARD, RIGHSDR AWXA0000429Seat Track · gougedAT C-CHECK; SEAT TRACK GOUGED AT STA 578, RBL 45. REMOVED AND INSTALLED FABRICATED SEAT TRACK IAW 737 SRM 53-30-2, FABRICATED PART IAW 737 SRM 53-00-52,SDR AWXA0000428Seat Track · gougedAT C CHECK; SEAT TRACK GOUGED AT STA 639, RBL 25. REMOVED AND INSTALLED FABRICATED SEAT TRACK IAW 737 SRM 53-10-1, TREATED PARTS IAW 737 SRM 51-30-2SDR AWXA0000427Seat Track · corrodedAT C CHECK ; SEAT TRACK CORRODED AND GOUGED AT STA 688-690, RBL 25. REMOVED AND INSTALLED FABRICATED SEAT TRACK IAW 737 SRM 51-30-2, PARTS FABRICATED IAW 737 SRM 53-00-52, TREATED IAW 737 SRM 51-10-2 AND 51-20-4SDR AWXA0000426Seat Track · gougedAT C CHECK; SEAT TRACK GOUGED AT STA 597 LBL45. REMOVED SEAT TRACK, FABRICATED NEW SEAT TRACK IAW 737 SRM 53-10-2, TREATED REPLACEMENT PART IAW 737 SRM 51-10-2, INSTALLED REPLACEMENT PART IAW SRM 737 51-30-2.SDR AWXA0000420Seat Track · gougedAT C CHECK ; SEAT TRACK GOUGED AT STA 520-540, RBL 25. REMOVED AND REPLACED SEAT TRACK IAW 737 SRM 53-10-2.SDR AWXA0000419Seat Track · gougedAT C CHECK; SEAT TRACK GOUGED AT STA 520-540, LBL 45. REMOVED AND REPLACED SEAT TRACK IAW 737 SRM 53-10-2.SDR AWXA0000418Seat Track · gougedAT C CHECK ; SEAT TRACK GOUGED AT STA 520-540 RBL 45. REMOVED AND REPLACED SEAT TRACK IAW 737 SRM 53-10-2.SDR AWXA0000415Seat Track · gougedAT C CHECK ; TOP OF SEAT TRACK GOUGED AT CABIN STA 500+4 RBL 25. REMOVED, FABRICATED, TREATED, AND INSTALLED REPAIR PARTS IAW 737 SRM 53-10-2, SRM 737 51-10-2, AND 737 SRM 53-10-02SDR 00FDEA00408Seat Track · corrodedNR 446 CORROSION ON LONGITUDINAL BEAM AND SEAT TRACK AT BS 846 TO BS 760, WL 208, RBL 45. ** S/D ** R&R CORROSION PER FEDEX SRM 51-30-2.SDR CALA0000986Seat Track · corrodedINSPECTION FOUND LT CENTER SEAT TRACK CORRODED AT STA 1145 - 1175, LBL 44. THE SEAT TRACK WAS REMOVED AND A NEW SEAT TRACK WAS INSTALLED IAW SRM 53-05, FIGURE 4, 51-10-4, AND 51-10-3.SDR ASAA0080399Seat Track · corrodedPHX - DURING 30K CHECK, FOUND CORROSION ON CABIN SEAT TRACK, FS 1031 TO 1308, LBL 44. REMOVED AND REPLACED SEAT TRACK SECTION IAW DC9 SRM 53-05. (M)SDR ASAA0080397Cargo Track · corrodedPHX - DURING 30K CHECK, FOUND CORROSION ON CARGO TRACK, FS 1007, LBL 16. REMOVED AND REPLACED CARGO TRACK SECTION FROM FS 1007 TO 1222 IAW DC9 SRM 53-05. (M)SDR ASAA0080396Cargo Track · corrodedPHX - DURING 30K CHECK, FOUND CORROSION ON CARGO TRACK, FS 692 TO 788, RBL 22. REMOVED AND REPLACED CARGO TRACK SECTION IAW DC9 SRM 51-30-00. (M)SDR ASAA0080395Seat Track · corrodedPHX - DURING 30K CHECK, FOUND CORROSION ON CABIN SEAT TRACK, FS 200 TO 797, RBL 22. REMOVED AND REPLACED SEAT TRACK SECTION IAW DC9 SRM 51-30. (M)SDR ASAA0080398Seat Track · corrodedDURING 30K CHECK CORROSION WAS FOUND IN CABIN SEAT TRACK, FS 1031 TO 1308, LBL 24. REMOVED AND REPLACED SEAT TRACK SECTION IAW DC9 SRM 53-24-00.SDR USAA001053Seat Track · corrodedPIT - FOUND SEAT TRACK CORRODED .050 INCH BY .5 INCH BY 1 INCH, STATION 328R TO 344R RIGHT OUTBOARD SEAT TRACK. INSTALLED SEAT TRACK SECTION PER SRM 53-00-52. CORROSION LEVEL 1, TASK NR C53-107-02. (M)SDR CALA0000984Seat Track · corrodedINSPECTION FOUND SEAT TRACK CORRODED AT STA 860, RBL 54. THE CORRODED SECTION OF SEAT TRACK WAS CUT OUT AND A REPLACEMENT SEAT TRACK AND AFT SPLICE WERE INSTALLED IAW SRM 53-05, FIGURE 4F.SDR CALA0000983Seat Track · corrodedINSPECTION FOUND SEAT TRACK CORRODED AT STA 1136, LBL 22. THE SEAT TRACK WAS REMOVED AND A NEW SEAT TRACK SECTION WAS INSTALLED IAW SRM 53-05, FIGURE 4F.SDR CALA0000982Seat Track · corrodedINSPECTION FOUND LEFT O/B SEAT TRACK CORRODED AT STA 1174 - 1236, LBL 56. THE SEAT TRACK WAS REMOVED AND A NEW SEAT TRACK AND SPLICE REPAIR WERE INSTALLED IAW SRM 53-05, FIGURE 4 AND 51-30-1.SDR CALA0000980Seat Track · corrodedINSPECTION FOUND CABIN SEAT TRACKS CORRODED AT STA 1180, RBL 22 AND AT STA 1220, RBL 22. THE SEAT TRACKS WERE REMOVED AND NEW SEAT TRACKS WERE INSTALLED IAW SRM 51-30-2, 51-30-1, 53-05, FIGURE 4, AND 51-10-3.SDR CALA0000979Seat Track · corrodedINSPECTION FOUND CABIN SEAT TRACKS CORRODED AT FS 1136 - 1174, LBL 44 AND AT FS 1174 - 1190, LBL 22. THE SEAT TRACKS WERE REMOVED AND NEW SEAT TRACKS WERE INSTALLED IAW SRM 51-30-1, 51-30-2, 53-05, FIGURE 4, AND 51-60-0.SDR CALA0000967Cargo Track · corrodedINSPECTION FOUND CARGO TRACK IN AFT CARGO PIT CORRODED AT STA 1322, LBL 26-28. REPAIR DOUBLERS WERE INSTALLED IAW 53-01 AND 51-10-0.SDR CALA0000966Cargo Track · corrodedINSPECTION FOUND CARGO TRACK IN AFT CARGO PIT CORRODED AT STA 1003 - 1155, RBL 24. THE CARGO TRACK WAS REMOVED AND A NEW TRACK WAS INSTALLED IAW SRM 51-30-1 AND 53-24.SDR AALA20001154Seat Track · corrodedTUL - NR 1 SEAT TRACK CORRODED, BS 762 - BS 767. BLENDED CORROSION OUT, OUT OF LIMITS. INSTALLED PLUG REPAIR AARD 53-20-00-10. (X)SDR AALA20001153Seat Track · gougedTUL - NR 1 SEAT TRACK GOUGED, BS 673. BLENDED GOUGE AREA PER SRM 51-10-3, OUT OF LIMITS, ROUTED, INSTALLED PLUG REPAIR AARD 53-20-00-10. (X)SDR MALA000374Seat Track · corrodedLT IB (LBL18.3) AND RT IB (BLO) SEAT TRACKS FWD SECTIONS WERE CORRODED, COMPLETED REPAIR IAW EOS53060 FOR BOTH SEATTRACKS.SDR AWXA0000412Seat Track · gougedSEAT TRACK GOUGED OUT OF LIMITS. REMOVED AND REPLACED SEAT TRACK IAW 737 SRM 51-10-2 AND 51-30-0SDR QXEA0001802Seat Track · corrodedYXX-X182 TO X355 Z100 Y12.5 LEFT HAND INBOARD SEAT TRACK HAS CORROSION AT ALL CAMLOCK RECEPTICAL LOCATIONS. REPAIRED IAW DHC-8 SRM 51-40-00, SRM 51-40-11, PAGE 1-6AND SRM 51-20-36.SDR TWAA0010412Seat Track · corrodedDURING CHECK-C MAINT FOUND CORROSION ON NR 3 LT SEAT TRACK, STA 1250 TO 1309. REMOVED AND REPLACED NR 3 SEAT TRACK FROM STA 1250 TO 1309, PER SPM 6-70-01. ---CLOSED---SDR DHL200080199CCargo Track · wornAT C CK; MAIN CARGO COMPARTMENT 3 RT TRACK WORN AND CORRODED FROM STA. 1490.0 TO 1540.0. REMOVED DAMAGED TRACK IAW SRM 51-3-0 PAGE 1, CLEANED,TREATED AND PRIMED AREA IAW SRM 51-1-8B, PAGE 1-2, INSTALLED NEW TRACK IAW SRM 51-3-0. REF: N/R 1619.SDR UPS00433059Seat Track · crackedINSPECTION TYPE: C. SEAT TRACK CRACKED BS 440 AND BS460 RBL 64. SECTION OF SEAT TRACK REPLACED FROM BS 430 TO BS 460 IAW SRM 53-10-0 5, FIG. 1A, DETAIL 1VSDR COMA0060523Seat Track · wornCO-PILOT SEAT TRACT OUTBOARD FORWARD STOP WORN. REMOVED WORN STOP. INSTALLED A SERVICEABLE ONE.SDR 20001204AP008Seat Track · corrodedMAIN CABIN AFT END SEAT TRACK EXTENSION HAS EXFOLIATIVE CORROSION ON SURFACE FROM BS 1130 TO BS 1183 LBL 25. REMOVED SEAT TRACK BS 1130 TO 1183 LBL 25. FABRICATED SEAT TRACK IAW 51-10-1. TREATED, PRIMED AND INSTALLED SEAT TRACK EXTENSION IAW 51-10-1 PAGE 8.SDR SIMA1732Seat Track · corrodedSAW - DURING MBV-2 INSPECTION, MAINTENANCE FOUND THE LEFT FLIGHT ATTENDANT SEAT TRACK CORRODED. MAINTENANCE REMOVED AND REPLACED SEAT TRACK IAW ENGINEERING ORDER E9-5300-013. AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR 20001012AP001Seat Track · corrodedABI - FOUND SEAT TRACK AT BL 18.3L WAS FOUND CORRODED DURING MBV VISIT. SEAT TRACK SECTION AND ONE U-BEAM WERE REMOVED AND REPLACED IAW SAAB SRM 53-70-60. (M)SDR SIMA1721Seat Track · corrodedABI - FOUND SEAT TRACK AT BL 18.3L WAS FOUND CORRODED DURING MBV VISIT. SEAT TRACK SECTION AND ONE U-BEAM WERE REMOVED AND REPLACED IAW SAAB SRM 53-70-60. (M)SDR DHL2000801118Cargo Track · corrodedMAIN CARGO COMPT FLOOR TRACK 3 LT SHOWS CORROSION AT STA 1460.000. CUT OUT DAMAGED AREA PER SRM 53-2-3. FABRICATED CHANNEL AND PLUG PER SRM 53-2-3. CLEANED, TREATED AND PRIMED PER 51-1-8B. INSTALLED CHANNEL AND PLUG PER SRM 53-2-3.SDR DHL200080196CCargo Track · wornAT C CK; MAIN CARGO COMPARTMENT 1 LT TRACK LUGS WORN AT STA. 680. CUTOUT DAMAGED AREA IAW SRM 53-2-3 PAGE 17, CLEANED,TREATED AND PRIMED AREA IAW SRM 51-1-8B, PAGE 1-2, INSTALLED CHANNEL AND PLUG IAW SRM 53-2-3.SDR QXEA0001801Seat Track · corrodedBS 182 TO BS 270 RBL 12.5, INBOARD RIGHT HAND SEAT TRACK CORRODED AT NUMEROUS CAMLOCK RECEPTICAL LOCATIONS. REPAIRED IAW DHC-8 SRM 51-40-11, PAGE 1, SRM 51-40-00, PAGE 4, AND HORIZON AIR EA 2-53-178.SDR CALA0000949Seat Track · corrodedINSPECTION FOUND LEFT O/B SEAT TRACK CORRODED AT FS 1174 - 1207, LBL 54. THE SEAT TRACK WAS REMOVED AND A NEW SEAT TRACK WAS INSTALLED IAW SRM 51-30-1, 53-05, FIGURE 4, AND 51-10-4.SDR CALA0000938Cargo Track · corrodedINSPECTION FOUND LT TIE DOWN TRACK CORRODED IN MID CARGO AREA AT STA 522 - 786.5, LONGERON 27L. THE TIE DOWN TRACK WAS REMOVED AND REPLACED IAW SRM 51-30-2 AND 51-30-5.SDR CALA0000932Cargo Track · corrodedINSPECTION FOUND LT TIE DOWN TRACK CORRODED UNDER NUT CLIPS IN FORWARD PIT AT FS 218 - 538, LONGERON 27L. THE TIE DOWN TRACK WAS REMOVED AND A NEW TRACK WAS INSTALLED IAW SRM 51-30-1, 51-30-2, AND 51-30-5.SDR CALA0000931Seat Track · corrodedINSPECTION FOUND RIGHT O/B SEAT TRACK CORRODED AT STA 720 - 795, RBL 54.5. THE SEAT TRACK WAS REMOVED AND A NEW SEAT TRACK WAS INSTALLED IAW SRM 51-10-4, 51-10-3, 53-05, FIGURE 4F, 51-30-1, AND 51-30-5.SDR CALA0000930Cargo Track · corrodedINSPECTION FOUND LT TIE DOWN TRACK CORRODED IN AFT CARGO AREA AT FS 1007 - 1320, LONGERON 27L. THE TIE DOWN TRACK AND SPLICE WERE REMOVED AND A NEW TRACK AND SPLICE WERE INSTALLED IAW SRM 51-30-1, 51-30-2, 51-10-4, AND 53-05, FIGURE 4B.SDR CALA0000925Seat Track · corrodedINSPECTION FOUND LEFT O/B SEAT TRACK CORRODED AROUND FASTENER HOLES AT STA 1150 - 1174. THE CORRODED SECTION OF TRACK WAS CUT OUT AND A NEW SECTION WAS INSTALLED IAW SRM 53-05, FIGURE 4F.
Back to JASC 5347