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 USAA2009012790188Seat Track · corrodedBFM - C2 - MAJOR REPAIR - CORROSION ON SEAT TRACK BETWEEN FR38 TO FR39.2, Y450. REPLACED CORROSION ON SEAT TRACK BETWEEN FR38 TO FR39.2, Y450 IAW A330 SRM 51-42-11 & 51-44-11.SDR USAA2009012790193Seat Track · corrodedBFM - C2 - MAJOR REPAIR - CORROSION ON SEAT TRACK BETWEEN FR44 TO FR47, -Y450. REPLACED SEAT TRACK BETWEEN FR44 TO FR47, -Y450 IAW A330 SRM 53-31-15 & 51-42-11.SDR USAA2009012790192Seat Track · corrodedBFM - C2 - MAJOR REPAIR - CORROSION ON SEAT TRACK BETWEEN FR53.2 TO FR54, Y450. REPLACED SEAT TRACK BETWEEN FR53.2 TO FR54, Y450 IAW A330 SRM 53-31-15.SDR QXEA2009012700050Seat Track · corrodedPDX - C1 - LIGHT CORROSION IN CTR OF CLAWS ON RT INBD SEAT TRACK AT STA X718. BLENDED CORROSION ON RT INBD SEAT TRACK AT STA X718. MAX MATERIAL REMOVED .011 INCH. BLEND IS WITHIN LIMITS OF RD8/4-53-884. HFEC IAW -8 400 NDTM PART6, 51-00-01. NO CRACKS NOTSDR QXEA2009012700049Seat Track · corrodedPDX - C1 - LIGHT CORROSION IN CTR OF CLAWS ON LT INBD SEAT TRACK FROM STA X734 TO X744. BLENDED CORROSION FROM LT INBOARD SEAT TRACK AT STA X734- X744, MAX MATERIAL REMOVED .013 INCH. BLEND IS WITHIN LIMITS OF RD 8/4-53-884. HFEC IAW NDTM PART 6, 51-00-01. SDR QXEA2009012700047Seat Track · corrodedPDX - C1 - LIGHT CORROSION IN CRT OF CLAWS ON LT INBD SEAT TRACK AT STA X718. BLENDED CORROSION ON LT INBOARD SEAT TRACK AT STA X718. MAX MATERIAL REMOVED .020". BLEND FOUND TO BE WITHIN LIMITS OF RD 8/4-53-884. HFEC IAW -8 400 NDTM PART 6, 51-00-01. NO CSDR TRBACPCP20090005Seat Track · corrodedCORROSION ON SEAT TRACK LT SIDE BETWEEN FRAME 29 AND 36. REMOVED SEAT TRACK BETWEEN FRAME 29 TO 36 AND INSTALLED NEW SEAT TRACK IAW SRM NR 51-25-04.SDR UALA2009012600262Seat Track · corrodedMAIN CABIN STA 808 RBL 54.5 SEAT TRACK CORRODED. MAJOR REPAIR ACCOMPLISHED. INSTALLED NEW SECTION OF SEAT TRACK.SDR ASOA200900132Seat Track · corroded2 SECTIONS OF SEAT TRACK BETWEEN FS 364.0 AND 399.5 AT LBL 9 AND RBL 9 ARE CORRODED BEYOND LIMITS IAW SRM 53-21-49. REMOVED SEAT TRACK AND INSTALLED NEW SEAT TRACK IAW AMM 53-01-11-400-802.SDR ASOA200900111Seat Track · corrodedCORROSION DAMAGE ON FLOOR SEAT RAIL FS379.00 TO FS477.40 AT LBL 9.0. INSTALLED NEW SEAT TRACK P/N SH670-32249-3 PER SRM 51-41-00 EM 7025452 JOB COMPLETED.SDR ASOA200900110Seat Track · corrodedCORROSION DAMAGE ON FLOOR SEAT RAIL FS 379.00 TO 477.40 AT RBL 9.0. WORK WAS ACCOMPLISHED ON W/O108929 NON ROUTINE 219 TFP 7017470 JOB COMPLETED.SDR ASOA200900109Seat Track · corrodedCORROSION DAMAGE ON FLOOR SEAT RAIL FS477.40 TO FS581.00 AT LBL 9.0. INSTALLED NEW SEAT TRACK P/N SH670-33426-1 PER SRM 51-41-00 EM 7025452 JOB COMPLETED.SDR ASOA200900108Seat Track · corrodedCORROSION DAMAGE ON FLOOR SEAT RAIL FS477.40 TO FS581.00 AT RBL 9.0. INSTALLED NEW SEAT TRACK P/N SH670-33426-1 PER SRM 51-41-00 EM 7025452. JOB COMPLETED.SDR ASOA200900107Seat Track · corrodedCORROSION DAMAGE ON FLOOR SEAT RAIL FS581.00 TO FS693.00 AT LBL 9.0 MARKED. INSTALLED NEW SEAT TRACK PER SRM 51-41-00.SDR ASOA200900106Seat Track · corrodedCORROSION DAMAGE ON FLOOR SEAT RAIL FS 581.00 TO FS 693.00 AT RBL 9.0. BLENDED FLOOR SEAT RAIL (WITHIN LIMITS) FS 581.00 TO 693.00 AT RBL 9.0 PER SRM 51-31-49. KR17389.SDR ASOA200900105Seat Track · corrodedCORROSION DAMAGE ON FLOOR SEAT RAIL FS 693.00 TO FS 830.00 AT LBL 9.0 MARKED. BLENDED FLOOR SEAT RAIL (WITHIN LIMITS)F.S. 693.00 TO 830.00 AT LBL9.0 PER SRM 51-41-49.SDR ASOA200900104Seat Track · corrodedCORROSION DAMAGE ON FLOOR SEAT RAIL FS693.00 TO FS830.00 AT RBL 9.0 MARKED. BLENDED FLOOR SEAT RAIL (WITHIN LIMITS) FS 693.00 TO 830.00 AT RBL 9.0 PER CRJ 700 SRM 51-41-49.SDR ASOA200900103Seat Track · corrodedCORROSION DAMAGE ON FLOOR SEAT RAIL FS830.00 TO FS953.00 AT LBL 9.0 MARKED. INSTALLED NEW SEAT TRACK P/N SH670-37420-5 PER CRJ 700 SRM 51-41-00 EM 7025452.SDR ASOA200900102Seat Track · corrodedCORROSION DAMAGE ON FLOOR SEAT RAIL FS830.00 TO FS985.00 AT RBL 9.0 MARKED. BLENDED FLOOR SEAT RAIL (WITHIN LIMITS) FS 830.00 TO 985.00 AT RBL 9.0 PER CRJ 700 SRM 51-51-49.SDR ASOA200900101Seat Track · corrodedCORROSION DAMAGE ON FLOOR SEAT RAIL FS 953.00 TO FS 1000.00 AT LBL 9.0 MARKED. INSTALLED NEW SEAT TRACK P/N SH670-37420-5 PER CRJ 700 SRM 51-41-00 EM 7025452.SDR IXXA09SMN024SCargo Track · corrodedDURING ROUTINE C CHECK INSPECTION, FOUND MAIN CARGO COMPARTMENT NUMBER 3 TRACK LUG CORRODED AT STATION 494.000 - 570.000. REMOVED EXISTING SPLICES. REMOVED CORROSION. FOUND OUT OF LIMITS. REMOVED CORRODED TRACK SEGMENT. FABRICATED SPLICES. CLEANED, TREATSDR ASOA200900114Seat Track · corrodedLT SIDE SEAT RAIL HAS CORROSION FROM FS 409 BACK. CLEANED LT SIDE PAX SEAT RAILS FROM FS 409 AND AFT IAW AMM 53-01-11-000-802, SUBTASK 53-01-11-020-002 PARA 3A (3) AND UPON FURTHER INVESTIGATION, FOUND NO SIGNS OF CORROSION ON RAILS.SDR FDEA200901210285Seat Track · corrodedCABIN, MAIN DECK SEAT TRACK BASE, STATION 615 TO STATION 625 X = -8.5 FOUND CORROSION. REPAIR CARRIED OUT AS PER SRM 53-70-00 FIG. 1 VOL.I. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100.SDR AALA2009021100066Seat Track · corrodedNUMBER FOUR SEAT TRACK CORROSION REMOVAL OUT OF LIMITS AT STATION 237. INSTALLED SEAT TRACK PLUG AND CHANNEL IN ACCORDANCE WITH AARD 53 20 00 10.SDR ASOA200900094Seat Track · corrodedLEFT SIDE SEAT RAILS HAVE MINOR CORROSION ENTIRE THE LENGTH OF THE RAILS. REMOVED AND REPLACED LEFT SIDE SEAT RAIL AT FS 743.00 TO FS 847.00 IAW CRJ 700 AMM 53-00-49. AFTER REMOVAL OF THE SEAT RAIL FS 743.00 TO FS 847.00 WAS INSPECTED FOR CORROSION NO DEFECTSDR ASOA200900093Seat Track · corrodedRT SEAT RAILS HAVE CORROSION ON FIRST SECTION OF RAIL AT 2 LOCATIONS AS MARKED (AROUND FS421.00). BLENDED RIGHT SIDE SEAT RAILS ON FS 400.00 WITHIN LIMITS IAW SRM CRJ 700 53-21-49 MA 7026048.SDR ASOA200900092Seat Track · corrodedRT SEAT RAILS HAVE CORROSION ON SECTION OF RAIL AT FS785. INSTALLED RIGHT SIDE SEAT RAILS ON FS 785.00 IAW AMM CRJ 700 53-00-49 MA 7026048.SDR ASOA200900091Seat Track · corrodedRT FLOOR SEAT TRACK FWD END HAS CORROSION AT FWD LAV AREA. REMOVED RT FLOOR SEAT TRACK AT FWD LAV AREA IAW CRJ700 AMM 53-00-49. NEW SEAT TRACK NEEDS TO BE INSTALLED. INSTALLED NEW SEAT RAIL ON THE RIGHT SIDE CABIN FLOOR AT BL 9.00 FROM FS 350.00 TO FS 485SDR HNAA2009061700182Seat Track · corrodedRT INBD SEAT RAIL FOUND CORRODED FROM STA X 182 TO X260. REMOVED AND REPLACED SEAL RAIL IAW MFG 85320490 AND EO8-53-09-3047.SDR DHLA2009743543Seat Track · corrodedCABIN SEAT TRACK CORRODED, BS 950 +9 INCH TO BS 1135, RBL 45. REMOVED, FABRICATED NEW, AND INSTALLED SEAT TRACK SECTION PER B727 SRM 53-10-5 FIG 7 AND 51-10-1.SDR FDEA200901190235Seat Track · corrodedSEAT TRACK BASE STATION 1114 TO STATION 1119 X = -8.5 FOUND CORROSION. REPAIRED BY SECTIONAL SEAT TRACK REPLACEMENT AS PER SRM 53-70-00 FIGURE 1 VOLUME I. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100.SDR FDEA200901180232Seat Track · crackedCABIN, SEAT TRACK STATION 1089 X = 27.5 FOUND CRACKED. REPAIRED BY SECTIONAL SEAT TRACK REPLACEMENT AS PER SRM 53-70-00 FIGURE 1 VOLUME I. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100.SDR USAA2009012890215Seat Track · corrodedSAL - C7 - MAJOR REPAIR - GALVANIC CORROSION ON SEAT RAIL BEAM BETWEEN FR64 TO FR66 + 5 INCHES, Y1292. REPLACED SEAT RAIL BEAM BETWEEN FR64 TO FR66 + 5 INCHES, Y1292 IAW A320 SRM 51-72-11.SDR FDEA200901140191Seat Track · damagedMAIN DECK CARGO COMPARTMENT NR 3 RT SEAT TRACK HAS 2 ELONGATED SCALLOPS AT FR 54.2 AND 6 INCHES AFT OF FR 54.2. REMOVED DAMAGED SECTION OF TRACK AND INSTALLED NEW SEAT TRACK AT TRACK NR 3 RT BETWEEN FR 54.2 AND FR 58 IAW A310-200 SRM 51-72-10.SDR USAA2009012890217Seat Track · corrodedSAL - C7 - MAJOR REPAIR - CORROSION ON SEAT TRACK BETWEEN FR12 TO FR23, -Y1292. REPLACED SEAT TRACK BETWEEN FR12 TO FR23, -Y1292 IAW A320 SRM 51-42-11.SDR FDEA200901130187Seat Track · corrodedSEAT TRACK STA 650 RBL 24 CORRODED. REMOVED CORROSION FOUND TO BE OUT OF LIMIT IAW SRM 53-00-52, ORIG MAT 0.100 REMAINING MAT 0.074. REMOVED SEAT TRACK IAW SRM 51-40-02 AND 53-00-52. FABRICATED NEW SEAT TRACK IAW SRM 53-00-52 FROM BAC1520-792/24 BATCH NR 11SDR FDEA200901130172Seat Track · corrodedMAIN DECK CARGO COMPARTMENT SEAT TRACK NR 2 LT, 12 INCHES AFT OF FR 17 HAS 10 SQ IN OF CORROSION. REMOVED LEVEL 1 CORROSION. REMOVED DAMAGED SEAT TRACK AND INSTALLED NEW TRACK AT TRACK NR 2 LT BETWEEN FR 14 AND FR 17 IAW A310-200 SRM 51-72-10.SDR FDEA200901130171Seat Track · damagedMAIN DECK CARGO COMPARTMENT NR 5RT SEAT TRACK HAS 2 ELONGATED SCALLOPS, AFT OF FR 54.2 CUT OUT DAMAGED SEAT TRACK SECTION AND INSTALLED SEAT TRACK CUTOUT REPAIR AT TRACK NR 5 RT BETWEEN FR 54.2 AND FR 59 IAW SRM 53-10-16, FIG 201.SDR FDEA200901130170Seat Track · corrodedMAIN DECK CARGO COMPARTMENT SEAT TRACK NR 3RT BETWEEN FR 16 AND FR 17 HAS 15 SQ INCH OF CORROSION REMOVED LEVEL 1 CORROSION. REMOVED AND REPLACED SEAT TRACK SECTION NR 3RT BETWEEN FR15 AND FR18 IAW A310-200 SRM 51-72-10.SDR HNAA2009011200010Seat Track · corrodedDURING 'C' CHECK INSPECTIONS, THE RT FORWARD I/B SEAT RAIL WAS FOUND TO HAVE CORROSION MEASURING .020 DEEP. THE SEAT RAIL SECTION WAS REPLACED IAW DHC RD8-53-3074.SDR FDEA200901120155Seat Track · corrodedMDCC SEAT TRACK 2R FROM FRAME 16 TO FRAME 18 CORRODED APROX 50 INCHES IN LENGTH. AFTER EVALUATION OF TRACK, IS CORRODED (LEVEL I) BEYOND ECONOMICAL REPAIR. REMOVED AND REPLACED SEAT TRACK 2R AT FRAME 16 IAW A310-200 SRM 51-72-10.SDR FDEA200901120154Seat Track · crackedMAIN CABIN INSPECTION FLOOR PANEL AND SEAT TRACKS FOUND CRACKS ON TRACK. REPAIRED AREA IAW SRM 53-70-00 FIG 1, SHT 1 AND 2 VOL I.SDR USAA2009012690167Seat Track · corrodedSAL - C3 - MAJOR REPAIR - GALVANIC CORROSION ON SEAT BEAM BETWEEN FR64 TO FR65, -Y765. REPAIRED SEAT BEAM BETWEEN FR64 TO FR65, -Y765 IAW A320 SRM 51-72-11.SDR FDEA200901110148Seat Track · corrodedMAIN DECK, FLOOR PANEL SEAT TRACK AT STA 1541, X = 8.5 FOUND WITH CORROSION. REPAIR CARRIED OUT AS PER SRM 53-70-00 FIG 1 VOL I. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100.SDR R5KB15756Seat Track · corrodedLBL 44, SEAT TRACK CROWN CORRODED FROM STA 760 TO 848.SDR EIAA20090013Seat Track · chafedSTA 1770 BLB 33 SEAT/TIE DOWN TRACK CHAFED. DAMAGED AREA REMOVED AS PER SRM 51-10-01, NDT CHK CARRIED OUT AS PER PT4/51-00-00. ORIG THICKNESS 0.170 INCH REMAINING 0.130 INCH BEYOND SRM UNITS OF 53-10-01. CUT DAMAGED SEAT TRACK FROM STA 1770 TO 1830 AS PER SSDR USAA2009012690161Seat Track · corrodedSAL - C3 - MAJOR REPAIR - CORROSION ON SEAT TRACK BETWEEN FR41 TO FR47, -Y765. REPLACED SEAT TRACK BETWEEN FR41 TO FR47, -Y765 IAW A320 SRM 51-42-11 & AIRBUS DRAWING D53371110.SDR AALA2009021300102Seat Track · misrepairedFIRST OFFICER SEAT TRACK REPAIR TEES INCORRECT AT STATION 148 ON FLIGHT DECK. REMOVED AND REPLACED SEAT TRACK TEES PER DRAWING EDK1346.SDR USAA2009012390137Seat Track · corrodedSAL - C21 - MAJOR REPAIR - GALVANIC CORROSION ON SEAT TRACK BETWEEN BS 922 TO BS 947, RBL 54.50. REPAIRED SEAT TRACK BETWEEN BS 922 TO BS 947, RBL 54.50 IAW B737 SRM 53-00-52.SDR SWIA200921294Seat Track · corrodedC-CHECK, LEFT FORWARD SEAT RAIL ON WALL CORRODED. REPLACED PER AMM.
Back to JASC 5347