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 ASOA04309Seat Track · corrodedDURING A C-CHECK IN YUL, THE AFT CARGO SEAT TRACK ON THE RIGHT SIDE BETWEEN FS 41 AND FS 42 WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE AFT CARGO SEAT TRACK ON THE RIGHT SIDE BETWEEN FS 41-42 IAW SRM 51-25-04. (M)SDR ASOA04311Seat Track · corrodedDURING A C-CHECK IN YUL, THE SEAT TRACKS FROM FS 36 TO FS 39 ON THE LEFT AND RGHT SIDES WERE FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACKS FROM FS 36 TO FS 39 ON THE LEFT AND RIGHT SIDES IAW SRM 51-25-04. (M)SDR ASOA04310Seat Track · corrodedDURING A C-CHECK IN YUL, THE SEAT TRACKS FROM FS 39 TO FS 40 ON THE RIGHT SIDE AND FROM FS 39 TO FS 41 ON THE LEFT SIDE WERE FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACKS FROM FS 39 TO FS 40 ON THE RIGHT SIDE AND FROM FSSDR USAA040125Seat Track · corrodedBFM - OFUND SEAT TRACK CORRODED 2 INCHES BY 1.5 INCH BY .025 INCHE DEEP, FRAME 66-68, -Y1292, -Z240. REMOVED AND REPLACED SEAT TRACK PER SRM 53-41-14, 53-00-14, 51-42-11, 51-74-00. (M)SDR 2004UALA00348Seat Track · corrodedSEAT TRACK BETWEEN BS 639 AND 706 LBL 44 HAS CORROSION. MAJOR REPAIR ACCOMPLISHED. INSTALLED NEW SEAT TRACK SECTION.SDR 04FDEA00953Seat Track · corrodedMAIN DECK CARGO COMP, 1ST SEAT TRACK FROM CENTER LINE RT SIDE BETWEEN FRAME 74 AND 75, 2 AREAS OF CORROSION UPPER SURFACE. CLEANED CORROSION AND FOUND TO BE OUT OF LIMITS. FABRICATED AND INSTALLED SEAT TRACK SECTION PER A300-600 SRM 53-10-16 AND 51-40-21.SDR 04FDEA00952Seat Track · corrodedMAIN CABIN FR 40 TO 42 NR 3 RIGHT SEAT TRACK SPOT OF CORROSION ON TWO AREAS AS MARKED. REMOVED AND REPLACED SEAT TRACK IAW A300-600 SRM 51-72-10 AND 51-40-21.SDR 04FDEA00926Cargo Track · corrodedMAIN DECK CARGO COMP 3RD CARGO TRACK RT SIDE FROM CENTER LINE AT FR 29 ONE EA AREA OF CORROSION. REPAIRED CORRODED AREA AS PER A300-600 SRM 53-10-16.SDR 04FDEA00925Cargo Track · corrodedMAIN DECK CARGO COMP 2ND CARGO TRACK FROM CENTER RT SIDE BETWEEN FRAMES 77 AND 78, 2 EA AREAS OF CORROSION, UPPER SURFACE. BLENDED CORROSION AND FOUND TO BE OUT OF LIMITS. CUT AND REMOVED DAMAGED SECTION OF CARGO TRACK, FABRICATED NEW SECTION OF CARGO TRACK,SDR 04FDEA00924Cargo Track · corrodedMAIN DECK CARGO COMP 2ND SEAT TRACK FROM CENTER RT SIDE BETWEEN FRAMES 74 AND 75, 1 EA AREA OF CORROSION. BLENDED CORROSION AND FOUND TO BE OUT OF LIMITS. CUT AND FABRICATED NEW SEAT TRACK SECTION IAW A300 SRM 53-10-16 FIG 208. LOCATED AND DRILLED NEW SPLICSDR 04FDEA00923Seat Track · corrodedMAIN CARGO COMP 1ST SEAT TRACK LT SIDE FROM CENTER AT FRAME 70 JUST AFT HAS MILD CORROSION UPPER SURFACE. CLEANED CORROSION AND FOUND TO BE OUT OF LIMITS PER SRM 53-10-16. FABRICATED AND INSTALLED SEAT TRACK SECTION PER SRM 53-10-16 AND 51-40-21.SDR 04FDEA00922Seat Track · corrodedSEAT TRACK AT C33 RIGHT NR 1 AND 2 SEAT TRACKS THREE AREAS OF CORROSION, MAIN CARGO COMPT. REMOVED DISCREPANT CLS ADAPTER AND REPLACED WITH NEW CLS ADAPTER IAW A300-600 SRM 51-72-10.SDR 04FDEA00921Seat Track · corrodedSEAT TRACK AT C31 BETWEEN RIGHT NR 1 AND NR 2 SEAT TWO AREAS OF CORROSION. REMOVED DISCREPANT CLS ADAPTER AND REPLACED WITH NEW CLS ADAPTER IAW A300-600 SRM 51-72-10.SDR 04FDEA00920Seat Track · corrodedMAIN DECK CARGO COMP RT SIDE NR 5 SEAT TRACK BETWEEN FR 24 AND 25 HAS TWO AREAS OF CORROSION UPPER SURFACE. REPAIRED SEAT TRACK IAW A300-600 SRM 53-10-16 PG 210 FIG 202, TREATED AREA AS PER A300-600 SRM 51-75-10.SDR 04FDEA00919Seat Track · gougedMAIN CABIN SMALL SIDE TRACK BETWEEN R4 AND R3 AT FRAME 61 HAS DEEP GOUGE. REMOVED AND REPLACED SEAT TRACK IAW A300-600 SRM 51-40-21.SDR 04FDEA00918Seat Track · corrodedMAIN DECK CARGO COMP CENTER SEAT AT CENTER LINE BETWEEN FRAME 74 TO 76, THREE EACH AREAS OF CORROSION ON UPPER SURFACE. DAMAGE FOUND TO BE OUT OF LIMITS PER SRM 53-10-16. CUT OUT SECTION OF SEAT TRACK .125 INCH LONG, FABRICATED AND INSTALLED REPLACEMENT SECTSDR 04FDEA00917Seat Track · corrodedMAIN DECK CARGO COMP FLOOR, CENTER SEAT TRACK BETWEEN FRAME 66 AND 68, TWO EACH AREAS OF CORROSION. CLEANED CORROSION AND FOUND TO BE OUT OF LIMITS. SPLICED IN NEW SECTION OF SEAT TRACK BETWEEN FRAMES 65.5 AND 68.5 IAW A300-600 SRM 53-10-16.SDR 04FDEA00916Seat Track · corrodedSEAT TRACK -0- [C/L] BETWEEN FRAMES 29-30 HAS CORROSION ON FLANGE NEAR FASTENER HOLE, MAIN CABIN FLOOR. REPAIRED SEAT TRACK AS PER A300-600 SRM 53-10-16 PG 210 FIG 202.SDR ASAA0410190Seat Track · gougedFOUND SEAT TRACK IS NICKED AND GOUGED AT STATION 600-616, LBL 25. REMOVED DAMAGED SECTION AND INSTALLED REPLACEMENT FLOOR TRACK SECTION IAW SRM 53-10-5. (M)SDR MALA040371Seat Track · corrodedDURING C1 & C2 INSPECTION IN LCQ, SEAT TRACK NR 4 CORRODED OUT OF LIMITS. CUT OUT CORRODED SECTION OF NR 4 SEAT TRACK, LOCATED, DRILLED AND INSTALLED NEW SECTION OF NR 4 SEAT TRACK IAW MESABA EO A53026. A/C RELEASE DATE 4/29/04.SDR MALA040369Seat Track · corrodedDURING C1 & C2 INSPECTION IN LCQ, SEAT TRACK NR 1 CORRODED OUT OF LIMITS. CUT OUT CORRODED SECTION OF NR 1 SEAT TRACK, LOCATED AND DRILLED NEW SECTION OF SEAT AND INSTALLED IAW MESABA EO A53026. A/C RELEASE DATE 4/29/04.SDR MALA040370Seat Track · corrodedDURING C1 & C2 INSPECTION IN LCQ, SEAT TRACK NR 3 CORRODED OUT OF LIMITS. CUT OUT CORRODED SECTION OF NR 3 SEAT TRACK, LOCATED, DRILLED AND INSTALLED NEW SECTION NR 3 SEAT TRACK IAW MESABA EO A53026. A/C RELEASE DATE 4/29/04.SDR 04FDEA00899Seat Track · corrodedSECOND SEAT TRACK FROM CENTER LEFT BETWEEN FRAMES F77 & F78, 2 EA AREAS OF CORROSION UPPER SURFACE, MAIN CARGO COMPT. REMOVED CORROSION IAW A300-600 SRM 51-74-10. REMOVAL OF CORROSION WAS VISUALLY OUT OF LIMITS IAW A300-600 SRM 51-74-10. LOCATED, DRILLED, ASDR USAA040138Seat Track · corrodedBFM - FOUND SEAT TRACK BEAM CORRODED 2 INCHES IN DIAMETER BY .030 INCH DEEP AREA, BETWEEN FRAME 64 AND 65, -Y765, -Z240. REMOVED AND REPLACED BEAM PER SRM 53-00-14, 51-74-00, 51-42-11, 51-44-00, 51-23-11. CORROSION LEVEL 2, TASK NR JA-260-53500. (M)SDR MWEA040051Seat Track · corrodedNR 2 SEAT TRACK HAS AREA OF CORROSION IN CENTER CHANNEL AT STATION 1265. FABRICATED AND INSTALLED SEAT TRACK.SDR UPS04842168Seat Track · corrodedINSPECTION TYPE:C3 STATION 786 TO 798 BL 0 SEAT TRACK IS CORRODED BEYOND LIMITS. REMOVED, FABRICATED AND REPLACED SEAT TRACK SECTION BETWEEN STATION 750 TO 810 IAW SRM 53-2-3 FIG 14.SDR CALA0400335Seat Track · corrodedINSPECTION FOUND RIGHT I/B SEAT TRACK CORRODED BETWEEN BS 907 AND 947. THE CORRODED SECTION OF SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 53-60-52.SDR CALA0400327Seat Track · corrodedINSPECTION FOUND G-1 GALLEY SEAT TRACK CORRODED AT STA 277 TO 294, RBL 45.6. A NEW SEAT TRACK WAS INSTALLED IAW SRM 53-00-02.SDR AWXA200400480Seat Track · crackedDURING C-17 CHECK EXFOLIATION CORROSION AND A 1 INCH CRACK WAS FOUND ON SEAT TRACK BS 420 TO BS 425, RBL 45. MAINTENANCE REMOVED DAMAGED SECTION OF SEAT TRACK FROM BS 380 TO BS 480, RBL 45; FABRICATED A NEW REPLACEMENT SECTION OF SEAT TRACK PER DWG 65-46813; ISDR UPS04842334Seat Track · wornINSPECTION TYPE: C-1, ENGINEERS SEAT TRACKS HAVE ELONGATED HOLES. REMOVED FWD F/E'S SEAT TRACK IAW DC8 SRM 51-3-0 LOCATED AND DRILLED SE AT TRACK IAW DC8 SRM 51-1-24 AND INSTALLED IAW DC8 SRM 51-3-1SDR UPS04842333Seat Track · wornINSPECTION TYPE: C-1, ENGINEER SEAT TRACKS HAVE ELONGATED HOLES. REMOVED F/E SEAT TRACKS IAW DC8 SRM 51-3-0, LOCATED AND DRILLED FWD AND AFT TRACKS P/N 3657504-1 IAW DC8 SRM 51-1-24 AND INSTALLED IAW DC8 SR M 51-3-1SDR MALA040322Seat Track · corrodedDURING 4Y/2Y INSPECTION, CORROSION ON LEFT I/B SEAT TRACK AT STA 294-295. REMOVED AND REPLACED LEFT I/B SEAT TRACK AT STA 288-324, IAW MESABA EO S53060. A/C RELEASE DATE 4/9/04.SDR MALA040323Seat Track · corrodedDURING 4Y/2Y INSPECTION, CORROSION ON RIGHT I/B SEAT TRACK AT STA 294-295. REMOVED AND REPLACED CORRODED SECTION OF SEAT TRACK IAW MESABA EO S53060. A/C RELEASE DATE 4/9/04.SDR 04FDEA00836Seat Track · crackedMAIN DECK CARGO COMPARTMENT SEAT TRACK AT STA 755 RBL 29 FOUND CRACKED. SEAT TRACK AT STA 745 TO STA 816 RBL 27.5 CUT AND REMOVED, CARRIED OUT REPAIR IAW SRM 53-70-00 FIG 1 VOL 1.SDR 04FDEA00835Seat Track · crackedMAIN DECK CARGO COMPARTMENT SEAT TRACK AT STA 755 LBL 29 FOUND CRACKED. SEAT TRACK AT STA 745 TO STA 785 LBL 27.5 CUT AND REMOVED, CARRIED OUT REPAIR AS PER SRM 53-70-00 FIG 1 VOL 1.SDR ASAA0480233Seat Track · corrodedOKC - FOUND HV CHECK, PASSENGER CABIN SEAT TRACK AT STATION 1168-1220 IS CORRODED. REMOVED CORROSION AND INSTALLED RPR SECTION AND SPLICE PER SRM 53-05. (M)SDR ASAA0480244Seat Track · corrodedFOUND SEAT TRACK AT STATION 1163 LBL 44 HAS INTERGRANULAR CORROSION. REMOVED DAMAGED SEAT TRACK FABRICATED AND INSTALLED REPLACEMENT SEAT TRACK IAW 51-10-4, 51-30-5, MD80 SRM. (M)SDR ASAA0480247Seat Track · gougedFOUND SEAT TRACK LBL 22 STATION 1168 TO 1220 HAS NUMEROUS GOUGES. REMOVED DAMAGED SECTION, FABRICATED AND INSTALLED REPLACEMENT SECTION AND SPLICE IAW MD80 SRM 51-10-4. (M)SDR UPS04842336Seat Track · corrodedINSPECTION TYPE: C-1, CORROSION AROUND NUTPLATES & FASTENER FROM STH 1480 TO 1540 AT CUSP LT SIDE OF AFT CARGO COMPT PUT A7763. REMOVED AIR GRILLS CUSP CLOSEOUT & FLOOR TO FOM REMOVED SEAT TRACK ORIG THICKNESS .090 IAW 51-2-0. REMOVED CORR IAW 51-1-8 AFTER BLESDR CALA0400316Cargo Track · corrodedINSPECTION FOUND CARGO RAIL CORRODED AT STA 767, RBL 13.84. THE CARGO RAIL WAS REPAIRED IAW ECRA 5321-01177.SDR CALA0400314Cargo Track · gougedINSPECTION FOUND AFT CARGO FLOOR RAIL GOUGED AT STA 727J-5, RBL 3.0. REPAIRED IAW SRM 53-00-53, FIGURE 201, PAGE 202-203.SDR AWXA200400434Seat Track · corrodedMCN - MAJOR REPAIR - DURING C-8 CHECK FRETTING CORROSION WAS FOUND ON CABIN SEAT TRACK Y765 RT BETWEEN FR 24 AND FR 35. MAINTENANCE REMOVED CORRODED SECTION OF SEAT TRACK Y765 RT FROM FR 24 TO FR 35; RECEIVED AND INSTALLED A NEW REPLACEMENT SECTION OF SEAT TRSDR AWXA200400432Seat Track · corrodedMCN - MAJOR REPAIR - DURING C-8 CHECK FRETTING CORROSION WAS FOUND ON CABIN SEAT TRACK Y765 LT BETWEEN FR 24 AND FR 35. MAINTENANCE REMOVED CORRODED SECTION OF SEAT TRACK Y765 LT FROM FR 24 TO FR 35; RECEIVED AND INSTALLED A NEW REPLACEMENT SECTION OF SEAT TRSDR AWXA200400431Seat Track · corrodedMCN - MAJOR REPAIR - DURING C-8 CHECK FRETTING CORROSION WAS FOUND ON CABIN SEAT TRACK Y1292 LT BETWEEN FR 24 AND FR 35. MAINTENANCE REMOVED CORRODED SECTION OF SEAT TRACK Y1292 LT FROM FR 24 TO FR 35; RECEIVED AND INSTALLED A NEW REPLACEMENT SECTION OF SEAT SDR AWXA200400430Seat Track · corrodedMCN - MAJOR REPAIR - DURING C-8 CHECK FRETTING CORROSION WAS FOUND ON CABIN SEAT TRACK Y1292 RT BETWEEN FR 41 AND FR 47. MAINTENANCE REMOVED CORRODED SECTION OF SEAT TRACK Y1292 RT FROM FR 41 TO FR 47; RECEIVED AND INSTALLED A NEW REPLACEMENT SECTION OF SEAT SDR AWXA200400429Seat Track · corrodedMCN - MAJOR REPAIR - DURING C-8 CHECK FRETTING CORROSION WAS FOUND ON CABIN SEAT TRACK Y1292 LT BETWEEN FR 41 AND FR 47. MAINTENANCE REMOVED CORRODED SECTION OF SEAT TRACK Y1292 LT FROM FR 41 TO FR 47; RECEIVED AND INSTALLED A NEW REPLACEMENT SECTION OF SEAT SDR AWXA200400428Seat Track · corrodedMCN - MAJOR REPAIR - DURING C-8 CHECK FRETTING CORROSION WAS FOUND ON CABIN SEAT TRACK Y765 LT BETWEEN FR 41 AND FR 47. MAINTENANCE REMOVED CORRODED SECTION OF SEAT TRACK Y765 LT FROM FR 41 TO FR 47; RECEIVED AND INSTALLED A NEW REPLACEMENT SECTION OF SEAT TRSDR AWXA200400427Seat Track · corrodedMCN - MAJOR REPAIR - DURING C-8 CHECK FRETTING CORROSION WAS FOUND ON CABIN SEAT TRACK Y1292 RT BETWEEN FR 24 AND FR 35. MAINTENANCE REMOVED CORRODED SECTION OF SEAT TRACK Y1292 RT FROM FR 24 TO FR 35; RECEIVED AND INSTALLED A NEW REPLACEMENT SECTION OF SEAT SDR AWXA200400426Seat Track · corrodedMCN - MAJOR REPAIR - DURING C-8 CHECK EXFOLIATION CORROSION WAS FOUND ON CABIN SEAT TRACK Y1292 RT BETWEEN FR 47 AND FR 66. MAINTENANCE REMOVED CORRODED SECTION OF SEAT TRACK Y1292 RT FROM FR 47 TO FR 66; FABRICATED A NEW REPLACEMENT SECTION OF SEAT TRACK ANDSDR AWXA200400425Seat Track · corrodedMCN - MAJOR REPAIR - DURING C-8 CHECK EXFOLIATION CORROSION WAS FOUND ON CABIN SEAT TRACK Y765 RT BETWEEN FR 47 AND FR 66. MAINTENANCE REMOVED CORRODED SECTION OF SEAT TRACK Y765 RT FROM FR 47 TO FR 66; FABRICATED A NEW REPLACEMENT SECTION OF TRACK AND 4 EACH
Back to JASC 5347