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 DHL9672250CSeat Track · corrodedAT C-CHECK, SEAT TRACK HAS CORROSION AT RBL 24 FROM BS 870 TO BS 950. REMOVED AND REPLACED SEAT TRACK PER SRM 53-10-3.SDR DHL9672205CSeat Track · corrodedAT C-CHECK, FOUND SEAT TRACKS CORRODED LBL 24 FROM BS 870 TO BS 950. REMOVED, REPAIRED AND REPLACED SEAT TRACK PER SRM 51-30-2.SDR C2XA96IA233Seat Track · corrodedIAH - INSPECTION: 1C, 2C, 4C. TOTAL TIME: 12,085.2 HOURS. TOTAL CYCLES: 17,466. DURING A ROUTINE INSPECTION, THE CABIN RT FORWARD SIDEWALL SEAT TRACK WAS FOUND CORRODED BEYOND THE MANUFACTURER'S LIMITS. MAINTENANCE REMOVED AND REPLACED THE RT FORWARD SISDR C2XA96IA232Seat Track · corrodedIAH - INSPECTION: 1C, 2C, 4C. TOTAL TIME: 12,085.2 HOURS. TOTAL CYCLES: 17,466. DURING A ROUTINE INSPECTION, THE RT FLOOR LEVEL FORWARD SEAT TRACK WAS FOUND CORRODED BEYOND MANUFACTURER'S LIMITS. MAINTENANCE REMOVED AND REPLACED THE RT FORWARD FLOOR SEASDR C2XA96IA231Seat Track · corrodedIAH - INSPECTION: 1C, 2C, 4C. TOTAL TIME: 12,085.2 HOURS. TOTAL CYCLES: 17,466. DURING A ROUTINE INSPECTION, THE CABIN FLOOR LEVEL LT AFT SEAT TRACK WAS FOUND TO BE CORRODED BEYOND MANUFACTURER'S LIMITS. MAINTENANCE REMOVED AND REPLACED LT AFT FLOOR SEASDR C2XA96IA230Seat Track · corrodedIAH - INSPECTION: 1C, 2C, 4C. TOTAL TIME: 12,085.2 HOURS. TOTAL CYCLES: 17,466. DURING A ROUTINE INSPECTION, THE CABIN FLOOR LEVEL LT SEAT TRACK WAS FOUND CORRODED BEYOND MANUFACTURER'S LIMITS. THE CABIN LT FORWARD FLOOR LEVEL SEAT TRACK WAS REMOVED ANDSDR 96ZZZX4922Seat Tracks · corrodedINT - DURING A SCHEDULED INSPECTION, THE LEFT AND RIGHT CABIN INBOARD SEAT RAILS WERE FOUND PITTED BETWEEN FS 210 AND FS 220. REPAIRS WERE COMPLETED BY REPLACING THE DEFECTIVE SECTIONS. REFERENCE: OPERATOR CONTROL NR MALA965130.SDR 96FDEA01505Seat Track · corrosionUPPER LOBE CORROSION AT LBL 35 FROM FS 540 TO 560. REMOVED CORROSION FOUND OUT OF LIMITS. REMOVED AND REPLACED SEAT TRACK PER SRM 51-10-1.SDR UPS96821397Seat Track · corrosionINSPECTION TYPE: CS2 EXFOLIATED CORROSION ON CABIN SEAT TRACK, AT SEVERAL PLACES FS 640 THROUGH FS 1280 TRACK NR 9. REPLACED TRACK SECTION PER SRM 53-2-3.SDR AALA961332Cargo Track · corrodedTUL - FOUND CARGO TRACK CORRODED ON TOP SIDE. REPLACED TIE DOWN. (M)SDR 96ZZZM1549Tie Down Track · corrodedVARIOUS CORROSION SPOTS FOUND ON STRUCTURE AND TIE DOWN TRACKS IN AFT CARGO PIT. SEE ATTACHED NON-ROUTINE CARDS 10000116/128/131/132/133/134. REWORKED CORRODED STRUCTURE, REMOVED AND REPLACED WORN AND CORRODED TIE DOWN TRACKS IAW DC9 SRM 51-30-1. (M)SDR 96ZZZM1550Tie Down Tracks · corrodedVARIOUS CORROSION SPOTS FOUND ON STRUCTURE AND TIE DOWN TRACKS IN MID CARGO PIT. REFERENCE NON-ROUTINE FORMS 10000081/85/88/89/96. REWORKED CORRODED STRUCTURE, REMOVED AND REPLACED WORN AND CORRODED TIE DOWN TRACKS IAW DC9 SRM 51-30-1. (M)SDR ORJA9665Seat Track · corrodedVARIOUS CORROSION SPOTS FOUND ON SEAT TRACKS IN AFT CABIN AREA. REFERENCE ATTACHED NON-ROUTINE CARDS 20000069/70. REMOVED WORN AND CORRODED SEAT TRACKS AND REPLACED WITH NEW SEAT TRACKS, INSTALLED IAW DC9 SRM 53-05 PG 105. (M)SDR DHL9670802CSeat Track · corrodedAT C-CHECK, FWD BAGGAGE COMPT HAS SEAT TRACK CORROSION AT STA 615. REPLACED FWD BAGGAGE SEAT TRACK FROM STA 580 TO 700, PER SRM 51-10-1.SDR AALA961319Track · corrodedTUL - FOUND CARGO ROLLER TRACK HAS CORROSION AT PAD LOCK ATTACH HOLES AT FRAME 35. SPLICED IN NEW SECTION OF ROLLER TRAY IAW SRM 53-10-15 FIG 202. (M)SDR 96ZZZM1548Seat Track · corrodedVARIOUS CORROSION SPOTS FOUND ON SEAT TRACKS IN AFT CABIN AREA. REFERENCE ATTACHED NON-ROUTINE CARDS 20000069/70. REMOVED WORN AND CORRODED SEAT TRACKS AND REPLACED WITH NEW SEAT TRACKS, INSTALLED IAW DC9 SRM 53-05 PG 105. (M)SDR HAL960056Cargo Track · corrosionDURING CHECK, FOUND CORROSION ON CENTER ROLLER TRACK AT STATION 979 TO STATION 1099. FABRICATED NEW ROLLER TRACK AND INSTALLED PER SRM 51-10-00-1. (M)SDR AALA961416Seat Track · corrodedTUL - FOUND CORROSION ON NR 3 SEAT TRACK AT LAV L. REMOVED AND REPLACED NR 3 SEAT TRACK PER SRM 51-72-10. (M)SDR AALA961414Seat Track · corrodedTUL - FOUND CORROSION ON SEAT TRACK NR 3, STATION 2188. REMOVED CORROSION AND INSTALLED ALUMINUM PLUG AND APPLIED PRO SEAL 870 SEALANT PER ESO 3095. (M)SDR AALA961286Seat Track · corrodedTUL - FOUND CORROSION ON NR 8 SEAT TRACK. INSTALLED BEAM SPLICE REPAIR BETWEEN FRAME 34 AND 36 PER SRM 53-10-16. (M)SDR CKSA96112Seat Track · corrodedDURING C-2 CHECK, INSPECTION FOUND SEAT TRACK AT LBL 50 CORRODED AT ATTACH POINTS FROM FS 830 TO FS 980. REMOVED AND REPLACED SEAT TRACK AT LBL 50. TASK NR 80939, CORROSION CARD NR 5700-0553.SDR CKSA96111Seat Track · corrodedDURING C-2 CHECK, INSPECTION FOUND SEAT TRACK AT CENTER BL FS 1000 TO FS 850 CORRODED AT ATTACH POINTS. REMOVED AND REPLACED SEAT TRACK IAW DC8 SRM 51-1-21. TASK NR 80937, CORROSION CARD NR 5700-0553.SDR CKSA96110Seat Track · corrodedDURING C-2 CHECK, INSPECTION FOUND SEAT TRACK AT RBL 50 CORRODED AT ATTACH POINTS. REMOVED AND REPLACED SEAT TRACK IAW DC8 SRM 51-1-21 AND 51-3-0. TASK NR 80938, CORROSION CARD NR 5700-0553.SDR CKSA96101Seat Track · corrodedDURING C-2 CHECK, INSPECTION FOUND FS 640 TO 860 LBL 25 SEAT TRACK CORRODED. REMOVED AND REPLACED SEAT TRACK IAW DC8 SRM 53-2-3. TASK NR 80951, CORROSION CARD NR 2000-0551.SDR C2XA96IA216Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE RIGHT OUTBOARD SEAT TRACK FROM FRAME 31 TO 32 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED SEAT TRACK, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA96IA215Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE RIGHT INBOARD SEAT TRACK FROM FRAME 31 TO 32 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR UPS96821057Track · corrosionINSPECTION TYPE CS2, NR 3 SEAT TRACK AT FS 1342 HAS MODERATE CORROSION. REPAIRED SEAT TRACK PER SRM 53-2-3.SDR ABXA9700120Seat Track · corrodedDURING C-CHECK AND COMPLIANCE WITH AD 92-22-08, FOUND SEAT EXFOLIATED STATION 160 TO 218. REPLACED TRACK IAW DC-9 SRM 51-30-1, DRAWING K05406.SDR AALA961251Seat Track · corrodedTUL - FOUND CORROSION ON NR 8 SEAT TRACK FROM FRAME 30-34. REMOVED AND REPLACED NR 8 SEAT TRACK FROM FRAME NR 30 TO 34 PER SRM 51-72-10. (M)SDR QXEA9600349Seat Track · corrosionSEAT TRACK (P/N 85331040-109) FOUND CORRODED BEYOND LIMITS. CORROSION NOTED DURING C-CHECK (NR200-90). TRACK REPLACED IAW SRM 51-40-11.SDR QXEA9600348Seat Track · corrosionSEAT TRACK (P/N 85320490-133) FOUND CORRODED BEYOND LIMITS. CORROSION NOTED DURING C-CHECK (NR200-88). TRACK REPLACED IAW SRM 51-40-00.SDR QXEA9600347Seat Track · corrosionSEAT TRACK (P/N 85330164-119) FOUND CORRODED BEYOND LIMITS. CORROSION FOUND DURING C-CHECK (NR200-87). TRACK REPLACED IAW SRM 51-40-11.SDR QXEA9600346Seat Track · corrosionSEAT TRACK (P/N 85330164-117) FOUND CORRODED BEYOND LIMITS. CORROSION NOTED DURING C-CHECK (NR200-86). TRACK REPLACED IAW SRM 51-40-11.SDR QXEA9600345Seat Track · corrosionSEAT TRACK (P/N 85320490-135) FOUND CORRODED BEYOND LIMITS. CORROSION NOTED DURING C-CHECK (NR200-85,133-23). TRACK REPLACED IAW SRM 51-40-11.SDR QXEA9600344Seat Track · corrosionSEAT TRACK (P/N 85320701-125) FOUND CORRODED BEYOND LIMITS. CORROSION NOTED DURING C-CHECK (NR200-84). TRACK REPLACED IAW SRM 51-40-00.SDR QXEA9600343Seat Track · corrosionSEAT TRACK (P/N 85330507-107) FOUND CORRODED BEYOND LIMITS. CORROSION NOTED DURING C-CHECK (NR200-83). TRACK REPLACED IAW SRM 51-40-00.SDR QXEA9600342Seat Track · corrosionSEAT TRACK (P/N 85330507-104) FOUND CORRODED BEYOND LIMITS. CORROSION NOTED DURING C-CHECK (NR200-81). TRACK REPLACED I/A/W SRM 51-40-11.SDR QXEA9600341Seat Track · corrosionSEAT TRACK (P/N 85320701-123) FOUND CORRODED BEYOND LIMITS. CORROSION NOTED DURING C-CHECK (NR200-80-82). TRACK REPLACED IAW SRM 51-40-00.SDR C2XA96IA206Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE RIGHT AFT FLOOR SEAT TRACK WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA96IA205Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE LEFT LOWER SEAT TRACK WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA96IA204Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE LEFT FORWARD SIDEWALL SEAT TRACK WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA96IA203Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE LEFT AFT FLOOR SEAT TRACK WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA96IA202Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE RIGHT FORWARD SIDEWALL SEAT TRACK WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA96IA201Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE RIGHT FORWARD FLOOR SEAT TRACK WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR 97ZZZM101Seat Rail · corrodedFORWARD LEFT SEAT RAIL IS CORRODED OUTBOARD SIDE FRAME 18 TO FRAME 19A, REPLACEMENT REQUIRED. REMOVED AND REPLACED FORWARD LEFT OUTBOARD SEAT RAIL PER A/C SRM STANDARD PRACTICES.SDR QXEA9600317Seat Track · corrosionRIGHT HAND OUTBOARD SEAT TRACK HAS CORROSION ON INBOARD FLOOR SUPPORT AT FRAME 12405, 13365 AND 13875A. CORROSION NOTED DURING C-CHECK NR300-35-36-37. TRACK REPLACED I/A/W SRM 530215.SDR 96FDEA01429Seat Track · corrodedCORROSION ON O/B OF TRACK STA 840 RBL 48. INSTALLED DOUBLER PER EA 7531028823.SDR USAA960548Floor Track · corrosionCLT - INSPECTION VISUALLY FOUND LEVEL 2 40 INCH CORROSION RANDOM TOP RAIL SURFACES, LOCATED BETWEEN BS 360 - BS 520, RBL 45, REPLACED 40 INCH SECTION FOR FLOOR TRACK AS PER BOEING SRM 53-00-52 FIG 202. (M)SDR UPS96820924Track · corrosionINSPECTION TYPE-C, HEAVY CORROSION ON TRACK NR 1 FWD END OF POSITION NR 2. REPAIRED TRACK PER SRM 53-2-3.SDR UPS96820925Track · corrosionINSPECTION TYPE-C, HEAVY CORROSION ON TRACK NR 1 FWD END OF POSITION 1. REPAIRED TRACK PER SRM 53-2-3.
Back to JASC 5347