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 USAA990749Seat Track · corrodedCLT - DURING C-4 CHECK VISUAL INSPECTION, FOUND SURFACE CORROSION ON SEAT TRACK AT STATION 377, LBL 24.75, CORROSION LEVEL 2. INSTALLED NEW SEAT TRACK PER SRM 51-10-00. (M)SDR SCNA99525Seat Track · corrodedDURING A HEAVY MAINTENANCE CHECK, THE SEAT TRACK AT BS 480 TO 500 RBL 24 WAS FOUND TO HAVE CORROSION AROUND THE FASTENER HOLES. REMOVED CORRODED PORTION OF SEAT TRACK, TREATED AND PRIMED NEW SECTION OF THE SEAT TRACK AND INSTALLED REF 53105.SDR SCNA99519Seat Track · corrodedDURING A HEAVY MAINTENANCE CHECK, CORROSION WAS FOUND ON SEAT TRACK AT BS 383 TO 480 RBL 43. REMOVED AND REPLACED SEAT TRACK FROM FACTORY SPLICE TO PRODUCTION END PER SRM 5130.SDR SCNA99516Seat Track · corrodedDURING A HEAVY MAINTENANCE CHECK, THE SEAT TRACK WAS FOUND TO HAVE CORROSION AT BS 460 RBL 2473. REMOVED AND REPLACED SEAT TRACK FROM FACTORY SPLICE TO THE PRODUCTION END PER SRM 5130. FABRICATED REPLACEMENT SEAT TRACK PER SRM 53105 AND TREATED AND PRIMED PESDR SCNA99513Seat Track · corrodedDURING A HEAVY MAINTENANCE CHECK, THE SEAT TRACK WAS FOUND TO BE SEVERELY CORRODED AT BS 344 LBL 2475. THE SEAT TRACK WAS REMOVED AND FABRICATED PER SRM 53105. TREATED AND PRIMED PER 512101 AND INSTALLED PER SRM 53105.SDR SCNA99512Seat Track · corrodedDURING A HEAVY MAINTENANCE CHECK, THE SEAT TRACK AT LBL 24 BS 480 TO 495 WAS FOUND TO HAVE CORROSION ALONG THE UPPER SURFACE. REMOVED DAMAGED SEAT TRACK AND FABRICATED NEW SECTION OF THE SEAT TRACK IAW SRM 53105 PAGE 20 FIG 7 SHEET 3. TREATED AND PRIMED IAW SDR SCNA99511Seat Track · corrodedDURING A HEAVY MAINTENANCE CHECK, SEAT TRACK AT LBL 24 BS 344 480 WAS FOUND FOUND TO HAVE CORROSION AROUND FASTENER HOLES UPPER SURFACE. SEAT TRACK REMOVED AND REPLACED FROM STATION 344 TO 480 PER SRM 53105. TREATED AND PRIMED PER SRM 512110. INSTALLED PER SDR AT9900547Tie Down Track · corrodedSCHEDULED INSPECTION AT TIMCO LAKE CITY, FL, FOUND THE AFT PIT TIE DOWN TRACK AT BS 937-996 WITH CORROSION. REMOVED CORROSION, DRILLED, COUNTERSUNK, DEBURRED, TREATED, PRIMED, AND INSTALLED NEW SECTION IAW DC9 SRM 51-10-4, 51-30-1, AND 51-10-3.SDR QXEA9901605Seat Track · gougedPDX - LEFT INBOARD SEAT TRACK HAS TWO GAUGES AT X268. REPAIRED IAW DHC-8 SRM 51-26-26.SDR QXEA9901600Seat Track · corrodedPDX - RIGHT OUTBOARD SEAT TRACK AT X312 HAS CORROSION PITS. REPAIRED IAW RD 8-53-1342.SDR QXEA9901599Seat Track · corrodedPDX - RIGHT OUTBOARD SEAT TRACK AT X327 HAS DEEP CORROSION PITS. REPAIRED IAW DHC8 SRM 51-26-26.SDR QXEA9901597Seat Track · corrodedPDX - RIGHT OUTBOARD SEAT TRACK HAS CORROSION PITS IN THE HAT CHANNEL AT X364. REPAIRED IAW RD 8-53-1342.SDR QXEA9901596Seat Track · corrodedPDX - RIGHT OUTBOARD SEAT TRACK HAS CORROSION PITS IN THE HAT CHANNEL AT X374. REPAIRED IAW RD 8-53-1342.SDR QXEA9901594Seat Track · corrodedPDX - LEFT OUTBOARD SEAT TRACK AT STATION 342 THERE IS CORROSION PITS. REPAIRED IAW RD 8-53-1342.SDR CALA9900849Seat Track · corrodedINSPECTION FOUND LT CENTER SEAT TRACK CORRODED FROM STA 1098 TO 1193, LBL 24. THE SEAT TRACK WAS REMOVED AND A NEW SEAT TRACK AND SPLICES WERE INSTALLED IAW SRM 53-05, FIGURE 4F.SDR CALA9900848Seat Track · corrodedINSPECTION FOUND LEFT I/B SEAT TRACK CORRODED FROM STA 1079 TO 1231, LBL 24. THE CORROSION WAS REMOVED IAW SRM 51-30-01. A NEW SEAT TRACK AND SPLICES WERE INSTALLED IAW SRM 53-05, FIGURE 5, 51-30-1, AND 51-30-5.SDR CALA9900845Seat Track · corrodedINSPECTION FOUND LT SEAT TRACK CORRODED FROM STA 1193 TO 1212, LBL 44. THE CORRODED SECTION OF SEAT TRACK WAS REMOVED AND A NEW SEAT TRACK WAS INSTALLED IAW SRM 53-05, FIGURE 4E, 51-10-4, 51-30-1.SDR CALA9900844Seat Track · corrodedINSPECTION FOUND RIGHT O/B SEAT TRACK CORRODED AT STA 328-360. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 53-00-52.SDR CALA9900843Seat Track · corrodedINSPECTION FOUND RIGHT O/B SEAT TRACK GOUGED AT STA 1197, RBL 54. A NEW SEAT TRACK AND FITTINGS WERE INSTALLED SRM 53-05.SDR 9903279913Seat Track · crackedDURING PERIODIC CHECK, FOUND TWO CRACKS ON SEAT TRACK FITTING FS 617. REPAIRED PER EA 99-164490 (P/N 3916212-502).SDR UPS99830245Seat Track · corrodedINSPECTION TYPE:C1 DOUBLE SEAT TRACK AT FS 440, RBL 48, IS CORRODED OUT BEYOND LIMITS. CUT OUT DAMAGED SECTION AND SPLICED IN A NEW SECTION OF SEAT TRACK IAW SRM 53-2-3.SDR AT9900610Seat Track · corrodedSCHEDULED INSPECTION AT TIMCO LAKE CITY, FL. FOUND THE LEFT OUTBOARD SEAT TRACK AT BS 570 - 590 WITH NICKS, SCRATCHES AND CORROSION. CUT OUT SECTION OF SEAT TRACK, FABRICATED, DRILLED, DEBURRED, COUNTERSUNK, AND INSTALLED IAW DC9 SRM 51-10-3, 53-05-0, 51-30-SDR AT9900804Seat Track · corrodedFOUND RIGHT INBOARD SEAT TRACK AT BS 218-965 WITH NICKS, SCRATCHES AND CORROSION. REPLACED SEAT TRACK IAW DC9 SRM 53-05 FIGURE 4, 51-30-2, 51-10-3.SDR AT9900543Seat Track · corrodedSCHEDULED INSPECTION AT TIMCO LAKE CITY, FL, FOUND THE CABIN RIGHT INBOARD SEAT TRACK AT 198-206 RBL-22 CORRODED. REMOVED SEAT TRACK, LOCATED AND DRILLED, TRIMMED, COUNTERSUNK, DEBURRED, TREATED, PRIMED, AND INSTALLED IAW DC9 SRM 51-10-4, 51-30-1, 51-10-3, ANSDR AT9900542Seat Track · corrodedSCHEDULED INSPECTION AT TIMCO LAKE CITY, FL, FOUND THE FORWARD CABIN OUTBOARD SEAT TRACK AT BS 198-205 RBL-44 CORRODED. REMOVED SEAT TRACK, CUT, DRILLED, TRIMMED SECTION, ALODINED, PRIMED AND INSTALLED SPLICE IAW DC9 SRM 53-20-1, 53-05 FIG 4F, 51-10-3, AND 51SDR UF6A990740Seat Rail · corrodedSBN - SEAT RAIL CORRODED BETWEEN STATION 252AS AND 270AS. MAINTENANCE REPLACED IAW BAE ATP SRM 53-10-13. (M)SDR 99ZZZX2894Seat Track · corrodedSJU - HMV1 INSPECTION CRIC NR 7991 AT LT F/A SEAT TRACK IS CORRODED. BLENDED OUT CORROSION AND FOUND OUT OF LIMITS IAW SRM 53-00-00 PAGE 312 THROUGH 314. CAUSE OF DAMAGE, ENVIRONMENTAL. COMPLETED CORROSION REPAIR PER EO NR 9-5300-013R4 BY REMOVING AND REPLASDR HEEA062890Seat Track · mismanufacturedTRACK ASSY MISMANUFACTURED. OUTBOUND HOLES DO NOT LINE UP, MISDRILLED.SDR QXEA9901598Seat Track · gougedPDX - RIGHT OUTBOARD SEAT TRACK AT X346 HAS A GOUGE. REPAIRED IAW DHC8 SRM 51-20-16.SDR QXEA9901595Seat Track · corrodedPDX - RIGHT OUTBOARD SEAT TRACK HAS PITS IN THE HAT CHANNEL AT X406. REPAIRED IAW DHC8 SRM 51-20-16.SDR UPS99230113Seat Track · corrodedINSPECTION TYPE:C, CORROSION ON SEAT TRACK AT BS 358, LBL 23, WL 208. REMOVED CORROSION IN A 2' X 8 AREA, REMOVED .038 FROM ORIGINAL THICKNESS OF .100 FOUND TO BE OUT OF LIMITS. CUT OUT DAMAGED AREA OF SEAT TRACK, FABRICATED NEW SECTION OF TRACK, FABRICATED SDR 99FDEA00261Seat Track · crackedMAIN DECK AREA - CRACK FOUND ON SEAT TRACK AT STA 635 X = 47.5 LT. CRACK LENGTH APPROX 3.85 IN. *S/D* CRACK AREA TRIMMED OUT AT STA 625 & 645. NEW TRACK REWORKED PER DWG NR NCA 6792. SPLICE HATS REWORK AND SPLICE PLATES FAB AND WEB INSTALLED PER SRM 53-70SDR 99FDEA00257Seat Track · crackedSNRM 431, 430, 355, 354 CRACK ON SEAT TRACK BS 635, X=8.5 RT, X=47.5 RT, X=27.5 LT, X=47.5 LT. REPAIRED SEAT TRACK IN ACCORD WITH SRM 53-70-00.SDR C2XA99IA392Seat Track · corrodedDURING CONTINENTAL EXPRESS C-CHECK, FOUND CARGO BAY RT SEAT RAIL CORRODED FROM FRAMES 36 TO 39. REMOVED AND REPLACED SEAT TRACK IAW SRM 51-25-05. AIRCRAFT APPROVED FOR RETURN TO SERVICE. (X) TAT: 23,946.4 HOURS. TAC: 27,645. (X)SDR C2XA99IA390Seat Track · corrodedDURING CONTINENTAL EXPRESS C-CHECK, FOUND CARGO BAY LEFT SEAT RAIL CORRODED FROM FRAMES 36 TO 39. REMOVED AND REPLACED SEAT TRACK IAW SRM 51-25-05. AIRCRAFT APPROVED FOR RETURN TO SERVICE. TAT: 23,946.4 HOURS. TAC: 27,645. (X)SDR AALA991034Seat Track · corrodedTUL - FOUND CORROSION ON SEAT TRACK NR 8. REPLACED FLOOR SEAT TRACK FROM FRAME 27-31 PER SRM 51-21-00. (M)SDR SIMA991901Seat Track · corrodedSAW - DURING CPCP-2 INSPECTION, FOUND LEFT AND RIGHT AFT INBOARD AND THE LEFT AND RIGHT MIDDLE INBOARD SEAT TRACKS CORRODED. REMOVED AND REPLACED SEAT TRACKS IAW EO E9-5300-013. AIRCRAFT RETURNED TO SERVICE. REF: OPER CNTRL NR 99ZZZX2811 THROUGH NR 99ZZZX2SDR 99ZZZX2813Seat Track · corrodedSAW - DURING CPCP-2 INSPECTION, FOUND LEFT AND RIGHT AFT INBOARD AND THE LEFT AND RIGHT MIDDLE INBOARD SEAT TRACKS CORRODED. REMOVED AND REPLACED SEAT TRACKS IAW EO E9-5300-013. AIRCRAFT RETURNED TO SERVICE. REPLACED 2 EACH. REF: OPER CNTRL NR SIMA991901SDR 99ZZZX2812Seat Track · corrodedSAW - DURING CPCP-2 INSPECTION, FOUND LEFT AND RIGHT AFT INBOARD AND THE LEFT AND RIGHT MIDDLE INBOARD SEAT TRACKS CORRODED. REMOVED AND REPLACED SEAT TRACKS IAW EO E9-5300-013. AIRCRAFT RETURNED TO SERVICE. REPLACED 2 EACH. REF: OPER CNTRL NR SIMA991901SDR 99ZZZX2811Seat Track · corrodedSAW - DURING CPCP-2 INSPECTION, FOUND LEFT AND RIGHT AFT INBOARD AND THE LEFT AND RIGHT MIDDLE INBOARD SEAT TRACKS CORRODED. REMOVED AND REPLACED SEAT TRACKS IAW EO E9-5300-013. AIRCRAFT RETURNED TO SERVICE. REPLACED 2 EACH. REF: OPER CNTRL NR SIMA991901SDR QXEA9901495Seat Track · corrodedPDX - RIGHT INBOARD SEAT TRACK HAS CORROSION INSIDE CHANNEL AND AT CHANNEL RADIUS STARTING AT TRACK END AND GOING FORWARD 11. REPAIRED IAW FOKKER SRM 51-10-04, PARAGRAPH 4.SDR QXEA9901494Seat Track · corrodedPDX - RIGHT OUTBOARD SEAT TRACK HAS CORROSION INSIDE CHANNEL AND AT CUT OUT NEAR FRAME 9305A. REPAIRED IAW FOKKER SRM 51-10-04, PARAGRAPH 4.SDR CALA9900811Track · corrodedINSPECTION FOUND AFT CARGO TIE DOWN TRACK CORRODED AT STA 1007-1155. THE TIE DOWN TRACK WAS REPLACED IAW SRM 51-30-1.SDR CALA9900806Seat Track · corrodedINSPECTION FOUND LEFT I/B SEAT TRACK CORRODED AT STA 1102-1215. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 51-30-1.SDR AT9900617Seat Track · corrodedDURING SCHEDULED INSPECTION AT TIMCO LAKE CITY FLORIDA, FOUND RT INBOARD SEAT TRACK SCRATCHED AND CORRODED AT BS 218 TO 965. REMOVED SECTION OF SEAT TRACK FROM BS 218-235 AT EXISTING SPLICE. FABRICATED REPAIR SECTION, ALODINED, PRIMED AND INSTALLED SECTION ASDR AALA991014Seat Track · corrodedTUL - FOUND CORROSION AT NR 3 SEAT TRACK. REMOVED CORROSION PER SRM 51-74-10. ALODINED, PRIMED PAINTED AREA AND INSTALLED ALUMINUM PLUG WITH SEALANT, REF A300 SRM 51-21-00 AND ESO 305.75 AARD CHP53 DATED 7 JUL 99. (M)SDR USAA990701Seat Track · corrodedPIT - DURIGN Q2, C-1 CHECK, FOUND 1 INCH BY 1.5 INCH CORRODED AREA AT SEAT TRACK AT STATION 420 RT OUTBOARD SEAT TRACK. CORROSION LEVEL 1, CORROSION TASK NR C58-53300. (M)SDR AALA991008Seat Track · corrodedTUL - FOUND SEAT TRACK NR 1 CORRODED JUST FORWARD OF THE L-1 DOOR. REMOVED CORROSION PER SRM 51-71-10. INSTALLED STRAP REPAIR PER AARD 53-20-00-2. ALODINED, PRIMED AND PAINTED PER SRM 51-21-00-0. (M)SDR AALA994115Seat Track · corrodedAFW - SEAT TRACK AT STA 770 AND LBL 11 HAS CORROSION REMOVAL ON UPPER SURFACE. BLENDED OUT CORROSION AND REFINISHED SURFACE PER SRM. THE BLENDED REPAIR IS SATISFACTORY FOR CONTINUED SERVICE AS NOTED CONDITION. TST: 49,949 HOURS. CYCLES: 8,146. (X)SDR UPS99830096Seat Track · gougedINSPECTION TYPE:C2 MAIN CABIN SEAT TRACK I IS GOUGED AT STA 300. BLENDED GOUGED AREA, FOUND TO EXCEED LIMITS IAW DC8 SRM 53-2-3. REPAIRED IAW DC8 SRM 53-2-3. INSTALLED PLUG AND CHANNEL IAW DC8 SRM 51-3-0 AND 53-2-3.
Back to JASC 5347