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 MALA040272Seat Track · corrodedDURING INSPECTION IN LCQ, LEFT I/B SEAT TRACK CORRODED. REMOVED AND REPLACED CORRODED SECTION OF SEAT TRACK IAW MESABA EO S53060. A/C RELEASE DATE 3/19/2004.SDR GTIA040367Seat Track · corrodedFTW - FOUND RIGHT OUTBOARD SEAT TRACK STATION 836-1030 CORRODED AND GOUGED. REMOVED OUT OF LIMITS SEAT TRACK RIGHT OUTBOARD STATION 836-1036. FABRICATE SEAT TRACK. FABRICATED SPLICES. INSTALLED SEAT TRACK. INSTALLED SPLICES. (M)SDR GTIA040366Seat Track · corrodedFTW - FOUND RIGHT OUTBOARD SEAT TRACK STATION 436-636 CORRODED AND GOUGED. FOUND STATION 480-636 TO BE OUT OF LIMITS. REMOVED SEAT TRACK. FABRICATE SEAT TRACK. FABRICATED SPLICES. INSTALLED SEAT TRACK. INSTALLED SPLICES. (M)SDR GTIA040373Seat Track · corrodedFTW - FOUND RIGHT OUTBOARD SEAT TRACK STATION 636-836 CORRODED AND GOUGED. REMOVED LEFT OUTBOARD SEAT TRACK STATION 636-836. FABRICATED SEAT TRACK, INSTALLED SEAT TRACK AND SPLICES. (M)SDR GTIA040375Seat Track · corrodedFTW - FOUND LEFT INBOARD SEAT TRACK STATION 256-456 CORRODED AND GOUGED. REMOVED DAMAGED TRACK STATION 256-456. LOCATED AND DRILLED HOLES ON SEAT TRACK. LOCATED AND DRILLED SPLICES. INSTALLED LEFT INBOARD SEAT TRACK AND SPLICES. (M)SDR GTIA040374Seat Track · corrodedFTW - FOUND LEFT OUTBOARD SEAT TRACK STATION 1036-1136 CORRODED AND GOUGED. REMOVED SEAT TRACK LEFT OUTBOARD STATION 1036-1136. FABRICATED SEAT TRACKS. FABRICATED SPLICES. INSTALLED LEFT OUTBOARD SEAT RACKS AND SPLICES. (M)SDR GTIA040370Seat Track · corrodedFTW - FOUND RIGHT INBOARD SEAT TRACK STATION 636-836 CORRODED AND GOUGED. REMOVED DAMAGED SEAT TRACK INBOARD RIGHT STATION 636-836. LOCATED AND DRILLED NEW TRACK. LOCATED AND DRILLED TRACK SPLICES. INSTALLED NEW TRACKS AND THREE SPLICES. INSTALLED NEW TRASDR GTIA040365Seat Track · corrodedFTW - FOUND LEFT OUTBOARD SEAT TRACK STATION 436-636 CORRODED AND GOUGED. SEAT TRACK STATION 436-570 IS OUT OF LIMITS. REMOVED SEAT TRACK. FABRICATED SEAT TRACK. INSTALLED SEAT TRACK AND SPLICES. (M)SDR GTIA040372Seat Track · corrodedFTW - FOUND RIGHT INBOARD SEAT TRACK CORRODED AND GOUGED FS 1036-1309. REMOVED DAMAGED TRACK RIGHT INBOARD STATION 1036-1309. LOCATED AND DRILLED NEW TRACK. LOCATED AND DRILLED TRACK SPLICES. INSTALLED NEW TRACKS AND THREE SPLICES. (M)SDR GTIA040368Seat Track · corrodedFTW - FOUND RIGHT OUTBOARD SEAT TRACK STATION 1036-1309 CORRODED AND GOUGED. REMOVED OUT OF LIMITS SEAT TRACK RIGHT OUTBOARD STATION 1036-1309. FABRICATED SEAT TRACK. FABRICATED SPLICES. INSTALLED SEAT TRACK. INSTALLED SPLICES. (M)SDR GTIA040369Seat Track · corrodedFTW - FOUND RIGHT INBOARD SEAT TRACK STATION 436-636 CORRODED AND GOUGED. REMOVED DAMAGED SEAT TRACK RIGHT INBOARD STATION 436-636. LOCATED AND DRILLED NEW TRACK. LOCATED AND DRILLED SPLICES. INSTALLED NEW TRACKS AND THREE SPLICES. (M)SDR GTIA040379Seat Track · corrodedFTW - FOUND LEFT INBOARD SEAT TRACK STATION 456-656 CORRODED AND GOUGED. REMOVED DAMAGED TRACK STATION 456-656. LOCATED AND DRILLED SEAT TRACK. LOCATED AND DRILLED SPLICES. INSTALLED LEFT INBOARD SEAT TRACK. (M)SDR GTIA040376Seat Track · corrodedFTW - FOUND LEFT INBOARD SEAT TRACK STATION 856-1056 CORRODED AND GOUGED. REMOVED DAMAGED TRACK STATION 856-1056. LOCATED AND DRILLED SEAT TRACK. LOCATED AND DRILLED SPLICES. INSTALLED LEFT INBOARD SEAT TRACK AND SPLICES. (M)SDR GTIA040377Seat Track · corrodedFTW - FOUND LEFT INBOARD SEAT TRACK STATION 1056-1136 CORRODED AND GOUGED. REMOVED DAMAGED TRACK STATION 1056-1136. LOCATED AND DRILLED SEAT TRACKS. LOCATED AND DRILLED SPLICES. INSTALLED LEFT INBOARD SEAT TRACKS AND SPLICES. (M)SDR GTIA040378Seat Track · corrodedFTW - FOUND LEFT INBOARD SEAT TRACK STATION 656-856 CORRODED AND GOUGED. REMOVED DAMAGED SECTION OF TRACK STATION 656-856. LOCATED AND DRILLED SEAT TRACK. LOCATED AND DRILLED. INSTALLED LEFT INBOARD SEAT TRACK AND SPLICES. (M)SDR ASAA0480186Seat Track · chafedOKC - DURING HV CHECK, FOUND CABIN SEAT TRACK IS CHAFED AT FS 1212-1322. REPLACED DAMAGED SECTION OF TRACK PER SRM 53-05. (M)SDR 04FDEA00646Seat Track · corrodedMAIN DECK - SEAT TRACK AT STA Y = 6-10 TO 6-90 (X= -8.50), FOUND WITH CORROSION. MAIN DECK - STA Y = 6-10 TO 6-90 (X= -8.50), NEW SEAT TRACK FABRICATED AS PER DWG AGA7082. CORRODED SEAT TRACK REMOVED AND REPLACED AS PER SRM 51-31-01 VOL 2.SDR MALA040271Seat Track · corrodedDURING INSPECTION IN LCQ, FS 297 RIGHT I/B SEAT TRACK CORRODED. REMOVED AND REPLACED CORRODED SECTION OF SEAT TRACK IAW MESABA EO S53060. A/C RELEASE DATE 3/17/04.SDR DHL3642004510Seat Track · corrodedDURING C-CHECK, MAIN CARGO COMPARTMENT SEAT TRACK FLANGES HAVE SEVERAL AREAS OF CORROSION BETWEEN FR. 32 AND FR. 38.2, LBL 18. REMOVED CORROSION FROM SEAT TRACK FLANGES BETWEEN FR 32 TO 38.2, LBL 18 IAW A300 SRM 51-40-11. MAT. LOSS FROM FR 32 TO 33 = 0.003,SDR DHL2004364512Seat Track · corrodedDURING "C" CHECK, 5TH SEAT TRACK FROM LT SIDE, INBD LOWER FLANGE CRACKED, OUTBOARD FLANGE HAS CORROSION AFT. OF FRAME 20. REMOVED CORROSION AT FLANGE OF SEAT TRACK IAW A300 SRM 51-40-11 PAGE 1 MATERIAL (REMOVED .030. FOUND TO BE OUT LIMIT IAW A300 SRM 53-10-00SDR DHL2004364511Seat Track · corrodedDURING C-CHECK, CABIN-8TH SEAT TRACK FROM LT SIDE, HEAVY CORROSION ON LOWER FLANGES AND IN SEAT TRACK BETWEEN FRAME 20-21. REMOVED CORROSION AT I/B SIDE OF SEAT TRACK IAW A300 SRM 51-40-11 PAGE 701. MATERIAL REMOVED .040 ORIGINAL THICKNESS .090. FOUND TO BE SDR DHL3642004509Seat Track · corrodedDURING C-CHECK, MAIN CARGO COMPARTMENT SEAT TRACK FLANGES HAVE CORROSION BETWEEN FR. 33 AND FR 36 RBL 36 ( MKD ) REMOVED CORROSION FROM SEAT TRACK FLANGES BETWEEN FR. 33 TO 36, RBL 36 IAW A300 SRM 51-40-11. MAT. LOSS FROM FR. 35 TO FR. 36 = 0.020 TO 0.030, FOSDR DHL2004364507Seat Track · corrodedDURING C-CHECK, N/R 5527 CABIN, 10TH SEAT TRACK FROM LT. SIDE, HAS CORROSION ON IB AND OB LOWER FLANGES BETWEEN FRAME 19-24 AND HEAVY CORROSION INSIDE TRACK OF FRAME 20. CUT OUT SEAT TRACK AT FR. 23 1/2 AND REMOVED SEAT FROM FR. 19 TO 23 1/2 IAW A-300 SRM 53-SDR DHL2004364506Seat Track · corrodedDURING C-CHECK, 7TH SEAT TRACK FROM LT SIDE, INBD LOWER FLANGE CRACKED AFT OF FRAME 20 AND CORROSION ON FLANGES BETWEEN FRAME 19-21. REMOVED CORROSION AT SIDE OF SEAT TRACK IAW SRM, FOUND TO BE OUT OF LIMITS. REMOVED CORRODED SEAT TRACK SECTION. TRIMMED TO FSDR DHL2004364505Seat Track · corrodedDURING C-CHECK, CABIN-SEAT TRACK, 3RD FROM SIDE HAS HEAVY CORROSION AFT OF FRAME 20. REMOVED CORROSION FROM SEAT TRACK FRAME 20 LBL 57. FOUND TO BE OUT OF LIMITS IAW SRM. CUT OUT SEAT TRACK SECTION FROM FR. TO 21.5 LBL 57 IAW SRM. TRIMMED TO FIT NEW SEAT TRSDR DHL2004364504Seat Track · corrodedDURING C-CHECK, MAIN CARGO COMPARTMENT SEAT TRACK FLANGE HAS CORROSION BETWEEN FR. 32 AND FR. 36 LBL 36. REMOVED CORROSION FROM SEVERAL SPOTS BETWEEN FR 32-36, LBL 36. MATERIAL LOSS FROM 35.5 TO FR 36 0.003 FOUND TO BE WITHIN LIMITS , FOUND TO BE OUT OF LIMITSSDR DHL2004364503Seat Track · corrodedDURING C-CHECK, SEAT TRACK, 4TH FROM LT. SIDE HAS CORROSION AFT. OF FRAME 20, AND LOWER FLANGE CRACKED. REMOVED CORRODED SEAT TRACK SECTION FROM FR. 23.5 TO FR. 15. TRIMED TO FIT NEW SEAT TRACK SECTION FROM FR. 23.5 TO FR. 15 AND SPLICED ANGLES AT FR. 23.5. TSDR DHL2004364501Seat Track · corrodedDURING C-CHECK, 9TH SEAT TRACK HAS HEAVY CORROSION IN TRACK & FLANGES FRAME 20. REMOVED CORROSION FROM SEAT TRACK FLANGE & CENTER SECTION AT FR. 19-20, RBL 57, FOUND TO BE OUT OF LIMITS. REMOVED DAMAGED SEAT TRACK SECTION FROM FR. 18.5-20.5, RBL 57. TRIMMED NESDR MALA040270Seat Track · corrodedDURING INSPECTION IN LCQ, LEFT I/B SEAT TRACK CORRODED. REMOVED AND REPLACED CORRODED SECTION OF SEAT TRACK IAW MESABA EO S53060. A/C RELEASE DATE 3/17/2004.SDR DHL2004364515Seat Track · corrodedDURING C-CHECK, MAIN DECK COURIER AREA HAVE CORROSION EVIDENCE ON FLOOR PANEL SUPPORT/SEAT TRACK FROM APPROX FR 14 TO FR 19 RBL 36 (MARKED). REMOVED CORROSION FROM TRACK FR 14 TO FR 19 RBL 36. MATERIAL LOSS .025 FOUND OUT OF LIMITS AS PER A-300 SRM 53-10-00,SDR DHL2004364514Seat Track · corrodedDURING C-CHECK, MAIN DECK COURIER AREA HAS CORROSION EVIDENCE ON FLOOR PANEL SUPPORT/SEAT TRACK FROM APPROX FR 14 TO FR 19 LBL 36 (MARKED). REMOVED CORROSION FROM FLOOR PANEL SUPPORT (SEAT TRACK) BETWEEN FR 14 TO FR 19, LBL 36 IAW A-300 SRM 51-40-11. MAT LOSSDR DHL2004364500Seat Track · corrodedDURING C-CHECK, MAIN DECK COURIER AREA HAVE CORROSION EVIDENCE ON FLOOR PANEL SUPPORT/SEAT TRACK FROM APPROX FR 14 TO FR 15 RBL 0 TO RBL 20 (MARKED). REMOVED CORROSION FROM FR 14 TO FR 15 RBL 29, MAT LOSS .030, FOUND TO BE OUT OF LIMITS IAW A-300 SRM 53-10-00SDR CALA0400235Seat Track · corrodedINSPECTION FOUND RIGHT I/B SEAT TRACK CORRODED AT STA 328-360. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 53-00-52.SDR CALA0400232Seat Track · corrodedINSPECTION FOUND RIGHT O/B SEAT TRACK CORRODED AT STA 328-338. REPAIRED IAW SRM 53-00-52, FIGURE 202.SDR ASAAO480180Seat Track · chafedOKC - DURING HV CHECK, FOUND SEAT TRACK CHAFED AT FS 1212. REPLACED DAMAGED SECTION OF TRACK PER SRM 53-05. (M)SDR ASAA0480180Seat Track · chafedOKC - DURING HV CHECK, FOUND SEAT TRACK CHAFED AT FS 1212. REPLACED DAMAGED SECTION OF TRACK PER SRM 53-05. (M)SDR 04FDEA00614Seat Track · crackedMAIN DECK FLOOR SUPPORT BEAM AT STA 635/ X = 8.5 FOUND CRACK AT THE EXISTING REPAIR SECTION. MAIN DECK FLOOR SUPPORT BEAM AT STA 635/ X = 8.5 FOUND CRACK AT THE EXISTING REPAIR SECTION REMOVED & REPAIR CARRIED OUT SECTIONAL REPLACED SEAT TRACK FROM STA 525 - SDR CALA0400229Seat Track · corrodedINSPECTION FOUND RIGHT O/B SEAT TRACK CORRODED AT STA 887-927. THE SEAT TRACK WAS REPAIRED IAW SRM 53-00-52.SDR GTIA040214Seat Track · corrodedFTW - FOUND SEAT TRACK FLANGE CORRODED AT STATION 1251 LBL 44. REMOVED SEAT TRACK AT STATION 1231-1301. LOCATED AND DRILLED NEW SEAT TRACK. INSTALLED SEAT TRACK. (M)SDR UPS04242060Cargo Track · crackedINSPECTION TYPE: C, LEFT CARGO TRACK RAIL IN AFT CARGO BAY, VERY FWD SECTION TO BS 950 IS CRACKED. REF CPT 2643 FOR FABRICATION OF CARGO TRACK. REPAIRED CARGO TRACK IAW SRM 53-10-5 FIG 8.SDR MALA040244Seat Track · corrodedDURING 4Y/2Y INSPECTION IN LCQ, LEFT I/B SEAT TRACK HAS CORROSION AT STA 294. REMOVED AND REPLACED LEFT I/B SEAT TRACK AT STA 294 IAW MESABA EO S53060. A/C RELEASE DATE 3/13/04.SDR MALA040245Seat Track · corrodedDURING 4Y/2Y INSPECTION, RIGHT I/B SEAT TRACK HAS CORROSION AT STA 294.5. REMOVED AND REPLACED RIGHT I/B SEAT TRACK AT STA 294 IAW MESABA EO S53060. A/C RELEASE DATE 3/13/2004.SDR CALA0400223Seat Track · corrodedINSPECTION FOUND RT I/B SEAT TRACK CORRODED AT STA 907-927. THE SEAT TRACK WAS REPAIRED IAW SRM 53-00-52.SDR CALA0400221Galley Track · corrodedINSPECTION FOUND GALLEY TRACK CORRODED AT STA 270-294, RBL 14. THE CORRODED SECTION OF TRACK WAS REMOVED AND A NEW SECTION WAS INSTALLED IAW SRM 53-00-52, PAGE 202, STEP 11 AND 12 AND SRM 51-10-02.SDR 04FDEA00609Seat Track · chippedMAIN DECK SEAT TRACK AT STA 1239 RBL 27.5 WITH CROWN AREA EDGE CHIPPED. MAIN DECK STA 1239/ RBL 47.5 DAMAGED SEAT TRACK CARRIED OUT SECTIONAL REPAIR AS PER SRM 53-70-00 VOL 1.SDR ASOA04369Seat Track · corrodedDURING C-CHECK, THE LT SIDE SEAT TRACK AT FRAMES 36-39 AS WELL AS THE RT SIDE SEAT TRACK FROM FRAME 39-40 WERE FOUND CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE CORRODED SEAT TRACKS IAW SRM51-25. AIRCRAFT WAS RELEASED FROM C-CHECK ON MARCH 2SDR ASO2004F00008Seat Track · corrodedDURING C-CHECK, THE LEFT SIDE SEAT TRACK AT FRAMES 36-39 AS WELL AS THE RT SIDE SEAT TRACK FROM FRAME 39-40 WERE FOUND CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE CORRODED SEAT TRACKS IAW SRM. AIRCAFT WAS RELEASED FORM C-CHECK ON MARCH 21, 2SDR SWIA200413163Seat Track · corrodedFUSELAGE SEAT TRACKS HAVE CORROSION FS 399 TO 599 + 96 RBL 9. DISCOVERED DURING C-CHECK INSPECTION. SEAT RAIL FS 409+126 TO FS 559+04 REPLACED. SEAT RAIL FS 559+04 TO FS 559+85 REPLACED.SDR SWIA200413162Seat Track · corrodedFUSELAGE SEAT TRACKS HAVE CORROSION FS 399 TO 599 + 96 LBL 9. DISCOVERED DURING C-CHECK INSPECTION. SEAT RAIL FS 409+126 TO 559+04 REPLACED. SEAT RAIL FS 559+04 TO 559+85 REPLACED.SDR UPS04M42065Seat Track · damagedINSPECTION TYPE:C CABIN SEAT TRACK AT STA 996 RBL 28 FLOOR PNL ATTACHMENT ELONGATED. REMOVED DAMAGED PORTION OF SEAT TRACK AS PER SRM 51-31-01, V2, R34. NEW SEAT TRACK REWORKED & SPLICE AS SRM 53-70-00 FIG 1, V1 REV 34. NEW SEAT TRACK & SPLICE INSTALLED 2/E
Back to JASC 5347