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 IXXA060199SCargo Track · corrodedDURING ROUTINE C CHECK, FOUND TRACK CORRODED FROM STATION 990 TO STATION 1380 + X17 AT LONGERON 33 LEFT HAND. REPLACED CARGO TRACK SECTION FROM STATION 1140 TO STATION 1380 + X17 PER ALL APPLICABLE DATA.SDR IXXA060198SCargo Track · corrodedDURING ROUTINE C CHECK FOUND TRACK CORRODED FROM STATION Y990 TO Y1020 AT TX45 TO Z 0. REPLACED DAMAGED TRACK PER ALL APPLICABLE DATA.SDR USAA040268Seat Track · corrodedBFM - FOUND TRACK CORRODED .150 INCH BY .045 INCH BY .025 INCH AREA, SEAT TRACK, FRAME 23,Y-1292. REMOVED AND REPLACED TRACK PER SRM 53-00-15. CORROSION LEVEL 2, TASK NR JA-220-53500. (M)SDR MALA040452Seat Track · corrodedDURING 4K INSPECTION IN LCQ, FS 294 RIGHT I/B SEAT TRACK HAS CORROSION. MAINTENANCE REMOVED AND REPLACED CORRODED SECTION OF RIGHT I/B SEAT TRACK AT FS 294 IAW MESABA EO S53060. AIRCRAFT RELEASE DATE 6/23/04.SDR MALA040451Seat Track · corrodedDURING 4K INSPECTION IN LCQ, FS 294 LEFT I/B SEAT TRACK HAS CORROSION. MAINTENANCE REMOVED AND REPLACED CORRODED SECTION OF LEFT I/B SEAT TRACK AT FS 294 IAW MESABA EO S53060. AIRCRAFT RELEASE DATE 6/23/04.SDR GTIA040622Seat Track · corrodedFOUND LEFT OUTBOARD SEAT TRACKS STATION 200-798 GOUGED AND CORRODED. FOUND STATION 790-798 OUT OF LIMITS. REMOVED SEAT TRACK STATION 760-837. LOCATED AND DRILLED NEW TRACK SECTION AND SPLICE. INSTALLED SEAT TRACK. (M)SDR GTIA040620Seat Track · gougedFOUND RIGHT INBOARD SEAT TRACKS STATION 200-798 GOUGED AND CORRODED. FOUND STATION 200 TO 370 IS OUT OF LIMITS. REMOVED SEAT TRACK. LOCATED AND DRILL NEW RIGHT INBOARD SEAT TRACK. LOCATED AND DRILLED THREE EACH SPLICES. INSTALLED THEE SPLICE. INSTALLED RSDR GTIA040612Seat Track · corrodedFTW - FOND LEFT INBOARD SEAT TRACKS STATION 200-798 GOUGED AND CORRODED. MATERIAL OUT OF LIMITS STATION 200-270. REMOVED SEAT TRACK. FABRICATED RIGHT INBOARD SEAT TRACK. LOCATED AND DRILLED SEAT TRACK AND SPLICE. INSTALLED SEAT TRACK. INSTALLED SPLICE. SDR GTIA040611Seat Track · corrodedFTW - FOUND LEFT OUTBOARD SEAT TRACKS STATION 798-1309 GOUGED AND CORRODED. OUT OF LIMITS FROM STATION 1032-1309. REMOVED SEAT TRACK STATIN 1032-1309. FABRICATED THREE NEW SEAT TRACKS FROM STATION 1032 TO 1136, 1136 TO 1250 AND 1250 TO 1309. FABICATED TWO SPSDR GTIA040608Seat Track · corrodedFTW - FOUND RIGHT OUTBOARD SEAT TRACKS STATION 700-798 GOUGED AND CORRODED. SEAT TRACK 790-798 OUT OF LIMITS. REMOVED RIGHT OUTBOARD SEAT TRACK STATION 778-798. DRILLED AND LOCATED RIGHT OUTBOARD REPAIR SEAT TRACK STATION 778-798. INSTALLED SEAT TRACK STATSDR GTIA040613Seat Track · corrodedFTW - FOUND LEFT INBOARD SEAT TRACKS STATION 798-1309 GOUGED AND CORRODED. CUT OUT SEAT TRACK SECTION FROM STATION 936.5-1309. LOCATED AND DRILLED 4 EACH SECTION SEAT TRACKS AT STATION 936-1051, 1051-1146, 1146-1222 AND 1222-1309. LOCATED AND DRILLED 4 SPLISDR UPS04842620Seat Track · brokenINSPECTION TYPE: C, LUG BROKEN POS 3 LEFT O/B SEAT TRACK PLANK NEXT TO LOCK. REMOVED AND REPLACED SEAT TRACK PLANK SECTION FS-200 TO FS-265-00.SDR AWXA200400667Seat Track · corrodedMCN - MAJOR REPAIR - DURING C-04 CHECK CORROSION WAS FOUND ON BEAM Y765 LT INBOARD SEAT TRACK BETWEEN FR 20 AND FR 23. MAINTENANCE CUT OUT DAMAGED SECTION OF SEAT TRACK ON BEAM Y765 LT FROM FR 19+10 INCHES TO FR 24; FABRICATED A NEW REPLACEMENT SECTION OF SEASDR AWXA200400666Seat Track · corrodedMCN - MAJOR REPAIR - DURING C-04 CHECK CORROSION WAS FOUND ON BEAM Y1292 LT OUTBOARD SEAT TRACK BETWEEN FR 20 AND FR 23. MAINTENANCE CUT OUT DAMAGED SECTION OF SEAT TRACK ON BEAM Y1292 LT FROM FR 19+10 TO FR 24; FABRICATED A NEW REPLACEMENT SECTION OF SEAT TRSDR AWXA200400685Seat Track · corrodedDURING C-04 CHECK CORROSION WAS FOUND ON BEAM Y765 LT IB SEAT TRACK BETWEEN FR 41 AND FR 47. MAINTENANCE REMOVED DAMAGED SECTION OF SEAT TRACK ON BEAM Y765 LT FROM FR 41 TO FR 47; FABRICATED A NEW REPLACEMENT SECTION OF SEAT TRACK; INSTALLED REPAIR PART IAW SDR AWXA200400675Seat Track · corrodedMCN - MAJOR REPAIR - DURING C-04 CHECK CORROSION WAS FOUND ON BEAM Y765 LT INBOARD SEAT TRACK BETWEEN FR 36 AND FR 41. MAINTENANCE CUT OUT DAMAGED SECTION OF SEAT TRACK ON BEAM Y765 LT FROM FR 36 TO FR 41; FABRICATED A NEW REPLACEMENT SECTION OF SEAT TRACK; ISDR AWXA200400674Seat Track · corrodedMCN - MAJOR REPAIR - DURING C-04 CHECK CORROSION WAS FOUND ON BEAM Y1292 LT OUTBOARD SEAT TRACK BETWEEN FR 37 AND FR 41. MAINTENANCE REMOVED DAMAGED SECTION OF SEAT TRACK ON BEAM Y1292 LT FROM FR 37 TO FR 41; FABRICATED A NEW REPLACEMENT SECTION OF SEAT TRACKSDR AWXA200400672Seat Track · corrodedMCN - MAJOR REPAIR - DURING C-04 CHECK CORROSION WAS FOUND ON UPPER SURFACE AND INSIDE THE TRACK CHANNEL OF BEAM Y1292 RT OUTBOARD SEAT TRACK BETWEEN FR 41 AND FR 47. MAINTENANCE REMOVED DAMAGED SECTION OF SEAT TRACK ON BEAM Y1292 RT FROM FR 41 TO FR 47; FABRSDR AWXA200400671Seat Track · corrodedMCN - MAJOR REPAIR - DURING C-04 CHECK CORROSION WAS FOUND ON BEAM Y765 RT INBOARD SEAT TRACK BETWEEN FR 41 AND FR 47. MAINTENANCE REMOVED DAMAGED SECTION OF SEAT TRACK ON BEAM Y765 RT FROM FR 41 TO FR 47; FABRICATED A NEW REPLACEMENT SECTION OF SEAT TRACK; ISDR AWXA200400670Seat Track · corrodedDURING C-04 CHECK CORROSION WAS FOUND ON BEAM Y765 RT INBOARD SEAT TRACK BETWEEN FR 47 AND FR 64. MAINTENANCE CUT OUT DAMAGED SECTION OF SEAT TRACK ON BEAM Y765 RT FROM FR 47 TO FR 64; FABRICATED A NEW REPLACEMENT SECTION OF SEAT TRACK; INSTALLED REPAIR PART SDR AWXA200400669Seat Track · corrodedDURING C-04 CHECK CORROSION WAS FOUND ON BEAM Y1292 LT OUTBOARD SEAT TRACK BETWEEN FR 41 AND FR 47. MAINTENANCE CUT OUT DAMAGED SECTION OF SEAT TRACK ON BEAM Y1292 LT FROM FR 41 TO FR 47; FABRICATED A NEW REPLACEMENT SECTION OF SEAT TRACK; INSTALLED REPAIR PASDR AWXA200400668Seat Track · corrodedDURING C-04 CHECK CORROSION WAS FOUND ON BEAM Y765 RT INBOARD SEAT TRACK BETWEEN FR 36 AND FR 41. MAINTENANCE CUT OUT DAMAGED SECTION OF SEAT TRACK ON BEAM Y765 RT FROM FR 36 TO FR 41; FABRICATED A NEW REPLACEMENT SECTION OF SEAT TRACK; INSTALLED REPAIR PART SDR AWXA200400665Seat Track · corrodedMCN - MAJOR REPAIR - DURING C-04 CHECK EXFOLIATION CORROSION WAS FOUND ON BEAM Y765 RT INBOARD SEAT TRACK BETWEEN FR 47 AND FR 64. MAINTENANCE REMOVED CORROSION AND FOUND ONLY THE AREA OF BEAM Y765 RT INBOARD SEAT TRACK BETWEEN FR 55 AND FR 64 WAS OUT OF LIMISDR 04FDEA01621Seat Track · gougedMAIN CARGO COMPT SEAT TRACK HAS GOUGED AREAS AT STA 791-808 RBL 27. SEAT TRACK OUT OF LIMITS IAW SRM 53-70-00. REMOVED DAMAGED SECTION OF SEAT TRACK, FABBED NEW SECTION OF SEAT TRACK AND SPLICES ON MAE TRAVELERS T4/434273, T4/434274, T4/434272. LOCATED AND SDR 04FDEA01620Seat Track · gougedMAIN CARGO COMPT SEAT TRACK HAS GOUGED AREAS AT STA 791-808 RBL 45. REMOVED SEAT TRACK SECT AT STA 766-815. FABBED NEW TRACK AND SPLICES ON MAE TRAVELERS, T4/434382, T4/434383, T4/434384. LOCATED AND DRILLED IAW SRM 53-70-00. TREATED AND PRIMED IAW SRM 51-SDR AWXA200400677Seat Track · corrodedMCN - MAJOR REPAIR - DURING C-04 CHECK FILIFORM CORROSION WAS FOUND ON UPPER SURFACE OF FLOOR RAIL Y81 RIGHT AT FR 16. MAINTENANCE REMOVED DAMAGED FLOOR RAIL Y81 RIGHT AT FR 16; FABRICATED A NEW REPLACEMENT RAIL; INSTALLED REPAIR PART IAW A320 51-42-11 PG 6-7SDR MALA040441Seat Track · corrodedDURING 4Y/2Y INSPECTION IN LCQ, FS 294 TO FS 319 RIGHT O/B SEAT TRACK CORRODED. REMOVED AND REPLACED CORRODED SECTION OF SEAT TRACK IAW MESABA EO S53060. AIRCRAFT RELEASE DATE 6/7/04.SDR SIMA200416001Seat Track · corrodedABI - DURING AN MBV INSPECTION, THE CABIN SEAT TRACK AT BL 0.0 WAS FOUND TO BE CORRODED BEYOND SRM LIMITS AT THE WING BOX. REMOVED CORRODED SEAT TRACK AND INSTALLED NEW TRACK IAW SAAB 340 SRM, 72LKS3079, REV 43, 53-70-60 PARA 8 AND STANDARD SRM PRACTICES. (MSDR USAA040312Seat Track · corrodedBFM - FOUND SEAT TRACK CORRODED .135 INCH LONG BY .060 INCH WIDE BY .017 INCH DEEP AREA, BETWEEN FRAME 21 AND 23, BL Y-965, -Z240. REMOVED AND REPLACED SEAT TRACK PER SRM 53-00-15 FIG 101. (M)SDR USAA040271Seat Track · corrodedBFM - FOUND TRACK CORRODED .85 INCH BY .75 INCH BY .36 INCH DEEP, MAIN DECK FLOOR SUPPORT, FRAME 16, Y 1292. REMOVED AND REPLACED TRACKS PER SRM 53-11-14. CORROSION LEVEL 2, TASK NR JA-220-53500. (M)SDR USAA040276Seat Track · corrodedBFM - FOUND BEAM ASSEMBLY SEAT TRACK 2 INCHES BY 1.6 INCH BY .070 IND DEEP AREA, FRAME 64-66, -Y765, -Z240. REMOVED AND REPLACED BEAM PER SRM 51-74-00, 53-00-14, 51-42-11, 51-21-11, 51-23-11. (M)SDR UPS04242566Seat Track · corrodedINSPECTION TYPE:N/A ON INSPECTION SEAT TRACK SECTION FOUND CORRODED AT BS 730 AT RBBL 625 APPROX. NEW SEAT TRACK SECTION FABRICATED IAW SRM 51-20-1 AND ALODINED AND PRIMED IAW SRM 51-10-02. SEAT TRACK INSTALLED IAW EO B727-5310-7477 STEP 28.SDR 04FDEA01568Seat Track · corrodedNR 2 RT TRACK BETWEEN FR 45 & 54, LEVEL 2 CORROSION IN TRACK, AND FR 47 & 48, 2EA AREAS, FR 46 & 47 2EA AREAS OF LEVEL 2 CORROSION, FR 48 & 49 2EA AREAS BROKEN RIVETS AND BARE METAL ALONG FLANGE. REMOVED DAMAGED TRACK, FABBED NEW TRACK AND INSTALLED IAW SRM'SSDR 04FDEA01567Seat Track · chippedSEAT TRACK 5L 4 INCHES FWD OF FRAME 23 HAS CHIPPED SCALLOP. REMOVED DAMAGED SECTION OF TRACK, FABBED REPAIR SPLICE IAW SRM 53-10-16, AND INSTALLED SPLICE IAW SRM'S 51-10-08, 51-35-00, AND 51-40-21.SDR 04FDEA01559Seat Track · corrodedMAIN CARGO SEAT TRACK IS CORRODED AROUND FLOOR BOARD FASTENER HOLES STA 1219 RBL 74-86. REMOVED AND REPLACED SECTION OF SEAT TRACK AND SPLICES IAW SRM 53-20-00-01 AT MAE.SDR 04FDEA01550Seat Track · gougedMAIN CABIN TRACK 3R: 1) A WORN SCALLOP AT FR 24. 2) GOUGES ON TOP OF SCALLOPS AT FR 22. 3) GOUGED SCALLOPS AT FR 20 TO 21. BLENDED AREAS 2 AND 3 IAW A300-600 SRM 51-73-10, WITHIN LIMITS PER SRM 53-10-16. FOR AREA 1 AT FR 24 REF EA 6-5320-78360 FOR REPAIR,SDR 04FDEA01549Seat Track · corrodedSEAT TRACK 3R HAS 6 EA AREAS OF CORROSION. 1) 8 INCHES FWD OF FR27. 2) 4 INCHES FWD OF FR27. 3) 6 INCHES AFT OF FR30. 4) 8 INCHES AFT FR32. 5) 10 INCHES AFT OF FR33. 6) 4 INCHES AFT OF FR38.1. REMOVED CORROSION 6 AREAS IAW A300-600 SRM 53-10-16, AREA 3 SDR 04FDEA01545Seat Track · corrodedBETWEEN FR 28 AND FR 29 AT TRACK 2L THERE IS AREAS OF CORROSION (MAIN CARGO) AND FROM FR 30 TO FR 38, 12 EA AREA OF CORROSION. REMOVED CORROSION IAW A300-600 SRM 51-74-10, MEASURED MAT'L LOSS, CHECKED MAT'L LIMITS PER SRM 53-10-16 FIG 102, REPAIRED SEAT TRACKSDR 04FDEA01544Seat Track · corrodedMAIN DECK CARGO COMP BETWEEN FR 45 AND FR 54, L4 SEAT TRACK HAS 6 AREAS OF CORROSION. 1) 6 INCHES AFT OF FR 45. 2) 12 INCHES AFT OF FR47. 3) 5 INCHES FWD OF FR49. 4) 2 INCHES FWD OF FR50. 5) 7 INCHES FWD OF FR 53. 6) 12 INCHES AFT OF FR53. REMOVED CORROSDR 04FDEA01543Seat Track · corrodedSEAT TRACK 1 (CENTER TRACK) HAS 6 EA AREAS OF CORROSION INCLUDING ON AND UNDER SCALLOPS. 1) 10 INCHES AFT OF FR 71 AT PRODUCTION BREAK. 2) BETWEEN FR 73 & FR 74. 3) BETWEEN FR 75 & FR76. 4 & 5) BETWEEN FR 75 & 76. 6) 2 INCHES AFT OF FR 78. REMOVED DISCRESDR 04FDEA01542Seat Track · corrodedSEAT TRACK 4R HAS 1 EA AREA ON AND UNDER SCALLOP WITH CORROSION 10 INCHES AFT OF FR 74. REMOVED CORROSION IAW A300-600 SRM 51-74-10, MAT'L LOSS OUT OF LIMITS. REMOVED DAMAGED SECTION SEAT TRACK, LOCATED DRILLED, AND INSTALLED SEAT TRACK SECTION IAW A300-600 SDR USAA040266Seat Track · corrodedBFM - FOUND SEAT TRACK CORRODED .750 INCH LONG BY .600 INCH WIDE BY .077 INCH DEEP, SEAT TRACK FRAME 16 AT Y + 765, -Z240. REMOVED AND REPLACED SEAT TRACK IAW SRM 51-42-11, SRM 53-11-14. CORROSION LEVEL 2, TASK NR JA-220-53500. (M)SDR 04FDEA01516Seat Track · corrodedSEAT TRACK 5R FROM 8 INCHES FWD OF FR 45 TO FR 54 HAS 3 EA AREAS OF CORROSION, ONE AREA OUTBOARD FLANGE WITH GOUGES AT FR 47, AND 7 AREAS OF ELONGATED HOLES WITH GOUGES ON INBOARD FLANGE BETWEEN FR 48 TO FR 51. REMOVED CORROSION AND GOUGES IAW A300-600 SRM 51SDR 04FDEA01515Seat Track · corrodedTRACK 3L SECTION FROM 10 INCHES AFT OF FR 71 TO 10 INCHES FWD OF FR 74 HAS 4 AREAS OF CORROSION INCLUDING ON AND UNDER SCALLOPS, AT FR 72, BETWEEN FR 72 AND 73, 2 INCHES AFT OF FR 74. REMOVED SEAT TRACK, FABRICATED REPLACEMENT TRACK, TREATED, PRIMED AND TOP CSDR 04FDEA01513Seat Track · corrodedSEAT TRACK NR 4L SECTION FROM FR 74 TO FR 80/82 HAS 3 EA AREAS OF CORROSION, INCLUDING ON AND UNDER SCALLOPS, BETWEEN FR 74 AND FR 75, 10 INCHES AFT OF FR 75, 3 INCHES FWD OF FR 76. REMOVED CORROSION FROM SEAT TRACK, MAT'L LOSS AT AREAS AND ARE OUT OF LIMITS SDR QXEA200400368Seat Track · corrodedPDX - SEAT TRACK NR 4 HAS AREA OF CORROSION IN CENTER OF TRACK AT STATION X377. REPLACED NR 4 SEAT TRACK.SDR QXEA200400366Seat Track · chafedPDX - SEAT TRACK NR 4 HAS CHAFE IN CENTER OF TRACK FROM STATION X285 TO X298. REPLACED NR 4 SEAT TRACK.SDR QXEA200400365Seat Track · corrodedPDX - SEAT TRACK NR 4 HAS CORROSION ON TOP OF TRACK AT APPROXIMATELY STATION X253. REPLACED NR 4 SEAT TRACK.SDR QXEA200400364Seat Track · corrodedPDX - SEAT TRACK 4 HAS CORROSION ON FLANGE AND ON EDGE OF NUTPLATE FLANGE AT STATION X240 ON OB SIDE. REPLACED SEAT TRACK.SDR QXEA200400367Seat Track · chafedPDX - SEAT TRACK 4 HAS LIGHT CHAFE THROUGH PRIMER FROM STATION X315 TO X328. REPLACED NR 4 SEAT TRACK.
Back to JASC 5347