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 DL75E090691Seat Track · corrodedMAIN CABIN SEAT TRACK GOUGED AND CORRODED AT STA 440-640 RT RBL 45. C/W AT SAA, SAT ON N/R 126444 JOB 82600260001.SDR DL75E090689Seat Track · corrodedCABIN SEAT TRACK GOUGED SEVERAL PLACES STA 1080-1180 RBL 45 C/W AT SAA - SAT ON N/R 126470 JOB 82601390001.SDR DL75E090687Seat Track · corrodedMAIN CABIN SEAT TRACK GOUGED AND CORRODED AT STA 440-640 RT RBL 24/ AR SAA - SAT ON N/R 126443 JOB 82600280001.SDR DL75E090685Seat Track · gougedCABIN SEAT TRACK GOUGED SEVERAL PLACES STA 1540-1640 RBL 24 CORROSION AT STA 1640 C/W AT SAA - SAT ON N/R 136452 JOB 82601340001.SDR ASAA0995162Cargo Track · damagedCARGO TIE DOWN TRACK HAS MECHANICAL DAMAGE. REMOVED AND REPLACED TRACK.SDR AALA20090512TUL05Seat Track · corrodedNR 3 SEAT TRACK CORRODED OUT OF LIMITS. INSTALLED PLUG REPAIR PER AARD 53-20-00-10.SDR AALA20090424TUL31Cargo Track · corrodedAFT CARGO FWD RIGHT TIEDOWN TRACK IS CORRODED BTWN STA 1005-1155. REMOVED AND REPLACED TIE DOWN TRACK.SDR UALA2009041601100Seat Track · gougedMAIN CABIN RT SEAT TRACK GOUGED STA 488, RBL 100. MAJOR REPAIR ACCOMPLISHED. REMOVED DAMAGED SECTION OF SEAT TRACK STA 423.45 TO 511.45, RBL 88.5 AND INSTALLED NEW SECTION OF SEAT TRACK AND SPLICED PARTS.SDR KCSA091028Seat Track · crackedMAIN DECK SEAT TRACK AT STA 846 LBL-11 HAS CRACKED FLANGE .250 INCH.SDR ASAA0995453Cargo Track · wornFWD CARGO PIT TIE DOWN AT STA 495 HAS A WORN LUG ABOVE STR 26L. REMOVED TRACK SECTION, FABBED REPLACEMENT TRACK AND SPLICE PARTS AND INSTALLED REPAIR PARTS IAW EA 900 53EA 01219.SDR IPXA09555707Seat Track · corrodedINSPECTION TYPE:C4 MAIN CABIN 44 SECTION, SEAT TRACK AT STA 1198 CORRODED AT NUT PLATE. BLENDED CORROSION & REPLACED FLOORBOARD. ACCOMPLISHED REPAIR IAW EO B757-5310-33285-ASDR IPXA09555706Seat Track · corrodedINSPECTION TYPE:C4 MAIN CABIN 44 SECTION SEAT TRACK AT STA 1200 RBL 58 CORRODED NUT PLATE. BLENDED CORROSION, 10X ONSP, NDT, ALODINE, PRIMED, FILLED SEAT TRACK RELOCATED HOLE, FABBED NEW PANEL.SDR ASOA200900442Seat Track · corrodedLT PAX FLOOR SEAT RAIL FS 683.50 TO FS 836.50 IS CORRODED (13259/PG.83).SDR ASOA200900441Seat Track · corrodedLT PAX FLOOR SEAT RAIL FS 581.00 TO FS 683.50 IS CORRODED (13259/PG 83).SDR ASOA200900440Seat Track · corrodedLT PAX FLOOR SEAT RAIL FS 485.00 TO FS 581.00 IS CORRODED. BLENDED CENTER PAX DOOR FLOOR SEAT RAIL FS 485-581 IAW SRM 51-21-11, ALL BLENDED AREAS FOUND TO BE WITHIN ALLOWABLE LIMITS IAW SRM 53-31-49, TREATED BLENDED AREAS IAW SRM 51-21-11.SDR ASOA200900439Seat Track · corrodedLT PAX FLOOR SEAT RAIL FS 374.00 TO FS 485.00 IS CORRODED (13259/PG 82).SDR ASOA200900438Seat Track · corrodedRT PAX FLOOR SEAT RAIL FS 836.50 TO FS 988.00 IS CORRODED (13259/ PG 82). BLENDED CORROSION ON RT PAX FLOOR SEAT RAIL IAW SRM 51-21-11, ALL AREAS BLENDED FOUND TO BE WITHIN LIMITS IAW SRM 53-51-49, TREATED, & PRIMED BLENDED AREAS IAW SRM 51-21-11.SDR ASOA200900437Seat Track · corrodedRT PAX FLOOR SEAT RAIL FS 683.50 TO FS 836.50 IS CORRODED (13259/PG 82).SDR ASOA200900436Seat Track · corrodedRT PAX FLOOR SEAT RAIL FS 581.00 TO FS 683.50 IS CORRODED (13259/PG 81).SDR ASOA200900435Seat Track · corrodedRT PAX FLOOR SEAT RAIL FS 485.00 TO FS 581.00 IS CORRODED (13259/PG 81).SDR ASOA200900434Seat Track · corrodedRT PAX FLOOR SEAT RAIL FS 350.00 TO FS 485.00 IS CORRODED. BLENDED FLOOR SEAT RAIL, MATERIAL LOSS OF .050 NOTED, FOUND TO BE OUT OF LIMITS IAW SRM 53-21-49, INSTALLED SPLICE SECTION OF SEAT RAIL IAW AMM 53-00-49. INSTALLED SERVICEABLE SEAT TRACK IAW ASA AMMSDR ASOA200900433Seat Track · corrodedRT PAX SIDE SEAT RAIL FS 784.00 TO FS 861.00 IS CORRODED (13259/PG 84). BLENDED CORROSION IAW SRM 53-41-49, ALL AREAS BLENDED FOUND TO BE WITHIN LIMITS IAW SRM 53-41-49. TREATED REWORKED AREAS OF RT PAX SIDE SEAT RAIL IAW SRM 51-21-11.SDR ASOA200900432Seat Track · corrodedLEFT PAX SIDE SEAT RAIL FS 784.00 TO FS 861.00 IS CORRODED (13259/PG 84).SDR FDEA200904141297Seat Track · corrodedCABIN, LT STA 1731 X= 107 SEAT TRACK FOUND CORROSION. SEAT TRACK REPAIRED AS PER SRM 53-70-00 FIG. 6 VOL.I REV. 40. THIS REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100 REV. 107.SDR FDEA200904141296Seat Track · corrodedLT STA 1545 TO STA 1551 X= 8 SEAT TRACK FOUND CORRODED. REPAIRED PER SRM 53-70-00 FIG. I REV 40. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100 REV. 107.SDR FDEA200904141295Seat Track · corrodedRT STA 1471 X= -8 SEAT TRACK FOUND CORRODED. REPAIRED AS PER SRM 53-70-00 FIG I VOL I REV 40. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-10 REV 107.SDR FDEA200904141294Seat Track · corrodedRT STA 1531 - STA 1561 X= -8 SEAT TRACK FOUND CORRODED. REPAIRED AS PER SRM 53-70-00 FIG. I REV 40. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100 REV. 107.SDR AALA20090512TUL42Seat Track · damagedNR 1 SEAT TRACK DAMAGED AT STA 636. INSTALLED SEAT TRACK PLUG PER AARD 53-20-00-10.SDR AALA20090512TUL30Seat Track · corrodedCORROSION ON SEAT TRACK NR 5 BEYOND LIMITS, STA 234-237. INSTALLED SEAT TRACK PLUG PER AARD 53-20-00-10.SDR AALA20090512TUL11Seat Track · corrodedCORROSION BEYOND MANUAL LIMITS AT SEAT TRACK NR 6 AT STA 854-859. INSTALLED SEAT TRACK PLUG PER AARD 53-20-00-10.SDR AALA20090423TUL45Splice · corrodedLEVEL 1 CORROSION ON TIE DOWN TRACK SPLICE LEFT SIDE STATION 1212-1220. REMOVED AND REPLACED TRACK SPLICE PER SRM 51-30-05.SDR FDEA200904131283Seat Track · corrodedCABIN SEAT TRACK AT BL 0 IS CORRODED BETWEEN STA 1176 AND 1140. REMOVED SEAT TRACK SECTION IAW SRM 51-30-2. FABRICATED NEW SEAT TRACK IAW SRM 51-30-5 AND DRAWING NR 53FX976 REV B. DRILLED NEW SEAT TRACK IAW SRM 51-30-5. TREATED AND PRIMED NEW SEAT TRACK IASDR QXEA2009041400249Seat Track · corrodedRT SEAT RAIL HAS CORROSION ON RAIL AT APPROX FS 553.00. BLENDED CORROSION, DEEPEST LOCATION REMOVED .013 MATERIAL, FOUND TO BE WITHIN LIMTS IAW CRJ 700 REO 670-53-00-013 STEP 1. ALODINED AND REIDENTIFIED SEAT TRACK IAW REO 670-53-00-013.SDR FDEA200904111265Seat Track · corrodedMAIN DECK CARGO STA 1175 TO STA 1257, X = -75.5 SEAT TRACK FOUND WITH SURFACE CORROSION. REPAIRED BY SECTIONAL SEAT TRACK REPLACEMENT AS PER SRM 53-70-00 FIGURE 1 VOLUME I, REVISION 40. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100, REVISION 107.SDR FDEA200904111264Seat Track · corrodedMAIN DECK CARGO STA 1301 TO STA 1381, X = 75.5 SEAT TRACK FOUND WITH SURFACE CORROSION.SDR FDEA200904111263Seat Track · corrodedMAIN DECK CARGO STA 1276 TO STA 1361, X = -75.5 SEAT TRACK FOUND WITH SURFACE CORROSION.SDR ASAA0975061Seat Track · chafedFIRST OFFICERS AFT O/B SEAT TRACK CHAFED AT AFT RADIUS. REMOVED AND REPLACED FIRST OFFICERS AFT O/B SEAT TRACK.SDR ASAA0975060Seat Track · chafedCAPTAINS AFT O/B SEAT TRACK CHAFED AT AFT RADIUS. REMOVED AND REPLACED CAPTAINS AFT O/B SEAT TRACK.SDR QXEA2009041400257Seat Track · corrodedLT OTBD SEAT TRACK HAS CORROSION BETWEEN FS 915.00 AND FS 950.00. BLENDED LT OTBD SEAT TRACK BETWEEN FS 915.00 AND FS 950.00 IAW REO 670-53-00-013 NOTE 1. MAX MATERIAL REMOVED AT DIMENSION "U" .005 INCH FOUND TO BE WITHIN LIMITS OF TABLE 1. ALODINED AND REISDR QXEA2009041400256Seat Track · corrodedPDX - 8YR TASK - LT OTBD SEAT TRACK HAS CORROSION BETWEEN FS 838.00 AND FS 858.00. BLENDED LT OTBD SEAT TRACK BETWEEN FS 838.00 AND FS 858.00 IAW REO 670-53-00-013 NOTE 1 MAX MATERIAL REMOVED AT DIMENSION "U" .005 FOUND TO BE WITHIN LIMITS OF TABLE 1. ALODINSDR QXEA2009041400255Seat Track · corrodedLT OTBD SEAT TRACK HAS CORROSION BETWEEN FS 785.00 AND FS 828.00. BLENDED LT OTBD SEAT TRACK BETWEEN FS 785.00 AND FS 828.00 IAW REO 670-53-00-013 NOTE 1. MAX MATERIAL REMOVED AT DIMENSION "U" .021 FOUND TO BE WITHIN LIMITS OF TABLE 1. ALODINED AND REIDENTISDR QXEA2009041400254Seat Track · corrodedLT OTBD SEAT TRACK HAS CORROSION BETWEEN FS 718.00 AND FS 761.00. BLENDED LT OTBD SEAT TRACK BETWEEN FS 718.00 AND FS 1.00 IAW REO 670-53-00-013 NOTE 1. MAX MATERIAL REMOVED AT DIMENSION "U" .010 INCH FOUND TO BE WITHIN LIMITS OF TABLE 1. ALODINED AND REIDESDR QXEA2009041400253Seat Track · corrodedLEFT OTBD SEAT TRACK HAS CORROSION BETWEEN FS 667.00 AND FS 718.00. BLENDED SEAT TRACK BETWEEN FS 677.00 AND FS 718.00 IAW REO 670-53-00-013 NOTE 1. MAX MATERIAL REMOVED AT DIMENSION "U" .009 INCH. FOUND TO BE WITHIN LIMITS TABLE 1. ALODINED AND REIDENTIFISDR QXEA2009041400252Seat Track · corrodedPDX - 8YR TASK - RT OTBD SEAT TRACK HAS CORROSION BETWEEN FS 902.00 AND FS918.00. BLENDED CORROSION IAW REO670-53-00-013 NOTE 1. REMOVED MAX MATERIAL OF .001 INCH FROM DIMENSION "U" AND .002 INCH FROM DIMENSION "T". FOUND TO BE WITHIN LIMITS. ALODINED ANSDR QXEA2009041400251Seat Track · corrodedPDX - 8YR TASK - RT SIDE SEAT RAIL HAS CORROSION ON RAIL AT APPROX FS 581.00. BLENDED CORROSION, DEEPEST LOCATION REMOVED .032 MATERIAL FOUND TO BE WITHIN LIMITS IAW REO 670-53-00-013 STEP 1. ALODINED AND REIDENTIFIED SEAT TRACK IAW REO 670-53-00-013.SDR QXEA2009041400250Seat Track · corrodedPDX - 8YR TASK - RT SIDE SEAT RAIL HAS CORROSION ON RAIL APPROX FS 613.00. BLENDED CORROSION PER REO 670-53-00-013 NOTE NR 1 MAX MATERIAL REMOVED .016 BLEND FOUND TO BE WITHIN LIMITS. ALODINED AND REIDENTIFIED SEAT TRACK IAW REO 670-53-00-013.SDR AALA20090423TUL44Cargo Track · corrodedLEVEL 1 CORROSION ON RIGHT TIE DOWN TRACK AT MULTIPLE SCREW HOLES AND MOUNTING SCREW HOLES. INSTALLED NEW TIE DOWN TRACK PER SRM 53-30-00.SDR USAA2009042490971Seat Track · corrodedSAL - C19 - MAJOR REPAIR - CORROSION ON SEAT TRACK AT BS 797, LBL 45.5. REPAIRED SEAT TRACK AT BS 797, LBL 45.5 IAW B737 SRM 53-00-52.SDR USAA2009042390966Seat Track · corrodedSAL - C19 - MAJOR REPAIR - CORROSION ON SEAT TRACK AT BS 912, LBL 45.5. REPAIRED SEAT TRACK AT BS 912, LBL 45.5 IAW B737 SRM 53-00-52.SDR ASOA200900415Seat Track · corrodedLT FWD FLOOR TRACK (SEAT RAIL) HAS CORROSION DAMAGE ON FWD EDGE. REMOVED & REPLACED SEAT TRACK IAW AMM 53-01-11-400-802 & 51-23-00-390-810.
Back to JASC 5347