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 CALA9800443Tie Down · corrodedINSPECTION FOUND RT TIE DOWN STRIP CORRODED AT STA 794.3 TO 847. THE RT CARGO TRACK WAS CUT AND SPLICED IAW SRM 53-00-53, FIGURE 202.SDR AWXA9800080Floor Track · corrodedNR 2 AND 3 FLOOR TRACK STN 808 FR 20 REPLACED DUE CORROSION BEYOND SRM LIMITS. SPLICED IN FLOOR TRACK AS PER SRM 53-00-15 PAGE 201.SDR CALA9800423Floor Track · corrodedINSPECTION FOUND CABIN FLOOR TRACK CORRODED AT STA 1050 TO 1130, BL 25R. THE CORRODED SECTION OF FLOOR TRACK WAS REPLACED IAW SRM 53-10-5 AND 51-10-1.SDR CALA9800422Floor Track · corrodedINSPECTION FOUND CABIN FLOOR TRACK CORRODED AT STA 1100, BL 45R. THE CORRODED SECTION OF FLOOR TRACK WAS REMOVED AND REPLACED IAW SRM 53-10-5.SDR UPS98826143Seat Track · corrodedINSPECTION TYPE:C STA.300, RBL59, THE SEAT TRACK IS CORRODED BEYOND LIMITS. REMOVED AND REPLACED SEAT TRACK FROM STA 280-330 IAW SRM 53-2-3.SDR P5CA9800548Seat Track · corrosionLEVEL 1 CORROSION ON MAIN DECK BS 2190 LBL 11 SEAT TRACK. REPLACED TRACK PER SRM 53-10-05 FIG 14.SDR P5CA9800544Seat Track · corrodedLEVEL 1 CORROSION ON UPPER DECK SEAT TRACK BS 502 THRU 530 LBL 9. REMOVED CORROSION PER SRM 51-10-01 AND TRACK REPAIRED PER SRM 51-10-05.SDR AWXA9800079Seat Track · corrodedNR 4 SEAT TRACK REPLACED FROM STN 808 FRO 20 TO STN 950 FRA 24 DUE CORRODED BEYOND SRM LIMITS. SPLICED IN FLOOR TRACK AS PER ER 32-53:12-17.SDR AWXA9800075Floor Track · corrodedDURING SCHEDULED C-3 INSPECTION, REPLACED NR 2 AND NR 3 FLOOR TRACK STN 808 FR 20 DUE TO CORROSION BEYOND SRM LIMITS. SPLICED IN FLOOR TRACK PER SRM 53-00-15, PAGE 201.SDR AWXA9800074Seat Track · corrodedDURING SCHEDULED C-3 INSPECTION, NR 4 SEAT TRACK REPLACED FROM STN 808 FR 20 TO STN 950 FR 24 DUE TO CORROSION BEYOND SRM LIMITS. SPLICED IN FLOOR TRACK PER ER 32-53-12-17.SDR SIMA980701Seat Track · corrodedSAW - DURING CPCP-8 INSPECTION, MAINTENANCE REPORTED THE LEFT AFT INBOARD, LEFT AFT OUTBOARD AND THE LEFT AFT FLIGHT ATTENDANT SEAT TRACKS WERE CORRODED. MAINTENANCE REMOVED AND REPLACED THE THREE SEAT TRACKS IAW SRM 51-25-04. A/C WAS RETURNED TO SERVICE. (SDR P5CA9800573Seat Track · corrosionLEVEL 1 CORROSION ON MAIN DECK SEAT TRACK BS 920 RBL 97R. CORROSION REMOVED AND REPAIRED PER SRM 53-10-05 FIG 14.SDR MWEA98342Seat Track · corrodedLEFT HAND OUTBOARD SEAT TRACK WAS FOUND CORRODED OUT OF SERVICEABLE LIMITS FROM FS 570 TO 965. REMOVED AND REPLACED SECTION OF TRACK.SDR MWEA98341Seat Track · corrodedRIGHT HAND INBOARD SEAT TRACK WAS FOUND TO HAVE CORROSION FROM FS 200 TO 584. REMOVED AND REPLACED SEAT TRACK SECTION.SDR MWEA98339Seat Track · corrodedRIGHT HAND INBOARD SEAT TRACK WAS FOUND CORRODED FROM FS 579 TO 965. REMOVED AND REPLACED SEAT TRACK.SDR 98ZZZM447Seat Track · corrodedSAW - DURING CPCP-8 INSPECTION, MAINTENANCE REPORTED THE LEFT AFT INBOARD, LEFT AFT OUTBOARD AND THE LEFT AFT FLIGHT ATTENDANT SEAT TRACKS WERE CORRODED. MAINTENANCE REMOVED AND REPLACED THE THREE SEAT TRACKS IAW SRM 51-25-04. A/C WAS RETURNED TO SERVICE. (SDR 98ZZZM446Seat Track · corrodedSAW - DURING CPCP-8 INSPECTION, MAINTENANCE REPORTED THE LEFT AFT INBOARD, LEFT AFT OUTBOARD AND THE LEFT AFT FLIGHT ATTENDANT SEAT TRACKS WERE CORRODED. MAINTENANCE REMOVED AND REPLACED THE THREE SEAT TRACKS IAW SRM 51-25-04. A/C WAS RETURNED TO SERVICE. (SDR UPS98826149Seat Track · corrodedINSPECTION TYPE:C STA 1230 AT LBL 59, THE SEAT TRACK IS CORRODED ALSO AT STA 1290. REMOVED, FABRICATED AND INSTALLED REPLACEMENT SECTION OF TRACK FROM STA 1130 TO 1270 IAW SRM 53-2-3.SDR UPS98826147Seat Track · corrodedINSPECTION TYPE:C STA 580 AT LBL 59, THE SEAT TRACK IS CORRODED. REMOVED, FABRICATED AND INSTALLED REPLACEMENT SECTION OF TRACK IAW SRM 53-2-3.SDR UPS98826145Seat Track · corrodedINSPECTION TYPE:C STA 1045 AT BLO, THE SEAT TRACK HAS HEAVY CORROSION, THE LOCK TANG ON RT SIDE IS CRACKING. REMOVED FABRICATED REPLACEMENT SECTION OF TRACK FROM STA 990-1070 IAW SRM 53-2-3.SDR UPS98826142Seat Track · corrodedINSPECTION TYPE:C 2ND OBSERVERS FWD SEAT TRACK HAS HEAVY CORROSION, AROUND THE MOUNTING SCREWS. REMOVED AND REPLACED SEAT TRACK IAW SRM 51-3-1.SDR UPS98826140Seat Track · corrodedINSPECTION TYPE:C STA 510 TO 550 BL 0, THE SEAT TRACK HAS HEAVY CORROSION. REMOVED DAMAGED SECTION OF SEAT TRACK AND SPLICED REPLACEMENT SECTION FROM STA 430 TO 550 BL O IAW 53-2-3 FIG. 14.SDR AALA980488Seat Track · corrodedTUL - FOUND SEAT TRACK NR 3 BETWEEN FRAME 31 AND 32 HAS DEEP CORROSION. INSTALLED NEW SEAT TRACK FROM FRAME 25 - FRAME 33 PER AARD 51-10-00-3 AND 51-70-00-1 AND 51-40-00-1 AND SRM 51-21-20 AND 51-22-00 AND 51-24-00 AND 51-72-10-0 AND 51-40-30 AND 53-10-16-2. SDR AALA980485Seat Track · corrodedTUL - FOUND CORROSION ON SEAT TRACK 6 INCH AFT OF FRAME 15A, 18 INCHES RT OF CENTER LINE. REPAIRED PER ESO30595, DATED 3-9-98, INSTALLED STAINLESS STRAP. (M)SDR AALA980483Floor Track · corrodedTUL - DURING C-CHECK, FOUND CORROSION FLOOR TRACK NR 4 AT FRAME 14 IN FORWARD CABIN. REMOVED CORROSION AND INSTALLED REPAIR STRAPS PER AARD 53-20-00-2 AND ESO 30595, DATED 3-9-98. (M)SDR MWEA98329Seat Track · corrodedLEFT HAND INBOARD SEAT TRACK WAS FOUND CORRODED OUT OF LIMITS FROM FS 531 TO FS 965. REMOVED AND REPLACED SEAT TRACK.SDR MWEA98328Seat Track · corrodedRT OUTBOARD SEAT TRACK WAS FOUND CORRODED OUT OF LIMITS FROM FS 880 TO FS 965. REMOVED AND REPLACED SECTION OF TRACK.SDR AALA980481Seat Track · corrodedTUL - FOUND CORROSION UNDER LAV 'M' SUPPORT, CENTER BEAM AT FRAME 31 AND 32. REPLACED CORRODED SEAT TRACK STRUCTURE PER SRM 51-10-00-0, 53-10-16-2, 53-10-00-1, 51-22-00. (M)SDR AALA980473Seat Track · corrodedTUL - FOND CORROSION NR 10 SEAT TRACK BETWEEN FRAME 27 AND 28. INSTALLED NEW SEAT TRACK PER AARD 51-10-00-3 AND 51-20-00-1 AND SRM 51-10-00-0 AND 53-10-16-2 AND 51-10-00-1 AND 51-22-00. (M)SDR SWIA971152Seat Track · corrodedFORWARD LONG SECTION OF CABIN SEAT TRACK, RIGHT SIDE FLOOR LEVEL HAS NUMEROUS AREAS OF CORROSION. REPLACED RIGHT SIDE FLOOR LEVEL SEAT TRACK WITH NEW SEAT TRACK IAW SRM 51-40-02.SDR AALA980466Seat Track · corrodedTUL - NR 7 SEAT TRACK CORRODED BETWEEN FRAME 15 AND 16. NR 7 SEAT TRACK CORRODED BETWEEN FRAME 16 AND 16A. REPLACED NR 7 SEAT TRACK FROM FRAME 15A TO FRAME 19 PER SRM 51-72-10-0. (M)SDR AALA980465Seat Track · gougedTUL - DURING C-CHECK, FOUND GOUGE IN NR 8 SEAT TRACK AT FRAME NR 31 IN FORWARD CABIN. BLENDED OUT DAMAGED AREA AND REPAIRED PER ESO 30595 DATED 3-4-98. (M)SDR DHL9872663DSupport · wornAT D CHECK, SEAT TRACK ASSY AT LBL 45 BS 870 IS LOOSE AND WORN AT ATACH BOLT. REPLACED SEAT TRACK SUPPORT PER SRM 51-10-1. N/R 3600.SDR 98ZZZX1080Rail Support · crackedPILOT SEAT RAIL SUPPORT BRACKET CRACKED AT STA 77 AND STA 87. THE CRACKS WERE FOUND UNDER THE LEFT HAND SEAT RAIL IN THE FLANGE AREA AROUND THE NUT PLATES.SDR UPS98226017Seat Track · corrosionINSPECTION TYPE:SI CORROSION (C53-224-01.05-03) ON SEAT TRACK FLANGE STA 1130-1175, LBL 45, WL 208. REMOVED OUT OF LIMITS SEAT TRACK FABRICATED AND INSTALLED NEW SEAT TRACK AND REPAIR PARTS IAW SRM 53-10-5, 51-30-2.SDR QXEA9800475Seat Track · corrodedCORROSION ON RIGHTHAND INBOARD SEAT TRACK AT FRAME 4610 APPROXIMATELY 5 INCH LENGTH. REMOVED AND REPLACED SEAT TRACK PER FOKKER SRM 51-31-01.SDR QXEA9800463Seat Track · damagedRT INBD SEAT TRACK HAS GOUGES AND NICKS IN TRACK AT TOP SURFACE. REMOVED AND REPLACED SEAT TRACK IAW FOKKER SRM 53-02-15.SDR SWIA971151Seat Track · corrodedLEFT FLOOR SEAT TRACK LONG SECTION UNDER GALLEY AREA HAS CORROSION. REMOVED AND REPLACED LEFT SEAT TRACK WITH A NEW SEAT TRACK IAW SRM 51-40-02.SDR DHL9872658DSeat Track · gougedAT D CHECK, NR 6 SEAT TRACK LOCK FLANGES GOUGES AT STA 1080. INSTALLED NEW SECTION PER SRM 53-10-5. 30 LONG, N/R 5145.SDR DHL9872655DSeat Track · wornAT D CHECK, NR 3 SEAT TRACK WORN AT STA 600. REMOVED AND REPLACED SEAT TRACK PER SRM 53-10-5 FROM STA 560 TO 690. N/R 5147.SDR DHL9872654DSeat Track · wornAT D CHECK, NR 5 SEAT TRACK LOCK FLANGE WORN AT STA 600. REMOVED DAMAGED SECTION. REPLACED DAMAGED SECTION FROM STA 560 TO 600 PER SRM 53-10-5. N/R 5156.SDR DHL9872653DSeat Track · wornAT D CHECK, NR 5 SEAT TRACK LOCK FLANGES WORN AND GOUGED FROM STA 1166 TO 1176. REMOVED AND REPLACED DAMAGED SEAT TRACK. N/R 5150.SDR UPS98826078Seat Track · corrodedINSPECTION TYPE-D/CK, SEAT TRACK F FUSELAGE STATION 1440 CORRODED. REMOVED SEAT TRACK SECTION FUSELAGE STATION 1430 TO 1450, CUT AND DRILLED NEW SECTION AND INSTALLED SECTION IAW DC8 SRM 51-1-8, 51-3-0, 53-1-2 AND EO DC8 5320 5167.SDR TWAA9803306Seat Track · corrodedMCI - DURING MAJOR MAINTENANCE CHECK, NR 4 CABIN CHAIR TRACK CORROSION WAS OUT OF LIMITS AFTER CLEAN UP. REPLACED FLOOR TRACK FROM STATION 200 TO 266 PER SRM 51-01 PAGE 1 ITEM C AND STANDARD PROCEDURES. (M)SDR AU980249Insert · separated(AUS) AFT FLIGHT ATTENDANT'S SEAT BULKHEAD ATTACHMENT INSERTS HAD PULLED OUT OF THE BULKHEAD.SDR AALA98422Track · corrodedTUL - FOUND CORROSION TO TRACK NR 1 AT STATION 457 AT THE LAV TIEDOWN, BEYOND LIMITS. REMOVED AND REPLACED NR 1 TRACK FROM PRODUCTION SPLICE TO L1 DOOR STATION 410, PER SRM AARD 51-10-00-1 PAGE 1. (M)SDR AALA980424Seat Track · corrodedTUL - CORROSION ON SEAT TRACK AT STA 1209, NUT PLATE MOUNT HOLE FOR GALLEY. REPLACED NR 1 SEAT TRACK STA 1174 - STA 1309. (X)SDR CKSA98196Seat Track · corrodedDURING ROUTINE C-2 CHECK INSPECTION, FOUND COCKPIT FLOOR TRACK SECOND OBSERVERS SEAT AFT TRACK HAS CORROSION AROUND FASTENERS. REMOVED AND REPLACED AFT FLOOR TRACK AT SECOND OBSERVERS SEAT IAW DC8 SRM 51-1-21. SEAT TRACK DRILLED IAW DAC DWG NR 3657504. PRIMSDR CKSA98195Seat Track · corrodedDURING ROUTINE C-2 CHECK INSPECTION, FOUND COCKPIT FLOOR TRACK SECOND OBSERVERS SEAT FWD TRACK HAS CORROSION AROUND FASTENERS. REMOVED AND REPLACED FWD FLOOR TRACK AT SECOND OBSERVERS SEAT IAW DC8 SRM 51-1-21. SEAT TRACK DRILLED IAW DAC DWG NR 3657504. PRIMSDR CKSA98188Seat Track · wornDURING ROUTINE C-2 CHECK INSPECTION, FOUND CAPT'S UPPER SEAT TRACKS WORN. REMOVED AND REPLACED BOTH FWD SEAT TRACK T'S AT CAPT'S POSITION IAW DC8 SRM 53-1-0 AND 51-1-20D. INSTALLATION OK. AFTER CAPT'S SEAT INSTALLATION SEAT TRACK AND SEAT OPERATES GOOD AT A
Back to JASC 5347