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 QXEA9900188Seat Track · corrodedPDX - THERE ARE THREE AREAS WITH LIGHT PITTING CORROSION INSIDE CHANNEL OF RIGHT INBOARD SEAT TRACK BETWEEN FRAME 8305 AND 9305. REPAIRED IAW MM 53-40-01, PAGE 201-202, PARAGRAPH B6, STEPS 1-6.SDR QXEA9900187Seat Track · corrodedPDX - THERE ARE THREE AREAS OF LIGHT TO MODERATE CORROSION IN CHANNEL OF RIGHT INBOARD SEAT TRACK BETWEEN FRAMES 7305 AND 8305. REPAIRED IAW MM 53-40-01, PAGE 201-202, PARAGRAPH B6, STEPS 1-6.SDR QXEA9900186Seat Track · corrodedPDX - THERE ARE TWO AREAS OF LIGHT TO MODERATE CORROSION IN CHANNEL OF RIGHT-HAND INBOARD SEAT TRACK BETWEEN FRAME 6805 AND 7305. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9, PARAGRAPH B AND C.SDR DHL9971204CSeat Track · wornAT C-CHECK, CABIN SEAT TRACK WORN AT BL 0 CENTER TRACK BS 740. REMOVED SEAT TRACK AND REPLACED PER SRM 51-30-2.SDR DHL9971203CSeat Track · wornAT C-CHECK, SEAT TRACK AT BL 0 BS 785 WORN. REMOVED SEAT TRACK FROM STA 760 TO 850 AND REPLACED PER SRM 53-10-5.SDR DHL9971202CSeat Track · wornAT C-CHECK, CABIN SEAT TRACK WORN AT BL 0 CENTER TRACK BS 789. REMOVED AND REPLACED SEAT TRACK FROM BS 789 TO STA 850 PER SRM 51-10-5.SDR DHL9980564CSeat Track · wornAT C-CHECK, NR 4 SEAT TRACK WORN AT STA 690. REMOVED EXISTING REPAIR AND FABRICATED NEW REPAIR PER SRM 53-2-3. N/R 259SDR DHL9980563CSeat Track · wornAT C-CHECK, NR 8 SEAT TRACK WORN AT APPROX 785. REMOVED AND INSTALLED REPAIR PER SRM 53-2-3. N/R 258SDR DHL9980561CSeat Track · wornAT C-CHECK, NR 5 SEAT TRACK WORN. CUT OUT DAMAGED AREA AT FS 1260. INSTALLED REPAIR PARTS PER SRM 53-2-3. N/R 298SDR DHL9980560CSeat Track · wornAT C-CHECK, NR 3 SEAT TRACK WORN AT STA 329. REMOVED EXISTING TRACK AND FABRICATED NEW, INSTALLED PER SRM 53-2-3. N/R 290SDR AT9900123Seat Track · crackedSCHEDULED INSPECTION AT AERO CORP, FL. FOUND CORROSION AT DIFFERENT LOCATIONS. FIRST, THE LAVATORY WALL HAT SECTION AT STA 300 L-35 TO 50, SECONDLY THE SEAT TRACK IN THE CABIN AT STA 328 TO 344 BL 24 TO 75R, AND THE SIDE WALL IS CRACKED AND CORRODED AT STA 4SDR UPS99528368Seat Track · crackedINSPECTION TYPE:S-1 CRACKED SEAT TRACK FLANGE AT BS 1010, RBL 16, WL 156. REMOVED CRACKED SEAT TRACK SECTION FROM BS 950-BS 1010 RBL 16, WL 156. INSTALLED NEW SEAT TRACK PER SRM 51-10-1.SDR DHL9980565CSeat Track · damagedAT C-CHECK, NR 3 SEAT TRACK WORN AT STA 690. REMOVED DAMAGED SEAT TRACK AND INSTALLED FABRICATED NEW TRACK PER SRM 53-2-3. N/R 262SDR DHL9980551CSeat Track · damagedAT C-CHECK, NR 2 SEAT TRACK WORN FS 1310. REMOVED DAMAGED FOUR HOLE REPAIR AND FABRICATED AND INSTALLED PER SRM 53-2-3. N/R 299SDR DHL9971228CSeat Track · crackedAT C-CHECK, CABIN SEAT TRACK CRACKED AT STA 550 LBL 48. REMOVED SEAT TRACK FROM 540 TO 620. INSTALLED NEW SEAT TRACK PER SRM 53-10-5.SDR CALA9900043Seat Track · corrodedCORROSION AT BOTTOM OF SEAT TRACK STA 1090 RBL 47. REMOVED AND REPLACED CORRODED SEAT TRACK FROM STA 1090 TO STA 1130 RBL 47 PER SRM 51-10-1.SDR UPS99828657Seat Track · corrodedINSPECTION TYPE-C3, SECOND OBS SEAT TRACKS ARE CORRODED UNDER THE NUT PLATES. REMOVED AND REPLACED SEAT TRACKS IAW SRM 51-1-20D AND 51-3-0.SDR DHL9980580CSeat Track · wornAT C-CHECK, NR 4 SEAT TRACK WORN AT STA 507. REMOVED SEAT TRACK AND INSTALLED REPAIR PER SRM 53-2-3. N/R 191SDR DHL9980559CSeat Track · wornAT C-CHECK, NR 5 SEAT TRACK WORN AT STA 325. REMOVED, REPLACED EXISTING TRACK AND INSTALLED PER SRM 51-18. N/R 289SDR RRXA991151Seat Track · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION, FUSELAGE, CABIN FLOOR TRACK BETWEEN STA 1380 AND STA 1440 AT BL 59 LEFT, WL 0. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED NEW SEAT TRACK SECTIOSDR RRXA991149Seat Track · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION, FUSELAGE, CABIN FLOOR TRACK BETWEEN STA 1280 AND STA 1300 AT BL 44 LEFT. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED NEW SEAT TRACK SECTION IAW SDR RRXA991148Seat Track · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION, FUSELAGE, CABIN FLOOR TRACK BETWEEN STA 1280 AND STA 1300 AT BL 59 LEFT. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED NEW SEAT TRACK SECTION IAW SDR RRXA991147Seat Track · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION, FUSELAGE, CABIN FLOOR TRACK BETWEEN STA 1300 AND STA 1320, BL 44 LEFT. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED NEW SEAT TRACK SECTION IAW DCSDR RRXA991146Seat Track · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION, FUSELAGE, CABIN FLOOR TRACK BETWEEN STA 1180 AND STA 1200 AT BL 59 LEFT. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED NEW SEAT TRACK SECTION IAW SDR RRXA991145Seat Track · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION, FUSELAGE, CABIN FLOOR TRACK BETWEEN STA 1300 AND STA 1360 AT BL 59 LEFT. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED NEW SECTION OF SEAT TRACK ISDR RRXA991144Seat Track · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION, FUSELAGE, CABIN FLOOR TRACK BETWEEN STA 920 AND STA 960, BL 59 LEFT. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED NEW SEAT TRACK SECTION AND INSTALLED IAW DC8 SDR QXEA9900181Seat Track · corrodedPDX - THERE IS LIGHT PITTING CORROSION ON THE INBOARD FLOOR SUPPORT FLANGE OF THE LEFT-HAND INBOARD SEAT TRACK BETWEEN FRAMES 12875 AND 13345. REPAIRED IAW FOKKER SRM 51-10-04, PAGE 9.SDR C2XA99IA030Seat Track · corrodedDURING C-CHECK INSPECTION, FOUND LEFT INBOARD SEAT TRACK CORRODED AT SCREW HOLES STATION 1150.0 THROUGH 1213. REMOVED AND REPLACED SEAT TRACK. AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR UPS99228618Seat Track · corrodedINSPECTION TYPE-SI, CORROSION (C53-111-01.00-03) IN AFT CARGO BAY LBL 16 WL 150 BS 1063 TO 1168 (CARGO TRACK). REMOVED, FABRICATED AND INSTALLED NEW CARGO TRACK WORK DONE IAW SRM'S 53-10-1, 53-10-5, 51-10-3, 51-10-2, 51-20-1, 51-30-2.SDR RRXA991143Seat Track · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION, FUSELAGE, CABIN FLOOR TRACK BETWEEN STA 480 AND STA 520, BL 44 LEFT, WL 0. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED NEW SEAT TRACK SECTION AND INSTALLED SEASDR CA990310014Seat Track · corroded(CAN) SEAT RAIL FOUND CORRODED UNDER LAV/GALLEY AREA. PART REPLACED.SDR UPS99828494Seat Track · corrodedINSPECTION TYPE-C3, SECOND OBS FWD SEAT TRACK HAS HEAVY CORROSION AROUND RT ATTACH SCREW. REMOVED AND REPLACED SEAT TRACK IAW SRM 51-3-0.SDR RRXA991152Seat Track · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION, FUSELAGE, CABIN FLOOR TRACK AT BL 44 LEFT, BETWEEN STA 240 AND STA 329. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. (CORROSION DAMAGE RECORDED IN EWA CORROSION PROGRAM).SDR C2XA99IA014Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE LEFT INBOARD PASSENGER SEAT TRACK WAS FOUND TO BE CORRODED AT FRAME 36. MAINTENANCE REMOVED AND REPLACED THE AFFECTED SECTION OF SEAT TRACK IAW ATR42-320 SRM 51-25-04, AND 51-25-02, AND THE AIRCRAFT WAS APPROVED FOR RETURNSDR C2XA99IA013Seat Track · corrodedIAH - DURNG C-CHECK INSPECTION, THE RIGHT INBOARD PASSENGER SEAT TRACK WAS FOUND TO BE CORRODED AT FRAME 36. MAINTENANCE REMOVED AND REPLACED THE AFFECTED SECTION OF SEAT TRACK IAW ATR42-320 SRM 51-25-04, AND 51-25-02, AND THE AIRCRAFT WAS APPROVED FOR RETURNSDR C2XA99IA011Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE LEFT INBOARD SEAT TRACK WAS FOUND TO BE CORRODED FROM FRAME 34.5 TO FRAME 36. MAINTENANCE REMOVED AND REPLACED THE AFFECTED SECTION OF SEAT TRACK IAW ATR42-320 SRM 51-25-40, AND 51-25-02, AND THE AIRCRAFT WAS APPROVED FOR SDR C2XA99IA010Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE RIGHT INBOARD SEAT TRACK WAS FOUND TO BE CORRODED FROM FRAME 34 TO FRAME 36. MAINTENANCE REMOVED AND REPLACED THE AFFECTED SECTION OF SEAT TRACK IAW ATR42-320 SRM 51-25-04, AND 51-25-02, AND THE AIRCRAFT WAS APPROVED FOR RSDR C2XA99IA006Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE RIGHT OUTBOARD SEAT TRACK WAS FOUND TO BE CORRODED FROM FRAME 34 TO FRAME 36. MAINTENANCE REMOVED AND REPLACED THE AFFECTED SECTION OF SEAT TRACK IAW ATR42-320 SRM 51-25-02, AND 51-70-00, AND THE AIRCRAFT WAS APPROVED FOR SDR QXEA9900194Seat Track · gougedPDX - THERE ARE THREE AREAS WITH LIGHT GOUGES IN CHANNEL LIP ON THE LEFT OUTBOARD SEAT TRACK, BETWEEN FRAME 12875 AND 13815. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 8-9, PARAGRAPH B AND C.SDR QXEA9900191Seat Track · corrodedPDX - THERE ARE THREE AREAS WITH PITTING CORROSION INSIDE CHANNEL OF RIGHT OUTBOARD SEAT TRACK, BETWEEN FRAMES 10966 AND 12875. REPAIRED IAW SRM 51-10-4, PAGES 8 AND 9, PARAGRAPH B AND C.SDR QXEA9900190Seat Track · corrodedPDX - THERE ARE TWO AREAS OF PITTING CORROSION ON INBOARD FLOOR SUPPORT FLANGE OF THE RIGHT OUTBOARD SEAT TRACK BETWEEN FRAMES 10966 AND 11905. REPAIRED IAW MM 53-40-01, PAGE 201-202, PARAGRAPH B6, STEPS 1-6.SDR UPS99828561Seat Track · corrodedINSPECTION TYPE-C, SEAT TRACK BETWEEN FS 920 AND 940, RBL 60 IS CORRODED OUT OF LIMITS. REMOVED DAMAGED SEAT TRACK BETWEEN FS 720 AND 950, SPLICED IN A NEW SECTION IAW EO DC8-5320-5167-C.SDR UPS99828353Seat Track · corrodedINSPECTION TYPE:C SEAT TRACK AT FS 1370, AT BL 0 HAS CORROSION OUT OF LIMITS. REMOVED DAMAGED SEAT TRACK FROM FS 1370 TO 1530 AT BL 0 AND SPLICED IN A NEW SECTION OF TRACK IAW SRM 53-2-3.SDR SPAA9800017Floor Track · corrodedDURING ACCOMPLISHMENT OF CPCP TASK C53-107-02, CABIN FLOOR TRACK AT BS 335, RBL 22, WAS FOUND CORRODED BEYOND SRM LIMITS. DAMAGED PART WAS REPLACED PER SRM 53-10-5, FIG 2.SDR UPS99828485Seat Track · corrodedINSPECTION TYPE-C, SEAT TRACK BLOWN AT FS 1500 AT RBL 50. REMOVED DAMAGED SEAT TRACK BETWEEN FS 1470 TO 1550, FABRICATED AND REPLACED SEAT TRACK IAW SRM 53-2-3 FIG 6A, 51-3-0.SDR UPS99828484Seat Track · corrodedINSPECTION TYPE-C, SEAT TRACK BLOWN AT FS 1060, RBL 50. REMOVED DAMAGED SEAT TRACK BETWEEN FS 1010 TO 1106, FABRICATED AND REPLACED SEAT TRACK IAW SRM 53-7-1, 51-1-21 AND 51-3-0.SDR UPS99828355Seat Track · splitINSPECTION TYPE:C SEAT TRACK SPLIT AND CORRODED AT FS 1060, LBL 60. REMOVED DAMAGED SEAT TRACK FROM FS 1000-1300, LBL 60 IAW SRM 53-2-3.SDR UPS99828352Seat Track · corrodedINSPECTION TYPE:C SEAT TRACK AT FS 1500 AT LBL 50 HAS HEAVY CORROSION. CUT OUT DAMAGED SEAT TRACK FROM FS 1270 TO 1520, LBL 50 AND SPLICED IN A NEW SECTION IAW SRM 53-2-3.SDR UPS99828349Seat Track · corrodedINSPECTION TYPE:C SEAT TRACK AT FS 1060-1080 AT RBL 60 HAS HEAVY CORROSION. REMOVED AND REPLACED SEAT TRACK FROM FS 1030 TO 1110, RBL 60 IAW SRM 53-2-3.SDR UPS99828346Seat Track · corrodedINSPECTION TYPE:C HEAVY CORROSION ON SEAT TRACK LOR FLANGE AT FS 770 AT LBL 25. REMOVED DAMAGED SECTION OF SEAT TRACK, FS 650-875 LBL 25, PER SRM 53-2-3.
Back to JASC 5347