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 HALA0700397Seat Track · corrodedLEVEL 1 CORROSION ON SEAT TRACK RBL 11, AT STATION 714, 748, 763, 765, AND 778. REWORKED CORROSION, REWORKED AREAS FOUND WITHIN LIMITS, PER SRM 53-00-52. REWORKED AREAS ALODINED AND PAINTED.SDR HALA0700396Seat Track · corrodedLEVEL 1 CORROSION ON SEAT TRACK LBL 11, AT STATION 543, 566, 580, 600, 642, 715, AND 780. REWORKED CORROSION. CORROSION AREAS FOUND WITHIN LIMITS PER SRM 53-00-52. REWORKED AREAS ALODINED AND PAINTED.SDR 07FDEA03803Seat Track · corrodedHEAVY CORROSION ON SEAT TRACK BETWEEN FRAME 14-19, Y-450 RT. REPLACEMENT OF SEAT TRACK IAW SRM 51-72-10.SDR QXEA200701479Seat Track · damagedC5 PDX - LEFT INBOARD SEAT TRACK HAS WEAR DAMAGE, BOTTOM OF TRACK FRAME STATION X473 - X484/ Y9.2. REPAIRED IAW RD8-53-1339.SDR HALA0700416Seat Track · corrodedLEVEL 1 CORROSION ON SEAT TRACK RBL 88.5 NUMEROUS AREAS BETWEEN STA 1076 AND 1400. REPLACED SEAT TRACK.SDR USAA920070840Seat Track · corrodedPIT - MAJOR REPAIR - C-4 CHECK, CORROSION ON SEAT TRACK, BS 1620 - BS 1640, RBL 25. REPLACED SEAT TRACK, BS 1620 - BS 1640, RBL 25 IAW B757-200 SRM 51-40-02.SDR HALA0700388Seat Track · corrodedLEVEL 1 CORROSION ON SEAT TRACK RBL 11 STA 795, 842, 889, 903, 934, 953, 966, 980, 1016, 1044 AND 1062. REWORKED AREAS WITHIN LIMITS PER SRM 53-00-52. REWORKED AREAS PRIMED AND PAINTED.SDR UPS07850724Seat Track · corrodedINSPECTION TYPE:C1 2ND OBSERVERS AFT SEAT TRACK WORN, CORRODED. REMOVED AND REPLACED 2ND OBSERVERS AFT SEAT TRACK IAW SRM 51-03-00 AND SRM 51-01-24.SDR ASAA0782031Cargo Track · corrodedCARGO TRACK CORRODED. REPLACED TRACK PER SRM 51-30-02 AND 51-30-01.SDR ASAA0782030Cargo Track · corrodedRIGHTHAND CARGO TRACK CORRODED. REPLACED TRACK PER SRM 51-10-4 AND 51-30-01.SDR QXEA200701435Seat Track · corrodedC5 PDX - FLOORBOARD FLANGE TO SEAT TRACK GUSSET AT STATION 599.0 INBOARD OF LEFT INBOARD SEAT TRACK HAS CORROSION ON LOWER SURFACE AND ALONG EDGE ON FLANGE. REPAIRED IAW SRM 51-20-11, 51-20-16, 51-40-11.SDR QXEA200701434Seat Track · corrodedC5 PDX - FLOORBOARD NUT PLATE AND FLANGE ARE CORRODED AT STATION 599.0 INBOARD OF LEFT INBAORD SEAT TRACK. REPAIRED IAW SRM 51-40-11, 51-20-11, 51-20-36.SDR AWXA200701125Dummy Rail · corrodedSAL - MAJOR REPAIR - C-04 CHECK - NR 5975012, CORROSION ON CABIN DUMMY RAIL, BS 683/FR 15, -Y81. REPLACED CABIN DUMMY RAIL, BS 683/FR 15, -Y81 IAW A320 SRM 51-72-11.SDR AWXA200701116Dummy Rail · corrodedSAL - MAJOR REPAIR - C-4 CHECK - NR 5975014, CORROSION ON CABIN DUMMY RAIL, BS 709/FR 16, BS 732/FR 17, BS 808/FR 20, +Y254. REPLACED CABIN DUMMY RAIL, BS 605/FR 12 - BS 950/FR 20, +Y254 IAW A320 SRM 51-72-11.SDR AWXA200701115Dummy Rail · corrodedSAL - MAJOR REPAIR - C-4 CHECK - CORROSION ON CABIN DUMMY RAIL, BS 709/FR 16, -Y1379.5. REPLACED CABIN DUMMY RAIL, BS 709/FR 16, -Y1379.5 IAW A320 SRM 51-72-11.SDR F3LA200700230Bushing · corrodedDURING C-3 CHECK, INSPECTION REPORTED AFT LT FLT ATTENDANT SEAT (HOLD DOWN INSERTS) CORRODED IN MOUNTING HOLE AND EXTENDING INTO THE FLOORBEAM. REPLACED AFT LT FLT ATTENDANT SEAT FLOOR MOUNT BUSHINGS IAW AMM 25-22-42-400-001.SDR 07FDEA03599Seat Track · corrodedHEAVY CORROSION AT SEAT TRACK BETWEEN FRAME 14-19, STRG 26 RHS, OUT OF LIMIT. REPLACEMENT OF SEAT TRACK IAW SRM 51-72-10.SDR 07FDEA03598Seat Track · corrodedHEAVY CORROSION AT SEAT TRACK BETWEEN FRAME 15A-19, STRG 26 RHS, OUT OF LIMIT. REPLACEMENT OF SEAT TRACK IAW SRM 51-72-10.SDR KCSA071369Seat Track · crackedCAPTAINS I/B AFT SEAT TRACK HAS A 1.5 INCH CRACK IN WEB.SDR KCSA071368Seat Track · crackedCO-PILOT AFT I/B SEAT TRACK HAS A 1.5 INCH CRACK IN FWD END.SDR KCSA071367Seat Track · crackedCAPTAINS AFT O/B SEAT TRACK HAS A 1.5 INCH CRACK FWD END.SDR KCSA071366Seat Track · crackedCAPTAINS FWD O/B SEAT TRACK HAS 1.5 INCH CRACK IN FWD END.SDR KCSA071365Seat Track · crackedCO-PILOT FWD I/B SEAT TRACK HAS A 3 INCH CRACK IN FWD CORNER.SDR AWXA200701119Seat Track · corrodedSAL - MAJOR REPAIR - C-4 CHECK - NR 5975579, CORROSION ON CABIN SEAT TRACK, BS 808/FR 20, BS 843/FR 21 AND BS 897/FR 23, -Y765. REPLACED CABIN SEAT TRACK, BS 808/FR 20 - BS 897/FR 23, -Y1292 IAW A320 SRM 51-72-11.SDR AWXA200701118Seat Track · corrodedSAL - MAJOR REPAIR - C-4 CHECK - NR 5975580, CORROSION ON CABIN SEAT TRACK, BS 808/FR 20, BS 843/FR 21 AND BS 897/FR 23, -Y1292. REPLACED CABIN SEAT TRACK, BS 605/FR 12 - BS 950/FR 24, -Y1292 IAW A320 SRM 51-72-11.SDR 07FDEA03531Seat Track · corrodedFOUND SEAT TRACK C15A-19, Y-953 HEAVY CORRODED. REPAIR PERFORMED BY REPLACEMENT OF PART IAW SRM 51-72-10.SDR 07FDEA03529Seat Track · corrodedSEAT TRACK C15A-19, Y-1552 HEAVY CORRODED. REPAIR PERFORMED BY REPLACEMENT OF PART IAW SRM 51-72-10.SDR 07FDEA03526Seat Track · corrodedFOUND SEAT TRACK C15-19 Y-1959 HEAVY CORRODED. REPAIR PERFORMED BY REPLACEMENT OF PART IAW SRM 51-72-10.SDR 07FDEA03518Seat Track · corrodedCORROSION FOUND AT SEATTRACK C15A0-19, Y 1959 REPAIR PERFORMED BY REPLACEMENT OF PART IAW SRM 51-72-10.SDR COMA0770048Seat Track · corrodedLEFT AND RIGHT SEAT TRACKS ARE CORRODED FROM FS 500.00 TO FS 785. REMOVED THE CORROSION BY BLENDING IAW REO 670-53-00-013.SDR SIMA200725606Seat Track · corrodedDURING A HMBV INSPECTION, CORROSION WAS FOUND ON BL 36 LT. REPLACED THE SEAT TRACK USING PART NUMBER 7253742-407 IAW SAAB SRM 53-70-60 PARA 3. AIRCRAFT RETURED TO SERVICE.SDR KCSA071337Seat Track · crackedSTA-1330 LBL-11 SEAT TRACK LOWER RADIUS HAS A 6 INCH CRACK AT CENTER GUIDE ALIGNMENT HOLE.SDR 07FDEA03506Seat Track · crackedSEAT TRACK BALLMAT AREA CRACK ON SEAT TRACK. REPAIREED AREA IAW SRM 53-70-00 FIG 1 VOL I.SDR SIMA200725607Seat Track · corrodedDURING A HMBV INSPECTION CORROSION WAS FOUND ON THE CARGO SECTION OF THE SEAT TRACK AT B/L. 0.0. REPLACED THE SECTION OF CORRODED SEAT TRACK USING PART NUMBER 7253799-457 IAW SAAB SRM 53-70-60 PARA 3. AIRCRAFT RETURNED TO SERVICE.SDR DALA1134549221Cargo Track · corrodedCORROSION ON LOWER CARGO TRACK SPLICE BAR BETWEEN STA 579 AND STA 598 SRM 53-40-01, VOL I FIG 7.SDR S2YA07005Seat Track · crackedDURING STRUCTURAL INSPECTION OF THE AIRCRAFT, A CRACK WAS FOUND IN A SEAT TRACK EXTRUSION. THE SEAT TRACK IS LOCATED AT FS 290.85 EXTENDING APPROXIMATELY 5 INCHES. THE DAMAGE CONSISTED OF A HALF-INCH CRACK IN THE LOWER VERTICAL FLANGE WHERE THE UPPER PORTION OSDR ABXA070303Cargo Track · corrodedUPPER CARGO TRACKS WERE CORRODED AT FLOOR PANEL 3F ATTACH POINTS. REPAIRED SEAT TRACK IAW REA D957-56383.SDR EIA2007178Seat Track · crackedMAIN DECK BS 640 LBL 99 SEAT TRACK FOUND CRACKED. MAIN DECK BS 640 LBL 99 SEAT TRACK REPAIRED PER SRM 51-30-02.SDR AWXA200701088Seat Track · corrodedSAL - MAJOR REPAIR - BC-6 CHECK - NR 5991192, CORROSION ON CABIN SEAT TRACK, BS 1810/FR 41 - BS 2136/FR 47, +Y765. REPLACED CABIN SEAT TRACK, BS 1810/FR 41 - BS 2136/FR 47, +Y765 IAW A320 SRM 51-72-11.SDR EIA2007177Seat Track · crackedMAIN DECK BS 1580-1600 RBL 11 TO RBL 11 SEAT TRACK FOUND CRACKED. MAIN DECK BS 1580-1600 RBL 11 TO RBL 11 SEAT TRACK REPAIRED AS PER 51-30-02.SDR ABXA070314Seat Track · corrodedSEAT TRACK CORRODED INSIDE TOP OF DOUBLE TRACK AT FS 214 - 190, RIGHT BUTT LINE 22. REPAIRED SEAT TRACK IAW DC9 SSRM K05406.SDR 07FDEA03390Seat Track · gougedMAIN CARGO COMPT SEAT TRACK HAS GOUGED AREAS AT F/S 1641-1781 LBL48 REMOVE, FABRICATED AND INSTALLED DAMAGED SEAT TRACK PER SRM.SDR HNAA0700188Seat Track · corrodedCORROSION FOUND ON RIGHT SEAT TRACK AT STATION X597.500. RIGHT INBOARD SEAT TRACK REPLACED FROM STATION X526.500 TO X618.00. INSTALLED WITH SOLID RIVETS PER SRM 51-41-00.SDR TRAX200701331Seat Track · corrodedCORROSION FOUND ON RIGHT SEAT TRACK BETWEEN FR 39-40 OUT OF LIMIT, NEED TO FABRICATE NEW SEAT TRACK.SDR TRAX200701324Seat Track · corrodedLEFT SEAT TRACK BETWEEN FR 36-39 FOUND CORRODED ON W/C 100-46. NEED TO FABRICATE NEW SEAT TRACK. FABRICATED AS PER SRM 53-63-00 FIG 201 LT SEAT TRACK INSTALLATION IS COVERED BY W/C 100-46.SDR HALA0700369Seat Track · corrodedSECTION 43 SEAT TRACK CORROSION RBL 88.50 STN 592 CORROSION BEYOND SRM LIMITS, REPAIRED BE SEAT TRACK REPLACEMENT. REPLACEMENT P/N 143T5217-11.SDR HALA0700368Seat Track · corrodedSECTION 43 SEAT TRACK CORROSION LBL 11 STN 565. CORROSION BEYOND SRM LIMITS, REPAIRED BE SEAT TRACK REPLACEMENT. REPLACEMENT P/N 143T5217-11.SDR HALA0700367Seat Track · corrodedSECTION 43 SEAT TRACK CORROSION LBL 11 STN 597.5. CORROSION BEYOND SRM LIMITS, REPAIRED BE SEAT TRACK REPLACEMENT. REPLACEMENT P/N 143T5217-11.SDR HALA0700365Seat Track · corrodedSECTION 43 SEAT TRACK CORROSION RBL 88.50 STN 560.5, CORROSION BEYOND SRM LIMITS, REPAIRED BE SEAT TRACK REPLACEMENT. REPLACEMENT P/N 143T5217-11.SDR HALA0700366Seat Track · corrodedSECTION 43 SEAT TRACK CORROSION RBL 88.50 STN 560 CORROSION BEYOND SRM LIMITS, REPAIRED BE SEAT TRACK REPLACEMENT. REPLACEMENT P/N 143T5217-11.
Back to JASC 5347