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 DLM90070872Seat Track · corrodedSEAT TRACK RBL 22 BLENDED OUT OF LIMITS AT FS 850. REMOVED DAMAGED SECTION OF TRACK BETWEEN FS 722-850. SPLICED IN NEW SECTION IAW MD90 SRM 53-40-01 FIG 6.SDR ASAA0781845Seat Track · damagedSEAT TRACK HAS DOUBLE DRILLED HOLES. REMOVED DAMAGED SECTION OF TRACK, LOCATED, DRILLED AND INSTALLED A REPLACEMENT TRACK IAW SRM 53-05 PG 11 FIG 4H, 51-10-4 PG 1 AND 51-30-5 PG 1 AND 51-30-1 PG 1.SDR ASAA0781839Seat Track · corrodedCABIN SEAT TRACK CORRODED. REPLACED DAMAGED SECTION OF TRACK PER SRM 51-10-4, 53-05 AND 51-30-5.SDR UPS07M50729Seat Track · corrodedINSPECTION TYPE:C CORROSION ON SEAT TRACK CROWN, CHANNEL & FLANGE FROM STA 839-939 X=-75. CABIN SEAT TRACK X=-75, STA 839-939, CROWN CHANNEL & FLANGE AREA CORR RMVD & AREA REPROTECTED SRM 51-21-01 VII R38. FLANGE ORG THK 0.080" MAT'L REMND 0.042". MATL RMVSDR UPS07M50199Seat Track · corrodedINSPECTION TYPE:C CORROSION ON SEAT TRACK CROWN & FLANGE AT STA 815-865 X=-8. CABIN SEAT TRACK X=-8 STA 815-865 CORROSION REMOVED & REPROTECTED SRM 512101VIIR38 . CHNNL ORG THK 0.100" MATL REMN 0.075" MATL REMV 0.025". EXCEEDS LIMIT. CORRODED SEAT TRACK CUTOSDR 07FDEA02338Seat Track · corrodedSEAT TRACK BALL MAT AREA CRACK 4" LONG AND SEVERE CORROSION WITH EXFOLIATION ON SEAT TRACK. REPAIRED AREA IAW SRM 53-70-00 FIG 1 VOL 1 7 SRM 53-60-00 FIG 2-11 VOL 1.SDR 07FDEA02335Seat Track · corrodedMAIN CABIN SEVERE CORROSION WITH EXFOLIATION ON SEAT TRACK. REPAIRED SEAT TRACK IAW SRM 53-70-00 FIG 1 VOL 1.SDR 07FDEA02333Seat Track · crackedMAIN CABIN CRACK 1' LONG ON SEAT TRACK. REPAIRED IAW SRM 53-70-00 FIG 1 VOL 1.SDR DLM90070929Seat Track · corrodedSEAT TRACK STA. 655.760 LBL 24 FOUND CORRODED OUT OF LIMITS. REPAIRED PER SRM 53-40-01 REF AAR N/R 2700-0146.SDR DLM90070873Seat Track · corrodedSEAT TRACK FS 655-760 LBL 24 FOUND TO BE CORRODED OUT OF LIMITS. REPAIRED SEAT TRACK IAW MD-90 SRM 53-40-01.SDR 07FDEA02300Seat Track · corrodedMAIN CARGO DECK, RT, SEAT TRACK AT -Y953, BETWEEN FR 55 (BS 3566) AND FR 57.2 (BS 3778) IS CORRODED. REMOVED AND REPLACED CORRODED SEAT TRACK SECTION, FR 54.2 TO FR 58, IAW A300-600 SRM 53-10-16 FIG 201. NEW SEAT TRACK SECTION LOCATED AND DRILLED IAW A300-6SDR 07FDEA02294Seat Track · corrodedCABIN, LBL 25 SEAT TRACK IB FLANGE HAS CORROSION ON UPPER SURFACE BETWEEN BS 400 AND BS 460. REMOVED CORROSION IAW B727 SRM 51-10-1, ORIGINAL .080", REMAINING .059" REF EA NR 7- 5310-113056, ROTO PEENED SEAT TRACK FLANGE AT STA 400-460 LBL 25. TREATED AND PSDR QXEA200701060Seat Track · corrodedC4 PDX - CABIN UNDER FLOOR LEFT AT FRAME X201.300 AND AT STRINGER 31L, STRINGER FITTING TO LEFT SEAT TRACK LOWER CHANNEL SUPPORT HAS CORROSION AT FASTENERS. REPAIRED IAW SRM 51-20-11, 51-40-11, 51-20-36.SDR AWXA200700777Seat Track · corrodedSAL - MAJOR REPAIR - CORROSION ON CABIN SEAT TRACK, -Y765, FR 41 + 10.5", FR 42, FR 42 + 18", FR 46 + 16". REPLACED CABIN SEAT TRACK, -Y765, FR 41 - FR 47 IAW A320 SRM 51-72-11.SDR AWXA200700776Seat Track · corrodedSAL - MAJOR REPAIR - CORROSION ON CABIN SEAT TRACK, -Y765, FR 38 +13", FR 39+ 4.5" AND FR 40+ 14". REPLACED CABIN SEAT TRACK, -Y765, FR 36 - FR 41 IAW A320 SRM 51-72-11.SDR QXEA200701032Seat Track · corrodedC4 PDX - CABIN UNDER FLOOR CENTER AT FRAME X488.5 AND STRINGER 31L, THE VERTICAL SEAT RAIL SUPPORT CHANNEL HAS CORROSION ON THE FORWARD SIDE BETWEEN FRAME AND SUPPORT. REPAIRED IAW SRM 51-20-11, 51-20-16.SDR SIMA200719412Seat Track · corrodedLEFT INBOARD SEAT TRACK CORRODED BETWEEN FRAMES 47 TO 53. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-01-06. OPERATIONAL CHECK GOOD. RETURNED AIRCRAFT TO SERVICE.SDR SIMA200719410Seat Track · corrodedLEFT INBOARD SEAT TRACK CORRODED BETWEEN FRAMES 47 TO 53. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-01-06. OPERATIONAL CHECK GOOD. RETURNED AIRCRAFT TO SERVICE.SDR SIMA200719409Seat Track · corrodedLEFT INBOARD SEAT TRACK CORRODED BETWEEN FRAMES 23 TO 28. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-01-06. OPERATIONAL CHECK GOOD. RETURNED AIRCRAFT TO SERVICE.SDR SIMA200719407Seat Track · corrodedLEFT INBOARD SEAT TRACK CORRODED BETWEEN FRAMES 36 TO 47. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-01-06. OPERATIONAL CHECK GOOD. RETURNED AIRCRAFT TO SERVICE.SDR SIMA200719406Seat Track · corrodedLEFT INBOARD SEAT TRACK CORRODED BETWEEN FRAMES 19 TO 23. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-01-06. OPERATIONAL CHECK GOOD. RETURNED AIRCRAFT TO SERVICE.SDR SIMA200719405Seat Track · corrodedRIGHT INBORAD SEAT TRACK CORRODED BETWEEN FRAMES 47 TO 53. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-01-06. OPERATIONAL CHECK GOOD. RETURNED AIRCRAFT TO SERVICE.SDR SIMA200719411Seat Track · corrodedRIGHT INBOARD SEAT TRACK CORRODED BETWEEN FRAMES 36 TO 47. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-01-06. OPERATIONAL CHECK GOOD, RETURNED AIRCRAFT TO SERVICE.SDR SIMA200719408Seat Track · corrodedRIGHT INBORAD SEAT TRACK CORRODED BETWEEN FRAMES 23 TO 28. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-01-06. OPERATIONAL CHECK GOOD. RETURNED AIRCRAFT TO SERVICE.SDR SIMA200719212Seat Track · corrodedRIGHT OUTBOARD SEAT TRACK CORRODED BETWEEN FRAMES 47 AND 53. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-01-06. AIRCRAFT RETURNED TO SERVICE.SDR SIMA200719211Seat Track · corrodedLEFT OUTBOARD SEAT TRACK CORRODED BETWEEN FRAMES 36 AND 47. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-01-06. AIRCRAFT RETURNED TO SERVICE.SDR SIMA200719213Seat Track · corrodedLEFT OUTBOARD SEAT TRACK CORRODED BETWEEN FRAMES 47 AND 53. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-01-06. AIRCRAFT RETURNED TO SERVICE.SDR SIMA200719210Seat Track · corrodedLEFT INBOARD SEAT TRACK CORRODED BETWEEN FRAMES 36 AND 47. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-01-06. AIRCRAFT RETURNED TO SERVICE.SDR DLM90070871Seat Track · corrodedSEAT TRACK CORRODED OUT OF LIMITS RBL 22 AND STA 579. FABRICATED AND REPLACED SEAT TRACK STA 522-579 AT RBL 22 IAW MD90 SRM 53-40-01 FIG 6.SDR 2007UALA02161Seat Track · corrodedAFT RT LAV AREA FLOOR STRUCTURE OB SEAT TRACK STA 995-1016 LBL 39 LBL40 WL 208-208 UPPER SURFACE HAS CORROSION. REMOVED AND REPLACED FLOOR TRACK AND WEB.SDR 07FDEA02241Seat Track · corrodedAFT UPPER MAIN DECK, CORROSION ON SEAT TRACK LWR O/B UPPER SURFACE STA 950 LBL 26K. REMOVED CORROSION REF SRM 51-10-1, VERIFIED REMAINING MATERIAL WITHIN LIMITS REF SRM 53-10-1 FIG 3. TREATED AND PRIMED REF MM 51-20-002-7.SDR 07FDEA02240Seat Track · corrodedAFT UPPER MAIN DECK, SEAT TRACK HAS CORROSION, ON UPPER INBD FLANGE, STA 1070 2 LBL 45. REMOVED CORROSION ORIG THICKNESS .530. REMOVED .036, REMAINING .494" MATERIAL. REMOVED IS WITHIN LIMITS. TREATED AND APPLIED PRIMER REF SRM 53-10-1 PG 13-17.SDR 07FDEA02237Seat Track · corrodedRBL SEAT TRACK HAS CORROSION BETWEEN UPPER CHANNEL AND LWR MOUNT FLANGE STA 783-849. REMOVED CORROSION REF SRM 53-10-1 FIG 3 SHT 5. .015" MAT. REMOVED. OUT OF LIMITS REF SRM 53-10-1 FIG 3. REMOVED FLOORBEAM AND SEAT TRACK BS 740 TO 850 RBL 45. FABRICATED NSDR 07FDEA02232Seat Track · corrodedMAIN DECK CARGO COMPARTMENT FLOOR SEAT TRACK AT BS 5-23 TO 5-33 LT X = 75 FOUND WITH CORROSION. [06-29-07] REPAIR CARRIED OUT AS PER SRM 53-70-00 FIG.1 VOL.I. REPAIR CLASSIFIED AS MAJOR REPAIR AS PER FEDEX GMM 6-2-100.SDR 07FDEA02198Seat Track · crackedMAIN DECK, SEAT TRACK AT STA 755, X= -27 FOUND CRACK AT LOWER SURFACE. [06-29-07] REPAIR CARRIED OUT AS PER SRM 53-70-00 FIG.1 VOL.I. REPAIR CLASSIFIED AS MAJOR REPAIR AS PER FEDEX GMM 6-2-100.SDR SWIA200718462Seat Track · corrodedLEFT SIDEWALL FORWARD SEAT TRACK IS CORRODED, DISCOVERED AT C-CHECK. REPLACED THE LEFT SIDEWALL SEAT TRACK IAW EMB SERVICE LETTER EST-186/96 AND MM 20-10-03.SDR SWIA200718461Seat Track · corrodedRIGHT SIDEWALL FORWARD SEAT TRACK IS CORRODED, DISCOVERED AT C-CHECK. SPLICED IN A NEW SECTION OF TRACK IAW EMB SERVICE LETTER EST-186/96 AND MM 20-10-03.SDR 07FDEA02186Seat Track · corrodedAFT COMPARTMENT, TRACK Y140 WITH DEEP CORROSION BETWEEN FR 61 AND FR 62. THE TRACK WAS REPLACED IN ACCORDANCE WITH AMM 25-52-21.SDR 07FDEA02185Seat Track · corrodedAFT COMPARTMENT, TRACK Y14710 WITH CORROSION BETWEEN FR 61 AND FR62. THE TRACK WAS REPLACED IN ACCORDANCE WITH AMM 25-52-21.SDR 07FDEA02184Seat Track · wornMDCC - FLOOR - WEAR AT TRACK Y-1456 BETWEEN FR 62 AND 63. REPAIRED IN ACCORDANCE WITH SRM 53-10-16 FIG 208 SHEET 1 - PAGE 243 TO 248.SDR 07FDEA02183Seat Track · corrodedMDCC - TRACK WITH CORROSION BETWEEN FRAMES 15A AND 19 AT Y-1959. THE CORRODED PART WAS REPLACED IN ACCORDANCE WITH SRM 51-72-10.SDR HALA07431Seat Track · corrodedLEVEL 1 CORROSION AT SEAT TRACK RBL 59 AT STA. 69, AREA REWORKED AND FOUND WITHIN LIMITS PER SRM 53-00-52. REWORKED AREA ALODINED AND PAINTED.SDR SIMA200719207Seat Track · corrodedLEFT OUTBOARD SEAT TRACK CORRODED BETWEEN FRAMES 36 AND 47. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-01-06. AIRCRAFT RETURNED TO SERVICE.SDR SIMA200719208Seat Track · corrodedLEFT AFT OUTBOARD SEAT TRACK CORRODED BETWEEN FRAMES 47 AND 53. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-01-06. AIRCRAFT RETURNED TO SERVICE.SDR SIMA200719206Seat Track · corrodedRIGHT OUTBOARD SEAT TRACK CORRODED BETWEEN FRAMES 36 AND 47. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-01-06. AIRCRAFT RETURNED TO SERVICESDR SIMA200719205Seat Track · corrodedRIGHT OUTBOARD SEAT TRACK CORRODED BETWEEN FRAMES 28 AND 36. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-01-06. AIRCRAFT RETURNED TO SERVICE.SDR SIMA200719209Seat Track · corrodedLEFT FOWARD OUTBOARD SEAT TRACK CORRODED BETWEEN FRAMES 17 AND 23. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-01-06. AIRCRAFT RETURNED TO SERVICE.SDR NOCA11407Seat Track · corrodedSEAT TRACK CORROSION BEYOND SRM LIMITS NUMEROUS LOCATIONS 962 - 1095. REMOVED AND REPLACED SEAT TRACK AS PER SRM 53-00-52.SDR NOCA11307Seat Track · corrodedCORROSION ON SEAT TRACK OUT OF SRM LIMITS AT NUMEROUS LOCATIONS FROM STA 960 - 1085. REMOVED AND REPLACED SEAT TRACK AS PER MM 53-00-52.SDR NOCA12807Mount · corrodedAFT INBOARD GALLEY FLOOR MOUNT CORRODED. REPLACED GALLEY FLOOR MOUNT PER SRM 53-11-54.
Back to JASC 5347