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 GTIA030376Seat Track · corrodedFTW - FOUND CABIN RIGHT INBOARD SEAT TRACK CORRODED FS 692-886. REMOVED TRACK. DRILLED AND LOCATED NEW TRACK AND SPLICES. INSTALLED NEW TRACK. (M)SDR QXEA200300581Seat Track · nickedPDX - NR 1 COCKPIT SEAT TRACK HAS A NICK IN THE INBOARD EDGE 8 INCHES FORWARD OF AFT END OF TRACK. REPAIRED IAW HORIZON AIR EA R-53-101.SDR QXEA0300580Seat Track · nickedPDX - NR 3 COCKPIT SEAT TRACK HAS A NICK IN THE INBOARD EDGE FORWARD OF THE AFT END OF THE TRACK. REPAIRED IAW HORIZON AIR EA R-53-102.SDR AWXA200300568Cargo Track · corrodedDURING C-09 CHECK EXFOLIATION CORROSION WAS FOUND UNDER NUT PLATES ON AFT CARGO COMPARTMENT TIE DOWN FITTING AT BS 1360, RBL 36. MAINTENANCE REMOVED AND REPLACED DAMAGED TIE DOWN FITTING AT BS 1360, RBL 36 IAW B757-200 SRM 51-40-02, PG 11.SDR 03FDEA00682Seat Track · corrodedCABIN- EXFOLIATION CORROSION OBSERVED ON SEAT TRACK UPPER LEG AT STA 1383 RBL 9.SDR MALA030278Seat Track · corrodedDURING C-CHECK INSPECTION IN CVG, NR 2 SEAT TRACK ON FRAME 18 HAS CORROSION. MAINTENANCE REPAIRED SEAT TRACK IAW EO A53026. REF TO 409 118111 FOR DETAIL. A/C RELEASE DATE 5/21/03.SDR MALA030277Seat Track · corrodedDURING C-CHECK INSPECTION IN CVG, NR 1 SEAT TRACK HAS CORROSION FROM FRAMES 18-20A. MAINTENANCE REPAIRED SEAT TRACKS IAW EO A53026. REF 409 118107 FOR DETAIL. A/C RELEASE DATE 5/21/2003SDR MALA030276Seat Track · corrodedDURING C-CHECK INSPECTION IN CVG, NR 3 SEAT TRACK HAS CORROSION FROM FRAME 10-20A. MAINTENANCE REPAIRED SEAT TRACK IAW EO #A53026. REF TO 409 # 118106 FOR DETAIL. A/C RELEASE DATE 5/21/03.SDR MALA030275Seat Track · corrodedDURING C-CHECK IN CVG, NR 4 SEAT TRACK FORWARD FROM FRAME 18 TO 20A HAS CORROSION. MAINTENANCE REMOVED AND REPLACED SEAT TRACK IAW EO A53026. REF 409 118105 FOR DETAIL. A/C RELEASE DATE 5/21/03.SDR UPS03840734Seat Track · wornINSPECTION TYPE: C-2, FWD PIT STA 320 LBL 27 FLOORBOARD, TRACK CORRODED. REMOVED CORROSION, WITHIN LIMITS IAW DC8 SRM 53-2-3. FOUND SCALLOP ON UPPER SURFACE WORN BEYOND LIMITS IAW DC8 SRM 53-2-3. REMOVED AND REPLACED TRACK SECTION IAW DC8 SRM 51-3-0, 53-2-SDR UPS03840728Seat Track · corrodedINSPECTION TYPE: C-2, MAIN CABIN TRACK CORRODED ON LOWER SIDE IN CARGO PIT RT TUNNEL STA 1243 RBL 62. REMOVED EXISTING SEAT TRACK SECTION. LOCATED, DRILLED & DEBURRED NEW SECTION OF TRACK AND SPLICES (P/N 60-15176), DC8-53B-003-502 (2) IAW DC8 SRM 51-3-2. SDR DHL2003750001Seat Track · brokenTHE REAR STOP ON THE S/O'S CHAIR SLIDING TRACK BROKEN/MISSING. REMOVED AND REPAIR SCREW ON TRACK STOP. CHECKED GOOD IAW 20-80-1.SDR DHL2003802004Seat Track · lack of lubeS/O SEAT VERY HARD TO MOVE WHEN USING FORWARD SEAT EDGE RELEASE HANDLE. LUBRICATED GUIDE RAILS, OPS CHECKED GOOD PER M/M 25-11-2.SDR DHL2003805008Seat Track · dirtySECOND OFFICERS SEAT DOES NOT SLIDE EASILY ON THE FLOOR RAILS. CLEANED SEAT TRACKS AND LUBED S/O'S SEAT ROLLERS. CHECKED GOOD AS PER M/M 25-11-6.SDR MWEA030195Seat Track · damagedCAPTAIN'S AFT SEAT TRACKS HOLES ARE ENLONGATED. DRILLED UP, INSTALLED REPAIR.SDR MWEA030194Seat Track · damagedFIRST OFFICER'S AFT SEAT TRACK HOLES ARE ENLONGATED. REMOVED TOP LEG OF FIRST OFFICER'S AFT SEAT TRACK AND TOP LEG OF PILOT'S SEAT, DRILLED UP SEAT TRACK AND INSTALLED TOP LEG SEAT TRACK AND TOP LEG OF PILOTS SEAT TRACK.SDR DHL2003604794Cargo Track · deterioratedMAIN CARGO COMPT NR 1 TRACK WITH LUGS (02 EA) DETERIORATED, STA 116.000 - STA 118.000. REMOVED DAMAGED NR 1 TRACK PLUG IAW SRM 51-3-0 PG 1. FABRICATED NEW TRACK PLUG IAW SRM 53-2-3 PG 17-19. INSTALLED NEW PLUG ON NR 1 TRACK IAW SRM 53-2-3 PG 17-19, SRM 51-3SDR DHL2003604792Seat Track · wornMAIN CARGO COMPT NR 4 TRACK LUGS WORN AT SEVERAL SPOTS STA 950.000-610.000. REMOVED NR 4 TRACK DAMAGED SEGMENT IAW SRM 53-2-3 PG 49-50. FABRICATED SPLICES IAW SRM 53-2-3 PG 49-50. CLEANED, TREATED AND PRIMED IAW SRM 51-1-8B. INSTALLED NEW TRACK SEGMENT ANDSDR AUS20030477Seat Track · corroded(AUS) CABIN FLOOR STRUCTURE CONTAINED LEVEL 2 CORROSION IN THEFOLLOWING AREAS:- 1. DOOR CUTOUT REAR RADIUS AT L1 DOOR2. CENTRE ATTACHMENT ANGLE (LOCATED BETWEEN FORWARD AND REAR RADIUS OF L1 DOOR GUSSETS 3. LT REAR PASSENGER DOOR SILL. RT OUTBOARD SEAT TRACK ASDR 250TR0011Cargo Track · damagedRIGHT CARGO TIE DOWN TRACK CRACKED AT BS 460 (FORWARD CARGO BIN).REPAIRED PER SRM 51-40-4.SDR CALA0300222Seat Track · corrodedSEAT TRACK CORRODED STATION 277 - 294 AT RBL 42. REMOVED AND REPLACED DAMGED SEAT TRACK PER SRM 51-40-02.SDR CALA0300220Cargo Track · corrodedAFT CARGO RIGHT TIE DOWN RAIL CORRODED IN NUMEROUS PLACES BETWEEN STATIONS 727 AND 787 UPPER SURFACE. REMOVED AND REPLACED WITH NEW TRACK PER 53-60-53 AND INSTALLED SPLICE AND FASTENERS PER SRM 53-00-53.SDR CALA0300226Cargo Track · corrodedAFT BAG BIN CARGO TIE DOWN RAIL HAS CORROSION AT STATION 947. REMOVED AND REPLACED TIE DOWN TRACK STATION 877 - 947 PER SRM 51-40-02 AND 53-60-53.SDR CALA0300224Seat Track · corrodedRIGHT OUTBOARD SEAT TRACK HAS CORROSION AT AFT END STATION 927. REMOVED AND REPLACED SEAT TRACK PER SRM 51-10-2.SDR 03FDEA00638Seat Track · corrodedCABIN SEAT TRACK AT RT X = 47.5 STA 1321 - 1361 CORRODED. CABIN - STA 1270 TO STA 1390 RT X=47.5 SEAT TRACK REPAIRED AS PER SRM 53-70-00, VOL I, FIG 1.SDR 03FDEA00590Seat Track · corrodedCABIN SEAT TRACK CORRODED AT STA 6-90 LT X = 75.25. SEAT TRACK REPAIRED AS PER SRM 53-70-00 FIG. 1 VOL. I.SDR ASAA0380405Cargo Track · corrodedOKC - DURING 30K CHECK, FOUND AFT CARGO TRACKS BETWEEN L27R AND L28R ARE CORRODED. INSTALLED REPAIR DOUBLER PER SRM. (M)SDR ASAA0380399Floorbeam · corrodedOKC - DURING 30K CHECK, FOUND FORWARD FLIGHT ATTENDANT SEAT INBOARD FLOOR ATTACH ANGLE CORRODED. REPAIRED PER SRM. (M)SDR ASAA0380384Mount · corrodedOKC - DURING 30K CHECK, FOUND GALLEY MOUNT CORRODED. REPLACED MOUNT. (M)SDR ASAA0380386Track · corrodedOKC - DURING 30K CHECK, FOUND FALSE TRACK CORRODED FROM STATION 160-200. REPLACED FALSE TRACK PER SRM. (M)SDR ASAA0380383Mount · corrodedOKC - DURING 30K CHECK, FOUND GALLEY MOUNT CORRODED. REPLACED MOUNT. (M)SDR ASOA03187Seat Track · corrodedDURING A C-CHECK IN BNA, THE LEFT SEAT TRACK FROM FRAME 37 TO 41 WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE LEFT SEAT TRACK FROM FRAME 37 TO 41 IAW SRM 51-25-02 AND SRM 51-25-04. (M)SDR 03FDEA00589Seat Track · crackedCABIN SEAT TRACK CRACKED AT STA 755 LBL 47.5 BETWEEN FLOOR PANELS NR 241BF, 241CF AND 241JF. CABIN STA 645 TO STA 765 LBL 47.5 SEAT TRACK REPAIRED AS PER SRM 53-70- 00, VOL.I, FIG.1.SDR 03FDEA00588Seat Track · crackedCABIN SEAT TRACK CRACKED AT STA 635 LBL 8.5 BETWEEN FLOOR PANELS 233FF AND 233EF. CABIN STA 635 TO STA 655 LBL 8.5 SEAT TRACK REPAIRED AS PER SRM 53-70-00, FIG.1, VOL.1.SDR 03FDEA00569Seat Track · corrodedMAIN CARGO DECK SEAT TRACK STA 675 TO 735 RBL 75 AT TRACK FLANGE CLIP NUT HOLES TOP AND BOTTOM CORRODED. CLOSING ACTION ON 04/14/03. REMOVED CORROSION FOUND TO BE OUT OF LIMITS IAW SRM 53-70-00. REMOVED AND REINSTALLED NEW SEAT TRACK IAW SRM 51-31-01, FABSDR HOC2003F00007Seat Track · corrodedDURING A (C) CHECK CORROSION WAS NOTED ON SEAT TRACK AND FLOOR SUPPORTS AT STA 380-420, RBL 10-20.SDR HOC2003F00001Seat Track · corrodedDURING A (C) CHECK CORROSION WAS NOTED ON SEAT TRACK STA 1070-1130 LT.SDR 03FDEA00587Seat Track · crackedCABIN SEAT TRACK AT RT 47.5 STA 1199 - 1280 CRACKED AND CROWN AREA WORN. SEAT TRACK REPAIRED AS PER SRM 53-70-00 FIG. 1 VOL. I.SDR CALA0300204Cargo Track · crackedINSPECTION FOUND A 4 INCH CRACK IN RT TIE DOWN RAIL AT STA 492. THE TIE DOWN RAIL WAS REMOVED AND REPLACED IAW SRM 51-10-02.SDR UPS03240679Seat Track · crackedINSPECTION TYPE: C&SI, SEAT TRACK CRACKED AT O/B FLANGE, RBL 45.5 BETWEEN BS 780 - BS 804 REPLACED SEAT TRACK IAW DRAWING NR 65-41980SDR 03FDEA00445Seat Track · corrodedMAIN DECK SEAT TRACK STA 595 TO 675 AND STR FOR FLOORBOARDS BAD. CLIP NUTS HOLES CORRODED TOP AND BOTTOM. BLENDED DAMAGE TRACK IAW SRM 53-10-00 STA 595 TO 620 FOUND TO BE OUT OF LIMITS. INSTALLED REPAIR SECTIONS AND SPLICES IAW SRM 53-70-00.SDR UPS03440625Seat Track · corrodedINSPECTION TYPE: C M/D - SEAT TRACK O/B FLANGE LOWER SURFACE CORROSION. SEAT TRACK REPAIRED AS PER SRM 53-10-05 FIG 16. CORROSION BLEND OUT 0.050 X 1 X 1.5 INCH. EXCEED SRM LIMIT.SDR UPS03440575Seat Track · corrodedINSPECTION TYPE: C, SEAT TRACK FOUND CORROSION. CORROSION BLEND OUT ( 0.050 X 5/8 X 2 INCHES). M/D SEAT TRACK REPAIRED AT BS 770-850 LBL 98 AS PER SRM 53-10-05 FIG 1A.SDR UPS03440535Seat Track · corrodedINSPECTION TYPE: C, SEAT TRACK FOUND CORROSION AT BS 480 - 485 RBL 65. SEAT TRACK REPAIRED AT U/D BS 480 - 530 RBL 65 AS PER SRM 53-10-05 FIG 1A. CORROSION BLEND OUT 0.045 X 1 X 8 INCHES. EXCEED SRM LIMIT.SDR UPS03440534Seat Track · corrodedINSPECTION TYPE: C, BS 820 - 860 LBL 11 SEAT TRACK RT LIP FOUND CORRODED. BS 810 - 890 LBL 11 SEAT TRACK REPAIRED AS PER SRM 53-10-05 FIG 14. CORROSION BLEND OUT 0.050 X 1 X 10 INCHES. EXCEED SRM LIMIT.SDR PCA0300848Seat Track · corrodedLEVEL 1 CORROSION SEAT TRACK STA 1046 RBL 99.0. REPAIRED PER SRM 53-10-05.SDR GTIA030431Seat Track · corrodedFOUND CABIN LEFT MIDDLE SEAT TRACK CORRODED FS 1309-1214. CUT OUT SEAT TRACK. DRILL AND LOCATED NEW SECTION OF SEAT TRACK. DRILL AND LOCATED SPLICE REPAIR. INSTALLED MID SEAT TRACK FS 1204-1309 AND SPLICE REPAIR. (M)SDR UPS03440507Seat Track · corrodedINSPECTION TYPE: C, SEAT TRACK O/B FLANGE CORROSION. SEAT TRACK REPAIR AT BS 670 - 810 RBL 11. REF NRC 6876. CORROSION BLEND OUT 0.050 X 1 X 2 INCHES.SDR UPS03440506Seat Track · corrodedINSPECTION TYPE: C, SEAT TRACK O/B FLANGE UNDER SURFACE CORROSION. BS 670 - 810 RBL 11 SEAT TRACK REPAIRED PER SRM 53-10-05 FIG 14. CORROSION BLEND OUT 0.030 X 1 X 1 INCHES. EXCEED SRM LIMIT.SDR UPS03440490Seat Track · corrodedM/D - SEAT TRACK I/B FLANGE CORROSION. CUTOUT SEAT TRACK REPAIRED PER SRM 53-10-05 FIG 1A. CORROSION BLEND OUT 0.050 X 1 X 1 INCH. EXCEED SRM LIMIT.
Back to JASC 5347