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 RAAA00B1043Seat Track · damagedDURING SCHEDULED C2 CHECK, FOUND NUMEROUS AREAS DAMAGED ON SEAT TRACK. REPLACED SEAT TRACK BS 758 - 850 LBL 45 IAW SRM 51-10-1, 51-30-2.SDR RAAAOOB1042Seat Track · corrodedDURING SCHEDULED C2 CHECK, FOUND SEVERAL AREAS OF CORROSION ON SEAT TRACK, CORROSION BEYOND LIMIT. REPLACED SEAT TRACK BS 758 - 860 BBL 0 IAW 727 SRM 51-10-1, 51-30-2.SDR RAAA00B1040Seat Track · corrodedDURING SCHEDULED C2 CHECK, FOUND NUMEROUS AREAS OF CORROSION ON SEAT TRACK. REPLACED SEAT TRACK BS 600 - 740 LBL 25 IAW SRM 51-10-1, 51-30-2.SDR RAAA00B1039Seat Track · corrodedDURING SCHEDULED C2 CHECK, FOUND CORROSION ON SEAT TRACK BEYOND LIMIT. REPLACED SEAT TRACK BS 440 - 480 IAW 727 SRM 51-10-1, 51-30-2.SDR SIMA1253Seat Track · corrodedSAW - DURING CPCP-2 INSPECTION, FOUND LEFT AFT OUTBOARD, RIGHT AFT OUTBOARD, LEFT FLIGHT ATTENDANT AND RIGHT FLIGHT ATTENDANT SEAT TRACKS CORRODED BEYOND LIMITS. REMOVED AND REPLACED CORRODED SEAT TRACKS IAW EO E905300-013. (M)SDR CALA0000622Seat Track · gougedRIGHT SIDE INBOARD SEAT TRACK HAS GOUGES AT STA 332. REMOVED AND REPLACED SEAT TRACK PER SRM 53-05 FIG 4.SDR CALA0000621Seat Track · gougedSEAT TRACK HAS GOUGING AND A DAMAGED LOBE WHERE SEAT WAS MOUNTED AT FS 370 LEFT I/B TRACK. REMOVED AND REPLACED SEAT TRACK PER SRM 53-05 FIG 4.SDR CALA0000620Galley Track · corrodedG2 GALLEY SUPPORT MOUNT CORRODED AT FS 212 RBL 12. REMOVED AND REPLACED GALLEY SUPPORT PER SRM 51-30-5.SDR CALA0000618Seat Track · corrodedCENTER SEAT TRACK LBL 44 FS 1098 TO 1174 CORRODED AROUND NUT PLATE UPPER AND LOWER FLANGES. REPLACED SEAT TRACK PER SRM 53-05 FIG 4F SHEET 1.SDR DHL2000801119Cargo Track · wornMAIN CARGO COMPT FLOOR TRACK 1 RT LUGS WORN. CUT OUT DAMAGED AREA PER SRM 53-2-3. FABRICATED CHANNEL PER SRM 53-2-3. FABRICATED SPLICE PER SRM 53-2-3. CLEANED, TREATED AND PRIMED PER SRM 51-1-8B. INSTALLED CHANNEL AND SPLICE PER SRM 53-2-3.SDR 00FDEA00322Seat Track · crackedSNRM 456 & 590 MAIN DECK, SEAT TRACK CRACKED AT BS 635 X = 27.5 RT. *S/D* REWORKED SEAT TRACK PER SRM 53-70-00 FIG 1 VOL 1.SDR CALA0000606Seat Track · corrodedLEFT INBOARD SEAT TRACK IS CORRODED AT STA 1210 TO 1240 LBL 22. REMOVED AND REPLACED DAMAGED SECTION OF SEAT TRACK PER SRM 51-10-03, 53-05 FIG 4B-1, 51-10-04, 53-05 FIG 4F, 53-30-01, AND 53-30-5.SDR CALA0000602Cargo Track · corrodedMID CARGO RIGHT SIDE TIE DOWN TRACK CORRODED. REMOVED AND REPLACED DAMAGED SECTION OF TRACK PER SRM 51-10-03, 51-30-02, AND 51-30-01.SDR CALA0000592Seat Track · corrodedMAIN CABIN LEFT O/B SEAT TRACK AT LBL 54 IS CORRODED AT STA 1174 TO 1387. REMOVED AND REPLACED SEAT TRACK SECTION PER SRM 53-01 FIG 1, 51-10-03, AND 51-30-01.SDR RAAA00B1038Seat Track · corrodedDURING SCHEDULED C2 CHECK, FOUND CORROSION ON SEAT TRACK. REPLACED SEAT TRACK BS 340 - 480 IAW SRM 51-10-1, 51-30-2.SDR RAAA00B1037Seat Track · corrodedDURING SCHEDULED C2 CHECK, FOUND CORROSION ON SEAT TRACK. REPLACED SEAT TRACK BS 350 - 480.SDR RAAA00B1036Seat Track · corrodedDURING SCHEDULED C2 CHECK, FOUND CORROSION ON SEAT TRACK. REPLACED SEAT TRACK BS 480 - 600 IAW SRM 51-10-1, 51-30-2.M54#598SDR RAAA00B1035Seat Track · corrodedDURING SCHEDULED C2 CHECK, FOUND CORROSION ON SEAT TRACK. REPLACED SEAT TRACK BS 480 - 600 IAW SRM 51-10-1, 51-30-2.SDR RAAA00B1034Seat Track · corrodedDURING SCHEDULED C2 CHECK, FOUND CORROSION ON SEAT TRACK. REPLACED SEAT TRACK BS 350 - 480 IAW SRM 51-10-1, 51-30-2.SDR RAAA00B1033Seat Track · corrodedDURING SCHEDULED C2 CHECK, FOUND CORROSION ON SEAT TRACK. REPLACED SEAT TRACK BS 350 - 480 LBL 25 IAW SRM 51-10-1, 51-30-2.SDR RAAA00B1032Seat Track · corrodedDURING SCHEDULED C2 CHECK, FOUND NUMEROUS AREAS CORROSION ON SEAT TRACK. REPLACED SEAT TRACK BS 320 - 440 LBL 45 IAW SRM 51-10-1, 51-30-2.SDR RAAA00B1031Seat Track · corrodedDURING SCHEDULED C2 CHECK, FOUND CORROSION ON SEAT TRACK. REPLACED SEAT TRACK BS 554 - 569 LBL45 IAW SRM 51-10-1, 51-30-2.SDR RAAA00B1030Seat Track · corrodedDURING SCHEDULED C2 CHECK, FOUND CORROSION ON SEAT TRACK. REPLACED SEAT TRACK IAW SRM 51-10-1, 51-30-2.SDR 00FDEA00313Seat Track · corrodedCORROSION ON TOP OF EXPANSION JOINT FOUND AFT REMOVAL OF SEAT TRACK BS 758, LBL 25, WL 208. *S/D* REMOVED AND REPLACED PER FEDEX SRM 51-30-02.SDR RRXA002423Seat Track · damagedDURING A MAINTENANCE VISIT FOUND ELONGATED HOLES IN THE SEAT TRACK AT FS 520-XCW 0, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. WITHIN ALLOWABLE LIMITS IAW DC-8 SRM 53-2-3, FIG 12 AND EO NR 00-047 WITH APPROVEDSDR CALA0000595Cargo Track · corrodedAFT CARGO RIGHT AFT TIE DOWN TRACK IS CORRODED BETWEEN FS 1211 AND 1320. REMOVED AND REPLACED DAMAGED SECTION OF TRACK PER SRM 51-30-01, 51-10-01, AND 51-10-03.SDR RAAA00B1026Seat Track · wornDURING SCHEDULED C2 CHECK, FOUND SEAT TRACK LUGS WORN BEYOND LIMIT. REPLACED SEAT TRACK BS 550 - 740 RBL 45 IAW SRM 51-10-1, 51-30-2.M54#588SDR RAAA00B1025Seat Track · wornDURING SCHEDULED C2 CHECK, FOUND SEAT TRACK LUGS WORN. REPLACED SEAT TRACK BS 660 - 740 RBL 25 IAW 727 SRM 51-10-1, 51-30-2.SDR RAAA00B1024Seat Track · corrodedDURING SCHEDULED C2 CHECK, FOUND SEAT TRACK LUGS CHIPPED. REPLACED SEAT TRACK BS 550 - 740 RBL 45 IAW 727 SRM 51-10-1, 51-30-2.M54#586SDR RAAA00B1023Seat Track · corrodedDURING SCHEDULED C2 CHECK, FOUND NUMEROUS AREAS CORROSION SEAT TRACK. REPLACED SEAT TRACK BS 550 - 740 BBL 0.M54#584SDR RAAA00B1022Seat Track · corrodedDURING SCHEDULED C2 CHECK, FOUND CORROSION ON SEAT TRACK. REPLACED SEAT TRACK BS 550 - 740 BBL 0 IAW 727 SRM 51-10-1, 51-30-2.SDR RAAA00B1029Seat Track · corrodedDURING SCHEDULED C2 CHECK, FOUND CORROSION ON SEAT TRACK. REPLACED SEAT BS 380 - 445 TRACK IAW SRM 51-10-1, 51-30-2.SDR RAAA00B1028Seat Track · wornDURING SCHEDULED C2 CHECK, FOUND SEAT TRACK LUGS WORN BEYOND LIMIT. REPLACED SEAT TRACK BS 660 - 740 RBL 25 IAW SRM 51-10-1, 51-30-2.SDR RAAA00B1027Seat Track · wornDURING SCHEDULED C2 CHECK, FOUND SEAT TRACK LUGS WORN BEYOND LIMIT. REPLACED SEAT TRACK BS 550 - 740 RBL45 IAW 727 SRM 51-10-1, 51-30-2.SDR RAAA00B1021Seat Track · corrodedDURING SCHEDULED C2 CHECK, FOUND CORROSION ON SEAT TRACK. REPLACED SEAT TRACK BS 550 - 740 BBL 0 IAW 727 SRM 51-10-1, 51-30-2.SDR RAAA00B1020Seat Track · corrodedDURING SCHEDULED C2 CHECK, FOUND CORROSION ON SEAT TRACK. REPLACED SEAT TRACK BS 550 - 740 BBL 0 IAW SRM 51-10-1, 51-30-2.SDR RAAA00B1019Seat Track · wornDURING SCHEDULED C2 CHECK, FOUND SEAT TRACK LUGS WORN. REPLACED SEAT TRACK BS 600 - 740 IAW SRM 51-10-1, 51-30-2.SDR RAAA00B1018Seat Track · wornDURING SCHEDULED C2 CHECK, FOUND SEAT TRACK LUGS WORN. REPLACED SEAT TRACK BS 737 - 740 LBL45 IAW SRM 51-10-1, 51-30-2.SDR RAAA00B1016Seat Track · brokenDURING SCHEDULED C2 CHECK, FOUND SEAT TRACK LUG BROKEN. REPLACED SEAT TRACK BS 340 - 480 IAW 51-10-1, 51-30-2.SDR RAAA00B1015Seat Track · misdrilledDURING SCHEDULED C2 CHECK, FOUND FASTENER DRILLED OFF IN NUT PLATE. REPLACED SEAT TRACK IAW SRM 51-10-1, 51-30-2.SDR RAAA00B1014Seat Track · corrodedDURING SCHEDULED C2 CHECK, FOUND CORROSION SEAT TRACK. REPLACED SEAT TRACK IAW SRM 51-10-2, 51-30-2.SDR RAAA00B1013Seat Track · corrodedDURING SCHEDULED C2 CHECK, FOUND CORROSION ON SEAT TRACK. REPLACED SEAT TRACK BS 480 - 600 IAW SRM 51-10-2, 51-30-2.SDR RAAA00B1017Seat Track · corrodedCORROSION ON SEAT TRACK. REPLACED SEAT TRACK IAW SRM 51-10-1, 51-10-2, 51-30-2.SDR RAAA00B1006Seat Track · damagedDURING SCHEDULED C2 CHECK, FOUND LT OUTBOARD SEAT TRACK DAMAGED AT BS 592 & 612. REPLACED DAMAGED SECTION OF SEAT TRACK IAW SRM 51-10-1.SDR L1GA200000056Cargo Track · corrodedLEVEL 2 CORROSION LT FWD CARGO FLOOR TRACK.SDR L1GA200000055Seat Track · corrodedLEVEL 2 CORROSION RT FWD CARGO FLOOR TRACK.SDR L1GA200000054Seat Track · crackedFWD PIT FLOOR RAIL CRACKED AND CORRODED.SDR RRXA000433Cargo Track · corrodedDURING A MAINTENANCE VISIT, FOUND CORROSION DAMAGE TO RT CARGO TIE DOWN AT STA 365 AND LONGERON 33R, DAMAGE EXCEEDED LIMITATIONS IAW DC8 SRM. REMOVED AND REPLACED TRACK IAW DC8 SRM 51-1-24, 51-1-8, 51-3-2, 53-2-3 FIG 12. TREATED AREA IAW DC8 SRM 51-1-8. CORSDR UPS00232585Seat Track · damagedINSPECTION TYPE:C+SI, SEAT TRACK DAMAGED BETWEEN BS 498 & 502 LBL 62.5. SECTION OF TRACK REPLACED IAW SRM 53-10-2 FIG 7 AND SRM 53-10-5 FIG 3.SDR TWAA0007003Cargo Track · corrodedDURING CHECK-C MAINT, THE RT AFT CARGO COMPT TIE DOWN TRACK HAD NUMEROUS PLACES OF CORROSION AT TOP AND BOTTOM OF CLIP NUT LOCATIONS FROM STA 1212 TO 1320. REMOVED AND REPLACED TIE DOWN FLOOR TRACK FROM STA 1212 TO 1320, INSTALLED WITH NAS 7103 SCREWS PER SRM
Back to JASC 5347