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 HALA0800256Seat Track · corrodedLEVEL 1 CORROSION ON SEAT TRACK AT LBL 88.5, STA 1288, AREA HAS BEEN REWORKED BEFORE. SEAT TRACK REPLACED PER SRM.SDR HALA0800251Seat Track · corrodedLEVEL 1 CORROSION ON SEAT TRACK CROWN/BASE AT LBL 88.5, STA 1197+144, AREA HAS BEEN REWORKED BEFORE. SEAT TRACK WAS REPLACED PER SRM.SDR HALA0800258Seat Track · corrodedLEVEL 1 CORROSION ON SEAT TRACK CROWN/BASE AT 88.5, STA 1319, AREA HAS BEEN REWORKED BEFORE. REPLACED SEAT TRACK PER SRM.SDR HALA0800259Seat Track · corrodedLEVEL 1 CORROSION ON SEAT TRACK CROWN/BASE AT LBL 88.5, STA 1339, AREA HAS BEEN REWORKED BEFORE. SEAT TRACK REPLACED PER SRM.SDR HALA0800197Seat Track · corrodedLEVEL 1 CORROSION RBL 54.75, SEAT TRACKS AT STA 1436, BASE OF TRACKS. CORROSION REMOVED PER SRM 51-10-02, REV 76 AND SRM 53-00-52/101. REWORK WITHIN LIMITS.SDR USAA920080489Seat Track · corrodedMIA - MAJOR REPAIR - C4 CHECK - LEVEL 2 CORROSION ON CABIN SEAT TRACK, BS 426 - BS 665, RBL 88.5. REPLACED CABIN CABIN SEAT TRACK, BS 426 - BS 665, RBL 88.5 IAW B767 SRM 53-00-52.SDR USAA920080439Seat Track · corrodedSAL - MAJOR REPAIR - C7 CHECK - CORROSION ON CABIN SEAT TRACK, BS 605 / FR 12 TO BS 950 / FR 24, +Y1292. REPLACED CORROSION ON CABIN SEAT TRACK, BS 605 / FR 12 TO BS 950 / FR 24, +Y1292, IAW A320 SRM 51-72-11.SDR USAA920080437Seat Track · corrodedSAL - MAJOR REPAIR - C7 CHECK - CORROSION ON CABIN SEAT TRACK, BS 1323 / FR 31 , -Y1292. REPAIRED CABIN SEAT TRACK, BS 1323 / FR 31, -Y1292 IAW A320 SRM 53-00-15.SDR ASAA0842610Seat Track · defectiveBS 500B RBL 24 SEAT TRACK INERFERES WITH SEAT INSTALLATION BS 500B TO BS 500D RBL 24. SEAT TRACK REPLACED IAW B737 400 SRM 53 00 52 REPAIR 1 FIG 201.SDR USAA920080462Seat Track · corrodedSAL - MAJOR REPAIR - C7 CHECK - CORROSION ON CABIN SEAT TRACK, BS 709 / FR 16 - BS 808 / FR 20, +Y765. REPLACED CABIN SEAT TRACK, BS 605 / FR 12 - BS 808 / FR 20, +Y765 IAW A320 SRM 51-72-11.SDR USAA920080436Seat Track · corrodedSAL - MAJOR REPAIR - C7 CHECK - CORROSION ON CABIN RAIL SEAT BEAM, BS 3101 / FR 65, +Y765. REPLACED CABIN RAIL SEAT BEAM, BS 3043 / FR 64 - BS 3158 / FR 66, +Y765 IAW A320 SRM 51-72-11.SDR 08FDEA00413Seat Track · corrodedMAIN CARGO COMPARTMENT, SEAT TRACK HAS CORROSION IN SEVERAL PLACES FROM STA 360 TO STA 380, LBL 48. REMOVED CORROSION IAW SRM 51-10-6 AND FOUND TO BE OUT OF LIMITS IAW SRM 53-10-2 FIG 7 AND 53-10-1 FIG3 SRM PAG23. REMOVED SEAT TRACK SECTION IAW 51-30-2. FABSDR USAA920080427Seat Track · corrodedMIA - MAJOR REPAIR - C4 CHECK - CORROSION ON CABIN SEAT TRACK, BS 347, RBL 86. REPLACED SEAT TRACK BS, 347 - BS 522, RBL 86.SDR USAA920080460Seat Track · corrodedSAL - MAJOR REPAIR - C7 CHECK - CORROSION ON CABIN SEAT TRACK, BS 1810 / FR 41 - BS 2136 / FR 47, +Y765. REPLACED CABIN SEAT TRACK, BS 1810 / FR 41 - BS 2136 / FR 47, +Y765 IAW A320 SRM 51-72-11.
SDR DLM90080197Seat Track · gougedCABIN SEAT TRACK GOUGED AND CORRODED OUT OF LIMITS FS 588-759 RBL 54. REPAIRED SEAT TRACK, IAW MD90 SRM 53-40-01.SDR 08FDEA00412Seat Track · corrodedMAIN CARGO COMPARTMENT, SEAT TRACK CORRODED IN NUMEROUS PLACES FROM BS 360-400, LBL 24. REMOVED CORROSION AND FOUND TO BE OUT OF LIMITS IAW SRM 53-10-2 FIG7 AND 53-10-1 FIG3, SRM PAGE 23. REMOVED SEAT TRACK SECTION IAW SRM 51-30-2. FABRICATED NEW SEAT TRACKSDR HALA0800147Seat Track · corrodedLEVEL 2 CORROSION SECTION 46 RBL 11, SEAT TRACK AT STA 1197.90. REWORKED IAW SRM 53-00-52-101.SDR HALA0800173Seat Track · corrodedLEVEL 1 CORROSION SECTION 46, SEAT TRACKS AT RBL 88.5, STA 1288. REWORK IAW SRM 53-00-52/101 AND REPLACED SEAT TRACK IAW SRM WHERE DAMAGE WAS OUT OF LIMITS.SDR HALA0800196Seat Track · corrodedLEVEL 1 CORROSION RBL 54.75, SEAT TRACKS AT STA 1401, BASE OF TRACKS. CORROSION REMOVED PER SRM 51-10-02, REV 76 AND SRM 53-00-52/101. REWORK WITHIN LIMITS.SDR HALA0800195Seat Track · corrodedLEVEL 1 CORROSION RBL 54.75, SEAT TRACKS AT STA 1370, BASE OF TRACKS. CORROSION REMOVED PER SRM 51-10-02, REV 76 AND SRM 53-00-52/101. REWORK WITHIN LIMITS.SDR HALA0800194Seat Track · corrodedLEVEL 1 CORROSION RBL 54.75, SEAT TRACKS AT STA 1351, BASE OF TRACKS. CORROSION REMOVED PER SRM 51-10-02, REV 76 AND SRM 53-00-52/101. REWORK WITHIN LIMITS.SDR HALA0800193Seat Track · corrodedLEVEL 1 CORROSION RBL 54.75, SEAT TRACKS, STA 1338, BASE OF TRACK. CORROSION REMOVED PER SRM 51-10-02 REV 76 AND SRM 53-00-52/101. REWORK WITHIN LIMITS.SDR HALA0800192Seat Track · corrodedLEVEL 1 CORROSION RBL 54.75, SEAT TRACKS AT STA 1307, BASE OF TRACK. CORROSION REMOVED PER SRM 51-10-02, REV 76 AND SRM 53-00-52/101. REWORK WITHIN LIMITS.SDR HALA0800191Seat Track · corrodedLEVEL 1 CORROSION RBL 54.75, SEAT TRACK AT STA 1275, BASE OF TRACKS. CORROSION REMOVED PER SRM 51-10-02 REV 76 AND SRM 53-00-52/101. REWORK WITHIN LIMITS.SDR HALA0800190Seat Track · corrodedLEVEL 1 CORROSION RBL 54.75, SEAT TRACKS AT STA 1241, BASE OF TRACKS. CORROSION REMOVED PER SRM 51-10-02, REV 76 AND SRM 53-00-52/101. REWORK WITHIN LIMITS.SDR HALA0800189Seat Track · corrodedLEVEL 1 CORROSION RBL 54.75, SEAT TRACKS, STA 1210, BASE OF TRACKS. CORROSION REMOVED PER SRM 51-10-02 REV 76 AND SRM 53-00-52/101. REWORK WITHIN LIMITS.SDR HALA0800188Seat Track · corrodedLEVEL 1 CORROSION RBL 54.75, SEAT TRACKS, STA 1197+120, BASE OF TRACK. CORROSION REMOVED PER SRM 51-10-02 REV 76 AND SRM 53-00-52/101. REWORK WITHIN LIMITS.SDR HALA0800187Seat Track · corrodedLEVEL 1 CORROSION RBL 54.75, SEAT TRACKS AT STA 1197+113, BASE OF TRACK. CORROSION REMOVED PER SRM 51-10-02 REV 76 AND SRM 53-00-52/101. REWORK WITHIN LIMITS.SDR HALA0800186Seat Track · corrodedLEVEL 1 CORROSION AT RBL 54.75, SEAT TRACKS, STA 1197+88, BASE OF TRACKS. CORROSION REMOVED PER SRM 51-10-02 REV 76 AND SRM 53-00-52/101. REWORK WITHIN LIMITS.SDR HALA0800185Seat Track · corrodedLEVEL 1 CORROSION AT RBL 54.75, SEAT TRACKS AT STA 1197+85, BASE OF TRACK. CORROSION REMOVED PER SRM 51-10-02, REV 76 AND SRM 53-00-52/101. REWORK WITHIN LIMITS.SDR HALA0800184Seat Track · corrodedLEVEL 1 CORROSION AT RBL 54.75, SEAT TRACKS, STA 1197+81, BASE OF TRACK. CORROSION REMOVED PER SRM 51-10-02, REV 76 AND SRM 53-00-52/101. REWORK WITHIN LIMITS.SDR HALA0800183Seat Track · corrodedLEVEL 1 CORROSION AT RBL 54.75, SEAT TRACKS AT STA 1197+63, BASE OF TRACK. CORROSION REMOVED PER SRM 51-10-02, REV 76 AND SRM 53-00-52/101. REWORK WITHIN LIMITS.SDR HALA0800182Seat Track · corrodedLEVEL 1 CORROSION AT RBL 54.75, SEAT TRACKS AT STA 1197+49, BASE OF TRACK. CORROSION REMOVED PER SRM 51-10-02, REV 76 AND SRM 53-00-52/101. REWORK WITHIN LIMITS.SDR HALA0800181Seat Track · corrodedLEVEL 1 CORROSION AT RBL 54.75, SEAT TRACKS AT STA 1197+22, BASE OF TRACKS. CORROSION REMOVED PER SRM 51-10-02, REV 76 AND SRM 53-00-52/101, REWORK WITHIN LIMITS.SDR HALA0800180Seat Track · corrodedLEVEL 1 CORROSION AT RBL 54.75, SEAT TRACKS, STA 1186, BASE OF TRACKS. CORROSION REMOVED IAW SRM 51-10-02, REV 76 AND SRM 53-00-52/101. REWORK WITHIN LIMITS.SDR HALA0800179Seat Track · corrodedLEVEL 1 CORROSION AT RBL 54.75, SEAT TRACKS, STA 1170, AT THE BASE OF TRACKS. CORROSION REMOVED PER SRM 51-10-02, REV 76 AND SRM 53-00-52/101. REWORK WITHIN LIMITS.SDR HALA0800178Seat Track · corrodedLEVEL 1 CORROSION AT RBL 54.75, SEAT TRACK, STA 1156, AT THE BASE OF TRACKS. CORROSION REMOVED PER SRM 51-10-02, REV 76 AND SRM 53-00-52/101. REWORK WITHIN LIMITS.SDR HALA0800177Seat Track · corrodedLEVEL 1 CORROSION SECTION 46, SEAT TRACKS AT RBL 88.5, STA 1197+20. REWORKED IAW SRM 53-00-52/101, AND REPLACED IAW SRM SEAT TRACKS WHERE DAMAGE WAS OUT OF LIMITS.SDR HALA0800176Seat Track · corrodedLEVEL 1 CORROSION SECTION 46, SEAT TRACKS AT RBL 88.5, STA 1094. REWORKED IAW SRM 53-00-52/101, AND REPLACED SEAT TRACKS WHERE DAMAGE WAS OUT OF LIMITS.SDR HALA0800175Seat Track · corrodedLEVEL 1 CORROSION SECTION 46, SEAT TRACKS, AT RBL 88.5, STA 1186. REWORKED IAW SRM 53-00-52/101, AND REPLACED SEAT TRACKS WHERE OUT OF LIMITS.SDR HALA0800174Seat Track · corrodedLEVEL 1 CORROSION SECTION 46, SEAT TRACKS AT RBL 88.5, STA 1197+2. REWORKED IAW SRM 53-00-52/101, AND REPLACED SEAT TRACKS WHERE DAMAGE WAS OUT OF LIMITS.SDR HALA0800172Seat Track · corrodedLEVEL 1 CORROSION SECTION 46 SEAT TRACKS, AT RBL 88.5, STA 1243. REWORKED IAW SRM 53-00-52/101, AND REPLACED SEAT TRACKS WERE OUT OF LIMITS.SDR HALA0800171Seat Track · corrodedLEVEL 1 CORROSION SECTION 46, SEAT TRACKS AT RBL 88.5, STA 1275. REWORKED IAW SRM 53-00-52/101, AND REPLACED SEAT TRACKS WHERE OUT OF LIMITS.SDR HALA0800170Seat Track · corrodedLEVEL 1 CORROSION SECTION 46, SEAT TRACKS AT RBL 88.5, STA 1288. REWORKED IAW SRM 53-00-52/101, AND REPLACED SEAT TRACKS IAW SRM WHERE OUT OF LIMITS.SDR HALA0800169Seat Track · corrodedLEVEL 1 CORROSION SECTION 46, SEAT TRACKS AT RBL 88.5, STA 1307. REWORKED IAW SRM 53-00-52/101, AND REPLACED SEAT TRACKS WERE DAMAGE WAS OUT OF LIMITS.SDR HALA0800168Seat Track · corrodedLEVEL 1 CORROSION SECTION 46, SEAT TRACKS AT RBL 88.5, STA 1313. REWORKED IAW SRM 53-00-52/101 AND REPLACED SEAT TRACKS WHERE OUT OF LIMITS.SDR HALA0800167Seat Track · corrodedLEVEL 1 CORROSION SECTION 46 SEAT TRACKS, AT RBL 88.5, STA 1320. REWORKED IAW SRM 53-00-52/101, REPLACED SEAT TRACKS IAW SRM WHERE DAMAGE WAS OUT OF LIMITS.SDR HALA0800166Seat Track · corrodedLEVEL 1 CORROSION SECTION 46 SEAT TRACKS AT RBL 88.5, STA 1339. REWORKED IAW SRM 53-00-52/101, AND REPLACED SEAT TRACKS IAW SRM WHERE DAMAGE WAS OUT OF LIMITS.SDR HALA0800165Seat Track · corrodedLEVEL 1 CORROSION SECTION 46, SEAT TRACKS AT RBL 88.5, STA 1370. REWORKED IAW SRM 53-00-52/101, AND REPLACED SEAT TRACKS IAW SRM WHERE DAMAGE WAS OUT OF LIMITS.SDR HALA0800164Seat Track · corrodedLEVEL 1 CORROSION SECTION 46, SEAT TRACKS AT RBL 88.5, STA 1384. REWORKED IAW SRM 53-00-52/101, AND REPLACED SEAT TRACKS IAW SRM WHERE DAMAGE WAS OUT OF LIMITS.
Back to JASC 5347