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 DHL2003367507Seat Track · gougedItem Ref. N/R 0029518:Main cabin floor seat track scallops at STA. 3360 Fr. 54 L/side has gouges. Corrective action:Blended out gouges IAW A300 SRM 53-10-00,alodined IAW A300 SRM 51-40-12,primed IAW A300 SRM 51-40-12,painted IAW A300 SRM 51-40-12. Blended areaSDR DHL2003367506Seat Track · corrodedItem Ref. N/R 0029516:Main cabin floor seat track scallops has gouges at L/side between Sta. 3742 and STA. 3745 Fr. 58. Corrective action:Blended out gouges IAW A300 SRM 53-10-00,alodined IAW A300 SRM 51-40-12,primed IAW A300 SRM 51-40-12,painted IAW A300 SRM SDR MWEA030114Support Bracket · crackedFORWARD CARGO COMPARTMENT SUPPORT BRACKET ON FLOOR BEAM STATION 332 AFT SIDE IS CRACKED LOCATED AT CENTER LINE. -- LOCATED, DRILLED AND INSTALLED BRACKET.SDR AALA20030435Seat Track · corrodedMCI - FOUND FLOOR TRACK AT LBL 23, FS 1166 HAS CORROSION GALLEY NR 3. REMOVED DAMAGED CHAIR TRACK FROM STATION 1088-1220, AND INSTALLED NEW CHAIR TRACK AND SPLICE PER SRM 53-05-00. (M)SDR AALA2003434Seat Track · corrodedMCI - FOUND LEFT SIDE, INBOARD SET TRACK, INBOARD SIDE AT FS 1157 HAS EVIDENCE OF CORROSION. REMOVED DAMAGED CHAIR TRACK FROM STATION 1088-1220 AND INSTALLED NEW CHAIR TRACK AND SPLICE PER SRM 53-05-00. (M)SDR AALA20030342Seat Track · corrodedTUL - FOUND CORROSION ON SEAT TRACK NR 1. BLENDED AND ROUTED OUT CORROSION AND TREATED AND PRIMED INSTALLED PLUG REPAIR PER 53-05-00 AND AARD 53-20-00-10 AND POINTED. (M)SDR AALA20030331Seat Track · corrodedFOUND CORROSION NR 3 SEAT TRACK. BLENDED AND ROUTED OUT CORROSION ALODINE AND PRIMED INSTALLED PLUG REPAIR PER 53-05-00 AND AARD 53-20-00-10 51-10-3 AND PAINTED. (M)SDR ASAA0310037Cargo Track · corrodedOKC - DURING D-CHECK, CARGO TIE DOWN SUPPORT FITTING AT BS 540, LEFT BUTTOCK LINE 40 CORRODED. REMOVED AND REPLACED TIE DOWN SUPPORT PER SRM. (M)SDR ABXA030111Seat Track · corrodedSEAT TRACK AT BUTT LINE 22 LEFT HAD CORROSION ON UPPER SURFACE OF OUTBOARD LOWER LEG FROM STA. 1034 - 1041 AND LOWER SURFACE OF OUTBOARD UPPER LEG AT STA. 1009. REPLACED TRACK SECTION IAW DC-9 SRM 53-05.SDR ASAA0380156Seat Track · corrodedOKC - FOUND DURING 30K CHECK, SEAT TRACK SECTION IS CORRODED. REPLACED DAMAGED SECTION PER SRM 53-05. (M)SDR GTIA030167Seat Track · corrodedFORWARD CABIN STA 200 TO STA 148, RBL 8 INCHES CORRODED ON TRACK. REMOVED FLOOR TRACK SUPPORT STA 148 TO 200 RBL 8. FABRICATED NEW TRACK. INSTALLED NEW TRACK.SDR ASAA0310023Seat Track · corrodedPAE - DURING C-CHECK, FOUND SEAT TRACK AT BS 727-727A, LEFT BUTTOCK LINE 25 CORRODED. REMOVED AND REPLACED SEAT TRACK PER SRM. (M)SDR ASAA0310024Seat Track · corrodedPAE - DURING C-CHECK, FOUND SEAT TRACK AT BS 663-720, LEFT BUTTOCK LINE 45 CORRODED. REMOVED AND REPLACED SEAT TRACK PER SRM. (M)SDR 0300565512Seat Track · corrodedDuring "H" check found corrosion on seat track at BS 365 RBL 24.75 and RBL 45. Repaired per EA 55-192510.SDR UPS03240290Seat Track · corrodedINSPECTION TYPE:C&SI CABIN SEAT TRACK AT STA 650 TO 680 HAS CORROSION ON O/B FLANGE OF T RACK LBL 45.5. CORROSION REMOVED IAW SRM 53-10-1 OUT OF LIMITS. SEAT TRACK SECTION REMOVED BETWEEN BS 650-740 LBL 45.5 IAW SRM 51-30-2. NEW SECTION OF SEAT TRACK FABRICSDR CALA0300062Cargo Track · corrodedINSPECTION FOUND RT TIEDOWN RAIL CORRODED AT STA 522 - 636. A NEW TIEDOWN RAIL WAS INSTALLED IAW ECRA 5321-01134.SDR F3LA200300080Seat Track · corrodedDURING C-4 CHECK, INSPECTION REPORTED CORROSION IN AND AROUND SCREW HOLES AT SEAT TRACK BETWEEN STA. 328 AND STA. 344, RBL 54. FABRICATED AND INSTALLED REPLACEMENT SEAT TRACK PER SRM 51-30-3.SDR F3LA200300077Seat Track · corrodedDURING C-4 CHECK, INSPECTION REPORTED SEAT TRACK CORRODED AT NUTCLIP HOLES, RT. SIDE BETWEEN FLOORBEAM AT STA. 986.5 TO STA. 1016. REPLACED SEAT TRACK PER SRM 53-10-01, FIG. 3, SRM 51-30-02, MM 51-21-41 AND SOPM 20-41-02.SDR CALA0300058Seat Track · corrodedINSPECTION FOUND L/H O/B SEAT TRACK AT BS 907-947.5 CORRODED. THE CORRODED SECTION OF SEAT TRACK WAS REMOVED AND A NEW SECTION WAS INSTALLED IAW SRM 53-00-52, FIGURE 204.SDR ZW0A0302301Seat Track · corrodedDURING CHECK-C MAINT FOUND CORROSION ON CABIN SEAT TRACK AT STA 1150 TO 1164, LBL 22. REMOVED CORRODED SECTION AND SPLICED IN NEW SECTION PER SRM 53-05, FIG 4F, FROM STA 1150 TO 1230.SDR ASOA03096Seat Track · corrodedDURING C-CHECK INSPECTION, THE SEAT TRACK BETWEEN FRAMES 31R TO 36R, WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK BETWEEN FRAMES 31R TO 36R, IAW SRM.SDR ASOA03097Seat Track · corrodedDURING C-CHECK INSPECTION, THE SEAT TRACKS BETWEEN FRAMES 36R TO 39R AND 39L TO 41L WERE FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACKS BETWEEN FRAMES 36R TO 39R AND 39L TO 41L IAW SRM.SDR ASAA0380139Seat Track · corrodedOKC - FOUND DURING 30K CHECK, SEAT TRACK CORROSION AT FS 200-255. REPLACED DAMAGED SECTION OF SEAT TRACK PER SRM 53-05. (M)SDR SIMA200306409Seat Track · corrodedABI - THIS IS A LEVEL TWO FINDING, FOUND DURING AN IMBV INSPECTION, LEFT FORWARD LOWER SEAT TRACK CORRODED BETWEEN FRAME 18-23. REMOVED AND INSTALLED SERVICEABLE LEFT FORWARD SEAT TRACK IAW EMB 135 AMM 53-01-06. (M)SDR AALA20030272Galley Track · corrodedTUL - FOUND CORROSION ON FORWARD GALLEY TIE DOWN FITTING. REPLACED WITH NEW TIE DOWN FITTING PER SRM 51-01. (M)SDR UPS03M40284Seat Track · corrodedINSPECTION TYPE: C CABIN CORROSION ON SEAT TRACK BETWEEN STA 1721-1761 AS MARKED ON X=8.5. CORROSION REMOVED AS PER SRM 51-21-01 VOL 2 REV 32 AT SEAT TRACK STA 1721-1761, X-8.5 EXCEED LIMIT AS PER SRM 53-70-00 FIG 3 VOL 1 REV 32. DAMAGED PORTION OF SEAT TRACSDR BJNA03029Seat Track · corrodedDURING A SCHEDULED MAINTENANCE VISIT, LEVEL 2 CORROSION WAS DISCOVERED ON A PASSENGER CABIN SEAT TRACK LOCATED AT BS 360 LEFT OUTBOARD SIDE. REMOVED THE CORRODED SECTION OF SEAT TRACK AND REPLACED WITH A NEW SECTION MADE OUT OF BOEING EXTRUSION P/N BAC 1520-7SDR BJNA03028Seat Track · corrodedDURING A SCHEDULED MAINTENANCE VISIT, LEVEL 2 CORROSION WAS DISCOVERED ON THE SCALLOPS AND WELLS OF A PASSENGER CABIN SEAT TRACK LOCATED AT BS 344-360 LEFT INBOARD SIDE. REMOVED THE CORRODED SECTION OF SEAT TRACK AND REPLACED WITH A NEW SECTION MADE OUT OF BOSDR CALA0300035Seat Track · corrodedINSPECTION FOUND R/H O/B SEAT TRACK CORRODED AT GALLEY MOUNT FOR #2 GALLEY. THE CORRODED SECTION OF SEAT TRACK WAS REMOVED AND A NEW SECTION WAS SPLICED IN IAW SRM 53-05, FIGURE 4F.SDR CALA0300034Galley Track · corrodedINSPECTION FOUND GALLEY FLOOR TRACK CORRODED BETWEEN BS 277 - 294 AT RBL 36. THE TRACK WAS REMOVED AND REPLACED IAW SRM 51-10-02.SDR C2XA03TY028Seat Track · corrodedDURING A SCHEDULED 2-C INSPECTION, MULTIBLE SEAT TRACKS HAD CORROSION. MAINTENANCE REMOVED AND REPLACED SEAT TRACKS IN THE CABIN IAW EMB 145MM-53-01-06. ALL WORK WAS ACCOMPLISHED AND WILL BE RELEASED UPON COMPLETION OF ALL WORK.SDR QXEA0300265Seat Track · gougedPDX - Y722 Y9.50L SEAT TRACK IS GOUGED. REPAIRED IAW HORIZON AIR EA 6-53-193.SDR QXEA0300264Seat Track · gougedPDX - X730 Y1.5R SEAT TRACK TOP FLANGE IS GOUGED. REPAIRED IAW HORIZON AIR EA 6-53-193.SDR QXEA0300263Seat Track · corrodedPDX - X739 Y9.5R SEAT TRACK HAS PITTING CORROSION. REPAIRED IAW HORIZON AIR EA 6-53-193.SDR P5CA0300795Seat Track · crackedSTA 1817 / LBL 98 / WL 208 CRACK ON SEAT TRACK. DAMAGED AREA TRIMMED OUT, REINFORCED WITH NEW SEAT TRACK PER SRM 53-10-05.SDR P5CA0300762Seat Track · crackedCRACK FOUND ON SEAT TRACK STA 1817/LBL 98 WL 208. DAMAGE AREA TRIMMED OUT. REINFORCED WITH NEW SEAT TRACK PER SRM 53-10-05.SDR P5CA0300794Seat Track · corrodedSTA 1760-1880 LBL & RBL 11 WL 208 CORROSION ON SEAT TRACK AND FLOORBEAM. DAMAGED AREA TRIMMED OUT, REINFORCED PER SRM 51-30-02 & 53-10-05 FIG 1 A.SDR P5CA0300791Seat Track · corrodedUPPER LOBE MAIN DECK, CORROSION ON SEAT TRACK LBL 11 BETWEEN STA 1940-1960. CORRODED PORTION SEAT TRACK REMOVED, REINFORCED WITH NEW SEAT TRACK PER SRM 53-11-25 FIG -7.SDR AALA20030126Seat Track · corrodedTUL - FOUND CORROSION SEAT TRACK NR 6 STATION 216 TO 219 TOP FORWARD END. REMOVED CORROSION PER SRM 51-10-3, REMOVAL WITH IN MANUAL LIMITS. TREATED AND PRIMED PER 51-10-3. (M)SDR C2XA03TY017Seat Track · corrodedDURING A SCHEDULED INSPECTION THE FORWORD TOP CAP BELOW THE LT SEAT TRACK WAS FOUND CORRODED. MAINTENANCE REPLACED THE RIVETS AND CLEANED CORROSION OFF OF THE TOP CAP IAW-EMB-145-SRM-57-40-02. THE REPAIR WAS SATISFACTORY AND THE AIRCRAFT WILL BE RELEASED UPOSDR SIMA200305010Seat Track · corrodedABI - DURING IMBV INSPECTION A LEVEL 2 FINDING FOUND, LEFT LOWER FORWARD NR 1 SEAT TRACK CORRODED AROUND HARDWARE. REMOVED AND INSTALLED LEFT LOWER NR 1 SEAT TRACK IAW EMB 145 SRM 53-01-06. (M)SDR P5CA0300797Seat Track · crackedFWD CGR SHEARED RIVETS ON SEAT TRACK & CRACK ON INTERCOSTAL BETWEEN LBL 25-LBL 45. DAMAGED INTERCOSTAL REMOVED NEW FABRICATED H/ 2024 T30.050 THK PER SAMPLER SRM 53-10-21. PROTECTED AREA PER SRM 51-10-02, RIVETED PER SRM 51-30-02.SDR P5CA0300812Seat Track · crackedCRACK ON SEAT TRACK RBL-25 STA 910. DAMAGED PORTION FLOOR TRACK REMOVED, NEW PORTION FABRICATED H/F 7178-76511 EXTRU BAC 1520-1682 PER SRM 53-11-25 SRM 51-40-02 (7075T6 TMSGO) RIVETED PER SRM 51-30-02.SDR P5CA300749Cargo Track · damagedLOWER LOBE AFT CARGO DISTORTION ON FLOOR TRACK SUPPORT LBL-25 BETWEEN STA 1900 - 1920. DAMAGE PORTION FLOOR TRACK REMOVED. NEW PORTION FABRICATED H/F 7178-T65H EXTRU BAC 1580-1688 PER SRM 53-11-25, FIG 7. ANGLE 7075-T6 THS 60-1350 PER SRM 51-40-02. RIVETEDSDR QXEA0300187Seat Track · corrodedPDX - NR 12 SEAT TRACK HAS LIGHT CORROSION AT STATION 516. REPAIRED IAW RD 8-53-3644, DHC-8 SRM 51-20-16 AND SRM 51-20-36SDR QXEA0300185Seat Track · scratchedPDX - NR 8 SEAT TRACK HAS SCRATCHES AT STATION 474-486. REPAIRED IAW RD 8-53-1339, DHC-8 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA0300186Seat Track · scratchedPDX - NR 9 SEAT TRACK HAS SCRATCHES AT STATION 531. REPAIRED IAW RD 8-53-4472 AND DHC-8 SRM 51-10-00.SDR QXEA0300184Seat Track · scratchedPDX - NR 5 SEAT TRACK HAS SCRATCHES AT STATION 440. REPAIRED IAW RD 8-53-1339, SRM 51-20-16 AND SRM 51-20-36.SDR QXEA0300183Seat Track · scratchedPDX - NR 5 SEAT TRACK HAS SCRATHES AT STATION 445-455. REPAIRED IAW RD 8-53-1339, DHC-8 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA0300182Seat Track · scratchedPDX - NR 5 SEAT TRACK HAS SCRATCHES AT STATION 470-482. REPAIRED IAW RD 8-53-1339, DHC-8 SRM 51-20-16 AND SRM 51-20-36.
Back to JASC 5347