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 SCNA01300Seat Track · corrodedDURING HEAVY MAINTENANCE INSPECTION CORROSION WAS FOUND OUT OF LIMITS ON THE SEAT TRACK LOCATED AT FS779 TO FS850 RBL24. REMOVED CORROSION IAW B727 SRM 511006. REMOVED SEAT TRACK IAW B727 SRM 513002. FABRICATED NEW SEAT TRACK PER SAMPLE FROM BAC 15201429. INSTSDR SIMA3572Seat Track · corrodedSBP - DURING MBV, FOUND CORROSION ON RIGHT GALLEY INBOARD SEAT TRACK. REMOVED AND REPLACED TRACK IAW SRM. (M)SDR SIMA3573Seat Track · corrodedSBP - DURING MBV, FOUND CORROSION ON SEAT TRACK BL 0 FROM FUSELAGE STATION 294 TO 361. REMOVED AND REPLACED CORRODED SECTION OF SEAT TRACK IAW SRM 53-70-60. (M)SDR SIMA3574Seat Track · corrodedSBP - DURING MBV, FOUND CORROSION ON SEAT TRACK BL 18.3 FROM FUSELAGE STATION 294 TO 361. REMOVED AND REPLACED CORRODED SECTION OF SEAT TRCK IAW SRM 53-70-60. (M)SDR RAIA0012066Seat Track · corrodedMX-STL-DURING MAINTENANCE CHECK FOUND RIGHT HAND FLIGHT ATTENDANT SEAT TRACK BETWEEN FUSALAGE FRAMES 40 AND 36 HAS CORROSION. MAINTENANCE REMOVED AND REPLACE RIGHT HAND FLIGHT ATTENDANT SEAT TRACK IAW ATR42 SRM.SDR RAIA0012069Seat Track · corrodedMX-STL-DURING MAINTENANCE CHECK FOUND RIGHT HAND OUT BOARD SEAT TRACK HAS CORROSION BETWEEN FUSALAGE FRAMES 36 & 34. MAINTENANCE REPAIRED THE SEAT TRACK IAW ATR42 SRM.SDR RAIA0012068Seat Track · corrodedMX-STL-DURING MAINTENANCE CHECK FOUND LEFT HAND FLIGHT ATTENDANT SEAT TRACK BETWEEN FUSALAGE FRAMES 38 & 36 HAS CORROSION.MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK IAW ATR42 SRM.SDR LR7A00223Fitting · crackedDURING SCHEDULED B2 CHECK PER JOBCARD HSP53262 FOUND FS 617 RT TIE DOWN FITTING CRACKED AT RBL 62, WL 146. REPLACED FITTING PER SMP 583-51-10, PG 4. DRC 2027.SDR LR7A00222Fitting · crackedDURING SCHEDULED B2 CHECK PER JOBCARD HSP53262 FOUND FS 617 LT TIE DOWN FITTING CRACKED AT LBL 62, WL 146. REPLACED FITTING PER SMP 583-51-10, PG 4. DRC 2022.SDR AALA20010052Seat Track · corrodedTUL - FOUND CORROSION ON SEAT TRACK NR 5 FS 200-246. SPLICED IN A NEW SECTION OF SEAT TRACK FS 200-246 PER SRM 53-05 FIG 4F. (M)SDR CALA0001983Seat Track · corrodedINSPECTION FOUND LT O/B SEAT TRACK CORRODED AT FS 1079-1136. THE SEAT TRACK WAS REMOVED AND A NEW SEAT TRACK WAS INSTALLED IAW SRM 51-30-5 AND 51-30-1.SDR CALA0001979Cargo Track · gougedINSPECTION FOUND GOUGES IN MID PIT RT AFT CARGO TRACK AT FS 693-788. THE TRACK WAS REMOVED AND A NEW TRACK WAS INSTALLED IAW SRM 51-30-1.SDR CALA0001978Cargo Track · corrodedINSPECTION FOUND CORROSION AT FASTENER HOLES ON UPPER AND LOWER SURFACES OF RT CARGO TRACK IN MID PIT AT STA 541-636. THE TRACK WAS REMOVED AND A NEW TRACK WAS INSTALLED IAW SRM 51-10-3, 51-10-4, AND 51-30-1.SDR AWXA0001128Seat Track · corrodedCABIN SEAT TRACK RBL 24 I/B FLANGE HAS BARE METAL ON UNDERSIDE AT EACH FLOOR BOARD FASTENER HOLE - SOME WITH LIGHT SURFACE CORROSION - FROM BS 540 - 727. REMOVED LIGHT SURFACE CORROSION - .070 MATERIAL LOSS .001-.002 FOUND WITH IN LIMITED MECHANICAL MEASUREMENSDR 20010406SG003Seat Track · corrodedDURING C-CHECK, FOUND LEFT OUTBOARD SEAT TRACK UPPER SURFACE OUTBOARD FLANGE CORRODED BS 1020. REMOVED AND REPLACED TRACK SECTION LEFT OUTBOARD TRACK BS 990 TO 1070 LBL 45 IAW SRM 53-10-5 FIG 7. (M)SDR 20010206CW004Seat Track · misinstalledDURING COMPLIANCE OF AD, FOUND SEAT TRACKS INSTALLED WITH CHERRY MAX BLIND FASTENERS AND OVERSIZED RIVETS, WHICH DID NOT MEET THE REQUIRED 2D EDGE DISTANCE REQUIREMENT. FLOOR AND TRACKS HAD TO BE REPLACED AND SUB FLOOR REPAIRED. CHERRY MAX RIVETS ANRE NOT APSDR CALA0001972Cargo Track · corrodedINSPECTION FOUND RT AFT PIT TIE DOWN TRACK CORRODED AROUND FASTENER HOLES AT FS 1211-1332. THE TRACK WAS REMOVED AND A NEW TRACK WAS INSTALLED IAW SRM 51-30-1, 53-01, FIGURE 1, 51-10-4, AND 51-10-3.SDR SIMA0037Seat Track · corrodedSAW - DURING CPCP-2 INSPECTION, MAINTENANCE REPORTED THE LEFT MIDDLE OUTBOARD SEAT TRACK CORRODED. MAINTENANCE REMOVED AND REPLAED THE SEAT TRACK IAW EO E9-5300-013. AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR AALA20010050Seat Track · corrodedTUL - FOUND NR 1 SEAT TRACK CORRODED ON LUGS IN CHANNEL AND ON FLANGES. INSTALLED NEW SEAT TRAK STATION 1174-1309 PER SRM 53-05. (M)SDR 20010406SG002Seat Track · corrodedDURING C-CHECK, FOUND CABIN SEAT TRACK CORRODED BS 344 TO 360 RBL 45. REMOVED AND REPLACED SEAT TRACK SECTION FROM BS 344 TO BS 480 IAW SRM 53-10-5 FIG 7. (M)SDR AALA20010055Seat Track · corrodedTUL - FOUND NR 6 SEAT TRACK CORRODED AT STATION 671. ROUTED OUT CORROSION AND INSTALLED REPAIR PLUG PER SRM 53-05. (M)SDR AALA20010054Seat Track · corrodedTUL - FOUND NR 1 SEAT TRACK HAS CORROSION OF STATION 451. ROUTED OUT CORROSION AND INSTALLED REPAIR PLUG PER SRM 53-05. (M)SDR AALA20010053Seat Track · corrodedTUL - FOUND NR 6 SEAT TRACK CORRODED STATION 701. ROUTED OUT TRACK AND INSTALLED REPAIR PLUG PER SRM 53-05. (M)SDR MALA000781Seat Track · corrodedFOUND DURING C-CHECK, CORROSION ON BL 0 SEAT TRACK STA 294 - 370. REFER TO CELSIUS TASK CARD 1540, W/O19161, AND SAAB STATEMENT 340SDS000642. MAINTENANCE REMOVED CORROSION FROM BL 0 SEAT TRACK STA 360 - 294 AS MARKED IAW SRM 51-10-30. REMAINING MATERIAL ISSDR MALA000780Seat Track · corrodedFOUND DURING C-CHECK, CORROSION ON SEAT TRACK LBL, STA 294 - 370. REFER TO CELSIUS W/O 19161, TASK CARD 1539 AND SAAB STATEMENT 340 SDS000642. MAINTENANCE REMOVED CORROSION FROM SEAT TRACK 18.3 LBL STA 370 - 294 AS MARKED, IAW SRM 51-10-30. REMAINING MATERISDR MWEA001242Seat Track · damagedCABIN FLOORBOARD B6 AT STATION 617 TO 639 LT, BETWEEN NR 1 & 2 SEAT TRACKS HAS HOLES CRACKED OUT. -- REMOVED AND REPLACED FLOORBOARD.SDR CALA0001953Cargo Track · corrodedINSPECTION FOUND RT FORWARD CARGO TIE DOWN TRACK CORRODED AT STA 218-370. THE TIE DOWN TRACK WAS REMOVED AND A NEW TRACK WAS INSTALLED IAW SRM 51-30-1 AND 51-10-4.SDR CALA0001948Seat Track · corrodedINSPECTION FOUND RT O/B SEAT TRACK CORRODED AT STA 352-457. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 53-05, FIGURE 4F, 51-10-3, 51-30-1, AND 51-30-5.SDR CALA0001940Seat Track · corrodedINSPECTION FOUND CABIN LT I/B SEAT TRACK CORRODED AT FS 896. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 51-30-1 AND 51-30-5.SDR CALA0001937Seat Track · corrodedINSPECTION FOUND CABIN RT SEAT TRACK CORRODED AT FS 265-790. THE SEAT TRACK WAS REMOVED AND A NEW TRACK WAS INSTALLED IAW SRM 51-30-2, 53-04, FIGURE 4F, AND 53-05, FIGURE 4B.SDR CALA0001935Cargo Track · corrodedINSPECTION FOUND LT CARGO TRACK IN MID PIT CORRODED ON UPPER AND LOWER SURFACES BETWEEN STA 541 AND 788. THE TRACK WAS REMOVED AND A NEW TRACK WAS INSTALLED IAW SRM 51-30-2, 51-30-5, AND 51-30-1.SDR CALA0001933Seat Track · corrodedINSPECTION FOUND LT O/B SEAT TRACK CORRODED AT STA 256. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 53-05, FIGURE 4F.SDR CALA0001932Seat Track · corrodedINSPECTION FOUND CABIN RT CENTER SEAT TRACK CORRODED AT STA 427-925. THE SEAT TRACK WAS REPAIRED IAW SRM 53-05, FIGURE 4B.SDR MALA000798Seat Track · corrodedFOUND DURING 4K HEAVY CHECK, CORROSION ON SEAT TRACK RT CENTER AISLE, IN CARGO AREA FROM STA 630 TO 651. MAINTENANCE COMPLETED REPAIR IAW EO S53077.SDR AWXA0001100Seat Track · gougedLBL 45 CABIN SEAT TRACK GOUGED AT FS 694. REMOVED GOUGE IAW SRM 51-10-02; MATERIAL LOSS OUT OF LIMITS IAW 51-00-52; REMOVED FLOOR BOARDS AND DAMAGED PART; TREATED AND PRIMED, SEALED AND INSTALLED REPLACEMENT SECTION IAW SRM 53-60-52 FIG 1 SHT 2SDR AWXA0001094Seat Track · corrodedCABIN SEAT TRACK CORROSION OUT OF LIMITS AT STA 727E-767 RBL 45. REMOVED DAMAGED SEAT TRACK IAW SRM 51-40-02; FABED AND INSTALLED REPLACEMENT TRACK IAW 51-40-02, 53-60-52 FIG 1 AND 51-20-05SDR AWXA0001093Seat Track · corrodedCABIN FLOORBEAM STA 294 RBL 25-52 HAS CORROSION AT TOP OF FLOORBEAM AND PREVIOUS SPLICE REPAIR. SPLICED NEW SECTION OF FLOOR BEAM IAW SRM 53-10-08 & 51-40-02; FABED AND INSTALLED UPPER TEE CHORD IAW 53-10-08 FIG 1; INSTALLED 2 EA MISSING FASTENERS ON PREVIOUS SDR AWXA0001091Seat Track · gougedCABIN SEAT TRACK LBL 24 GOUGED AT FS 492 WENT OUT OF LIMITS. REMOVED DAMAGED TRACK IAW SRM 51-40-02; INSTALLED REPLACEMENT TRACK IAW 53-40-02; FABED SEAT TRACK IAW 53-00-52.SDR AWXA0001087Seat Track · dentedRBL 25 CABIN SEAT TRACK AT FS 500A WENT OUT OF LIMITS. REMOVED SEAT TRACK IAW SRM 51-40-02; FABED AND INSTALLED REPLACEMENT IAW B737 SRM 53-30-52 FIG 1, 51-40-02 AND 51-20-05; REINSTALLED TRACK IAW 51-40-02SDR AWXA0001086Seat Track · wornLBL 45 CABIN SEAT TRACK AT FS 444 BLEND OUT OF LIMITS. REMOVED DAMAGED SEAT TRACK IAW 53-00-52; FABED REPLACEMENT PART IAW 53-30-52; INSTALLED REPLACEMENT PART IAW 51-40-02SDR AWXA0001085Seat Track · damagedCABIN SEAT TRACK LBL 45 AREAS BLENDED OUT OF LIMITS FROM STA 867-873. REMOVED SEAT TRACK; FABED SEAT TRACK IAW SRM 53-60-52 FIG 1; TREATED AND PRIMED IAW 51-20-01; INSTALLED IAW 51-40-02; TOP COAT IAW 51-21-21.SDR AWXA0001081Seat Track · dentedCABIN SEAT TRACK STA 945 RBL 25 TOP OF TRACK HAS DENT OUT OF LIMITS. REMOVED, FABED AND INSTALLED SEAT TRACK SECTION IAW SRM 53-00-52 FIG 204 AND 51-40-02SDR AWXA0001080Seat Track · gougedCABIN SEAT TRACK LBL 45 HAS NUMEROUS BLEND OUTS OUT OF LIMITS FROM STA 723 - 800. REMOVED DAMAGED SEAT TRACK SECTION AND TONGUE IAW B737 SRM 53-00-52 FIG 204; FABED SEAT TRACK, REPAIR SPLICE, AND RADIUS FILLERS IAW 53-00-52 FIG 204; INSTALLED SEAT TRACK, REPAISDR AWXA0001078Seat Track · damagedCABIN SEAT TRACK LBL 45 HAS NUMEROUS BLEND OUTS THAT WERE OUT OF LIMITS. REMOVED, FABED REPLACEMENT SEAT TRACK AND REINSTALLED SEAT TRACK IAW SRM 53-00-50.SDR AALA20010046Seat Track · corrodedTUL - FOUND CORROSION ON SEAT TRACK STATION 764 UPPER SURFACE OF LUGS. INSTALLED SEAT TRACK REPAIR PLUG PER SRM 53-10 FIG 4 SHEET 2. (M)SDR AALA20010057Seat Track · corrodedTUL - FOUND NR 1 SEAT TRACK CORRODED STATION 1115-1118. CUT OUT DAMAGE AND INSTALLED PLUG PER SRM 53-05. (M)SDR AALA20010049Seat Track · corrodedTUL - FOUND SEAT TRACK NR 1 CORRODED STATION 577-578. CUT OUT DAMAGED AREA AND INSTALLED PLUG REPAIR PER SRM 53-05. (M)SDR AALA20010048Seat Track · corrodedTUL - FOUND CORROSION ON SEAT TRACK NR 1 AT STATION 562. REMOVED OUT OF LIMITS CORROSION AND INSTALLED PLUG REPAIR PER SRM 53-05. (M)SDR MALA000797Seat Track · corrodedFOUND DURING 4K HEAVY CHECK INSPECTION, HEAVY CORROSION ON RT CENTER AISLE SEAT TRACK APPROXIMATELY STA 294 - 374. MAINTENANCE COMPLETED REPAIR IAW EO S53060.SDR MALA000796Seat Track · corrodedFOUND DURING 4K HEAVY INSPECTION, CORROSION ON LT CENTER AISLE SEAT TRACK APPROXIMATELY STA 294 - 379. MAINTENANCE COMPLETED REPAIR IAW EO S53060.
Back to JASC 5347