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 05FDEA00041Seat Track · wornMAIN DECK CARGO, SEAT TRACK BETWEEN STA Y= 1341 TO Y= 1401, X= - 47.50 FOUND WORN. REPAIRED PER SRM 53-70-00 VOLUME I, FIGURE 1.SDR 05FDEA00004Seat Track · damagedMAIN DECK CARGO, SEAT TRACK AT STA Y= 791.75 TO Y= 859, X= 8.5 DAMAGED AT FLANGED AREA. REPAIRED PER SRM 53-70-00 VOLUME I, FIGURE 1SDR USAA050018Seat Track · corrodedBFM - FOUND SEAT TRACK CORRODED .018 INCH DEEP BY .25 INCH DEEP WIDE BY .5 INCH LONG AREA, FR 51, Y = -450 SEAT TRACK. CORROSION LEVEL 2, TASK NR J7-200-2578X. REMOVED AND REPLACED PER SRM 53-31-15 FIG 101 SHEET 8. (M)SDR USAA050017Seat Track · corrodedBFM - SEAT TRACK FOUND CORRODED .046 INCH DEEP BY .36 INCH WIDE BY 1.46 INCH LONG, FRAME 62-72, Y= -2462. CORROSION LEVEL 2, TASK NR J7-200-2580C. REMOVED AND REPLACED PER SRM 53-00-15 FIG 101 SHEET 2. (M)SDR USAA050016Seat Track · corrodedBFM - FOUND SEAT TRACK CORRODED .017D BY .25W BY .5L AREA, BETWEEN FRAME 52-53, Y=-450 SEAT TRACK. CORROSION LEVEL 2, TASK J7-200-2578C. REMOVED AND REPLACED PER SRM 53-31-15, FIG 101 SH 8. (M)SDR USAA050015Seat Track · corrodedBFM - FOUND SEAT TRACK CORROSION .075 INCH LONG BY .5 INCH WIDE BY .036 INCH DEEP, FRAME 58-59, -Y450, -Z240. CORROSION LEVEL 2, TASK NR J7-200-2580C. REMOVED AND REPLACED SEAT TRACK PER SRM 51-74-00, 53-00-15. (M)SDR USAA050021Seat Track · corrodedBFM - FOUND TRACK CORRODED 1.5 INCH BY 1.5 INCH BY .040 INCH DEEP, MAIN DECK FLOORBEAM, FRAME 13-13A AT Y953. CORROSION LEVEL 2, TASK NR J7-220-53500. REMOVED AND REPLACED BEAM TRACK PER STM 53-11-15. (M)SDR USAA050022Seat Track · corrodedBFM - FOUND RAIL CORRODED 1.5 INCH BY 1.5 INCH BY .040 INCH DEEP, FRAME 13-13A, Y1456, MAIN CABIN FLOOR. CORROSION LEVEL 2, TASK NR J7-220-53500. REMOVED AND REPLACED RAIL PER SRM 53-11-14. (M)SDR USAA050012Seat Track · corrodedBFM - FOUND SEAT TRACK CORRODED .640 INCH LONG BY .125 INCH WIDE BY .038 INCH DEEP AREA, Y+450. CORROSION LEVEL 2, TASK NR J7-200-2580C. REMOVED AND REPLACED SEAT TRACK PER SRM 53-00-15, 53-00-10, 51-42-11, 51-21-11, 51-42-11. (M)SDR USAA050014Seat Track · corrodedBFM - FOUND SEAT TRACK APPROX 27 SQUARE INCH 18 LOCATIONS, FRAME 54-68, +Y450, MAIN CABIN SEAT TRACK. REMOVED AND REPLACED SEAT TRACKS PER SRM 53-00-15. CORROSION LEVEL 2, TASK NR J7-200-258OC. (M)SDR USAA050013Seat Track · corrodedBFM - FOUND SEAT TRACK CORRODED .750 INCH LENGTH BY .500 INCH WIDE BY .035 INCH DEEP AREA, -Y450 FROM FRAME 68-72. CORROSION LEVEL 2, TASK NR J7-200-258OC. REMOVED AND REPLACED SEAT TRACK PER SRM 53-00-15, 51-42-11, 51-44-11, 51-21-11. (M)SDR USAA050019Seat Track · corrodedBFM - FOUND SEAT TRACK CORRODED, 1 INCH BY .75 INCH BY .035 INCH DEEP, FRAME 74, Y 1202 CM, MAIN CABIN SEAT TRACK. REMOVED AND REPLACED SEAT TRACK PER SRM 53-00-15. CORROSION LEVEL 2, TASK NR J7-270-53500. (M)SDR ASA044409Seat Track · damagedPAE - SEAT TRACK, MECHANICAL DAMAGE STA 360 TO 480, RBL 45, WL208. REPLACED SEAT TRACK. (K)SDR ASA0440399Cargo Track · corrodedPAE - CORROSION ON FLOOR TRACK AT PREVIOUS REPAIR BS772, RBL 13.80, WL 153. REMOVED CORROSION, FOUND TO BE OUT OF LIMITS ORIGINAL .070 INCH REMAINING .31 INCH X 1 INCH X 2.5 INCHES. REMOVED AND REPLACED CARGO TRACK FROM BS 727 TO 947.5, RBL 13.8, WL 153. (K)SDR ASA044403Cargo Track · corrodedPAE - AFT CARGO COMPARTMENT TIE DOWN FITTINGS HAVE LIGHT CORROSION. RBL 13.80, STA 947.5 TO 727 RBL 13.8. (K)SDR DHL2005743509Seat Track · corrodedMAIN CABIN STA 360 BL 0 SEAT TRACK CORRODED (SEAT TRACK SECTION 360-500). REMOVED CORROSION IAW B727 SRM 53-10-1. FOUND TO BE OUT OF LIMITS. REMOVED SEAT TRACK IAW B727 SRM 51-30-2. OBTAINED NEW SEAT TRACK PO 60-6549-0331976. LOCATE, DRILL, DEBURRED TRACKSDR QXEA200500048Seat Track · corrodedPDX - LEFT HAND OUTBOARD SEAT TRACK HAS CORROSION AT STATION 738 TO 756. REPLACED IAW CRJ AMM 53-00-49.SDR 04FDEA03499Seat Track · corrodedMCD FR 47 TO FR 53 LT NR 1 SEAT TRACK HAS 4 AREAS OF CORROSION REF N-CARD N00473. REPAIRED TRACK AT FR 46.5 TO FR 47.5 AND FR 52.5 TO FR 54 IAW SRM 53-10-16.SDR ASA0440381Seat Track · corrodedPAE - SEAT TRACK CORRODED AT STA 370. REPAIRED SEAT TRACK. (K)SDR ASA0440384Seat Track · mismanufacturedPAE - OB FLANGE OF SEAT TRACK IS MISSING FLOOR PANEL ATTACHMENT HOLES AT BS 360-480. LOCATED AND DRILLED HOLES. (K)SDR ASA0440390Seat Track · damagedPAE - MECHANICAL DAMAGE SEAT TRACK AT BS 727B TO 927. REMOVED DAMAGED SEAT TRACK AND REPLACED. (K)SDR ASA0440387Seat Track · damagedPAE - DAMAGED SEAT TRACK AT BS 927. REMOVED DAMAGED SEAT TRACK AND REPLACED. (K)SDR ASA0440388Seat Track · damagedPAE - DAMAGED SEAT TRACK AT BS 480. REMOVED DAMAGED SEAT TRACK AND REPLACED. (K)SDR ASA0440389Seat Track · gougedPAE - DAMAGED SEAT TRACK AT BS 727B. REMOVED DAMAGED SEAT TRACK AND REPLACED. (K)SDR QXEA200500047Seat Track · corrodedPDX - LEFT HAND LOWER WEB OF BULKHEAD AT STATION 280 HAS CORROSION. REPLACED IAW CRJ SRM 51-42-06 AND SRM 51-42-13.SDR 04FDEA03485Seat Track · corrodedSTA Y=832 TO 919 RIGHT HAND NR 3 SEAT TRACK AREAS FOUND WITH CORROSION. REPIARED IAW SRM 53-70-00 FIG 1 VOL I.SDR 04FDEA03480Seat Track · corrodedMAIN DECK, SEAT TRACK RBL 107 CORRODED AT STA 1310 TO STA 1361. REMOVED AS PER SRM 51-31-01.SDR 04FDEA03479Seat Track · corrodedMAIN DECK, SEAT TRACK RBL 77 CORRODED AT STA 1841 TO STA 1887. CORRODED SEAT TRACK REMOVED AS PER SRM 53-70-00. FABRICATED REPAIR SEAT TRACK AND SPLICE AS PER FIG 1 & FIG 7 OF SRM 53-70-00 AND INSTALLED AS PER SRM 51-31-01& 53-70-00.SDR 04FDEA03478Seat Track · scratchedMAIN DECK, SEAT TRACK RBL 107 FOUND WITH SCRATCHES AT STA 1544 TO STA 5-93.SDR 04FDEA03477Seat Track · scratchedMAIN DECK, SEAT TRACK RBL 107 FOUND WITH SCRATCHES AT STA 1541 TO STA 5-73. REMOVED AS PER SRM 51-31-01 VOL II. REPAIR SEAT TRACK FABRICATED AS PER DRAWING A5A7084 & INSTALLED AS PER SRM 53-70-00 FIG 1 VOL I & SRM 51-31-01 VOL II.SDR 04FDEA03476Seat Track · scratchedMAIN DECK, SEAT TRACK RBL 107 FOUND WITH SCRATCHES AT STA 1391 TO STA 1471. REPAIRED SEAT TRACK & SPLICE FABRICATED AS PER SRM 53-70-00.SDR 04FDEA03475Seat Track · corrodedMAIN DECK, SEAT TRACK RBL 107 CORRODED AT STA 1421. REPAIRED AS PER SRM 53-70-00 FIG I & SRM 51-31-01 VOL II. REFER TO SNRM N2547 FOR WORK DETAILS.SDR 249TR0097Galley Track · corrodedRIGHT OUTBOARD GALLEY TRACK CORRODED FOR G-2 GALLEY. REPLACED SECTION OF TRACK PER BOEING DRAWING 65-45834 AND SRM 53-10-2 AND 51-10-2.SDR 249TR0091Seat Track · corrodedSEAT TRACK AT RBL 38 HAS CORROSION AT BS 986 + 4. REPLACED SECTION OF TRACK PER SRM 51-10-1 AND 53-10-2.SDR 249TR0073Galley Track · corrodedCORROSION ON INBOARD TRACK FOR G-1 GALLEY. REPLACED SECTION OF TRACK PER SRM 51-10-1.SDR 249TR0071Galley Track · corrodedCORROSION IN OUTBOARD TRACK FOR G-1 GALLEY. REPLACED TRACK PER SRM 51-40-2.SDR 249TR0058Seat Track · corrodedCORROSION ON SEAT TRACK FROM BS 344 TO BS 366 AT LBL 22. REPAIRED PER SRM 53-10-5.SDR 04FDEA03466Seat Track · damagedMAIN DECK, SEAT TRACK RBL 107 FOUND WITH SCRATCHES AT STA 1665 TO STA 1721. REPLACEMENT CARRIED OUT AT MAIN DECK RBL 107 STA 1531 TO STA 2007SDR SWIA200414393Seat Track · corrodedLT SEAT RAIL FROM FS 364.00 TO 409+16 CORRODED. (ITEM FOUND AT C-CHECK INSPECTION.) SEAT REPAIRED IAW CRJ SRM 51-41-02 AT FS364.0 TO 409+16.SDR SWIA200414392Seat Track · corrodedLEFT SIDE SEAT RAIL FROM FS 409+16 TO 409+112 CORRODED. (ITEM FOUND AT C-CHECK INSPECTION.) SEAT RAIL REPLACED IAW CRJ SRM 51-41-02 AT FS 409+16 TO 409+112.SDR USAA041079Seat Track · corrodedCLT - FOUND SEAT TRACK CORRODED 3 INCH BY 1 INCH, STATION 713.5 TO 716 LBL 88.5. INSTALLED NEW SECTION OF SEAT TRACK PER SRM 53-00-52. (M)SDR SWIA200414391Seat Track · corrodedLEFT SIDE SEAT RAIL FROM FS 449+85 TO 499.00 CORRODED. SEAT RAIL INSTALLED IAW CRJ SRM 51-41-02 AT 449+85 TO 499.00.SDR SWIA200414390Seat Track · corrodedRIGHT SIDE SEAT RAIL FROM FS 544.00 TO 559+96 CORRODED. ITEM FOUND AT C-CHECK INSPECTION. INSTALLED SEAT RAIL IAW CRJ SRM 51-41-02 AT FS 544 TO 559+96 RBL 27.0.SDR SWIA200414388Seat Track · corrodedMAIN CABIN SEAT TRACK HAS NUMEROUS AREAS OF CORROSION; FS 559.0 TO FS 559.0+80 LBL 9.0. ITEM FOUND AT C-CHECK INSPECTION. REMOVED CORROSION AND TREATED IAW CRJ SRM 51-21-06 & 51-21-11 AREAS BLENDED WITHIN LIMITS IAW CRJ SRM 53-51-49 & 53-21-49.SDR SWIA200414387Seat Track · corrodedMAIN CABIN SEAT TRACK HAS NUMEROUS AREAS OF CORROSION; FS 559.0 TO FS 559.0+80 RBL 9.0. ITEM FOUND AT C-CHECK INSPECTION. INSTALLED NEW SEAT TRACK IAW CRJ SRM 51-40-11, 51-23-00, 51-41-04 AT F.S 559.0 TO 559.01-80, RBL 9.0.SDR USAA041129Seat Track · corrodedBFM - FOUND SEAT TRACK CORRODED 1.5 INCH LENGTH BY 1.250 INCH WIDE BY .129 INCH DEEP, Y 1959 BETWEEN FRAME 57.4-58 - Z240. REMOVED AND REPLACED WITH NEW SEAT TRACK PER SRM 53-00-15 AND 51-42-11. (M)SDR 04FDEA03449Seat Track · damagedSTA 836 LT NR 3 SEAT TRACK EXISTING FLANGE REPAIR FOUND NOT CONFORMING TO SRM STANDARD. REPAIRED SEAT TRACK & SPLICE FABRICATED AS PER SRM 53-70-00.SDR USAA041127Seat Track · corrodedBFM - FOUND SEAT TRACK ASSEMBLY CORRODED .075 INCH LENGTH BY 050 INCH WIDE BY .040 INCH DEEP, AFT CABIN SEAT TRACK AT Y-1207, FRAME 73. CORROSION LEVEL 2, TASK NR J7-200-53500. REMOVED AND REPLACED PER SRM 53-00-15, 51-74-00, 51-42-11, 51-44-11.SDR ASA0440364Seat Track · damagedPAE - MECHANICAL DAMAGE ON SEAT TRACK. REPLACED SEAT TRACK. (K)SDR ASA0440365Seat Track · tornPAE - MECHANICAL DAMAGE ON SEAT TRACK. REPLACED SEAT TRACK. (K)
Back to JASC 5347