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 DHL2004806508Cargo Track · wornUPPER CARGO COMPT NR 4 FLOOR TRACK PLUG LUGS WORN STA 1140.000. REMOVED NR 4 FLOOR TRACK PLUG STA 1140.000 IAW SRM 51-3-0 PG 1. CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B. INSTALLED NEW PLUG IAW SRM 51-3-0 PG 1.SDR DHL2004806511Cargo Track · wornMAIN CARGO COMPT NR 3 FLOOR TRACK LUG WORN STA 867.000. TRIMMED OUT DAMAGED AREA IAW SRM 53-2-3 PG 17 FIG 6D. CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B. INSTALLED CHANNEL AND PLUG IAW SRM 53-2-3 PG 17 FIG 6D. INSTALLED SCREW IAW SRM 51-3-0 PG 1.SDR DHL2004806509Cargo Track · wornUPPER CARGO COMPT NR 2 FLOOR TRACK PLUG LUGS WORN STA 1130.000. REMOVED WORN PLUG IAW SRM 51-3-0 PG 1. CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B. INSTALLED NEW PLUG IAW SRM 51-3-0 PG 1.SDR MALA040106Seat Track · corrodedDURING 4K INSPECTION IN LCQ, FS 294 RT I/B FWD SEAT TRACK HAS CORROSION. REMOVED AND REPLACED CORRODED SECTION OF SEAT TRACK IAW MESABA EO S53060. REFER NR 1195871 FOR ADDITIONAL INFO. A/C RELEASE DATE 1/6/04.SDR MALA040105Seat Track · corrodedDURING 4K INSPECTION IN LCQ, FS 294 LT I/B FWD SEAT TRACK HAS CORROSION. REMOVED AND REPLACED CORRODED SECTION OF SEAT TRACK IAW MESABA EO S53060. REFER TO NR 1195871 FOR ADDITIONAL INFO. A/C RELEASE DATE 01/06/2004.SDR MALA030606Seat Track · corrodedDURING 4Y/2Y INSPECTION IN LCQ, FS 640-686 CENTER SEAT TRACK HAS CORROSION. MX REMOVED AND REPLACED CORRODED SECTION OF SEAT TRACK IAW MESABA EO S53060 DATED 3 NOV 2003 REV II. A/C RELEASE DATE 01/09/04. REFER TO 1196389 FOR ADDITIONAL DETAIL.SDR MALA030607Seat Track · corrodedDURING 4Y/2Y INSPECTION IN LCQ, FS 640-686 LEFT I/B SEAT TRACK HAS CORROSION. MX REMOVED AND REPLACED CORRODED SECTION OF SEAT TRACK IAW MESABA EO S53060 DATED 3 NOV 2003 REV II. A/C RELEASE DATE 01/09/04. REFER TO 1196389 FOR ADDITIONAL DETAIL.SDR MALA030605Seat Track · corrodedDURING 4Y/2Y INSPECTION IN LCQ, FS 640-686 RT OB SEAT TRACK HAS CORROSION. MECHANIC REMOVED AND REPLACED CORRODED SECTION OF SEAT TRACK IAW EO NR S53060 DATED 3 NOV 2003 REV II. A/C RELEASE DATE 01/09/04. REFER TO NR 1196389 FOR ADDITIONAL DETAIL.SDR DHL2004806503Cargo Track · wornMAIN CARGO COMPT NR 7 TRACK PLUG LUG WORN AT STA 275.000. REMOVED PLUG WITH WORN LUG IAW SRM 51-3-0 PG 1. CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B. INSTALLED NEW PLUG ON MAIN CARGO COMPT NR 7 TRACK AT STA 275.000 IAW SRM 51-3-0 PG 1.SDR DHL2004806512Cargo Track · wornUPPER CARGO COMPT NR 6 FLOOR TRACK PLUG LUGS WORN STA 1310.000. REMOVED NR 6 FLOOR TRACK PLUG STA 1310.000 IAW SRM 51-3-0 PG 1. CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B. INSTALLED NEW PLUG IAW SRM 51-3-0 PG 1.SDR DHL2003806501Cargo Track · wornMAIN CARGO COMPT NR 7 FLOOR TRACK PLUG LUG WORN AT STA 320.000. REMOVED PLUG WITH WORN LUG IAW SRM 51-3-0 PG 1. CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B. INSTALLED NEW PLUG IAW SRM 51-3-0 PG 1.SDR DHL2004806500Cargo Track · wornMAIN CARGO COMPT NR 6 FLOOR TRACK PLUG LUG WORN AT STA 210.000. REMOVED PLUG WITH WORN LUG IAW SRM 51-3-0 PG 1. CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B. INSTALLED NEW PLUG ON MAIN CARGO COMPT NR 6 FLOOR TRACK AT STA 210.000 IAW SRM 51-3-0 PG 1.SDR DHL2004806507Cargo Track · wornMAIN CARGO COMPT NR 6 TRACK PLUG LUG WORN AT STA 250.000. REMOVED PLUG WITH LUGS WORN IAW SRM 51-3-0 PG 1. CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B. INSTALLED NEW PLUG ON MAIN CARGO COMPT NR 6 FLOOR TRACK IAW SRM 51-3-0 PG 1.SDR DHL2004806506Cargo Track · wornMAIN CARGO COMPT NR 4 FLOOR TRACK PLUG WITH LUGS WORN STA 275.000. REMOVED PLUG WITH LUGS WORN IAW SRM 51-3-0 PG 1. CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B. INSTALLED NEW PLUG ON MAIN CARGO COMPT NR 4 FLOOR TRACK IAW SRM 51-3-0 PG 1.SDR DHL2004806505Cargo Track · wornMAIN CARGO COMPT NR 5 FLOOR TRACK PLUG WITH LUG WORN AT STA 160.000. REMOVED PLUG WITH WORN LUG IAW SRM 51-3-0 PG 1. CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B. INSTALLED NEW PLUG ON MAIN CARGO COMPT NR 5 FLOOR TRACK STA 160.000 IAW SRM 51-3-0 PG 1.SDR DHL2004806504Cargo Track · wornMAIN CARGO COMPT NR 4 FLOOR TRACK PLUG LUG WORN AT STA 780.000. REMOVED PLUG WITH WORN LUG IAW SRM 51-3-0 PG 1. CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B. INSTALLED NEW PLUG ON MAIN CARGO COMPT NR 4 FLOOR TRACK IAW SRM 51-3-0 PG 1.SDR 03FDEA02282Seat Track · damagedCOMPLY WITH EA 8-5310-73862. FUSELAGE MAINFRAME- MINOR DEVIATION TO SRM SEAT TRACK SPLICE. CLOSING ACTION ON 12/24/03. ON N/R S00031. COMPLIED WITH EA 8-5310-73862.SDR ASAA0310679Seat Track · corrodedOKC - DURING SCHEDULED D-CHECK, FOUND THE SEAT TRACK AT FUSELAGE STATION 683-727, RIGHT BUTTOCK LINE 60 CORRODED. REPLACED DAMAGED SECTION OF SEAT TRACK PER SRM. (M)SDR ASAA0310677Seat Track · corrodedOKC - DURING SCHEDULED D-CHECK, FOUND THE SEAT TRACK AT FUSELAGE STATION 807-947, RIGHT BUTTOCK LINE 24.75 CORRODED. REPLACED DAMAGED SECTION OF SEAT TRACK PER SRM. (M)SDR 2004F00222Seat Track · corrodedFOUND THE LEFT CABIN SEAT TRACK HAD SUSTAINED CORROSION DUE TO WATER INTRUSION FROM THE LEFT NR 6 EMERGENCY CABIN WINDOW. THE CAUSE OF THIS DEFECT WAS DUE TO WATER INTRUSION. MAY WANT TO INCREASE THE INSPECTION FREQUENCY IN THIS AREA. THE SEAT TRACK WILL BESDR 2004F00160Seat Track · corrodedFOUND THE LEFT CABIN SEAT TRACK HAD SUSTAINED CORROSION DUE TO WATER INTRUSION FROM THE LEFT NR 6 EMERGENCY CABIN WINDOW. REMOVED CORROSION AND BLENDED THE EFFECTIVE AREA OF THE SEAT TRACK. TREATED BARE METAL AND APPLIED PRIMER PER GULFSTREAM ENGINEERING DISSDR 2003UALA00976Seat Track · corrodedCABIN SEAT TRACK OB FR 62 FWD, SEVERAL LUGS WITH LIGHT CORROSION. MAJOR REPAIR ACCOMPLISHED. REMOVED AND REPLACED DAMAGED SECTION IAW SRM 53-00-15.SDR ASAA0340363Cargo Track · damagedOAK - DURING C-CHECK, FOUND AFT CARGO LEFT CARGO TRACK IS DAMAGE BEYOND LIMITS. REPAIRED IAW SRM. (M)SDR QXEA200301607Seat Track · damagedPDX- NR 4 SEAT TRACK WAS FOUND TO BE OUT OF LIMITS. REPAIRED IAW DHC-8 SRM 51-40-11, RD 8-53-4472 AND RD 8-53-1102.SDR QXEA200301606Seat Track · corrodedPDX- RIGHT HAND INBOARD NR 7 SEAT TRACK HAS CORROSION AT STATION X226.0. REPAIRED IAW DHC-8 SRM 51-40-11 AND RD 8-53-1102.SDR USAA030327Seat Track · corrodedCLT - FOUND SEAT TRACK CORRODED 6 INCHES, STATION 1468, RBL 88. REMOVED CORROSION, ALODINED, PRIMED AND PAINTED PER SRM 53-00-52 FIG 101. (M)SDR USAA030328Seat Track · corrodedCLT - FOUND SEAT TRACK CORRODED 2 INCHES, STATION 1437 AND RBL 88. REMOVED CORROSION, ALODINED, PRIMED AND PAINTED PER SRM 53-00-52 FIG 101. (M)SDR USAA030315Seat Track · corrodedFOUND SEAT TRACK CORRODED 5 INCHES BY .5 INCH BY .030 INCH DEEP AREA, FRAME 36, LBL 75 UNDER COAT CLOSET AFT OF L AT DOOR. TWO REPAIR SPLICES INSTALLED AND NEW TRACK INSTALLED PER EA 95034 AND SRM 53-00-15 FIG 202. (M)SDR 03FDEA02204Seat Track · corrodedMAIN CARGO DECK LT STA 839 SEAT TRACK REF X=27.5 BENEATH FLOOR PANEL 241JF SEAT TRACK FOUND CORRODED. REMOVED AND REPLACED AS PER SRM 51-33-01 VOL 2 & SRM 53-70-00 FIG 1 VOL 1.SDR AMWA96Seat Track · damagedDURING SCHEDULED ABCD STRUCTURAL INSPECTION, THE LEFT AFT SEAT TRACK WAS FOUND TO BE DAMAGED.SDR QXEA200301603Seat Track · corrodedPDX- WEB HAS OVERSIZED HOLE BELOW NR 7 SEAT TRACK AT STATION X399. REPAIRED IAW DHC-8 SRM 51-00-06, RD 8-53-7685 AND HORIZON AIR EA 2-53-520.SDR MALA030573Mount · corrodedDURING 4K INSPECTION IN LCQ, FWD LAV AFT I/B MOUNT HAS EVIDENCE OF CORROSION. MAINTENANCE REMOVED CORRODED LAV MOUNT, FABRICATED NEW MOUNT AND INSTALLED, IAW MESABA EO S25063, REV 0 DATED 19 DEC 2003. A/C RELEASE DATE 12/24/03.SDR 03FDEA02200Seat Track · corrodedMAIN CARGO DECK RT STA 455 TO STA 515 SEAT TRACK AT X=27.5 RT SEAT TRACK HAS HEAVY CORROSION. REMOVED AS PER SRM 53-70-00 FIG. 1 VOL. I AND INSTALLED NEW SEAT TRACK AT MAIN DECK CARGO RT STA 455 TO 525 AS PER SRM 53-70-00 FIG. 1 VOL I.SDR MALA030574Seat Track · corrodedDURING 4K INSPECTION IN LCQ, FS 620 TO FS 686, LT BL 18.3 SEAT TRACK HAS CORROSION. MAINTENANCE REMOVED AND REPLACED CORRODED SEAT TRACK SECTION FROM FS 620 - FS 686 IAW MESABA EO A53060 DATED 3 NOV 2003. A/C RELEASE DATE 12/24/03.SDR AMWA90Seat Track · crackedDURING AN ABC STRUCTURAL INSPECTION, THE FORWARD SEAT TRACK WAS FOUND TO BE CRACKED.SDR ASOA03688Seat Track · corrodedDURING A C-CHECK IN BNA, THE LEFT AND RIGHT OUTBOARD SEAT TRACKS AND THE RIGHT INBOARD SEAT TRACK, BETWEEN FS 23-29 WERE FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE LEFT AND RIGHT OUTBOARD SEAT TRACKS AND THE RIGHT INBOARD SEAT TRSDR F3LA200300172Mount · corrodedDURING C-CHECK, INSPECTION REPORTED CORROSION ON GALLEY MOUNT AT STA 990, RBL 32. REPLACED GALLEY MOUNT PER SRM 51-40-02.SDR AWXA200301557Seat Track · corrodedDURING C-04 CHECK GALVANIC CORROSION WAS FOUND ON THE UPPER AND LOWER SURFACE OF FLOORBEAM AT FR 66, Y1292, Z240. MAINTENANCE REMOVED CORRODED FLOORBEAM FROM FR 64 TO FR 66, Y1292, Z240; FABRICATED A NEW REPLACEMENT FLOORBEAM PER DWG D534-72209; INSTALLED REPSDR QXEA200301528Seat Track · corrodedNR 11 SEAT TRACK IS CORRODED BETWEEN X469 AND X473. REPAIRED IAW DHC-8 SRM 51-20-36.SDR QXEA200301527Seat Track · corrodedPDX - NR 10 SEAT TRACK IS CORRODED BETWEEN X345 AND X348. REPAIRED IAW DHC-8 SRM 51-20-36.SDR USAA030274Seat Track · corrodedCLT - FOUND SEAT TRACK CORRODED 1 SQUARE INCH BY .060 INCH DEEP, AT LBL 17.75, FRAME 57.2. REPLACED SEAT TRACK SECTION PER SRM 53-00-15 FIG 101. (M)SDR F3LA200300167Galley Track · corrodedDURING C-CHECK, INSPECTION REPORTED CORROSION ON GALLEY TRACK, STA. 344, LBL 20-23. REPAIRED GALLEY TRACK IAW SRM 53-00-52.SDR ASOA03687Seat Track · corrodedDURING A C-CHECK IN BNA, THE RIGHT OUTBOARD SEAT TRACK SECTION BETWEEN FS 13-23 WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE RIGHT OUTBOARD SEAT TRACK SECTION BETWEEN FS 13-23 IAW SRM 51-25-01 AND 51-25-04. (M)SDR ASOA03686Seat Track · corrodedDURING A C-CHECK IN BNA, THE LEFT AND RIGHT OUTBOARD SEAT TRACKS BETWEEN FS 29-36 WERE FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE LEFT AND RIGHT OUTBOARD SEAT TRACKS BETWEEN FS 29-36 IAW SRM 51-25-01 AND 53-00-00. (M)SDR MALA030567Seat Track · corrodedDURING 4K INSPECTION, SEAT TRACK ON RIGHT SIDE BETWEEN STA 240 AND 258 HAS CORROSION IN SEVERAL AREAS. REMOVED AND REPLACED CORROSION SEAT TRACK, FABRICATED NEW SEAT TRACK FROM RIGHT STA 215 TO 225 BUTTLINE 12 P/N 7253721-459 IAW SRM 51-40-40 & 51-40-27.SDR MALA030565Seat Track · corrodedDURING 4K INSPECTION, FS 630 TO 686 LEFT O/B SEAT TRACK HAS CORROSION. REMOVED AND REPLACED CORRODED SEAT TRACK SECTION FROM FS 630 TO FS 686 IAW MESABA EO S 53060 DATED NOV 3, 2003 REV II.SDR MALA030566Seat Track · corrodedDURING 4K INSPECTION IN LAKE CITY, FS 294 RIGHT SEAT TRACK HAS CORROSION. REMOVED AND REPLACED CORRODED SEAT TRACK SECTION FROM FS 284 TO FS 339 IAW MESABA EO 53060 DATED NOV 3, 2003 REV II.SDR MALA030564Seat Track · corrodedDURING 4K INSPECTION IN LAKE CITY, FL, FS 294 LEFT SEAT TRACK CORRODED. REMOVED AND REPLACED CORRODED SECTION OF SEAT TRACK AT FS 294 IAW MESABA EO A53060 DATED NOV 3, 2003, REV II.SDR MWEA030471Galley Track · corrodedAFT INBOARD G2 GALLEY MOUNT FITTINGS AT STATION 218 IS CORRODED. FABRICATED AND INSTALLED FITTINGS.SDR QXEA200301516Seat Track · corrodedPDX - TRACK 3 TOP FLANGE HAS AREAS OF LIGHT PITTING AT STATION X510.00. REPAIRED IAW DHC-8 SRM 51-20-16 AND SRM 51-20-36.
Back to JASC 5347