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 USAA041090Seat Track · corrodedBFM - S1 CHECK - SEAT TRACK, 5.3 INCH X 1.0 X 0.030 INCH AREA, CORROSION; LEVEL 2; TASK NR JA-220-53500-007, SEAT TRACK AT Y1292, APPROX FR 21. INSTALLED NEW SEAT TRACK SEGMENT AND REPAIR ANGLES IAW SRM. (K)SDR UPS05M43627Seat Track · corrodedINSPECTION TYPE:C, CABIN CORROSION ON SEAT TRACK FLANGE AT STA 1900-2007 X =107.0. CORROSION REMOVE AT STA1995 X=107, FOUND EXCEED LIMIT. MATERIAL REMOVED 0.060 IN & ORIGINAL MATERIAL THICKNESS 0.080 IN, OUT OF LIMIT. TRIMMED AT & NDT PERFORMED, FOUND NO CRSDR ASA0440291Seat Track · damagedPAE - FOUND DAMAGED SEAT TRACK. REPLACED SEAT TRACK. (M)SDR USAA041108Seat Track · corrodedBFM - FOUND SEAT TRACK CORRODED, .019 INCH DEEP Y .25 INCH WIDE BY .5 INCH LONG AREA, BETWEEN FRAME 44-45, Y=-450 SEAT TRACK. BLENDED CORROSION, REPLACED SEAT TRACK PER SRM 51-74-00, 53-31-15 FIG 101 SHT 8, 51-42-11. (M)SDR USAA041107Seat Track · corrodedBFM - FOUND SEAT TRACK CORRODED .022 INCH DEEP BY .35 INCH WIDE BY .075 INCH LONG AREA, BETWEEN FRAME 41-42, Y= -450, SEAT TRACK. BLENDED CORROSION, REPLACED SEAT TRACK PER SRM 51-74-00, 53-31-15 FIG 101 SH 8, 51-42-11. (M)SDR USAA041105Seat Track · corrodedBFM - FOUND SEAT TRACK CORRODED, .038 INCH DEEP BY 1 INCH WIDE BY 1 INCH LENGTH, FRAME 47, Y+450 SEAT TRACK. CORROSION LEVEL 2, TASK NR J7-200-2578C-025. BLENDED CORROSION, REPLACED SEAT TRACK PER SRM 51-74-00, 53-31-15 FIG 101, SHT 8, SRM 51-42-11. (M)SDR USAA041115Seat Track · corrodedBFM - FOUND SEAT TRACK CORRODED, 2 INCHES BY .5 INCH BY .070 INCH AREA, Y 1456 BETWEEN FRAME 32 AND 33. CORROSION LEVEL 2, TASK NR J7-230-53500-001. REMOVED AND REPLACED TRACK PER SRM 53-00-15. (M)SDR USAA041112Seat Track · corrodedFOUND SEAT TRACK CORRODED .020 INCH DEEP BY 2 INCH WIDE BY .5 INCH LENGTH AREA, FRAME 41, Y=-450 SEAT TRACK. CORROSION LEVEL 2, TASK NR J7-200-2578C-011. BLENDED CORROSION, REPLACED SEAT TRACK PER SRM 51-74-00, 53-31-15 FIG 101 SHT 8, 51-42-11. (M)SDR USAA041113Seat Track · corrodedBFM - SEAT TRACK CORRODED .479 INCH WIDE BY .125 INCH DEEP BY .125 INCH LENGTH AREA, FRAME 43, Y PLUS -450 SCALLOP OF SEAT TRACK. BLENDED CORROSION, REPLACED SEAT TRACK PER SRM 51-74-00, 53-31-15 FIG 101 SH 8, 51-42-11. (M)SDR USAA041121Seat Track · corrodedBFM - FOUND SEAT TRACK CORRODED .750 INCH LENGTH BY .500 INCH WIDE BY .051 INCH DEEP, CABIN FLOOR, Y-450, BETWEEN FRAME 36/37, TWO PLACES. CORROSION LEVEL 2, TASK JA-260-53500-001. REMOVED AND REPLACED PER SRM 53-00-15, FIG 101, SRM 51-74-00, 51-42-11. (M)SDR USAA041120Seat Track · corrodedBFM - FOUND SEAT TRACK ASSY CORRODED .500 INCH LONG BY 1 INCH WIDE BY .037 INCH DEEP, CABIN FLOOR, Y-450 BETWEEN FRAME 40.1 AND 40.2. CORROSION LEVEL 2, TASK NR J7-200-2578C-013. REMOVED AND REPLACED SEAT TRACK PER SRM 53-31-15, FIG 101, SH 8, SRM 51-42-11. SDR USAA041118Seat Track · corrodedBFM - FOUND SEAT TRACK CORRODED, 1 INCH BY 1 INCH BY .026 INCH AREA, Y450 BETWEEN FRAME 48 AND 49. CORROSION LEVEL 2, TASK NR J7-200-2578C-023. REMOVED AND REPLACED SET TRACK PER SRM 53-31-15. (M)SDR USAA041114Seat Track · corrodedBFM - FOUND SEAT TRACK CORRODED .055 INCH DEEP BY .75 INCH WIDE BY .5 INCH LENGTH AREA, BETWEEN FRAME 42-43, Y=-450 SEAT TRACK. CORROSION LEVEL 2, TASK NR J7-200-2578C-001. BLENDED CORROSION, REPLACED SEAT TRACK PER SRM 51-74-00, 53-31-15 FIG 101 SHT 8, 51-4SDR USAA041109Seat Track · corrodedFOUND SEAT TRACK CORRODED .024 INCH DEEP BY .50 INCH WIDE BY .075 INCH LONG AREA, BETWEEN FRAME 46-47, Y+-450 SEAT TRACK. BLENDED CORROSION, REPLACED SEAT TRACK PER SRM 51-74-00, 53-31-15 FIG 101 SHT 8, 51-42-11. (M)SDR MALA040927Seat Track · corrodedDURING 4K INSPECTION IN BNA, SEAT TRACK AT LBL 18.3 INBOARD FLANGE IS CORRODED BETWEEN FS 319 AND 339. DAMAGE WILL BE REPAIRED IAW MESABA EO S53060. REFER EAMS WORK ORDER 211207 TASK 1533. AIRCRAFT RETURN TO SERVICE 12/17/04.SDR MALA040925Seat Track · corrodedDURING 4K INSPECTION IN BNA, SEAT TRACK AT LBL 18.3 BETWEEN FS 483 AND FS 630 IS CORRODED ON O/B FLOOR PANEL FLANGE. DAMAGE WILL BE REPAIRED IAW MESABA EO S53078, REFER EAMS WORK ORDER 211207, TASK 1538 FOR ADDITIONAL INFORMATION. AIRCRAFT RETURN TO SERVICE SDR MALA040924Seat Track · corrodedDURING 4K INSPECTION IN BNA, CENTER AISLE SEAT TRACK FLANGE AT BL 0 IS CORRODED. DAMAGE WILL BE REPAIRED IAW MESABA EO S53060. REFER TO EAMS WO 211207, TASK 1524. AIRCRAFT RETURNED TO SERVICE 12/17/04.SDR ASA0440270Strap · corrodedPAE - FOUND CORROSION ON FLOOR STRAP. REPLACED FLOOR STRAP. (M)SDR ASA0440271Seat Track · corrodedPAE - FOUND CORROSION ON SEAT TRACK. REPLACED SEAT TRACK. (M)SDR ASA0440277Seat Track · damagedPAE - MECHANICAL DAMAGE ON SEAT TRACK. REMOVED DAMAGED TRACK AND SPLICED IN NEW TRACK. (M)SDR ASA0440278Seat Track · damagedPAE - FOUND SEAT TRACK IS DAMAGED. REPLACED SEAT TRACK. (M)SDR 04FDEA03382Seat Track · corrodedMAIN DECK, SEAT TRACK LBL 107 CORRODED AT STA 425 TO STA 450. CORROSION REMOVED AS PER SRM 51-21-01. FOUND OUT OF LIMIT AS PER SRM 53-70-00. REPLACED AS PER SRM 51-31-01.SDR AWXA200401437Galley Track · corrodedMCN - MAJOR REPAIR - DURING C-18 CHECK EXFOLIATION CORROSION WAS FOUND ON AFT END OF FORWARD GALLEY OUTBOARD TRACK AT BS 294, RBL 42, WL 208.5. MAINTENANCE REMOVED CORRODED FORWARD GALLEY OUTBOARD TRACK AT BS 294, RBL 42; FABRICATED A NEW REPLACEMENT TRACK PESDR ACE120404Seat Track · corrodedDURING CAMP INSPECTION, MAINTENANCE LOCATED CORROSION ON SEAT TRACK FLOOR PANEL FLANGES. SEAT TRACK AND ADJACENT LOCALIZED CORROSION SUSPECTED TO HAVE BEEN CAUSED BY CARGO SPILLAGE. SEAT TRACK REPLACED, OTHER AREAS REPAIRED.SDR EIA2004163Seat Track · corrodedM/D BS 1655-1660 LBL 95 SEAT TRACK CRACKED. M/D BS 1655 - 1660 LBL 95 SEAT TRACK REPAIRED PER SRM 53-10-05 FIG 1A.SDR EIA2004162Seat Track · corrodedM/D 1880-1920 LBL 75 SEAT TRACK FOUND CRACKED. M/D BS 1880-1920 LBL 75 SEAT TRACK REPAIRED PER SRM 53-10-05 FIG 1A.SDR MALA040906Seat Track · corrodedDURING 4K INSPECTION IN BNA, SEAT TRACK AT LBL 18.3 IS CORRODED ON INBOARD FLANGE, BETWEEN FS 294 AND FS 319. THE OUT OF LIMITS AREAS WERE REPAIRED IAW MESABA EO NR S53079. REFER EAMS WORK ORDER NR 211114/TASK 1523 FOR ADDITIONAL INFORMATION. AIRCRAFT RETURNSDR CALA0400736Seat Track · corrodedINSPECTION FOUND CABIN RIGHT I/B SEAT TRACK CORRODED AT STA 328-355, BL 0 TO RBL 23. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 53-00-52, FIGURE 202.SDR CALA0400735Seat Track · corrodedINSPECTION FOUND CABIN RIGHT O/B SEAT TRACK CORRODED AT STA 328-360, RBL 48 TO LBL 48. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 53-00-52.SDR CALA0400733Galley Track · corrodedINSPECTION FOUND FORWARD GALLEY FLOOR TRACK CORRODED AT STA 275-294, RBL 43. A NEW FLOOR TRACK SECTION WAS INSTALLED IAW SRM 51-40-02.SDR GTIA040863Seat Track · corrodedFTW - FOUND CABIN FLOOR SEAT TRACK CORRODED AT STATION 200-237, RBL 22. REMOVED CORROSION AND SECTION OF TRACK AT STATION 200-237, FABRICATED SECTION OF SEAT TRACK, TREATED, PRIMED AND TOPCOATED, OK TO INSTALL. (M)SDR DHL3622004500Seat Track · corrodedDURING C-CHECK, N/R 3194, FWD CABIN COURIER AREA - FR 19L - FR 15L, LBL 30 SEAT TRACK CORRODED. REMOVED CORROSION AT FWD CABIN AREA SEAT TRACK FOUND OUT OF LIMITS AT LBL 30 FR 19L - 15L AS PER A-300 SRM 53-10-00. REMOVED AND REPLACED SEAT TRACK FROM FRAME 1SDR 04FDEA03330Seat Track · corrodedMDCC LEFT NR 5 SEAT TRACK HAS CORROSION AT FR C-54, 53, 52, 50.89, 48. REMOVED AND REPLACED SEAT TRACK IAW A310 SRM 51-40-21 AND B/P 15 A 53811922 FROM FR 54 TO FR 45 LBL 77.SDR 04FDEA03328Seat Track · corrodedMDCC RIGHT NR 2 SEAT TRACK HAS CORROSION AT FR 52.8, 51.2, 50.51, 49.5 AND 48.5. REMOVED AND REPLACED SEAT TRACK FROM FR STA 46 TO FR STA 54 RBL 15.SDR SWIA200414590Seat Track · corrodedSIDEWALL SEAT TRACK CORRODED AT STA X5533.0-10870.0 STR 12L. ITEM FOUND AT C-CHECK INSPECTION. SEAT TRACK REPLACED IAW EMB 120 SRM 51-40-02, 51-22-00, 51-25-00.SDR SWIA200414589Seat Track · corrodedSIDEWALL SEAT TRACK CORRODED AT STA X11430.0-12860.0 STR 12R. ITEM FOUND AT C-CHECK INSPECTION. SEAT TRACK REPLACED IAW EMB SRM 51-40-02, 51-22-00, 51-25-00.SDR SWIA200414588Seat Track · corrodedSIDEWALL SEAT TRACK CORRODED AT STA X4600.0-10870.0 STR 12R. ITEM FOUND AT C-CHECK INSPECTION. SEAT TRACK REPLACED IAW EMB 120 SRM 51-40-02, 51-25-00, 51-22-00.SDR SWIA200414587Seat Track · corrodedFR 34 TO FR 38 SEAT TRACK IS CORRODED BEYOND LIMITS. ITEM FOUND AT C-CHECK INSPECTION. REPLACED SEAT TRACK IAW EMB SRM 51-25-00, 51-40-06, 51-21-02, 51-40-02, AMM 20-10-01.SDR SWIA200414586Seat Track · corrodedFR 32 TO FR 39 SEAT TRACK IS CORRODED BEYOND LIMITS. ITEM FOUND AT C-CHECK INSPECTION. SEAT TRACK REPLACED IAW EMB 120 SRM 51-25-00, 51-40-06, 51-21-02, 51-22-00, 51-40-020 AMM 21-10-01.SDR SWIA200414582Seat Track · corrodedRIGHT INBOARD MOST FORWARD SEAT RAIL IS CORRODED IN SEVERAL LOCATIONS. ITEM FOUND AT C-CHECK INSPECTION. REPLACED SEAT RAIL IAW SRM 51-25-00, 51-40-06, 51-40-02, AND MM 20-10-01.SDR MALA040896Seat Track · corrodedDURING 4K INSPECTION IN BNA, SEAT TRACK AT BLO, BETWEEN FS 294 AND 363 IS CORRODED OUT OF LIMITS AT 3 LOCATIONS, 294, 318, 340. THE DAMAGED AREAS WERE REPAIRED IAW MESABA EO #S53079. REFER EAMS NR 211114, TASK 1524 FOR ADDITIONAL INFORMATION. AIRCRAFT RETURSDR QXEA200400853Seat Track · corrodedYYC - RIGHT HAND INBOARD FORWARD SEAT RAIL HAS PITTING CORROSION ON TOP INBOARD FLANGE AT FUSELAGE STATION X66.0. REPAIRED IAW RD 8/4/53/884-1551 AND SRM SUB TASK 51-40-15-400-001.SDR QXEA200400855Seat Track · corrodedYYC - LEFT HAND INBOARD SEAT RAIL HAS CORROSION ON THE TOP FLAT AREA FROM STATION X2.070 TO 32. REPAIRED IAW RD 8/4-53-884 ISSUE 1.SDR ASAA0480579Seat Track · corrodedHV-CHECK - SEAT TRACK CORRODED. REPLACED DAMAGED SECTION.(K)SDR ASAA0410676Seat Track · corrodedPAE, D-CHECK: CORROSION ON SEAT TRACK. REPLACED SEAT TRACK.SDR ASAA0410674Seat Track · misdrilledPAE, D-CHECK: SEAT TRACK HAS MISDRILLED HOLES. REPLACED SEAT TRACK.SDR ASAA0410673Seat Track · corrodedPAE, D-CHECK: CORROSION ON SEAT TRACK. REPLACED SEAT TRACK.SDR ASAA0410672Seat Track · misinstalledPAE, D-CHECK: SEAT TRACK REQUIRES REPLACEMENT DUE TO FASTENER EDGE MARGIN. REPLACED SEAT TRACK.SDR ASAA0410666Seat Track · damagedPAE, D-CHECK: CROWN TOOTH DAMAGED ON SEAT TRACK. REPLACED SEAT TRACK.SDR ASAA0410665Seat Track · corrodedPAE, D-CHECK: CORROSION ON LWR SURFACE OF SEAT TRACK. REPLACED SEAT TRACK.
Back to JASC 5347