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 QXEA9901300Seat Track · corrodedPDX - LEFT OUTBOARD SEAT TRACK HAS CORROSION 4 AFT OF FRAME 7305 ON INBOARD AND OUTBOARD FLANGES. REPAIRED IAW FOKKER SRM 51-10-04, PAGE 8, PARAGRAPH 3, C4.SDR QXEA9901135Seat Track · damagedPDX - RIGHT INBOARD SEAT TRACK HAS TOOLING DAMAGE 4 FORWARD OF FRAME 6305. REPAIRED IAW FOKKER SRM 51-10-04, PAGE 8, PARAGRAPH 3,C,4.SDR QXEA9901133Seat Track · corrodedPDX - RIGHT INBOARD SEAT TRACK HAS CORROSION 9 AFT OF FRAME 9805. REPAIRED IAW FOKKER SRM 51-10-04, PAGE 8, PARAGRAPH 3,C,4.SDR QXEA9901132Seat Track · corrodedPDX - RIGHT INBOARD SEAT TRACK HAS FRETTING CORROSION IN 3 SMALL AREAS JUST FORWARD OF FRAME 9305C. REPAIRED IAW FOKKER SRM 51-10-04, PAGE 8, PARAGRAPH 3,C,4.SDR QXEA9901127Seat Track · corrodedPDX - RIGHT INBOARD SEAT TRACK HAS A SMALL AREA OF FRETTING CORROSION ON INBOARD FLANGE 8 FORWARD OF FRAME 7805. REPAIRED IAW FOKKER SRM 51-10-04, PAGE 8, PARAGRAPH 3,C,4.SDR QXEA9901125Seat Track · corrodedPDX - RIGHT INBOARD SEAT TRACK HAS A SMALL TOOLING DAMAGE 4 AFT OF FRAME 11905. REPAIRED IAW FOKKER SRM 51-10-04, PAGE 8, PARAGRAPH 3,C,4.SDR QXEA9901123Seat Track · corrodedPDX - LEFT INBOARD SEAT TRACK HAS FRETTING CORROSION ON OUTBOARD FLANGE EXTENDING 3 AFT TO 8 AFT OF FRAME 7805. REPAIRED IAW FOKKER SRM 51-10-04, PAGE 8, PARAGRAPH 3,C,4.SDR QXEA9901122Seat Track · corrodedPDX - LEFT INBOARD SEAT TRACK HAS CORROSION ON OUTBOARD FLANGE 2 FORWARD AND 2 AFT OF FRAME 8305. REPAIRED IAW FOKKER SRM 51-10-04, PAGE 8, PARAGRAPH 3,C,4.SDR QXEA9901121Seat Track · corrodedPDX - LEFT INBOARD SEAT TRACK HAS CORROSION ON INBOARD FLANGE AT FRAME 9305B AND EXTENDING 6 FORWARD OF 9305B. REPAIRED IAW FOKKER SRM 51-10-04, PAGE 8, PARAGRAPH 3,C,4.SDR QXEA9901114Seat Track · corrodedPDX - LEFT OUTBOARD SEAT TRACK HAS FRETTING CORROSION ADJACENT TO FRAME 9305B ON INBOARD FLANGE AND AROUND CAMLOC RECEPTACLE. REPAIRED IAW FOKKER SRM 51-10-04, PAGE 8, PARAGRAPH 3,C,4.SDR CALA9900569Seat Track · corrodedINSPECTION FOUND RT INBOARD SEAT TRACK CORRODED AT STA 218 TO 256. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 51-30.SDR USAA990482Seat Track · corrodedCLT - DURING C-4 CHECK, FOUND 1.5 INCH CORROSION ON ENDS OF SEAT TRACK AT STATION 377 AT LBBL 25 AND 45, CORROSION LEVEL 2. REPLACED SEAT TRACK SECTIONS PER SRM 51-10-00. (M)SDR USAA990481Seat Tracks · corrodedCLT - DURING C-4 CHECK, FOUND 2 INCH CORROSION ON ENDS OF SEAT TRACK AT STATION 377 AT LBBL 25 AND LBBL 45, CORROSION LEVEL 2. REPLACED SEAT TRACK SECTIONS PER SRM 51-10-00. (M)SDR QXEA9901299Seat Track · damagedPDX - LEFT OUTBOARD SEAT TRACK HAS 3 SMALL NICKS AND GOUGES BETWEEN FRAMES 14755 AND 15205. REPAIRED IAW FOKKER SRM 51-10-04, PAGE 8, PARAGRAPH 3C.SDR QXEA9901129Seat Track · corrodedPDX - RIGHT INBOARD SEAT TRACK HAS CORROSION 2 FORWARD OF FRAME 9305. REPAIRED IAW FOKKER SRM 51-10-04, PAGE 8, PARAGRAPH 3,C,4.SDR QXEA9901119Seat Track · corrodedPDX - LEFT INBOARD SEAT TRACK HAS FRETTING CORROSION ON INBOARD FLANGE ADJACENT TO FRAME 9305C. REPAIRED IAW FOKKER SRM 51-10-04, PAGE 8, PARAGRAPH 3, C, 4.SDR QXEA9901116Seat Track · corrodedPDX - LEFT INBOARD SEAT TRACK HAS FRETTING CORROSION AROUND CAMLOC RECEPTACLE 2 FORWARD OF FRAME 11905. REPAIRED IAW FOKKER SRM 51-10-04, PAGE 8, PARAGRAPH 3,C,4.SDR QXEA9901115Seat Track · damagedPDX - LEFT INBOARD SEAT TRACK HAS SMALL NICKS AND LIGHT CHAFE DAMAGE 4 AFT OF FRAME 11905. REPAIRED IAW FOKKER SRM 51-10-04, PAGE 8, PARAGRAPH 3,C,4.SDR QXEA9901113Seat Track · damagedPDX - LEFT OUTBOARD SEAT TRACK HAS A GOUGE 9 FORWARD OF FRAME 10346. REPAIRED IAW FOKKER SRM 51-10-04, PAGE 8, PARAGRAPH 3C4.SDR CALA9900567Seat Track · corrodedINSPECTION FOUND RT CENTER SEAT TRACK CORRODED AT STA 218-237. A NEW SECTION OF SEAT TRACK WAS SPLICED IN IAW SRM 53-05, FIGURE 4F.SDR CALA9900563Seat Track · corrodedINSPECTION FOUND LEFT OUTBOARD SEAT TRACK CORRODED AT STA 1136-1128. THE SEAT TRACK WAS REPLACED IAW SRM 51-30-2.SDR CALA9900561Seat Track · corrodedINSPECTION FOUND LEFT INBOARD SEAT TRACK CORRODED AT STA 1212-1222. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 51-30-01.SDR ASAA9910123Seat Track · gougedPHX - DURING D-CHECK, FOUND THE MAIN CABIN SEAT TRACK GOUGED BS 864.5, LBL 45.5. REPAIRED PER SRM 53-10-5, FIG 8. (M)SDR ASAA9910122Seat Track · corrodedPHX - DURING D-CHECK, FOUND THE MAIN CABIN SEAT TRACK CORRODED ON TOP AND BOTTOM SIDES, BS 727B-747, BL 0. REPAIRED PER SRM 53-10-1. (M)SDR ASAA9910119Seat Track · corrodedPHX - DURING D-CHECK, FOUND THE MAIN CABIN SEAT TRACK CORRODED AT BS 540, LBL65. REPAIRED PER SRM 53-10-5, FIG 7. (X)SDR ASAA9910116Seat Track · corrodedPHX - DURING D-CHECK, FOUND THE PASSENGER CABIN SEAT TRACK CORRODED ON TOP AND BOTTOM SIDES AT BS 727A TO BS 727B, RBL 62.5. REPAIRED PER SRM 53-10-5, FIG 7. (X)SDR SIMA991383Seat Track · corrodedSAW - DURING MBV-1 INSPECTION, FOUND LEFT FORWARD INBOARD AND OUTBOARD, LEFT MIDDLE INBOARD AND OUTBOARD, LEFT AFT INBOARD AND OUTBOARD, LEFT AND RIGHT FLIGHT ATTENDANT, RIGHT FORWARD AND RIGHT MIDDLE OUTBOARD, AND THE RIGHT AFT AND RIGHT MIDDLE INBOARD SEAT TSDR RRXA991568Seat Track · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION, FUSELAGE, TO MAIN DECK SEAT TRACK BETWEEN STA 480 AND STA 540 AT BL 24 RIGHT. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED NEW SEAT TRACK IAW DC8SDR RRXA991566Seat Track · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION, FUSELAGE, TO MAIN DECK SEAT TRACK AT STA 310 AND BL 24 RIGHT. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED NEW SEAT TRACK IAW DC8 SRM 53-1-0. (CSDR EISA99113Seat Track · corrodedDURING ACCOMPLISHMENT OF ROUTINE C-CHECK WORKCARD, FOUND CORROSION ON NR 1 SEAT TRACK AT FS 620. REMOVED SECTION TO TRACK FROM FS 620 TO 66O AND REPLACED WITH NEW SECTION OF TRACK PER SRM 53-10-5. (M)SDR EISA99110Seat Track · corrodedDURING ACCOMPLISHMENT OF ROUTINE C-CHECK WORKCARD, FOUND CORROSION OF SEAT TRACK AT FS 620 TO 720 LBL 24. REMOVED DAMAGE TRACK SECTION FROM FS 620 TO 720 AND REPLACED WITH NEW SECTION PER SRM 53-10-5. (M)SDR MALA976473Seat Track · corrodedDURING C-CHECK INSPECTION, SEAT TRACK CORROSION. SEAT TRACK WEB AND FLANGES AT BL 0 RIGHT I/B FROM STA 297.5 TO STA 564.0 HAS CORROSION AND PITTING. MAINTENANCE BLENDED OUT CORROSION AND PITTING IAW SRM 51-70-40 AND IAW SAAB DOC NR 72SDS1546. FABRICATED REISDR RRXA991604Seat Track · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION, FUSELAGE, AFT LWR CARGO COMPT BETWEEN STA 1240 AND STA 1320, AT LONGERON 36 FLOOR TRACK. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED NEW SECTIONSDR MALA976474Seat Track · corrodedDURING C-CHECK INSPECTION, SEAT TRACK WEB AND FLANGES AT BL 18.3 LEFT I/B FROM STA 297.5 TO STA 525.0 HAS CORROSION AND PITTING. MAINTENANCE BLENDED OUT CORROSION AND PITTING IAW SRM 51-70-40 AND IAW SAAB DOC NR 72SDS1546 REV A, FABRICATED REINFORCEMENT ANGLESDR RAAA99E4047Seat Track · corrodedDURING SCHEDULED NR 1 CHECK, FOUND CORROSION ON SEAT TRACK AT FS 374-445, RBL 41. REPLACED SEAT TRACK AS PER ECO 99-05, M-54 NR 173.SDR RAAA99E4046Seat Track · corrodedDURING SCHEDULED NR 1 CHECK, FOUND CORROSION ON SEAT TRACK FLANGE AT FS 236-430 RBL 21 SEVERAL SPOTS. REPLACED SEAT TRACK AS PER ECO 99-05, M-54 NR 172.SDR RAAA99E4044Seat Track · corrodedDURING SCHEDULED NR 1 CHECK, FOUND CORROSION ON SEAT TRACK FLANGE AT FS 844-863 BBL 0. REPLACED SEAT TRACK AS PER ECO 99-05, M-54 NR 167.SDR QXEA9901063Seat Track · corrodedPDX - RIGHT HAND SEAT TRACK EXTENSION IN BAGGAGE FLOOR HAS CORROSION WHERE O-RINGS MOUNT AT STATION 545 AND STATION 600. REPAIRED IAW DASH 8 RD 8-53-784.SDR UPS99829613Seat Track · corrodedINSPECTION TYPE:C3, FS 1300, 1310, 1320 AND 1340, RBL 45 THE SEAT TRACK HAS HEAVY CORROSION. CUT OUT DAMAGED SECTION, FABRICATED AND REPLACED SEAT TRACK IAW SRM 53-2-3.SDR UF6A990542Seat Track · corrodedSBN - REAR SEAT TRACK ON LEFT AND RIGHT SIDE HAS CORROSION IN GALLEY AREA, APPROXIMATELY STATION 252AS. MAINTENANCE REMOVED AND REPLACED CORRODED SEAT TRACK ON BOTH THE LEFT AND RIGHT SIDE. ALL WORK WAS DONE IAW BAE ATP SRM 53-10-13. (M)SDR RAAA99E4043Seat Track · damagedDURING SCHEDULED NR 1 CHECK, FOUND SEAT TRACK LOCK LUGS DAMAGED AT FS 891 TO 966 RBL 17. REPLACED SEAT TRACK AS PER ECO 99-05 M-54 NR 160.SDR RAAA99E4042Seat Track · damagedDURING SCHEDULED #1 CHECK, FOUND SEAT TRACK LUGS DAMAGED @ FUS/STA 939-1000 LBL 54. REPLACED SEAT TRACK AS PER ECO 99-05, M-54 # 159.SDR RAAA99E4041Seat Track · damagedDURING SCHEDULED NR 1 CHECK, FOUND SEAT TRACK LOCK LUGS AT FS 930-1000 LBL 24 DAMAGED. REPLACED SEAT TRACK AS PER ECO 99-05, M-54 NR 158.SDR RAAA99E4040Seat Track · damagedDURING SCHEDULED NR 1 CHECK, FOUND SEAT TRACK LUGS DAMAGED AT BBL 0, FS 856. REPLACED SEAT TRACK AS PER ECO 99-05, M-54 NR 157.SDR RAAA99E4037Seat Track · corrodedDURING SCHEDULED NR 1 CHECK, FOUND CORROSION ON SEAT TRACK AT FS 806-844, LBL 26. REPLACED SEAT TRACK AS PER ECO 99-05, M-54 NR 151.SDR RAAA99E4036Seat Track · corrodedDURING SCHEDULED NR 1 CHECK, FOUND CORROSION ON SEAT TRACK AT FS 787-837 LBL 56. REPLACED SEAT TRACK AS PER ECO 99-05, M-54 NR 150.SDR QXEA9901064Seat Track · corrodedPDX - LEFT-HAND SEAT TRACK EXTENSION IN BAGGAGE FLOOR HAS CORROSION WHERE O-RINGS MOUNT AT STATION 545 AND STATION 600. REPAIRED IAW DASH RD 8-53-784.SDR QXEA9901061Seat Track · corrodedPDX - CORROSION ON INBOARD LEFT-HAND SEAT TRACK FORWARD OF STATION 240. REPAIRED IAW HORIZON AIR EA 2-53-26.SDR C2XA99IA269Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE AFT FLIGHT ATTENDANT SEAT TRACK WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED SEAT TRACK IAW ATR42-320 SRM 51-25-02, AND 51-21-42, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA99IA268Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE FORWARD FLIGHT ATTENDANT SEAT TRACK WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED SEAT TRACK IAW ATR42-320 SRM 51-25-02, AND 51-21-42, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)
Back to JASC 5347