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 C2XA96IA250Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE RIGHT FORWARD FLOOR SEAT TRACK WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED SEAT TRACK, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA96IA249Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE RIGHT AFT FLOOR SEAT TRACK WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED PORTION OF SEAT TRACK, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA96IA248Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE LEFT FORWARD FLOOR SEAT TRACK WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED PORTION OF SEAT TRACK, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA96IA247Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE LEFT AFT FLOOR SEAT TRACK WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED PORTION OF SEAT TRACK, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA96IA246Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE LEFT AFT SIDEWALL SEAT TRACK WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED PORTION OF SEAT TRACK, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA96IA245Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE RIGHT AFT SIDEWALL SEAT TRACK WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED PORTION OF SEAT TRACK, AND THE AIRCRAFT WAS APPROVED FOR SERVICE. (M)SDR C2XA96IA244Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE LEFT FORWARD SIDEWALL SEAT TRACK WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED SEAT TRACK, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR ABXA9700612Seat Track · wornDURING C-CHECK AND COMPLIANCE WITH AD 92-22-08, FOUND SEAT TRACK BL 0 WORN FROM STA 605 TO 630. BLENDED IAW DC-9 SRM 53-05, FIGURE 4B.SDR ABXA9700611Seat Track · wornDURING C-CHECK AND COMPLIANCE WITH AD 92-22-08, FOUND SEAT TRACK WORN AT STA 313 TO STA 522, RBL 22. BLENDED IAW DC-9 SRM 53-05, AG 4B.SDR DU4R9600049Seat Track · corrodedDURING SCHEDULED INSPECTION AT AERO CORP IN LAKE CITY, FL, FOUND CABIN SEAT TRACK INBOARD LT SIDE BS 397.0 CORRODED BEYOND LIMITS.SDR DHL9672256CSeat Track · corrodedAT C-CHECK, SEAT TRACK FLANGE CORRODED AT STA 1032 AND RBL 1. REMOVED AND REPLACED SEAT TRACK FROM STA 1010 TO 1050 PER SRM 53-10-5.SDR ORJA9681Track · corrodedFOUND TRACK X-22 AND X-44 FROM STATION 200-237 HAS LEVEL 2 CORROSION. REPAIRED SEAT TRACKS IAW SRM 53-05, FIGURE 4. TREATED AND PRIMED IAW SRM 51-10-3. INSTALLED TRACK IAW SRM 51-30-2 AND 51-30-5. (M)SDR EISA96191Seat Track · corrodedDURING A SCHEDULED D-CHECK, FOUND A CABIN SEAT TRACK CORRODED STATION 620 LBL 40. REPLACED SEAT TRACK PER SRM 53-10-5. (M)SDR EISA96190Seat Track · corrodedDURING A SCHEDULED D-CHECK, FOUND CABIN SEAT TRACK CORRODED STATION 690 BL 40R. REPLACED SEAT TRACK PER SRM 53-10-5.SDR EISA96182Seat Track · corrodedDURING A SCHEDULED D-CHECK, FOUND CABIN SEAT TRACK CORRODED STATION 540-640 BL 40R. REPLACED TRACK PER SRM 53-10-5. (M)SDR EISA96181Seat Track · corrodedDURING A SCHEDULED D-CHECK, FOUND CABIN SEAT TRACK CORRODED STATION 540-620 LBL 40. REPLACED TRACK PER SRM 53-10-5. (M)SDR EISA96180Seat Track · corrodedDURING A SCHEDULED D-CHECK, FOUND CABIN SEAT TRACK CORRODED STATION 700 BL 20R. REPLACED TRACK PER SRM 53-10-5. (M)SDR EISA96179Seat Track · corrodedDURING A SCHEDULED D-CHECK, FOUND SEAT TRACK CORRODED STATION 1030 BL 12L. REPLACED TRACK PER SRM 53-10-5. (M)SDR EISA96178Seat Track · corrodedDURING A SCHEDULED D-CHECK, FOUND CABIN SEAT TRACK CORRODED STATION 690-700 RBL 2A. REPLACED TRACK PER SRM 53-10-5. (M)SDR EISA96176Seat Track · corrodedDURING A SCHEDULED D-CHECK, FOUND CABIN SEAT TRACK CORRODED STATION 480-540 RBL 40. REPLACED SEAT TRACK PER SRM 53-10-5. (M)SDR EISA96175Seat Track · corrodedDURING A SCHEDULED D-CHECK, FOUND SEAT TRACK CORRODED STATION 540-660 RBL 40. REPLACED SEAT TRACK PER SRM 53-10-5. (M)SDR USAAA960640Seat Track · corrodedPIT - DURING Q-2 CHECK, FOUND SEAT TRACK CORRODD AT LEFT INBOARD SEAT TRACK STATION 1125 TO 1168. SPLICED IN NEW SECTION OF SEAT TRACK PER SRM 53-05 FIG 4F. CORROSION TASK NR C58-53302, CORROSION LEVEL 1. (M)SDR USAA960662Seat Track · corrodedPIT - DURING Q-2 CHECK, FOUND LEVEL ONE SUSPECT, LEVEL TWO CORROSION AT RIGHT INBOARD SEAT TRACK AT STATION 339 TO STATION 360. SPLICED IN NEW SECTION OF SEAT TRCK PER SRM 53-05 FIG 4F. CORROSION TASK NR C58-53302, CORROSION LEVEL 1. (M)SDR USAA960661Seat Track · corrodedPIT - DURING Q-2 CHECK, FOUND SEAT TRACK CORROSION AT RIGHT INBOARD STATION 321 TO STATION 398. SPLICED IN NEW SECTION OF SEAT TRACK PER SRM 53-05 FIG 4. CORROSION TASK NR C58-53302, CORROSION LEVEL 1. (M)SDR USAA960636Seat Track · corrodedPIT - DURING Q-2 CHECK, FOUND CORRODED AREA .75 INCH BY 4 INCH AT STATION 373 SEAT TRACK RIGHT OUTBOARD. SPLICED IN NEW SECTION OF SEAT TRACK PER SRM 53-05 FIG 4F. CORROSION TASK NR C58-53302, CORROSION LEVEL 1. (M)SDR ORJA9676Track · corrodedAFT CARGO COMPARTMENT X16L TIE DOWN TRACK HAS CORROSION AT STATION 946 - 1030 AND STATION 1096. REMOVED AND REPLACED TRACK SECTIONS IAW SRM 51-30-1 AND TREATED IAW SRM 51-10-3. (M)SDR ORJA9674Track · corrodedFORWARD PIT STATION 370-522 LEFT TIE-DOWN TRACK HAS LEVEL 2 SURFACE CORROSION. REMOVED AND REPLACED DAMAGED TRACK SECTION IAW SRM 51-10-4 AND 51-30-1 AND 51-30-2. (M)SDR AWXA960619Seat Track · corrodedPAE - FLT 7825 - DURING ROUTINE MAINTENANCE CHECK, FOUND CORROSION ON SEAT TRACK BS 397, RBL 45, WL 208. REMOVED AND REPLACED SEAT TRACK PER IAW SRM 51-40-02 AND SRM 51-40-00. (M)SDR AWXA960617Seat Track · corrodedPAE - FLT 7825 - DURING ROUTINE MAINTENANCE CEHCK, FOUND CORROSION ON SEAT TRACK BS 397, RBL 24, WL 208. REMOVED AND INSTALLED REPAIR PARTS PER SRM 51-40-02. (M)SDR 96ZZZM1455Seat Track · corrodedSTL - DURING OP-15, FOUND CORROSION ON RIGHT INBOARD SEAT TRACK, STATION 1100. REPLACED SEAT TRACK PER SRM 53-05, PAGE 10G, FIGURE 4F.SDR 96ZZZM1454Seat Track · corrodedSTL - DURING OP-15 FOUND CORROSION ON LEFT OUTBOARD SEAT TRACK, STATION 1100. REPLACED SEAT TRACK PER SRM 53-05, FIGURE 4F, SHEET 1.SDR UPS96221322Seat Track · corrodedINSPECTION TYPE-C, RT SEAT TRACK HAS LIGHT SURFACE CORROSION FULL LENGTH OF FWD LOWER CARGO. REPLACED SEAT TRACK PER SRM 51-30-2.SDR ORJA9675Track · corrodedMID CARGO PIT HAS LEVEL 2 CORROSION AT STATION 693 - 787 ON RIGHT TIE-DOWN TRACK. REMOVED AND REPLACED TRACK IAW SRM 51-10-4 AND 51-30-1. (M)SDR AALA961388Seat Track · corrodedTUL - FOUND CORROSION ON TRACK NR 1 BETWEEN 31 AND 32 FRAMES AFT OF FRAME OF L2 DOOR UNDER LAV L. REPLACED SECTION OF TRACK PER SRM 51-74-10-0. (M)SDR AALA961384Seat Track · corrodedTUL - FLIGHT ATTENDANT SEAT TRACK JUST OUTBOARD OF TRACK NR 8 CORROSION AT FRAME 31. REPLACED TRACK PER SRM 51-72-10-0. (M)SDR AALA961382Seat Track · corrodedTUL - FOUND NR 8 SEAT TRACK HAS CORROSION BETWEEN FS 29 AND 31. REPLACED SEAT TRACK FROM FRAME 29-33 PER SRM 51-72-10-0. (M)SDR CKSA96153Seat Track · damagedDURING A-3 CHECK INSPECTION, FOUND DAMAGED SECTION OF SEAT TRACK FS 980 TO FS 1000 LBL 74.5. REMOVED DAMAGED SECTION OF SEAT TRACK FS 980 TO FS 1000 LBL 74.5. REPAIRED DAMAGE IAW AIA/E/2338 DRAWING DATED 9-17-96 AND FORM 8110-3 DATED 9-17-96. TASK CARD NR 8SDR 96ZZZM1462Seat Track · corrodedSTL - DURING OP-15, FOUND CORROSION ON LEFT INBOARD SEAT TRACK, FS 1087. REPLACED SEAT TRACK FROM FS 1022 TO FS 1100 PER SRM 53-05 AND 51-10-4.SDR AALA961363Cargo Track · corrodedTUL - FOUND AFT CARGO LEFT TIE DOWN TRACK HAS CORROSION FROM STATION 1060 TO STATION 1222. REMOVED AND REPLACED AFT CARGO LEFT TIE-DOWN TRACK FROM STATION 1001 TO 1222. (M)SDR 9620621152Seat Track · corrodedDURING T-CHECK, FOUND CORROSION ON THE RBL 65 SEAT TRACK AT FS 1841. REPAIRED TRACK (P/N NFA 6222-39) PER EA 11-110225.SDR MALA965132Floor Track · corrodedMSP - DURING A SCHEDULED INSPECTION IN MSP, MAINTENANCE FOUND THE AFT CARGO FLOOR TRACK RAIL TO HAVE CORROSION. REPAIRS WERE COMPLETED BY REPLACING THE RAIL ASSEMBLY, PN 85330217-001. (X)SDR DHL9672215CSeat Track · corrodedAT C-CHECK, FOUND CORROSION ON CABIN SEAT TRACK FLANGE RBL 25 STA 480 TO 520. REMOVED AND REINSTALLED NEW SEAT TRACK PER SRM 51-10-1 FROM STA 480 TO 520.SDR DHL9672263CSeat Track · corrodedAT C-CHECK, SEAT TRACK FLANGE RBL 24 BETWEEN STA 1010 TO 950B HAS CORROSION. REMOVED AND REPLACED SEAT TRACK FROM STA 955 TO 1020 PER SRM 51-10-1. SEAT TRACK WAS REPLACED BETWEEN STA 950 FRAME PLUS 5 TO STA 1020 AT RBL 24.SDR DHL9672262CSeat Track · corrodedAT C-CHECK, SEAT TRACK FLANGE RBL 46 BETWEEN STA 1070 AND 1030 HAS CORROSION. REMOVED AND REPLACED SEAT TRACK FROM STA 1010 TO 1130 PER SRM 53-10-5.SDR DHL9672244CSeat Track · corrodedAT C-CHECK, SEAT TRACK FLANGE LB 45 STA 1090 TO 1070 CORRODED. REMOVED AND REPLACED SEAT TRACK FROM STA 1060 TO 1130 PER SRM 53-10-5.SDR DHL9672243CSeat Track · corrodedAT C-CHECK, SEAT TRACK FLANGE RBL 53 STA 1130 TO 1070 HAS CORROSION. REPLACED SEAT TRACK PER SRM 51-10-1, 60 LONG.SDR DHL9672222CSeat Track · corrodedAT C-CHECK, SEAT TRACK FLANGE LBL 24 STA 995 HAS CORROSION. CUT OUT SEAT TRACK LBL 24 FROM BS 970 TO BS 1010. INSTALLED SEAT TRACK PER SRM 53-10-1.SDR MWEA96513Seat Track · wornDURING INSP, IT WAS FOUND THAT THE F/O'S LOWER AFT SEAT TRACKS INBD AND OUTBD HAD WORN ADJUSTMENT HOLES FOR THE SEAT LOCKING PIN. REPAIRED THE TRACKS IAW SRM 53-05, FIG 28.SDR MWEA96444Seat Track · corrodedDURING INSPECTION, SEAT TRACKS NR 2 AND NR 3 WERE FOUND TO HAVE CORROSION FROM STA 180 TO STA 229. REPAIRED THE SEAT TRACKS IAW SRM 53-05, FIG. 4D.SDR MALA965130Seat 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 96ZZZX4922. (X)
Back to JASC 5347