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 98ZZZM286Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS ON THE FLOOR SEAT TRACKS AB BS 383. SEAT TRACK WAS REPAIRED IAW KITTY HAWK EA D9-53-051. REFERENCE GAIA9815.SDR 98ZZZM285Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS ON THE FLOOR SEAT TRACKS AB BS 383. SEAT TRACK WAS REPAIRED IAW KITTY HAWK EA D9-53-051. REFERENCE GAIA9815.SDR 98ZZZM284Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS ON THE FLOOR SEAT TRACKS AB BS 383. SEAT TRACK WAS REPAIRED IAW KITTY HAWK EA D9-53-051. REF GAIA9815.SDR 98ZZZM283Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS ON THE FLOOR SEAT TRACKS AB BS 383. SEAT TRACK WAS REPAIRED IAW KITTY HAWK EA D9-53-051. REF GAIA9815.SDR 98ZZZM282Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS ON THE FLOOR SEAT TRACKS AB BS 383. SEAT TRACK WAS REPAIRED IAW KITTY HAWK EA D9-53-051. REF GAIA9815.SDR 98ZZZM281Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS ON THE FLOOR SEAT TRACKS AB BS 383. SEAT TRACK WAS REPAIRED IAW KITTY HAWK EA D9-53-051. REF GAIA9815.SDR 98ZZZM280Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS ON THE FLOOR SEAT TRACKS AB BS 383. SEAT TRACK WAS REPAIRED IAW KITTY HAWK EA D9-53-051. REF GAIA9815.SDR 98ZZZM279Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS ON THE FLOOR SEAT TRACKS AB BS 383. SEAT TRACK WAS REPAIRED IAW KITTY HAWK EA D9-53-051. REF GAIA9815.SDR 98ZZZM278Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS ON THE FLOOR SEAT TRACKS AB BS 383. SEAT TRACK WAS REPAIRED IAW KITTY HAWK EA D9-53-051. REF GAIA9815.SDR 98ZZZM277Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS ON THE FLOOR SEAT TRACKS AB BS 383. SEAT TRACK WAS REPAIRED IAW KITTY HAWK EA D9-53-051. REF GAIA9815.SDR 98ZZZM276Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS ON THE FLOOR SEAT TRACKS AB BS 383. SEAT TRACK WAS REPAIRED IAW KITTY HAWK EA D9-53-051. REF GAIA9815.SDR 98ZZZM275Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS ON THE FLOOR SEAT TRACKS AB BS 383. SEAT TRACK WAS REPAIRED IAW KITTY HAWK EA D9-53-051. REF GAIA9815.SDR 98ZZZM274Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS ON THE FLOOR SEAT TRACKS AB BS 383. SEAT TRACK WAS REPAIRED IAW KITTY HAWK EA D9-53-051. REF GAIA9815.SDR 98ZZZM273Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS ON THE FLOOR SEAT TRACKS AB BS 383. SEAT TRACK WAS REPAIRED IAW KITTY HAWK EA D9-53-051. REF GAIA9815.SDR 98ZZZM272Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS ON THE FLOOR SEAT TRACKS AB BS 383. SEAT TRACK WAS REPAIRED IAW KITTY HAWK EA D9-53-051. REF GAIA9815.SDR 98ZZZM271Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS ON THE FLOOR SEAT TRACKS AB BS 383. SEAT TRACK WAS REPAIRED IAW KITTY HAWK EA D9-53-051. REF GAIA9815.SDR 98ZZZM268Seat Track · corrodedSAW - DURNG CPCP-4 INSPECTION MAINTENANCE REPORTED THE FOLLOWING SEAT TRACKS WERE CORRODED. THE LEFT AFT OUTBOARD, LEFT AFT INBOARD, RIGHT AFT OUTBOARD, RIGHT AFT INBOARD, RIGHT AFT CARGO, RIGHT FLIGHT ATTENDANT AND LEFT FLIGHT ATTENDANT. MAINTENANCE REMOVEDSDR 98ZZZM267Seat Track · corrodedSAW - DURING CPCP-4 INSPECTION MAINTENANCE REPORTED THE FOLLOWING SEAT TRACKS WERE CORRODED. THE LEFT OUTBOARD, LEFT AFT INBOARD, RIGHT AFT OUTBOARD, RIGHT AFT INBOARD. MAINTENANCE REMOVED AND REPLACED SEAT TRACKS IAW SRM 51-25-04. A/C WAS RETURNED TO SERVISDR 98ZZZM266Seat Track · corrodedSAW - DURING CPCP-4 INSPECTION MAINTENANCE REPORTED THE FOLLOWING SEAT TRACKS WERE CORRODED. THE LEFT OUTBOARD, LEFT AFT INBOARD, RIGHT AFT OUTBOARD, RIGHT AFT INBOARD. MAINTENANCE REMOVED AND REPLACED SEAT TRACKS IAW SRM 51-25-04. A/C WAS RETURNED TO SERVISDR VJ9800126Seat Track · corrodedNR 2 SEAT TRACK, FS 275 TO 325, BL 22L, CORRODED BEYOND LIMIT. FABRICATED AND INSTALLED SEAT TRACK IAW DC9 SRM 51-30-1 AND 53-05, FIG 4.SDR VJ9800125Seat Track · corrodedNR 2 SEAT TRACK, FS 200 TO 250, CORRODED BEYOND LIMITS. FABRICATED AND INSTALLED NEW SEAT TRACK IAW DC9 SRM 51-30-1 AND 53-05, FIG 4.SDR UPS98825801Seat Track · corrodedINSPECTION TYPE-C, FS 1130 LBL 44 TRACK IS CORRODED BEYOND ALLOWABLE LIMITS. REMOVED, FABRICATED, AND INSTALLED REPLACEMENT SECTION OF TRACK IAW SRM ADDN DC8-5320-8309-B.SDR EIAA98047Seat Track · corrosionHKG - DURING 'C5/D' CHECK INSPECTION, BS 560 -580 AT RBL 55 SEAT TRACK HAS CORROSION. REPAIRED IAW SRM 53-10-05. (M)SDR DHL9872416CSeat Track · corrodedAT C-CHECK, SEAT TRACK CORRODED AT RBL 45, BS 1050. CUT OUT DAMAGED SECTION FROM 1030 TO 1070 PER SRM 53-10-5, AND REPLACED PER THE SAME. N/R 3671.SDR DHL9872415CSeat Track · corrodedAT C-CHECK, SEAT TRACK CORRODED AT BS 1050 LB 45. CUT OUT CORRODED SECTION, INSTALLED SEAT TRACK PER SRM 53-10-5. N/R 3672.SDR AALA980265Roller Tray · corrodedTUL - NR 4 ROLLER TRAY HAS CORROSION FROM STA 1601 - STA 1701. REMOVED CORROSION AND SPLICED TRAY STA 1641 PER SRM 53-70-00 VOL I. TST: 60,422.53 HOURS. CYCLES: 20,166. (X)SDR 98ZZZM248Seat Track · corrodedTHE FOLLOWING ITEMS WERE LEVEL 2 CORROSION FINDINGS DURING INDOC INSPECTION, CORROSION SEAT TRACK BS 1110-1130, RBL 24. REPAIRED PER SRM ON PMS NR 5799. REF GAIA9808.SDR 98ZZZM247Seat Track · corrodedTHE FOLLOWING ITEMS WERE LEVEL 2 CORROSION FINDINGS DURING INDOC INSPECTION, CORROSION SEAT TRACK BS 1110-1120, RBL 24. REPAIRED PER SRM ON PMS NR 5778. REF GAIA9808.SDR 98ZZZM243Seat Track · corrodedTHE FOLLOWING ITEMS WERE LEVEL 2 CORROSION FINDINGS DURING INDOC INSPECTION, CORROSION SEAT TRACK BS 680-700, LBL 25. REPAIRED PER SRM ON PMS NR 5819. REFERENCE GAIA9807.SDR 98ZZZM242Seat Track · corrodedTHE FOLLOWING ITEMS WERE LEVEL 2 CORROSION FINDINGS DURING INDOC INSPECTION, CORROSION SEAT TRACK BS 480-560, LBL 24. REPAIRED PER SRM ON PMS NR 5829. REFERENCE GAIA9807.SDR 98ZZZM241Seat Track · corrodedTHE FOLLOWING ITEMS WERE LEVEL 2 CORROSION FINDINGS DURING INDOC INSPECTION CORROSION SEAT TRACK BS 560-640, LBL 46. REPAIRED PER SRM ON PMS NR 5845.. REFERENCE GAIA9807.SDR 98ZZZM240Seat Track · corrodedTHE FOLLOWING ITEMS WERE LEVE 2 CORROSION FINDINGS DURING INDOC INSPECTION, CORROSION SEAT TRACK BS 560-640, LBL 25. REPAIRED PER SRM ON PMS NR 5846. REFERENCE GAIA9807.SDR EIAA98037Seat Track · crackedHKG - DURNG 'C5/D' CHECK INSPECTION, SEAT TRACK FOUND CRACKED BS 701, RBL 11. REPAIRED IAW SRM 53-10-05 FIG 14. (M)SDR AALA980261Roller Tray · corrodedTUL - ROLLER TRAY NR 1 HAS CORROSION AT STA 1621 - STA 1561. REMOVED AND REPLACED TRAY TRACK PER SRM 53-70-00 FIG 7. TST: 60,422.53 HOURS. CYCLES: 20,166. (X)SDR AALA980260Roller Tray · corrodedTUL - NR 1 ROLLER TRAY HAS CORROSION STA 1661. REMOVED AND REPLACED TRAY PER AARD 51-01-00-05. SPLICED PER SRM 53-70-00 FIG 7. TST: 60,422.53 HOURS. CYCLES: 20,166. (X)SDR UPS98225846Seat Track · corrodedINSPECTION TYPE-SI, CORROSION (44-53-12) IN SEAT TRACK WELL BS 970 TO 1110 RBL 25, WL 208 CORROSION FOUND TO BE OUT OF LIMITS PER SRM 53-10-1. FABRICATED NEW TRACK AND SPLICE PER 53-10-5, INSTALLED PER SRM 51-30-2.SDR UPS98225789Seat Track · corrodedINSPECTION TYPE-SI, CORROSION (44-53-12) IN SEAT TRACK WELL AND AROUND NUT PLATES BS 1010 TO 1110, RBL 62, WL 208. CORROSION FOUND OUT OF LIMITS PER SRM 51-30-2, REPLACED SEAT TRACK WITH NEW ITEM PER SRM 51-30-2, SRM 51-10-2 AND SRM 51-20-151.SDR TSAA9851080Track · corrodedDURING CPC CHECK, FOUND CORROSION ON RIGHT OUTBOARD TRACK AT DOOR SILL (AFT CARGO PIT). REPAIRED DAMAGE BY REPLACING TRACK PER SRM 51-10-1. (M)SDR MWEA98142Seat Track · corrodedDURING INSPECTION, FOUND GALLEY SEAT TRACK NR 3 IS CORRODED FROM STATION 200 TO STATION 240. MTC REPAIRED IAW SRM 53-05 FIG 40.SDR C2XA98IA008Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, FOUND FLIGHT ATTENDANTS RIGHT SEAT TRACK CORRODED IN SEVERAL AREAS. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK IAW ATR-42 STRUCTURAL REPAIR MANUAL 51-25-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR B4MR98027Seat Track · corrodedDURING ROUTINE C-CHECK INSPECTION, FOUND CORROSION BETWEEN STA 480 TO 660 RBL 44 SEAT TRACK. REMOVED CORROSION IAW B727 SRM 51-10-1, FOUND TO BE OUT OF LIMITS IAW B727 SRM 53-10-1. REMOVED DAMAGED SEAT TRACK AT STA 480 TO 520 AND STA 580 TO 660 IAW B727 SRM SDR B4MR98026Seat Track · corrodedDURING ROUTINE CPCP INSPECTION, FOUND FS 1130 LBL 44 SEAT TRACK HAS CORROSION. REMOVED SEAT TRACK IAW B727 SRM 51-10-6, OUT OF LIMITS IAW B727 SRM 53-10-1. INSTALLED SEAT TRACK IAW B727 SRM 51-30-2. CORROSION TASK CARD NUMBER C53-224-03. NON-ROUTINE TASK CSDR B4MR98025Seat Track · wornDURING ROUTINE C-CHECK INSPECTION, FOUND SEAT TRACK WORN BETWEEN FS 783 TO 795 RBL 24. REMOVED CORROSION, CORROSION REMOVAL BEYOND LIMITS IAW B727 SRM 53-10-1. INSTALLED REPAIR IAW B727 SRM 53-10-5 FIG 2. C-CHECK WORK CARD NUMBER 40090. NON-ROUTINE TASK CASDR B4MR98024Seat Track · corrodedDURING ROUTINE C-CHECK INSPECTION, FOUND CORROSION STA 480 TO STA 690 RBL 24 SEAT TRACK. REMOVED CORROSION IAW B727 SRM 51-10-1. FOUND TO BE OUT OF LIMITS IAW B727 SRM 53-10-1. INSTALLED SEAT TRACK IAW B727 SRM 53-10-5. C-CHECK WORK CARD NUMBER 40090. NONSDR B4MR98023Seat Track · wornDURING ROUTINE C-CHECK INSPECTION, FOUND SEAT TRACK WORN BETWEEN FS 880 TO 900 LBL 24. REMOVED WORN AREAS IAW B727 SRM 51-10-1, FOUND TO BE OUT OF LIMITS IAW B727 SRM 53-10-1. INSTALLED REPAIR IAW B727 SRM 53-10-5. C-CHECK WORK CARD NUMBER 40090. NON-ROUTISDR B4MR98022Seat Track · wornDURING ROUTINE C-CHECK INSPECTION, FOUND SEAT TRACK WORN BETWEEN FS 720A AND 720B LBL 44. SEAT TRACK WORN BEYOND LIMITS IAW B727 SRM 53-10-1. INSTALLED NEW SEAT TRACK IAW SRM 53-10-5. C-CHECK WORK CARD NUMBER 40090. NON-ROUTINE TASK CARD NUMBER 14933.SDR B4MR98021Seat Track · corrodedDURING ROUTINE C-CHECK INSPECTION, FOUND SEAT TRACK BETWEEN FS 950A AND 1030 RBL 44 HAS SEVERAL AREAS CORROSION AND WORN. REMOVED CORROSION AND WORN AREAS IAW B727 SRM 51-10-1, FOUND TO BE OUT OF LIMITS IAW B727 SRM 53-10-1. INSTALLED REPAIR IAW B727 SRM 53-SDR B4MR98020Seat Track · damagedDURING ROUTINE C-CHECK INSPECTION, FOUND SEAT TRACK BETWEEN FS 328 AND 360 RBL 18 HAS DRILL HOLE. REMOVED DAMAGED SEAT TRACK IAW SRM 53-10-5. INSTALLED NEW SEAT TRACK IAW B727 SRM 53-10-5. C-CHECK WORK CARD NUMBER 40090. NON-ROUTINE TASK CARD NUMBER 14936.SDR B4MR98019Seat Track · corrodedDURING ROUTINE C-CHECK INSPECTION, FOUND FS 950B TO 990 RBL 24 SEAT TRACK HAS AREA OF CORROSION AND WORN. REMOVED CORROSION AND WORN AREAS IAW B727 SRM 51-10-1. FOUND TO BE OUT OF LIMITS IAW B727 SRM 53-10-1. INSTALLED REPAIR IAW B727 SRM 53-10-5. C-CHECK SDR B4MR98018Seat Track · corrodedDURING ROUTINE C-CHECK INSPECTION, FOUND FS 1070 TO FS 1110 SEAT TRACK HAS CORROSION AND WORN SPOTS. REMOVED CORROSION AND FOUND TO BE BEYOND LIMITS. INSTALLED REPAIR IAW B727 SRM 53-10-5. C-CHECK WORK CARD NUMBER 40090. NON-ROUTINE TASK CARD NUMBER 14938.
Back to JASC 5347