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 UPS06446916Seat Track · corrodedBS 480-520 LBL46 SEAT TRACK O/B FLANGE FOUND CORROSION. CORROSION BLEND OUT 0.55" BY 1/2" BY 1.5" EXCEED SRM LIMIT. BS480-530 LBL46 SEAT TRACK REPLACED AND INSTALLED AS PER SRM 51-10-01 PG 9 AND 51-30-02.SDR 06FDEA1735Seat Track · chafedSNRM N00179: MAIN DECK COMPARTMENT SEAT TRACK FOUND WITH CHAFFED MARK AT STA 1801 LBL 47. CORRECTIVE ACTION: SNRM N00179: MAIN DECK COMPARTMENT SEAT TRACK AT STA 1801 LBL 47 CARRIED OUT REPAIR AS PER SRM 53-70-00 FIGURE 1 VOLUME I. REPAIR IS CLASSIFISDR 06FDEA1734Seat Track · chafedSNRM N00178: MAIN DECK COMPARTMENT SEAT TRACK FOUND WITH CHAFFED MARK AT STA 1801 LBL 27. CORRECTIVE ACTION: SNRM N00178: MAIN DECK COMPARTMENT SEAT TRACK AT STA 1801 LBL 27 CARRIED OUT REPAIR AS PER SRM 53-70-00 FIGURE 1 VOLUME I. REPAIR IS CLASSIFISDR 06FDEA1733Seat Track · chafedSNRM N00177: MAIN DECK COMPARTMENT SEAT TRACK FOUND WITH CHAFFED MARK AT STA 1801 LBL 8. CORRECTIVE ACTION: SNRM N00177: MAIN DECK COMPARTMENT SEAT TRACK AT STA 1801 LBL 8 CARRIED OUT REPAIR AS PER SRM 53-70-00 FIGURE 1 VOLUME I. REPAIR IS CLASSIFIEDSDR MALA060308Seat Track · corrodedDURING 4K CHECK IN BNA FOUND SEAT TRACK AT BL 0 BETWEEN FS 300 AND 339 IS CORRODED OUT OF LIMITS. THE DAMAGED TRACK HAS BEEN REPAIRED IAW MESABA EO S53342.SDR MALA060307Seat Track · corrodedDURING 4K CHECK IN BNA FOUND SEAT TRACK AT LBL 18.3, BETWEEN FS 300 AND 319 IS CORRODED OUT OF LIMITS. THE DAMAGED SEAT TRACK HAS BEEN REMOVED AND REPLACED IAW MESABA EO S53060.SDR CALA0600156Seat Track · corrodedINSPECTION FOUND THE LEFT I/B SEAT TRACK CORRODED AT STA 907 TO 947.5, LBL 25. THE SEAT TRACK SECTION WAS REMOVED AND REPLACED IAW SRM 51-40-02.SDR DU4R2006465Seat Track · corrodedCORROSION ON MAIN CABIN FS 229 TO FS 864 RIGHT O/B SEAT TRACK. INSTALLED SEAT TRACK P/N 5930547U709 IAW DC-9/MD-80 SRM 51-10-3, 53-05 FIG 4B1 AND 51-30-1.SDR DU4R2006464Seat Track · corrodedCORROSION ON MAIN CABIN FS 864 TO FS 1322 LEFT O/B SEAT TRACK. INSTALLED SEAT TRACK P/N 5930547U709 IAW DC-9/MD-80 SRM 51-10-3, 51-10-4 AND 51-30-1.SDR UPS06446914Cargo Track · corrodedBS 420-440 RBL88 TIE DOWN TRACK I/B FLANGE FOUND CORROSION. CORROSION BLEND OUT 0.030" BY 1/2" BY 2" EXCEED SRM LIMIT. BS410-460 RBL88 TRACK REPLACED AND INSTALLED AS PER SRM 51-10-01 PG 9 AND 51-30-02.SDR UPS06446895Cargo Track · corrodedINSPECTION TYPE:C M/D BS 440-460 RBL 88 TIE DOWN TRACK O/B FLANGE FOUND CORROSION. CORROSION BLEND OUT 0.055" X 1" X 1" EXCEED SRM LIMIT. M/D BS 410-460 RBL 88 TRACK REPLACED AND INSTALLED AS PER SRM 51-10-01 PG 9 AND 51-30-02.SDR UPS06446893Cargo Track · corrodedINSPECTION TYPE:C M/D - BS 440-460 LBL 11 TIE DOWN TRACK I/B FLANGE FOUND CORROSION. CORROSION BLEND OUT 0.057" X .5" X 1.5" EXCEED SRM LIMIT. M/D BS 440-460 LBL 11 TIE DOWN TRACK REPAIRED AS PER SRM 53-10-05 FIG 17.SDR TRAX200600195Track · corrodedSHORT FLOOR TRACKS AFT OF LAV AT LBL9, LBL27, RBL9 AND RBL27 HAVE CORROSION, RESOLVED ON W/O: 24018 TASKCARD: N/R-00422. REMOVED AND REPLACED CORRODED FLOOR TRACKS IAW AMM CRJ200 53-01-11 CM20420 JOB COMPLETE.SDR DU4R2006456Seat Track · corrodedMAIN CABIN FS 229 TO FS 864 LEFT I/B SEAT TRACK HAS AREAS OF CORROSION. REMOVED CORRODED SEAT TRACK LEFT FS 436 - FS 457 AND INSTALLED REPAIR SPLICE P/N ACA7413-505 AND PLATE P/N ACA7414-3 IAW DC-9/MD-80 SRM 53-05D.SDR QXEA200601316Seat Track · corrodedYYC - C4 FUSELAGE INTERIOR BAGGAGE COMPARTMENT SEAT TRACK RIGHT HAND INBOARD AT STATION X 598 AND Y 9.25 HAS NICKS AND CORROSION INSIDE AND ON TOP OD CLAW PORTION. REPAIRED IAW RD8-53-4936 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA200601317Cargo Track · corrodedYYC - C4 FUSELAGE INTERIOR BAGGAGE COMPARTMENT SEAT TRACK LEFT HAND INBOARD AT STATION X 598 AND Y 9.25 HAS NICKS AND CORROSION INSIDE AND ON TOP OD CLAW PORTION. REPAIRED IAW RD8-53-4936 SRM 51-20-16 AND SRM 51-20-36.SDR MALA060305Seat Track · corrodedDURING 2 YEAR CHECK IN BNA FOUND SEAT TRACK AT LBL 18.3 BETWEEN FS 297 AND 351 IS CORRODED OUT OF LIMITS. THE DAMAGED SEAT TRACK HAS BEEN REMOVED AND REPLACED IAW MESABA EO S53060.SDR MALA060304Seat Track · corrodedDURING 2 YEAR CHECK IN BNA FOUND SEAT TRACK AT BL 0, BETWEEN FS 625 AND 640 FLOOR SUPPORT FLANGE ON THE LEFT HAND SIDE OF THE TRACK IS CORRODED OUT OF LIMITS AND HAS BEEN REPAIRED IAW MESABA EO S53342.SDR MALA060303Seat Track · corrodedSEAT TRACK AT BL 0, BETWEEN FS 288 AND 319, FLOOR SUPPORT FLANGE ON THE LEFT HAND SIDE OF THE TRACK IS CORRODED OUT OF LIMITS AND HAS BEEN REPAIRED IAW MESABA EO S53342.SDR 06FDEA1717Seat Track · corrodedFOUND MAIN DECK, SEAT TRACK RBL 27 CORRODED AT STA 902. CORROSION REMOVED AND FOUND EXCEED LIMITS AS PER SRM 53-70-00 FIG.3 VOL.I. SEAT TRACK TRIMMED AS PER 53-70-00 FIG.1 VOL.I. HFEC INSPECTION CARRIED OUT PER DAC NDT SPM 06-10-01,001 REV.12 ON TRIMMSDR USAA060657Cargo Track · corrodedFOUND TRACK TIE DOWN CORRODED, BS 787-827 RBL. FABRICATED NEW TRACK AND INSTALLED IAW SRM 53-00-53 FIG 201 LEVEL 1 C53-208-01, DEFECT SIZE: 40".SDR QXEA200601663Seat Track · corrodedYYC C3 FUSELAGE INTERIOR RIGHT HAND INBOARD FORWARD SEAT RAIL X-39.000 TO X19.5 IS CORRODED BEYOND LIMITS. REPAIRED IAW DHC-8-400 SRM 51-40-07-320-801, 51-41-05-800-801 AND 51-80-00-210-002.SDR QXEA200601664Seat Track · corrodedYYC C3 FUSELAGE INTERIOR RIGHT HAND INBOARD FORWARD SEAT RAIL X19.50 TO X94.8 IS CORRODED BEYOND LIMITS. REPAIRED IAW DHC-8-400 SRM 51-40-07-320-801, 51-41-05-800-801 AND 51-80-00-210-002.SDR QXEA200601580Seat Track · corrodedYYC - C3 FUSELAGE INTERIOR RIGHT HAND INBOARD SEAT RAIL AT X19.580 HAS CORRODED SPLICE P/N 85338215-101. REPLACED IAW DHC-8-400 SRM 51-42-05-330-801 AND HORIZON AIR EA 6-53-682.SDR 06FDEA1685Seat Track · crackedM/D CARGO SEAT TRACK (STA 1501-1510, LT X=27.5) FOUND EDGE BROKEN.SDR UPS06246795Seat Track · crackedFOUND CABIN UPPER FLANGE AFT END CRACKED AT BS 850 LBL51 HAS SURFACE CORROSION SEAT TRACK REMOVED IAW SRM 51-30-02. NEW SEAT TRACK FABRICATED IAW SRM 53-10-02. INSTALLED NEW SEAT TRACK IAW SRM 51-30-02.SDR C1HA200685008Seat Track · corrodedUPPER CABIN SEAT TRACK AT LBL 45 DEEP CORROSSION INSIDE CROWN AREA AT STA 950 TO 970. CUT OUT SEAT TRACK FROM STA 950 TO 1115 IAW B727 SRM 53-10-1 FIG 3. FAB NEW SEAT TRACK FROM BAC1520-797 7075 T6 .02 IAW B727 SRM 53-10-5. ALODINE & PRIMED IAW B727 SRM 51-SDR C1HA200685005Seat Track · corrodedUPPER CABIN SEAT TRACK HAS CORROSION STA 469 RBL 45. FOUND CORROSION OUT OF LIMITS. REMOVED SEAT TRACK RBL 400 TO 480 IAW B727 SRM 51-30-2, FABRICATED NEW SEAT TRACK FROM BAC 1520 KTP 017 792 7178 IAW B727 SRM 53-10-2 FIG 7, & 51-20-1. ALODINED & PRIMED IAWSDR C1HA200685004Seat Track · corrodedCORROSSION CABIN SEAT TRACK LBL 24 STA 380 TO 440. REMOVED DAMAGE TRACK IAW B727 SRM 51-30-2, FABBED NEW TRACK FROM BAC 1520-792-7178 T6 IAW B727 SRM 53-10-2 FIG 7. ALODINE & PRIME IAW B727 SRM 51-10-2, INSTALLED SEAT TRACK IAW B727 SRM 53-10-5 FIG 7.SDR QXEA200601309Seat Track · corrodedYYC - C4 FUSELAGE INTERIOR FS 222.7 RIGHT HAND INBOARD SEAT TRACK AT Y 9.25 HAS COROSION ON UPPER SURFACE. REPAIRED IAW RD8-53-4478 AND RD8-53-3403.SDR MALA060295Seat Track · corrodedDURING 2 YEAR CHECK IN BNA, FOUND SEAT TRACK AT BL0 AND FS 300 IS CORRODED OUT OF LIMITS AT A NUTPLATE LOCATION AND HAS BEEN REPAIRED IAW MESABA EO#S53342. REF: EAMS WORK ORDER 213785 TASK 2510.SDR MALA060294Seat Track · corrodedDURING 2 YEAR IN BNA, FOUND SEAT TRACK AT LBL 18.3 AND FS 300 IS CORRODED OUT OF LIMITS AT A NUTPLATE LOCATION AND HAS BEEN REPAIRED IAW MESABA EOS53342. REF: EAMS WORK ORDER 213785 TASK 2511.SDR SIMA200613807Seat Track · corrodedIMBV INSPECTION, FOUND LEFT INBOARD SEAT TRACK CORRODED FROM FRAMES 42-43. REMOVED AND REPLACED SEAT TRACK IAW AMM 53-01-06. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA200613806Seat Track · corrodedIMBV INSPECTION, FOUND RIGHT FORWARD BOTTOM SEAT TRACK CORRODED. REMOVED AND REPLACED SEAT TRACK IAW AMM 53-01-06. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA200613805Seat Track · corrodedIMBV INSPECTION, FOUND RIGHT UPPER SEAT TRACK FROM FRAMES 47-53 CORRODED. REMOVED AND REPLACED SEAT TRACK IAW AMM 53-01-06. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA200613804Seat Track · corrodedIMBV INSPECTION, FOUND RIGHT UPPER SEAT TRACK FROM FRAMES 36-47 CORRODED. REMOVED AND REPLACED SEAT TRACK IAW AMM 53-01-06. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA200613803Seat Track · corrodedIMBV INSPECTION, FOUND RIGHT UPPER SEAT TRACK FROM FRAMES 30-36 CORRODED. REMOVED AND REPLACED SEAT TRACK IAW AMM 53-01-06. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA200613802Seat Track · corrodedIMBV INSPECTION, FOUND RIGHT FORWARD UPPER SEAT TRACK CORRODED. REMOVED AND REPLACED SEAT RACK IAW AMM 53-01-06. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA200613801Seat Track · corrodedIMBV INSPECTION, FOUND LEFT INBOARD FORWARD SEAT TRACK CORRODED. REMOVED AND REPLACED SEAT TRACK IAW AMM 53-01-06. AIRCRAFT RETURNED TO SERVICE. (M)SDR AWXA200600782Seat Track · corrodedMCN - DURING BC 4 CHECK DISCOVERED LEVEL 2 EXFOLIATION CORROSION ON SEAT TRACK AT FS 16 AND Y-1292. CORROSION WAS FOUND TO BE OUT OF LIMITS IAW A319 SRM 53-11-15 FIG 104. MAINTENANCE REMOVED DAMAGED PORTION OF SEAT TRACK IAW AIRBUS 319 SRM 53-11-15 FIG 201. SDR 06FDEA1652Seat Track · corrodedMAIN DECK, SEAT TRACK LBL 8.5 CORRODED AT STA 999 AND STA 1019. CORROSION REMOVED AND FOUND EXCEED LIMIT AS PER SRM 53-70-00 FIG.3 VOL.I. SEAT TRACK AT STA 1129 LBL 8.5 TRIMMED OUT AS PER SRM 53-70-00 FIG.1 VOL.I. NEW SEAT TRACK AND SPLICE ANGLE REWORKSDR DJFA2006238Seat Track · crackedDURING A SCHEDULED MAINTENANCE VISIT A CRACK WAS DISCOVERED IN THE PILOTS OB SEAT TRACK AFTER THE SEAT WAS REMOVED FOR CLEANING. THE SEAT TRACK WAS REPLACED IAW MM. THE AIRCRAFT WAS RETURNED TO SERVICE.SDR QXEA200601627Cargo Track · corrodedYYC - C3 FUSELAGEINTERIOR FORWARD BAGGAGE COMPARTMENT SEAT RAIL 8538261 HAS PITTING CORROSION FROM STATION X32.4 TO X71.2. REPAIRED IAW RD 8/4-53-884 AND ES 6-53-681.SDR QXEA200601553Seat Track · corrodedYYC - C3 FUSELAGE INTERIOR, SEAT TRACK LEFT, OUTBOARD 85338261 FROM STATION X704.0 TO X717.0 HAS CORROSION INSIDE AND ON TOP OF CLAW PORTION. REPAIRED IAW RD 8/4-53-884, ISSUE 2 AND HORIZON AIR EA 6-53-678.SDR QXEA200601531Seat Track · corrodedYYC C3 FUSELAGE INTERIOR, SEAT TRACK, RIGHT HAND INBOARD P/N 85338210-107 HAS CORROSION ON TOP AND INSIDE CLAW FROM STATION X704 TO X747.6. REPAIRED IAW RD 8/4-53-1496 AND HORIZON AIR EA 6-53-684.SDR 06FDEA1631Seat Track · corrodedMAIN DECK SEAT TRACK RBL 27 CORRODED AT STA 902. CORROSION REMOVED AND FOUND EXCEED LIMITS AS PER SRM 53-70-00 FIG.3 VOL I. SEAT TRACK TRIMMED AS PER 53-70-00 FIG.1 VOL.I. HFEC INSPECTION CARRIED OUT PER DAC NDT SPM 06-10-01.001 REV.12 ON TRIMMED AREASDR 06FDEA1630Seat Track · corrodedMAIN DECK SEAT TRACK RBL 8.5 CORRODED AT STA 957. CORROSION REMOVED AND FOUND EXCEED LIMITS AS PER SRM 53-70-00 FIG.3 VOL.I. SEAT TRACK AT STA 969 RBL 8.5 TRIMMED-OUT AS PER SRM 53-70-00 FIG.1 VOL.I.HFEC INSPECTION CARRIED OUT PER DAC NDT SPM 06-10-01.001 REVSDR UPS06246794Seat Track · corrodedFOUND CABIN SEAT TRACK I/B FLANGE CORRODED BETWEEN BS 760- BS 779 LBL 75 CORROSION FOUND TO BE OUT OF LIMITS IAW SRM 53-10-02. NEW SEAT TRACK FABRICATED AND INSTALLED IAW SRM 53-10-02 AND SRM 51-30-02.SDR USAA060639Cargo Track · corrodedFOUND CORROSION BS 727D+5 RBL 8.10. CUT AND TRIMMED REPAIR ANGLES IAW SRM 53-00-53 REPAIR 1 LEVEL 1 C53-208-01, DEFECT SIZE: 2.5".SDR MALA060274Seat Track · corrodedDURING 2 YEAR CHECK IN BNA, FOUND SEAT TRACK AT LBL 18.3 IS CORRODED OUT OF LIMITS BETWEEN FS 297 AND 304. THE OUT OF LIMITS HAS BEEN REPAIRED IAW MESABA EO#S53342. REF: EAMS WORK ORDER 213767 TASK 1514.
Back to JASC 5347