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 UPS00834412Seat Track · corrodedINSPECTION TYPE:C2, SEAT TRACK FLANGE CORRODED BL 0 STA 1124. REPAIRED SEAT TRACK IAW REO G07703.SDR CALA0001647Cargo Track · corrodedINSPECTION FOUND MID CARGO LT TIE DOWN TRACK CORRODED AT FS 522 - 798. THE CORROSION WAS REMOVED IAW SRM 51-10-3. THE TRACK WAS TREATED AND PRIMED FROM FS 522 - 617 AND FROM 700 - 798. FS 617 - 700 WAS FOUND OUT OF LIMITS. A REPAIR TRACK WAS INSTALLED FROMSDR UPS00234502Seat Track · corrodedINSPECTION TYPE:C, MAIN CABIN SEAT TRACK, CORRODED FROM BS 344 TO BS 360 AND LBL 22.5. REPLACED SECTION OF SEAT TRACKING ACCORDANCE WITH SRM 53-10-5. MATERIAL USED, P/N BAC1520-1432, 16 INCHES LONG.SDR TWAA0017304Cargo Track · corrodedDURING CHECK-C MAINT IN THE AFT CARGO COMPT THE LT FLOOR TRACK WAS CORRODED FROM STA 1022 TO 1211. INSTALLED SERVICEABLE TRACK PER SRM 51-01.SDR MWEA001083Seat Track · gougedNR 2 SEAT TRACK LOBE GOUGED AT STATION 655. FABRICATED AND INSTALLED SEAT TRACK REPAIR.SDR MWEA001082Seat Track · gougedNR 2 SEAT TRACK LOBE AND RADIUS UNDER LOBE ARE GOUGED AT STATION 693. FABRICATED AND INSTALLED SEAT TRACK REPAIR PARTS.SDR MWEA001072Seat Track · wornNR 2 SEAT TRACK LOBE WORN AT STATION 1035. REMOVED AND REPLACED SEAT TRACK.SDR MWEA001071Seat Track · wornNR 2 SEAT TRACK LOBE WORN AT STATION 875. REMOVED AND REPLACED SEAT TRACK.SDR MWEA001070Seat Track · wornNR 2 SEAT TRACK LOBE WORN AT STATION 342. FABRICATED AND INSTALLED REPAIR CHANNEL AND PLUG.SDR 00FDEA00741Seat Track · corrodedDURING ROUTINE INSP NR 2 MAIN CABIN SEAT TRACK FOUND CORRODED AT BS 772. REMOVED, REPLACED AND FAB PER IAW BAC SRM 53-10-5.SDR AWXA0000781Seat Track · gougedC-CHECK, CABIN SEAT TRACK AT FS 847 - 927, RBL 25, OUT OF LIMITS. CUT OUT DAMAGED SEAT TRACK, FABBED REPAIR SPLICE PLATE, INSTALLED PARTS IAW 737 SRM 53-00-52 FIG 204.SDR CALA0001634Cargo Track · corrodedINSPECTION FOUND AFT CARGO LT TIE DOWN TRACK CORRODED UNDER CLIP NUTS AT FS 1230 - 1322. THE TRACK WAS REMOVED AND A NEW TRACK WAS INSTALLED IAW SRM 51-10-4, 51-10-3, AND 53-05, FIGURE 3.SDR CALA0001632Cargo Track · corrodedINSPECTION FOUND FORWARD CARGO AFT RT TIE DOWN TRACK HAD CORRODED SCREW HOLES ON TOP AND BOTTOM. THE TRACK WAS REMOVED AND A NEW TRACK WAS INSTALLED IAW SRM 51-30-1, 51-30-3, AND 51-30-4.SDR CALA0001631Cargo Track · corrodedINSPECTION FOUND AFT CARGO RT SIDE TIE DOWN TRACK CORRODED BETWEEN FS 1212 - 1322. THE TRACK WAS REMOVED AND A NEW TRACK WAS INSTALLED IAW SRM 53-05, FIGURE 4 AND 51-10-3.SDR 00FDEA00731Seat Track · crackedMAIN DECK CARGO COMPARTMENT, FLOOR TRACK AT BS 635, RBL 25 FOUND CRACKED APPROX 4 INCHES LONG.SDR 00FDEA00730Seat Track · crackedMAIN DECK CARGO COMPARTMENT, FLOOR TRACK AT BS 695, LBL 8.5 IN FOUND WITH CRACKED APPROX 3 INCHES LONG.SDR MWEA001054Seat Track · corrodedSEAT TRACK IS CORRODED BEYOND LIMITS FROM STATION 1147 - 1165. FABRICATED AND INSTALLED SEAT TRACK REPAIR.SDR MWEA001053Seat Track · corrodedNR 4 SEAT TRACK IS CORRODED AT STATION 200. FABRICATED AND INSTALLED SEAT TRACK REPAIR.SDR MWEA001052Seat Track · corrodedCORROSION ON TOP SIDE OF LEFT (MOST OUTBOARD) SEAT TRACK AT STATION 572, 590, 606, 624, AND 638. FABRICATED AND INSTALLED SEAT TRACK REPAIR.SDR MWEA001051Seat Track · corrodedCORROSION ON TOP SIDE OF LEFT (MOST OUTBOARD) SEAT TRACK AT STATION 294, 325, 342, 360, AND 377. FABRICATED AND INSTALLED SEAT TRACK REPAIR.SDR MWEA001050Seat Track · corrodedCORROSION ON TOP SIDE OF LEFT (MOST OUTBOARD) SEAT TRACK AT STATION 800, 821, 837, 854, AND 876. FABRICATED AND INSTALLED SEAT TRACK REPAIR.SDR MWEA001049Seat Track · corrodedCORROSION ON TOP SIDE OF RIGHT MOST OUTBOARD SEAT TRACK AT STATION 1193, 1211, 1226, AND 1266. FABRICATED AND INSTALLED SEAT TRACK REPAIR.SDR MWEA001048Seat Track · corrodedCORROSION ON TOP SIDE OF RIGHT MOST OUTBOARD SEAT TRACK AT STATION 1100, 1115, 1127, 1130, AND 1148. FABRICATED AND INSTALLED SEAT TRACK REPAIR.SDR MWEA001046Seat Track · corrodedCORROSION ON TOP SIDE OF LEFT (MOST OUTBOARD) SEAT TRACK AT STATION 393, 408, 424, 441, AND 458. FABRICATED AND INSTALLED SEAT TRACK REPAIR.SDR TWAA0016809Seat Track · wornDURING OP 15 MAINT CHECK, NUMBER 3 CHAIR TRACK HAD WORN AREA AT STA 208 AND CORROSION AT STA 214 AND 233. REMOVED OLD TRACK AND FABRICATED NEW PER SRM 53-05, SPM 6-70-01, AND INSTALLED PER SRM 51-30.SDR TWAA0016808Seat Track · corrodedDURING OP 15 MAINT CHECK, FOUND NUMBER 4 CHAIR TRACK CORRODED ON TOP BETWEEN STA 200 AND 218, RBL 44, 18 INCHES LONG. REMOVED OLD TRACK AND FABRICATED NEW TRACK PER SRM 53-05, SPM 6-70-01, AND INSTALLED PER SRM 51-30.SDR UPS00234504Seat Track · gougedINSPECTION TYPE:C, CABIN SEAT TRACK LBL 60, STA 499/501 IS NICKED AND GOUGED. REPLACED CABIN SEAT TRACK FROM STA 499 TO STA 650, LBL 60 IN ACCORDANCE WITH SRM 53-10-5 FIG 3. MATERIAL USED, P/N BACK 1520-1433. ALSO SEE NRC 258775 AND 258778.SDR QXEA0002909Seat Track · corrodedYXX- CORROSION ON RIGHT HAND INBOARD SEAT TRACK AT AFT END OF LOWER BAGGAGE PIT AT STATION X597. REPAIRED IAW DHC-8 RD 8-53-4936, DHC-8 SRM 51-20-00 AND 51-40-00.SDR CALA0001618Cargo Track · corrodedINSPECTION FOUND LT TIE DOWN TRACK IN AFT CARGO AREA CORRODED BETWEEN FS 1007 AND 1320. THE TIE DOWN TRACK WAS REMOVED AND REPLACED IAW SRM 53-05, FIGURE 4G.SDR CALA0001617Cargo Track · corrodedINSPECTION FOUND AFT RT END OF TRACK TO AFT BULKHEAD FRAME IN FWD CARGO PIT CORRODED AT STA 522. THE TRACK WAS REMOVED AND A NEW SECTION OF TRACK WAS INSTALLED IAW SRM 51-10-4, 51-30-2, AND 51-30-5.SDR AALA20001816Seat Track · corrodedTUL - END OF NR 6 GALLEY TRACK CORRODED, STA 216 - STA 220, TOP OUTBOARD FLANGE. CUT OUT TRACK SECTION STA 215 - STA 304. INSTALLED NEW TRACK SECTION AND REPAIR SPLICE PER SRM 53-05 PART 1. (X)SDR UPS00234501Seat Track · crackedINSPECTION TYPE:C, MAIN CARGO DECK SEAT TRACK GOUGED AND CRACKED AT RBL 45 BETWEEN BS 480 AND 540. REPLACED SECTION OF SEAT TRACK IN ACCORDANCE WITH SRM 53-10-5 FIG 7. MATERIAL USED P/N BAC1520-1434, 60 INCHES.SDR AALA20001817Seat Track · corrodedTUL - STA 221 - STA 223, INSIDE NR 2 LAVATORY TRACK, NUTPLATE CORRODED. INSTALLED NEW SECTION OF SEAT TRACK, STA 200 TO STA 247, SRM 51-01. (X)SDR DHL200080753CCargo Track · wornAT C-CK; MAIN CARGO COMPT NR 1 FLOOR TRACK LUGS WORN AT STA 520. CUT OUT DAMAGED AREA IAW SRM 53-2-3, PG 17 & 19. CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B PG 1-2. INSTALLED NEW PLUG IAW SRM 53-2-3, PG 17 & 19. REF: N/R 1840.SDR UPS00834300Seat Track · wornINSPECTION TYPE:C2, SEAT TRACK E HAS WORN SCALLOPS 2 PLACES AT APPROX FS 160. BLENDED SEAT TRACK AT FS 150. BLENDOUT IS WITHIN LIMITS IAW DC8 SRM 53-2-3 FIG 12. CUT OUT HOLE FOR PLUG AT FS 160 IAW DC8 SRM 53-2-3 FIG 6D. ALODINED AND PRIMED IAW DC8 SRM 51-1SDR UPS00834298Seat Track · damagedINSPECTION TYPE:C2 MAIN CABIN SEAT TRACK AT FS 15080, SEAT TRACK ''A'' HAS 3 DAMAGED SCALLOPS. CUT OUT TRACK IAW DC8 SRM 53 FIG 6D, ALODINED AND PRIMED DRILLED CHANNEL PLUGS TO FIT IAW DC8 SRM 51-1-24, 53-2-3 FIG 6D. INSTALLED IAW DC8 SRM 51-3-0, 53-2-3 FIG SDR MALA000705Seat Track · nickedFOUND DURING C-CHECK, CARGO COMPARTMENT SEAT TRACK HAVE NICKS, SCRATCHES AND AREAS OF BEAR METAL AND CORROSION. REFER TO CELSIUS W/O 18910, TASK CARD 1507 AND SAAB STATEMENT 340SDS000299. MAINTENANCE SMOOTHED OUT NICKS AND SCRATCHES REF. SRM 51-10-10. FOUND SDR MALA000704Seat Track · corrodedFOUND DURING C-CHECK, CORROSION ON INBOARD FLOOR PANEL FLANGE OF SEAT TRACK LBL18.3, FROM STA 294-389. REFER TO CELSIUS W/O 18910, TASK CARD 1512, SAAB STATEMENT 340SDS000299. MAINTENANCE BLENDED CORROSION ON LBL 18.3, STA 294-389 PER SRM 51-70-40. REMAININSDR MALA000703Seat Track · corrodedFOUND DURING C-CHECK, CORROSION ON INBOARD FLOOR PANEL FLANGE OF SEAT TRACK BLO FROM STA 294 THRU 389. REFER TO CELSIUS W/O 18910, TASK CARD 1513, AND SAAB STATEMENT 340SDS000299. MAINTENANCE BLENDED CORROSION ON BL-0 FROM STA 294-389 PER SRM 51-70-40. FOUNDSDR AALA20001815Seat Track · corrodedTUL - SEAT TRACK NR 2 HAD CORROSION, STA 1200 - STA 1203, REMOVED AND REPLACED NR 2 TRACK. STA 1183 TO STA 1222 PER SRM 53-05. (X)SDR QXEA0002912Seat Track · corrodedYXX- EVIDENCE OF CORROSION AROUND CAMLOCK RECEPTICALS ON RIGHT HAND INBOARD SEAT TRACK AT STATION 222. REPAIRED IAW DHC-8 SRM 51-40-11 AND 51-40-00.SDR QXEA0002908Seat Track · corrodedYXX- LEFT HAND INBOARD FORWARD SEAT TRACK IS CORRODED AT STATION 222 AND MECHANICAL DAMAGE AT STATION 286. REPAIRED IAW DHC-8 SRM 51-40-11 AND 51-40-00.SDR RRXA003242Seat Track · damagedDURING A MAINTENANCE VISIT FOUND DAMAGE TO THE 3RD TRACK FROM RIGHT O/B SIDE BETWEEN STA''S 859 & 879, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM.SDR RRXA003241Seat Track · damagedDURING A MAINTENANCE VISIT FOUND DAMAGE TO THE CENTER SEAT TRACK FRAME AT STA 70, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM.SDR RRXA003255Intercostal · crackedDURING A MAINTENANCE VISIT FOUND A BROKEN INTERCOSTAL STRAP LT SIDE OF CENTER SEAT TRACK AT STA 660 AT X=+5, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. FABRICATED PART AND INSTALLED IAW DC-8 SRM 51-1SDR RRXA003254Intercostal · crackedDURING A MAINTENANCE VISIT FOUND A BROKEN INTERCOSTAL STRAP LT SIDE OF CENTER SEAT TRACK AT STA 620 AT X=+3, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. FABRICATED PART AND INSTALLED IAW DC-8 SRM 51-SDR RRXA003253Intercostal · crackedDURING A MAINTENANCE VISIT FOUND A BROKEN INTERCOSTAL STRAP LT SIDE OF CENTER SEAT TRACK AT STA 560 AND X=+3, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. FABRICATED PART AND INSTALLED IAW DC-8 SRM 51-SDR AALA20001805Seat Track · corrodedTUL - FOUND CORROSION ON NR 2 SEAT TRACK STATION 1193-1309. REPLACED SEAT TRACK STATION 1174-1309 PER SRM 51-01. (M)SDR AALA20001802Seat Track · corrodedTUL - FOUND SEAT TRACK NR 1 AT GALLEY TIE DOWN CORROSION 1 INCH BY 2 INCHES OUT OF LIMITS, NEED CHANGE NEW SEAT TRACK NR 1 FROM STATION 1174-1309. INSTALLED NEW SECTION OF SEAT TRACK FROM STATION 1174-1309 PER SRM 51-01. (M)SDR AALA20001801Seat Track · wornTUL - FOUND SEAT TRACK NR 4 IS WORN 6 INCHES BY 3 INCHES, STATION 934. INSTALLED 1 NEW SEAT TRACK PLUG PER SRM 53-30-00-10. (M)
Back to JASC 5347