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 05FDEA02662Seat Track · corrodedAFT CABIN SEAT TRACK CROWN AT STA 1349.5 TO 1353.5 RBL 107 FOUND CORROSION. CORRECTIVE ACTION: SNRM N0807: DISCREPANT SEAT TRACK CARRY OUT REPAIR AS PER SRM 53-70-00 FIG.1 VOL.I. CLASSIFIED MAJOR REPAIR AS PER GMM 6-2-100.SDR SWIA200516194Seat Track · corrodedFUSELAGE; FLOOR SEAT TRACK IS CORRODED; FS 559.00 + 40; RBL - 9.0, ITEM FOUND AT C-CHECK INSPECTION. INSTALLED SEAT TRACK FS 559.00 + 40; RBL - 9.0 IAW CRJ 200 AMM 53-01-11-400-802.SDR AWXA200501055Seat Track · corrodedMCN - MAJOR REPAIR - DURING C16 CHECK DISCOVERED CORROSION ON SEAT TRACK AT BS 827, BL 24L, WL 208. MAINTENANCE FOUND CORROSION TO BE OUT OF LIMITS IAW BOEING 737-30 SRM 53-00-52-1A FIG 101. CUT OUT DAMAGED SECTION OF SEAT TRACK AT BS 827, BL 24L, WL 208 IAWSDR 183Seat Track · damagedOB SEAT TRACK HAS SEVERAL ELONGATED HOLES FROM BS 460 TO 480.SDR 182Seat Track · corrodedCORROSION ON RT IB SEAT TRACK BS 365 TO 400.SDR DU4R0508181Seat Track · corrodedCORROSION ON RT OB SEAT TRACK BS 368 TO 400.SDR USAA051036Seat Track · crackedBS 662-670, RBL 24 CRACKED. STOP DRILLED CRACKS, INSTALLED REPAIR DOUBLER/CHANNELS IAW EA 96799, DEFECT SIZE: .250 X 2 INCH.SDR USAA051035Seat Track · crackedSEAT TRACK VERTICAL LEG HAS 0250 INCH CRACK AT CUTOUTS FOR FASTENERS. STOP DRILL CRACKS, INSTALL REPAIR ANGLES IAW EA 96799, DEFECT SIZE: 0250 INCH, CRACKED AT CUTOUTS FOR FASTENERS.SDR 05FDEA02585Seat Track · corrodedSEAT TRACK BETWEEN FS 71-73, LBL 32" HAS SEVERAL SPOTS OF CORROSION. REMOVED LIGHT SURFACE CORROSION IAW SRM 51-74-10 PG 204 .002 MAT LOSS FOUND TO BE WITHIN LIMITS IAW SRM 53-10-16 PG 103. TREATED AND PRIMED IAW SRM 51-21-10 PG 1 AND TOP COATED IAW SRM 51-SDR 05FDEA02584Seat Track · corrodedSEAT TRACK BETWEEN FS 69-70, LBL 37" HAS CORROSION. REMOVED LIGHT SURFACE CORROSION IAW SRM 51-74-10 PG 204 MAT LOSS .001, FOUND TO BE WITHIN LIMITS IAW SRM 53-10-16 PG 103. TREATED AND PRIMED IAW SRM 51-21-10 PG 1 AND TOPCOATED IAW SRM 51-23-00 PG 1.SDR CALA0500276Seat Track · corrodedINSPECTION FOUND CORROSION ON I/B SEAT TRACK AT FORWARD END, BS 328 +12, LBL 30 (CLOSET SUPPORT TRACK). THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 51-40-02.SDR CALA0500330Seat Track · corrodedTHE RT IB SEAT TRACK HAD CORROSION ON IB FLANGE AT STA 725-745, BL 0. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 51-40-02.SDR CALA0500271Seat Track · corrodedINSPECTION FOUND CENTER CLOSET SEAT TRACK CORRODED AT STA 360 PLUS 12 (OUTBOARD TRACK), LBL 41 TO LBL 42. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 51-40-02, 53-00-52, AND AMM 20-30-11-910-801, AND 20-50-11-910-801.SDR SIMA200524111Seat Track · corrodedTHE SEAT TRACK AT BL 0 WAS FOUND CORRODED. REMOVED THE EXISTING SEAT TRACK AND CLEANED THE AREA. INSTALLED NEW SEAT TRACK. REPAIR DONE IAW SAAB 340 SRM, SRM 72LKS3079 REV 45, CHAPTER 53-70-60 PARA 8. (M)SDR 05FDEA02510Seat Track · corrodedMAIN DECK SEAT TRACK AT STATION Y1092, -X8.5 FOUND CORRODED. REPAIR CARRIED OUT AS PER SRM 53-70-00 FIGURE I VOLUME I AT STATION Y1009 TO STATION Y1129, -X8.5.SDR 05FDEA02509Seat Track · corrodedCABIN SEAT TRACK AT STATION Y1019, -X8.5 FOUND CORRODED. REPAIR CARRIED OUT AS PER SRM 53-70-00 FIGURE I VOLUME I AT STATION Y1009 TO STATION Y1129, -X8.5.SDR 05FDEA02512Seat Track · corrodedMAIN DECK SEAT TRACK AT STATION Y1124, -X8.5 FOUND CORRODED. REPAIR CARRIED OUT AS PER SRM 53-70-00 FIGURE I VOLUME I AT STATION Y1009 TO STATION Y1129, -X8.5.SDR 05FDEA02507Seat Track · corrodedCABIN SEAT TRACK AT STATION Y1049, -X8.5 FOUND CORRODED. REPAIR CARRIED OUT AS PER SRM 53-70-00 FIGURE I VOLUME I AT STATION Y1009 TO STATION Y1129, -X8.5.SDR MWEA050085Seat Track · corrodedSEAT TRACK CORRODED AT STATION 207. FABRICATED AND INSTALLED SEAT TRACK.SDR MWEA050084Seat Track · corrodedSEAT TRACK, TWO SCREWS MISSING AT STATION 1270 AND CORROSION AROUND THE HOLE. FABRICATED AND INSTALLED SEAT TRACK.SDR MWEA050086Seat Track · corrodedNR 2 SEAT TRACK CORRODED, FORWARD END. FABRICATED AND INSTALLED SEAT TRACK.SDR MWEA050083Seat Track · damagedFIRST OFFICER'S, INBOARD SEAT TRACK HOLES ARE ENLONGATED. FABRICATED AND INSTALLED SEAT TRACK.SDR SIMA200524104Seat Track · corrodedSEAT TRACK AT BL 18.3 BETWEEN STATION 297 AND STATION 329 WAS FOUND TO BE CORRODED. CUT OUT SECTION OF EXISTING SEAT TRACK. PREPARED A 32.5 REPAIR SECTION FROM NEW SEAT TRACK. PREPARED A 15 INCH REPAIR U BEAM. REPAIR DONE IAW SAAB 340 SRM, SRM 72LKS3079 RESDR UPS05M45360Seat Track · corrodedCABIN SEAT TRACK AT STA 824-840 LBL =107.25 FOUND SEVERAL PLACES CORRODED. SEAT/T CORROSION REMOVED FOUND OUT OF LIMIT, (ORI THK 0.080" AND MAT REMOVED THK 0.030", PER SRM 53-70-00.F3.V.1.R37. DAMAGED PORTION OF SEAT/T CUT REMOVED. SPLICE AND NEW SEAT/TRACKSDR 05FDEA02502Seat Track · crackedFORWARD CARGO CEILING AREA, SEAT TRACK AT STA 635, LBL 8.5 FOUND CRACKED. 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 CARRIED OUT AS PER NDT SPM 06-10-01-SDR ASAA0540399Seat Track · corrodedPAE - FOUND SEAT TRACK CORRODED AT BS 907 RBL 25 WL 208. REMOVED REPLACED SEAT TRACK. (M)SDR ASAA0540413Seat Track · corrodedCORROSION ON SEAT TRACK FLANGE, BSTA 344, LBL 45, WL 208. REMOVED AND REPLACED SEAT TRACK IAW SRM. (K)SDR 05FDEA02491Seat Track · corrodedMAIN DECK SEAT TRACK AT STATION Y5-02 TO 5-20, -X8.5 FOUND CORRODED. MAIN DECK SEAT TRACK AT STATION Y5-00 TO STATION Y5-123, -X8.5 REPAIR CARRIED OUT AS PER SRM 53-70-00 FIGURE I VOLUME I. CLASSIFIED REPAIR AS MAJOR AS PER GMM 6-2-100.SDR 05FDEA02490Seat Track · corrodedCABIN SEAT TRACK AT STATION Y1064, -X8.5 FOUND CORRODED. MAIN DECK SEAT TRACK AT STATION Y1009 TO STATION Y1129, -X8.5 REPAIR CARRIED OUT AS PER SRM 53-70-00 FIGURE I VOLUME I. CLASSIFIED REPAIR AS MAJOR AS PER GMM 6-2-100.SDR AWXA200501012Seat Track · corrodedSAL - MAJOR REPAIR - DURING C3 CHECK DISCOVERED CORROSION ON SEAT TRACK LOCATED ON THE RT INBOARD SIDE AT FR 20+10" Y-765. MAINTENANCE REMOVED CORROSION AND FOUND REWORK TO BE OUT OF LIMITS IAW AIRBUS 320 SRM 53-31-15. REMOVED SEAT TRACK AT FR 20+10" Y-765 ASDR AWXA200501010Seat Track · corrodedSAL - MAJOR REPAIR - DURING C3 CHECK DISCOVERED CORROSION ON SEAT TRACK LOCATED ON THE RT INBOARD SIDE AT FR 36" Y-765. MAINTENANCE REMOVED CORROSION AND FOUND REWORK TO BE OUT OF LIMITS IAW AIRBUS 320 SRM 53-31-15. REMOVED SEAT TRACK AT FR 36" Y-765 AND INSDR AWXA200501005Seat Track · corrodedSAL - DURING C3 CHECK, DISCOVERED CORROSION ON SEAT TRACK LOCATED ON THE RT OUTBOARD SIDE AT FR 39 +3" Y-1292. MAINTENANCE REMOVED CORROSION AND FOUND REWORK TO BE OUT OF LIMITS IAW AIRBUS 320 SRM 53-31-15. REMOVED SEAT TRACK AT FR 39 +3" Y-1292 AND INSTALLESDR AWXA200501004Seat Track · corrodedSAL - DURING C3 CHECK, DISCOVERED CORROSION ON SEAT TRACK LOCATED ON THE LT INBOARD SIDE AT FR 39 +10" Y765. MAINTENANCE REMOVED CORROSION AND FOUND REWORK TO BE OUT OF LIMITS IAW AIRBUS 320 SRM 53-31-15. REMOVED SEAT TRACK AT FR 39 +10" Y765 AND INSTALLED NSDR AWXA200501003Seat Track · corrodedSAL - DURING C3 CHECK, DISCOVERED CORROSION ON SEAT TRACK LOCATED ON THE LT OUTBOARD SIDE AT FS 42 +16" Y1292. MAINTENANCE REMOVED CORROSION AND FOUND REWORK TO BE OUT OF LIMITS IAW AIRBUS 320 SRM 53-31-15. REMOVED SEAT TRACK AT FS 42 +16" Y1292 AND INSTALLESDR AWXA200501002Seat Track · corrodedSAL - DURING C3 CHECK, DISCOVERED CORROSION ON SEAT TRACK LOCATED ON THE LT OUTBOARD SIDE AT FS 36 +16" Y1292. MAINTENANCE REMOVED CORROSION AND FOUND REWORK TO BE OUT OF LIMITS IAW AIRBUS 320 SRM 53-31-15. REMOVED SEAT TRACK AT FR 36 +16" Y1292 AND INSTALLESDR AWXA200501001Seat Track · corrodedSAL - DURING C3 CHECK, DISCOVERED CORROSION ON SEAT TRACK LOCATED AT LT INBOARD SIDE AT FR 44+7, Y765. MAINTENANCE REMOVED CORROSION AND FOUND REWORK TO BE OUT OF LIMITS IAW AIRBUS 320 SRM 53-31-15. REMOVED SEAT TRACK AT FR 44+7, Y765 AND INSTALLED NEW SEAT SDR AWXA200501000Seat Track · corrodedSAL - DURING C3 CHECK DISCOVERED CORROSION ON SEAT TRACK LOCATED AT RT INBOARD SIDE AT FR 42+17, -Y765. MAINTENANCE REMOVED CORROSION AND FOUND REWORK TO BE OUT OF LIMITS IAW AIRBUS 320 SRM 53-31-15. REMOVED SEAT TRACK AT FR 42+17, -Y765 AND INSTALLED NEW SESDR AWXA200500999Seat Track · corrodedSAL - DURING C3 CHECK, DISCOVERED CORROSION ON SEAT TRACK LOCATED AT RT OUTBOARD SIDE AT FR 42+17, -Y1292. MAINTENANCE REMOVED CORROSION AND FOUND REWORK TO BE OUT OF LIMITS IAW AIRBUS 320 SRM 53-31-15. REMOVED SEAT TRACK AT FR 42+17, -Y1292 AND INSTALLED NESDR MWEA050079Seat Track · corrodedLEFT SIDE SEAT TRACK INBOARD SIDE BETWEEN STATION 1126 AND 1260 REQUIRES SPLICING DUE TO OUT OF LIMITS MATERIAL REMAINING AFTER CORROSION REMOVAL. FABRICATED AND INSTALLED SEAT TRACK.SDR MWEA050078Seat Track · corrodedMAIN CABIN, LEFT OUTBOARD SEAT TRACK STATION 1105 TO 1117 IS CORRODED. FABRICATED AND INSTALLED SEAT TRACK.SDR EIA2005247Seat Track · corrodedCABIN BS 160-175 RBL 10" SEAT TRACK FLANGE FOUND CORROSION. SEAT TRACK REPLACED FROM BS 140-185 RBL 10" AND INSTALLED PER SRM 51-1-01 AND 51-30-02.SDR EIA2005157Seat Track · corrodedCABIN BS 515-520 LBL 33 SEAT TRACK FOUND CORROSION. SEAT TRACK REPLACED FROM BS 510-590, INSTALLED PER SRM 51-10-01 AND 51-30-02.SDR MWEA050077Seat Track · corrodedMAIN CABIN LEFT OUTBOARD SEAT TRACK FLANGES AROUND NUT PLATE HOLES, STATION 1250 TO 1309 IS CORRODED. FABRICATED AND INSTALLED SPLICE.SDR SIMA200524105Seat Track · corrodedTHE LEFT UPPER SEAT TRACK WAS FOUND TO BE CORRODED. REMOVED THE CORRODED LEFT UPPER SEAT TRACK. INSTALLED NEW SEAT TRACK. REPAIR DONE IAW SAAB 340 SRM, SRM 72LKS3079 REV 45, CHAPTERS 51-40-21, 51-40-22 AND 51-40-40. (M)SDR ABXA050198Seat Track · crackedSEAT TRACK CRACKED AT STA 200, RIGHT BUTT LINE 10. REMOVED AND REPLACED SEAT TRACK RIGHT BUTT LINE 10, FS 200 TO FS 155 IAW DC-9 SRM 51-30-2 AND 51-30-1.SDR CALA0500278Seat Track · corrodedINSPECTION FOUND I/B CLOSET SEAT TRACK CORRODED AT STA 360 + 12, LBL 22.5. THE SEAT TRACK WAS REMOVED AND A NEW SEAT TRACK WAS INSTALLED IAW SRM 51-40-02.SDR 05FDEA02307Seat Track · corrodedCENTER CARGO - UPPER DECK SEAT TRACK X = -8.50 FROM STA 5-73 TO STA 1681 FOUND METAL CLIP NUTS AND SURROUNDING STRUCTURE CORRODED. CARRIED OUT REPAIR AS PER SRM 53-70-00.SDR 05FDEA02306Seat Track · corrodedCENTER CARGO - UPPER DECK SEAT TRACK X = -75.25 FROM STA 5-73 TO STA 1681 FOUND METAL CLIP NUTS AND SURROUNDING STRUCTURE WITH CORROSION. CARRIED OUT REPAIR AS PER SRM 53-70-00.SDR 05FDEA02305Seat Track · corrodedCENTER CARGO CEILING UPPER DECK SEAT TRACK RBL 8.0 FOUND CORRODED AT STA 1561. REPAIR CARRIED OUT AS PER SRM 53-70-00.SDR 05FDEA02304Seat Track · damagedMAIN DECK CARGO COMPARTMENT, FLOOR SEAT TRACK CROWN AT STA 1139, X= -47 FOUND ELONGATED. MAIN DECK CARGO COMP'T FLOOR SEAT TRACK REPAIR CARRIED OUT AS PER SRM 53-70-00 FIG. 1 VOL. I. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100.
Back to JASC 5347