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 CALA0001526Seat Track · corrodedINSPECTION FOUND CABIN LEFT I/B SEAT TRACK CORRODED AT FS 1030 - 1250. THE SEAT TRACK WAS REMOVED AND A NEW SEAT TRACK WAS INSTALLED IAW SRM 51-30-1, 53-05, FIGURE 4F, 51-10-4, AND 51-10-3.SDR UPS00434465Seat Track · corrodedINSPECTION TYPE:C, CORROSION FOUND ON UPPER DECK SEAT TRACK AT BS 544 LBL 48. NEW SECTION OF SEAT TRACK FITTED IAW SRM 51-30-02.SDR RAIA0010033Seat Track · corrodedMX-STL- DURING MAINTENANCE CHECK FOUND CORROSION ON ALL SEAT TRACKS AFT OF FUSELAGE FRAME 32. MAINTENANCE REPAIRED SEAT TRACKS AFT OF FUSELAGE FRAME 32 IAW ATR 72 SRM.SDR RAIA0010032Seat Track · corrodedMX-STL- DURING MAINTENANCE CHECK FOUND CORROSION AT FLIGHT ATTENDANT SEAT TRACKS. MAINTENANCE REPLACED FLIGHT ATTENDANT SEAT TRACKS IAW ATR 72 SRM.SDR TWAA0016019Cargo Track · corrodedDURING CHECK-C MAINT, THE RT CARGO TIE DOWN TRACK WAS CORRODED AT STA 1212 TO 1308. REMOVED AND REPLACED TRACK PER SPM 6-70-01. INSTALLED PER SRM 51-30-1.SDR AWXA0000722Seat Track · gougedC-CHECK, SEAT TRACK GOUGED AT FS 340, RBL 25. REMOVED, FAB''D REPLACEMENT TRACK AND INSTALLED SEAT TRACK IAW 737 SRM 53-10-5 FIG 2.SDR TWAA0016013Seat Track · corrodedDURING CHECK-C MAINT FOUND CORROSION ON CABIN FLOOR TRACK AT STA 1031 TO 1308, LBL 44 INCHES. REMOVED NUMBER 2 CHAIR TRACK STA 1031 TO 1306. INSTALLED NEW SECTION OF TRACK. SPLICE REPAIR PER SRM 53-05 FIG 4 AND 5. TRACK INSTALLED WITH NUTS, WASHERS, BOLTS,SDR TWAA0016014Seat Track · corrodedDURING CHECK-C MAINT THE CABIN FLOOR TRACK WAS DAMAGED AND CORRODED AT STA 200 TO 332, RBL 44 IN, NUMBER 4 TRACK. REPLACED NUMBER 4 TRACK FROM STA 200 TO 341 PER SPM 6-70-01 PAGE 2 AND 3 ITEM 4, SRM 53-05 FIG 4F, SRM 51-60-0. TREATED TRACK PER SRM 51-10-3.SDR CALA0001491Seat Track · corrodedRIGHT INBOARD SEAT TRACK CORRODED AT STATION 200 TO 266. REMOVED AND REPLACED SEAT TRACK SECTION PER SRM 51-30-1, 51-30-2, 51-30-5, 53-05 FIG 4F AND 51-10-4.SDR CALA0001485Cargo Track · corrodedMID PIT RT AFT TRACK SECTION FORWARD END OUTBOARD EDGE CORRODED. REMOVED DAMAGED SECTION. FABRICATED AND INSTALLED NEW SECTION OF TRACK PER SRM 51-10-3, 53-01, 51-10-4, 51-30-1, AND 51-30-2.SDR TWAA0019604Cargo Track · corrodedDURING CHECK-C MAINT IN THE AFT CARGO COMPT THE LT TIE DOWN TRACK WAS CORRODED AT CLIP NUT HOLE STA 1212 TO 1320. INSTALLED NEW TRACK PER SPM 6-70-01.SDR QXEA0002851Seat Track · tool damagePDX- TOOLING MARKS AT NR 7 SEAT TRACK SUPPORT FRAME UNDER UPPER FLANGE WHERE SEAT TRACK ATTACHES. REPAIRED IAW HORIZON AIR EA 2-53-219 AND 2-53-223.SDR QXEA0002848Seat Track · corrodedPDX- FORWARD END OF RIGHT HAND INBOARD SEAT TRACK HAS CORROSION AND EXFOLIATION TYPE CORROSION UNDER GALLEY AND LAVATORY. REPAIRED IAW HORIZON AIR EA 2-53-220, DHC-8 SRM 51-40-11 AND RD 8-53-1102, 8-53-4473.SDR 00FDEA00710Seat Track · crackedMAIN DECK SEAT TRACK FOUND CRACK AT BS 635 X = 47.5 RT. *S/D* REMOVED AND REPLACED PER IAW SRM 53-42-01 VOL III AND SRM 53-70-00 VOL I.SDR CALA0001481Seat Track · corrodedLEFT INBOARD SEAT TRACK FS 322 - 437 IS CORRODED. REMOVED AND REPLACED SEAT TRACK PER SRM 53-05 FIG 4F AND SPLICED PER SRM 53-05.SDR CALA0001476Seat Track · corrodedRIGHT OUTBOARD SEAT TRACK FS 200 - 250 CORRODED. REMOVED AND REPLACED SEAT TRACK PER SRM 51-30-2, 51-10-3, AND 51-30-1.SDR 00FDEA00707Seat Track · corrodedDURING ROUTINE INSP, NR 6 SEAT TRACK FOUND CORRODED BETWEEN BS 813 - 817. REMOVED AND REPLACED, FAB PER IAW BAC 727 SRM 53-10-5 & 51-30-2.SDR 00FDEA00706Seat Track · corrodedDURING ROUTINE INSP NR 4 SEAT TRACK FOUND CORRODED BETWEEN BS 460 - 480. REMOVED AND REPLACED, FAB PER IAW BAC 727 SRM 53-10-5 & 51-30-2.SDR USAA001671Seat Track · corrodedCLT - Q-4, SEAT TRACK CORRODED, 24 INCHES, CORROSION LEVEL 1 C53-107-02, CENTER BETWEEN STA 328 AND STA 344. REPLACED SEAT TRACK PER SRM 53-00-92. (X)SDR MALA000646Seat Track · corrodedFOUND DURING C-CHECK, CORROSION ON I/B FLOOR SUPPORT FLANGE AISLE WAY SEAT TRACK LBL 18.3 STA 294 - STA 363. REFER TO CELSIUS TASK CARD 1530, W/O 18737 AND SAAB STATEMENT 340SDS000199. REMOVED CORROSION IAW SRM 51-70-40. REMAINING MATERIAL IS OUT OF LIMITS SDR MALA000645Seat Track · corrodedFOUND DURING C-CHECK, CORROSION ON LT FLOOR BOARD SUPPORT FLANGE AISLE WAY ON SEAT TRACK LBO STA 294 - STA 339. REFER TO CELSIUS TASK CARD 1531, W/O 18737, AND SAAB STATEMENT 340SDS000199. MAINTENANCE REMOVED CORROSION IAW SRM 51-70-40. REMAINING MATERIAL ISDR CALA0001468Seat Track · corrodedLEFT OUTBOARD SEAT TRACK CORRODED AT FS 1090 - FS 1164. REMOVED AND REPLACED SEAT TRACK SECTION PER SRM 53-05 FIG 4F AND 51-10-3.SDR QXEA0002847Seat Track · corrodedPDX- FORWARD SECTION OF LEFT HAND INBOARD SEAT TRACK HAS CORROSION ON TOP SURFACE. REPAIRED IAW HORIZON AIR EA 2-53-216 AND DHC-8 RD 8-53-1339.SDR 00FDEA00709Cargo Track · crackedCABIN MAIN DECK CARGO COMPT SEAT TRACK ALONG X = 47 & Y = 635 FOUND WITH LWR FLANGE CRACKED. *S/D* REMOVED AND REPLACED PER IAW SRM 53-42-01 VOL III AND SRM 53-70-00 VOL I.SDR CALA0001473Seat Track · corrodedLEFT OUTBOARD SEAT TRACK CORRODED FROM FS 1079 - 1174. REMOVED DAMAGED SECTION OF SEAT TRACK. FABRICATED AND INSTALLED SPLICE MATERIAL PER SRM 51-30-1, 51-30-2, 53-05 PG109 FIG 4F, AND 51-30-5.SDR AALA20001640Seat Track · corrodedTUL - FOUND CORROSION AROUND HOLE IN FORWARD END OF NR 6 SEAT TRACK WHERE GALLEY TIE DOWN ATTACHES. REPLACED SEAT TRACK STATION 218 TO 300 PER 53-05 FIG 4A. (M)SDR C2AXX00IA347Seat Track · wornIAH-DURING C-CHECK INSPECTION, THE CAPTAINS AND FIRST OFFICERS SEAT TRACKS WERE FOUND TO BE WORN. MAINTENANCE REMOVED AND REPLACED THE AFFECTED SEAT TRACKS IN ACCORDANCE WITH EMB145 SRM 53-01-05, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR QXEA0002850Seat Track · corrodedPDX- LIGHT SURFACE CORROSION ON LEFT HAND INBOARD SEAT TRACK X282.4 TO X262.4. REPAIRED IAW DHC-8 RD 8-53-1339.SDR UPS00233861Cargo Track · crackedINSPECTION TYPE:C DURING 950 FITTING REPLACEMENT TIE DOWN ATTACH POINT AT FLOOR LEVEL ON BEAM AT BS 950 FOUND CRACKED. TIE DOWN REPLACED IAW SRM 51-30-2.SDR DHL200080713CCargo Track · wornMAIN CARGO COMPARTMENT NR 4 TRACK LUGS WORN AT STATION 418.000. CUT NR 4 TRACK PLUG, FABRICATED NEW PLUG, CLEANED, PRIMED AND TREATED AREA AND INSTALLED NEW PLUG IAW SRM 53-2-3.SDR DHL200080712CCargo Track · wornMAIN CARGO COMPARTMENT NR2 TRACK LUGS WORN AT STATION 418.00. CUT WORN NR 2 PLUG, CONDITIONED TRACK AND FABRICATED NEW PLUG, CLEANED, PRIMED AND TREATED AND INSTALLED NEW PLUG IAW SRM 53-2-3.SDR DHL200080711CCargo Track · wornMAIN CARGO COMPARTMENT NR 5 TRACK LUGS WORN BETWEEN STA 200.00 AND STA 220.00. CUT NR 5 TRACK PLUG, FABRICATED NEW PLUG, CLEANED, PRIMED AND TREATED AREA AND INSTALLED NEW PLUG IAW SRM 53-2-3.SDR DHL200080710CCargo Track · wornMAIN CARGO COMPARTMENT NR 4 TRACK LUGS WORN BETWEEN STATION 320.00 AND STATION 340.00. CUT DAMAGED AREA, FABRICATED SPLICE WITH ALCLAD 7075T6 0.100 IAW SRM 53-2-3. FABRICATED TRACK PLUG, CLEANED TREATED AND PRIMED AREA AND INSTALLED NEW SPLICE AND TRACK IAW SDR DHL200080709CCargo Track · wornMAIN CARGO COMPARTMENT NR 5 TRACK LUGS WORN AT STATION 594.000. CUT NR 5 TRACK PLUG, FABRICATED TRACK PLUG, CLEANED PRIMED AND TREATED AREA AND INSTALLED NEW PLUG IAW SRM 53-2-3.SDR DHL200080708CCargo Track · wornMAIN CARGO COMPARTMENT NR 7 TRACK LUGS WORN AT STATION 230.00. CUT OUT DAMAGED AREA, FABRICATED NEW PLUG, CLEANED TREATED AND PRIMED AREA AND INSTALLED NEW PLUG IAW SRM 53-2-3.SDR DHL200080706CCargo Track · wornMAIN CARGO COMPARTMENT NR 7 TRACK LUGS WORN AT STATION 300.00. CUT DAMAGED AREA, FABRICATED NEW PLUG, CLEANED, PRIMED AND TREATED AREA AND INSTALLED NEW PLUG IAW SRM 53-2-3.SDR DHL200080704CCargo Track · wornMAIN CARGO COMPARTMENT NR 7 TRACK LUGS WORN AT STATION 270.000. CUT DAMAGED AREA, FABRICATED NEW TRACK, CLEANED TREATED AND PRIMED AREA AND INSTALLED NEW PLUG IAW SRM 53-2-3.SDR QXEA0002790Seat Track · corrodedYXX- RIGHT HAND INBOARD SEAT TRACK FOUND CORRODED AT STATION X596 AND X599 IN FORWARD BAG PIT. REPAIRED IAW DHC-8 SRM 51-20-36, AND RD8-83-4936.SDR QXEA0002789Seat Track · corrodedYXX- RIGHT HAND INBOARD FORWARD SEAT TRACK FOUND CORRODED BETWEEN STATION X182.00 AND X240.60. REPAIRED IAW DHC-8 SRM 51-40-11, PAGE 1-4, AND RD8-53-3074, AND SRM 51-40-00, PAGE 4.SDR QXEA0002788Seat Track · corrodedYXX- LEFT HAND INBOARD SEAT TRACK FOUND TO HAVE MECHANICAL AND CORROSION DAMAGE. REPAIRED IAW DHC-8 SRM 51-40-11, PAGE 1, AND SRM 51-40-00, PAGE 4.SDR SIMA2729Seat Track · corrodedSAW - DURING CPCP-2 INSPECTION, MAINTENANCE FOUND AFT CARGO SEAT TRACK UNDER LAV WALL CORRODED BEYOND LIMITS. REMOVED AND REPLACED SEAT TRACK IAW EO E9-5300-013. (X)SDR UPS00234562Seat Track · gougedINSPECTION TYPE:C MAIN CARGO DECK, SEAT TRACK AT LBL 60 IS NICKED & GOUGED AT STA 499, STA 503 & STA 538. REPLACED SECTION OF SEAT TRACK FROM STA 445 TO STA 655, LBL 60 IN ACCORDANCE WITH SRM 53-10-5, P/N BAC1520-1433.SDR UPS00234561Seat Track · gougedINSPECTION TYPE:C CK MAIN CARGO DECK, SEAT TRACK AT LBL 60 IS NICKED & GOUGED AT STA.599 & STA. 603. REPLACED SECTION OF SEAT TRACK FROM STA. 445 TO STA 655, LBL 60 IN A CCORDANCE WITH SRM 53-10-5, P/N BAC1520-1433.SDR AALA20001652Seat Track · corrodedTUL - FOUND CORROSION ON NR 3 SEAT TRACK. ROUTED OUT CORRODED AREA ,1 INCH BY 3 INCHES AND .25 INCH DEEP, AND INSTALLED PLUG PER SRM 53-05 PART 1 FIG 4A. (M)SDR AALA20001651Seat Track · corrodedTUL - FOUND CORROSION ON NR 2 SEAT TRACK AT STATION 1200. CUT OUT DAMAGE AND INSTALLED SPLICE PER SRM 53-05 PART 1 AND ESO 80559 DATED 9-26-00. (M)SDR TWAA0015406Seat Track · corrodedDURING CHECK-C MAINT AT STA 200 TO 247, RBL 22 INCHES, A 47 INCH SECTION OF NUMBER 3 FLOOR TRACK WAS CORRODED. REMOVED CORRODED TRACK SECTION FROM STA 200 TO 247. SPLICED NEW TRACK SECTION PER SRM 53-05.SDR AALA20001644Seat Track · wornTUL - FOUND NR 4 SEAT TRACK WORN STATION 914-915. ACCOMPLISHED SEAT TRACK PLUG REPAIR PER AARD 53-20-00-10 REPAIR NR 10. (M)SDR AALA20001639Seat Track · corrodedTUL - FOUND NR 1 SEAT TRACK CORRODED IN CHANNEL AND ON WORN LUG. REMOVED OUT OF LIMIT AREA OF NR 1 SEAT TRACK STATION 1234 TO 1237 AND INSTALLED SEAT TRACK PLUG PER SRM 53-05 FIG 4A (M)SDR AWXA0000670Seat Track · brokenC-CHECK, NR 3 SEAT TRACK ATTACH ANGLE AT STA 520 BROKEN OFF. REMOVED DAMAGED ATTACH ANGLE, FABRICATED NEW ATTACH ANGLE IAW B737 DWG 69-41691, PRIMED IAW 737 MM 51-21-00, INSTALLED IAW EO 53-14-12 AND SB 737-53-1120.SDR MALA000598Seat Track · corrodedFOUND DURING C-CHECK, SURFACE CORROSION ON FRONT PART OF SEAT RAIL NR 4. CORROSION TREATED PER BAE REF BARA/AVR/5178/00. DEPTH OF CORROSION WITHIN SPECIFIED LIMITS . DYE PEN TEST REVEALED NO FAULTS. APPLIED ALODINE TO AFFECTED AREAS. REQUIRES EPOXY PRIME
Back to JASC 5347