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 DHL2008760518Seat Track · corrodedREMOVED, FABRICATED, AND REPLACED SEAT TRACK SECTION AT LBL 24, FROM BS 690 TO 740, PER B727 SRM 53-10-2 FIG 7 AND 53-10-5 FIG 1.SDR DHL2008760517Seat Track · corrodedREMOVED, FABRICATED, AND REPLACED SEAT TRACK SECTION AT LBL 45, FROM BS 690 TO 740, PER B727 SRM 53-10-2 FIG 7 AND 53-10-5 FIG 1.SDR DHL2008760515Seat Track · corrodedREMOVED, FABRICATED, AND REPLACED SEAT TRACK SECTION AT LBL 24, FROM BS 480 TO 690, PER B727 SRM 53-10-2 FIG 7 AND 53-10-5 FIG 1.SDR DHL2008760514Seat Track · corrodedREMOVED, FABRICATED, AND REPLACED SEAT TRACK SECTION AT LBL 45, FROM BS 480 TO 690, PER B727 SRM 53-10-2 FIG 7 AND 53-10-5 FIG 1.SDR SIMA200812107Seat Track · corrodedDURING A HMBV INSPECTION, THE SEAT TRACK AT BL 0.0 WAS FOUND TO BE CORRODED BETWEEN FS 297 TO FS 314. REMOVED 31 OF SEAT 31 OF SEAT TRACK FROM FS 297 TO FS 328. POSITIONED SPLICE SECTION P/N 7253799-381 AND U-BEAM REPAIR PIECE. TREATED AND INSTALLED IAW SAASDR UPS08852089Seat Track · wornINSPECTION TYPE:C3 STOP HOLES WORN, ROUNDED ON PILOTS LOWER SEAT TRACKS. REMOVED AND REPLACED LOWER SEAT TRACKS IAW SRM 51-3-1, 51-1-20D, 51-1- 24, 51-1-8.SDR TRAX200800546Seat Track · corrodedLEFT CABIN FLOOR SEAT TRACK STARTING AT FS 394.00 HAS CORROSION DAMAGE. REMOVED CORROSION FROM SEAT TRACK. BLENDED OUT OF LIMITS PER 53-21-49.SDR TRAX200800547Seat Track · corrodedRIGHT CABIN FLOOR SEAT RAIL STARTING AT FS 379.00 HAS CORROSION DAMAGE. JOB COMPLETE. BLENDED AREAS OF CORROSION STARTING AT FS 379.00 TO WITHIN LIMITS & ALODINED BLENDED AREAS PER CRJ 200 SRM 53-21-49
SP 7025126 04/18/2008. SUPPLEMENTAL SDR CLOSED 4/21/08SDR TRAX200800545Seat Track · corrodedRIGHT CABIN FLOOR SEAT RAIL STARTING AT FS 394.00 HAS CORROSION DAMAGE. JOB COMPLETE. BLENDED AREAS OF CORROSION STARTING AT FS 394.00 TO WITHIN LIMITS & ALODINED BLENDED AREAS PER CRJ 200 SRM 53-21-49
SP 7025126 04/18/2008. SUPPLEMENTAL SDR CLOSED 4/21/08SDR TRAX200800548Seat Track · corrodedLEFT CABIN FLOOR SEAT RAIL STARTING AT FS 379.00 HAS CORROSION DAMAGE.SDR 08FDEA01427Seat Track · misrepairedPREVIOUS REPAIR LOCATED ON MAIN CABIN SEAT TRACK NR 4 RT -Y1456 BETWEEN FRAMES 62 TO 63, HAS 2 EACH REPAIR SPLICES MEASURING 7 IN LONG BY 3 IN TALL AND 1 REPAIR SECTION 52 IN LONG FROM FRAME 65 TO BETWEEN FRAMES 62 AND 63. REPAIR NOT IAW SRM REQUIREMENTS. RESDR UPS08852129Seat Track · corrodedINSPECTION TYPE:C1 CABIN STA 840, LBL60, SEAT TRACK FLANGE HAS CORROSION CUT OUT CORROSION FABBED AND INSTALLED SEAT TRACK SPLICE IAW, SRM 53- 2-3, 510108, 5101020D.SDR TRAX200800541Seat Track · corrodedSEVERAL SEAT TRACKS IN CARGO COMPARTMENT HAVE CORROSION DAMAGE. JOB COMPLETE. REMOVED SEAT TRACKS AND INSTALLED NEW IAW CRJ200 SRM 53-41-49 COMPLETE. SUPPLEMENTAL SDR CLOSED 4/21/08.SDR 08FDEA01399Seat Track · damagedDURING MD10 ACF MODIFICATION IN UPPER FUSELAGE AT STA.939 X -47.50 FOUND SEAT TRACK WITH HOLE OVALIZED REPAIRED FOR SRM 53-70-00 FIG 1 VOL I.SDR USAA920081027Seat Track · corrodedMIA - MAJOR REPAIR - C4 CHECK - LEVEL 2 CORROSION ON CABIN SEAT TRACK, BS 764 - BS 820, RBL 86. REPLACED CABIN SEAT TRACK, BS 764 - BS 820, RBL 86.SDR UPS08852064Seat Track · damagedINSPECTION TYPE:C1 SEAT TRACK STA 960 RIGHT, DAMAGED MDCC RBL48. CUT OUT DAMAGE AND INSTALL PLUG IAW SRM 51-1-8, 53-2-3 FIG 6D.SDR UPS08852232Seat Track · damagedINSPECTION TYPE:C1 SEAT TRACK LBL 45 DAMAGED IN SEVERAL AREAS AT MCD BALL MAT AREA. REMOVED AND REPLACED 3 EACH SEAT TRACK PLUGS IAW, SRM 53-2-3 FIG 6D, 51 -1-8.SDR DHL2008760532Seat Track · corrodedREMOVED, FABRICATED, AND INSTALLED NEW SEAT TRACK SECTION AT RBL 24, BS 480 TO 690, PER B727 SRM 53-10-5 FIG 1 AND 53-10-2 FIG 7.SDR IXXA08SMN123SCargo Track · corrodedDURING ROUTINE C CHECK INSPECTION, FOUND MAIN CARGO COMPARTMENT NUMBER 3 TRACK WITH CORROSION AT STATION 590.000. REMOVED CORROSION. FOUND OUT OF LIMITS. REMOVED DAMAGED EXINTING SPLICES (FWD SIDE) AND REMOVED SEGMENT OF DAMAGED TRACK. FABRICATED SPLICES. SDR IXXA08SMN122SCargo Track · wornDURING ROUTINE C CHECK INSPECTION, FOUND MAIN CARGO COMPARTMENT NUMBER 4 TRACK WITH LUGS WORN AT STATION 685.000. REMOVED EXISTING SPLICES (FWD SIDE) AND REMOVED SEGMENT OF DAMAGED TRACK AFT SIDE. FABRICATED SPLICES. CLEANED, TREATED AND PRIMED AREA AND REPSDR IXXA08SMN121SCargo Track · wornDURING ROUTINE C CHECK INSPECTION, FOUND MAIN CARGO COMPARTMENT NUMBER 4 TRACK WITH LUGS WORN AT STATION 310.000 - 425.000. REMOVED DAMAGED SEGMENT OF TRACK AND EXISTING SPLICES. CLEANED, TREATED AND PRIMED AREA AND EXISTING SPLICES. INSTALLED SEGMENT OF NESDR UPS08852063Seat Track · wornINSPECTION TYPE:C1 FLIGHT COMPARTMENT, FIRST OFFICERS LWR APT SEAT TRACK HAS ELONGATED HOLES. REMOVED AND REPLACED SEAT TRACKS IAW SRM 51-1-20D, 51-1-8, 53-0-1.SDR UIEA200800120Seat Track · wornMAIN DECK STA 1625 TO 1680 RBL 11 SEAT TRACK FOUND WORN. SEAT TRACK REPAIRED PER SRM 53-10-05.SDR UIEA200800118Seat Track · brokenMAIN DECK BS 1720 TO 1760 LBL 11 SEAT TRACK FOUND BROKEN AND WORN, SEAT TRACK REPAIRED PER SRM 53-10-05 FIG 14.SDR 08FDEA01384Seat Track · corrodedCORROSION ON SEAT TRACK AT STA 1266, STA 1280, RBL 24. SEAT TRACK AT STA 1266 TO STA 1280, RBL 24 REPLACED NEW TRACK AS PER B757-200 SRM 51-10-02 REV 93. REPAIR CLASSIFIED AS MINOR PER GMM 6-2-100 CRITERIA.SDR 08FDEA01382Seat Track · corrodedMCD SEAT TRACK RBL 77 BETWEEN STA 840 TO 920 IS IN BARE METAL AND SUPERFICAL CORROSION. REMOVED LIGHT CORROSION FOUND TO BE OUT OF LIMITS IAW SRM 53-70-00. REMOVED AND INSTALLED NEW TRACK IAW SRM 53-70-00. FABBED NEW TRACK AND SPLICE ON TRAVELERS T8/733283 SDR 08FDEA01381Seat Track · gougedMCD SEAT TRACK RBL 27 STA 755 HAS A LOBE GOUGED. BLENDED DAMAGE FOUND TO BE OUT OF LIMITS IAW SRM 53-70-00. REMOVED AND INSTALLED NEW TRACK IAW SRM 53-70-00. NEW TRACK AND SPLICE FABBED ON TRAVELER T8/733018 AND T8/733020. REMOVED AND REINSTALLED AND SEALESDR 08FDEA01380Seat Track · gougedMCD SEAT TRACK LBL 7 STA 1691 HAS TWO LOBES GOUGED BLENDED DAMAGED AREA FOUND TO BE OUT OF LIMITS IAW SRM 53-70-00. NEW TRACKED FABBED ON TRAVELER T8/732523, NEW SPLICE FABBED ON TRAVELER T8/732524. TRACK INSTALLED IAW SRM 53-70-00.SDR 08FDEA01379Seat Track · damagedPREVIOUS REPAIR LOCATED ON MAIN CABIN SEAT TRACK NR 2 LT Y450 BETWEEN FRAMES 51 TO 52 HAS 2 EA REPAIR SPLICES MEASURING 7 IN LONG BY 3 IN TALL AND 1 REPAIR SECTION 51.9 IN LONG FROM FR 54 TO BETWEEN FRAMES 51 AND 52 REPAIR NOT IAW SRM REQUIREMENTS. REMOVED PRSDR UIEA200800153Seat Track · chafedMAIN DECK STA 1760 TO 1890 LBL 11 SEAT TRACK FOUND CHAFED. SEAT TRACK SMOOTHED OUT PER SRM 51-10-01 AND REPROTECTED PER 51-10-02.SDR USAA920080857Seat Track · crackedPIT - MAJOR REPAIR - C4 CHECK - A 2" CORNER OF SEAT TRACK CRACKED AT BS 780. REPLACED SEAT TRACK (BS 680-790) IAW SRM 51-40-00.SDR 08FDEA01368Seat Track · corrodedMAIN CARGO COMPATRMENT, SEAT TRACK IC CORRODED FROM BS 870-848, LBL 25. REMOVED SEAT TRACK AT MAIN CARGO COMPARTMENT IAW SRM 51-30-2. LOCATED AND DRIILED NEW TRACK, DIM 16 INCH LONG IAW SRM 51-30-5 AND 53-10-2 FIG 7. TREATED AND PRIMED AFFECTED AREAS IAW CSSDR 08FDEA01366Seat Track · corrodedMAIN DECK SEAT TRACK FLANGE BELOW FLOOR PANEL NR 271DF AT STA 5-83, X = 27 FOUND CORROSION AT UPPER SURFACE. REPAIRED BY SECTIONAL SEAT TRACK REPLACEMENT FROM STA 5-0 TO STA 1531, X = 27 AS PER SRM 53-70-00 FIGURE 1 VOLUME I. REPAIR CLASSIFIED AS MAJOR PER SDR 08FDEA01365Seat Track · corrodedMAIN DECK SEAT TRACK FLANGE BELOW FLOOR PANEL NR 271AF AND NR 271BF AT STA 1485 TO STA 1531, X = 8 FOUND CORROSION AT UPPER SURFACE AT 2 LOCATIONS. REPAIRED BY SECTIONAL SEAT TRACK REPLACEMENT FROM STA 1431 TO STA 1531, X = 8 AS PER SRM 53-70-00 FIGURE 1 VOLSDR 08FDEA01364Seat Track · corrodedMAIN DECK SEAT TRACK FLANGE BELOW FLOOR PANEL NR 263EF AT STA 1361, X = 8 FOUND CORROSION AT LOWER SURFACE. CORROSION REMOVED AS PER SRM 51-21-01 VOLUME II AND FOUND WITHIN LIMIT AS PER SRM 53-70-00 FIGURE 3 VOLUME I. ORIGINAL MATERIAL THICKNESS = 0.080", RSDR 08FDEA01363Seat Track · corrodedMAIN DECK SEAT TRACK FLANGE AT STA 1500, X = -8 FOUND CORROSION AT UPPER SURFACE. REPAIRED BY SECTIONAL SEAT TRACK REPLACEMENT PER SRM 53-70-00 FIGURE 3 VOLUME I. REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-100.SDR MALA080054Seat Track · corrodedSEAT TRACK CORRODED. REPLACED AT STA 288 TO 389 ALONG BL 18.3 REPAIRED IAW EO NR S530602.SDR UIEA200800121Seat Track · crackedMAIN DECK STA 1600 TO 1615 RBL 99 SEAT TRACK FOUND CRACKED. SEAT TRACK REPAIRED PER SRM 53-10-05.SDR 08FDEA01359Seat Track · crackedCENTER ARTICULATING SEAT TRACK FITTING AT FRAME 38.2 IS CRACKED. REMOVED FITTING IAW FEDEX A310 SRM 51-40-21; PARA 7. MATERIAL ID FOR BRACKET 7075-T7351 IAW AIRBUS DWG A53781977 AND A310 SRM 51-31-00. MACHINED A FITTING IAW AIRBUS DWG A53781977. ALODINEDSDR 08FDEA01351Seat Track · corrodedUPON REMOVAL OF MAIN DECK FLOOR PANEL 292BF, FOUND SEAT TRACK AT STA 1831 TO STA 1887, X = -75.5 WITH EXFOLIATION CORROSION. CORRODED SEAT TRACK REPAIRED BY SECTIONAL REPLACEMENT PER SRM 53-70-00 FIGURE 1 VOLUME I. REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-100.SDR 08FDEA01350Seat Track · corrodedMAIN DECK SEAT TRACK FLANGE BELOW FLOOR PANEL 262AF AT STA 1159 TO 1245, X = -8 FOUND CORROSION ON UPPER SURFACE. CORRODED SEAT TRACK REPAIRED BY SECTIONAL REPLACEMENT PER SRM 53-70-00 FIGURE 1 VOLUME I. REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-100.SDR 08FDEA01349Seat Track · corrodedMAIN DECK SEAT TRACK FLANGE BELOW FLOOR PANEL NR 263LF AND 263FF AT STA 1310 TO STA 1365, X = -8 FOUND CORROSION AT UPPER SURFACE AT 3 LOCATIONS. CORRODED SEAT TRACK REPAIRED BY SECTIONAL REPLACEMENT PER SRM 53-70-00 FIGURE 1 VOLUME I. REPAIR CLASSIFIED AS MASDR DHL2008760522Seat Track · corrodedREMOVED, FABRICATED, AND REPLACED SEAT TRACK SECTION AT RBL 45, FROM BS 760 TO 850, PER B727 SRM 53-10-2 FIG 7 AND 53-10-5 FIG 1.SDR DHL2008760521Seat Track · corrodedREMOVED, FABRICATED, AND REPLACED SEAT TRACK SECTION AT RBL 24, FROM BS 760 TO 850, PER B727 SRM 53-10-2 FIG 7 AND 53-10-5 FIG 1.SDR DHL2008760520Seat Track · corrodedREMOVED, FABRICATED, AND REPLACED SEAT TRACK SECTION AT LBL 24, FROM BS 760 TO 850, PER B727 SRM 53-10-2 FIG 7 AND 53-10-5 FIG 1.SDR DHL2008760519Seat Track · corrodedREMOVED, FABRICATED, AND REPLACED SEAT TRACK SECTION AT LBL 45, FROM BS 760 TO 850, PER B727 SRM 53-10-2 FIG 7 AND 53-10-5 FIG 1.SDR DHL2008760516Seat Track · corrodedREMOVED AND REPLACED SEAT TRACK SECTION AT RBL 45, FROM BS 480 TO 690, PER B727 SRM 53-10-2 FIG 7 AND 53-10-5 FIG 1.SDR USAA920080885Seat Track · corrodedPIT - MAJOR REPAIR - ULTIMATE BREAKING MODIFICATION - CORROSION ON CABIN SEAT TRACK, BS 808 / FR 20 - BS 950 / BS 24, -Y765. REPLACED CABIN SEAT TRACK, BS 808 / FR 20 - BS 950 / BS 24, -Y765 IAW A319 SRM 53-11-15.SDR UPS08852045Seat Track · wornINSPECTION TYPE:C1 STOP HOLES WORN IN F/E'S AFT SEAT TRACK. REMOVED AND REPLACED SEAT TRACK IAW SRM 51-3-0, 51-1-24, 51-1-8.SDR UPS08852026Seat Track · wornINSPECTION TYPE:C1 BOTH UPPER SEAT TRACKS WORN AT PILOTS SEAT. REMOVED AND REPLACED SEAT TRACKS IAW SRM 51-1-20D, 51-3-1, 51-1-24.
Back to JASC 5347