JASC 5330
Service difficulty reports · 79,365
Reports filed under 5330 · Fuselage Main, Plate/Skin, 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 = '5330' 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 = '5330' 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 USAA920082011Skin · corrodedBFM MONITOR MAJOR REPAIR NR 6056548 CORROSION ON INTERNAL SKIN AT BOLT HOLES COMMON TO TEE FITTING BS960, S23R, WL178. REPAIRED INTERNAL SKIN AT BOLT HOLES COMMON TO TEE FITTING BS960, S23R, WL178 IAW US AIRWAYS EA NR 6056548.SDR USAA920082002Skin · crackedCLT RON MAJOR REPAIR LOG NR 8218827 CRACK IN FUSELAGE SKIN AT BS727E, S22L. REPAIRED FUSELAGE SKIN AT BS727E, S22L IAW B737 SRM 53-00-01.SDR GLBA200811121Skin · dentedMAJOR REPAIR - DURING ROUTINE DAILY LINE ENVIRONMENT CONDITIONS A TUG COLLIDED WITH THE AIRCRAFT LEAVING FOUR DENTS BELOW THE CARGO DOOR BETWEEN FS 447.0 TO APPROXIMATELY FS 472.7 BETWEEN STRINGER 11L & 12L. MAINTENANCE REPAIRED AFT FUSELAGE SKIN BETWEEN FS 4SDR SWAA086020Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 747, STR 19R. REPAIRED SKIN PER SRM.SDR SWAA086015Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 495 TO 437, STR 10L. REPAIRED SKIN PER SWA EA.SDR SWAA086014Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 432 TO 434, STR 10L. REPAIRED SKIN PER SWA EA.SDR SWAA086013Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 385 TO 387, STR 10L. REPAIRED SKIN PER SWA EA.SDR SWAA086012Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 731C TO 733C, STR 4R. REPAIRED SKIN PER SWA EA.SDR SWAA086011Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 503C, STR 10R. REPAIRED SKIN PER SRM.SDR 2008UALA06343Skin · dentedAFT FUSELAGE DENTED STA 1710, STR 13-14R. MAJOR REPAIR ACCOMPLISHED. CUT OUT DAMAGED AREA AND FABRICATED A REPAIR DOUBLER AND FILLER.SDR SWAA086018Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 440, STR 1. REPAIRED SKIN PER SWA EA.SDR SWAA086005Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 420, STR 16L. REPAIRED SKIN PER SRM.SDR SWAA086004Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 436, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA086003Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 426, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA086002Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 500A, STR 17R. REPAIRED SKIN PER SRM.SDR USAA920082028Bear Strap · crackedCLT Q3 MAJOR REPAIR NR 03055380550/001 2 CRACKS ON BEAR STRAP AT L1 DOOR UPPER HINGE CUTOUT BS303, S10L. 0.50 INCHES LONG AND 0.187 INCHES LONG. REPAIRED BEAR STRAP AT L1 DOOR UPPER HINGE CUTOUT BS303, S10L, IAW US AIRWAYS EA NR 100723.SDR UPS08553972Skin · damagedINSPECTION TYPE:N/A LIGHTNING STRIKE DAMAGE TO FASTENER LOCATED AT FUSELAGE BS 395.0 STRINGER 3 LEFT. DAMAGE BEYOND SRM LIMITS. DAMAGED REPAIRED PER EO B757-5330-31068-A.SDR SWAA086024Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BETWEEN BS 431 TO BS 434, STR 1L. REPAIRED SKIN PER EA.SDR SWAA085999Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 881, STR 25R. REPAIRED SKIN PER SRM.SDR 08FDEA04651Skin · gougedAFT CARGO DOOR, FWD LOWER DOOR JAMB IS GOUGED. FOUND TO BE OUT OF LIMITS PER SRM 53-17-12. REPAIRED PER SRM 53-17-12. TREATED ALL AREAS PER 51-21-10. APPLY LUBRICANT CORROSION INHIBITOR PER 51-23-00.SDR ASAA0843921Bear Strap · crackedL1 DOOR LOWER HINGE CUTOUT SKIN AND BEARSTRAP CRACKED REMOVED DAMAGE. FABRICATED AND INSTALLED REPAIR TRIPLER, REPAIR DOUBLER, REPAIR FILLERS, STRUCTURAL FILLER IAW ASA EA 400-53EA-00284.SDR ASAA0843918Bear Strap · crackedL1 DOOR UPPER HINGE CUTOUT SKIN AND BEARSTRAP CRACKED. REMOVED DAMAGE FABRICATED AND INSTALLED BEARSTRAP FILLER REPAIR DOUBLER REPAIR FILLER IAW ASA EA 400 53EA 00284.SDR 2008UALA06327Skin · dentedDENT ON FUSELAGE SKIN AT STA 1711 BETWEEN S15R AND S16R. MAJOR REPAIR ACCOMPLISHED. CUT OUT DAMAGED SKIN AND INSTALLED DOUBLER REPAIR.SDR UPS08153827Skin · damagedINSPECTION TYPE:N/A LIGHTNING STRIKE TO FASTENER 1 INCH FWD OF FRAME 11. REPAIRED PER EO A300-5330-31036-A.SDR SWAA085947Skin · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR CUTOUT, BS 303 TO BS 305, WL 236 TO WL 258. REPAIRED SKIN PER PAE ER.SDR SWAA085959Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 435, STR 1. REPAIRED SKIN PER PAE ER.SDR SWAA085944Skin · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE SKIN CRACKED AT R2 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER PAE ER.SDR AALA200810146Skin · crackedCRACK IN FUSELAGE SKIN BELOW AIRSTAIR DOOR. CUTOUT CRACK, INSTALLED DOUBLER PER ESO 80559 DATED 10/21/08 AND DRAWING NR SR09530219.SDR DL757081463Skin · corrodedDURING AN AGING AIRCRAFT INSPECTION, CORROSION WAS FOUND ON THE INNER SURFACE OF THE GROUND AIR CONDITIONING CUTOUT AT STA 869. THE CORROSION DAMAGE WAS REPAIRED PER BOEING INSTRUCTIONS.SDR 2008UALA06319Skin · damagedFOUND LIGHTNING STRIKE HOLE THROUGH SKIN ABOVE F/O STATIC PORT, REQUIRES PLUG REPAIR. STRINGER HAS DAMAGE WILL REQ REPLACEMENT.SDR SWAA085907Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 960, BETWEEN STR 17R TO STR 18R. REPAIRED SKIN PER SWA EA.SDR SWAA085901Skin · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 377, STR 28R. REPAIRED SKIN PER AAR EA.SDR SWAA085900Skin · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE BELLY SKIN CRACKED AT BS 450, RBL 1. REPAIRED SKIN PER AAR EA.SDR SWAA085898Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 750, STR 18R. REPAIRED SKIN PER SRM.SDR SWAA085897Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND SKIN CRACKED AT R1 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA085896Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 380, STR 15L. REPAIRED SKIN PER EA.SDR SWAA085881Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND SKIN CRACKED AT L1 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER AAR EA.SDR SWAA085891Skin · crackedDURING SCHEDULED 14Y CHECK, FOUND SKIN CRACKED AT L1 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER AAR EA.SDR UPS08854179Skin · damagedINSPECTION TYPE:SV REPAIR SEQUENCE 803-F1-78 AT FS 1585 L24R HAS SRM 53-02-01 FIG 7 SHEET 11 IS A CAT B REPAIR. REMOVED REPAIR, FABRICATED AND INSTALLED REPAIR DOUBLER AND FILLER IAW DC-8 SRM 53-02-01 FIG 7 SHEET 11.SDR DLM88081665Skin · dentedDENTS ON REPAIR DOUBLER STA 229-245 BTW LONG 16 AND 18 LT. DENT OUT OF LIMITS. REMOVED DOUBLER AND FILLER IAW SRM 51-30-2 AND 51-30-5. REPAIR PARTS INSTALLED IAW ERA 330121-14 REV E.SDR DLM88081657Skin · dentedDENT ON FUSELAGE SKIN STA 206 BTW LONG 16 AND 17. DENT FOUND WITHIN LIMITS IAW SRM 53-04 FIG 38 TABLE COND 1B. PER NDT SPM 06.10.001 HFEC ACCOMPLISHED, NO CRACKS FOUND. NEW FILLER AND DOUBLER FABRICATED IAW ERA 362959-14 REV B. NEW DOUBLER AND FILLER INSTASDR DLM88081464Skin · crackedCRACK AND CORROSION IN BELLY SKIN AT POTABLE WATER DRAIN, FS 593.6, BTW L-29R AND L-30. CUT OUT DAMAGED AREA AND INSTALLED EXTERNAL DOUBLER.SDR SWAA085855Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 960, BETWEEN STR 18R TO STR 17R. REPAIRED SKIN PER SWA EA.SDR SWAA085853Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 435, STR 1. REPAIRED SKIN PER SWA EA.SDR FDEA200810274579Skin · damagedEXTERNAL LOWER FUSELAGE SKIN, LIGHTNING STRIKES (2EA) BS500- BS520, STR 28R- 27R. CHECKED LIMITS IAW SRM 53-00-01, FIG 201, REPAIR 6, FOUND TO BE OUT OF LIMITS IAW SRM 53-00-01, FIG 201, REPAIR 16 , FIG 101. REMOVED DAMAGE IAW SRM 50-00-01. REPAIR 16, NFEC CSDR UPS08854178Skin · damagedINSPECTION TYPE:SV REPAIR SEQUENCE 803-F1-10 AT FS 190-198 L24-25L HAS SRM REF 53-02-01 FIG 7 SHEET 11 IS A CAT B REPAIR. REMOVED REPAIR, FABRICATED AND INSTALLED REPAIR DOUBLER AND FILLER IAW DC-8 SRM 53-02-01 FIG 7 SHEET 11.SDR NWAA084816308Skin · crackedDURING LINE CHECK FOUND CRACK IN SKIN AT LAVATORY VACUUM EXHAUST HOLE AT BS 2090 S36R. REPAIRED PER EA 63-214334.SDR USAA920081980Skin · crackedCLT RON MAJOR REPAIR NR 8213467 AND 4371386 LT FUSELAGE SKIN CRACKED AT BS 967, 24L. REPAIRED LT FUSELAGE SKIN AT BS967, 24L IAW US AIRWAYS EA NR 100715.SDR DL757081446Skin · corrodedFUSELAGE SKIN CORRODED AT AFT LAV SVC CUTOUT FS 1690, S-26R. SKIN BLENDED AND REINFORCED WITH AN EXTERNAL DOUBLER.SDR 08FDEA04579Skin · damagedEXTERNAL LOWER FUSELAGE SKIN, LIGHTNING STRIKES BS 500- BS 520 STR 28R- 27R. CHECKED LIMITS IAW SRM 53-00-01 FIGURE 201 REPAIR 6, FOUND TO BE OUT OF LIMITS IAW SRM 53-00-01 FIGURE 201 REPAIR 16, FIGURE 101. REMOVED DAMAGE IAW SRM 50-00-01, REPAIR 16, NFEC CU
Back to JASC 5330