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 97ZZZM804Seat Track · corrodedFOUND CORROSION (C53-107-01) ON SEAT TRACK STATION 328-360 RBL 52 WL 208. REPAIRED SEAT TRACK PER SRM 51-10-2 AND 51-40-02. (M)SDR 97ZZZM1004Seat Track · corrodedFOUND CORROSION (C53-107-01) ON SEAT TRACK STATION 328-360 RBL 52 WL 208. REPAIRED SEAT TRACK PER SRM 51-10-2 AND 51-40-02.SDR ZZDA5310997Seat Track · corrodedDURING C-CHECK, FOUND EXFOLIATION CORROSION IN INBOARD SEAT TRACK AT STA 344. FABRICATED NEW SEAT TRACK FROM BAC 1520-792 13.75 INCHES BY 3.5 INCHES IAW B737 SRM 53-10-5. INSTALLED IAW B737 SRM 53-10-5. (X)SDR ZZDA5310897Seat Track · corrodedDURING C-CHECK, FOUND CORROSION IN RIGHT OUTBOARD SEAT TRACK AT STA 344. FABRICATED NEW FLOOR TRACK SECTION FROM BAC 1520-792 34 INCHES BY 3.25 INCHES IAW B737 SRM 53-10-5. INSTALLED IAW B737 SRM 51-30-3. (X)SDR WRLADRC031Seat Track · corrodedMAIN DECK, AFT OF NR 4 GALLEY, BS 806 TO BS 920 LBL 9 SEAT TRACK FLANGE FOUND CORRODED. SEAT TRACK FROM BS 830 TO BS 930 FABRICATED AS PER MD-11 SRM VOL III 53-42-01 FIG 2 REV 20 AND INSTALLED AS PER MD-11 SRM VOL 1 53-70-00 FIG 1 REV 20. SEAT TRACK FROM BS SDR MWEA97428Seat Track · corrodedDURING D-CHECK, STA 588 TO 745 NR 4 SEAT TRACK CORRODED. MAINT REPAIRED IAW SRM 53-05.SDR MWEA97427Seat Track · corrosionDURING D-CHECK, BETWEEN STA 718 AND 737 NR 1 SEAT TRACK CORRODED. MAINT REPAIRED IAW SRM 53-05 FIG 4A.SDR MWEA97426Seat Track · corrodedDURING D-CHECK, BETWEEN STA 200 TO 266 NR 4 SEAT TRACK CORRODED. MAINT REPAIRED IAW SRM 53-05 FIG 4D.SDR MWEA97425Seat Track · corrodedDURING D-CHECK, BETWEEN STA 200 TO 266 NR 3 SEAT TRACK CORRODED. MAINT REPAIRED IAW SRM 53-05 FIG 4D.SDR MWEA97423Seat Track · corrodedDURING D-CHECK, NR 1 SEAT TRACK CHANNEL STA 760 CORRODED. MAINT REPAIRED IAW SRM 53-05 FIG 4A.SDR MWEA97422Seat Track · corrodedDURING D-CHECK, STA 579 TO 598 NR 3 SEAT TRACK LUG CORRODED. MAINT REPAIRED IAW SRM 53-05 FIG 4A.SDR MWEA97421Seat Track · corrodedDURING D-CHECK, STA 538 NR 4 SEAT TRACK LUG BLENDED OUT OF LIMITS. MAINT REPAIRED IAW SRM 53-05 FIG 4A.SDR MWEA97420Seat Track · corrodedDURING D-CHECK, STA 737 NR 3 SEAT TRACK CORRODED. MAINT REPAIRED IAW SRM 53-05 FIG 4D.SDR MWEA97418Seat Track · corrodedDURING D-CHECK, STA 916 TRACK CHANNELL AND STA 914 NR 4 SEAT TRACK LUG BLENDED OUT OF LIMIT. MAINT REPAIRED IAW DAC SRM 53-05 FIG 4A.SDR 97ZZZM806Seat Track · corrodedFOUND CORROSION (C53-107-01) ON SEAT TRACK STATION 480-520 RBL 22 WL 208. REPAIRED SEAT TRACK PER SRM 51-40-02, 51-40-08.SDR 97ZZZM805Seat Track · corrodedFOUND CORROSION (C53-107-01) ON SEAT TRACK STATION 520-540 RBL 22 WL 208. REPAIRED SEAT TRACK PER SRM 51-40-02 AND 53-10-51. (M)SDR 97ZZZM1003Seat Track · corrodedFOUND CORROSION (C53-107-01) ON SEAT TRACK STATION 520-540 RBL 22 WL 208. REPAIRED SEAT TRACK PER SRM 51-40-02 AND 53-10-51.SDR 97ZZZM1002Seat Track · corrodedFOUND CORROSION (C53-107-01) ON SEAT TRACK STATION 480-520 RBL 22 WL 208. REPAIRED SEAT TRACK PER SRM 51-40-02, 51-40-08.SDR P5CA9701092Tie Down Track · crackedFWD CARGO TIE DOWN TRACK CRACKED AT BS 650 TO BS 660 RBL 44. REPLACED TIE DOWN TRACK AT BS 640 TO BS 700 PER BOEING SRM 53-10-05.SDR SCNA97198Seat Track · corrodedDURING HEAVY MAINTENANCE VISIT, THE SEAT TRACK BETWEEN STATIONS 1025 TO 1090, LBL 46 TO 47, WAS FOUND CORRODED. REMOVED, FABRICATED, AND INSTALLED NEW SEAT TRACK IAW B727 SRM 53-10-02 AND 53-10-03.SDR 97ZZZM803Floor Track · corrodedFOUND CORROSION (C53-208-01) AROUND NUTPLATES ON AFT CARGO BAY FLOOR TRACK BS 727-947 RBL 1380. REMOVED CORROSION, FABRICATED REPAIR PARTS, INSTALLED PER SRM 53-60-53, 51-40-02. (M)SDR 97ZZZM801Cargo Track · corrodedFOUND CORROSION (C53-208-01) ON NUTPLATES AFT CARGO BAY FLOOR TRACKS BS 727-947 LBL 12.50. REMOVED, FABRICATED AND INSTALLED REPAIR PARTS PER SRM 51-40-02. (M)SDR 97ZZZM800Cargo Track · corrodedFOUND CORROSION (C53-208-01) AROUND NUTPLATE LOCATIONS ON AFT CARGO BAY FLOOR TRACK BS 727-947 LBL 8.10 AND LBL 3. REMOVED, FABRICATED AND INSTALLED REPAIR PARTS PER SRM 51-10-2, 51-20-01 AND 51-40-02. (M)SDR 97ZZZM799Cargo Track · corrodedFOUND CORROSION (C53-208-01) AROUND NUTPLATE LOCATIONS ON AFT CARGO BAY TRACK BS 727-947 RBL 3. REMOVED, FABRICATED AND INSTALLED REPAIR PARTS PER SRM 51-40-02. (M)SDR 97ZZZM1011Cargo Track · corrodedFOUND CORROSION (C53-208-01) AROUND NUTPLATE LOCATIONS ON AFT CARGO BAY TRACK BS 727-947 RBL 3. REMOVED, FABRICATED AND INSTALLED REPAIR PARTS PER SRM 51-40-02.SDR 97ZZZM1010Cargo Track · corrodedFOUND CORROSION (C53-208-01) AROUND NUTPLATE LOCATIONS ON AFT CARGO BAY FLOOR TRACK BS 727-947 LBL 8.10 AND LBL 3. REMOVED, FABRICATED AND INSTALLED REPAIR PARTS PER SRM 51-10-2, 51-20-01 AND 51-40-02. (M)SDR 97ZZZM1009Cargo Track · corrodedFOUND CORROSION (C53-208-01) ON NUTPLATES AFT CARGO BAY FLOOR TRACKS BS 727-947 LBL 12.5. REMOVED FABRICATED AND INSTALLED REPAIR PARTS PER SRM 51-40-02. (M)SDR 97ZZZM1007Cargo Track · corrodedFOUND CORROSION (C53-208-01) AROUND NUTPLATES ON AFT CARGO BAY FLOOR TRACK BS 727-947 RBL 1380. REMOVED CORROSION, FABRICATED REPAIR PARTS, INSTALLED PER SRM 53-60-53, 51-40-02. (M)SDR C2XA97IA172Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, RIGHT OUTBOARD SEAT TRACK WAS FOUND TO BE CORRODED BETWEEN FRAMES 34 AND 36. MAINTENANCE REMOVED THE DAMAGED SECTION OF SEAT TRACK AND PERFORMED A SPLICE REPAIR IAW ATR 42 SRM 53-53-00 AND THE AIRCRAFT WAS APPROVED FOR RETURN SDR C2XA97IA171Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE RIGHT FLIGHT ATTENDANT SEAT TRACK WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED SEAT TRACK AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA97IA169Seat Track · corrodedIAH - DURING C-CHECK INSPECTION, THE RIGHT INBOARD SEAT TRACK WAS FOUND TO BE CORRODED BETWEEN FRAMES 34 AND 36. MAINTENANCE REMOVED AND REPLACED THE AFFECTED SEAT TRACK AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR ABXA9701090Seat Track · corrodedDURING C-CHECK, FOUND THE SEAT TRACK AT F/STA 294 TO 484 BL 0 CORRODED. REMOVED AND REPLACED CORRODED SECTION OF SEAT TRACK IAW DC9 SRM 51-30-1, 51-30-2 AND 51-30-5.SDR 97ZZZM999Seat Track · corrodedFOUND CORROSION (C53-107-01) ON SEAT TRACK STATION 330-336 RBL 42 WL 208. REPAIRED PER SRM 51-40-02 AND 51-20-01.SDR 97ZZZM998Seat Track · corrodedFOUND CORROSION (C53-107-01) ON SEAT TRACK STATION 328 RBL 22. REPAIRED PER SRM 53-00-52. (M)SDR 97ZZZM997Seat Track · corrodedFOUND CORROSION (C53-107-01) ON SEAT TRACK STATION 348 BL 0 WL 208. REMOVED CORROSION .020 REMOVED ORIG .080 WITHIN LIMITS PER SRM 51-20-01 AND 53-00-52.SDR 97ZZZM990Seat Track · corrodedFOUND CORROSION (C53-107-01) ON SEAT TRACK BS 582 RBL 25 WL 208. REPAIRED PER SRM 51-40-02 AND 53-00-52, REPLACED SEAT TRACK.SDR 97ZZZM989Seat Track · corrodedFOUND CORROSION (C53-107-01) ON SEAT TRACK BS 540 LBL 45 WL 208. REPAIRED PER SRM 51-20-02, 53-60-51, 51-20-01.SDR 97ZZZM819Seat Track · corrodedFOUND CORROSION (C53-107-01) ON SEAT TRACK BS 540 LBL 45 WL 208. REPAIRED PER SRM 51-20-02, 53-60-51, 51-20-01. (M)SDR 97ZZZM818Seat Track · corrodedFOUND CORROSION (C53-107-01) ON SEAT TRACK BS 582 RBL 25 WL 208. REPAIRED PER SRM 51-40-02 AND 53-00-52, REPLACED SEAT TRACK.SDR 97ZZZM811Seat Track · corrodedFOUND CORROSION (C53-107-01) ON SEAT TRACK STATION 348 BL 0 WL 208. REMOVED CORROSION .020 REMOVED ORIG .080 WITHIN LIMITS PER SRM 51-20-01 AND 53-00-52. (M)SDR 97ZZZM810Seat Track · corrodedFOUND CORROSION (C53-107-01) ON SEAT TRACK STATION 328 RBL 22. REPAIRED PER SRM 53-00-52. (M)SDR 97ZZZM809Seat Track · corrodedFOUND CORROSION (C53-107-01) ON SEAT TRACK STATION 330-336 RBL 42 WL 208. REPAIRED PER SRM 51-40-02 AND 51-20-01. (M)SDR 97ZZZM808Seat Track · corrodedFOUND CORROSION (C53-107-01) ON SEAT TRACK STATION 520-540 RBL 42 WL 208. REPAIRED PER SRM 51-40-02. (M)SDR 97ZZZM807Seat Track · corrodedFOUND CORROSION (C53-107-01) ON SEAT TRACK STATION 480-520 RBL 42 WL 208. REPAIRED PER SRM 53-00-52, 51-40-02, 51-21-41. (M)SDR 97ZZZM795Seat Track · corrodedFOUND CORROSION 9C53-107-01) ON SEAT TRACK BS 552, RBL 45 WL 208. REPAIRED PER SRM 53-00-52, 51-40-02 AND MM 51-21-9. (M)SDR 97ZZZM1015Seat Track · corrodedFOUND CORROSION (C53-107-01) ON SEAT TRACK BS 552, RBL 45 WL 208. REPAIRED PER SRM 53-00-52, 51-40-02 AND MM 51-21-9.SDR 97ZZZM1001Seat Track · corrodedFOUND CORROSION (C53-107-01) ON SEAT TRACK STATION 480-520 RBL 42 WL 208. REPAIRED PER SRM 53-00-52, 51-40-02, 51-21-41.SDR 97ZZZM1000Seat Track · corrodedFOUND CORROSION (C53-107-01) ON SEAT TRACK STATION 520-540 RBL 42 WL 208. REPAIRED PER SRM 51-40-02. (M)SDR PCAA9700423Seat Track · corrodedDURING A ROUTINE C-CHECK, THE RIGHT INBOARD CABIN SEAT RAIL WAS FOUND CORRODED BETWEEN STATIONS X187 AND X215. CORROSION BLENDED AND TREATED IAW DHC REPAIR DRAWING 8-53-2860. A/C RETURNED TO SERVICE. (M)SDR P5CA9701165Tie Down Ftg · corrodedLEVEL 1 - M/D TIE DOWN FITTING AND FLANGE FOUND CORRODED AT BS 460 LBL 40. CORROSION REMOVED AND REPROTECTED PER BOEING SRM 51-10-01, 51-10-02.
Back to JASC 5347