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 HALA0800074Seat Track · corrodedLEVEL 1 CORROSION SECTION 45, SEAT TRACK AT LBL 88.5, STA. 785. CORROSION REMOVED, CONFIRMED BY 10X MAGNIFICATION IAW SRM 51-10-02, REV 75. BLENDED WITHIN LIMITS IAW SRM 53-00-52/101 REV 75.SDR HALA0800073Seat Track · damagedSEAT TRACKS DAMAGED AT LOCATION LBL 88.5, STA. 375. DAMAGE REMOVED AT LOCATION LBL 88.5, STA 375, IAW SRM 53-00-52, WITHIN LIMITS.SDR HALA0800072Seat Track · damagedSEAT TRACKS DAMAGED AT LOCATION RBL 54, STA. 654. DAMAGE REMOVED AT LOCATION RBL 54, STA. 654, IAW 767-300 SRM 53-00-52, WITHIN SRM LIMITS.SDR HALA0800071Seat Track · damagedSEAT TRACKS DAMAGED AT LOCATION RBL 11, STA 598. DAMAGE REMOVED AT LOCATION RBL 11, STA 598, IAW 767-300 SRM 53-00-52, WITHIN SRM LIMITS.SDR HALA0800070Seat Track · damagedSEAT TRACKS DAMAGED AT LOCATION RLB 11, STA 520. DAMAGE REMOVED AT LOCATION RBL 11, STA 520, IAW B767-300 SRM 53-00-52, WITHIN SRM LIMITS.SDR HALA0800069Seat Track · damagedSEAT TRACKS DAMAGED AT LOCATION LBL 11 STA 534. DAMAGE REMOVED AT LOCATION LBL 11, STA 534 IAW B767-300 SRM 53-00-52, WITH IN LIMITS.SDR HALA0800068Seat Track · damagedSEAT TRACKS DAMAGED AT LOCATION LBL 11, STA.568. DAMAGE REMOVED IAW B767-300 SRM 53-00-52. WITHIN SRM LIMITS.SDR 08FDEA00072Seat Track · gougedMAIN CABIN SEAT TRACK Y1959 SCALLOPS GOUGED AND ELONGATED FRAME 20 TO 21. BLENDED SCALLOPS IAW FEDEX A310-200 SRM 53-10-16. FOUND TO BE OUT OF LIMITS IAW FEDEX A310-200 SRM 53-10-16. REMOVED ENTIRE DAMAGED SEAT TRACK SECTION FR 18 -FR 26 MADE CUT IAW FEDEX ASDR USAA920080148Seat Track · corrodedSAL - MAJOR REPAIR - C6 CHECK - CORROSION ON CABIN SEAT TRACK, BS 2403 / FR 52, +Y765. REPAIRED CABIN SEAT TRACK, BS 2403 / FR 52, +Y765 IAW A320 SRM 53-00-15 FIGURE 201.SDR CALA0800010Seat Track · corrodedRIGHT O/B SEAT TRACK CORRODED STA 887 TO 927. FABRICATED AND INSTALLED NEW SEAT TRACK SECTION PER SRM 53-00-02 REPAIR 3.SDR KCSA081005Seat Track · crackedFORWARD BILGE SEAT TRACK IS CRACKED BETWEEN STA 540 & 560, RBL 45.SDR ASAA0872459Scuff Plate · corrodedAFT CARGO COMPARTMENT FWD TIE DOWN CORRODED. REMOVED CORROSION IAW B737 SRM 53-00-53 FIG 103 PG 110. CORROSION FOUND TO BE OUT OF LIMITS IAW B737 SRM 53-00-53 FIG 103 PG 110. FABRICATED NEW SCUFF PLATE IAW B737 SRM 51-30-01 PG 22, 23 & 24.SDR CALA0800009Seat Track · corrodedSURFACE CORROSION ON LEFT I/B SEAT TRACK UPPER FLANGE NEXT TO LAV MOUNT STA 916. INSTALLED NEW SEAT TRACK PER SRM 53-00-52 FIG 101.SDR UPS08851561Seat Track · crackedINSPECTION TYPE:C2 MAIN CABIN SEAT TRACK HAS LUG MISSING, LUG CRACKED AND TRACK GOUGED, STA 320 LBL55. REPAIRED MAIN CABIN SEAT TRACK AT STA 320 AND LBL 55 REF SRM 53-02-03- 0 FIG 006D AND SRM 51-3-0.SDR USAA920080267Seat Track · corrodedBFM - MAJOR REPAIR - C4 CHECK, LEVEL 2 CORROSION ON CABIN SEAT TRACK, BS 871 - BS 1109, LBL 88.5. REPLACED CABIN SEAT TRACK, BS 871 - BS 1109, LBL 88.5 IAW B767 SRM 51-40-02.SDR USAA920080266Seat Track · corrodedBFM - MAJOR REPAIR - C4 CHECK, LEVEL 2 CORROSION ON CABIN SEAT TRACK, BS 1098 - BS 1362, LBL 88.5. REPLACED CABIN SEAT TRACK, BS 1098 - BS 1362, LBL 88.5 IAW B767 SRM 51-40-02.SDR USAA920080265Seat Track · corrodedBFM - MAJOR REPAIR - C4 CHECK, LEVEL 2 CORROSION ON CABIN SEAT TRACK, BS 380, LBL 88. REPLACED CABIN SEAT TRACK, BS 380, LBL 88 IAW B767 SRM 51-40-02.SDR USAA920080263Seat Track · corrodedBFM - MAJOR REPAIR - C4 CHECK - LEVEL 2 CORROSION ON CABIN SEAT TRACK, BS 871.5 - BS 1109, RBL 88.55, WL 200. REPLACED CABIN SEAT TRACK, BS 871.5 - BS 1109, RBL 88.55, WL 200 IAW B767 SRM 51-40-02.SDR P5CA0801542Seat Track · crackedMAIN CARGO DECK SEAT TRACK CRACKED AT STATION 1850-1862 RBL 11.33. SCL ACCOMPLISHED INTERIM REPAIR AND MIA ACCOMPLISHED PERMANENT REPAIR PER MA A4 5300-10-00.SDR USAA920080188Seat Track · corrodedSAL - MAJOR REPAIR - C6 CHECK - CORROSION ON CABIN SEAT RAIL, BS 2510 / FR 54, +Y765. REPAIRED CABIN SEAT RAIL, BS 2510 / FR 54, +Y765 IAW A320 SRM 53-00-15.SDR ASAA0842611Cargo Track · gougedFWD CARGO PIT RT TIE DOWN TRACK HAS GOUGED AT BS 460 + 2 RBL 14. FWD CARGO PIT RT TIE DOWN TRACK AT BS 460 REPAIRED IAW B737 400 SRM 53 00 53.SDR ASAA0842578Cargo Track · corrodedAFT CARGO PIT TIE DOWN TRACK LUG FOUND CORRODED AT BS 727 D LBL 17. TIE DOWN LUG REPLACED.SDR ASAA0842576Cargo Track · corrodedAFT CARGO PIT LEFT TIE DOWN TRACK FOUND CORRODED ON LUG AT BS 847 LBL 17. REPAIRED WITH REPAIR PART.SDR ASAA0842622Cargo Track · corrodedAFT CARGO PIT LT TIE DOWN TRACK AT BS 947 LBL 17 FOUND CORRODED. REPAIRED WITH MADE REPAIR PART.SDR ASAA0842572Cargo Track · corrodedAFT CARGO PIT RT TIE DOWN TRACK AT BS 767 TO 827 RBL 13 FOUND CORRODED. TIE DOWN TRACK REPLACED WITH NEW PART.SDR UPS08851636Seat Track · wornINSPECTION TYPE:C2 COCKPIT STA -38 SEAT TRACK IS WORN AND LOCK PIN HOLES ARE WORN. REMOVED AND REPLACED F/E AFT SEAT TRACK IAW SRM 51-03-00, 51-01-24.SDR UPS08851632Seat Track · wornINSPECTION TYPE:C2 CAPT'S FWD I/B SEAT TRACK IS WORN. REMOVED AND REPLACED CAPT'S FWD SEAT TRACKS REF, EO DC8-5340-18315 APPX B.SDR USAA920080268Seat Track · corrodedBFM - MAJOR REPAIR - C4 CHECK, LEVEL 2 CORROSION ON CABIN SEAT TRACK, BS 764 - BS 830, LBL 88.5. REPLACED CABIN SEAT TRACK, BS 764 - BS 830, LBL 88.5 IAW B767 SRM 51-40-02.SDR UPS08851516Seat Track · wornINSPECTION TYPE:C2 COCKPIT STA -52 SEAT TRACK IS WORN AND LOCK PIN HOLES ARE ELONGATED. REMOVED AND REPLACED F/E'S FWD SEAT TRACK AT STA -52 IAW SRM 51-03-00, AND DC8 AMM 25-11-02-0 FIG 002.SDR UPS08851507Seat Track · wornINSPECTION TYPE:C2 CAPT, AFT INBD SEAT TRACK LOCK PIN HOLES ARE WORN. REMOVED AND REPLACED CAPT AFT INBD SEAT TRACK IAW EO DC8-5340-18315 -B.SDR UPS08851506Seat Track · damagedINSPECTION TYPE:C2 CAPT, AFT OUTBD SEAT TRACK LOCK PIN HOLES ARE ELONGATED. REMOVED AND REPLACED CAPT, AFT OUTBD SEAT TRACK IAW EO DC8-5340- 18315-B.SDR UPS08851505Seat Track · damagedINSPECTION TYPE:C2 F/O'S AFT INBD SEAT TRACK LOCK PIN HOLES ARE ELONGATED. REMOVED AND REPLACED F/O'S INBD SEAT TRACK IAW EO DC8-5340-18315-B.SDR UPS08851504Seat Track · damagedINSPECTION TYPE:C2 1ST OFFICERS AFT OUTBD SEAT TRACK LOCK PIN HOLES ARE ELONGATED. REMOVED AND REPLACED 1ST OFFICERS AFT OUTBD SEAT TRACK IAW EO DC8- 5340-1815-B.SDR 08FDEA00042Seat Track · bentLT TRACK Y1456 FR 51, AFTER REMOVAL OF WEB FOUND 1 LINK WITH BENT TAB ON I/B SIDE, REMOVED AND REPLACED SUPPORT LINK AT TRACK Y1456 FR 51 IAW A300-600 SRM 51-40-21.SDR 08FDEA00040Seat Track · crackedFUS FR 53 SEAT TRACK 3L LOWER EDGE CRACKED, 1" WIDE REMOVED AND REPLACED SEAT TRACK 3L FROM FR 46 TO FR 54 IAW A300-600 SRM 51-40-21.SDR 08FDEA00039Seat Track · bentLT TRACK Y1456 FR50, AFTER REMOVAL OF WEB, FOUND 1 LINK TRACK WITH BENT TAB ON I/B SIDE. REMOVED AND REPLACED SUPPORT LINK BRACKET, LT TRACK Y1456 FR50 IAW A300-600 SRM 51-41-21.SDR 08FDEA00038Seat Track · crackedLOWER FUSELAGE FR 53 SEAT TRACK 2L, LOWER EDGE IS CRACKED, 1" WIDE REMOVED AND REPLACED SEAT TRACK 2L FR 46 TO FR 54 IAW A300-600 SRM 51-40-21.SDR TRAX200800036Seat Track · corrodedCORROSION FOUND ON LEFT SEAT TRACK BETWEEN FR 36 TO FR 39. CORROSION ON LEFT SEAT TRACK BETWEEN FR 36 TO 39 REMOVED IAW SRM 51-21-42. REPAIR DETERMINED NOT TO BE A MAJOR REPAIR IN ACCORDANCE WITH SP 663 AND FAR 43, APPENDIX A. REPAIR ACCOMPLISHED IN ACCORDASDR TRAX200800035Seat Track · corrodedCORROSION FOUND ON LEFT SEAT TRACK BETWEEN FR 39 TO FR 41. CORROSION ON LEFT SEAT TRACK BETWEEN FR 39 TO 41 REMOVED IAW SRM 51-21-42. REPAIR DETERMINED NOT TO BE A MAJOR REPAIR IN ACCORDANCE WITH SP 663 AND FAR 43, APPENDIX A. REPAIR ACCOMPLISHED IN ACCORDASDR TRAX200800034Seat Track · corrodedRIGHT SEAT TRACK FOUND CORRODED BETWEEN FR 36-38. CORROSION REMOVED ON FLOORBEAM AT FR 36 AS PER SRM 51-21-42 & WITHIN LIMITS AS PER SRM 53-00-00 FIG 304. REPAIR DETERMINED NOT TO BE A MAJOR REPAIR IN ACCORDANCE WITH SP 663 AND FAR 43, APPENDIX A. REPAIR ACSDR TRAX200800033Seat Track · corrodedRIGHT SEAT TRACK FOUND CORRODED BETWEEN FR 36-38. RIGHT SEAT TRACK CORROSION REMOVED BETWEEN FR 36-38 AS PER SRM 51-21-42 & WITHIN LIMITS AS PER SRM 53-00-00 FIG 304. REPAIR DETERMINED NOT TO BE A MAJOR REPAIR IN ACCORDANCE WITH SP 663 AND FAR 43, APPENDIX ASDR TRAX200800032Seat Track · corrodedRIGHT SEAT TRACK FOUND CORRODED BETWEEN FR 39 TO FR 41. RIGHT SEAT TRACK CORROSION REMOVED BETWEEN FR 39 TO FR 41 AS PER SRM 51-21-42 & WITHIN LIMIT AS PER SRM 53-00-00 FIG 304. REPAIR DETERMINED NOT TO BE A MAJOR REPAIR IN ACCORDANCE WITH SP 663 AND FAR 43,SDR TRAX200800031Seat Track · corrodedRIGHT I/B SEAT TRACK BETWEEN FR 13 TO FR 17 FOUND CORRODED. RIGHT INBOARD SEAT TRACK BETWEEN FR 13 TO 17 CORROSION REMOVED IAW SRM 51-21-42. REPAIR DETERMINED NOT TO BE A MAJOR REPAIR IN ACCORDANCE WITH SP 663 AND FAR 43, APPENDIX A. REPAIR ACCOMPLISHED IN SDR USAA920080264Seat Track · corrodedBFM - MAJOR REPAIR - C4 CHECK, LEVEL 2 CORROSION ON CABIN SEAT TRACK, BS 999 - BS 1065, LBL 11. REPLACED CABIN SEAT TRACK, BS 999 - BS 1065, LBL 11 IAW B767 SRM 51-40-02.SDR SIMA200802113Seat Track · corrodedAIRCRAFT WAS REMOVED FROM SERVICE. DURING A HMBV INSPECTION, THE SEAT TRACK AT B.L. 18.3L WAS FOUND TO BE CORRODED. REMOVED CORRODED SEAT TRACK AND REPLACED WITH NEW PART NUMBER 7253725-193 IAW SAAB SRM CHAPTERS 53-70-60. AIRCRAFT RETURNED TO SERVICE.SDR 08FDEA00023Seat Track · damagedLWR FUSELAGE FR 54 18" LEFT OF CENTER, SEAT TRACK SUPPORT LINK IS BROKEN INTO TWO PIECES. REMOVED AND REPLACED TRACK SUPPORT LINK IAW A300-600 SRM 51-40-21.SDR USAA920080140Seat Track · corrodedPIT - MAJOR REPAIR - BC4 CHECK, CORROSION ON SEAT TRACK, BS 709 / FR 16 - BS 808 / FR 20, -Y1292. REPLACED SEAT TRACK, BS 709 / FR 16 - BS 808 / FR 20, -Y1292 IAW A320 SRM 51-72-00.SDR QXEA200802089Seat Track · damagedPDX - C5 CHECK - RIGHT OUTBOARD SEAT TRACK NR 10 AT FS X393 HAS DAMAGE TO OUTBOARD FLANGE. REPAIRED IAW RD8-53-9958 AND -8 200 SRM 51-20-26.SDR QXEA200802077Seat Track · corrodedPDX - C5 CHECK - LAST NUT PLATE ON RIGHT CENTER SEAT TRACK AT STATION 600.0 HAS CORROSION ON THE UNDER SIDE. REMOVED AND INSTALL NEW NUTPLATE IAW -8 200 SRM 51-40-00.SDR QXEA200802071Seat Track · chafedPDX - C5 CHECK - THERE IS A CHAFED SPOT AT APPROXIMATELY 12" FORWARD OF STATION X387.350 ON THE LEFT OUTBOARD SEAT TRACK. REPAIRED IAW RD8-53-1342 AND -8 200 SRM 51-20-16, 51-20-36.
Back to JASC 5347