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 ASOA06130Seat Track · corrodedDURING A C-CHECK IN MCN, THE RIGHT SIDE SEAT TRACKS, BL 9, WERE FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE RIGHT SIDE SEAT TRACKS, BL 9, FROM FS 350 TO FS 581 AND FS 683.50 TO FS 836.50 IAW CRJ700 SRM 51-41-02. THE RIGHT SIDE SEAT TRACKS FROMSDR UPS06M46235Seat Track · corrodedINSPECTION TYPE:C CABIN:RT SEAT TRACK X=-75.25 AT STA1305-1371, FOUND CORROSION ON BOTH TOP SURFACE AND BASE. RT SEAT TRACK X=-75.25 STA 1350 CORROSION REMOVED AND FOUND EXCEED LIMIT SRM 53-70-00 FIG3 VOL1 38, FASTENERS REMOVED, SEAT TRACK CUT AT STA 1265 ANDSDR MALA060035Seat Track · corrodedDURING THE 2 YEAR INSPECTION, THE AISLE RIGHT SIDE SEAT TRACK BL0 WAS FOUND TO HAVE AREAS OF CORROSION FROM STA 294.0 TO STA 325.0 BEYOND ALLOWABLE LIMITS PER SAAB SRM. THE AISLE RIGHT SIDE TRACK WILL BE REPLACED WITH A NEW SEAT TRACK SECTION IAW MESABA EO#S5SDR MALA060034Seat Track · corrodedDURING THE 2 YEAR INSPECTION, THE AISLE LEFT SIDE SEAT TRACK BL 18.3 WAS FOUND TO HAVE AREAS OF CORROSION FROM STA 294.0 TO STA. 325.0 BEYOND LIMITS PER SAAB SRM. THE AISLE LEFT SIDE TRACK WILL BE REPLACED WITH A NEW SEAT TRACK SECTION IAW MESABA EO NR S53060SDR 06FDEA0389Seat Track · unknownUDC CENTER TRACK FR 44 FRE54 REQUIRES REPAIR REF N00728. R & R SEAT TRACK IAW SRM 51-72-10SDR 06FDEA0388Seat Track · corrodedUDC SEAT TRACK 1 FR 44-54 2 PLACES OF CORROSION REF N00605. REPAIRED SEAT TRACK IAW SRM 53-10-16 FIG 201.SDR 06FDEA0387Seat Track · corrodedUDC SEAT TRACK 1R FR 38.2 TO FR 45 HAS 3 AREAS OF CORROSION REF N00601. REMOVED AND REPLACED SEAT TRACK IAW SRM 51-72-10.SDR 06FDEA0386Seat Track · corrodedMDC SEAT TRACK 3R FR 30 TO 38.2 HAS 4 AREAS OF CORROSION REF N00595. REPAIRED SEAT TRACK IAW SRM 53-10-16 PARA 4.B FIG 201.SDR 06FDEA0385Seat Track · corrodedUDC Z250 FR 58- FR 54.3 TRACK 1R HAS CORROSION N00548. REPAIRED DAMAGED SECTION IAW SRM 53-10-16.SDR 06FDEA0384Seat Track · corrodedUDC FR 74 TO FR 79 HAS CORROSION TRACK 2L. REPAIRED SEAT TRACK IAW SRM 53-10-16 FIG 201.SDR 06FDEA0383Seat Track · corrodedMDC FR 65 TO FR 71 3RD TRACK FR LT OF CTR TRACK FOUR PLACES OF CORR REF N00562. REPAIRED SEAT TRACK IAW SRM 53-10-16 FIG 207.SDR 06FDEA0382Seat Track · corrodedUDC Z241 SEAT TRACK 4L FR 52 TO FR 45 SPLICE HAS 5 AREAS OF CORR REF N00647. REPAIRED SEAT TRACK SECTION 4L FR 45 IAW A300-600 SRM 53-10-16 FIG 205.SDR 06FDEA0381Seat Track · corrodedMDC Z241 SEAT TRACK 3L HAS CORR FR 41 TO FR 40 N00606. REMOVED AND REPLACED SEAT TRACK SECTION IAW SRM 51-72-10 PG 1 TO 4.SDR 06FDEA0380Seat Track · corrodedMDC Z240 SEAT TRACK 4L 3 AREAS OF CORR FR 31-30 2EA AND FR 38-FR 38.1 1EA AREA REF N00608. REMOVED AND REPLACED SEAT TRACK FR 31.5 TO 30.5 IAW SRM 53-10-16 FIG 201.SDR 06FDEA0379Seat Track · corrodedMDC Z241 SEAT TRACK 5L FR 42 TO FR 40 HAS 2 AREAS OF CORR REF N00650. REMOVED AND REPLACED SEAT TRACK IAW A300-600 SRM 51-72-10 PG 1 TO PG 4.SDR 06FDEA0378Seat Track · corrodedMDC Z241 SEAT TRACK 3L HAS 4 AREAS OF CORR 3 AT FR 32 TO 30 AND 1 AT FR 38.2 ERF N00654. REMOVED AND REPLACED SEAT TRACK AT FR 30 TO 31 IAW SRM 53-10-16 FIG 201.SDR CALA0600032Cargo Track · corrodedINSPECTION FOUND AFT CARGO FLOOR RAILS WHERE FLOORBOARD ATTACHES TO RAILS CORRODED AT STA 772, LBL 17.24 TO RBL 3. THE FLOOR RAILS WERE REPAIRED IAW ECRA 5321-01336.SDR SIMA200603705Seat Track · corrodedTHE RT UPPER OB SEAT TRACK WAS FOUND TO BE CORRODED. REMOVED THE CORRODED SEAT TRACK, INSTALLED NEW SEAT TRACK IAW SRM. (K)SDR SIMA200603704Seat Track · corrodedTHE LT UPPER OB SEAT TRACK WAS FOUND TO BE CORRODED. REMOVED THE CORRODED SEAT TRACK. INSTALLED SERVICEABLE SEAT TRACK IAW SRM. (K)SDR ASOA06122Seat Track · corrodedDURING A C-CHECK IN MCN, THE LEFT AND RIGHT SIDEWALL SEAT TRACKS WERE FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE LEFT SEAT TRACKS FORWARD OF THE EMERGENCY EXIT IAW CRJ700 AMM 53-00-49, AND REPAIRED THE LEFT SEAT TRACKS AFT OF THESDR QXEA200600392Seat Track · corrodedPDX - LEFT HAND FORWARD OUTBOARD SEAT TRACK NR 1 HAS PITTING AT STATION X392. REPAIRED IAW RD 8-53-1342.SDR QXEA200600389Seat Track · corrodedPDX - RIGHT HAND OUTBOARD SEAT TRACK NR 10 HAS MINOR PITTING AT STATIONS X268, X281 AND X312. REPAIRED IAW RD 8-53-1342.SDR QXEA200600390Seat Track · corrodedPDX - RIGHT HAND FORWARD OUTBOARD SEAT TRACK NR 10 HAS MINOR PITTING AT STATIONS X393, X408 AND X424. REPAIRED IAW RD 8-53-1342.SDR QXEA200600395Seat Track · corrodedPDX - LEFT HAND AFT OUTBOARD SEAT TRACK NR 2 HAS PITTING AT STATIONS X437, X485 AND X499. REPAIRED IAW RD 8-53-1342.SDR QXEA200600394Seat Track · corrodedPDX - RIGHT HAND AFT OUTBOARD SEAT TRACK NR 11 HAS PITTING AT STATIONS X471, X486, AND X500. REPAIRED IAW RD 8-53-1342.SDR QXEA200600396Seat Track · corrodedPDX - LEFT HAND AFT OUTBOARD SEAT TRACK NR 3 HAS PITTING AT STATION X516. REPAIRED IAW RD 8-53-3644.SDR QXEA200600391Seat Track · corrodedPDX - LEFT HAND INBOARD SEAT TRACK NR 4 HAS CORROSION AROUND THE CAM LOCK RECEPTICLES IN THE ENTRY WAY. THE CENTER RECEPTICLE AT STATION X238 APPEARS EXCESSIVE. REPAIRED IAW RD 8-53-1102, RD 8-53-4473 AND SRM 51-40-11.SDR QXEA200600388Seat Track · corrodedPDX - RIGHT HAND FORWARD INBOARD SEAT TRACK NR 7 HAS CORROSION IN SEVERAL PLACES IN THE LAV AREA. ON SPOT AT STATION X214 APPEARS BEYOND LIMITS. REPAIRED IAW HORIZON AIR EO 2-53-344 AND DASH8-200 RD 8-53-1102, 8-5-7473 AND SRM 51-40-11.SDR DHL2006804505Cargo Track · wornUPPER CARGO COMPT NR 2 TRACK LUG WORN, STA 1570.000 - STA 1610.000. CUT OUT DAMAGED TRACK SEGMENT IAW SRM 51-3-0 PG 1. FABRICATED SPLICES IAW SRM 53-2-3 FIG 14 PG 49-50. CLEANED, TREATED AND PRIMED AREA AND SPLICES IAW SRM 51-1-8B. INSTALLED NEW TRACK SEGMSDR ASAA0640056Cargo Track · corrodedPAE - FOUND AFT CARGO BAY, TIE DOWN FITTING CORRODED. FOUND OUT OF LIMITS, CARGO TIE DOWN TRACK REPLACED ON MIG-5 CARD NR 4989820 PER B737-400 SRM 53-60-53. (M)SDR ASAA0640055Cargo Track · corrodedPAE - FOUND AFT CARGO BAY, TIE DOWN FITTING CORRODED. FOUND OUT OF LIMITS, CARGO TIE DOWN TRACK REPLACED ON MIG-5 CARD PER B737-400 SRM 53-60-53. (M)SDR ASAA0640054Cargo Track · corrodedPAE - AFT CARGO COMPARTMENT, CORROSION ON CARGO TIE DOWN TRACKS. FOUND OUT OF LIMITS, CARGO TIE DOWN TRACK REPLACED ON MIG-5 CARD NR 4989820 PER B737-400 SRM 53-60-53. (M)SDR UPS06M46237Seat Track · corrodedINSPECTION TYPE:C CABIN: RT SEAT TRACK X=-107.25 FOUND CORROSION AT STA1381-1421 AS MARKED. RT SEAT TRACK X=-107.25 STA 1390 TO STA 1461 CORROSION. REMOVED AND EXCEED LIMIT SRM 53-70-00 FIG 3 VOL1 38. SEAT TRACK FASTENERS REMOVED AND SEAT TRACK CUT. HFEC ISDR UPS06M46236Seat Track · corrodedINSPECTION TYPE:C CABIN:RT SEAT TRACK X=-107.25 FOUND CORROSION AT STA1305~1361 AS MARKED. RT SEATRACK X=-107.25 STA1351 CORROSION REMOVED AND EXCEED LIMITS SRM 53- 70-00 FIG3 VOL1 38, SEATRACK FASTENERS REMOVED, SEAT TRACK CUT AT STA1229 AND 1371. HFEC INSPSDR ASOA06100Seat Track · corrodedDURING A C-CHECK, THE CARGO COMPARTMENT SEAT TRACKS, ON LBL 9 AND RBL 9, AFT OF FS 559+80, WERE FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE CARGO COMPARTMENT SEAT TRACKS, ON LBL9 AND RBL9, AFT OF FS 559+80, IAW SRM. (K)SDR MWEA060007Seat Track · out of alignmentFIRST OFFICERS INBOARD AFT SEAT TRACK NOT IN ALIGNMENT WITH THE OTHER SEAT TRACK. FABRICATED AND INSTALLED TEE FITTING.SDR 06FDEA0274Seat Track · gougedMAIN CABIN SEAT TRACK GOUGED BS 744 LBL 47.0. REMOVED FLOORBOARDS TO FOM IAW DC10-30 SRM 51-31-01 VOL II. FOUND SEAT TRACK TO BE OUT OF LIMITS AND FABBED IAW DC10 SRM 53-42-01 VOL II. ALODINED AND PRIMED IAW DC10 SRM 51-21-01 VOL II. INSTALLED SEAT TRACK, SDR QXEA200600407Seat Track · corrodedPDX - CORROSION UNDER LEFT HAND INBOARD SEAT TRACK NR 6, OUTBOARD FLANGE ON UPPER WEB FROM APPROXIMATELY STATION 560 TO 598. REPAIRED IAW DASH 8 200 SRM 53-00-16, 5120-16 AND SRM 51-20-46.SDR QXEA200600397Seat Track · corrodedPDX - PITTING CORROSION/GOUGING ON LEFTHAND INBOARD SEAT TRACK AT STATION X540-547, BL9.0, Z100.0. REPAIRED IAW RD 8-53-4936 AND SRM 51-40-00 AND SRM 51-40-11.SDR QXEA200600373Seat Track · corrodedYYC - C3 FUSELAGE INTERIOR, LEFT HAND SIDE SEAT RAIL HAS AREAS OF CORROSION FROM FUSELAGE STATION 785 TO FUSELAGE STATION 830. REPAIRED IAW REO 670-53-00-013, REV A.SDR QXEA200600376Seat Track · corrodedYYC - C3 FUSELAGE INTERIOR, LEFT OUTBOARD SIDE SEAT RAIL HAS AREAS OF CORROSION FROM FUSELAGE STATION 916 TO FUSELAGE STATION 953. REPAIRED IAW REO 670-53-00-013 REV A.SDR QXEA200600375Seat Track · corrodedYYC - C3 FUSELAGE INTERIOR, LEFT OUTBOARD SIDE SEAT RAIL HAS AREAS OF CORROSION FROM FUSELAGE STATION 863 TO FUSELAGE STATION 916. REPAIRED IAW REO 670-53-013, REV A.SDR QXEA200600374Seat Track · corrodedYYC - C3 FUSELAGE INTERIOR, LEFT OUTBOARD SIDE SEAT RAIL HAS AREAS OF CORROSION FROM FUSELAGE STATION 840 TO FUSELAGE STATION 863. REPAIRED IAW REO 670-53-00-013, REV A.SDR UPS06846072Seat Track · corrodedINSPECTION TYPE:C1 LBL 24 AT STA 680 HAS CORROSION UNDER SEAT TRACK AS VEIWED FROM LOWER ACCY COMPT. REMOVED, FABRICATED AND REPLACED SEAT TRACK IAW SRM 51-1-21, 51-3-0,5 AND 53-02-03.SDR 06FDEA0235Seat Track · corrodedMAIN DECK - CORROSION FOUND ON SEAT TRACK UPPER FLANGE BETWEEN STA 859 TO 879 AT X= 25.7. REPAIR CARRIED OUT AS PER SRM 53-70-00.SDR SIMA200602324Seat Track · corrodedDURING CPCP INSPECTION FOUND RT IB SEAT TRACK FROM FRAME 36-47 CORRODED. REPLACED SEAT TRACK IAW AMM. AIRCRAFT WAS RETURNED TO SERVICE. (K)SDR SIMA200602323Seat Track · corrodedDURING CPCP INSPECTION FOUND RT FWD IB SEAT TRACK CORRODED. REPLACED SEAT TRACK IAW AMM. AIRCRAFT WAS RETURNED TO SERVICE. (K)SDR SIMA200602321Seat Track · corrodedDURING CPCP INSPECTION FOUND LT IB SEAT TRACK BETWEEN FRAMES 24-30 CORRODED. REPLACED SEAT TRACK IAW AMM. AIRCRAFT WAS RETURNED TO SERVICE. (K)SDR SIMA200602317Seat Track · corrodedDURING CPCP INSPECTION FOUND RT FWD OB SEAT TRACK IS CORRODED. REPLACED SEAT TRACK IAW AMM. AIRCRAFT WAS RETURNED TO SERVICE. (K)SDR SIMA200602316Seat Track · corrodedDURING CPCP INSPECTION FOUND LT FWD IB SEAT TRACK CORRODED. REPLACED SEAT TRACK IAW AMM. AIRCRAFT WAS RETURNED TO SERVICE. (K)
Back to JASC 5347