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 MWEA99904Tiedown Rail · corrodedLEFT CARGO TIE DOWN RAIL WAS CORRODED FROM STATION 396 TO 510 AND FROM STATION 510 AFT. MAINTENANCE FITTED AND INSTALLED NEW TIE DOWN RAIL.SDR MWEA99903Tiedown Rail · corrodedRIGHT CARGO TIE DOWN RAIL WAS CORRODED FROM STATION 218 TO 248 IN FORWARD CARGO BIN. MAINTENANCE FITTED AND INSTALLED NEW TIE DOWN RAIL.SDR QXEA9902689Seat Track · chafedPDX - LEFT INBOARD SEAT TRACK CHAFFED AND LUG LIP WORN AT STATION 300. REPAIRED IAW DHC-8 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA9902688Seat Track · chafedPDX - LEFT INBOARD SEAT TRACK CHAFFED IN BOTTOM OF TRACK APPROXIMATELY AT STATION 330. REPAIRED IAW DHC-8 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA9902686Seat Track · gougedPDX - SMALL GOUGE IN BOTTOM OF LEFT INBOARD SEAT TRACK, APPROXIMATELY STATION 377. REPAIRED IAW DHC-8 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA9902664Seat Track · chafedPDX - LEFT OUTBOARD SEAT TRACK HAS CHAFING PITS ON INBOARD LIP APPROXIMATELY STATION 242. REPAIRED IAW DHC-8 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA9902630Seat Track · corrodedYXX - CORROSION FOUND ON RIGHT INBOARD SEAT TRACK AT X598.0 AT TIE DOWN IN BAGGAGE AREA. REPAIRED IAW RD8-53-4697.SDR SCNA99778Seat Track · corrodedDURING A HEAVY MAINTENANCE CHECK, THE RIGHT FORWARD GALLEY INBOARD SEAT TRACK TIE DOWNS WERE FOUND TO BE CORRODED OUT OF LIMITS. FABRICATED NEW SEAT TRACK FROM STA 1070 TO STA 1110. TREATED, PRIMED AND INSTALLED NEW SEAT TRACK PER SRM 51302 AND 51202.SDR QXEA9902693Seat Track · corrodedPDX - LIGHT SURFACE CORROSION ON RIVET HEADS AND WEB PLATE FROM RIGHT-HAND OUTBOARD SEAT TRACK TO STRINGER 23, BETWEEN FRAMES 387.350 AND 405.737. REPAIRED IAW DHC-8 SRM 51-40-11.SDR SCNA99777Seat Track · corrodedDURING A HEAVY MAINTENANCE CHECK THE LEFT AFT GALLEY OUTBOARD SEAT TRACK TIE DOWNS WERE FOUND TO BE CORRODED OUT OF LIMITS. FABRICATED NEW SEAT TRACK FROM STA 1070 TO STA 1110. TREATED, PRIMED AND INSTALLED NEW SEAT TRACK PER SRM 51302 AND 51202.SDR QXEA9902659Seat Track · corrodedPDX - MINOR CORROSION ON RIGHT-HAND OUTBOARD SEAT TRACK AT STATION 456. REPAIRED IAW DHC-8 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA9902658Seat Track · corrodedPDX - MINOR CORROSION ON RIGHT-HAND OUTBOARD SEAT TRACK AT STATION 471. REPAIRED IAW DHC-8 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA9902657Seat Track · corrodedPDX - MINOR CORROSION ON RIGHT-HAND OUTBOARD SEAT TRACK AT STATION 531. REPAIRED IAW DHC-8 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA9902656Seat Track · corrodedPDX - PITTING CORROSION AND NICKS ON RIGHT-HAND OUTBOARD SEAT TRACK AT STATION 540-543. REPAIRED IAW DHC-8 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA9902650Seat Track · corrodedPDX - LEFT-HAND OUTBOARD SEAT TRACK HAD LIGHT CORROSION INSIDE CHANNEL AT STATION 488.500. REPAIRED IAW DHC-8 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA9902649Seat Track · corrodedPDX - LEFT-HAND OUTBOARD SEAT TRACK HAD LIGHT CORROSION INSIDE CHANNEL 4 AFT OF STATION 467.00. REPAIRED IAW DHC-8 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA9902648Seat Track · corrodedPDX - LEFT-HAND OUTBOARD SEAT TRACK HAD LIGHT CORROSION INSIDE CHANNEL BETWEEN STRINGER 467.000 AND 445.500, LESS THAN 1 INCH LONG. REPAIRED IAW DHC-8 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA9902647Seat Track · corrodedPDX - LEFT-HAND OUTBOARD SEAT TRACK HAD LIGHT CORROSION INSIDE CHANNEL AT STATION 405.737. REPAIRED IAW DHC-8 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA9902640Seat Track · chafedPDX - RIGHT-HAND INBOARD SEAT TRACK CHAFED AND NICKED AT APPROXIMATELY STATION 456. REPAIRED IAW DHC-8 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA9902605Seat Track · chafedPDX - RIGHT-HAND INBOARD SEAT TRACK CHAFED IN BOTTOM OF TRACK APPROXIMATELY 10 FROM STATION 436. REPAIRED IAW DHC08 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA9902604Seat Track · chafedPDX - RIGHT-HAND INBOARD SEAT TRACK CHAFED AND NICKED AT APPROXIMATELY STATION 456. REPAIRED IAW DHC-8 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA9902603Seat Track · chafedPDX - RIGHT-HAND INBOARD SEAT TRACK CHAFED FROM APPROXIMATELY STATION 500 TO 520. REPAIRED IAW DHC-8 SRM 51-20-36 AND SRM 51-20-16.SDR QXEA9902602Seat Track · chafedPDX - LEFT-HAND INBOARD SEAT TRACK CHAFED AT APPROXIMATELY STATION 500 TO 520 AND 545. REPAIRED IAW DHC-8 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA9902601Seat Track · chafedPDX - LEFT-HAND INBOARD SEAT TRACK CHAFED AT STATION 488 AND LUG LIP WORN. REPAIRED IAW DHC-8 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA9902600Seat Track · chafedPDX - LEFT-HAND INBOARD SEAT TRACK CHAFED AT APPROXIMATELY STATION 445, 456 AND 470. REPAIRED IAW DHC-8 SRM 51-20-16 AND 51-21-36.SDR 2000ZZZM89Seat Track · corrodedRIGHT AFT INBOARD SEAT TRACK HAS CORROSION AROUND HI-LOK HOLES AT FLOORBEAM NR 36. BLENDED CORROSION IAW ATR-72 SRM 51-21-42. COMPLIED WITH EO NR E9-5300-013 R4, PART 'B' WAS SATISFACTORILY ACCOMPLISHED. (M)SDR 2000ZZZM62Seat Track · corrodedLEFT AFT INBOARD SEAT TRACK HAS CORROSION AREAS FROM FLOORBEAM 34 TO 36. BLENDED CORROSION IAW ATR-72 SRM 51-21-42. COMPLIED WITH EO NR E9-5300-013 R4, PART 'B' WAS SATISFACTORY ACCOMPLISHED. (M)SDR 2000ZZZM60Seat Track · corrodedLEFT AFT OUTBOARD SEAT TRACK HAS CORROSION BETWEEN FLOORBEAMS 34 TO 36. BLENDED CORRODED AREAS IAW ATR-72 SRM 51-21-42. REMOVED AND INSTALLED NEW LEFT OUTBOARD SEAT TRACK IAW ATR-72 SRM 51-25-04. (M)SDR 2000ZZZM53Seat Track · corrodedCORROSION AROUND SCREW HOLES TO SEAT TRACK. BLENDED OUT CORROSION TO SEAT TRACK IAW ATR72 SRM 51-21-42. EO NR E9-5300-015 R7 PART 'B' WAS SATISFACTORILY ACCOMPLISHED. (M)SDR USAA991346Seat Track · corrodedCLT - DURING C-1 CHECK VISUAL INSPECTION, FOUND SEAT TRACK CORROSION AT STATION 377.0 AND LBL 24. CORROSION LEVEL 1. INSTALLED NEW SEAT TRACK PER SRM 53-00-52. (M)SDR USAA991345Seat Track · corrodedCLT - DURING C-1 CHECK VISUAL INSPECTION, FOUND SEAT TRACK CORROSION AT STATION 377 AND LBL 47. CORROSION LEVEL 1. INSTALLED NEW SEAT TRACK PER SRM 51-10-00. (M)SDR UPS99231204Seat Track · corrodedINSPECTION TYPE:SI, CORROSION AT FWD CARGO BAY SEAT TRACK BS 538 RBL 14 WL 148.5. REMOVED AND REPLACED SEAT TRACK BS STA 480-588, RLB 14 PER SRM 53-10-5.SDR AWXA9900474Seat Track · damagedSEAT TRACK STA 520-634 WENT OUT OF LIMITS LBL 45. REMOVED DAMAGED SEAT TRACK PER SRM 51-40-02. FABRICATED AND INSTALLED REPLACEMENT PER SRM 53-00-52 MAT'L BAC 1520841 7178T6511 QQA-200/13C R65996, TREATED AND PRIMED.SDR AWXA9900471Seat Track · corrodedSEAT TRACK OUT OF LIMITS AND CRACKED STA 328-480 RBL 45.5. REMOVED AND REPLACED SEAT TRACK PER SRM 53-00-52. TREATED AND PRIMED PER S1-20-01.SDR 20000511AP011Seat Track · corrodedFOUND CABIN SEAT TRACK STATION 360 TO 440 RBL 48 HAS CORROSION. REMOVED CORROSION IAW 51-10-6 PAGE 12 FOUND OUT OF LIMITS IAW 51-10-1 PAGE 15. FABRICATED NEW SEAT TRACK IAW 53-10-5 PAGE 21. TREATED, PRIMED AND INSTALLED SEAT TRACK IAW 53-10-5 PAGE 21. (M)SDR 20000511AP010Seat Track · corrodedFOUND CABIN TRACK STATION 360 TO 420 RBL 24 HAS CORROSION. REMOVED CORROSION IAW 51-10-6 PAGE 2 FOUND OUT OF LIMITS. FABRICATES SEAT TRACK IAW 51-10-1. TREATED AND PRIMED IAW 51-10-2 PAGE 1. INSTALLED TRACK IAW 51-30-2. (M)SDR 20000511AP009Seat Track · corrodedCABIN FLOORBEAM STATION 320 LBL 46 HAS CORROSION AT ANCHOR NOT. REMOVED CORROSION IAW 51-10-6 PAGE 12. ACCOMPLISHED UT THICKNESS CHECK FOUND OUT OF LIMITS. CUT OUT DAMAGED AREA IAW 53-10-8 PAGE 49. FABRICATED ANGLES AND SPLICE, INSTALLED, TREATED IAW 53-10SDR 20000511AP008Seat Track · corrodedFOUND CABIN SEAT TRACK LBL 44 STATION 1110 TO 1070 HAS CORROSION. REMOVED CORROSION FOUND OUT OF LIMITS IAW 51-10-6 PAGE 6. REMVOED SEAT TRACK IAW 51-30-2 PAGE 5. FABRICATED SEAT TRACK IAW 53-10-5 PAGE 4. TREATED AND PRIMED IAW 51-10-2 PAGE 6. INSTALLED TSDR 20000511AP007Seat Track · corrodedFOUND CABIN SEAT TRACK STATION 1070 LBL 50 HAS CORROSION. REMOVED CORROSION FOUND OUT OF LIMITS IAW 51-30-2 PAGE 2. REMOVED HAT CHANNEL STATION 1070 LBL 50 IAW 51-30-2 PAGE 2. FABRICATED HAT CHANNEL IAW 51-10-1 PAGE 2. TREATED INSTALLED HAT CHANNEL IAW 51-1SDR 20000511AP004Seat Track · corrodedCABIN SEAT TRACK STATION 344 TO 400 LBL 44 HAS CORROSION. REMOVED CORROSION FOUND OUT OF LIMITS IAW 53-10-1 FIG 3. FABRICATED SEAT TRACK IAW 51-30-5 PAGE 1. TREATED INSTALLED IAW 51-10-2 PAGE 1 AND 51-30-2. (M)SDR 20000511AP003Seat Track · crackedCABIN SEAT TRACK STATION 344-400 LBL 24 HAS CORROSION. REMOVED CORROSION AND FOUND SEAT TRACK OUT OF LIMITS IAW 51-10-6 PAGE 12. FABRICATED NEW SEAT TRACK STATION 344-400 LBL 24 IAW 53-10-5 PAGE 4. TREATED AND PRIMED IAW 51-10-2 PAGE 2-4. INSTALLED SEAT TRSDR CALA9901579Seat Track · corrodedINSPECTION FOUND RT O/B SEAT TRACK CORRODED AT STA 218-256. THE CORRODED SECTION OF SEAT TRACK WAS REPLACED IAW SRM 53-05, FIGURE 4F.SDR 2000ZZZM80Seat Track · corrodedRIGHT AFT FLIGHT ATTENDANT SEAT TRACK IS CORRODED AROUND THE NUTPLATES. BLENDED OUT CORROSION FOUND TO BE OUT OF LIMITS. REMOVED AND REPLACED SUPPORT IAW EO NR E9-5300-013 R4. (M)SDR 2000ZZZM78Seat Track · corrodedLEFT AFT OUTBOARD SEAT TRACK HAS CORROSION IN TRACK (.025 INCH) TO T-5 AREA. BLENDED OUT CORROSION FOUND TO BE BEYOND LIMITS. REMOVED AND REPLACED SEAT TRACK IAW EO NR E9-5300-013 R4. (M)SDR 2000ZZZM77Seat Track · corrodedLEFT MID OUTBOARD SEAT TRACK HAS CORROSION AT FRAME 28D BLENDED OUT CORROSION FOUND TO BE BEYOND LIMITS AT ATTACHMENT POINT. REMOVED AND REPLACED SEAT TRACK IAW EO NR E9-5300-013 R4. (M)SDR 2000ZZZM76Seat Track · corrodedLEFT MID INBOARD SEAT TRACK HAS CORROSION FROM FRAME 24 TO 29 BLENDED OUT CORROSION FOUND TO BE BEYOND LIMIT .028 INCH. REMOVED AND REPLACED SEAT TRACK IAW EO NR E9-5300-013 R4. (M)SDR 2000ZZZM75Seat Track · corrodedRIGHT MID INBOARD SEAT TRACK HAS CORROSION FROM FRAME 24 TO 29, (.27 INCH ON T-5 AREA). BLENDED OUT CORROSION FOUND TO BE BEYOND LIMIT OF .033 INCH. REMOVED AND REPLACED SEAT TRACK IAW EO NR E9-5300-013 R4. (M)SDR 2000ZZZM28Seat Track · corrodedLEFT AFT INBOARD SEAT TRACK HAS CORROSION. BLENDED OUT AND FOUND TO BE OUT OF LIMITS. REMOVED AND INSTALLED LEFT AFT INBOARD SEAT TRACK IAW EO NR E9-5300-013 R4. (M)SDR CALA9901570Seat Track · corrodedINSPECTION FOUND SEAT TRACK CORRODED AT STA 1136-1117, LBL 56. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 51-30-1.SDR CALA9901564Seat Track · corrodedINSPECTION FOUND LT I/B SEAT TRACK CORRODED AT STA 1079-1309. A NEW SEAT TRACK WAS INSTALLED IAW SRM 51-30-1.
Back to JASC 5347