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 RRXA002432Seat Track · damagedDURING A MAINTENANCE VISIT FOUND ELONGATED HOLES TO THE SEAT TRACK AT FS 1260 - 1380 XCW 22 RT, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. RECEIVED REPAIR AND INSTALLED IAW DC-8 SRM 53-2-3, FIG 12 ASDR RRXA002431Seat Track · damagedDURING A MAINTENANCE VISIT FOUND ELONGATED HOLES TO THE SEAT TRACK AT FS 980 - 1125 XCW 57 LT, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. RECEIVED AND INSTALLED NEW TRACK IAW ROSENBALM DWG NR 24300 AND EA NR 7SDR RRXA002430Seat Track · damagedDURING A MAINTENANCE VISIT FOUND ELONGATED HOLES TO THE SEAT TRACK AT FS 1400 - 1440 XCW 0, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. RECEIVED AND INSTALLED NEW TRACK IAW ROSENBALM DWG NR 24300 AND EA NR 77-9SDR RRXA002429Seat Track · damagedDURING A MAINTENANCE VISIT FOUND GOUGES AND MISDRILLED HOLES IN THE SEAT TRACK AT FS 1220 - 1260, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. RECEIVED AND INSTALLED NEW TRACK IAW ROSENBALM DWG NR 24300 AND EA NSDR RRXA002428Seat Track · damagedDURING A MAINTENANCE VISIT FOUND ELONGATED HOLES TO THE SEAT TRACK AT FS 822-849 XCW 57 LT, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. RECEIVED AND INSTALLED NEW TRACK IAW ROSENBALM DWG NR 24300 AND EA NR 77-9SDR RRXA002427Seat Track · damagedDURING A MAINTENANCE VISIT FOUND ELONGATED HOLES TO THE SEAT TRACK AT FS 960 - 980 AND XCW 47 LT, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. RECEIVED AND INSTALLED NEW TRACK IAW DC-8 SRM 53-2-3, FIG 12, 51-1-3SDR RRXA002426Seat Track · damagedDURING A MAINTENANCE VISIT FOUND ELONGATED HOLES TO THE SEAT TRACK AT FS 883 - XCW 47 LT, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. RECEIVED AND INSTALLED NEW TRACK IAW DC-8 SRM 51-3-0, ROSENBALM DSDR RRXA002425Seat Track · damagedDURING A MAINTENANCE VISIT FOUND ELONGATED HOLES IN THE SEAT TRACK AT FS 980 - XCW O, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. RECEIVED AND INSTALLED PART IAW ROSENBALM DWG NR 24300 AND EA NR 77-995CF DATED SDR RRXA002424Seat Track · damagedDURING A MAINTENANCE VISIT FOUND ELONGATED HOLES IN THE SEAT TRACK AT FS 525 - XCW 22.5 LT, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. RECEIVED AND INSTALLED TRACK IAW ROSEMBALM DWG NR 24300 AND EO NR 77-995CFSDR RRXA002422Seat Track · damagedDURING A MAINTENANCE VISIT FOUND ELONGATED HOLES IN THE SEAT TRACK AT FS 460-XCW 47 LT, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. RECEIVED AND INSTALLED NEW PART IAW EO NR 77-995CF DATED 5-22-00 ANSDR RRXA002421Seat Track · damagedDURING A MAINTENANCE VISIT FOUND ELONGATED HOLES IN THE SEAT TRACK AT FS 690 - 702, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. RECEIVED AND INSTALLED NEW PART IAW EA NR 77-995CF, ROSENBALM DWG NR 24SDR RRXA002420Seat Track · damagedDURING A MAINTENANCE VISIT FOUND ELONGATED HOLES TO THE SEAT TRACK AT FS 440-XCW 0, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. RECEIVED AND INSTALLED NEW PART IAW EA NR 77-995CF, ROSENBALM DRAWING NSDR CALA0000740Seat Track · corrodedINSPECTION FOUND RT SEAT TRACK CORRODED FROM STA 200 - 275, RBL 45. THE SEAT TRACK WAS REMOVED AND A NEW TRACK WAS INSTALLED IAW SRM 53-05, FIGURE 4, 51-30-1, 51-30-5, AND ECRA 5310-01675.SDR RAAA00B1061Cargo Track · corrodedDURING SCHEDULED C2 CHECK, FOUND CORROSION ON CARGO TRACK. REPLACED SEAT TRACK BS 1048 RBL13 PER SRM 53-10-5 FIG 8.SDR AALA20000860Seat Track · corrodedTUL - NR 3 SEAT TRACK CORRODED. REMOVED AND REPLACED SECTION OF SEAT TRACK PER SRM 51-72-10 AND INSTALLED SPLICE PER SRM 53-10-16. (X)SDR AALA20000861Track · corrodedTUL - TRACK ''E'' IS CORRODED BETWEEN FRAMES 71-72. BLENDED OUT CORROSION PER SRM 51-7440-2 TO .017 INCH. ALODINED, PRIMED AND PAINTED BLENDED AREA PER 51-21-00 AND PER ESO 30595 DATED 5-18-00. (X)SDR AALA20000899Seat Track · corrodedNR 2 SEAT TRACK AT LAVATORY MOUNT HOLES CORRODED. REMOVED CORROSION, TREATED, PRIMED, PAINTED, AND INSTALLED STRUCTURAL STRAPS ON THE FORWARD AND AFT LAVATORY MOUNT HOLES PER AARD 53-20-00. (X)SDR C2XA00IA138Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE FLIGHT ATTENDANTS LEFT FORWARD SEAT TRACK WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED SECTION OF SEAT TRACK IAW ATR42-500 SRM 51-25-04, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA00IA137Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE FLIGHT ATTENDANTS RIGHT FORWARD SEAT TRACK WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED SECTION OF SEAT TRACK IAW ATR42-500 SRM 51-25-04, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR TWAA0008805Seat Track · corrodedDURING CHECK-C MAINT, FOUND CORROSION IN CHAIR TRACK AT RBL 22 AT THE FOLLOWING STATIONS: 363 TO 368, 237, 530 TO 460, 427 TO 462, 408 TO 420, 636, 788, AND 484 TO 503. REMOVED CORROSION PER SRM 51-10-3, 53-05 FIG 4B-1, AND SPM 6-80-01. PRIMED PER SRM 51-10-SDR 00FDEA00354Seat Track · corrodedCORROSION ON SEAT TRACK FLANGE BS 993, RBL 48, WL 208. *S/D* REPLACED PER FEDEX SRM 53-10-1, 51-20-2, 51-30-2.SDR MWEA00442Seat Track · corrodedCORROSION ON BOTTOM SIDE OF NR 4 SEAT TRACK AROUND FASTENER HOLES AT STATIONS 255 TO 264. FABRICATED AND INSTALLED SEAT TRACK SPLICE.SDR ASAA0080344Seat Track · corrodedPHX - DURING 30K CHECK, FOUND CORROSION ON LEFT OUTBOARD SEAT TRACK, FS 1212 AND 1250, LBL 45. REMOVED AND REPLACED SEAT TRACK SECTION IAW DC9 SRM 53-05, FIG 4. (M)SDR ASAA0080343Seat Track · damagedPHX - DURING 30K CHECK, FOUND ON LEFT INBOARD SEAT TRACK, FS 1085 TO 1231, LBL 24. REMOVED AND REPLACED SEAT TRACK SECTION IAW DC9 SRM 53-05, FIG 4. (M)SDR DHL2000801144Seat Track · wornF/E SEAT TRACK WORN (AFT). REMOVED WORN TRACK PER SRM 51-3-0. CLEANED, TREATED AND PRIMED AREA PER SRM 51-1-8B. INSTALLED NEW SEAT TRACK PER SRM 51-3-0.SDR 20000718AP001Seat Track · corrodedABI - FOUND SEAT TRACK BL 0 WAS FOUND TO BE CORRODED BEYOND SRM LIMITS FROM STATION 297 THROUGH 329. REMOVED AND REPLACED 32 INCHES OF EXISTING SEAT TRACK BL 0, IAW SAAB STATEMENT 72SDS0795, SAAB 340 SRM 53-70-60 PAGE 201-205. OK FOR SERVICE. (M)SDR SIMA1444Seat Track · corrodedABI - FOUND SEAT TRACK BL 0 WAS FOUND TO BE CORRODED BEYOND SRM LIMITS FROM STATION 297 THROUGH 329. REMOVED AND REPLACED 32 INCHES OF EXISTING SEAT TRACK BL 0, IAW SAAB STATEMENT 72SDS0795, SAAB 340 SRM 53-70-60 PAGE 201-2-5. OK FOR SERVICE. (M)SDR CALA0000735Seat Track · corrodedINSPECTION FOUND SEAT TRACK CORRODED AT STA 1199 - 1227, LBL 44. THE SEAT TRACK WAS REMOVED AND A NEW TRACK WAS INSTALLED IAW SRM 53-05, FIGURE 4F AND 51-30-5.SDR QXEA0001591Seat Track · crackedYYC- THE LEFT HAND INBOARD SEAT TRACK IS CRACKED ON THE INBOARD SIDE OF STATION 10253. REPAIRED IAW FOKKER SRM 53-15-05 PAGE 38 AND 51-31-01.SDR DHL2000801117Cargo Track · wornMAIN CARGO COMPT 1 LT TRACK LUGS WORN AT STA 680.0. CUT OUT DAMAGED AREA PER SRM 53-2-3. FABRICATED CHANNEL AND PLUG PER SRM 53-2-3. CLEANED TREATED AND PRIMED PER SRM 51-1-8B. INSTALLED CHANNEL AND PLUG PER SRM 53-2-3.SDR CALA0000728Cargo Track · corrodedINSPECTION FOUND RT CARGO TIE DOWN TRACK IN AFT CARGO PIT CORRODED ON UPPER AND LOWER SURFACE AT STA 1022 - 1155, RBL 24. THE TIE DOWN TRACK WAS REMOVED AND REPLACED IAW SRM 51-30-1.SDR AALA20000840Track · corrodedTUL - TRACK ''B'', LEFT, HAD CORROSION AT GALLEY MOUNT HOLE. BLENDED OUT CORROSION .050 INCH DEEP, REQUIRED PER ESO 30595 DATED 5-18-00. (X)SDR AALA20000839Track · corrodedTUL - TRACK ''C'', RIGHT, HAD CORROSION AFT OF FRAME 74. BLENDED OUT CORROSION PER SRM 51-74-10, .080 INCH KEEP. REPAIRED PER ESO 30575 DATED 5-18-00. (X)SDR AALA20000841Galley Track · corrodedTUL - TRACK ''B'', LEFT, HAD CORROSION AT AFT GALLEY MOUNT HOLE. BLENDED OUT CORROSION ,045 INCH DEEP, REPAIRED PER ESO 30595 DATED 5-18-00, FRAMES 79-80. (X)SDR AALA20000843Seat Track · corrodedTUL - CORROSION ON NR 2 TRACK, FRAME 33, AFT LAVATORY MOUNT. REMOVED AND BLENDED CORROSION. REF: SRM 51-74-10. INSTALLED STRAP ON AREA PER AARD 53-20-00-2 ON AFT MOUNT. TREATED AND PRIMED AND PAINTED. (X)SDR AALA20000845Track · corrodedTUL - RIGHT TRACK ''D'' AFT OF FRAME 73 HAD CORROSION. BLENDED CORROSION PER SRM 51-74-10-2 TO A DEPTH OF .020 INCH. REPAIRED PER ESO 30595 DATED 5-18-00. (X)SDR AALA20000831Seat Track · corrodedTUL - NR 8 SEAT TRACK CORRRODED. REMOVED AND REPLACED SEAT TRACK AND SEALED AROUND BRACKETS PER SRM 51-72-10-0. FRAME 33, STA 1870 TO STA 2135. (X)SDR MALA000348Seat Track · corrodedFOUND DURING C-CHECK, CORROSION ON SEAT TRACK LBL18 INBOARD FLANGE VERTICAL SECTION REFER CELSIUS TASK CARD 1513. MAINTENANCE REMOVED CORROSION IAW 51-70-40, WRAP AROUND S/M OUT OF LIMITS ON LOWER CORNER FOR SRM 51-00-00. MATERIAL REMOVED OUT OF LIMITS BETWESDR MALA000347Seat Track · corrodedFOUND DURING C-CHECK, CORROSION ON SEAT TRACK FLANGE STA 294-363 BL 0 REFER CELSIUS TASK CARD 1512 AND SAAB STATEMENT 72SDS2521. MAINTENANCE REMOVED CORROSION IAW SRM 51-70-40. MATERIAL REMOVED IS OUT OF LIMITS IN NUMEROUS PLACE BETWEEN STA 294 - 319 PER SRMSDR MALA000346Seat Track · corrodedFOUND DURING C-CHECK, CORROSION ON SEAT TRACK I/B FLANGE STA 294 - 339 BL 183. REFER CELSIUS TASK CARD 1511. MAINTENANCE REMOVED IS OUT OF LIMITS IN NUMEROUS AREAS BETWEEN STA 294 - 339 PER SRM 51-00-00. ALODINED, PRIMED AND TOP COATED AREAS. REF SAAB SRM SDR AALA2000803Seat Track · corrodedTUL - FOUND TRACK D RIGHT IS CORRODED BETWEEN FRAME 73-74. INSTALLED NEW TRACK PER SRM 51-72-10-0. (M)SDR ASAA0080336Cargo Track · corrodedPHX - DURING 30K CHECK, FOUND CORROSION ON CARGO TRACK, FS 1003 TO 1155, LONGERON 28R. REMOVED AND REPLACED CARGO TRACK IAW DC9 SRM 53-01, FIG 1. (M)SDR L1GA200000163Seat Track · corrodedLEVEL 2 CORROSION SEAT TRACK FS 522 - 542 BL 22R.SDR L1GA200000162Seat Track · corrodedLEVEL 2 CORROSION SEAT TRACK FS 542 - 560 BL 22R.SDR L1GA200000161Seat Track · corrodedLEVEL 2 CORROSION SEAT TRACK FS 579 BL 22R.SDR L1GA200000136Seat Track · damagedHOLES WORN CAPTAIN''S I/B SEAT TRACK.SDR QXEA0001348Seat Track · corrodedPDX- AFT RIGHT HAND INBOARD SEAT TRACK IS CORRODED BEYOND LIMITS. REPAIRED IAW DASH 8 SRM 51-40-11 AND SRM 51-40-00.SDR CALA0000711Seat Track · corrodedINSPECTION FOUND RIGHT I/B SEAT TRACK CORRODED AT FS 237, RBL 22. A RIGHT O/B SEAT TRACK WAS FOUND CORRODED AT FS 237, RBL 44.5.SDR CALA0000710Seat Track · corrodedINSPECTION FOUND LEFT I/B SEAT TRACK CORRODED AT FS 1183 - 1212, LBL 22. THE SEAT TRACK WAS REMOVED AND A NEW TRACK WAS INSTALLED IAW SRM 51-30-01.SDR CALA0000708Seat Track · corrodedINSPECTION FOUND RIGHT O/B SEAT TRACK CORRODED AT STA 1100 - 1130, RBL 44.5. THE SEAT TRACK WAS REMOVED AND A NEW SEAT TRACK WAS INSTALLED IAW SRM 51-30-2, 51-30-1, 51-10-4, AND 53-05.
Back to JASC 5347