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 P5CA9701164Tie Down Ftg · corrodedLEVEL 1 - M/D TIE DOWN FITTING FOUND CORRODED AT BS 480 LBL 35. CORROSION REMOVED AND REPROTECTED PER BOEING SRM 51-10-01, 51-10-02.SDR P5CA9701163Tie Down Ftg · corrodedLEVEL 2 - M/D BS 420 LBL 17 TIE DOWN FITTING FOUND CORRODED/CRACKED. REPLACED AND INSTALLED WITH SCREWS AS PER MM 20-51-01 AND SVC TAG NR FF 008407.SDR P5CA9701162Tie Down Ftg · corrodedLEVEL 1 - M/D TIE DOWN FITTING FOUND CORRODED AT BS 440 LBL 45. CORROSION REMOVED AND REPROTECTED PER BOEING SRM 51-10-01, 51-10-07.SDR P5CA9701081Seat Track · corrodedLEVEL 2, U/D BS 498 TO BS 520 LBL 65 SEAT TRACK FLANGE CORRODED. REPLACED SEAT TRACK AT BS 480 EXISTING SPLICE TO BS 529 EXISTING SPLICE PER BOEING SRM 51-10-01.SDR P5CA9701080Seat Track · corrodedLEVEL 2, U/D BS 480 TO BS 520 RBL 46.5 SEAT TRACK FOUND HEAVILY CORRODED. REPLACED SEAT TRACK AT BS 480 EXISTING SPLICE TO BS 529 EXISTING SPLICE PER BOEING SRM 51-10-01.SDR P5CA9701078Seat Track · corrodedLEVEL 2, U/D BS 530 TO BS 590 RBL 65 SEAT TRACK CROWN FOUND CORRODED. REPLACED SEAT TRACK BETWEEN BS 530 TO BS 600 PER BOEING SRM 53-10-05.SDR P5CA9701077Seat Track · corrodedLEVEL 2, U/D BS 530 TO BS 710 RBL 46 SEAT TRACK CORRODED. REPLACED SEAT TRACK BETWEEN BS 530 TO BS 710 PER BOEING SRM 53-10-05.SDR P5CA9701071Seat Track · corrodedLEVEL 2, U/D BS 480 TO BS 502 RBL 65 SEAT TRACK CORRODED. REPLACED SEAT TRACK AT BS 480 EXISTING SPLICE TO BS 529 EXISTING SPLICE PER BOEING SRM 51-10-01.SDR P5CA9700675Seat Track · corrodedLEVEL 1 CORROSION, M/D TIE DOWN TRACK FLANGE, BS 450, RBL R82. REMOVED CORROSION PER BOEING SRM 51-10-01, WITHIN LIMITS PER 53-10-01, TREATED PER 51-10-02 AND MM 51-24-11.SDR P5CA9700674Seat Track · corrodedLEVEL 1 CORROSION, M/D SEAT TRACK BS 440 TO 450, WL 200, RBL R92 TO R94. REMOVED CORROSION PER BOEING SRM 51-10-01, WITHIN LIMITS PER 53-10-01, TREATED PER 51-10-02 AND MM 51-24-11.SDR P5CA9700671Tie Down · corrodedLEVEL 1 CORROSION, M/D FLOORBEAM TIE DOWN PLATE, BS 2200, WL 200, LBL L80 TO L85. REMOVED CORROSION PER BOEING SRM 51-10-01, WITHIN LIMITS PER 53-10-01, TREATED PER 51-10-02 AND MM 51-24-11.SDR P5CA9700670Seat Track · corrodedLEVEL 1 CORROSION, M/D TIE DOWN TRACK FLANGE, BS 460, LBL L61. REMOVED CORROSION PER BOEING SRM 51-10-01, WITHIN LIMITS PER 53-10-01, TREATED PER 51-10-02 AND MM 51-24-11.SDR P5CA9700667Seat Track · corrodedLEVEL 1 CORROSION, M/D TIE DOWN TRACK FLANGE, BS 460 TO 485, LBL L33. REMOVED CORROSION PER BOEING SRM 51-10-01, WITHIN LIMITS PER 53-10-01, TREATED PER 51-10-02 AND MM 51-24-11.SDR P5CA9700666Fitting · corrodedLEVEL 1 CORROSION, M/D TIE DOWN FITTING FLANGE, BS 480, LBL L11. REMOVED CORROSION PER BOEING SRM 51-10-01, WITHIN LIMITS PER 53-10-0, TREATED PER 51-10-02 AND MM 51-24-11.SDR P5CA9700665Fitting · corrodedLEVEL 1 CORROSION, M/D TIE DOWN FITTING, BS 500, RBL R11 TO L11. REMOVED CORROSION PER BOEING SRM 51-10-01, WITHIN LIMITS PER 53-10-01, TREATED PER 51-10-02 AND MM 51-24-11.SDR W8PA970720Seat Track · damagedMECHANICAL DAMAGE ON SEAT TRACK. REPAIRED PER SRM 53-00-52. (M)SDR W8PA970709Seat Track · damagedMECHANICAL DAMAGE ON SEAT TRACK. BLENDED DAMAGE, FOUND TO BE OUT OF LIMITS, REMOVED AND REPLACED SEAT TRACK PER SRM 53-00-52, 51-40-02, 51-20-01. (M)SDR W8PA970700Seat Track · damagedMECHANICAL DAMAGE ON SEAT TRACK, MARKED BETWEEN BS 540 AND BS 727 + 7 INCHES, RBL 45, WL 208. REMOVED AND REPLACED SEAT TRACK FROM BS 540 TO BS 727 + 7 INCHES, RBL 45, WL 208 PER SRM 53-00-52. (X)SDR W8PA970688Seat Track · damagedMECHANICAL DAMAGE ON SEAT TRACK AT BS 328 - BS 480, RBL 24, WL 208. REPAIRED PER SRM 53-00-52. (X)SDR W8PA970676Seat Track · damagedMECHANICAL DAMAGE ON SEAT TRACK. ORIGINAL THICKNESS .160 INCH. REMOVED AND REPLACED SEAT TRACK PER SRM 53-00-52. (X)SDR SCNA97216Seat Track · corrodedDURING HEAVY MAINTENANCE VISIT, FOUND CORRODED SEAT TRACK AT STATION 370, LBL 42.8. REMOVED, FABRICATED, AND INSTALLED NEW SEAT TRACK IAW B727 SRM 53-10-1, 51-30-2, AND MM 51-20-11.SDR SCNA97208Seat Track · corrodedDURING HEAVY MAINTENANCE VISIT, SEAT TRACK AT THE FOLLOWING LOCATIONS WERE FOUND CORRODED: STATION 1070 TO 1130 LBL 56, STATION 1070 LBL 25, AND STATION 1110 TO 1130 LBL 46. REMOVED, FABRICATED, AND INSTALLED NEW SEAT TRACK IAW B727 SRM 51-20-2, 51-30-2, AND SDR P5CA9700664Seat Track · corrodedLEVEL 1 CORROSION, M/D BS 2180, RBL 98 TIE DOWN TRACK SURFACE. REMOVED CORROSION PER BOEING SRM 51-10-01, WITHIN LIMITS PER 53-10-01, TREATED PER 51-10-02 AND MM 51-24-11.SDR P5CA9700663Seat Track · corrodedLEVEL 1 CORROSIO, M/D BS 512, RBL 11 TIE DOWN TRACK. REMOVED CORROSION PER BOEING SRM 51-10-01, WITHIN LIMITS PER 53-10-01, TREATED PER 51-10-02 AND MM 51-24-11.SDR P5CA9700662Seat Track · corrodedLEVEL 1 CORROSION, M/D BS 512, LBL L11 TIE DOWN TRACK. REMOVED CORROSION PER BOEING SRM 51-10-01, WITHIN LIMITS PER 53-10-0, TREATED PER 51-10-02 AND MM 51-24-11.SDR P5CA9700661Seat Track · corrodedLEVEL 1 CORROSION, M/D BS 537 RBL R10, SEAT TRACK FLANGE. REMOVED CORROSION PER BOEING SRM 51-10-01, WITHIN LIMITS PER 53-10-01, TREATED PER 51-10-02 AND MM 51-24-11.SDR P5CA9700660Seat Track · corrodedLEVEL 1 CORROSION, M/D SEAT TRACK UPPER SURFACE AT STA 2250, LBL 33. REMOVED CORROSION PER BOEING SRM 51-10-01, WITHIN LIMITS PER 53-10-01, TREATED PER 51-10-02 AND MM 51-24-11.SDR MWEA97412Seat Track · out of limitsDURING D CHECK, STA 904 NO 3 SEAT TRACK BLENDED BEYOND LIMITS. MAINTENANCE SPLICED IAW SRM 53-05 FIG 4D AT STA 880-965.SDR DHL9770248DSeat Track · damagedAT D-CHECK, NR 5 CABIN FLOOR TRACK LOBES HAVE ROUGH EDGES AT CUT AREAS AND DAMAGED LOBES BS 640 TO 740 RBL 25. INSTALLED NEW SECTION OF SEAT TRACK FROM BS 640 TO 740 PER SRM 53-10-5.SDR P5CA9700942Tie Down Fitting · corrodedLEVEL 2 M/D BS 420 LBL 6 TIE DOWN FITTING FOUND CORRODED. CORROSION REMOVED PER BOEING SRM 51-10-01.SDR P5CA9700941Seat Tie Down · corrodedLEVEL 2 M/D BS 440 LBL 11-0 TIE DOWN FITTING FOUND CORRODED. CORROSION REMOVED PER BOEING SRM 51-10-01.SDR P5CA9700651Tie Down · corrodedLEVEL 1 CORROSION, M/D FLOORBEAM TIE DOWN PLATE, BS 2285, WL 200, RBL 45 TO 50. REMOVED CORROSION PER BOEING SRM 51-10-01, WITHIN LIMITS PER 53-10-0, TREATED PER 51-10-02 AND MM 51-24-11.SDR P5CA9700639Tie Down · corrodedLEVEL 1 CORROSION, M/D BS 460 LBL 3 TIE DOWN FITTING FOUND. REMOVED CORROSION PER BOEING SRM 51-10-01, WITHIN LIMITS PER 53-10-01, TREATED PER 51-10-02 AND MM 51-24-11.SDR P5CA9700638Seat Track · corrodedLEVEL 1 CORROSION, M/D BS 460 RBL 40 TIE DOWN FITTING FLANGE. REMOVED CORROSION PER BOEING SRM 51-10-01, WITHIN LIMITS PER 53-10-01, TREATED PER 51-10-02 AND MM 51-24-11.SDR P5CA9700637Seat Track · corrodedLEVEL 1 CORROSION, M/D BS 380 TO 390 RBL 11 TIE DOWN TRACK FLANGE. REMOVED CORROSION PER BOEING SRM 51-10-01, WITHIN LIMITS PER 53-10-01, TREATED PER 51-10-02 AND MM 51-24-11.SDR P5CA9700634Seat Track · corrodedLEVEL 1 CORROSION, M/D BS 400 TO 410 RBL 11 TIE DOWN TRACK. REMOVED CORROSION PER BOEING SRM 51-10-01, WITHIN LIMITS PER 53-10-01, TREATED PER 51-10-02 AND MM 51-24-11.SDR MWEA97407Seat Track · misrepairedDURING D-CHECK, STA 917 TO 937 NR 2 SEAT TRACK PREV REPAIR IMPROPER. MAINT REMOVED AND REPLACED IAW SRM 53-05 FIG 4D REF NR 1 0947.SDR DHL9770250DSeat Track · corrodedAT D-CHECK, NR 2 CABIN FLOOR TRACK IS CORRODED AT BS 620 TO 740 LB 45. REMOVED SECTION OF SEAT TRACK FROM 620 TO 740, INSTALLED NEW SECTION PER SRM 53-10-5.SDR DHL9770249DSeat Track · corrodedAT D-CHECK, NR 3 CABIN FLOOR TRACK IS CORRODED, BS 620 TO 740 LBL 25. REPLACED TRACK FROM 620 TO 740 PER SRM 53-10-5.SDR DHL9770226DSeat Track · corrodedAT D-CHECK, NR 1 CABIN FLOOR TRACK IS CORRODED FROM BS 620 TO 740 LBL 65. REMOVED CORROSION FROM SEAT TRACK TREATED AND PRIMED. REMOVED SEAT TRACK AND REPLACED PER SRM 53-10-1 FROM BS 655 TO 740.SDR P5CA9701060Tie Down Track · crackedFWD CARGO TIE DOWN TRACK FOUND CRACKED AT RT STN 650 TO 660 RBL 44 APPX. REPAIRED TRACK PER BOEING SRM 53-10-05.SDR MWEA97389Seat Track · corrodedNUMBER 4 SEAT TRACK CHANNEL AREA BLENDED OUT OF LIMITS AT STA 773. REMOVED AND REPLACED REPAIR IAW SRM 53-05 FIGURE 4A.SDR DHL9770227CSeat Track · corrodedAT D- CHECK, NR 3 FLOOR TRACK IS CORRODED AT BS 560 TO 620 BL 0. REPLACED SEAT TRACK PER SRM 53-10-5.SDR DHL9770225DSeat Track · corrodedAT D-CHECK, NR 3 CABIN FLOOR TRACK CORRODED FROM BS 480 TO BS 560 LBL 24. REPLACED FLOOR TRACK FROM BS 480 TO 560 PER SRM 53-10-5.SDR DHL9770216DSeat Track · crackedAT D-CHECK, NR 1 SEAT TRACK HAS O/B FLANGE CRACKED AT STA 870. REMOVED AND REPLACED TRACK PER SRM 53-10-5 FROM STA 870 TO 950.SDR DHL9770208DSeat Track · crackedAT D-CHECK, NR 3 SLAT TRACK HAS LIGHT CORROSION STA 870 TO 950. REMOVED CORROSION AND FOUND 4 INCH CRACK. REPLACED SEAT TRACK FROM BS 870 TO 960 PER SRM 53-10-5.SDR DHL9770207DSeat Track · corrodedAT D-CHECK, 31 SEAT TRACK CORROSION FROM STA 870 TO 950. REMOVED AND REPLACED SEAT TRACK PER SRM 53-10-5.SDR DHL9770206DSeat Track · corrosionAT D-CHECK, NR 7 SEAT TRACK HAS LIGHT CORROSION STA 740 TO 870. REMOVED AND REPLACED CABIN SEAT TRACK PER SRM 53-10-5 FROM STA 740 TO 870.SDR SCNA97240Seat Track · corrodedDURING HEAVY MAINTENANCE VISIT, THE SEAT TRACK AT STATION 420-460 RBL 55 WAS FOUND CORRODED. REMOVED, FABRICATED, INSTALLED AND NEW SEAT TRACK IAW B727 SRM 53-10-2, 51-30-2 AND MM 51-20-11.SDR SCNA97199Seat Track · corrodedDURING HEAVY MAINTENANCE VISIT, THE SEAT TRACK BETWEEN STATIONS 420 TO 460, RBL 55 WAS FOUND CORRODED. REMOVED, FABRICATED AND INSTALLED NEW SEAT TRACK IAW B727 SRM 53-10-2, 51-30-2, AND MAINTENANCE MANUAL 51-20-11.
Back to JASC 5347