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 AT0100053Seat Track · corrodedFOUND SEAT TRACK WAS CORRODED BEYOND LIMITS. INSTALLED NEW SECTION OF SEAT TRACK IAW B737 SRM 73-10-5 FIGURE 2, 53-20-1.SDR TWAA0101208Seat Track · corrodedDURING CHECK-C MAINT, FOUND CORROSION ON NUMBER 4 TRACK AT STA 1142 TO 1309. REPLACED TRACK WITH NEW. INSTALLED PER SRM 53-05 PAGE 106.SDR MWEA010085Cargo Track · corrodedLUGGAGE TRACK STATION 738 - 817 HAS CORROSION. FABRICATED AND INSTALLED NEW LUGGAGE TRACK.SDR MWEA010092Seat Track · corrodedNR 4 SEAT TRACK HAS CORROSION ON BOTTOM OF OUTBOARD FLANGE STATION 965. FABRICATED AND INSTALLED SPLICE ANGLES, CENTER STRAP, AND SEAT TRACK SECTION.SDR MALA010391Seat Track · corrodedDURING 4K INSPECTION IN CWA, MAINTENANCE FOUND CORROSION ON RT CENTER AISLE SEAT TRACK IN CARGO COMPARTMENT STA 657 TO STA 686.888. REFER TO EO S53078. MAINTENANCE REPAIRED IAW EO S53078.SDR MALA010390Seat Track · corrodedDURING 4K INSPECTION IN CWA, FOUND CORROSION ON LT IB CENTER AISLE SEAT TRACK UPPER FLOORBOARD FLANGE FROM STA 650.888 TO 686.888. REFER TO 409 CARD 32269. MAINTENANCE COMPLETED REPAIR IAW EO S53078.SDR MALA010125Seat Track · corrodedFOUND DURING 4K HEAVY CHECK, DURING INSPECTION FOUND CORROSION ON RT CENTER AISLE SEAT TRACK UPPER FLOORBOARD FLANGE FROM STA 657 TO 686.8. COMPLETED REPAIR IAW EO S53078.SDR MALA010124Seat Track · corrodedFOUND DURING 4K HEAVY CHECK, DURING INSPECTION FOUND CORROSION ON LT CENTER AISLE SEAT TRACK INBOARD UPPER FLOORBOARD FLANGE FROM STA 650.88 TO 686.8. COMPLETED REPAIR IAW EO S53078.SDR QXEA0100044Seat Track · damagedPDX- LEFT HAND INBOARD SEAT TRACK HAS RAISED MATERIAL AT STATION X424.124. REPAIRED IAW HORIZON AIR EA 9-53-592, AND DHC-8 RD8-53-1339, AND SRM 51-20-13, PAGES 1-4.SDR QXEA0100043Seat Track · corrodedPDX- LEFT HAND INBOARD SEAT TRACK HAS LIGHT CORROSION ON TOP AREA AT STATION X456.500. REPAIRED IAW HORIZON AIR EA 9-53-592 AND DHC-8 RD8-53-1339, AND SRM 51-20-16, PAGE 1-4.SDR QXEA0100042Seat Track · damagedPDX- LEFT HAND INBOARD SEAT TRACK HAS PAINT MISSING THROUGH OUT THE TRACK. REPAIRED IAW HORIZON AIR EA 9-53-592 AND DHC-8 SRM 51-20-16, PAGES 1-4.SDR TWAA0101205Galley Track · corrodedDURING CHECK-C MAINT, FOUND NUMBER 1 CABIN TRACK, GALLEY TIE DOWN HAD CORROSION AT STA 1174. REPLACED TRACK FROM STA 1174 TO 1308, PER SRM 51-30-1.SDR MALA010135Seat Track · corrodedFOUND DURING C-CHECK, CORROSION ON LBL18.3 SEAT TRACK AND WEB FROM STA 294 - STA 363. REFER TO CELSIUS W/O 19238, TASK 1526, AND SAAB STATEMENT 340 SDS000801. MAINTENANCE REMOVED CORROSION BETWEEEN STA 294 - 363 IAW SRM 51-70-40. ALODINED, PRIMED IAW SRM 51SDR MWEA010071Seat Track · corrodedSTATION 198 TO 239 NR 4 SEAT TRACK HAS CORROSION ON IT. FABRICATED AND INSTALLED SPLICE.SDR AUS20010431Seat Track · cracked(AUS) SEAT TRACKS CRACKED THROUGH STOP PIN HOLES.SDR USAA010047Seat Track · corrodedCLT - FOUND SEAT TRACK CORRODED 3 INCHES, STATION 1640 RT INBOARD SEAT TRACK UPPER SURFACE. REMOVED AND REPLACED PER SRM 51-40-02. (M)SDR USAA010046Seat Track · corrodedCLT - FOUND SEAT TRACK CORRODED 3 INCHES, STATION 1640 R OUTBOARD SEAT TRACK UPPER SURFACE. REMOVED AND REPLACED PER SRM 51-40-02. (M)SDR USAA010045Seat Track · corrodedCLT - FOUND FORWARD COAT CLOSET TRACK CORRODED 3 INCHES BY 2 INCH, STATION 377.7, LBL 45.75. INSTALLED NEW SEAT TRACK PER SRM 51-10-00. (M)SDR USAA010044Seat Track · corrodedCLT - FOUND FORWARD COAT CLOSET TRACK CORRODED 3 INCHES BY 2 INCHES, STATION 377.7, LB 24.75. INSTALLED NEW SEAT TRACK PER SRM 51-10-00. (M)SDR AALA20010063Seat Track · corrodedTUL - FOUND CORROSION BEYOND LIMITS ON SEAT TRACK NR 1 AT STATION 671. INSTALLED SEAT TRACK PLUG PER AARD 53-20-00-10. (M)SDR MALA010133Seat Track · corrodedFOUND DURING C-CHECK, CORROSION ON BL 0 SEAT TRACK LT FLOOR FLANGE AND WEB STA 294 - STA 363. REFER TO CELSIUS W/O 19238, TASK 1525. MAINTENANCE REMOVED CORROSION BETWEEN STA 294 - 363 IAW SRM 51-70-40, MATERIAL REMAINING WITHIN LIMITS, REF SRM 51-10-10. ALSDR MALA010388Seat Track · corrodedDURING 4K INSPECTION IN CWA, LT CENTER AISLE SEAT TRACK CORRODED. REF TO 409 CARD 032268. MAINTENANCE REPAIRED SEAT TRACK AT BL 18.3 FROM STA 294 TO STA 329.0 IAW EO 553060.SDR QXEA0100052Seat Track · corrodedPDX- RIGHT HAND INBOARD SEAT TRACK AT STATION X257 HAS PITTING CORROSION. REPAIRED IAW HORIZON AIR EA 9-53-589 AND DHC-8 RD8-53-1339.SDR QXEA0100049Seat Track · corrodedPDX- LEFT HAND OUTBOARD SEAT TRACK HAS LIGHT CORROSION AT STATION X376.110. REPAIRED IAW DHC-8 RD8-53-1342.SDR QXEA0100048Seat Track · corrodedPDX- LEFT HAND OUTBOARD SEAT TRACK HAS LIGHT CORROSION AT STATION X405.737. REPAIRED IAW DHC-8 RD8-53-1342.SDR QXEA0100047Seat Track · corrodedPDX- LEFT HAND OUTBOARD SEAT TRACK HAS LIGHT CORROSION AT STATION X434.500. REPAIRED IAW DHC-8 RD8-53-1342.SDR QXEA0100046Seat Track · corrodedPDX- LEFT HAND OUTBOARD SEAT TRACK HAS SOME SMALL PITTING AT STATION X307.400. REPAIRED IAW DHC-8 SRM 51-40-00, PAGES 1-4 AND RD8-51-102 AND RD8-53-1339.SDR QXEA0100045Seat Track · corrodedPDX- LEFT HAND INBOARD SEAT TRACK HAS LIGHT PITTING ON TOP AT STATION X282.400. REPAIRED IAW DHC-8 RD8-53-1339.SDR QXEA0100032Seat Track · gougedPDX- RIGHT HAND INBOARD SEAT TRACK HAS MISSING MATERIAL AND GOUGED UPAT STATION X434.500. REPAIRED IAW DHC-8 RD8-53-1339.SDR QXEA0100039Seat Track · damagedPDX- RIGHT HAND OUTBOARD SEAT TRACK HAS RAISED MATERIAL AT STATION X280.400. REPAIRED IAW HORIZON AIR EA 9-53-587 AND DHC-8 RD8-53-1342, AND SRM 51-20-16.SDR QXEA0100038Seat Track · damagedPDX- RIGHT HAND OUTBOARD SEAT TRACK HAS RAISED MATERIAL AT STATION X361.050. REPAIRED IAW HORIZON AIR EA 9-53-587 AND DHC-8 RD8-53-1342 AND SRM 51-20-13.SDR QXEA0100036Seat Track · corrodedPDX- RIGHT HAND OUTBOARD SEAT TRACK HAS LIGHT CORROSION ON TOP SIDE AT STATION X280.400. REPAIRED IAW HORIZON AIR EA 9-53-587 AND DHC-8 RD8-53-1342 AND SRM 51-20-13.SDR QXEA0100035Seat Track · corrodedPDX-RIGHT HAND OUTBOARD SEAT TRACK HAS PITTING ON TOP SIDE AT STATION X264.100. REPAIRED IAW DHC-8 RD8-53-1342 AND SRM 51-20-16, AND HORIZON AIR EA 9-53-587.SDR TWAA0101103Cargo Track · corrodedDURING CHECK-C MAINT IN THE AFT CARGO COMPT COROSION WAS AROUND SCREW HOLES ON LT TIE DOWN TRACK FROM STA 1212 TO 1320R. INSTALLED NEW TRACK PER SRM 51-30-0.SDR UPS01434708Seat Track · corrodedINSPECTION TYPE:C, MAIN DECK CORROSION ON SEAT TRACK INNER FLANGE BS 1765, 1785 AND 1820 LBL 76 REPAIR REQUIRED. REPAIRED IAW SRM 53-10-05.SDR QXEA0100033Seat Track · corrodedPDX- RIGHT HAND INBOARD SEAT TRACK HAS PITTING ON TOP SIDE AT STATION X300.400. REPAIRED IAW DHC-8 RD8-53-1339 AND HORIZON AIR EA 9-53-588.SDR QXEA0100031Seat Track · corrodedPDX- RIGHT HAND INBOARD SEAT TRACK HAS PITTED AREA AT STATION X519.000. REPAIRED IAW HORIZON AIR EA 9-53-588 AND DHC-8 RD8-53-1339.SDR TWAA0101106Cargo Track · corrodedDURING CHECK-C MAINT FOUND CORROSION ON TIE DOWN TRACK LT STA 1081 TO 1219. REPLACED TRACK AT STA 1087 TO 1222 LT PER SRM 51-30-0.SDR UPS01434717Seat Track · corrodedINSPECTION TYPE:C, UPPER DECK SEAT TRACK BS 600 - 630 LBL 47 CORRODED. CORRODED SECTION REMOVED AND NEW SECTION FITTED IAW SRM 51-40-02.SDR UPS01434716Seat Track · corrodedINSPECTION TYPE:C, MAIN CABIN UPPER DECK FLOOR SEAT TRACK AT BS 540 - 670 LBL 66 CORRODED. CORRODED SECTION OF SEAT TRACK REMOVED AND NEW SECTION FITTED IAW SRM 51-40-02.SDR QXEA0100050Seat Track · corrodedPDX- CORROSION UNDER BOLTHEAD ON STRAP ON INBOARD SIDE OF SEAT TRACK AT STATION X597.5 AND STRINGER 31L. REPAIRED IAW DHC-8 20-14-01 AND SRM 51-20-16, AND SRM 51-20-26.SDR TWAA0101108Galley Track · corrodedDURING CHECK-C MAINT IN THE FWD CABIN, LIGHT CORROSION WAS ON GALLEY TIE DOWN ANGLE APPROX STA 210, RBL 10, AT NUT PLATE RIVETS. PART REMOVED AND REPLACED WITH NEW PART PER SPM 6-70-01. PAINTED WHITE PER SRM 51-10-03. INSTALLED NEW FASTENERS PER SRM 51-30-0SDR TWAA0100924Cargo Track · corrodedDURING CHECK-C MAINT FOUND TIE DOWN TRACK CORRODED AT STA 1219 TO 1320, LT SIDE AFT CARGO BIN. REPLACED TRACK PER SRM 53-01 PAGE 4.SDR 20010222SG014Seat Track · corrodedDURING CPCP-2 INSPECTION, MAINTENANCE REPORTED THE LEFT FORWARD INBOARD, LEFT FORWARD OUTBOARD, LEFT MIDDLE OUTBOARD, LEFT MIDDLE INBOARD, LEFT AFT INBOARD, RIGHT AFT INBOARD, RIGHT MIDDLE OUTBOARD, RIGHT MIDDLE INBOARD, AND RIGHT FORWARD INBOARD SEAT TRACKS CSDR 20010222SG013Seat Track · corrodedDURING CPCP-2 INSPECTION, MAINTENANCE REPORTED THE LEFT FORWARD INBOARD, LEFT FORWARD OUTBOARD, LEFT MIDDLE OUTBOARD, LEFT MIDDLE INBOARD, LEFT AFT INBOARD, RIGHT AFT INBOARD, RIGHT MIDDLE OUTBOARD, RIGHT MIDDLE INBOARD, AND RIGHT FORWARD INBOARD SEAT TRACKS CSDR 20010222SG012Seat Track · corrodedDURING CPCP-2 INSPECTION, MAINTENANCE REPORTED THE LEFT FORWARD INBOARD, LEFT FORWARD OUTBOARD, LEFT MIDDLE OUTBOARD, LEFT MIDDLE INBOARD, LEFT AFT INBOARD, RIGHT AFT INBOARD, RIGHT MIDDLE OUTBOARD, RIGHT MIDDLE INBOARD, AND RIGHT FORWARD INBOARD SEAT TRACKS CSDR 20010222SG011Seat Track · corrodedDURING CPCP-2 INSPECTION, MAINTENANCE REPORTED THE LEFT FORWARD INBOARD, LEFT FORWARD OUTBOARD, LEFT MIDDLE OUTBOARD, LEFT MIDDLE INBOARD, LEFT AFT INBOARD, RIGHT AFT INBOARD, RIGHT MIDDLE OUTBOARD, RIGHT MIDDLE INBOARD, AND RIGHT FORWARD INBOARD SEAT TRACKS CSDR 20010222SG010Seat Track · corrodedDURING CPCP-2 INSPECTION, MAINTENANCE REPORTED THE LEFT FORWARD INBOARD, LEFT FORWARD OUTBOARD, LEFT MIDDLE OUTBOARD, LEFT MIDDLE INBOARD, LEFT AFT INBOARD, RIGHT AFT INBOARD, RIGHT MIDDLE OUTBOARD, RIGHT MIDDLE INBOARD, AND RIGHT FORWARD INBOARD SEAT TRACKS CSDR 20010222SG009Seat Track · corrodedDURING CPCP-2 INSPECTION, MAINTENANCE REPORTED THE LEFT FORWARD INBOARD, LEFT FORWARD OUTBOARD, LEFT MIDDLE OUTBOARD, LEFT MIDDLE INBOARD, LEFT AFT INBOARD, RIGHT AFT INBOARD, RIGHT MIDDLE OUTBOARD, RIGHT MIDDLE INBOARD, AND RIGHT FORWARD INBOARD SEAT TRACKS CSDR 20010222SG008Seat Track · corrodedDURING CPCP-2 INSPECTION, MAINTENANCE REPORTED THE LEFT FORWARD INBOARD, LEFT FORWARD OUTBOARD, LEFT MIDDLE OUTBOARD, LEFT MIDDLE INBOARD, LEFT AFT INBOARD, RIGHT AFT INBOARD, RIGHT MIDDLE OUTBOARD, RIGHT MIDDLE INBOARD, AND RIGHT FORWARD INBOARD SEAT TRACKS C
Back to JASC 5347