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 95FDEA00070Seat Track · corrosionCORROSION (71C709-02) UNDER NUTPLATES FROM BS 1050-1070, STR 28R, RBL 15. REMOVED AND REPLACED SEAT TRACK BS 1130-1010, RBL 15, WL 148. ALL WORK DONE IAW SRM 53-10-5.SDR UPS202059Seat Track · corrodedDURING 'C' CHECK, MAINTENANCE FOUND CORROSION ON SEAT TRACK AT STA 780-820, RBL 45, WL 208. REPLACED SEAT TRACK PER SRM 51-30-02, 51-10-1.SDR UPS202058Seat Track · corrodedDURING 'C' CHECK, MAINTENANCE FOUND CORROSION ON SEAT TRACK AT STA 756-852, LBL 65. REPLACED SEAT TRACK PER SRM 51-30-02, 51-10-2, 51-20-4.SDR DL72S950474Seat Track · crackedFOUND ON CV2 CHECK TPAMM, LEFT INBD SEAT TRACK CRACKED STA 1033. REPAIRED PER SRM 53-10-5 FIG 7.SDR DL72S950473Seat Track · corrodedFOUND ON CV2 CHECK TPAMM, CORROSION ON SEATTRACK BS 380 RBL48. REPAIRED PER SRM 53-10-5 FIG 7.SDR USAA950118Seat Track · corrodedINT - DURING Q-6 CHECK VISUAL INSPECTION OF SEAT TRACK, FOUND .25 INCH BY .5 INCH GOUGE STA 887 LBL 25. REPAIRED PER SRM 53-00-52 FIG 204. CORROSION TASK NR C53-107-02. CORROSION LEVEL 2. (W)SDR MALA954261Seat Track · crackedMSP - DURING SCHEDULED INSPECTION, MAINTENANCE FOUND COPILOT'S SEAT TRACK ATTACHMENT NUT PLATES ON FS 107.060 CRACKED. REPAIRS WERE COMPLETED TO THE FRAME, PN 27-21052-035, IAW FAIRCHILD ARP 53-10-8913, REVISION A AND THE SRM. (X)SDR MALA954260Seat Track · crackedMSP - DURING A SCHEDULED INSPECTION, MAINTENANCE FOUND PILOT'S SEAT TRACK ATTACHMENT NUT PLATES ON FS 107.060 CRACKED. A REPAIR ANGLE DOUBLER WAS ATTACHED TO THE FRAME, PN 27-21052-035 IAW FAIRCHILD ARP 53-10-8913, REVISION A AND THE SRM (X)SDR C2XA95IA007Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, FOUND LEFT AFT SEAT TRACK CORRODED. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK, AIRCRAFT APPROVED FOR RETURN TO SERVICE. TOTAL CYCLES 15,473. (Z)SDR DL72S950470Seat Track · corrodedFOUND ON CV2 CHECK, CORROSION ON SEAT TRACK STA 344. REPAIRED PER SRM 53-10-5 FIG 7.SDR DL72S950469Seat Track · corrodedFOUND ON CV2 CHECK, CORROSION ON SEAT TRACK O/B RT STA 420-445, REPAIRED PER SRM 53-10-5 FIG 7.SDR DL72S950463Seat Track · corrodedFOUND ON CV2 CHECK, CORROSION SEVERAL PLACES ON RT I/B SEAT TRACK RBL 23 FROM STA 380 - 480, REPAIR. REPLACED SEAT TRACK SECTION FROM STA 380 TO 440 PER SRM 53-10-5 FIG 7.SDR DL72S950462Seat Track · corrodedFOUND ON CV2 CHECK, CORRROSION FOUND SEAT TRACK RBL 45 BETWEEN 1090 AND 1136 TOP AND BOTTOM SIDES, REPAIR. REPLACED SEAT TRACK FROM 1110 TO 1136 PER SRM 53-10-3 FIG 7.SDR DL72S950461Seat Track · corrodedFOUND ON CV2 CHECK, CORROSION FOUND SEAT TRACK LOCATED AT LBL 25 BETWEEN 1130 AND 1110, REPAIR. REPLACED SEAT TRACK SECTION PER SRM 53-10-5 FIG 3.SDR DL72S950459Seat Track · corrodedFOUND ON CV2 CHECK, CORROSION ON LEFT O/B SEAT TRACK BETWEEN STA 1030 AND 1050 BOTH SIDES OF TRACK, REPAIR. REPLACED SEAT TRACK SECTION PER CVSRM 53-10-5.SDR 9501429872Tie Down Track · corrodedDURING PERIODIC CHECK, FOUND CORROSION IN AFT CARGO TIE-DOWN TRACK FS 855-1030. REPLACED TRACK PER EA 98-93787.SDR UPS801957Tie Down Tracks · corrosionWHILE IN 'C' CHECK, MAINTENANCE FOUND HEAVY CORROSION ON LOWER CARGO TIE DOWN TRACKS AT FS 80-260, LBL 36 AND FS 360-450, RBL 36. INSTALLED REPAIR IAW SRM 51-3-0.SDR UPS201943Seat Track · corrosionWHILE IN C-CHECK MAINTENANCE, FOUND SEAT TRACK AT LBL 45 STA 740-760 CORRODED. INSTALLED REPAIR IAW SRM 51-10-01, 51-30-2, 51-10-02 AND MM 51-20-151.SDR UPS201939Seat Track · corrosionWHILE IN C-CHECK, MAINTENANCE FOUND CORROSION ON SEAT TRACK STA 756-852, LBL 45, WL 208. INSTALLED REPAIR IAW SRM 51-10-2.SDR UPS201937Seat Track · corrosionWHILE IN C-CHECK, MAINTENANCE FOUND SEAT TRACK HAS CORROSION AND PITTING STA 756-852, LB 25, WL 208. INSTALLED REPAIR IAW SRM 51-20-4 AND SRM 51-30-2.SDR 95ZZZX1516Floor Track · wornDURING C-CHECK, FOUND FLOOR TRACK WORN AFT COMP 3 BL 45.500 RIGHT 2 EA PLACES. CUT OUT DAMAGED TRACK. FABRICATED NEW TRACK SECTION IAW DER APPROVED COTNEY ENGINEERING SKETCH SKA 94190-10 AND INSTALLED IAW SRM 53-2-3.SDR 95ZZZW48Seat Track · corrodedDURING C-CHECK, THE NR 1 SEAT TRACK AT FS 1450-1570 HAS CORROSION. REPLACED SEAT TRACK PER DOUGLAS SRM CHAPTER 53. TOTAL CYCLES 24057.SDR 95ZZZW47Seat Track · corrodedDURING C-CHECK, THE NR 2 SEAT TRACK HAS CORROSION AT STA 14550. REPLACED SEAT TRACK PER DOUGLAS SRM CHAPTER 53. TOTAL CYCLES 24057.SDR USAA950120Seat Track · corrosionINT - DURING Q-6 CHECK VISUAL INSPECTION OF SEAT TRACK, FOUND TWO CORROSION AREAS 1.0 INCH BY 1.0 INCH AND .500 BY 1.0 INCH, BETWEEN FWD GALLEY BULKHEAD AND BS 294.5, 42.0 INCHES FROM BBL 0. REPAIRED PER BOEING DRAWING 69-40352-6. CORROSION TASK NR C53-107-0SDR 95FDEA00075Seat Track · corrodedSEAT TRACK CORRODED WL 208, LBL 25, STA 870-1070. REMOVED AND REPLACED NEW SEAT TRACK BS 870-1070, LBL 25, WL 208 IAW FEDEX 727 SRM 53-10-5.SDR DL733950119Seat Track · corrosionAT HMV, CORROSION WAS FOUND ON SEAT TRACK HORIZONTAL FLANGE AT STA 344 LBL 20. REMOVED OLD SECTION, FABRICATED NEW SEAT TRACK AND INSTALLED SEAT TRACK PER SRM53-00-52.SDR DLL16950298Seat Track · corrodedAT HMV, FOUND FS 1318 CENTER INBOARD SEAT TRACK CORRODED AT FS 1318 AVBOVE HYDTRAULIC SERVICE CENTER. REPLACED TRACK PER SRM 53-21-00.SDR DLL16950381Seat Track · corrodedDURING OVERHAUL THE SEAT TRACK THAT RUNS FROM FS 1665 FS 1745 AT RBL 22 WAS FOUND CORRODED. REPLACED SECTION OF TRACK PER SRM 53-21-00 PG 836.SDR USAA950059Seat Track · corrodedINT - DURING Q-4 CHECK VISUAL INSPECTION OF SEAT TRACKS, FOUND CORRODED AREA APPROXIMATELY 29.0 INCHES BY 1.25 INCHES, BS 328 - 10 INCHES AFT OF BS 359.96 APPROX 20 INCHES O/B OF BBL 0. REPAIRED PER SRM 53-00-52. CORRODED TASK NR C3-107-02. CORROSION LEVEL SDR USAA950058Seat Track · corrodedINT - DURING Q-4 CHECK VISUAL INSPECTION OF SEAT TRACK, FOUND THREE AREAS, 1 INCH BY .250 INCH, .500 INCH BY .250 INCH, 1 INCH BY 1.25 INCH CORRODED, FWD OF GALLEY SERVICE DOOR BS 270 TO BS 294.5 - 42.0 O/B OF BBL 0. REPAIRED PER SRM 51-10-2. CORROSION TASK SDR DL733950097Seat Track · corrosionAT HMV, CORROSION WAS FOUND ON SEAT TRACK UPPER SURFACES AT STA 960 ON THE OUTBOARD SIDE. REPAIRED PER SRM 53-00-52 FIG 204.SDR DL733950076Floor Track · corrosionAT HMV, CORROSION WAS FOUND ON GALLEY FLOOR TRACK AT FLOOR BEAM 328 RT SIDE ON THE FWD END OF INBOARD TRACK. REPAIRED PER SRM 53-00-52 PG 202-205.SDR DL733950075Floor Track · corrosionAT HMV, CORROSION WAS FOUND ON GALLEY FLOOR TRACK AT FLOOR BEAM STA 328 ON OUTBOARD TRACK RIGHT HAND SIDE AT FWD END. REPLACED SEAT TRACK PER SRM 51-00-00.SDR DL733950074Floor Track · corrosionAT HMV, CORROSION WAS FOUND ON GALLEY FLOOR TRACK AT FLOOR BEAM 328 ON RT SIDE AT CENTER FWD END. REPAIRED PER SRM 53-00-52 PG 202-205.SDR DL733950073Seat Track · corrodedAT HMV, FOUND CORROSION ON LEFT OUTBOARD SEAT TRACK AT FS 344. REPAIRED PER SRM 53-00-52 PG 202-205.
Back to JASC 5347