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 05FDEA01579Seat Track · corrodedSEAT TRACK, RBL 45, FS 500 - 540 HAS CORROSION AND FROM STATIONS 580 TO 690 HAS EXISTING BLEND REPAIRS AND REQUIRES REPLACEMENT PER EO 7-5340-7-5002. REMOVED AND REPLACED SEAT TRACK, STA 480-690 IAW SRM 51-30-2. SEAT TRACK FABBED ON TRAVELER T5-524064.SDR USAA050715Cargo Track · corrodedCLT - FOUND FLOOR TRACK ANGLE CORRODED 104 INCHES, CARGO FLOOR TRACK ANGLE, AFT CARGO STATION 787-847 STRINGER 27R. FABRICATED AND INSTALLED A NEW CARGO TRACK IAW SRM 53-00-53 FIG 202. (M)SDR 05FDEA01507Seat Track · corrodedMAIN DECK CARGO, SEAT TRACK AT STA 5-0 TO STA 5-35, X = -9 FOUND CORRODED. MAIN DECK CARGO, SEAT TRACK AT STA 5-0 TO STA 1531, X = -9 REMOVED AND REPLACED AT EXISTING SPLICES PER SRM 53-70-00 VOLUME I, FIGURE 1. REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-100SDR 05FDEA01506Seat Track · corrodedMAIN DECK CARGO, SEAT TRACK AT STA 5-93, X = -75 FOUND CORRODED. MAIN DECK CARGO, SEAT TRACK AT STA 5-0 TO STA 1531, X = -75 REMOVED AND REPLACED AT EXISTING SPLICES PER SRM 53-70-00 VOLUME I, FIGURE 1. REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-100.SDR CA050608003Seat Track · cracked(CAN) AT FWD END OF SEAT TRACKS, 2 SCREWS BEYOND END OF TRACK. SCREWS ATTACH TO ANGLE UNDER FLOOR SKIN. CRACKS ORIGINATE FROM UNDER SCREW HEADS, FWD OF TRACK. TRACK, PILOT'S IB, DOES NOT HAVE UNDER FLOOR ANGLE. THERE WERE NO CRACKS THIS LOCATION. OTHER 3 WERESDR 05FDEA01497Seat Track · corrodedUPPER CARGO COMPARTMENT, SEAT TRACK AT STA 1269 TO STA 1381, X= - 27 FOUND WITH CORROSION. 27 REMOVED AND REPLACED AT EXISTING SPLICES PER SRM 53-70-00 VOLUME I, FIGURE 1. REPAIR CLASSIFIED MAJOR GMM 6-2-100.SDR 05FDEA01495Seat Track · crackedMAIN DECK, SEAT TRACK AT STA 635 LBL = 9 FOUND CRACKED. REMOVED AND REPLACED WITH REWORKED SEAT TRACK AS PER SRM 53-70-00 VOLUME I, FIGURE 1.SDR 05FDEA01494Seat Track · crackedMAIN DECK, SEAT TRACK AT STA 635 RBL = 9 FOUND CRACKED. REMOVED AND REPLACED WITH REWORKED SEAT TRACK AS PER SRM 53-70-00 VOLUME I, FIGURE 1.SDR UPS05M45083Seat Track · corrodedINSPECTION TYPE:C-CHECK CABIN - CORROSION ON SEAT TRACK FLANGE AT SPLICE END STA 929 X=-8. CABIN SEAT TRACK BETWEEN STA 849-929 X=-8 REPAIR CARRIED OUT AS PER SRM 53-70-00 FIG 1 VOL I REV 37.SDR UPS05M44907Seat Track · corrodedCABIN CORROSION ON SEAT TRACK AT STA 919-989 X=8. SEAT TRACK BETWEEN STA 909-989 X=8. REPAIR CARRIED OUT AS PER SRM 53-70 -00 FIG 1 VOL 1 REV 37.SDR 103Seat Track · gougedCABIN RT OB SEAT TRACK HAS NUMEROUS GOUGES STA. 540 TO 727E. S/O 109001, N/R 22858SDR 102Seat Track · gougedCABIN LT IB SEAT TRACK HAS NUMEROUS GOUGES STA. 540 TO 727E. S/O 109001, N/R 22850SDR MALA050446Seat Track · corrodedDURING C2 INSPECTION, FOUND RIGHT INBOARD SEAT RAIL CORRODED NEAR FRAME 18.SDR MALA050453Seat Track · corrodedDURING C2 INSPECTION, FOUND RIGHT OUTBOARD SEAT RAIL CORRODED NEAR FRAME 18.SDR MALA050451Seat Track · corrodedDURING C2 INSPECTION, FOUND LEFT INBOARD FORWARD SEAT RAIL CORRODED NEAR FRAME 18.SDR CALA0500164Seat Track · corrodedINSPECTION FOUND LT O/B SEAT TRACK CORRODED BETWEEN BS 360 AND 380 CLOSET MOUNT TRACK, LBL 45.5. THE SEAT TRACK WAS REMOVED AND REPLACED IAW ECRA 5321-01226.SDR UPS05M45320Seat Track · corrodedCK AFT CABIN CORROSION ON SEAT TRACK AT X=107 STA 1961. AFT CABIN CORROSION ON SEAT TRACK AT X=107 STA 1961. REMOVED AND FOUND EXCEEDED LIMIT AS PER SRM 53-70-00 FIG 3 VOL 1 REV 36. REPAIR SLICE HAT REWORKED CARRIED OUT AND REPAIR SPLICE PLATE FABRICATED ASSDR UPS05M45082Seat Track · corrodedINSPECTION TYPE:C-CHECK AFT CABIN - CORROSION ON SEAT TRACK AT X=-107 STA 1841, 1901 & 1961. AFT CABIN CORROSION ON SEAT TRACK REMOVED AND FOUND EXCEED LIMIT AS PER SRM 53-70-00 FIG 3 VOL 1 REV 37, SPLICE HATS REWORKED CARRIED OUT AND SPLICE PLATES FABRICATE SDR 05FDEA01430Seat Track · corrodedAFT INTERMEDIATE FUSELAGE STA 1964 X = 107.25 RIGHT O/B EXISTING REPAIR ON CORRODED SEAT TRACK. DISCREPANT SEAT TRACK TRIM OUT AT STA 1831 RBL 107. NEW SEAT TRACK REPLACED FROM AFA 7789-542 AND CARRIED OUT REPAIR AS PER SRM 53-70-00 FIG 1 VOL I. NEW SEAT TRSDR 05FDEA01429Seat Track · corrodedAFT INTERMEDIATE FUSELAGE STA 1964, X = 107.25 LT OB EXISTING REPAIR ON CORRODED SEAT TRACK. FOR WORK ACCOMPLISHED REFER TO SNRM N0198, DISCREPANT SEAT TRACK TRIM OUT FROM STA 1751 LBL 107. NEW SEAT TRACK REPLACED FROM AFA 7789-545 AND CARRIED OUT REPAIRSDR 05FDEA01433Seat Track · corrodedFWD FUSELAGE STA 765-1129 X = 8.5 LT GALLEY 7 EXISTING REPAIR ON CORRODED SEAT TRACK. SEAT TRACK REPAIR AT FWD FUSELAGE STA 765-1129 X = 8.5 LT EVALUATED FOUND CARRIED OUT IAW SRM 53-70-00 FIG 3 VOL I. EO 1-5100-7-5001 ACCOMPLISHED.SDR 05FDEA01418Seat Track · corrodedMAIN DECK CABIN - AFT CABIN AT STA 1964 RBL 107 CURVED SEAT TRACK FOUND CORRODED AT LAVATORY TIE DOWN FITTING AREA AS MARKED. REPLACED FROM AFA 7789-542 AND CARRIED OUT REPAIR AS PER SRM 53-70-00 FIG1 VOL I. NEW SEAT TRACK AND REPAIR PARTS LOCATED AND INSTSDR 05FDEA01417Seat Track · corrodedMAIN DECK CABIN, AFT CABIN AT STA 1964 LBL 107 CURVED SEAT TRACK FOUND CORRODED AT LAVATORY TIE DOWN FITTING AS MARKED. TRIM OUT FROM STA 1751 LBL 107. NEW SEAT TRACK REPLACED FROM AFA 7789-545 AND CARRIED OUT REPAIR AS PER SRM 53-70-00 FIG 1 VOL I. NEW SEASDR ASAA0540259Seat Track · damagedPREVIOUS BLEND-OUT AT PAX CABIN SEAT TRACK, BS 500+12 INCHES, LBL 25, WL 208 OUT OF LIMITS. CUTOUT DAMAGE AND REPAIRED IAW SRM 53-00-52. (K)SDR ASAA0540258Seat Track · gougedLT OB SEAT TRACK HAS MULTIPLE GOUGES AT BS 500C. REMOVED AND REPLACED SEAT TRACK IAW SRM 53-00-52. (K)SDR UPS05444669Cargo Track · corrodedINSPECTION TYPE: C, M/D BS 700 LBL 78 TIE DOWN FITTING FLANGE FOUND CORRODED. CORROSION BLEND OUT 0.020 X 1 X 1.25 INCH EXCEED SRM 53-10-01 FIG 1 LIMITS. M/D BS 700 LBL 78 TIE DOWN FITTING REPLACED AS PER MM 20-51-01.SDR UPS05444668Cargo Track · corrodedINSPECTION TYPE: C, M/D BS 800 LBL 55 TIE DOWN FITTING FLANGE CORRODED. CORROSION BLEND OUT 0.026 X .875 X 1.125 INCH EXCEED SRM 53-10-01 FIG 1 LIMITS. M/D BS 800 LBL 55 TIE DOWN FITTING REPLACED AS PER MM 20-50-01.SDR CALA0500166Seat Track · corrodedINSPECTION FOUND SEAT TRACK SECTIONS CORRODED BETWEEN STA 720 AND 740, AT RBL 25 AND RBL 45.5. THE SEAT TRACK SECTIONS WERE REPLACED IAW SRM 51-40-02 AND 51-40-05.SDR UPS05444650Seat Track · corruptedINSPECTION TYPE:C M/D- BS 520-540 LBL 86 SEAT TRACK O/B FLANGE CORRODED. CORROSION BLEND OUT 0.018 X .5 X 10 INCH EXCEED SRM 53-10-01 FIG 1 LIMITS. SEAT TRACK REPAIRED AS PER SRM 53-10-05 FIG 1A FROM BS 480-570 LBL 86.SDR UPS05444647Seat Track · corrodedINSPECTION TYPE:C M/D- BS 760-780 RBL 75 TIE DOWN TRACK FLANGE FOUND CORROSION. CORROSION BLEND OUT 0.029 X .5 X 4 INCH EXCEED SRM 53-10-01 FIG 1 LIMITS. M/D BS 750-870 RBL 75 TIE DOWN TRACK REPAIRED AS PER SRM 53-10-05 FIG 1A.SDR UPS05444644Seat Track · corrodedINSPECTION TYPE:C M/D - BS 680-700 RBL 11 SEAT TRACK O/B FLANGE CORRODED. CORROSION BLEND OUT 0.024 X .5 X 5 INCH EXCEED SRM 53-10-01 FIG 1 LIMITS. M/D BS 630-770 RBL 11 TIE DOWN TRACK REPAIRED AS PER SRM 53-10-05 FIG 14.SDR UPS05444643Seat Track · corrodedINSPECTION TYPE:C M/D - BS 728, RBL 11 SEAT TRACK O/B FLANGE CORRODED. CORROSION BLEND OUT 0.025 X .75 X 3 INCH EXCEED SRM 53-10-01 FIG 1 LIMITS. M/D - BS 630 - BS 770 RBL 11 TIE DOWN TRACK REPAIRED AS PER SRM 53-10-05 FIG 14.SDR UPS05444642Seat Track · corrodedINSPECTION TYPE:C M/D - BS 630-670 RBL 11 TIE DOWN TRACK CROWN & FLANGE FOUND CORROSION. CORROSION BLEND OUT 0.025 X .5 X 2 INCH EXCEED SRM 53-10-01 FIG 1 LIMITS. M/D BS 630-770 RBL 11 TIE DOWN TRACK REPAIRED AS PER SRM 53-10-05 FIG 14.SDR UPS05444627Seat Track · corrodedINSPECTION TYPE:C M/D - BS 860-980 RBL 97 SEAT TRACK I/B FLANGE CORRODED. CORROSION BLEND OUT: 0.028 X 1 X 2 INCH. SEAT TRACK REPAIRED AS PER SRM 53-10-05 FIG 1A FROM BS 850-990 RBL 97 INCH.SDR UPS05444626Seat Track · corrodedINSPECTION TYPE:C M/D - BS 860 LBL 75 SEAT TRACK O/B FLANGE CORRODED. CORROSION BLEND OUT: 0.021 X 1 X 1.75 INCH. SEAT TRACK REPAIRED AS PER SRM 53-10-05 FIG 1A FROM BS 850 - 870 LBL 75 INCH.SDR UPS05444617Seat Track · corrodedBS 720-740 LBL 75 SEAT TRACK O/B FLANGE CORRODED. CORROSION BLENDED OUT. EXCEEDED SRM 53-10-01 FIG 1 LIMITS, SEAT TRACK REPAIRED AS PER SRM 53-10-05 FIG 1A FROM BS 670-770 LBL 75.SDR UPS05444614Seat Track · corrodedBS 830 RBL 11 SEAT TRACK FLANGE CORRODED. CORROSION BLENDED OUT. EXCEEDED SRM 53-10-01 FIG 1 LIMITS, SEAT TRACK REPAIRED AS PER SRM 53-10-05 FIG 14.SDR UPS05444613Seat Track · corrodedBS 770- 800 RBL 11 SEAT TRACK I/B FLANGE CORROSION. CORROSION BLENDED OUT. EXCEEDED SRM 53-10-01 FIG 1 LIMITS, SEAT TRACK REPAIRED AS PER SRM 53-10-05 FIG 14.SDR UPS05444608Seat Track · corrodedBS 890-910 RBL 11 SEAT TRACK O/B FLANGE CORRODED. CORROSION BLEND OUT 0.025 BY 0.5 BY 3.0 IN. EXCEED SRM 53-10-01 FIG 1 LIMITS, M/D BS 890 - BS 1000 RBL 11 SEAT TRACK REPAIRED AS PER SRM 53-10-05 FIG 14 WORK DETAIL REF NRC NR 6392.SDR UPS05444605Cargo Track · corrodedBS 525-610 RBL 11 TIE DOWN TRACK FLANGE ANCHOR NUTS AREA FOUND CORROSION. CORROSION BLEND OUT 0.025 BY 1.0 BY 9.0 IN. EXCEED SRM 53-10-01 FIG 1 LIMIT. M/D BS 510- BS 630 RBL 11 TIE DOWN TRACK REPAIRED AS PER SRM 53-10-05 FIG 14.SDR UPS05444600Seat Track · corrodedBS 778 LBL 33 SEAT TRACK I/B FLANGE CORRODED. CORROSION BLEND OUT 0.026 BY 0.5 BY 0.5 IN. EXCEED SRM 53-10-01 FIG 1 LIMITS, SEAT TRACK REPAIRED AS PER SRM 53-10-05 FIG 1A FROM BS 770-810 LBL 33.SDR UPS05444599Cargo Track · corrodedBS 550- 570 LBL 32 TIE DOWN TRACK FLANGE FOUND CORROSION. CORROSION BLEND OUT 0.048 BY 0.4375 BY 1.0 IN. EXCEED SRM 53-10-01 FIG 1 LIMITS, TIE DOWN TRACK REPAIRED AS PER SRM 53-10-05 FIG 1A.SDR UPS05444547Cargo Track · crackedINSPECTION TYPE:C M/D - BS 520, LBL 11, TIE DOWN TRACK FOUND HEAVY CORROSION CRACK (CRACK LENGTH 2.5 X 1 INCH). TIE DOWN TRACK REPAIRED AS PER SRM 53-10-05.SDR UPS05444546Seat Track · crackedINSPECTION TYPE:C M/D- BS 640 - 660 RBL 75 SEAT TRACK I/B FLANGE CORROSION CRACKED (CRACK LENGTH 1 INCH CORROSION CRACK). M/D BS 640-670 RBL 75 SEAT TRACK REPAIRED AS PER SRM 53-10-05 FIG 1A.SDR UPS05444544Seat Track · corrodedINSPECTION TYPE:C M/D - BS 756 RBL 33 SEAT TRACK O/B FLANGE CORRODED. CORROSION BLEND OUT 0.039 X .875 X 1.25 INCH EXCEED SRM 53-10-01 FIG 1 LIMIT, M/D BS 670 - 770 RBL 33 SEAT TRACK REPAIRED AS PER SRM 53-10-05 FIG 1A.SDR UPS05444538Seat Track · corrodedINSPECTION TYPE: C M/D - BS 600-640 LBL 90 SEAT TRACK OB FLANGE COR. CORROSION BLEND OUT 0.034 INCH X .8750 INCH X 0.5 INCH EXCEED SRM 53-10-01 FIG 1 LIMIT. M/D SEAT TRACK REPAIRED IAW SRM 53-10-05 FIG 1A AT BS 570-640 LBL 90.SDR UPS05444537Seat Track · corrodedINSPECTION TYPE: C M/D - BS 782 RBL 33 SEAT TRACK IB FLANGE COR. CORROSION BLEND OUT 0.022 INCH X 0.5 INCH X 0.5 INCH EXCEED SRM 53-10-01 FIG 1 LIMIT. M/D - RBL 33 INCH SEAT TRACK REPAIRED IAW SRM 53-10-05 FIG 1A BTN BS 770-810.SDR ASAA0540254Cargo Track · corrodedCORROSION AFT CARGO BAY, TIE DOWN ON FLOOR TRACK. REMOVED DAMAGE AND INSTALLED NEW TRACK IAW SRM. (K)SDR UPS05444648Seat Track · corrodedINSPECTION TYPE:C M/D- BS 862 RBL 74 SEAT TRACK FLANGE CORROSION. CORROSION BLEND OUT 0.035 X 1.5 X 1.5 INCH EXCEED SRM 53-10-01 FIG 1 LIMITS. M/D BS 750-870 RBL 75 TIE DOWN TRACK REPAIRED AS PER SRM 53-10-05 FIG 1A.SDR UPS05444646Seat Track · corrodedINSPECTION TYPE:C M/D- BS 1040-1090 LBL 10 SEAT TRACK FLANGE CORROSION. CORROSION BLEND OUT 0.040 X 1 X 1.75 INCH EXCEED SRM 53-10-01 FIG 1 LIMITS. M/D BS 1000-1110 LBL 10 SEAT TRACK REPAIRED AS PER SRM 53-10-05 FIG 34.
Back to JASC 5347