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 DHL2008760551Seat Track · corrodedREMOVED CORRODED SEAT TRACK, FABRICATED, AND INSTALLED SEAT TRACK SECTION AT BS 950 TO 950D +10, LBL 45.5, PER B727 SRM 53-10-2 FIG 7 AND 53-10-5 FIG 1.SDR USAA920080955Seat Track · corrodedBFM - MAJOR REPAIR - C2 CHECK - CORROSION ON CABIN SEAT TRACK, BS 4895 / FR 59 - BS 5160 / FR 64, +Y450. REPAIRED CABIN SEAT TRACK, BS 4895 / FR 59 - BS 5160 / FR 64, +Y450 IAW A330 SRM 53-00-15.SDR USAA920080954Seat Track · corrodedBFM - MAJOR REPAIR - C2 CHECK - CORROSION ON CABIN SEAT TRACK, BS 4417 / FR 54 - BS 4842 / FR 58, +Y1959. REPAIRED CABIN SEAT TRACK, BS 4417 / FR 54 - BS 4842 / FR 58, +Y1959 IAW A330 SRM 53-00-15.SDR HALA0800552Seat Track · corrodedLEVEL 2 CORROSION ON BOTH TRACK FITTINGS WHERE FEET OF STA 911 PARTITION ATTACHES TO FLOOR. BOTH TRACK FITTINGS REPLACED IAW 767-300 SRM 51-40-02 REV 76 AND DWG 145T5222.SDR 08FDEA01478Seat Track · damagedDURING MD10 ACF MODIFICATION IN UPPER FUSELAGE AT STA 1273 AND X -47.250 FOUND MISSING MATERIAL ON SEAT TRACK. REPAIRED SEAT TRACK FOR SRM 53-10-00 FIG 1 VOL I.SDR UPS08852296Seat Track · wornINSPECTION TYPE:C3 SEAT TRACK WORN LBL 61 STA 930 MAIN CABIN. REPAIRED MAIN CABIN SEAT TRACK AT STA 930 AND LBL 61 IAW SRM 51-1-8 AND SRM 53-02-03-0 FIG 006D.SDR UPS08852269Seat Track · gougedINSPECTION TYPE:C3 CABIN STA 1130 RBL 50 SEAT TRACK SCALLOP IS GOUGED. REPLACED SEAT TRACK PLUG AT STA 1130 AND RBL 50 IAW SRM 51-03-00.SDR UPS08852254Seat Track · damagedINSPECTION TYPE:C3 RT SEAT TRACK DAMAGED RBL 46 FROM STA 380-STA 385. REPAIRED CABIN SEAT TRACK AT RBL 46 STA 380 TO STA 385 IAW SRM 53-02-0 3-FIG 006D, SRM 51-01-08, SRM 51-03-00.SDR UPS08852213Seat Track · damagedINSPECTION TYPE:C3 RIGHT SEAT TRACK DAMAGED RBL 46 FROM STA 400 TO 408. REPLACED SEAT TRACK CHANNEL AND PLUG AT RBL 46 AND STA 400 TO 408 IAW SRM 51-03-00, SRM 53-02-03 FIG 6D, SRM 51-9-00 FIG 065.SDR DHL2008760555Seat Track · corrodedREMOVED CORRODED SEAT TRACK, FABRICATED, AND INSTALLED SEAT TRACK SECTION AT BS 850 TO 870, LBL 45.5, PER B727 SRM 53-10-2 FIG 7 AND 53-10-5 FIG 1.SDR DHL2008760552Seat Track · corrodedREMOVED CORRODED SEAT TRACK, FABRICATED, AND INSTALLED SEAT TRACK SECTION AT BS 870 TO 950, RBL 24.75, PER B727 SRM 53-10-2 FIG 7 AND 53-10-5 FIG 1.SDR DHL2008760549Seat Track · corrodedREMOVED CORRODED SEAT TRACK, FABRICATED, AND INSTALLED SEAT TRACK SECTION AT BS 870 TO 950, LBL 45.5, PER B727 SRM 53-10-2 FIG 7 AND 53-10-5 FIG 1.SDR USAA920080971Seat Track · corrodedBFM - MAJOR REPAIR - C2 CHECK - CORROSION ON CABIN SEAT TRACK, BS 4417 / FR 54 - BS 4682 / FR 57.2, -Y450. REPAIRED CABIN SEAT TRACK, BS 4417 / FR 54 - BS 4682 / FR 57.2, -Y450 IAW A330 SRM 53-31-15.SDR USAA920080938Seat Track · corrodedPIT - MAJOR REPAIR - S3 CHECK - LEVEL 2 CORROSION ON CABIN SEAT TRACK, BS 760/FR 18 - BS 808/FR 20, -Y1292. REPLACED CABIN SEAT TRACK, BS 760/FR 18 - BS 808/FR 20, -Y1292 IAW A321 SRM 53-21-15.SDR UPS08852268Seat Track · gougedINSPECTION TYPE:C3 CABIN STA 1470 RBL46 SEAT TRACK PLUG GOUGED. REMOVED AND REPLACED SEAT TRACK PLUG AT STA 1470 AND RBL46 IAW SRM 51-03-00.SDR DHL2008760556Seat Track · corrodedREMOVED CORRODED SEAT TRACK, FABRICATED, AND INSTALLED SEAT TRACK SECTION AT BS 850 TO 870, LBL 24.75, PER B727 SRM 53-10-2 FIG 7 AND 53-10-5 FIG 1.SDR DHL2008760546Seat Track · corrodedREMOVED, FABRICATED, AND INSTALLED SEAT TRACK SECTION AT BS 960 TO BS 1135, RBL 24, PER B727 SRM 53-10-5 FIG 1 AND 51-30-2.SDR DHL2008760524Seat Track · corrodedREMOVED, FABRICATED, AND REPLACED SEAT TRACK SECTION AT LBL 24, FROM BS 950 +10 TO 1135, PER B727 SRM 53-10-2 FIG 7 AND 53-10-5 FIG 1.SDR IXXA08SMN176SCargo Track · deterioratedDURING ROUTINE C CHECK INSPECTION, FOUND MAIN CARGO COMPARTMENT NUMBER 5 TRACK LUGS DETERIORATED BETWEEN STATION 70.000 AND STATION 210.000. REMOVED DAMAGED SEGMENT OF TRACK AND EXISTING SPLICES. CLEANED, TREATED AND PRIMED AREA AND EXISTING SPLICES. INSTALSDR IXXA08SMN178SCargo Track · deterioratedDURING ROUTINE C CHECK INSPECTION, FOUND MAIN CARGO COMPARTMENT NUMBER 4 TRACK LUGS DETERIORATED AT STATION 70.000 TO 340.000. REMOVED SEGMENT OF DAMAGED TRACK AND EXISTING SPLICES. CLEANED, TREATED AND PRIMED AREA AND EXISTING SPLICES. INSTALLED NEW SEGMENSDR USAA920080916Seat Track · corrodedBFM - MAJOR REPAIR - C2 CHECK, CORROSION ON CABIN SEAT TRACK, BS 4258 / FR 53.7 - BS 4417 / FR 54, -Y450. REPAIRED CABIN SEAT TRACK, BS 4258 / FR 53.7 - BS 4417 / FR 54, -Y450 IAW A330 SRM 53-31-15.SDR QXEA200800421Seat Track · corrodedPDX C4 CHECK. CORROSION ON SEAT TRACK NR 4 CAMLOCK RECEP. STA X222. REMOVED NR 4 SEAT TRACK IAW -8 200 SRM 51-40-11. DRILLED UP AND INSTALLED NEW TRACK IAW -8 200 SRM 51-40-00, 51-40-11 AND RD8-53-1102.SDR QXEA200800420Seat Track · corrodedPDX C4 CHECK. SURFACE CORROSION ON SEAT TRACK NR 7 BETWEEN STA X220 AND X226. REMOVED NR 7 SEAT TRACK IAW -8 200 SRM 51-40-11. DRILLED UP AND INSTALLED NEW TRACK IAW -8 200 SRM 51-40-00, 51-40-11 AND RD8-53-1102.SDR QXEA200800419Seat Track · corrodedPDX C4 CHECK. LT SEAT TRACK NR 2 HAS CORROSION AT APPROX STA 438 STA 466.5, STA 485, AND STA 498. REMOVED SEAT TRACK IAW -8 200 SRM 51-40-11. DRILLED UP AND INSTALLED NEW TRACK IAW -8 200 SRM 51-40-00, 51-40-11.SDR QXEA200800422Seat Track · corrodedPDX C4 CHECK. CORROSION ON SEAT TRACK NR 1 AT APPROX. STA X360. REMOVED NR 4 SEAT TRACK IAW -8 200 SRM 51-40-00. DRILLED UP AND INSTALLED NEW TRACK IAW -8 200 SRM 51-40-00, 51-40-11.SDR QXEA200800410Seat Track · corrodedPDX C4 CHECK FUSELAGE INTERIOR WEB THAT TIES INTO LT O/B SEAT TRACK HAS AN OVERSIZED HOLE LOCATED 2" AFT OF FRAME 333.300. REMOVED WEB BETWEEN FRAMES 333.30 AND 354.25 NEXT TO LH O/B SEAT TRACK. FABRICATED NEW WEB IAW T/C 2-53-836. INSTALLED WEB IAW -8 200 SDR QXEA200800411Support Bracket · damagedPDX C4 CHECK LT O/B SEAT TRACK SUPPORT BRACKET ON FWD SIDE OF FRAME AT STA X333.3 HAS DAMAGED HOLE, 2ND HOLE AFT TOP. REMOVED LT O/B SEAT TRACK SUPPORT BRACKET FWD SIDE FRAME AT STA X3333.3. INSTALLED NEW BRACKET FROM STOCK AT LT O/B SEAT TRACK ON FWD SIDE OSDR QXEA200800409Seat Track · corrodedPDX C4 CHECK BRACKET FOR NR 1 SEAT TRACK WEB AFT OF FRAME 354 IS DAMAGED. REMOVED BRACKET IAW -8 200 SRM 51-40-11. INSTALLED NEW BRACKET IAW -8 200 SRM 51-40-00, 51-40-11.SDR QXEA200800407Seat Track · corrodedPDX C4 CHECK CORROSION ON RT O/B SEAT TRACK AT APPROX X488.5. BLENDED OUT CORROSION IAW RD8-53-10103. ALODINE PRIMED IAW -8 200 SRM 51-20-16, 51-20-36.SDR UPS08852215Seat Track · damagedINSPECTION TYPE:C3 COCKPIT STA 32 OBSERVERS SEAT FWD SEAT TRACK HAS ELONGATED HOLES. REPLACED 2ND OBSERVERS FWD SEAT TRACK IAW SRM 51-01-02 AND SRM 51-03-00.SDR UPS08852196Seat Track · damagedINSPECTION TYPE:C3 COCKPIT OBSERVER SEAT AFT SEAT TRACK HAS ELONGATED HOLE. REMOVED AND REPLACED 2ND OBSERVERS AFT SEAT TRACK IAW SRM 51-03-00 AND SRM 51-01-24.SDR UPS08M52163Seat Track · corrodedINSPECTION TYPE:C AFT CABIN, CORROSION ON SEAT TRACK CROWN AND CHANNEL AT STA 1761 - 1781 X=-27.5. CORROSION ON AFFECTED AREA REMOVED. MAT'L THK: 0.145 INCH (CROWN), MAT'L REMOVED 0.030 INCH (STA1767), MAT'L REMAINING: 0.115 INCH, FOUND OUT OF LIMIT. DISCRESDR UPS08852092Seat Track · damagedINSPECTION TYPE:C3 COCKPIT FIRST OFFICERS LT AFT SEAT TRACK HAS ELONGATED HOLES. REMOVED AND REPLACED SEAT TRACKS IAW SRM 51-3-1, 51-1-20D, 51-1-8, 51 -1-24.SDR RYNA200800017Seat Track · corrodedPASSENGER CABIN RIGHT INBOARD SEAT TRACK IS CORRODED AT BS 448. REPAIRED CORRODED AREA IAW MD-80 SRM 51-10-03.SDR RYNA200800018Seat Track · corrodedPASSENGER CABIN LEFT INBOARD SEAT TRACK IS CORRODED AT BS 731. REPAIRED CORRODED AREA IAW MD-80 SRM 51-10-03.SDR RYNA200800019Seat Track · corrodedPASSENGER CABIN LEFT INBOARD SEAT TRACK IS CORRODED AT BS 693. REPAIRED CORRODED AREA IAW MD-80 SRM 51-10-03.SDR RYNA200800021Seat Track · corrodedPASSENGER CABIN LEFT INBOARD SEAT TRACK IS CORRODED AT BS 1212 - 1287. REPAIRED CORRODED AREA IAW MD-80 SRM 51-10-03.SDR RYNA200800020Seat Track · corrodedPASSENGER CABIN RIGHT INBOARD SEAT TRACK IS CORRODED AT BS 1078. REPAIRED CORRODED AREA IAW MD-80 SRM 51-10-03.SDR RYNA200800015Seat Track · corrodedPASSENGER CABIN RIGHT INBOARD SEAT TRACK IS CORRODED AT BS 1022-1060. REPAIRED CORRODED ARE IAW SRM 51-10-03.SDR RYNA200800016Seat Track · corrodedPASSENGER CABIN RIGHT INBOARD SEAT TRACK IS CORRODED AT BS 579. REPAIRED CORRODED ARE IAW MD-80 SRM 51-10-03.SDR IXXA08SMN137SCargo Track · wornDURING ROUTINE C CHECK INSPECTION, FOUND MAIN CARGO COMPARTMENT NUMBER 4 TRACK WITH LUGS WORN AT STATION 680.000. REMOVED EXISTING SPLICES (FWD SIDE) AND REMOVED SEGMENT OF DAMAGED TRACK AFT SIDE. FABRICATED SPLICES. CLEANED, TREATED AND PRIMED AREA AND SPLSDR IXXA08SMN136SCargo Track · brokenDURING ROUTINE C CHECK INSPECTION, FOUND MAIN CARGO COMPARTMENT NUMBER 2 TRACK WITH LUGS, BROKEN AT STATION 55.000. REMOVED SEGMENT OF DAMAGED TRACK AND EXITING SPLICES. CLEANED, TREATED AND PRIMED AREA AND EXITING SPLICES. INSTALLED NEW TRACK AND REINSTALLSDR 08FDEA01441Seat Track · damagedDURING MD10 ACF MODIFICATION IN UPPER FUSELAGE AT STA 1209 X= 47.250 SEAT TRACK WITH MISSING MATERIAL. REPAIRED FOR SRM 53-70-00 FIG 1 VOL I.SDR 08FDEA01440Seat Track · damagedDURING MD10 ACF MODIFICATION IN UPPER FUSELAGE FROM STA 1099 TO STA 1159 ON SEAT TRACK FOUND HOLES OVALIZED REPAIRED FROM SRM 53-70-00 FIG 1 VOL I.SDR 08FDEA01439Seat Track · crackedDURING MD10 ACF MODIFICATION IN UPPER FUSELAGE AT STA 1341 X = -75.250 FOUND SEAT TRACK WITH CRACK .5" LONG REPAIRED FOR SRM 53-70-00 FIG 1 VOL I.SDR FDEA200804161427Seat 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 X 3 IN TALL AND 1 EA REPAIR SECTION 52 IN LONG FROM FRAME 65 TO BETWEEN FRAMES 62 AND 63 REPAIR NOT IAW SRM REQUIREMENTS.REMOSDR UPS08852224Seat Track · wornINSPECTION TYPE:C3 BOTH FLOOR SEAT TRACKS WORN FOR F/E'S SEAT. REPLACED FWD AND AFT SEAT TRACKS IAW SRM 51-01-24 AND 51-03-00.SDR DHL2008760548Seat Track · corrodedREMOVED CORRODED SEAT TRACK. FABRICATED, AND INSTALLED SEAT TRACK SECTION AT BS 850 TO 870, RBL 45.5, PER B727 SRM 53-10-2 FIG 7 AND 53-10-5 FIG 1.SDR DHL2008760547Seat Track · corrodedREMOVED CORRODED SEAT TRACK, FABRICATED, AND INSTALLED SEAT TRACK SECTION AT BS 690 TO 740, RBL 24, PER SRM 53-10-2 FIG 7 AND 53-10-5 FIG 1.SDR DHL2008760523Seat Track · corrodedREMOVED, FABRICATED, AND REPLACED SEAT TRACK SECTION AT RBL 24, FROM BS 850 TO 870, PER B727 SRM 53-10-2 FIG 7 AND 53-10-5 FIG 1.
Back to JASC 5347