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 05FDEA02302Seat Track · corrodedAFT CARGO - RIGHT SEAT TRACK AT STA 1954 FOUND CORRODED. REMOVED AND REPLACED AS PER SRM 51-31-01.SDR 05FDEA02296Seat Track · corrodedMCD SEAT TRACK HAS CORROSION BS 870 TO 950 RBL 26. REMOVED AND REPLACED SEAT TRACK IAW SRM 51-30-2.SDR 05FDEA02295Seat Track · corrodedMCD SEAT TRACK STA 1140-1176 BL-0 HAS CORRODED AREAS. REMOVED AND REPLACED SEAT TRACK IAW SRM 51-30-2.SDR 05FDEA02292Seat Track · corrodedPHANTOM SEAT TRACK STA 740-757.5 LBL-45 CORRODED. REMOVED AND REPLACED SEAT TRACK IAW SRM 51-30-2.SDR 05FDEA02291Seat Track · unknownSEAT TRACK BL 0 STA 360-480 REQUIRES EXTENSION FOR EO 7-5340-7-5002. INSTALLED NEW SEAT TRACK IAW SRM 51-30-2 MAJOR REPAIR.SDR ABXA050194Seat Track · crackedSEAT TRACK RT BUTT LINE 9, FS 200, CRACKED. REMOVED AND REPLACED SEAT TRACK IAW DC-9 SRM 51-30-1.SDR 05FDEA02276Seat Track · crackedSEAT TRACK AT STA 720 X= 57 FOUND CRACK .5 INCH. REPAIR IAW SRM 53-70-00 FIG 4A VOL I.SDR 176Seat Track · corrodedCORROSION ON SEAT TRACKS LT SIDE IB AND OB AT BS 780 - 800. S/O 283001, DELTA NR NR21386.SDR 05FDEA02273Seat Track · corrodedMAIN CABIN SEAT TRACK FROM STA 1381 TO 1701 AND AT STA 1951 X= -107 CORRODED. REPAIR IAW SRM 53-70-00 FIG 5 VOL I.SDR 05FDEA02265Seat Track · crackedUPPER CARGO SEAT TRACK RBL 47 CRACKED AT STATION 6-20. UPPER CARGO SEAT TRACK RBL 47 CRACKED AT STATION 6-20 REPAIRED AS PER SRM 53- 70-00 FIGURE 1 VOLUME I. THIS REPAIR IS CLASSIFIED AS MAJOR PER GMM 6-2-100.SDR 05FDEA02264Seat Track · corrodedUPPER CARGO SEAT TRACK RBL 47 CORRODED AT STATION 1441. CARRIED OUT REPAIR AS PER SRM 53-70-00.SDR SIMA200522008Seat Track · corrodedTHE SEAT TRACK AT BL 36R WAS FOUND CORRODED. REMOVED EXISTING SEAT TRACK AT BL 36R. CLEANED AND TREATED NEW SEAT TRACK. REPAIR DONE IAW SAAB 340B SRM, SRM 72LKS 3079, CHAPTERS 51-40-21, 51-40-22, 51-40-25 AND 51-40-40. (M)SDR 05FDEA02263Seat Track · crackedMAIN DECK CARGO COMPARTMENT, FLOOR SEAT TRACK AT STA 635, X= 27 FOUND CRACKED APPROXIMATELY 3 INCHES LONG. REMOVED AND REPAIR SEAT TRACK AND SPLICES FABRICATED. HFEC INSPECTION CARRIED OUT AS PER NDT SPM 06-10-01-001. FOUND NO CRACKED. REPAIR PARTS TREATESDR 05FDEA02262Seat Track · crackedMAIN DECK CARGO COMPARTMENT, FLOOR SEAT TRACK AT STA 635, X= - 8.5 FOUND CRACKED APPROXIMATELY 3 INCHES LONG. REMOVED AS PER SRM 53-70-00. REPAIR SEAT TRACK AND SPLICES FABRICATED, HFEC INSPECTION CARRIED OUT. FOUND NO CRACK FOUND. INSTALLED AS PER SRM 53-SDR 05FDEA02261Seat Track · crackedMAIN DECK CARGO COMPARTMENT, FLOOR SEAT TRACK AT STA 635, X= 8.5 FOUND CRACKED APPROXIMATELY 3 INCHES LONG. REMOVED AS PER SRM 53-70-00 VOLUME I, FIGURE 1. REPAIR SEAT TRACK AND SPLICES FABRICATED AS PER SRM 53-70-00 VOLUME I, FIGURE 1. HFEC INSPECTION CARSDR 05FDEA02259Seat Track · corrodedUPPER CARGO SEAT TRACK LBL 11 CORRODED AT STA 1791. CORROSION REMOVED AS PER SRM 51-21-01.SDR 05FDEA02258Seat Track · crackedUPPER CARGO SEAT TRACK RBL 47 CRACKED AT STA 1309. REPAIRED AS PER SRM 53-700-00.SDR 05FDEA02257Seat Track · crackedUPPER CARGO SEAT TRACK LBL 11 CRACKED AT STA 633. UPPER CARGO SEAT TRACK LBL 11 AT STA 633 CARRIED OUT REPAIR AS PER SRM 53-70- 00 VOLUME I FIGURE 1. REPAIR IS CLASSIFIED MAJOR AS PER GMM 6-2-100.SDR 05FDEA02255Seat Track · corrodedMAIN DECK, SEAT TRACK LBL 11 CORRODED AT STA 859.SDR 05FDEA02254Seat Track · crackedMAIN DECK, SEAT TRACK LBL 47 CRACKED AT STA 939. REPAIR CARRIED OUT AS PER SRM 53-70-00.SDR USAA050931Seat Track · corrodedPIT - FOUND SEAT TRACK CORRODED 1 INCH DIAMETER, Y-765, ABOVE C-20. DEFECTIVE PART REPLACED WITH IDENTICAL PART. (M)SDR 05FDEA02178Seat Track · crackedONE CRACK 2 INCHES LONG INSIDE TRACK AND FORMED PART AT STA 1019 X=-27 MAIN CABIN FLOOR PANEL. REPAIR SEAT TRACK PER SRM 53-70-00 FIG 1 VOL 1.SDR CA051101008Fitting · corroded(CAN) THE CORROSION TASK C53-107-01-01.7 IS INSPECTING THE CABIN SEAT TRACKS. THE CORROSION WAS FOUND ON THE UPPER DECK CARGO G NET FITTING P/N 65-62157-505. THE FOLLOWING INSPECTIONS OF THIS FITTING HAVE BEEN INCORPORATED IN THE MAINTENANCE PROGRAM 1) ADDITISDR 05FDEA02145Seat Track · corrodedMAIN DECK CARGO SEAT TRACK AT FRAME 41 TO 45 RBL 40 HAS CORROSION ALONG LENGTH NOTED. REMOVED CORRODED SEAT TRACK SECTION IAW SRM 53-10-16. FABRICATED NEW SEAT TRACK SECTION ON TRAVELER T5/534306. LOCATED AND DRILLED SECTION IAW SRM 53-10-16 AND 51-40-44. SDR 05FDEA02144Seat Track · corrodedMAIN DECK CARGO SEAT TRACK AT FRAME 41 TO 44 BL0 HAS CORROSION ALONG LENGTH NOTED. REMOVED SEAT TRACK, FABRICATED NEW SEAT TRACK ON TRAVELER NR T5/534305 IAW SRM 53-15-16. LOCATED AND DRILLED IAW SRM 53-10-16. TREATED AND PRIMED IAW SRM 51-21-10. INSTALLEDSDR ASOA05710Seat Track · corrodedDURING A C-CHECK IN YUL, THE SEAT TRACKS BETWEEN FRAME 36 TO FRAME 39 LEFT/RIGHT WERE FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACKS BETWEEN FRAME 36 TO FRAME 39 LEFT/RIGHT IAW ATR72 SRM 51-21-42 AND 51-25-04. (M)SDR ASOA05711Seat Track · corrodedDURING A C-CHECK IN YUL, THE SEAT TRACK BETWEEN FRAME 39 TO FRAME 40 RIGHT WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK BETWEEN FRAME 39 TO FRAME 40 RIGHT IAW ATR 72 SRM 51-25-04. (M)SDR ASOA05712Seat Track · corrodedDURING A C-CHECK IN YUL, THE SEAT TRACK BETWEEN FRAME 39 TO FRAME 41 WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK BETWEEN FRAME 39 TO FRAME 41 IAW ATR 72 SRM 51-25-04. (M)SDR USAA050935Seat Track · corrodedPIT - FOUND DUMMY RAIL CORRODED 1 INCH EACH THREE AREAS, C-16 Y510. CORROSION LEVEL 1, TASK JA-220-53500. INSTALLED/REPLACED DUMMY RAIL PER SRM 53-00-14 FIG 201. (M)SDR MALA050630Seat Track · corrodedDURING 4K INSPECTION IN BNA, SEAT TRACK AT BLO FROM FS 294-FS 310 IS CORRODED AND HAS BEEN REPAIRED IAW MESABA EO NR 53309. REF: EAMS WORK ORDER #212637 TASK 1509.SDR MALA050631Seat Track · corrodedDURING 4K INSPECTION IN BNA, SEAT TRACK AT LBL 18.3 FROM FS 294-FS 310 IS CORRODED AND HAS BEEN REPAIRED IAW MESABA EO NR 212637 TASK 110.SDR MALA050616Seat Track · corrodedSEAT TRACK AT BL 0 FROM FS 294 TO FS 310 IS CORRODED AND HAS BEEN REPAIRED IAW SRM 53-70-60. REF EAMS WORK ORDER 212637 TASK 1509.SDR MALA050615Seat Track · corrodedSEAT TRACK AT LBL18.3 FROM FS 294 TO FS 310 IS CORRODED AND HAS BEEN REPAIRED IAW SRM 53-70-60 REF: EAMS WORK ORDER 21-26-37 TASK 1510.SDR 05FDEA02135Seat Track · corrodedSEAT TRACK AT Y953 FR 17-19 IS CORRODEDSDR 05FDEA02134Seat Track · corrodedSEAT TRACK AT Y953 FR 17-19 IS CORRODED.SDR 05FDEA02123Seat Track · corrodedSEAT TRACK STA 344-480 RBL 45 CORRODED. REMOVED AND REPLACED SEAT TRACK IAW SRM 51-30-2.SDR ASOA05637Seat Track · corrodedDURING C-CHECK, THE LT SIDE WALL SEAT RAIL (TRACK) AT FS 559 +64 ABOVE THE BLOWOUT PANEL WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE LT SIDE WALL SEAT RAIL (TRACK) AT FS 559 +64 IAW SRM. (K)SDR 05FDEA02101Seat Track · corrodedMDCC SEAT TRACK FROM FRAME 54.2-54.3, BL-0 HAS 2 PLACES OF CORROSION REMOVED CORROSION IAW SRM 53-10-16 FOUND SEAT TRACK TO BE OUT OF LIMITS. FABRICATED SEAT TRACK ON TRAVELER NR T5/532242 IAW SRM 53-10-16 TREATED AND PRIMED IAW SRM 51-21-10. FABRICATED SDR DHL2005366501Seat Track · corrodedDURING C-CHECK, COCKPIT SEAT TRACK WORN OUT OF LIMITS AT COPILOT SEAT AFT O/B, FLIGHT ING AND FWD TRACK FOR FIRST OBSERVER SEAT. REMOVED AND REPLACED COCKPIT TRACKS AT COCKPIT; AFT O/B,FLIGHT ING: O/B TRACK AND FIRST OBSERVER; FWD TRACK AS PER A-300 M/M 53-41SDR UPS05444990Seat Track · corrodedSTA 700-710 LBL 66 SEAT TRACK FOUND CORRODED. CORROSION BLEND OUT 0.042 X 1 X 4 EXCEED SRM 53-10-01 FIG 1 LIMIT, SEAT TRACK REPAIRED AS PER SRM 53-10-05 FIG 1A.SDR MALA050608Seat Track · corrodedSEAT TRACK AT FS640 AND BL 0 IS CORRODED AND HAS BEEN REPAIRED IAW MESABA EO NR S53079.SDR 05FDEA02094Seat Track · corrodedSEAT TRACK AT R-2, -Y953 FR 55 TO 56 IS CORRODED OUT OF LIMITS. REMOVED AND REPLACED WITH NEW SEAT TRACK IAW SRM 53-10-16 FIG 201 REF TRAVELER T5/533734.SDR 05FDEA02093Seat Track · corrodedSEAT TRACK BL-0 FR 72.5 CORRODED OUT OF LIMITS. CUT OUT THE DAMAGED SEAT TRACK SECTION IAW SRM 53-10-16. FABRICATED NEW SEAT TRACK AND INSTALLED NEW SEAT TRACK IAW SRM 53-10-16 REF TRAVELER T5/533030.SDR 05FDEA02092Seat Track · corrodedSEAT TRACK AT BL-0 FR 70.5 IS CORRODED OUT OF LIMITS. CUT OUT THE DAMAGED SEAT TRACK SECTION IAW SRM 53-10-16. FABRICATED AND INSTALLED NEW SEAT TRACK IAW SRM 53-10-16 REF TRAVELER T5/533029.SDR 05FDEA02058Seat Track · corrodedSEAT TRACK AT Y450 FR 15 IS CORRODEDSDR UPS05845148Seat Track · corrodedFE'S AFT SEAT TRACK STOP HOLES WORN AND HEAVY CORROSION AROUND COUNTER SUNK ATTACH SCREWS. REMOVED AND REPLACED FE'S AFT SEAT TRACK IAW DC-8 SRM 51-1-21, 51-3-2, AND 51-3-0.SDR 05FDEA02044Seat Track · corrodedSEAT TRACK BL 0 FROM FRAME STA 45 TO 53 CORRODED IN SEVERAL AREAS. REMOVED DAMAGED SEAT TRACK SECTION, FABRICATED DRILLED AND DEBURRED HOLES IN SEAT TRACK REPLACEMENT AND SPLICE SET. TREATED AND PRIMED ALL PARTS IAW SRM 51-23-10. INSTALLED NEW SEAT TRACKSDR 05FDEA02031Seat Track · corrodedMAIN DECK CARGO SEAT TRACK AT FRAME 41 TO 44 RBL 20, HAS CORROSION ALONG LENGTH NOTED. REMOVED SEAT TRACK, LOCATED AND DRILLED IAW SRM 53-10-16. INSTALLED NEW SEAT TRACK IAW SRM 53-10-16.SDR MALA0596Seat Track · corrodedDURING 4Y/2Y CHECK IN BNA FOUND SEAT TRACK AT LBL 18.3 AND BETWEEN FS297 AND 310 IS CORRODED AND HAS BEEN REPAIRED IAW SRM 53-70-60. REF: EAMS WORK ORDER 212650 TASK 2512SDR MALA050595Seat Track · corrodedDURING 4Y/2Y CHECK IN BNA FOUND LAV SEAT TRACK PN 7253721-459 IS CORRODED AND HAS BEEN REMOVED AND REPLACED IAW SRM 51-40-27 REF: EAMS WORKORDER 212650 TASK 2511
Back to JASC 5347