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 UPS04M42064Seat Track · damagedINSPECTION TYPE:C CABIN SEAT TRACK AT STA 996 RBL 76 FLOOR PANEL ATTACHMENT HOLE FOUND ELONGATED. DAMAGED SEAT TRACK PORTION REMOVED AS PER SRM 51-31-01 V2 REV 34. HFEC REWORK CARRIED OUT & NEW SEAT TRACK FABRICATED AS PER SRM 53-70-00 FIG 1 VOL 1 REV 34. NSDR CALA0400215Cargo Track · corrodedINSPECTION FOUND LOWER RAIL IN FORWARD CARGO COMPARTMENT CORRODED AT STA 500D. THE RAIL WAS REPLACED IAW SRM 51-40-02.SDR 04FDEA00572Seat Track · corrodedMAIN CABIN AT FS 835 - 870 AT LBL 8.5 SEAT TRACK HAS CORROSION AFT INBOARD FLANGE. REMOVED CORRECTED SECTION OF SEAT TRACK. FABRICATED NEW SECTION OF SEAT TRACK AND INSTALLED IAW DC10 SRM 53-42-01 VOL 1, DC10 SRM 53-70-00 VOL 1 AND DC10 SRM 51-21-01 VOL 2.SDR ASAA0440054Seat Track · corrodedGYR - FOUND MAIN DECK SEAT TRACK AT STATION 344 LBL 26.5 UPPER SURFACES OF INBOARD AND OUTBOARD FLANGES CORRODED. REPAIRED SEAT TRACK AT STATION 344 LBL 26.5. (M)SDR ASAA0440061Seat Track · corrodedGYR - MAIN DECK SEAT TRACK AT STATION 344 LBL 45.6 UPPER SURFACE OF INBOARD AND OUTBOARD FLANGES FOUND CORRODED. REPAIRED SEAT TRACK AT STATION 344 LBL 45.6 IAW SRM 737 53-00-52. (M)SDR UPS04842185Seat Track · corrodedINSPECTION TYPE:C1 CABIN STA 650 SEAT TRACK PITTED LBL 60. REMOVED CORRODED IAW DC8 SRM 51-1-8, OUT OF LIMITS IAW DC8 SRM 53-2-3. ROUTED OUT DAMAGED IAW UPS DC8 SRM 53-2-3. LOCATED AND DRILLED HOLES IN SEAT TRACK TO LOCATE PLUG AND CHANNEL IAW UPS DC8 SRM 5SDR MALA040227Seat Track · corrodedWHILE REMOVING EMERGENCY FLOOR TRACK LIGHTING STRIP, NOTED CORROSION ON LT AND RT CENTER AISLE SEAT TRACKS WEBS AT APPROXIMATELY STA 303. REMOVED CORROSION FROM LT & RT CENTER AISLE FWD SEAT TRACKS AND REPAIRED IAW 01-04031 CARD 210633 FOR DETAILS.SDR CALA0400200Cargo Track · damagedINSPECTION FOUND LT TIE DOWN RAIL LOWER FLANGE DAMAGED BY A SCREW JUST AFT OF STA 867 AND ABOVE STRINGER 27L. A NEW TIE DOWN RAIL WAS INSTALLED IAW SRM 53-00-53.SDR CALA0400199Cargo Track · damagedINSPECTION FOUND LT TIE DOWN RAIL LOWER FLANGE DAMAGED BY A SCREW BETWEEN STA 747-767 ABOVE STRINGER 29L. A NEW TIE DOWN RAIL WAS INSTALLED IAW SRM 53-00-53.SDR UPS04842159Seat Track · corrodedINSPECTION TYPE:C1 MAIN CABIN SEAT TRACK DAMAGED AT STA 319 LBL 24 DOT A5804. BLEND CORROSION IAW DC8 SRM 51-1-8; OUT OF LIMITS IAW DC8 SRM 53-2-3; ROUTED OUT SEAT TRACK IAW DC8 SRM 53-2-3 FIG D; ALODINED AND PRIMED IAW DC8 SRM 51-1-8. INSTALLED PLUG AND CHASDR UPS04842152Seat Track · gougedINSPECTION TYPE: C1, MAIN CABIN FS 1220 SEAT TRACK -E- GOUGED ON SCALLOPS. BLENDED GOUGED AREA IAW DC8 SRM 53-2-0. OUT OF LIMITS IAW DC8 SRM 53- 2-3. REMOVED SEAT TRACK STA 1180-1280. RECEIVED NEW SEAT TRACK AND FITTING. CUT AND DRILLED SEAT TRACK AND FISDR HNAA0400020Seat Track · corrodedCORROSION, RT SEAT RAIL FLOOR FLANGE FOR RT LOWER FLOOR PANEL IS CORRODED FROM X560 TO X600 WITH PREVIOUS BLENDING.SDR UPS04M42066Seat Track · corrodedINSPECTION TYPE:C CABIN SEAT TRACK STA 899 TO 919, X=8.50 LEFT FOUND CORROSION. CORRODED SEAT TRACK FROM STA 899-919 X=8.5 LEFT FOUND EXCEED LIMIT AS PER SRM 53-70-00, V1, R34. DAMAGED AREA TRIMMED FROM STA 860-939. NEW SEAT TRACK & SPLICE FAB 2/EA AS PER 5SDR MALA040216Seat Track · corrodedDURING 4Y/2Y INSPECTION, LEFT I/B SEAT TRACK AT STA 295 HAS CORROSION. REMOVED DAMAGED SEAT TRACK SECTION AT STA 295, CUT-DRILLED, DEBURR-TREATED, SEAT TRACK, INSTALLED NEW FABRICATED SEAT TRACK IAW EO S53060. A/C RELEASE DATE 3/1/04.SDR MALA040215Seat Track · corrodedDURING 4Y/2Y INSPECTION, RIGHT I/B SEAT TRACK AT STA 295 HAS CORROSION. REMOVED DAMAGED SEAT TRACK SECTION AT STA 295, CUT-DRILLED, DEBURR-TREATED, SEAT TRACK, INSTALLED NEW FABRICATED SEAT TRACK IAW EO S53060. A/C RELEASE DATE 3/1/04.SDR ASAA0480104Seat Track · corrodedOKC - DURING HV6 CHECK, FOUND SEAT TRACK IS CORRODED AT FS 236-266. REPLACED DAMAGED SECTION PER SRM 51-30-1 AND 51-30-5. (M)SDR ASAA0480103Seat Track · corrodedOKC - DURING HV6 CHECK, FOUND SEAT TRACK IS CORRODED AT FS 236-313. REPLACED DAMAGED SECTION PER SRM 51-30-1 AND 51-30-5. (M)SDR UIEA200400023Seat Track · crackedFORWARD CARGO COMPARTMENT SEAT TRACK CRACKED AT BS 576, APPROX RBL 48. REMOVED DAMAGED SEAT TRACK AS PER 747 SRM 51-30-01. INSTALLED SECTION OF SEAT TRACK IN FORWARD CARGO COMPARTMENT AT BS 576 RBL 48 P/N 65B601176-54. P/O NR 5075 LOT NR 01511488 REF 53-10-SDR MALA040262Seat Track · corrodedDURING INSPECTION IN LCQ, SEAT TRACK NR 3 CORRODED FRAME 18-20. REMOVED AND REPLACED CORRODED SECTION OF SEAT TRACK IAW MESABA EO A53026. A/C RELEASE DATE 3/10/04.SDR MALA040263Seat Track · corrodedDURING INSPECTION IN LCQ, SEAT TRACK NR 4 CORRODED FRAME 18-20. REMOVED AND REPLACED CORRODED SECTION OF SEAT TRACK IAW MESABA EO A53026. A/C RELEASE DATE 3/10/04.SDR MALA040261Seat Track · corrodedDURING INSPECTION IN LCQ, SEAT TRACK NR 2 CORRODED FRAME 18-20. REMOVED AND REPLACED CORRODED SECTION OF SEAT TRACK IAW MESABA EO A53026. A/C RELEASE DATE 3/10/04.SDR MALA040243Seat Track · corrodedFS 295 LEFT I/B SEAT TRACK CORRODED. REMOVED AND REPLACED CORRODED SECTION OF SEAT TRACK IAW MESABA EO S53060. A/C RELEASE DATE 3/8/04.SDR MALA040242Seat Track · corrodedFS 295 RIGHT I/B SEAT TRACK CORRODED. REMOVED AND REPLACED CORRODED SECTION OF SEAT TRACK IAW MESABA EO S53060. A/C RELEASE DATE 3/8/04.SDR GTIA040216Seat Track · corrodedFTW - FOUND MAIN CABIN SEAT TRACK LBL 24 INCHES STATION 1307 TO STATION 1130 HAS CORROSION. REMOVED SEAT TRACK SECTION STATION 1068-1307. FABRICATED NEW SEAT TRACK. FABRICATED NEW SEAT TRACK. FABRICATED SPLICE SECTION REPAIR STATION 1140 AND 1260. INSTALLSDR GTIA040233Seat Track · corrodedFTW - FOUND MAIN CABIN SEAT TRACK RBL 24 INCHES STATION 200 TO 256 HAS CORROSION. REMOVED SEAT TRACK STATION 200 TO 265. LOCATED AND DRILLED NEW SEAT TRACK. INSTALLED SEAT TRACK. (M)SDR GTIA040202Seat Track · corrodedFTW - FOUND MAIN CABIN SEAT TRACK LBL 38 STATION 1136 TO STATION 1097 HAS CORROSION. REMOVED OUT OF LIMITS SEAT TRACK, LBL 38 STATION 1136-1097. FABRICATED NEW TRACK. INSTALLED TRACK. (M)SDR GTIA040201Seat Track · corrodedFTW - FOUND MAIN CABIN SEAT TRACK RBL 44 INCEHS STATION 200 TO 256 HAS CORROSION. SEAT TRACK RBL 44 STATION 200-245 OUT OF LIMITS. FABRICATED NEW SEAT TRACK SECTION AND SPLICE. INSTALLED SECTION OF SEAT TRACK AND SPLICE. (M)SDR MALA040199Seat Track · corrodedDURING 4K INSPECTION IN LCQ, LT I/B SEAT TRACK STA 297 HAS CORROSION. MAINTENANCE REMOVED AND REPLACED CORRODED SECTION OF SEAT TRACK IAW MESABA EO S53060. A/C RELEASE DATE 2/20/04.SDR GTIA040171Seat Track · corrodedFTW - FOUND LEFT CABIN INBOARD SEAT TRACK CORRODED AND WORN STATION 200-1307. REMOVED CORROSON LEFT CABIN INBOARD SEAT TRACK STATION 200-1307. REMOVED SEAT TRACK STATION 200 TO SPLICE STATION 260. LOCATED AND DRILLED NEW SEAT TRACK STATION 200 TO SPLICE STASDR CALA0400123Cargo Track · corrodedINSPECTION FOUND AFT BAGGAGE BIN TIE DOWN RAIL CORRODED AT FASTENER HOLES FROM STA 787-847. THE TIE DOWN RAIL WAS REMOVED AND REPLACED IAW SRM 51-40-02 AND 53-00-53.SDR USAA040022Seat Track · corrodedFOUND SEAT TRACK CORRODED 3 INCHES, BS 1087 AT LBL 88. FABRICATED AND INSTALLED SEAT TRACK AND REPAIR SPLICE PE SRM 53-00-52. (M)SDR GTIA040199Seat Track · corrodedFTW - FOUND LEFT INBOARD SEAT TRACK CORRODED SEVERAL AREAS FROM FS 297-1022. AFTER FURTHER INSPECTION FOUND LEFT INBOARD SEAT TRACK CORRODED AND OUT OF LIMITS FROM FS 1022 TO FS 1039. FABRICATED SEAT TRACK SECTION. INSTALLED SEAT TRACK SECTION AND SPLICE. SDR GTIA040200Seat Track · corrodedFTW - FOUND RIGHT OUTBOARD SEAT TRACK CORRODED SEVERAL AREAS FROM FS 237-1309. FS 351-807 AND FS 1032-1309 OUT OF LIMITS. REMOVED SEAT TRACK BETWEEN STATION 351-798 AND STATION 1032-1309. FABRICATED SEAT TRACK SEC'S FS 200-807 AND REPAIR SPLICES. FABRICATESDR UPS04241976Seat Track · corrodedINSPECTION TYPE:C, CORROSION ON SEAT TRACK AT BEARSTRAP LOCK PIN LOCATION, BS 950 RBL 4 5.5. FABRICATED AND INSTALLED NEW SEAT TRACK SECTION IAW SRM 53-10-5. REPAIR CARRIED OUT IAW SRM EO 2004-017-001 UPS ENGINEERING FILE 727-53-20136.SDR AWXA200400210Seat Track · corrodedMCN - MAJOR REPAIR - DURING C-04 CHECK CORROSION WAS FOUND IN TWO PLACES ON LT OUTBOARD SEAT TRACK AT FR 33, Y1292. MAINTENANCE REMOVED DAMAGED SECTION OF SEAT TRACK AT FR 33, Y1292; FABRICATED A FILLER, DOUBLER, AND 2 EACH L-PROFILES; INSTALLED REPAIR PARTS SDR MALA040208Seat Track · corrodedFS 294 LT SEAT TRACK HAS CORROSION. REMOVED AND REPLACED CORRODED SECTION OF SEAT TRACK IAW EO NR S53060. A/C RELEASE DATE 2/26/04. REFER TO LOG PAGE NR 1264969 FOR ADDITIONAL INFORMATION.SDR AWXA200400192Seat Track · corrodedMCN - MAJOR REPAIR - DURING B-04 CHECK GALVANIC CORROSION WAS FOUND ON FLOORBEAM SEAT RAIL AT FR 66, Y1292 RT. MAINTENANCE REMOVED DAMAGED FLOORBEAM SEAT RAIL AT FR 66, Y1292 RT; FABRICATED A NEW REPLACEMENT FLOORBEAM SEAT RAIL; INSTALLED REPAIR PART IAW A320SDR AWXA200400189Seat Track · corrodedDURING B-04 CHECK CORROSION WAS FOUND ON UPPER AND LOWER SURFACE OF FLOOR BEAM TEE CAP (SEAT TRACK) AT CLIP NUT LOCATIONS BETWEEN FR 17 AND FR 20, Y1292 RT. MAINTENANCE REMOVED DAMAGED SEAT TRACK BETWEEN BS 7830 AND BS 8000, Y1292 RT; FABRICATED 6 EACH REPASDR 04FDEA00387Seat Track · corrodedFWD CABIN SEAT TRACK CORRODED FROM STA 459 TO 495 -X27.5. FWD CABIN SEAT TRACK CORRODED FROM STA 459 TO 495 -X27.5 CARRIED OUT SECTIONAL REPLACED FROM STA 450 TO 525 -X27.5 AS PER MD11 SRM 53-70-00 FIG1 V1, PERFORMED NDT INSPECTION ON TRIMMED AREA CRACK SDR 04FDEA00381Seat Track · corrodedCORROSION ON CABIN SEAT TRACK AT X27.5 STA 459 TO 480. CORROSION ON CABIN SEAT TRACK AT X27.5 STA 459 TO 480 SECTIONAL REPLACED FROM STA 450 TO STA 525 AS PER MD11 SRM 53-70-00 FIG1 VOL1.SDR F3LA200400009Mount · corrodedDURING C-7 CHECK, INSPECTION REPORTED FWD LAVATORY MOUNT BLOCK AT STA 303, LBL 12, CORRODED. REPLACED LAVATORY MOUNT PER SRM 53-10-15, SRM 53-10-51 AND DRAWING 65C33970.SDR CALA0400076Seat Track · corrodedINSPECTION FOUND FORWARD ENTRY SEAT TRACK CORRODED FROM STA 270-294.5, RBL 40. THE SEAT TRACK WAS REMOVED AND A NEW SEAT TRACK WAS INSTALLED IAW SRM 51-40-02.SDR ARWA20040201Cargo Track · corrodedDURING C-CHECK INSPECTION THE FOLLOWING WAS FOUND; AFT LOWER CARGO COMPARTMENT BETWEEN STA 940.000 AND STA 1500.000, RBL 58.5 INCHES TRACK WR SECTION WITH CORROSION. REMOVED CORROSION IN ACCORDANCE WITH DC-8 SRM 51-1-8, FOUND TO BE OUT OF LIMITS IN ACCORDANCE SDR 373PA0045Seat Track · corrodedCORROSION ON AFT END OF LEFT INBOARD SEAT TRACK OF AFT GALLEY. REPAIRED PER SRM 53-00-52.SDR 373PA0028Seat Track · corrodedCORROSION UNDER SEAT TRACK RBL 45 STA 328 TO STA 344. REPAIRED SEAT TRACK PER SRM 53-00-52, FIG 202.SDR QXEA200400104Seat Track · chafedPDX - NR 5 SEAT TRACK INBOARD FLANGE HAS A CHAFE AT X434. REPAIRED IAW DHC-8-200 SRM 51-20-16 AND SRM 51-20-26.SDR ASAA0480062Seat Track · corrodedOKC - DURING 15K CHECK, FOUND RIGHT INBOARD SEAT TRACK IS CORRODED AT FS 200-247. REPLACED SEAT TRACK PER SRM 53-05. (M)SDR ASAA0480060Seat Track · corrodedOKC - DURING 15K CHECK, FOUND LEFT OUTBOARD SEAT TRACK IS CORRODED AT FS 1106-1185. REPLACED DAMAGED TRACK PER SRM 51-10-4 AND 51-30-5. (M)SDR ASAA0480058Seat Track · corrodedDURING 15K CHECK, FOUND LEFT INBOARD SEAT TRACK IS CORRODED AT FS 1098-1165. REPLACED SEAT TRACK PER SRM 51-10-4 AND 51-30-5. (M)SDR QXEA200400105Seat Track · corrodedPDX - RIGHT HAND INBOARD SEAT TRACK HAS PITTING CORROSION ON TOP END FROM FS 220.00 TO FS 246.00. REPAIRED IAW DHC-8-200 SRM 51-40-11.
Back to JASC 5347