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 DL757091011Skin · damagedDURING L/O FOUND DAMAGE TO FWD CARGO DOOR FRAME AFT CORNER WAS DOCUMENTED IN ADF BUT APPEARS TO BE STRUCK AGAIN. ADF DATED 4/6/08.SDR DL75E090987Skin · dentedFUSELAGE EXTERNAL SKIN HAS A DENT AT STA 1570 AND STR 28 LT, C/W AT SAS - SAT ON N/R 134308 JOB 82954990001.SDR DL75E090986Skin · dentedEMPENNAGE EXTERNAL DENT FS 1872 S3R- S4R, C/W AT SAA - SAT ON N/R 133993 JOB 82956570001.SDR DL75E090985Skin · dentedACCOMPLISHED REPAIR AS REQUIRED PER OMI LOG W/CN U03299225 2 DENTS NOTED AT STA 423 BETWEEN STRINGER S19L AND S20 . 4 FT AFT AND 2 FT BELOW L1 DOOR DENTS MEASURED IAW SRM 53-00-01 PAGE 1014 DETAIL 111 AS DESCRIBED IN CORRECTION ACTION, C/W AT SAA - SAT ON N/R SDR DL75E090980Floorbeam · corrodedSTA377 ON FLOORBEAM BL-0 - LBL 60 SEVERAL AREAS OF CORROSION AS MARKED CP53-221-01-02-5I. C/W AT SAA - SAT ON N/R 126038 JOB 82957590001.SDR SWAA093568Skin · crackedDURING SCHEDULED 2HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA093537Skin · crackedDURING SCHEDULED 2HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT R2 DOOR LOWER FWD CORNER CUTOUT. REPAIRED SKIN PER SWA EA.SDR SWAA093548Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR UPPER HINGE CUTOUT, BETWEEN BS 292 TO BS 304, BETWEEN WL 234 TO WL 262. REPAIRED SKIN PER EA.SDR SWAA093536Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 413, STR 17L. REPAIRED SKIN PER SWA EA.SDR SWAA093535Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 436, STR 17R. REPAIRED SKIN PER SWA EA.SDR SWAA093524Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT 727C, STR 14R. REPAIRED SKIN PER SWA EA.SDR SWAA093534Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 767, STR 22L. REPAIRED SKIN PER SRM.SDR SWAA093529Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 739.5, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA093530Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 770, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA093523Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 799, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA093521Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 799, STR 17L. REPAIRED SKIN PER SRM.SDR SWAA093522Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 810, STR 17L. REPAIRED SKIN PER SRM.SDR SWAA093531Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 880.5, STR 25R. REPAIRED SKIN PER SRM.SDR SWAA093533Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 900, STR 25R. REPAIRED SKIN PER SRM.SDR SWAA093532Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 930, STR 21R. REPAIRED SKIN PER SRM.SDR AALA20090605TUL06Skin · dentedDENT IN FUSELAGE SKIN AT STATION 228 LONGERON 19 LEFT TO 20 LEFT 2 INCHES BY 2 INCHES BY .041. DYE CHECKED, NO CRACKS FOUND. INSTALLED DOUBLER PER SRM 53-04-00 FIGURE 12B.SDR IPXA09556331Skin · dentedINSPECTION TYPE:C2 EXTERNAL FUSELAGE SKIN SECTION 48 LEFT, HAS A CREASED DENT MARKED AT BS 1949 BL 6L. REPAIRED PER SRM 51-70-10-2R-01-3.SDR USAA2009060191373Skin Panel · crackedPHX - B2 - MAJOR REPAIR - NR 4503012 - CRACK ON FUSELAGE SKIN PANEL AT FORWARD LEFT HAND AIR CONDITIONING ATTACHMENT CUTOUT BS520, S27L. REPAIRED FUSELAGE SKIN PANEL AT FORWARD LEFT HAND AIR CONDITIONING ATTACHMENT CUTOUT BS520, S27L IAW US AIRWAYS EA 112879.SDR FDEA200905311859Skin · damagedDURING PTF MOD, FOUND FUSELAGE SKIN HAS DEEP SCRATCHES IN SEVERAL LOCATIONS AT BS 640 TO BS 900, STR 4R. REPAIRED IAW EA F-5300-128631A REPAIR IS CLASSIFIED AS MAJOR PER GMM 6-2-100 CRITERIA.SDR IPXA09556173Skin · dentedINSPECTION TYPE:N/A DENT STA 1506 BETWEEN STR 28R AND 29R DAMAGED. REPAIRED PER EO 757-5330-33695-A.SDR ABXA200905300024Skin · crackedCRACK INDICATION IN SKIN FS 1654.5 AT APPROX S3R VERIFIED WITH ET. REPAIRED IAW B767-200 SRM 53-80-01, 1 INCH CRACK.SDR UALA2009060101563Skin · corrodedEXT FUSELAGE SKIN STA 1542, BL 0 IS CORRODED AROUND DRAIN HOLE STR 39L - 39R. MAJOR REPAIR ACCOMPLISHED: CUT OUT DAMAGED SKIN AND INSTALLED DOUBLER TRIPLER REPAIR.SDR SWAA093476Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND SKIN CRACKED AT BS 827, STR 13L. REPAIRED SKIN PER SWA EA.SDR COMA2009060150148Skin · crackedPERMANENT REPAIR NEEDS PERFORMED TO REPLACE TEMP REPAIR THAT WAS DONE AT FS 559.00 WEB BETWEEN RBL 9-18. REMOVED TEMP REPAIR AND INSTALLED A PERMANENT REPAIR ON FS 559 BULKHEAD WEB BETWEEN RBL 9 AND RBL 18 PER CRJ TASKCARD: SMA-2-53R0002 SECTION 2.SDR DL757090945Skin · dentedLWR FUSELAGE STA 1310-1330 S29L TO S28R PREVIOUS BLENDOUTS MULTIPLE SHARP DENTS, NO TAG C/W AT SAA - SAT ON N/R 107953 JOB 82866150001.SDR UALA2009060101580Skin · crackedEXTERNAL SKIN STA 1220 RT SIDE BETWEEN LAP AND STR 36 HAS CRACK INDICATION. DRILLED OUT CRACK AND INSTALLED SOLID RIVET.SDR SWAA093487Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 311.5, STR 19R. REPAIRED SKIN PER SWA EA.SDR SWAA093485Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 308, STR 20R. REPAIRED SKIN PER SWA EA.SDR SWAA093484Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 317, BETWEEN STR 19R TO STR 20R. REPAIRED SKIN PER SWA EA.SDR SWAA093486Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 325, STR 23R. REPAIRED SKIN PER SWA EA.SDR SWAA093482Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 331, STR 23R. REPAIRED SKIN PER SWA EA.SDR SWAA093483Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 344, BETWEEN STR 19R TO STR 20R. REPAIRED SKIN PER SWA EA.SDR SWAA093489Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 727C, STR 14R. REPAIRED SKIN PER SWA EA.SDR FDEA200905291850Skin · damagedAPPROX BS 650, LAP 26, BOTTOM ROW OF FASTENERS, 1 FASTENER HOLE HAS AN ELONGATED HOLE .270 INCH DIAMETER AT BS 650, LAP 26, (BS 646 / S26L), SKIN REPAIR WAS ACCOMPLISHED, DUE TO DISCREPANCY EFFECTING THE PTF CONVERSION, ON MAE MOD W/C NR 118250287DSSR08, AND MSDR DLM88090940Skin · gougedGOUGE AT STA 201 AND LONGERON 17R. REPAIRED IAW ERA 473065-14 REV ORG, TRIM OUT, FILLER AND DOUBLER.SDR UALA2009052901540Skin · dentedFUSE SKIN BS 400-420 STR 27L-28L HAS A DENT, 2X2 INCHES. INTERIM BLIND FASTENER REPAIR INSTALLED. PERMANENT REPAIR NOT TO EXCEED PTC:11,372.SDR DLM88090931Skin · dentedFUSELAGE SKIN STA 587 TO 636 AND LONGERON 23R DENTED ABOVE STATIC PORT. REPLACED FUSELAGE SKIN FROM STA 587 TO 636 FROM LONGERON 23 L TO L 26 L IAW SRM 53-04D FIGURE 12C AND 12E. CLASS 1 REPAIR - 8000 CYCLE, REPEAT VISUAL INSPECTION.SDR USAA2009052991334Skin · crackedPHL - WALK AROUND - MAJOR REPAIR - LOG 4385194 - CRACK IN FUSELAGE SKIN BETWEEN BS747 TO BS767, S19R. REPAIRED FUSELAGE SKIN BETWEEN BS747 TO BS767, S19R IAW B737 SRM 53-00-01-2R-31.SDR GLBA20090529GSkin · chafedDURING ROUTINE SCHEDULED MX A PREVIOUS PATCH REPAIR WAS FOUND CHAFED BEHIND THE RT HEAT EXCHANGER AT FS 30 BETWEEN STRINGER 17R AND 18R. MX REPAIRED THE AFFECTED AREA AT FS 30 ON THE RT SIDE OF THE FUSELAGE IAW EO- 09-120-53-001.SDR GLBA20090529FSkin · chafedDURING ROUTINE SCHEDULED MX A PREVIOUS PATCH REPAIR WAS FOUND CHAFED BEHIND THE LT HEAT EXCHANGER AT FS 30 BETWEEN STRINGERS 17L AND 18L. MX REPAIRED THE AFFECTED AREA AT FS 30 ON THE LT SIDE OF THE FUSELAGE IAW EO- 09-120-53-001.SDR FDEA200905281832Skin · damagedFOUND AN EXISTING BLEND OUT AREA AT C57, P 26RT REPAIR PERFORMED BY POLISHING TO SMOOTH FINISH AND NDT FOR CRACK FREE CONDTION IAW. RAS/EFW/9000179/2009 ISS. A, APPROVED BY EA 6-5310-129143SDR UIEA201000165Skin · dentedDURING WALKAROUND INSP DAMAGE WAS FOUND TO THE FUSELAGE SKIN RT BS 1765, S34 (LAP SPLICE) DENT DAMAGE MEASURING 1.5 IN LONG, 0.500 IN. WIDTH AND 0.045 DEPTH. (REF FIGURE 1). LOCATED 15.0 IN. FWD OF CARGO DOOR CUTOUT AND 7.0 IN ABOVE CARGO DOOR SWITCH CUTOUT. "SDR CNMA20090151Access Panel · damagedKEELBEAM ACCESS PANEL NR 139 AL HAS EDGE DAMAGE ON RT AND LT SIDES. SANDED, CLEANED AND PREPED KEELBEAM PANEL NR 139 AL IAW SRM 51-70-03, PG 6-8, APPLIED REPAIR IAW SRM 51-70-03 PG 9-13 AND RESTORED FINISH IAW SRM 51-70-03 PG 13.SDR CNMA20090149Skin · damagedREPAIR DENT STA 1493 524L AND 25-L EXTERIOR SKIN. CUT OUT DAMAGED AREA OF EXTERIOR SKIN STA 1493 STR 24L AND 25L. FABRICATED REPAIR PARTS AND INSTALL IAW SRM 53-00-01, FIG 201, REPAIR NR 4.SDR CNMA20090009Skin · damagedCOMPLY WITH EO D53-18 REPAIR OF SKIN AT S-27L STA 475 TO STA 495. COMPLETED EO D53-18 REPAIR OF SKIN AT S-2L STATION 475 TO 495 IAW EO D53-18 DWG 5330640-1.
Back to JASC 5330