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 PCA0300836Seat Track · brokenSEAT TRACK CROWN BROKEN OFF STA 340-360. REPAIRED PER SRM 53-10-05.SDR UPS03440505Seat Track · corrodedINSPECTION TYPE: C, SEAT TRACK FOUND CORROSION AT 520 - 575 LBL 46. SEAT TRACK REPAIRED AT U/D BS 480 - 590 LBL 46 AS PER SRM 53-10-05 FIG 1A. CORROSION BLEND OUT 0.045 X 1 X 10 INCHES. EXCEED SRM LIMIT.SDR UPS03440504Seat Track · corrodedINSPECTION TYPE: C, SEAT TRACK FOUND CORROSION AT BS 560 - 565 LBL 65. SEAT TRACK REPAIRED AT U/D BS 530 - 570 LBL 65 AS PER SRM 53-10-05 FIG 1A. CORROSION BLEND OUT 0.040 X 1 X 10 INCHES. EXCEED SRM LIMIT.SDR PCA0300841Seat Track · crackedFWD CARGO AT BS 680 RBL 45.5 SEAT TRACK CRACK / TOP CHORD PUNCTURE. SEAT TRACK REPAIR SRM 53-10-05 FI 5 FLOOR STRUCTURE 51-40-03 FIG 1.SDR PCA0300844Seat Track · corrodedMAIN DECK SEAT TRACK FLANGE - LEVEL 1 CORROSION S1800 LBL 67.01. REPAIR PER SRM 53-10-05 FIG 1A.SDR CHA1200395015Seat Track · corrodedCORROSION FOUND ON LBL 55 SEAT TRACK BS 1070 TO BS 1140.SDR CH1A200395010Seat Track · corrodedCORROSION FOUND ON LBL 45 SEAT TRACK FS 1000 TO FS 1140.SDR P5CA0300822Seat Track · corrodedSEAT TRACK STA 970 LBL 98.58 LEVEL 1 CORROSION. REPAIRED SRM 53-10-05 1A.SDR P5CA0300821Seat Track · corrodedSEAT TRACK STA 1046 RBL 99.0 LEVEL 1 CORROSION. REPAIR PER SRM 53-10-05 FIG 34.SDR P5CA0300820Seat Track · corrodedSEAT TRACK STA 360 TO STA 420 LBL 91.045 LEVEL 1 CORROSION. REMOVED AND REPLACED TRACK PER SRM 53-10-05 FIG 1.SDR AUS20030496Seat Track · corroded(AUS) AFT FLIGHT ATTENDANT SEAT SUPPORT BRACKET CORRODED.SDR DHL2003801079Cargo Track · wornMAIN CARGO COMPT. NR 6 TRACK LUGS WORN (STA. 280.000 - STA. 321.000) REMOVED NR 6 TRACK DAMAGED SEGMENT IAW SRM 53-2-3 PG.49-50. CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B. INSTALLED NEW TRACK SEGMENT IAW SRM 53-2-3 PG. 49-50.SDR DHL2003803006Seat Track · dirtyF/E'S SEAT DIFFICULT TO SLIDE FORE AND AFT. LOCKING MECHANISM DOES NOT SEEM TO BE DISENGAGING FULLY. CLEANED SEAT TRACK, LUBED TRACK AND MECHANICAL HANDLE SEAT, OPS OK M/M 25-11-6.SDR 03FDEA00399Seat Track · crackedN 317 MAIN CARGO COMPT, SEAT TRACK IS CRACKED 10 INCHES LONG AT FS 960 LBL 28. REMOVED DAMAGED PORTION OF SEAT TRACK FROM STA 949 TO 989 AND R & R IAW SRM 53-70-00. REPAIR PARTS FABRICATED ON TRAVELER T2/323005 AND T2/323056, PAINTED IAW SRM 51-21-02.SDR DHL2003801080Cargo Track · wornMAIN CARGO COMPT. NR 2 TRACK PLUG LUGS AT STA. 219.000 WORN. REMOVED WORN PLUG AT STA. 219.000 IAW SRM 51-3-0 PG.1. CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B. INSTALLED NEW PLUG AND CHANNEL IAW SRM 53-2-3 PG.17-19.SDR DHL2003801078Cargo Track · wornMAIN CARGO COMPT. NR 2 CARGO TRACK LUGS BETWEEN STA. 1553 AND STA. 1620, WORN, CORRODED. REMOVED NR 2 WORN TRACK SEGMENT IAW SRM 53-2-3 PG. 49-50. CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B. FABRICATED 3 SPLICES IAW SRM 53-2-3 PG.49-50. INSTALLED NEW SDR CALA0300178Seat Track · corrodedINSPECTION FOUND SEAT TRACK CORRODED AT STA 277-294.5, RBL 40. A NEW SEAT TRACK WAS INSTALLED IAW SRM 51-10-2.SDR 2003F00540Seat Track · corrodedFOUND CABIN FLOOR SEAT TRACK HAS CORROSION FS 200-221 LBL 44. REMOVED CORRODED SECTION. FABRICATED AND INSTALLED REPAIR MEMBER IAW DC9 MD80 SRM 53-05 FIG 4F. (M)SDR 2003F00538Seat Track · corrodedFOUND CABIN FLOOR SEAT TRACK HAS CORROSION FS 200-223 LBL 22. REMOVED CORROSION. FABRICATED AND INSTALLED REPAIR MEMBER IAW DC9/MD80 SRM 51-10-3, 53-05 FIG 4B-1, 53-05 AND 53-05 FIG 4F. (M)SDR DHL2003801051Cargo Track · wornMAIN CARGO COMPT NR 6 TRACK LUGS WORN IN MANY POINTS, STA 1553.000 - STA 1593.000 (40.000). CUT OUT DAMAGED TRACK SEGMENT IAW SRM 53-2-3 PG 49-50. CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B. FABRICATED NEW SPLICE (7075-T6 0.100). CLEANTED, TREATED ANSDR DHL2003801064Cargo Track · wornMAIN CARGO COMPT NR 7 TRACK PLUG LUGS AT STA 318.000 WORN. REMOVED AND REPLACED NR 7 TRACK PLUG LUGS AT STA 318.000 IAW SRM 51-3-0 PG 1.SDR AWXA200300427Seat Track · corrodedLCQ - MAJOR REPAIR - DURING C-08 CHECK INTERGRANULAR CORROSION WAS FOUND ON SEAT TRACK AT BS 365, RBL 45. MAINTENANCE REMOVED SEAT TRACK AT RBL 45 FROM BS 365 TO BS 418; FABRICATED A NEW REPLACEMENT SEAT TRACK PER DWG 141N5130; INSTALLED REPAIR PART IAW B757-SDR AWXA200300417Seat Track · corrodedLCQ - MAJOR REPAIR - DURING C-08 CHECK EXFOLIATION CORROSION WAS FOUND SEAT TRACK BS 365 TO BS 418, RBL 24. MAINTENANCE REMOVED SEAT TRACK BS 365 TO BS 418, RBL 24; FABRICATED A NEW REPLACEMENT SEAT TRACK SUPPORT ASSEMBLY AND SHEAR TIE; INSTALLED REPAIR PARTSSDR DHL2003801040Cargo Track · wornMAIN CARGO COMPT NR 4 TRACK PLUG LUGS WORN AT STA 952.000. REMOVED AND REPLACED NR 4 TRACK PLUG AT STA 952.000 IAW SRM 51-3-0 PG 1.SDR AWXA200300405Seat Track · corrodedMCN - MAJOR REPAIR - DURING C-04 CHECK FILIFORM CORROSION WAS FOUND ON UPPER SURFACE OF RT INBOARD CABIN SEAT TRACK AT FORWARD END OF FR 20. MAINTENANCE REMOVED CORRODED RT INBOARD CABIN SEAT TRACK AT FORWARD END OF FR 20; FABRICATED A NEW REPLACEMENT SEAT TRSDR AWXA200300395Seat Track · corrodedMCN - MAJOR REPAIR - DURING C-04 CHECK FILIFORM CORROSION WAS FOUND ON UPPER SURFACE OF RT OUTBOARD CABIN SEAT TRACK FORWARD END AT FR 20. MAINTENANCE REMOVED CORROSION AND FOUND MATERIAL LOSS TO BE OUT OF LIMITS. REMOVED RT OUTBOARD CABIN SEAT TRACK FORWARDSDR DHL2003726002Seat Track · damagedS/O'S SEAT WILL NOT LOCK INTO RAIL FOR SIDEWAY MOVEMENT. CLEANED AND LUBRICATED SEAT RAILS AND LOCKING MECHANISM PER M/M 2510. OPS NORMAL.SDR UPS03840471Seat Track · crackedINSPECTION TYPE: C3, CABIN SEAT TRACK F CRACKED AT STA 1571. REMOVED AND REPLACED SEAT SECTION IAW DC8 SRM 53-2-3 AND UPS EO DC8- 5320-5167SDR UPS03840469Seat Track · crackedINSPECTION TYPE: C3, CABIN SEAT TRACK F CRACKED AT STA 1571. REMOVED AND REPLACED SEAT SECTION IAW DC8 SRM 53-2-3 AND UPS EO DC8- 5320-5167.SDR AWXA200300419Seat Track · corrodedMCN - MAJOR REPAIR - DURING C-04 CHECK GALVANIC CORROSION WAS FOUND ON UPPER SURFACE OF SEAT TRACK Y-1292 AT FR 66. MAINTENANCE REMOVED CORROSION AND FOUND MATERIAL LOSS TO BE OUT OF LIMITS; REMOVED DAMAGED SECTION OF BEAM Y-1292 FROM FR 64 TO FR 66; FABRICATSDR 2003UALA00335Seat Track · corrodedSEAT TRACK CORRODED, BS 800-808, LBL 52. MAJOR REPAIR ACCOMPLISHED. REPAIRED SEAT TRACK WITH SPLICE SECTION AND FILLERS.SDR AUS20030365Seat Track · cracked(AUS) SEAT TRACK CRACKED IN TWO PLACES. ON REMOVAL OF THE SEAT TRACK ANOTHER CRACK WAS FOUND AT THE CUTOUT FOR THE REMOVAL OF THESECOND ROW OF SEATS.SDR AUS20030364Seat Track · cracked(AUS) SEAT TRACK CRACKED AT REAR SEAT STOP. ON REMOVAL ANOTHER CRACK WAS FOUND AT THE SEAT REMOVAL CUTOUT.SDR DHL2003741511Seat Track · gougedDURING C-CHECK DISCREPANCY AS FOLLOWS, BS 521 - 530 LT BL 45 SEAT TRACK ARE GOUGED AT LOCK EARS. REMOVED DAMAGED SEAT TRACK AT BS 480-540 LBL 45 IAW B-727 SRM 51-30-2. LOCATED AND DRILLED NEW SEAT TRACK AND INSTALLED IAW B-727 SRM 53-10-5 FIG 7.SDR DHL2003741510Seat Track · gougedDURING C-CHECK DISCREPANCY AS FOLLOWS, BS 800 AND 824 LT BL 45 SEAT TRACK EARS ARE WORN WITH GOUGES. REMOVED DAMAGED SEAT TRACK AND INSTALLED NEW SEAT TRACK IAW B-727 SRM 51-30-2 AT BS 760 TO 848 LT BL 45.SDR MWEA030145Seat Track · corrodedNR 1 SEAT TRACK CORRODED INBOARD OF AFT SERVICE DOOR BY NUT PLATES. LOCATED, DRILLED AND INSTALLED TRACK SECTION.SDR AMTA200300477Cargo Track · corrodedC-3 CARGO COMPARTMENT TRACK CORRODED, 53 FUSELAGE 10 MAIN FRAME. REPAIRED C-3 TRACK AS PER SRM 53-24-00 AND ALODINED PRIMED AND PAINTED AREA AS PER SRM 51-21-02. (M)SDR AMTA200300458Floorbeam · corrodedC-2 COMPARTMENT FLOORBEAM CORRODED FS 1685 LBL 40. FABRICATED NEW CARGO FLOOR TRACK SECTION LBL 40 FS 1685-1725. INSTALLED CARGO FLOOR TRACK IAW 51-40-01 SRM. (M)SDR MWEA030141Seat Track · corroded# 1&2 SEAT TRACK HAS CORROSION AT FRAME STATION 1265. -- BLENDED SEAT TRACK, LOCATED,DRILLED AND INSTALLED REPAIR.SDR ASAA0310199Floorbeam · corrodedOKC - DURING D-CHECK, FOUND FLOORBEAM AT BS 420, BUTTOCK LINE 0, LEFT BUTTOCK LINE 25 CORRODED. REMOVED AND INSTALLED REPAIR PER SRM. (M)SDR ASAA0310193Seat Track · corrodedOKC - DURING D-CHECK, FOUND SEAT TRACK AT BODY STATION 520-540, RIGHT BUTTOCK LINE 46 CORRODED. REMOVED AND REPLACED SEAT TRACK PER SRM. (M)SDR ASAA0310159Seat Track · corrodedPAE - DURING C-CHECK, FOUND SEAT TRACK AT BS 727B-947, RIGHT BUTTOCK LINE 25 CORRODED. REMOVED AND REPLACED SEAT TRACK PER SRM. (M)SDR ASAA0310160Seat Track · corrodedPAE - DURING C-CHECK, FOUND SEAT TRACK AT BS 663-727B, RIGHT BUTTOCK LINE 25 CORRODED. REMOVED AND REPLACED SEAT TRACK PER SRM. (M)SDR ASAA0310161Seat Track · corrodedPAE - DURING C-CHECK, FOUND SEAT TRACK AT BS 663-727, BUTTOCK LINE 0 CORRODED. REMOVED AND REPLACED SEAT TRACK PER SRM. (M)SDR ASAA0310162Seat Track · corrodedDURING C-CHECK, FOUND SEAT TRACK AT BS 663-727A, LT BUTTOCK LINE 25 CORRODED. REMOVED AND REPLACED SEAT TRACK IAW SRM. (M)SDR ASAA0310167Seat Track · corrodedPAE - DURING C-CHECK, FOUND SEAT TRACK AT BS 697-616, LT BUTTOCK LINE 45, RT BUTTOCK LINE 45 CORRODED. REMOVED AND REPLACED SEAT TRACK PER SRM. (M)SDR GTIA030236Seat Track · gougedFTW - FOUND LEFT INBOARD SEAT TRACK BETWEEN G-4 GALLEY SEAT 33 STATION 1212 TO 1309 NUMEROUS NICKS, GOUGES, BARE METAL AND CORROSION. SEAT TRACK FOUND OUT OF LIMITS AT STATION 1277 AND 1280. CUT OUT SEAT TRACK FROM STATION 1261-1297. FABRICATED NEW SEAT TRASDR UPS03M40439Seat Track · corrodedINSPECTION TYPE:C SEAT TRACK AT RBL 8.5 BETWEEN STA 784-939 FOUND CORRODED. CORROSION REMOVED AT SEAT TRACK RBL 8.5 STA 784-939 & FOUND EXCEED LIMIT AS PER SRM 51-21-01 VOL II REV 32 & 53-70-00 VOL I REV 32. NEW SEAT TRACK REWORKED AND HOLES PICK UP AS PER SSDR UPS03M40437Seat Track · corrodedINSPECTION TYPE:C SEAT TRACK AT LBL 8.5 BETWEEN STA 791-840 FOUND CORRODED. CORROSION REMOVED AT STA 791-840 LBL 8.5 & FOUND EXCEED LIMIT AS PER SRM 51-21-01 VOL II REV 32 & 53-70-00 VOL I REV 32. NEW SEAT TRACK REWORKED AND HOLES PICKED OUT AS PER AS PER SRSDR UPS03M40436Seat Track · corrodedINSPECTION TYPE:C SEAT TRACK AT RBL 27.5 BETWEEN STA 791-840 FOUND CORRODED. CORROSION REMOVED AT SEAT TRACK RBL 27.5 STA 791-840 FOUND EXCEED LIMIT AS PER SRM 51-21-01 VOL II REV 32 & 53-70-00 VOL I REV 32. NEW SEAT TRACK & SPLICE REWORKED AS PER SRM 53-70-
Back to JASC 5347