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 AWXA9800091Floor Track · corrodedNR 4 FLOOR TRACK, STATION 800, AT FRAME 20 CORRODED NR 4 FLOOR TRACK, STATION 800, AT FRAME 20 CORRODED. REPAIRED PER SRM 53-00-15, FIG 201 PG 204 NR 4 FLOOR TRACK, STATION 800, AT FRAME 20 CORRODED, REPAIRED PER SRM 53-00-15, FIG 201 PG. 204.SDR AALA980589Seat Track · corrodedTUL - FOUND TWO AREAS OF CORROSION AND MECHANICAL DAMAGE ON NR 10 TRACK. INSTALLED TRACK NR 10 BETWEEN FRAMES 21-26 PER SRM 51-72-10-0, ALODINED, PRIMED AND PAINTED TRACK PER SRM 51-21-00-0. (M)SDR AALA980588Seat Track · corrodedTUL - FOUND CORROSION ON TRACK NR 10, 4 INCHES FORWARD OF FRAME 28. INSTALLED TRACK NR 10 FROM FRAME 26-30 PER SRM 51-72-10-0. (M)SDR P5CA9800567Seat Track · corrosionLEVEL 1 CORROSION ON SEAT TRACK STA 920 RBL 97R. REPAIRED CORROSION PER SRM 53-10-05.SDR AALA980587Track · corrodedTUL - TRACK 3A LAV SUPPORT TRACK HAS CORROSION IN AROUND 3 LAVATORY BOLT HOLES AND ON TOP OF TRACK. REMOVED CORRODED TRACK AND LAVATORY SUPPORT BOLT HOLE BLOCKS AND REPLACED WITH NEW PER SRM 51-72-10-0 AND 51-21-00-0. (M)SDR AALA980585Seat Track · corrodedTUL - FOUND CORROSION AROUND FLOORBOARD MOUNT HOLE ON NR 7 TRACK JUST AFT OF FRAME 78. BLENDED OUT CORROSION AND INSTALLED STRAP DOUBLER PER AARD 53-20-00-02. (M)SDR AALA980583Seat Track · corrodedTUL - FOUND CORROSION IN NR 2 SEAT TRACK AT STATION 1304. CORROSION REMOVAL WENT BEYOND LIMITS. REPLACED SEAT TRACK NR 2 FROM STATION 1260 TO 1309 AND SPLICE PER SRM 53-05 FIG 4F. (M)SDR AWXA9800087Floor Track · corrodedDURING SCHEDULED C-5 INSPECTION, FOUND NR 4 TRACK CORRODED STATION 800. TRACK REPLACED AS PER SRM 53-11-15, PAGE 217 AND 218.SDR P5CA9800733Tie Down · corrodedLEVEL 1 CORROSION AT TIE DOWN FITTING SUPPORT FUSELAGE BS 2300 BL 22. REMOVED CORROSION AND REPROTECTED PER SRM 51-10-01 AND 51-10-02.SDR P5CA9800732Tie Down · corrodedLEVEL 1 CORROSION AT TIE DOWN FUSELAGE BS 2180 BL 30. REMOVED CORROSION AND REPROTECTED PER SRM 51-10-01 AND 51-10-02.SDR P5CA9800727Tie Down · corrosionLEVEL 1 CORROSION ON TIE DOWN AT FUSELAGE BS 1000 BL R97. CORROSION REMOVED AND REPROTECTED PER SRM 51-01-01 AND 51-10-02.SDR P5CA9800726Tie Down · corrosionLEVEL 1 CORROSION ON TIE DOW AT FUSELAGE BS 980 BL L11. CORROSION REMOVED AND REPROTECTED PER SRM 51-10-01 AND 51-10-02.SDR P5CA9800717Tie Down Track · corrodedLEVEL 1 CORROSION ON MAIN DECK TIE DOWN TRACK AT BS 1120 TO 1170 BL R11. REMOVED CORROSION AND REPROTECTED PER SRM 51-10-01 AND 51-10-02.SDR P5CA9800715Seat Track · corrosionLEVEL 1 CORROSION ON UPPER DECK SEAT TRACK AT BS 520 BL 9. CORROSION REMOVED, REPAIRED AND REPROTECTED PER SRM 51-10-01, 51-10-02 AND 53-10-05.SDR P5CA9800711Seat Track · brokenMAIN DECK SEAT TRACK BROKEN AT BS 2150 TO 2230. SEAT TRACK REPAIRED PER SRM 53-10-08.SDR P5CA9800710Seat Track · wornSEAT TRACK BS 2260 BL 33 DEEPLY WORN. REPLACED SEAT TRACK PER SRM 53-10-05.SDR P5CA9800566Seat Track · corrosionLEVEL 1 CORROSION ON SEAT TRACK BS 498 TO 500 LBL 99L. REPAIRED CORROSION PER SRM 51-10-01.SDR P5CA9800554Seat Track · corrodedLEVEL 1 CORROSION ON SEAT TRACK FLANGE AT BS 1110 BL 98. CORROSION REMOVED, REPAIRED AND REPROTECTED PER SRM 51-10-01, 53-10-01 AND 51-10-02.SDR P5CA9800551Seat Track · corrosionLEVEL 1 CORROSION ON SEAT TRACK BS 520 TO 530 BL L47. CORROSION REMOVED TRACK REPLACED AND REPROTECTED PER SRM 51-10-01, 53-10-01, 51-10-02.SDR P5CA9800530Seat Track · crackedBS 2250 LBL 11 SEAT TRACK WEB CRACKED. REPAIRED SEAT TRACK PER SRM 51-40-02.SDR CALA9800580Seat Track · corrodedINSPECTION FOUND SEAT TRACK CORRODED AT STA 1090, LBL 55 AND AT STA 970 TO 1130, RBL 24. THE SEAT TRACKS WERE REMOVED AND REPLACED IAW SRM 53-10-2, 51-10-2, AND 51-20-11.SDR CALA9800574Seat Track · corrodedINSPECTION FOUND TOP AND BOTTOM OF RT OUTBOARD SEAT TRACK CORRODED AT FS 400 TO 440. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 51-30-2, 53-10-5 AND 51-10-2.SDR AALA980564Seat Track · corrodedTUL - THE SMALL SEAT TRACK INBOARD OF R-4 DOOR IS CORRODED BETWEEN 73 FRAME AND 74 FRAME TRACK 9. REMOVED AND REPLACED SEAT TRACK LOCATED AT TRACK 9 BETWEEN FRAME 73 AND 74 PER SRM 51-77-10-0. (M)SDR AALA980547Seat Track · corrodedTUL - FOUND CORRODED SEAT TRACK NR 6. REMOVED AND REPLACED THE SECTION OF SEAT TRACK NR 6 PER SRM 51-72-10-0. (M)SDR SIMA980781Seat Tracks · corrodedSAW - DURING CPCP-4 INSPECTION, MAINTENANCE REPORTED THE RIGHT MID OUTBOARD, THE RIGHT AFT OUTBOARD, RIGHT AFT INBOARD, LEFT AFT OUTBOARD, LEFT AFT INBOARD, RIGHT FLIGHT ATTENDANT AND LEFT FLIGHT ATTENDANT SEAT TRACKS CORRODED. MAINTENANCE REMOVED AND REPLACESDR CALA9800520Seat Track · corrodedINSPECTION FOUND SEAT TRACK CORRODED AT STA 1030-1090, RBL 36. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 53-10-5, PAGES 18-22.SDR CALA9800519Seat Track · corrodedINSPECTION FOUND SEAT TRACK CORRODED AT STA 1030-1140, RBL 24. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 53-10-5, PAGES 18-22.SDR CALA9800518Seat Track · corrodedINSPECTION FOUND LT OUTBOARD SEAT TRACK CORRODED AT FS 1080-1110, LBL 45. THE CORRODED SECTION OF TRACK WAS CUT OUT AND A NEW SECTION WAS FABRICATED AND INSTALLED IAW SRM 53-10-5.SDR CALA9800510Seat Track · corrodedINSPECTION FOUND RT INBOARD SEAT TRACK CORRODED AT STA 380-440. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 51-10-2 AND 51-30-2.SDR CALA9800509Seat Track · corrodedINSPECTION FOUND SEAT TRACK CORRODED AT STA 1070-1110, RBL 15. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 51-30-1.SDR AALA980544Roller Tray · corrodedTUL - RIGHT INBOARD L/L GALLEY ROLLER TRAY HAS SEVERAL AREAS OF CORROSION. INSTALLED NEW SECTION OF TRACK FROM STATION 725 TO STATION 879 PER SRM 53-70-00 FIG NR 8. (M)SDR AALA980527Seat Track · corrodedTUL - SEAT TRACK NR 6 CORRODED UNDER GALLEY 840-850. REPLACED SECTION OF SEAT TRACK FROM STATION 735-879 PER SRM 53-70-00. (M)SDR 98ZZZM420Seat Tracks · corrodedSAW - DURING CPCP-4 INSPECTION, MAINTENANCE REPORTED THE RIGHT MID OUTBOARD, THE RIGHT AFT OUTBOARD, RIGHT AFT INBOARD, LEFT AFT OUTBOARD, LEFT AFT INBOARD, RIGHT FLIGHT ATTENDANT AND LEFT FLIGHT ATTENDANT SEAT TRACKS CORRODED. MAINTENANCE REMOVED AND REPLACESDR 98ZZZM419Seat Tracks · corrodedSAW - DURING CPCP-4 INSPECTION, MAINTENANCE REPORTED THE RIGHT MID OUTBOARD, THE RIGHT AFT OUTBOARD, RIGHT AFT INBOARD, LEFT AFT OUTBOARD, LEFT AFT INBOARD, RIGHT FLIGHT ATTENDANT AND LEFT FLIGHT ATTENDANT SEAT TRACKS CORRODED. MAINTENANCE REMOVED AND REPLACESDR 98ZZZM418Seat Tracks · corrodedSAW - DURING CPCP-4 INSPECTION, MAINTENANCE REPORTED THE RIGHT MID OUTBOARD, THE RIGHT AFT OUTBOARD, RIGHT AFT INBOARD, LEFT AFT OUTBOARD, LEFT AFT INBOARD, RIGHT FLIGHT ATTENDANT AND LEFT FLIGHT ATTENDANT SEAT TRACKS CORRODED. MAINTENANCE REMOVED AND REPLACESDR VJ9800081Seat Track · corrodedSEAT TRACK, FS 200 TO 230, BL 45L, CORRODED. REPLACED SEAT TRACK FROM FS 200 TO 230, BL 45L IAW DC9 SRM 53-05, FIG 4D, 51-30-1 AND 51-30-2.SDR VJ9800080Seat Track · corrodedSEAT TRACK FS 245, BL 44.5R, CORRODED. REPLACED SEAT TRACK SPLICE IAW DC9 SRM 51-30-1, 51-30-2 AND 53-05.SDR VJ9800079Seat Track · corrodedSEAT TRACK FS 200 TO 245, BL 44.5R, CORRODED. REPLACED SEAT TRACK FROM FS 200 TO 245, BL 44.5R, IAW DC9 SRM 51-30-1, 51-30-2 AND 53-05.SDR VJ9800078Seat Track · corrodedSEAT TRACK FS 200 TO 220, BL 22L, CORRODED. REPLACED SEAT TRACK FROM FS 200 TO 325 IAW DC9 SRM 51-30-1 AND 53-05.SDR TWAA9806501Track · corrodedMCI - DURING CHECK-C, MAINTENANCE FOUND NR 1 CHAIR TRACK CORRODED BEYOND LIMITS AT FS 237 TO FS 256. REPLACED CHAIR TRACK SECTION PER SRM 51-01, PAGE 1. ACFT TT: 38,048 HOURS. ACFT TC: 32,705. (X)SDR TWAA9804501Seat Track · corrodedMCI - DURING OP 16 MAINTENANCE CHECK, FOUND NR 1 CHAIR TRACK CORRODED BEYOND LIMITS FS 237 TO FS 256. REPLACED CHAIR TRACK SECTION PER SRM 51-01. (X)SDR AALA980533Roller Tray · corrodedTUL - FOUND SEVERAL AREAS OF CORROSION ON LEFT OUTBOARD ROLLER TRAY. INSTALLED NEW TRAY PER AARD 51-01-00-05. (M)SDR TWAA9804204Seat Track · corrodedMCI - DURING OP 16 MAINTENANCE CHECK, INNER GRANULAR CORROSION WAS FOUND AT INBD SIDE OF NR 2 CHAIR TRACK, FS 1267 - FS 1278. REPLACED NR 2 CHAIR TRACK FS 1220 - FS 1309 PER SRM 53-08. (X)SDR AALA980519Tie Down · corrodedTUL - FOUND CARGO FLOOR, THIRD TIE DOWN FROM DOOR FLOOR BRACKET HAS CORROSION. SPLICED IN REPAIR PER SRM 53-10-15-2. (M)SDR UPS98226323Seat Track · corrodedINSPECTION TYPE-C, CORROSION ON SEAT TRACK FLANGE, AS MARKED, IN MAIN DECK BS 870 TO 960 RBL 45 WL 208. CORROSION FOUND TO BE OUT OF LIMITS PER SRM 53-10-1. REPLACED WITH NEWLY FABRICATED ITEM PER SRM 53-10-5, 51-30-2 AND 51-30-0.SDR TWAA9804205Seat Track · corrodedMCI - DURING OP 16 MAINTENANCE CHECK, INNER GRANULAR CORROSION WAS FOUND ON NR 1 CHAIR TRACK ON OTBD RADIUS STA 1140. REPLACED CHAIR TRACK SECTION FS 1126 - FS 1145 OF NR 1 TRACK PER SRM 53-05 FIG 4. (X)SDR CALA9800468Floor Track · corrodedINSPECTION FOUND FLOOR TRACK CORRODED AT STA 380 TO 420, RBL 25. THE TRACK WAS REMOVED AND A NEW TRACK WAS FABRICATED AND INSTALLED IAW SRM 53-05-01 AND 51-10-01.SDR CALA9800456Floor Track · corrodedINTERIOR UPPER LOBE CABIN UNDER FLOOR LAV/GALLEY CORROSION ON FLOOR TRACK AT STA 840, RBL 27. THE FLOOR TRACK WAS REMOVED, A NEW TRACK WAS INSTALLED IAW SRM 53-70-00, 51-20-00, AND 51-31-01.SDR UPS98826150Seat Track · corrodedINSPECTION TYPE:C STA 950 TO 1070 LBL 59, THE SEAT TRACK HAS HEAVY CORROSION. REMOVED, FABRICATED AND INSTALLED REPLACEMENT SECTION OF TRACK FROM STA 930 TO 1070 IAW SRM 53-2-3.SDR UPS98826144Seat Track · corrodedINSPECTION TYPE:C STA 1070 AT BL0 THE SEAT TRACK IS CORRODED. REMOVED, FABRICATED REPLACEMENT SECTION OF TRACK IAW SRM 53-2-3.
Back to JASC 5347