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 DHL200071716DSeat Track · corrodedAT D CK, LIGHT CORROSION AND GOUGE ON SEAT TRACK BS 620, RBL 45. REMOVED AND REPLACED SEAT TRACK PER B727 SRM 51-10-1 AND SRM 53-10-5, FIG 7. MATERIAL USED; BAC 1520-792, SIZE; 40 LONG. REF: N/R 3389.SDR DHL200071707DSeat Track · damagedAT D CK, SEAT TRACK NR 4 FS 620 IS DAMAGED AT PALLET LOCK POSITION. REMOVED AND REPLACED DAMAGED SECTION OF TRACK FROM BS 600 TO 640 PER SRM 53-10-5, FIG 7 P/N BAC 1520-79 (40 LONG) REF: N/R 3394.SDR DHL200071706DSeat Track · wornAT D CK, UPPER DECK NR 3 SEAT TRACK FS480 TO 560 IS WORN OUT ON 3 LOCK POSITIONS. REMOVED CABIN SEAT TRACK FROM STA 480 TO 630 PER SRM 51-30-2. INSTALLED NEW TRACK AT NR 3 POSITION AT STA 480 TO 630. MATERIAL USED; BAC 1520-792, INSTALLED PER SRM 51-30-2. RSDR AALA2000124Seat Track · gougedTUL - NR 4 SEAT TRACK DEEP GOUGE STATION 1155. ROUTED OUT AREA DAMAGED, INSTALLED SEAT TRACK PLUG PER SRM 53-05 FIG 4A. (M)SDR USAA991451Seat Track · corrodedCLT - DURING Q-3 CHECK VISUAL INSPECTION, FOUND A 2 INCH AREA OF CORROSION AT FORWARD END OF SEAT TRACK STATION 345, LBL 20. REPLACED SEAT TRACK PER SRM 53-00-02. (M)SDR 00FDEA00023Seat Track · crackedSNRM 263, 264, 265, 266, 268 UPPER CARGO COMPT 263-LT BS 635, LBL 28. 264- LT BS 635, LBS 48. 265- LT BS 755, LBL 28. 266- LT BS 755, LBL 48. 268- RT BS 637, RBL 48, SEAT TRACKS CRACKED. SEAT TRACKS REPAIRED AS PER SRM 53-70-00.SDR DHL2000803111Seat Track · deterioratedAT C-CHECK, MAIN CARGO NR 3 LT SEAT TRACK FLANGE DETERIORATED BETWEEN FS 780 TO FS 810. REMOVED DAMAGED TRACK FLANGE IAW SRM 53-2-3, FABRICATED AND INSTALLED TRACK FLANGE IAW SRM 51-1-21 PG 7. REF: N/R 5194.SDR UPS00831657Seat Track · crackedINSPECTION TYPE:C1 STA 865 RBL 24 SEAT TRACK IS CRACKED AT UPPER FLANGE. REPAIRED IAW SRM 53-2-3.SDR UPS00831634Seat Track · crackedINSPECTION TYPE:C1 STA 1040 RBL 24 SEAT TRACK IS CRACKED. REPAIRED IAW SRM 53-2-3.SDR GAIA0012Seat Track · damagedDURING PHASE-IN INSPECTION, DAMAGE WAS FOUND ALONG CABIN SEAT TRACK FROM BS 950 TO 1135 RIGHT BODY LINE 25. REPLACED SECTION OF CABIN SEAT TRACK FROM BS 950 TO 1135, RBL 25. MATERIAL USED, PART NR CAB1520-792, 185 INCH LONG. REPAIR ACCOMPLISHED IAW SRM 53-1SDR GAIA0008Seat Track · damagedDURING PHASE-IN INSPECTION, DAMAGE WAS FOUND ALONG CABIN SEAT TRACK FROM BS 1080 TO 1135, RIGHT BODY LINE 45. REPLACED SECTION OF CABIN SEAT TRACK FROM BS 1080 TO BS 1135, RBL 45 IAW SRM 53-10-5 FIG 7. MATERIAL USED, PART NR BAC1520-792, 55 INCHES LONG. SEESDR GAIA0007Seat Track · damagedDURING PHASE-IN INSPECTION, DAMAGE WAS FOUND ALONG SEAT TRACK FROM STATION 344 TO 480 RIGHT BODY LINE 45.5. REPLACED SEAT TRACK FROM STATION 344 TO STATION 480, RBL 45.5. MATERIAL USED, PART NR CAB1520-792. ACCOMPLISHED IAW SUPPLEMENTAL TYPE CERTIFICATE (STSDR GAIA0006Seat Track · damagedDURING PHASE IN INSPECTION, DAMAGE WAS FOUND ALONG SEAT TRACK FROM STATION 344 TO 480, RIGHT BODY LINE 24.75. REPLACED SEAT TRACK FROM STATION 344 TO STATION 480, RBL 24.75. MATERIAL USED, PART NR CAB1520-792. ACCOMPLISHED IAW SUPPLEMENTAL TYPE CERTIFICATE SDR GAIA0005Seat Track · damagedDURING PHASE-IN INSPECTION, DAMAGE WAS FOUND ALONG SEAT TRACK FROM STATION 344 TO 480 LEFT BODY LINE 45.5. REPLACED SEAT TRACK FROM STATION 344 TO STATION 480, LBL 45.5. MATERIAL USED, PART NR BAC1520-792. ACCOMPLISHED IAW SUPPLEMENTAL TYPE CERTIFICATE (STCSDR CALA0000021Seat Track · corrodedINSPECTION FOUND RT O/B SEAT TRACK CORRODED AT STA 907-927. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 53-00-52.SDR CALA0000020Seat Track · corrodedINSPECTION FOUND LT O/B SEAT TRACK CORRODED AT STA 344-360. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 53-10-02.SDR CALA0000017Seat Track · corrodedINSPECTION FOUND G-1 GALLEY FLOOR TRACK CORRODED AT STA 270-294, RBL 45. THE FLOOR TRACK WAS REMOVED AND REPLACED IAW SRM 53-10-2.SDR AALA2000120Seat Track · corrodedTUL - PITTING CORROSION NR 1 SEAT TRACK, STATION 1054-1056, STATION 1037-1039. INSTALLED NEW SEAT TRACK NR 1 FROM STATION 1032-1087 SRM 53-05 PAGE 4B. (M)SDR RRXA000530Seat Track · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION DAMAGE TO SEAT TRACK BETWEEN STA 1160 TO STA 1210 AND BL 60 RIGHT. DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED NEW SEAT TRACK SECTION IAW DC-SDR RRXA003364Seat Track · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION DAMAGE TO THE SEAT TRACK AROUND FASTENERS AT FS 120-140 AND L30R, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. RECEIVED PART AND INSTALLED IAW DC-8 SRM 53-2-0.SDR QXEA0000028Seat Track · damagedPDX - NR 9 RIGHT INBOARD SEAT TRACK NUMEROUS DISCREPANCIES. REPLACED IAW DHC-8 SRM 51-40-11.SDR QXEA0000024Seat Track · corrodedPDX - LEFT FORWARD INBOARD SEAT TRACK HAS SEVEN AREAS OF MINOR PITTING CORROSION JUST FORWARD OF STATION X270.600 TO STATION 387.350. REPAIRED IAW DHC-8 GSR MANUAL, CHAPTER 53, QX GREEN SHEET SUPPLEMENT.SDR QXEA0000023Seat Track · damagedPDX - LEFT FORWARD INBOARD SEAT TRACK HAS TWO AREAS THAT HAVE SEVERAL NICKS BETWEEN STATIONS X405.737 AND X424.124. REPAIRED IAW DHC-8 GSR MANUAL CHAPTER 53.SDR QXEA0000022Seat Track · corrodedPDX - LEFT FORWARD INBOARD SEAT TRACK HAS LIGHT FRETTING CORROSION ON THE OUTBOARD PANEL SUPPORT FLANGE FROM STATION X234.500 TO X270600. REPAIRED IAW DHC-8 RD CHAPTER 53.SDR QXEA0000021Seat Track · corrodedPDX - LEFT FORWARD INBOARD SEAT TRACK HAS SOME MINOR PITTING CORROSION AROUND THE RIVET HEAD ON THE OUTBOARD PANEL SUPPORT FLANGE AT STATION X202.750. REPAIRED IAW DHC-8-200 SRM 51-40-00.SDR QXEA0000019Seat Track · corrodedPDX - LEFT AFT OUTBOARD SEAT TRACK HAS SEVERAL NICKS AT STATION X510.000. REPAIRED IAW DASH 8 MM 20-32-02 AND 20-34-08.SDR QXEA0000018Seat Track · corrodedPDX - LEFT AFT INBOARD SEAT TRACK HAS LIGHT SURFACE PITTING CORROSION AT STATION X547-500. REPAIRED IAW DASH 8 MM 20-32-02 AND 20-34-08.SDR QXEA0000017Seat Track · corrodedPDX - LEFT AFT INBOARD SEAT TRACK AT THE AFT CARGO BAY TIE-DOWN LUG HAS MINOR PITTING CORROSION. REPAIRED IAW DHC-8 20-32-02 AND 20-34-08.SDR QXEA0000016Seat Track · corrodedPDX - RIGHT OUTBOARD CABIN SEAT TRACK HAS PITTING CORROSION INSIDE TRACK CHANNEL AT STATION 488.500. REPAIRED IAW DCH-8 MM 20-32-02 AND 20-34-08.SDR QXEA0000007Seat Track · gougedPDX - RIGHT OUTBOARD SEAT TRACK HAS GOUGES AROUND SEAT PEG HOLE AT STATION 467.000. REPAIRED IAW DASH 8 MM 20-52-02 AND 20-34-08.SDR AALA2000123Seat Track · corrodedTUL - FOUND CORROSION SPOTS STATION 700-793. REPLACED SEAT TRACK FROM STATION 645-797 WITH SPLICE AT STATION 645 PER SRM 53-05 FIG 4F. (M)SDR AT0100065Seat Track · corrodedFOUND LEFT INBOARD SEAT TRACK CORRODED AT BS 500B-52D. REMOVED AND REPLACED SEAT TRACK IAW B737 SRM 53-10-5 FIGURE 1.SDR RRXA000646Seat Track · wornDURING A MAINTENANCE VISIT, FOUND DAMAGE TO MAIN DECK SEAT TRACK BETWEEN STA 580 TO 600 AND LBL 45, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED IAW DC-8 SRM 53-2-3.SDR 20000424AP017Seat Track · corrodedABI - SEAT TRACK AT BL 0.0 FOUND TO BE CORRODED BEYOND LIMITS. REMOVED AND REPLACED 67 INCHES OF SEAT TRACK AT BL 0.0 IAW SAAB SRM 72LKS 53-70-60. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA0082Seat Track · corrodedABI - SEAT TRACK AT BL 0.0 FOUND TO BE CORRODED BEYOND LIMITS. REMOVED AND REPLACED 67 INCHES OF SEAT TRACK AT BL 0.0 IAW SAAB SRM 72LKS 53-70-60. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA0081Seat Track · corrodedABI - FORWARD END OF SEAT TRACK AT BL 0 WAS FOUND TO BE CORRODED BEYOND LIMITS. REMOVED AND REPLACED 11.5 INCHES OF SEAT TRACK AT BL 0 IAW SAAB SRM 72LKS 3079, 53-70-60. AIRCRAFT RETURNED TO SERVICE. (M)SDR QXEA0000027Seat Track · damagedPDX - NR 7 CABIN RIGHT INBOARD SEAT TRACK NUMEROUS DISCREPANCIES. REPLACED IAW DHC-8 SRM 51-40-00.SDR QXEA0000020Seat Track · gougedPDX - LEFT MIDDLE OUTBOARD SEAT TRACK HAS SEVERAL GOUGES AT STATION X467.000. REPAIRED IAW DHC-8-200 SRM 51-40-11.SDR QXEA0000029Seat Track · damagedPDX - NR 10 RIGHT OUTBOARD SEAT TRACK NUMEROUS DISCREPANCIES. REPLACED IAW DHC-8 SRM 51-40-00.SDR QXEA0000026Seat Track · damagedPDX - NR 5 CABIN SEAT TRACK, LEFT MIDDLE NUMEROUS DISCREPANCIES. REPLACED IAW DHC-8 SRM 51-40-11.SDR QXEA0000025Seat Track · damagedPDX - NR 2 LEFT FORWARD OUTBOARD SEAT TRACK HAS NUMEROUS DISCREPANCIES. REPLACED SEAT TRACK IAW DHC-8 SRM 51-40-00.SDR AALA2000121Seat Track · corrodedTUL - PITTING CORROSION IN NR 1 SEAT TRACK INSIDE AND FLANGES AT BS 823-826, 892-896, 910-914, 994-995, AND 1022-1023. INSTALLED NEW SEAT TRACK NR 1 FROM STATION 823 TO STATION 1022 SRM 53-05 PAGE 4B. (M)SDR AALA2000118Seat Track · corrodedTUL - PITTING CORROSION ON NR 3 SEAT TRACK INSIDE AND ON FLANGES, STATION 1202-1204. REMOVED SECTION OF SEAT TRACK FROM STATION 1170 TO 1221 AND INSTALLED NEW SECTION PER SRM 53-05 FIG 4 PAGE 5. (M)SDR TWAA0000906Seat Track · corrodedDURING OP 16 MAINT CHECK, FOUND CABIN CORROSION IN THE CHAIR TRACK AT LBL 22 INCHES, STA 1117 TO 1309. INSTALLED NEW SEAT TRACK PER MM 53-40-01, PAGE 201. SPLICED PER SRM 53-05, PAGE 106 FIG 4F.SDR AALA20010127Seat Track · corrodedTUL - FOUND NR 1 SEAT TRACK CORRODED AND GOUGED STATION 671-673. INSTALLED PLUG REPAIR PER SRM 53-05 PART 1 FIG 4A. (M)SDR AT0100043Cargo Track · corrodedFOUND AFT PIT CARGO TRACK BS 937 - 966 CORRODED BEYOND LIMITS. REPAIRED CARGO TRACK IAW DC9 SRM 51-10-03, 51-10-04, AND 53-21.SDR QXEA0000057Seat Track · corrodedPDX - FRETTING CORROSION ON CENTER OF LEFT INBOARD SEAT TRACK BETWEEN FRAMES 11405 AND 11703. REPAIRED IAW HORIZON AIR EA 4-53-959.SDR MWEA00010Seat Track · crackedSEVERAL DAMAGED FASTENER HOLES SUBFLOOR UNDER INBOARD PILOTS SEAT TRACK. MTC STOP DRILLED CRACK, THEN FABRICATED AND INSTALLED DOUBLER.SDR SIMA00410Cargo Track · corrodedSAW - AFT CARGO OUTBOARD SEAT TRACK CORRODED BEYOND LIMITS. REMOVED AND REPLACED SEAT TRACK IAW EO E9-5300-013. AIRCRAFT RETURNED TO SERVICE. (M)SDR TWAA0000805Seat Track · corrodedDURING OP 16 MAINT CHECK, FOUND CORROSION IN CABIN ON NUMBER 2 TRACK FLANGE AT LBL 44, OTBD SIDE NUT PLATE HOLES, STA 1150 TO 1155. REPLACED SEAT TRACK AND MADE SPLICE PER SRM 51-01, PAGE 1 PARA L AND SRM 53-05, FIG 4F SHEET 5. INSTALLED FASTENERS PER SRM 51
Back to JASC 5347