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 QXEA200500496Seat Track · corrodedPDX - RIGHT OUTBOARD SEAT TRACK NR 11 HAS CORROSION IN TRACK GROOVE BETWEEN STATION X435 AND X438. REPAIRED IAW DHC-8 200 SRM 51-40-00 AND SRM 51-40-11.SDR 05FDEA00690Seat Track · corrodedMAIN DECK, SEAT TRACK RBL 47.5 CORRODED AT STA 1885. CORROSION REMOVED AS PER SRM 51-21-01 VOLUME II.SDR 05FDEA00689Seat Track · corrodedMAIN DECK, SEAT TRACK 47.5 CORRODED AT STA 1661 TO STA 1751. REPAIRED IAW SRM 53-70-00 FIGURE 1 VOLUME I.SDR 05FDEA00688Seat Track · corrodedMAIN DECK, SEAT TRACK RBL 27.5 CORRODED AT STA 1691. REPAIRED IAW SRM 53-70-00 FIGURE 1 VOLUME I.SDR 05FDEA00687Seat Track · corrodedMAIN DECK, SEAT TRACK LBL 75 CORRODED AT STA 1608. FOUND WITHIN LIMIT AS PER SRM 53-70-00 VOLUME I FIGURE 3. REWORKED AREA PROTECTED AND PAINTED AS PER SRM 51-21-01 VOLUME II.SDR 05FDEA00686Seat Track · corrodedMAIN DECK, SEAT TRACK 47.5 FOUND CORRODED AT STA 1605. CARRIED OUT REPAIR IAW SRM 53-70-00 VOLUME I FIGURE 1.SDR 05FDEA00685Seat Track · corrodedMAIN DECK, SEAT TRACK AT 47.5 CORRODED AT STA 1581. CARRIED OUT REPAIR IAW SRM 53-70-00 VOLUME I FIGURE 1.SDR 05FDEA00684Seat Track · corrodedMAIN DECK, SEAT TRACK 47.5 CORRODED AT STA 1531. CARRIED OUT REPAIR IAW SRM 53-70-00 VOLUME I FIGURE 1.SDR 05FDEA00683Seat Track · corrodedMAIN DECK, SEAT TRACK RBL 47.5 CORRODED AT STA 1401. CARRIED OUT REPAIR IAW SRM 53-70-00 VOLUME I FIGURE 1.SDR 05FDEA00682Seat Track · damagedMAIN DECK, SEAT TRACK LBL 47.5 FOUND WITH SCRATCHES AT STA 936. CARRIED OUT REPAIR IAW SRM 53-70-00 FIGURE 1 VOLUME I.SDR 05FDEA00681Seat Track · damagedMAIN DECK, SEAT TRACK RBL 27.5 FOUND WITH SCRATCHES AT STA 758. CARRIED OUT REPAIR IAW SRM 53-70-00 FIGURE 1 VOLUME I.SDR 05FDEA00680Seat Track · corrodedMAIN DECK, SEAT TRACK LBL 107 CORRODED AT STA. REMOVED AND REPLACED AS IAW SRM 51-33-01 VOLUME II.SDR 05FDEA00672Seat Track · crackedAFTER REMOVAL OF SEAT TRACK NR 3 RT BETWEEN FRAMES 45-54. FOUND BRACE FITTING AT FRAME 47/48 ATTACH POINT CRACKED 1.2 INCH LONG ON INBOARD SIDE OF TRACK. REPAIRED IAW EA 6-5310-79122.SDR 05FDEA00670Seat Track · corrodedMAIN CABIN FRAME 34 TO 37 SEAT TRACK YB77 HAS 2EA AREAS OF CORROSION NR 4 SEAT TRACK RT. REMOVED CORROSION IAW A310 SRM 51-74-10, OUT OF LIMITS IAW A310 SRM 53-10-16 FIG 101. FABBED NEW REPAIR SECTION OF SEAT TRACK IAW A310 SRM 53-10-16 FIG 208. REMOVED ANDSDR DHL2005740532Seat Track · corrodedMAIN CABIN SEAT TRACK BS 760 - BS 870 LBL 45.5 CORROSION AND DAMAGED. REMOVED AND REPLACED SEAT TRACK FROM P/N BAC1520-841 PO NR 9001650 DIM 8 FT IAW B727 SRM 53-10-2 FIG 1 AND 53-10-5 FIG 2. TREATED AND PRIMED SEAT TRACK IAW B727 SRM 51-10-2.SDR DHL2005740019Seat Track · damagedMAIN CABIN SEAT TRACK BS 344 TO 480 LBL 45.5 DAMAGED. REMOVED AND REPLACED NEW SEAT TRACK AT BS 344 TO BS 480 LBL 45.5 AND FABRICATED SEAT TRACK P/N BAC1520-792 PO NR 9001329 DIM. 12 FT IAW B727 SRM 53-10-2 FIG 1 AND 51-30-5 AND DWG NR 2902 VENTURA AEROSPACE.SDR DHL2005740018Seat Track · damagedMAIN CABIN SEAT TRACK BS 344 TO 480 LBL 24.75 DAMAGED. REMOVED AND REPLACED SEAT TRACK AT BS 344 TO BS 480 LBL 24.75 AND FABRICATED NEW SEAT TRACK P/N BAC1520-792 PO NR 9001465 DIM. 12 FT IAW B727 SRM 53-10-2 FIG1 AND 51-30-5 AND DWG NR 2902 VENTURA AEROSPACESDR DHL2005740016Seat Track · damagedMAIN CABIN SEAT TRACK BS 344 TO 480 RBL 24.75 DAMAGED. REMOVED AND REPLACED NEW SEAT TRACK AT BS 344 TO BS 480 RBL 24.75 AND FABRICATED NEW SEAT TRACK P/N BAC1520-792 PO NR 9001767 DIM 12 FT IAW B727 SRM 53-10-2 FIG 1 AND 51-30-5 AND DWG NR 2902 VENTURA AEROSSDR DHL2005740015Seat Track · damagedMAIN CABIN SEAT TRACK BS 344 TO BS 480 RBL 45.5 DAMAGED. REMOVED SEAT TRACK FROM BS 344 TO 480 RBL 45.5 IAW B727 SRM 51-30-2. FABRICATED NEW SEAT TRACK P/N BAC1520-792 PO NR 9001329 DIM. 12 FT IAW B727 SRM 53-10-2 FIG 1 AND 51-30-5 AND DWG NR 2902, TREATED ASDR 05FDEA00645Seat Track · corrodedSEAT TRACK STA 344-480 RBL 45 IS CORRODED AND REQUIRES REPLACEMENT PER EO 7-5340-7- 5002. REMOVED AND REPLACED SEAT TRACK IAW SRM 51-30-2.SDR QXEA200500599Seat Track · corrodedYYC - FUSELAGE INTERIOR, RIGHTHAND INBOARD SEAT RAIL AT STATION X350 TO X402, HAS MODERATE TO SEVERE PITTING CORROSION ON TOP AND INSIDE SURFACES. REMOVED AND REPLACED IAW CRJ700 SRM 51-41-02-001-001-A01 AND SRM 53-00-49-400-801-A02.SDR MALA050298Seat Track · corrodedDURING 4K CHECK IN BNA FOUND SEAT TRACK AT BL 0 AND FS 649 IS CORRODED ON THE LOWER LT FLANGE AND HAS BEEN REPAIRED IAW MESABA EO S53076.SDR ABXA050085Seat Track · corrodedUPPER CARGO LEFT SIDE BUTT LINE 44 HAD FLOOR PANEL BULGED. REMOVED AND REPLACED CORRODED SECTION OF SEAT TRACK AT STA 973 - 1071, LEFT BUTT LINE 44 ON JOB CARD 0349 IAW DC-9 SRM.SDR 05FDEA00630Seat Track · chafedSTA 939 TO 969 RT MOST OUTBOARD SEAT TRACK AREAS FOUND CHAFED MARKS. FABRICATED & REPAIRED AS PER SRM 53-70-00 FIG 1 VOL I.SDR MALA050290Seat Track · damagedDURING 4K CHECK IN BNA FOUND GALLEY SEAT TRACK PROFILE, P/N 7253721-495 HAS BEEN DAMAGED, REMOVED AND REPLACED IAW SRM 51-40-21.SDR ABXA050084Seat Track · brokenSEAT TRACK BROKEN IN UPPER CARGO COMPARTMENT AT FS 1041 AND LEFT BUTT LINE 44.5. SPLICED IN NEW SECTION OF SEAT TRACK AT FS 1041 - 965, LEFT BUTT LINE 44.5 IAW DC-9 SRM 53-05.SDR 05FDEA00629Seat Track · corrodedSEAT TRACK, STA. 344 - 480, LBL 24 HAS CORROSION AND EXISTING BLEND REPAIRS AND REQUIRES REPLACEMENT PER 7-5340-7-5002. REMOVED DAMAGED SEAT TRACK IAW SRM 51-30-2 - MAT ID BAC 1520-792 IAW SRM 51-10-2 FIG 7. NEW EXTRUSION SCALLOPED ON TRAV NR T5/501341. SDR MALA050296Seat Track · damagedDURING 4K CHECK IN BNA REMOVED AND REPLACED SEAT TRACK AT LBL 18.3 IAW MESABA EO S53060R3, FROM FS 294 TO 373.SDR MALA050295Seat Track · damagedDURING 4K CHECK IN BNA REMOVED AND REPLACED SEAT TRACK AT BL O IAW MESABA EO S53060 R3, FROM FS 294 TO FS 373.SDR QXEA200500548Cargo Track · damagedYYC - FORWARD FUSELAGE, FORWARD CARGO COMPARTMENT RETREVIAL TRAY RAILS, FORWARD RIGHTHAND INBOARD RAIL HARD ANODIZED COATING COMING OFF. REPAIRED IAW CRJ700 SRM 51-21-11-001-001-A01 AND SRM 51-21-06-001-00-A01.SDR ABXA050076Cargo Track · corrodedCORROSION ON FLOOR TRACK STA 889 TO STA 1072, LEFT SIDE. REMOVED AND REPLACED TRACK IAW DC-9 SRM 51-30-1.SDR 05FDEA00623Seat Track · gougedMDCC SONE 241, RT NR 2 SEATRACK, FR54.2 HAS 1-EA GOUGES AREA ON SCALOPE HOLE. REMOVED DAMAGED SEAT TRACK FITTING AT MDCC ZONE 241 RT NR 2 FR54.2 AND REPLACED WITH NEW SEAT TRACK FITTING P/N A5381114620000 IAW A310 SRM 51-40-21.SDR 05FDEA00622Seat Track · corrodedMAIN DECK CARGO ZONE 240 LT NR4 SEAT TRACK, FR 54 AND FR 54.1 CORROSION PROPAGATED ON SEAT TRACK FLANGE SCREW HOLES 2-AREAS. BLENDED CORROSION IAW A310-200 SRM 51-74-10, 53-10-16, CHECKED LIMITS AND NOTED FOR MATERIAL LOSS, DUE TO CORROISION OUT OF LIMITS RESDR 0500719983Seat Track · corrodedDURING H-CHECK FOUND CORROSION ON SEAT TRACK AT BS 239 LBL 25. REPAIRED PER EA 99-202920.SDR QXEA200500600Seat Track · corrodedYYC - FUSELAGE INTERIOR, RIGHTHAND INBOARD SEAT RAIL, AT STATION X417, HAS PITTING CORROSION ON TOP AND INSIDE SURFACES. REPAIRED IAW CRJ700 SRM 51-21-06-001-001-A01, REO 670-53-00-013 AND CRJ700 SRM 51-21-16, CODE A044.SDR QXEA200500601Seat Track · corrodedYYC - FUSELAGE INTERIOR, RIGHTHAND INBOARD SEAT RAIL AT STATION X431 HAS PITTING CORROSION ON TOP AND INSIDE SURFACES. REPAIRED IAW CRJ700/900 SRM 51-21-06-001-001-A01, PARAGRAPH 3E, REO 670-53-00-013 AND CRJ700 SRM 51-21-16, CODE A044.SDR QXEA200500564Seat Track · corrodedYYC - FUSELAGE INTERIOR, LEFTHAND OUTBOARD SEAT RAIL AT STATION X709 HAS PITTING CORROSION ON INSIDE AND MOST INBOARD SURFACES. REPAIRED IAW CRJ700 SRM 51-21-06-001-001-A01 AND SRM 51-21-16.SDR CALA0500078Seat Track · corrodedINSPECTION FOUND MAIN CABIN FLOOR LT O/B SEAT TRACK CORRODED AT STA 887-927, LBL 48. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 53-00-52.SDR 05FDEA00601Seat Track · wornMAIN DECK CARGO COMPARTMENT, SEAT TRACK CROWN FOUND CHAFED AT STA Y= 965, X= -47. MAIN DECK CARGO COMPARTMENT, CHAFED SEAT TRACK AT STA Y= 949 TO Y= 1009, X= -47 TRIMMED, REMOVED AND REWORKED SEAT TRACK INSTALLED PER SRM 53-70-00 VOLUME I FIGURE 1.SDR 05FDEA00600Seat Track · wornMAIN DECK CARGO COMPARTMENT, SEAT TRACK CROWN FOUND CHAFED AT STA Y= 965, X= -47. MAIN DECK CARGO COMPARTMENT, CHAFED SEAT TRACK AT STA Y= 949 TO Y= 1009, X= -47. TRIMMED, REMOVED AND REWORKED SEAT TRACK INSTALLED PER SRM 53-70-00 VOLUME I FIGURE 1.SDR CALA0500077Seat Track · corrodedINSPECTION FOUND SEAT TRACK CORRODED AT STA 360-375, RBL 24. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 53-00-52.SDR USAA050486Seat Track · corrodedBFM - FOUND SEAT TRACK CORRODED 2 INCHES LONG BY 1 INCH WIDE BY .040 INCH DEEP, CABIN SEAT TRACK Y450 FRAME 47-50. REPLACED SEAT TRACK PER SRM 53-00-15. (M)SDR DHL2005367516Seat Track · corrodedDURING "C" CHECK IN MIAMI, FL AT AVBORNE HEAVY MAINTENANCE DISCREPANCY AS FOLLOWS, N/R FIRST OBSERVER SEAT TRACK HAS WEAR MARKS. REMOVED AND REPLACED SEAT TRACK "FWD" OF 1ST OBSERVER AT COCKPIT IAW A-300 MM 53-41-11.SDR USAA050466Seat Track · corrodedBFM - FOUND SEAT TRACK CORRODED, 4 INCHES LONG BY 1 INCH WIDE BY .050 INCH DEEP, MAIN CABIN SEAT TRACK Y-2462 FRAME 4-47. FABRICATED SEAT TRACK SPLICE PER SRM 53-31-15. (M)SDR QXEA200500613Seat Track · corrodedYYC - FUSELAGE INTERIOR, LEFTHAND INBOARD SEAT RAIL AT STATION X678 HAS PITTING CORROSION ON TOP SURFACE. REPAIRED IAW CRJ700/900 SRM 51-21-06-001-001-A01, PARAGRAPH 3E, REO 670-53-00-013 AND CRJ700 SRM 51-21-16, A044.SDR QXEA200500611Seat Track · corrodedYYC - FUSELAGE INTERIOR, LEFTHAND INBOARD SEAT RAIL AT STATION X647 HAS PITTING CORROSION ON TOP SURFACE. REPAIRED IAW CRJ700/900 SRM 51-21-06-001-001-A01, PARAGRAPH 3E, REO 670-53-00-013 AND CRJ700 SRM 51-21-16, CODE A044.SDR QXEA200500604Seat Track · corrodedYYC - FUSELAGE INTERIOR, RIGHTHAND INBOARD SEAT RAIL, AT STATION X523 HAS PITTING CORROSION ON TOP AND INSIDE SURFACES. REPAIRED IAW CRJ700/900 SRM 51-21-06-001-001-A01, PARAGRAPH 3E, REO 670-53-013 AND CRJ700 SRM 51-21-16, CODE A044.SDR QXEA200500597Seat Track · corrodedYYC - FUSELAGE INTERIOR, RIGHTHAND OUTBOARD SEAT RAIL AT STATION X785, HAS PITTING CORROSION ON MOST INBOARD SURFACE. REPAIRED IAW CRJ700/900 SRM 51-21-06-001-001-A01, PARAGRAPH 3E, REO 670-53-00-013 AND CRJ700 SRM 51-21-16, CODE A044.SDR QXEA200500596Seat Track · corrodedYYC - FUSELAGE INTERIOR, RIGHTHAND OUTBOARD SEAT RAIL AT STATION 753, HAS PITTING CORROSION ON MOST INBOARD SURFACE. REPAIRED IAW CRJ700/900 SRM 51-21-06-001-001-A01, PARAGRAPH 3E AND CRJ700 SRM 51-21-16, CODE A044.SDR QXEA200500595Seat Track · corrodedYYC - FUSELAGE INTERIOR, RIGHT HAND OUTBOARD SEAT RAIL AT STATION X739, HAS PITTING CORROSION ON MOST INBOARD SURFACE. REPAIRED IAW CRJ700/900 SRM 51-21-06-001-001-A01, PARAGRAPH A 3E AND CRJ700 SRM 51-21-16, CODE A044.
Back to JASC 5347