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 QXEA200603335Seat Track · corrodedC3 YYC - INTERNAL FUSELAGE, FS483.0 - 573.0, LEFT OUTER SEAT RAIL HAS AREAS OF NICKS AND CORROSION. REPAIRED IAW REO670-53-00-013.SDR QXEA200603334Seat Track · corrodedC3 YYC - INTERNAL FUSELAGE, FS 379.0 - 483.0, RIGHT OUTER SEAT RAIL HAS AREAS OF CORROSION. REPAIRED IAW REO670-00-013.SDR QXEA200603333Seat Track · corrodedC3 YYC - INTERNAL FUSELAGE, FS 379.0 - 483.0, LEFT OUTER SEAT RAIL HAS AREAS OF NICKS AND CORROSION. REPAIRED IAW REO670-53-00-013.SDR 06FDEA04190Seat Track · corrodedLT FWD CABIN SEAT TRACK BEAM IS CORRODED FROM STA 580 - STA 620 LBL 45 REMOVED CORRODED SECTION OF SEAT TRACK AND REPLACED, REF SRM 53-10-1 FIGURE 3, SRM 53-10-2 FIGURE 7A.SDR 06FDEA04182Seat Track · corrodedMCD SEAT TRACK AT LBL 25, STA 948 - 958 HAS CORROSION. REMOVED AND REPLACED SEAT TRACK IAW 51-30-5. SEAT TRACK FABBED ON TRAVELER, T6/647796.SDR 06FDEA04181Seat Track · corrodedMCD - SEAT TRACK SPLICE AT LBL 25, STA 950-950 PLUS 20" HAS CORRODED FASTENERS, EXFOLIATION BETWEEN PARTS REMOVED SPLICE ANGLES. REMOVED CORROSION, SPLICE ANGLES OUT OF LIMITS. FABBED NEW ANGLES BATCH NR 9R000776001. TREATED AND PRIMED NEW ANGLES, INSTALLEDSDR SWIA200618246Seat Track · corrodedPASSENGER SEAT RAILS AT FS 485.00 TO FS 581.00 ARE CORRODED, DISCOVERED AT C-CHECK. REPLACED LEFT AND RIGHT PASSENGER SEAT RAILS AT FS 485.00 TO FS 581.00 WITH SERVICEABLE SEAT RAILS, P/N SH670-33426-1 (QTY 2).SDR QXEA200603341Seat Track · corrodedC3 YYC - INTERNAL FUSELAGE, FS 713.0-763.0, LEFT OUTER SEAT RAIL HAS AREAS OF CORROSION. REPAIRED IAW REO670-53-00-013.SDR 06FDEA04175Seat Track · corrodedMCD, BL 0 SEAT TRACK BETWEEN STA 870 - 880 HAS CORRODED NUT PLATE HOLES, TOP AND BOTTOM SIDES OF TRACK. BLENDED SEAT TRACK, FOUND TO BE OUT OF LIMITS IAW SRM 53-10-1,FIG 3. REMOVED SEAT TRACK IAW SRM 51-10-5, FABRICATED NEW SEAT TRACK ON TRAVELER T6/647662, SDR AMTA200600695Seat Track · brokenCABIN FLOOR SUPPORT SEAT TRACK CROWN FOUND BROKEN. REPLACED SEAT TRACK IAW SRM.SDR AMTA200600693Seat Track · corrodedCABIN SEAT TRACK FOUND WITH CORROSION AND SCRATCHES. REPLACED SEAT TRACK CROWN IAW SRM. (PART OF REPLACEMENT OF CROWN TRACK ON NRC 4193). (K)SDR 06FDEA04168Seat Track · corrodedCABIN, SEAT TRACK STA 1179 TO STA 1301 X=75.5 (LT) FOUND WITH CORROSION. REPAIR CARRIED OUT AS PER SRM 53-70-00 FIG.1 VOL.I. REPAIR CLASSIFIED MAJOR AS PER GMM 6-2-100.SDR CALA0600504Seat Track · corrodedINSPECTION FOUND SEAT TRACK CORRODED AT STA 360, LBL 24.75. A NEW SEAT TRACK WAS INSTALLED IAW SRM 51-40-02.SDR ASAA0671290Cargo Track · corrodedAFT CARGO BAY TRACK IS CORRODED AT BS 787 REPAIRED IAW SRM 53 00 53SDR AWXA200602082Seat Track · corrodedSAL - CORROSION ON MAIN CABIN SEAT TRACK, FS 24 - FS 35, -Y1292. REPLACED MAIN CABIN SEAT TRACK, FS 24 - FS 35, -Y1292 IAW A320 SRM 51-72-11.SDR 06FDEA04156Seat Track · crackedMAIN CARGO COMPT SEAT TRACK HAS A CRACK AND CORROSION AT FASTENER HOLE, APPROX AT BS 693 LBL 24 REMOVED SEAT TRACK FROM STA 690-740 LBL24 REF SRM 51-30-2. VERIFIED MATERIAL FOR NEW SEAT TRACK REF SRM 53-10-2 PG 13. FABRICATED NEW SEAT TRACK REF DWG NR 2902 ASDR 06FDEA04150Seat Track · corrodedLT CABIN SEAT TRACK BEAM IS CORRODED AT STA 620-628 LBL 1. REMOVED SEAT TRACK, FABRICATED NEW SEAT TRACK AND INSTALLED REF SRM 51-30-02 (N00537).SDR 06FDEA04149Seat Track · corrodedLT FWD CABIN SEAT TRACK BEAM IS CORRODED AT STA 546 LBL 24. REMOVED SEAT TRACK AND INSTALLED NEW TRACK REF SRM 51-30-5, AND SRM 51-30-2. (N00527)SDR 06FDEA04144Seat Track · corrodedCABIN LT SIDE STA 990-1070 LBL 45.5 SEAT TRACK HAS CORROSION AND EXFOLIATION ON O/B FLANGE REMOVED DAMAGED SEAT TRACK AND REPLACED WITH NEW TRACK REF SRM 53-10-5 PG1-5SDR K11A2008121872307Seat Track · corrodedSEAT TRACK HAS SEVERAL AREAS OF CORROSION.SDR DHL2006780121Seat Track · corrodedCABIN SEAT TRACK BS 830, LBL 45 HAS CORROSION AND IS GOUGED AS MARKED. REMOVED SEAT TRACK SECTION FROM BS 747.45 TO BS 852.95, LBL 45 AND FABRICATED NEW SEAT TRACK FROM BAC1520-841, 95" LONG, PO NR 9004051 IAW B727 SRM 53-10-2 FIG 7, 51-30-5, AND 51-30-2. TRSDR DHL2006780221Seat Track · corrodedCABIN SEAT TRACK BS 830, LBL 45 HAS CORROSION AND IS GOUGED AS MARKED. REMOVED SEAT TRACK SECTION FROM BS 747.45 TO BS 852.95, LBL 45 AND FABRICATED NEW SEAT TRACK FROM BAC1520-841, 95" LONG, PO NR 9004051 IAW B727 SRM 53-10-2 FIG 7, 51-30-5, AND 51-30-2. TRSDR K11A2008122672312Splice · corrodedCORROSION ON SEAT TRACK SPLICE, AFT PIT.SDR K11A2008122672311Splice · corrodedCORROSION ON SEAT TRACK SPLICE, AFT PIT.SDR K11A2008122672310Splice · corrodedCORROSION ON SEAT TRACK SPLICE, AFT PIT.SDR 06FDEA04141Seat Track · corrodedCABIN SEAT TRACK AT STA 990 TO STA 1079 X=-8.5 (RT) FOUND WITH CORROSION. REPAIR CARRIED OUT AS PER SRM 53-70-00 FIG.1 VOL.I. REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-100.SDR SWIA200617669Seat Track · corrodedLEFT FLOOR SEAT TRACK CORRODED AT END TO ABOUT 4" FEET BY GALLEY. INSTALLED LEFT FLOOR SEAT TRACK AFT SECTION FROM SEAT 9A TO GALLEY.SDR SWIA200617668Seat Track · corrodedLEFT FLOOR SEAT TRACK CORRODED AT BEGINNING TO ABOUT 4 FEET, DISCOVERED DURING C-CHECK INSPECTION. REPLACED LEFT FLOOR SEAT TRACK FROM SEAT 2A TO SEAT 4A.SDR ASAA0671283Cargo Track · corrodedAFT CARGO OH TIEDOWN TRACK AT BS 787 CORRODED REPAIRED IAW SRM 51 40 02.SDR ASAA0671268Cargo Track · crackedAFT CARGO PIT PH TIE DOWN TRACK CRACKED AT VERTICAL FLANGE AT BS 747. REPAIRED IAW SRM 51-40-02.SDR 06FDEA04126Seat Track · corrodedCABIN SEAT TRACK AT STA 6-0 TO STA 6-30 X=27.5 (LT) FOUND WITH CORROSION. CORROSION CRACK REMOVED AND SECTIONAL REPAIR PERFORMED AS PER SRM 53-70-00 FIG.1 VOL.I. REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-100.SDR KCSA061545Seat Track · damagedMAIN DECK SEAT TRACK IS DAMAGED AT STA 1150, LBL 74.SDR 06FDEA04120Seat Track · corrodedCABIN SEAT TRACK AT STA 824 TO STA 840 X=8.5 LT FOUND WITH CORROSION. CORROSION CRACK REMOVED AND SECTIONAL REPAIR PERFORMED AS PER SRM 53-70-00 FIG.1 VOL.I. REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-100.SDR 06FDEA04119Seat Track · corrodedCABIN SEAT TRACK AT STA 808 TO STA 859 X=27.5 LT FOUND WITH CORROSION. REPAIR CARRIED OUT AS PER SRM 53-70-00 FIG.1 VOL.I. REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-100.SDR 06FDEA04118Seat Track · corrodedCABIN SEAT TRACK AT STA 6-100 TO STA 1199 X=27.5 RT FOUND WITH CORROSION. REPAIR CARRIED OUT AS PER SRM 53-70-00 FIG.1 VOL.I. REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-100.SDR 06FDEA04117Seat Track · corrodedFOUND CABIN SEAT TRACK AT STA 845 TO STA 899 X=75.25 RT FOUND WITH CORROSION. REPAIR CARRIED OUT AS PER SRM 53-70-00 FIG.1 VOL.I. REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-100.SDR 06FDEA04116Seat Track · corrodedCABIN SEAT TRACK AT STA 899 TO STA 1099 X=27.5 RT FOUND WITH CORROSION. REPAIR CARRIED OUT AS PER SRM 53-70-00 FIG.1 VOL. I. REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-100.SDR 06FDEA04115Seat Track · corrodedCABIN SEAT TRACK AT STA 899 TO STA 962 X=8.5 RT FOUND WITH CORROSION. REPAIR CARRIED OUT PER SRM 53-70-00 FIG.1 VOL.I. REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-100.SDR 06FDEA04114Seat Track · corrodedFOUND CABIN SEAT TRACK AT STA 935 TO STA 1025 X=8.5 LT FOUND WITH CORROSION. CORROSION CRACK REMOVED AND SECTIONAL REPAIR PERFORMED AS PER SRM 53-70-00 FIG.1 VOL.I. REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-100.SDR 06FDEA04113Seat Track · corrodedCABIN SEAT TRACK AT STA 890 TO STA 979 X=27.5 LT FOUND WITH CORROSION. REPAIR CARRIED OUT PER SRM 53-70-00 FIG.1 VOL. I. REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-100.SDR ASAA0691227Cargo Track · gougedFWD CARGO PIT TIE DOWN TRACK LT AT BS 495 GOUGED REPAIRED IAW SRM 53 00 53 FIG 201.SDR QXEA200603395Seat Track · corrodedPDX C4 - LEFT OUTBOARD SEAT TRACK NR 3 HAS APPROXIMATELY 1" CIRCULAR SPOT OF CORROSION INSIDE CHANNEL AT APPROXIMATELY FUSELAGE STATION X544. REPAIRED IAW DHC8-200 SRM 51-40-11, 51-40-00 AND RD 8/51/102.SDR ASAA0691246Cargo Track · corrodedAFT CARGO RT TIE DOWN TRACK CORRODED AT NUTPLATE ATTACHING AREA UPPER AND LWR SURFACES. REPLACED WITH FABRICATED REPAIR PART IAW SRM 53 70 53 FIG 2.SDR ASAA0691240Cargo Track · corrodedAFT CARGO CORROSION FOUND ON RT TIEDOWN TRACK. TIEDOWN SECTION REPLACED WITH FABRICATED REPAIR PART IAW SRM 51 40 02.SDR ASAA0691239Cargo Track · corrodedAFT CARGO BAY CORROSION ON FLOOR TRACK SPLICE. CORRODED FLOOR TRACK SPLICE REPLACED WITH FABRICATED REPAIR PART IAW SRM 51 40 05 AND 51 40 02.SDR HNAA0600156Seat Track · corrodedCLEAT REPLACED DUE TO BEING CRACKED AND CORRODED AT X312 STR 23P AT SEAT RAIL ATTACH POINT LT SIDE.SDR HNAA0600155Seat Track · corrodedRIGHT REAR SEAT RAIL REPLACED DUE TO CORROSION.SDR AWXA200601969Seat Track · corrodedSAL - MAJOR REPAIR - CORROSION ON MAIN CABIN SEAT TRACK, FS 41+7", FS 42+17", FS 44+7", FS 45+4", FS 45+17",-Y1292. REPLACED SEAT TRACK, FS 41+7", FS 42+17", FS 44+7", FS 45+4", FS 45+17",-Y1292 IAW A319 SRM 51-72-11.SDR AWXA200602000Seat Track · corrodedSAL - FOUND CORROSION ON MAIN CABIN SEAT TRACK , -Y765 FS 20+1" AND FS 21+13. REPAIRED MAIN CABIN SEAT TRACK , -Y765 FS 20+1" AND FS21+13 IAW A319 SRM 53-11-15 FIGURE 202.SDR AWXA200601978Dummy Rail · corrodedSAL - CORROSION ON MAIN CABIN DUMMY RAIL (TRACK ), FS 20, -Y189. REPLACED MAIN CABIN DUMMY RAIL (TRACK), FS 20 - FS 24, -Y189 IAW A319 SRM 51-72-11.
Back to JASC 5347