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 CKSA98318Seat Track · corrodedDURING ROUTINE CPCP INSPECTION FOUND LEVEL 2 CORROSION, SEAT TRACK CORRODED FROM BS 510 TO BS 660, BWL 199.8, LBL33 (SEVERAL PLACES). REMOVED CORROSION IAW SRM 51-10-01. DAMAGE OUT OF LIMITS AT LBL 33 ON BS 510 TO BS 516 AND CRACK FOUND AT BS 552 LBL 33 IAW SDR CKSA98317Seat Track · corrodedDURING ROUTINE CPCP INSPECTION FOUND LEVEL 2 CORROSION, SEAT TRACK CORRODED BETWEEN BS 580-BS 600, BWL 310 (UPPER DECK), LBL 45. REMOVED CORROSION IAW SRM 51-10-01. CORROSION OUT OF LIMITS IAW 53-10-01. ID MATERIAL PN BAC1520-1567P .07295. REPAIRED SEAT TRSDR CKSA98316Seat Track · corrodedDURING ROUTINE CPCP INSPECTION FOUND LEVEL 2 CORROSION, SEAT TRACK CORRODED FROM BS 580 TO BS 600, BWL 310 (UPPER DECK) LBL65. REMOVED CORROSION IAW B747 SRM 51-10-01. FOUND OUT OF LIMITS IAW B747 SRM 53-10-01. ID MATERIAL PN BAC1520-1566. REPAIRED SEAT TRSDR CALA9800886Tiedown Rail · corrodedINSPECTION FOUND RIGHT TIE DOWN RAIL CORRODED IN AFT CARGO BIN AT STA 1007 TO 1155. THE TIE DOWN RAIL WAS REMOVED AND THE CORROSION WAS REMOVED IAW SRM 51-30-3. A REPAIR DOUBLER WAS INSTALLED IAW ECRA 5320-01519.SDR AALA984117Seat Track · corrodedAFW - CORROSION REMOVED FROM UPPER SURFACE OF SEAT TRACK. BLENDED OUT EXCEEDED SRM MAX ALLOWABLE LIMITS. BLENDED OUT CORROSION AND REMOVED TABS ADJACENT TO THE DAMAGED AREA ALODINED AND PRIMED. APPROCHED BY ENGINEER WITH NOTED CONDITION PER MRB 767-1632. (SDR RAIA980527Seat Track · corrodedSTL - DURING MAINTENANCE, FOUND RIGHT INBOARD SEAT TRACK CORRODED. MAINTENANCE PERFORMED SPLICE REPAIR IAW ATR 42 SRM. (M)SDR RAIA980525Seat Track · corrodedSTL - DURING MAINTENANCE, FOUND CORROSION AT LEFT AND RIGHT FLIGHT ATTENDANT SEAT TRACKS. MAINTENANCE PERFORMED SPLICE REPAIR AT LEFT AND RIGHT FLIGHT ATTENDANT SEAT TRACKS IAW ATR 42 SRM. (M)SDR C2XA98IA173Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, FOUND RIGHT AFT CENTER SEAT TRACK CORRODED FROM FRAMES 29 TO 36. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK IAW ATR-42 SRM 51-25-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA98IA172Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, FOUND RIGHT SIDE FLIGHT ATTENDANTS SEAT TRACK CORRODED. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK IAW ATR-42 SRM 51-25-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA98IA171Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, RIGHT AFT OUTBOARD SEAT TRACK CORRODED FROM FRAMES 31 TO 36. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK IAW ATR-42 SRM 51-25-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR UPS98826802Cargo Track · corrodedINSPECTION TYPE-C, STA 1240 TO 1260 ABOVE STR 33L, THE CARGO TRACK HAS HEAVY CORROSION. REMOVED, FABRICATED AND REPLACED TRACK IAW DWG 5759223 AND SRM 51-3-0.SDR UPS98826801Cargo Track · corrodedINSPECTION TYPE-C, STA 1140 ABOVE STR 33R, THE CARGO TRACK HAS HEAVY CORROSION. REMOVED, FABRICATED AND REPLACED TRACK IAW DWG 5759223 AND SRM 51-3-0.SDR UPS98826800Cargo Track · corrodedINSPECTION TYPE-C, STA 1140, ABOVE STR 33L, THE CARGO TRACK HAS HEAVY CORROSION. REMOVED, FABRICATED AND REPLACED TRACK IAW DWG 5759223.SDR SCNA98704Seat Track · corrodedDURING A HEAVY MAINT CHECK, CORROSION WAS FOUND AT THE LEFT CENTER SEAT TRACK AT STATION 1090 TO 1120 ON THE INSIDE OF THE TRACK. REMOVED SEAT TRACK IAW B727 SRM 51302. TRACK OUT OF LIMITS IAW B727 SRM 513002. MATERIAL ID 7075 T6 PER SRM 511001. FABRICATEDSDR SCNA98703Seat Track · misdrilledDURING A HEAVY MAINT CHECK, THE LEFT CENTER SEAT TRACK AT STATION 1070 HAD A NUT PLATE HOLE THAT WAS MISDRILLED AND EXTREMELY WALLOWED OUT. REMOVED SEAT TRACK IAW B727 SRM 513002. TRACK OUT OF LIMITS IAW B727 SRM 513002. MATERIAL ID 7075 T6 B727 SRM 511001.SDR CALA9800870Tiedown Rail · corrodedINSPECTION FOUND CORROSION ON LT TIE DOWN RAILS AT STA 1007-1174 AND STA 1212-1231. NEW TIE DOWN RAILS WERE INSTALLED IAW SRM 51-30-01.SDR AALA980996Roller Tray · corrodedFOUND CORROSION ON FORWARD AND AFT ENDS OF ROLLER TRAY NR 1 FROM STATION 58L-63L. REMOVED AND REPLACED ROLLER TRAY PER SRM 51-72-10-0. (M)SDR UPS98826805Cargo Track · corrodedINSPECTION TYPE-C, STA 470 TO 640 ABOVE STR 33L, THE CARGO TRACK HAS HEAVY CORROSION. REMOVED, FABRICATED AND REPLACED TRACK IAW DWG 5759223 AND SRM 51-3-0.SDR UPS98826799Cargo Track · corrodedINSPECTION TYPE-C, STA 70 TO 260 ABOVE STR 33R, THE CARGO TRACK HAS HEAVY CORROSION. REMOVED, FABRICATED AND REPLACED TRACK IAW DWG 5759223 AND SRM 51-3-0.SDR UPS98826798Cargo Track · corrodedINSPECTION TYPE-C,STA 70 TO 260 ABOVE STR 33L, THE CARGO TRACK HAS HEAVY CORROSION. REMOVED, FABRICATED AND REPLACED TRACK IAW DWG 5759223 AND SRM 51-3-0.SDR RAAA98B1065Track · corrodedDURING SCHEDULED S6 INSPECTION PER CARD S6-54104, FOUND AFT CARGO COMPT LBL 19 FLOOR TRACK CORRODED AT BS 950 TO 1110. REPLACED TRACK PER SRM 51-10-1 AND 51-30-2. M-54 NR 447.SDR RAAA98B1063Track · corrodedDURING SCHEDULED S6 INSPECTION PER CARD S6-52103, FOUND FWD CARGO COMPT LBL 18 FLOOR TRACK CORRODED AT BS 589. REPLACED TRACK PER SRM 51-10-1. M-54 NR 402.SDR RAAA98B1062Track · corrodedDURING SCHEDULED S6 INSPECTION PER CARD S6-52103, FOUND FWD CARGO COMPT LBL 18 FLOOR TRACK CORRODED AT BS 636, 646 AND 660 TO 680. REPLACED TRACK PER SRM 51-10-1. M-54 NR 401.SDR RAAA98B1061Track · corrodedDURING SCHEDULED S6 INSPECTION PER CARD S6-54104, FOUND AFT CARGO COMPT RBL 13 FLOOR TRACK CORRODED AT BS 950 TO 1110. REPLACED TRACK PER SRM 51-10-1 AND 51-30-2. M-54 NR 392.SDR DHL9870641CSeat Track · corrodedAT C-CHECK, CORROSION AT NUT PLATE ON OUTBD FLANGE OF SEAT TRACK LBL 46 BETWEEN BS 480 AND 600. REMOVED SEAT TRACK, REMOVED CORROSION FROM CABIN FLOOR, WITHIN LIMITS AND INSTALLED NEW TRACK PER SRM FROM BS 480 TO 550 PER SRM 53-10-5. N/R 3576.SDR DHL9870637CSeat Track · corrodedAT C-CHECK, FWD CARGO RT SEAT TRACK STR 27R HAS CORROSION AT TOP AND BOTTOM BS 480 TO 510. N/R 3550.SDR AALA980995Roller Tray · corrodedTUL - FOUND CORROSION ON NR 6 ROLLER TRACY ON FORWARD END, AFT END. REMOVED AND REPLACED ROLLER TRAY, PER 51-72-10-0. (M)SDR 98ZZZX2309Seat Track · corrodedDURING C-CHECK INSPECTION, LEVEL 2 CORROSION WAS NOTED ON CABIN SEAT TRACK, STA 344 AT RBL 45.5.SDR UPS98826829Cargo Track · corrodedINSPECTION TYPE:C, STA 435 ABOVE STR 33L, CARGO TRACK HAS HEAVY CORROSION. REMOVED, FABRICATED AND REPLACED TRACK IAW DWG 5887623 AND SRM 51-3-0.SDR SIMA981331Seat Track · corrodedSAW - DURING CPCP-4 INSPECTION, MAINTENANCE REPORTED THE FOLLOWING SEAT TRACKS CORRODED OUT OF LIMITS. THE LEFT FORWARD OUTBOARD, LEFT MIDDLE INBOARD, LEFT MIDDLE OUTBOARD, LEFT AFT INBOARD, RIGHT FORWARD OUTBOARD, RIGHT MIDDLE OUTBOARD AND RIGHT AFT INBOARD.SDR CKSA98341Seat Track · damagedFOUND TWO SECTIONS OF SEAT TRACK DAMAGED AT STA 380 ON NR 1 AND NR 2 TRACKS AFTER REMOVAL OF CARGO. REPAIRED DAMAGED AREAS OF SEAT TRACK IAW DOUGLAS DC-8 SRM CH 53-2-3. NON-ROUTINE M-7 ITEM 1 LOG PAGE 815-0860.SDR CKSA98296Seat Track · crackedDURING ROUTINE CPCP INSPECTION, FOUND LEVEL 2 CORROSION, C2 THRESHOLD CARGO HOLD DOWN TRACK JUST FWD OF BS 1625, TRACK IS CRACKED AND TWO SCREWS SHEARED. REPLACED FASTENERS IAW L1011 SRM 51-40-01. REPAIRED CRACKED HOLD DOWN IAW L1011 SRM 51-50-04. TREATED ASDR 98ZZZM528Seat Track · corrodedSAW - DURING CPCP-4 INSPECTION, MAINTENANCE REPORTED THE FOLLOWING SEAT TRACKS CORRODED OUT OF LIMITS. THE LEFT FORWARD OUTBOARD, LEFT MIDDLE INBOARD, LEFT MIDDLE OUTBOARD, LEFT AFT INBOARD, RIGHT FORWARD OUTBOARD, RIGHT MIDDLE OUTBOARD AND RIGHT AFT INBOARD.SDR 98ZZZM527Seat Track · corrodedSAW - DURING CPCP-4 INSPECTION, MAINTENANCE REPORTED THE FOLLOWING SEAT TRACKS CORRODED OUT OF LIMITS. THE LEFT FORWARD OUTBOARD, LEFT MIDDLE INBOARD, LEFT MIDDLE OUTBOARD, LEFT AFT INBOARD, RIGHT FORWARD OUTBOARD, RIGHT MIDDLE OUTBOARD AND RIGHT AFT INBOARD.SDR 98ZZZM526Seat Track · corrodedSAW - DURING CPCP-4 INSPECTION, MAINTENANCE REPORTED THE FOLLOWING SEAT TRACKS CORRODED OUT OF LIMITS. THE LEFT FORWARD OUTBOARD, LEFT MIDDLE INBOARD, LEFT MIDDLE OUTBOARD, LEFT AFT INBOARD, RIGHT FORWARD OUTBOARD, RIGHT MIDDLE OUTBOARD AND RIGHT AFT INBOARD.SDR 98ZZZM525Seat Track · corrodedSAW - DURING CPCP-4 INSPECTION, MAINTENANCE REPORTED THE FOLLOWING SEAT TRACKS CORRODED OUT OF LIMITS. THE LEFT FORWARD OUTBOARD, LEFT MIDDLE INBOARD, LEFT MIDDLE OUTBOARD, LEFT AFT INBOARD, RIGHT FORWARD OUTBOARD, RIGHT MIDDLE OUTBOARD AND RIGHT AFT INBOARD.SDR 98ZZZM524Seat Track · corrodedSAW - DURING CPCP-4 INSPECTION, MAINTENANCE REPORTED THE FOLLOWING SEAT TRACKS CORRODED OUT OF LIMITS. THE LEFT FORWARD OUTBOARD, LEFT MIDDLE INBOARD, LEFT MIDDLE OUTBOARD, LEFT AFT INBOARD, RIGHT FORWARD OUTBOARD, RIGHT MIDDLE OUTBOARD AND RIGHT AFT INBOARD.SDR 98ZZZM523Seat Track · corrodedSAW - DURING CPCP-4 INSPECTION, MAINTENANCE REPORTED THE FOLLOWING SEAT TRACKS CORRODED OUT OF LIMITS. THE LEFT FORWARD OUTBOARD, LEFT MIDDLE INBOARD, LEFT MIDDLE OUTBOARD, LEFT AFT INBOARD, RIGHT FORWARD OUTBOARD, RIGHT MIDDLE OUTBOARD AND RIGHT AFT INBOARD.SDR CKSA98340Seat Track · damagedDURING ROUTINE B-CHECK INSPECTION, FOUND COMP NR 18 SIDE WALL RESTRAINT PULLED OUT OF SEAT TRACK, DAMAGED SEAT TRACK. REMOVED FLOOR PANEL TO FOM. REMOVED DAMAGED SECTION OF SEAT TRACK. REPLACED DAMAGED SEAT TRACK IAW DC8 SRM 51-3-0. INSTALLED FLOOR PANEL ISDR 98ZZZX2321Seat Track · corrodedDURING C-CHECK INSPECTION, FOUND SEAT TRACK CORRODED.SDR 98ZZZX2317Seat Track · corrodedDURING C-CHECK INSPECTION, LEVEL 2 CORROSION WAS NOTED ON CABIN SEAT TRACK STA 1110 AT RBL 45.5.SDR UPS98826722Cargo Track · corrodedINSPECTION TYPE:C, STA 980-1070 AT STR 33R, THE CARGO TRACK HAS HEAVY CORROSION. REMOVED, FABRICATED AND REPLACED TRACK IAW DWG 5759229 AND SRM 51-3-0.SDR SWIA971201Seat Track · corrodedCORROSION ON SEAT TRACK NEAR GALLEY AREA. REMOVED CORRODED PORTION OF SEAT TRACK AND FABRICATED NEW LEFT SEAT TRACK NEAR GALLEY AREA.SDR SWIA971200Seat Track · corrodedCORROSION ON SEAT TRACK NEAR LAV AREA. REPLACED SEAT TRACK AS REQUIRED.SDR SWIA971198Seat Track · corrodedCORROSION IN LEFT AFT FLOOR LEVEL SEAT TRACK. REMOVED AND REPLACED THE LEFT AFT FLOOR LEVEL SEAT TRACK WITH NEW IAW MM 51-00-00.SDR AALA980935Roller Tray · corrodedTUL - NR 1 ROLLER TRAY OUTBOARD FLANGE AT ATTACH POINT AT FRAME 21 HAS CORROSION. REMOVED SECTION OF NR 1 ROLLER TRAY FROM FRAME 20 TO FRAME 23 AND SPLICED NEW ROLLER TRAY IN PER SRM 53-10-15-2. (M)SDR CALA9800814Tie Down Rail · corrodedAFT CARGO BIN RIGHT SIDE TIE DOWN RAIL STA 1007 TO 1155 CORRODED AT FASTENERS. INSTALLED NEW TIE DOWN RAIL PER SRM 51-30.SDR 98ZZZM549Seat Track · corrodedDURING A CPCP 4 INSPECTION PERFORMED AT AMR EAGLE MAINTENANCE CENTER FOUND THE LEFT FOWARD OUTBOARD SEAT TRACK CORRODED IN SEVERAL AREAS. REMOVED AND INSTALLED NEW SEAT TRACK IAW ATR 42 SRM 51-25-04. CAUSE OF DAMAGE, ENVIRONMENTAL. (M)SDR 98ZZZM548Seat Track · corrodedDURING A CPCP 4 INSPECTION PERFORMED A AMR EAGLE MAINTENANCE CENTER FOUND THE RIGHT OUTBOARD SEAT TRACK, AFT CABIN, CORRODED IN SEVERAL AREAS. REMOVED AND INSTALLED SEAT TRACK IAW ATR 42 SRM 51-25-04. CAUSE OF DAMAGE, ENVIRONMENTAL. (M)SDR 98ZZZM547Seat Track · corrodedDURING A CPCP 4 INSPECTION PERFORMED AT AMR EAGLE MAINTENANCE CENTER FOUND THE RIGHT FWD INBOARD SEAT TRACK CORRODED IN SEVERAL AREAS. REMOVED AND INSTALLED NEW SEAT TRACK IAW ATR 42 SRM 51-25-04. CAUSE OF DAMAGE, ENVIROMENTAL. (M)
Back to JASC 5347