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 ASOA03328Seat Track · corrodedDURING A C-CHECK IN BNA, THE LEFT OUTBOARD SEAT TRACK BETWEEN FS 29-36 WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE LEFT OUTBOARD SEAT TRACK BETWEEN FS 29/36 IAW SRM 51-25-04 AND 51-25-02. (M)SDR UPS03841046Seat Track · wornINSPECTION TYPE: C2, CABIN FLOOR TRACK -F- HAS WORN SCALLOPS FROM STA 740-770. REMOVED DAMAGED SEAT TRACK AND SPLICED NEW SEAT TRACK AND ADDED 2 SPLICE CHANNELS IAW UPS EO DC8-5320-5167. FABRICATED, LOCATED AND DRILLED HOLES IAW UPS EO DC8-5320-5167 AND DWGSDR UPS03841044Seat Track · wornINSPECTION TYPE: C2, CENTER FLOOR TRACK BL 0 STA 1190 IS EXCESSIVELY WORN. BLENDED FLOOR TRACK (ORIG .420, REM .550) OUT OF LIMITS IAW DC8 SRM 53-2-3. REMOVED DAMAGED FLOOR TRACK, LOCATED, DRILLED & DEBURRED NEW SEAT TRACK 60-15176 IAW DC8 SRM 53-2-3. ASDR UPS03841038Seat Track · wornINSPECTION TYPE: C2, CABIN SEAT TRACK AT STA 218/BL49L SCALLOPS ARE WORN. BLENDED SCALLOPS IAW DC8 SRM 53-2-3. ORIG WIDTH .600, .420 REMAINING OUT OF LIMITS IAW DC8 SRM 53-2-3. CUT OUT IAW DC8 SRM 53-2-3. ALODINED AND PRIMED CUTOUT IAW DC8 SRM 51-1-8. INSDR 2003UALA00545Seat Track · corrodedFASTENER HOLES CORRODED AT SEAT TRACK FLANGE BS 830-862, RBL 34 COMMON TO FLOORBEAM. MAJOR REPAIR ACCOMPLISHED. INSTALLED SPLICE SECTION, ANGLES AND FILLERS.SDR CALA0300366Seat Track · corrodedINSPECTION FOUND FLOOR SEAT TRACK CORRODED AT CABIN FORWARD FLOOR STRUCTURE, STA 377, LBL 24.78. THE SEAT TRACK WAS REMOVED AND REPLACED IAW BOEING DRAWING 141N5130.SDR 03FDEA01056Seat Track · damagedMAIN CARGO COMPT FLOOR SEAT TRACK DAMAGED A 6 INCH CRACK IN SEAT TRACK ADAPTER AT 12R, FR 59 AND Y1456. REMOVED AND REPLACED SEAT TRACK ADAPTER IAW EA. (6-2550-71920) REV PT 2.SDR 03FDEA01062Seat Track · corrodedFORWARD CABIN - R1 DOOR ENTRANCE TRACK FOUND CORRODED AT STA 430. CORROSION BLENDED CARRIED OUT FOUND WITHIN LIMIT AS PER SRM 53-70-00 FIG 3 VOL 1.SDR 03FDEA01061Seat Track · corrodedFORWARD CABIN - L1 DOOR ENTRANCE TRACK FOUND CORRODED AT STA 420 - 457. CORROSION BLENDED CARRIED OUT FOUND WITHIN LIMIT AS PER SRM 53-70-00 FIG 3 VOL 1.SDR MALA030359Seat Track · corrodedDURING C-CHECK INSPECTION IN CVG, NR 3 SEAT RAIL FROM FRAME 18 TO 6 INCHES AFT OF FRAME 20 IS CORRODED BEYOND LIMITS. MAINTENANCE REPAIRED IAW EO NR A53026. REFER TO 409 NR 128125, TASK CARD NR 0893A FOR DETAIL. A/C RELEASE DATE 7/25/03.SDR MALA030358Seat Track · corrodedDURING C-CHECK INSPECTION IN CVG, NR 2 SEAT RAIL FROM FRAME 18 TO 20 IS CORRODED BEYOND LIMITS. MAINTENANCE REPAIRED IAW EO NR A53026. REFER 409 NR 128124, TASK CARD NR 0893A FOR DETAIL. A/C RELEASE DATE 7/25/03.SDR MALA03057Seat Track · corrodedDURING C-CHECK INSPECTION IN CVG, NR 1 SEAT RAIL FROM FRAME 18 TO 20 IS CORRODED BEYOND LIMITS. MAINTENANCE REPAIRED PER EO NR A53026. REFER TO 409 NR 128123 FOR DETAIL. A/C RELEASE DATE 7/25/03.SDR MALA030360Seat Track · corrodedDURING C-CHECK INSPECTION IN CVG, NR 4 SEAT RAIL FROM FRAME 18 TO FRAME 20A IS CORRODED. MAINTENANCE REPAIRED IAW EO NR A53026. REFER TO 409 NR 128126, TASK CARD NR 0893A FOR DETAIL. A/C RELEASE DATE 7/25/03SDR 03FDEA01060Seat Track · crackedMAIN DECK CARGO FLOOR SEAT TRACK CRACKED AT STA 695, LBL 27.5. REPAIR CARRIED-OUT AT MAIN DECK CARGO FLOOR SEAT TRACK BETWEEN STA 680 AND STA 745 IAW SRM 53-70-00 FIG 1 VOL I.SDR 2003UALA00538Seat Track · corrodedMAIN CABIN BS 1043, RBL 90, SEAT TRACK CORRODED BEYOND LIMITS. MAJOR REPAIR ACCOMPLISHED. INSTALLED SPLICE SECTION, ANGLES AND FILLERSSDR 2003UALA00537Seat Track · corrodedLT MAIN DECK FLOOR, SEAT TRACK CORRODED BEYOND LIMITS BETWEEN BS 764-776, LBL 56-LBL 59. MAJOR REPAIR ACCOMPLISHED. INSTALLED NEW SECTION SPLICE.SDR SROM200300036Floorbeam · corrodedDURING D CHECK INSPECTION FOUND CORROSION ON FLOORBEAM UPPER CAP AT STA 344 FROM LBL 30 TO RBL 30. REMOVED AND REPLACED DAMMAGED CAP IAW SRM 51-30-2, 51-10-6, 51-10-2 AND 53-10-1.CORROSION LEVEL 1SDR MALA030328Seat Track · corrodedLEFT CENTER AISLE SEAT TRACK LBL 18.3 FROM STA 297-319 HAS CORROSION. MAINTENANCE COMPLETED SPLICE REPAIR IAW EO S53060. REF 409 NR 192030 FOR FURTHER DETAIL. A/C RELEASE DATE 7/6/03.SDR DHL2003873564Seat Track · wornITEM REF.: N/R 0827.: MAIN CARGO COMPT. NR 6 TRACK LUG WORN STA.1470.000-STA.1590.000. REMOVED DAMAGED TRACK IAW SRM 51-3-0 PG.1. CLEANED, TREATED AND PRIMED IAW SRM 51-1-8B. INSTALLED NEW TRACK IAW SRM 51-3-0 PG.1.SDR SROM200300034Seat Track · gougedDURING D CHECK INSPECTION FOUND NUMEROUS GOUGES IN CENTER AND TOP OF SEAT TRACK BETWEEN BS 540 - 727, LBL 24. REMOVED AND REPLACED SEAT TRACK BETWEEN BS 540 TO 727 IAW SRM 51-30-2, 51-10-2 AND MM 51-21-0.SDR CALA0300357Seat Track · corrodedINSPECTION FOUND THE LT I/B SEAT TRACK CORRODED BETWEEN BS 907 AND 947. A NEW SEAT TRACK SECTION WAS INSTALLED IAW SRM 53-00-52, FIGURE 204.SDR DHL2003873620Cargo Track · wornMAIN CARGO COMPT NR 6 TRACK LUGS WORN AT STA 1306.000. CUT OUT NR 6 TRACK DAMAGED AREA IAW SRM 53-2-3 PG 17-18, SRM 51-3-0 PG 1. CLEANED,TREATED, AND PRIMED AREA IAW SRM 51-1-8B. INSTALLED NEW PLUG AND CHANNEL IAW SRM 53-2-3 PG 17-18, SRM 51-3-0 PG 1.SDR SROM200300038Seat Track · gougedDURING D CHECK INSPECTION FOUND BARE METAL AND GOUGES ON SEAT TRACK BETWEEN STAS 727 AND 947, RBL 45.5. REMOVED AND REPLACED SEAT TRACK IAW SRM 51-10-1, 51-30-2, 51-10-2 AND MM 51-21-171.SDR GTIA030588Seat Track · corrodedFTW - FOUND RIGHT INBOARD SEAT TRACK UNDER G2 CORRODED AT FS 200-256. REMOVED SECTION OF SEAT TRACK, RIGHT INBOARD AT FS 200 TO 265. FABRICATED LOCATED AND DRILLED NEW SECTION OF SEAT TRACK. INSTALLED NEW SECTION OF TRACK. (M)SDR SROM200300031Seat Track · gougedDURING D CHECK INSPECTION FOUND GAUGES IN SEAT TRACK ALONG CENTER AND TOP FLANGES BETWEEN STA 540 AND 727. REMOVED DAMAGED SEAT RACK AND REPLACED IAW SRM 53-10-1, 51-30-2 AND 51-10-2.SDR CALA0300343Galley Track · corrodedINSPECTION FOUND GALLEY TRACK CORRODED BETWEEN BS 328 AND 360 AT RBL 44. THE FLOOR TRACK WAS REMOVED AND REPLACED IAW SRM 51-10-2.SDR CALA0300342Galley Track · corrodedINSPECTION FOUND CORROSION ON GALLEY TRACK BETWEEN BS 277 AND 294, RBL 44. THE GALLEY TRACK WAS REMOVED AND REPLACED IAW SRM 51-10-2.SDR MWEA030258Cargo Track · corrodedMODERATE CORROSION ON MID-PIT LEFT SIDE TIE RAIL FROM FRAME STAION 541 AFT TO FRAME STATION 788. FABRICATED AND INSTALLED SPLICE FOR TIE DOWN RAIL, FABRICATED AND INSTALLED AFT SLPICE.SDR MWEA030256Cargo Track · corrodedSPOTS OF LITE CORROSION ON MID-PIT RIGHT SIDE TIE DOWN RAIL FROM FRAME STATION 541 - 636. BLENDED CORROSION, REPLACED ENTIRE SECTION OF TIE DOWN RAIL, FABRICATED AND INSTALLED SPLICE.SDR 03FDEA01046Seat Track · crackedMAIN DECK - AT BS 755, LEFT X=8.5, FLOOR TRACK CRACKED. MAIN DECK - BS 755, LT X=8.5 SEAT TRACK REPAIRED AS PER SRM 53-70-00,VOL I.SDR 03FDEA01045Seat Track · crackedMAIN DECK - AT BS 695, LEFT X=8.5, FLOOR TRACK CRACKED. MAIN DECK - AT BS 695 TO BS745 X=8.5 LT CARRIED OUT REPAIR IAW SRM 53-70-00 VOL I.SDR 2003UALA00521Seat Track · wornMAIN CABIN AT STATION 1065, LBL 11, SEAT TRACK WORN.SDR DHL2003604793Cargo Track · wornMAIN CARGO COMPT NR 2 TRACK LUGS WORN, STA -55.000 - STA 310.000. REMOVED NR 2 TRACK WITH WORN LUGS IAW SRM 51-3-0 PG 1. CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B. INSTALLED NEW NR 2 TRACK ON MAIN CARGO COMPT STA -55.000 - STA 310.000 IAW SRM 51-3-0 SDR SWIA200312245Seat Track · corrodedLT CABIN SIDE SEAT RAIL BETWEEN FS 444 AND 495 CORRODED. DISCOVERED DURING C-CHECK, DAMAGED SEAT RAIL REMOVED AND REPLACED PER CRJ AMM CH 20-21-00. P/N: 601R38312-115SDR SWIA200312244Seat Track · corrodedBAGGAGE COMPARTMENT SEAT TRACKS LBL 9.0 & RBL 9.0 BETWEEN FS 559 + 80 AND 559 + 96 CORRODED. DISCOVERED DURING C-CHECK, SEAT TRACKS REPLACED IAW CRJ AMM 20-21-00. P/N: 601R38779-13SDR DHL2003873536Cargo Track · wornMAING CARGO COMPT NR 2 TRACK LUG WORN, STA 1590.000 - 1680.000. REMOVED NR 2 TRACK DAMAGED SEGMENT IAW SRM 51-3-0 PG 1. CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B. INSTALLED NEW TRACK SEGMENT WITH NEW FASTENERS IAW SRM 51-3-0 PG 1.SDR DHL2003873544Cargo Track · wornMAIN CARGO COMPT NR 2 TRACK LUG WORN,( STA.1570.000-STA.1590.000) REMOVED NR 2 TRACK DAMAGED SECTION IAW SRM 51-3-0 PG 1. CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B. INSTALLED NEW TRACK SEGMENT WITH NEW FASTENERS IAW SRM 51-3-0 PG 1.SDR MWEA030253Seat Track · wornFIRST OFFICER'S AFT OUTBOARD SEAT TRACK IS WORN BEYOND LIMITS. FABRICATED AND INSTALLED SEAT TRACK.SDR MWEA030252Seat Track · wornCAPTAINS AFT OUTBOARD SEAT TRACK IS WORN BEYOND LIMITS. FABRICATED AND INSTALLED SEAT TRACK.SDR 03FDEA00977Seat Track · crackedFLOOR SEAT TRACK AT STA 635 LH X=47.5 CRACKED. FLOOR TRACK AT STA 635 LH X=47.5 CARRIED OUT REPAIR IAW SRM 53- 70-00 VOL.I.SDR 03FDEA00976Seat Track · crackedFLOOR SEAT TRACK AT STA 635 LH X=27.5 CRACKED. DAMAGED FLOOR TRACK AREA FROM BS625 TO BS 665 LH X=27.5 CARRIED OUT SEAT TRACK REPAIR IAW SRM 53-70-00 VOL. I.SDR 03FDEA00975Seat Track · crackedFLOOR SEAT TRACK AT STA 635 LH X=8.5 CRACKED. CORRECTIVE ACTION SNRM N0163 : CABIN - FLOOR TRACK AREA AT BS 625 TO BS 745 LT X=8.5 CARRIED OUT SEAT TRACK REPAIR IAW SRM 53-70-00 VOL.ISDR DHL2003873618Seat Track · wornMAIN CARGO COMPT NR 3 TRACK LUG WORN. (STA.1680.000 - 1695.000) CUT OUT NR 3 TRACK DAMAGED SEGMENT IAW SRM 53-2-3 PG 49-50. FABRICATED SPLICES IAW SRM 53-2-3 PG.49-50. CLEANED, TREATED AND PRIMED IAW SRM 51-1-8B. INSTALLED NEW TRACK SEGMENT AND SPLICES IAW SRSDR DHL2003873519Seat Track · wornITEM REF.: N/R 0843.: MAIN CARGO COMPT NR 5 TRACK LUG WORN BETWEEN STA.1680.000 AND STA.1695.000. CUT OUT NR 5 TRACK DAMAGED SEGMENT IAW SRM 53-2-3 PG.49-50. FABRICATED SPLICES (7075-T6 0.160) IAW SRM 53-2-3 PG.49-50. CLEANED, TREATED AND PRIMED IAW SRM 51-1-SDR MALA030335Seat Track · corrodedDURING C-CHECK INSPECTION IN CVG, NR 4 SEAT RAIL CORRODED BEYOND LIMITS. FLOORBEAM AT FRAME 20-18. MAINTENANCE REPLACED SEAT TRACK NR 4 IAW EO NR A53026, REMOVED AND REINSTALLED ELEVATOR G-WEIGHT AND RIG CHECKED ELEVATOR CIRCUIT. SEE CONTINUATION CARD DETAILSDR MALA030334Seat Track · corrodedDURING C-CHECK INSPECTION IN CVG, NR 2 SEAT RAIL CORRODED BEYOND LIMITS. FLOOR FRAME 20 TO I/B. MAINTENANCE REPLACED SECTION OF RAIL IAW EO A53026. REFER 409 NR 127854 FOR DETAIL. A/C RELEASE DATE 7/1/2003.SDR MWEA030247Cargo Track · corrodedVARIOUS SPOTS OF LIGHT CORROSION ON MID-PIT RIGHT SIDE CARGO TIE DOWN RAIL FROM FRAME STATION 693-788. FABRICATED AND INSTALLED NEW SECTION RAIL.SDR USAA030104Cargo Track · corrodedFOUND CARGO TRACK CORRODED .5 INCH BY 2 INCHES, AFT CARGO STATION 807 2 INCHES S-26R TIE DOWN TRACK. CARGO TRACK REPAIR PER SRM 53-10-53 FIG 202. (M)SDR DHL2003873619Cargo Track · wornMAIN CARGO COMPT NR 5 TRACK PLUG LUG WORN AT STA 1315.000. REMOVED DAMAGED PLUG AND CHANNEL IAW SRM 51-3-0 PG 1. CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B. INSTALLED NEW PLUG CHANNEL TO TRACK NR 5 AT STA 1315.000 IAW SRM 51-3-0 PG 1.SDR UPS03840929Seat Track · corrodedINSPECTION TYPE: C, AFT ACCESSORY COMPT. STA. 1600-1620 AT RBL 45 SEAT TRACK REPAIR IS CORRODED BEYOND LIMITS. REMOVED, FABRICATED AND REPLACED SEAT TRACK SECTION STATION 1590-1610 AT RBL 45, AND REPLACED SEAT TRACK SPLICE STATION 1600-1620 IAW SRM 53-2-3
Back to JASC 5347