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 AALA20110507TUL01Skin · crackedRIGHT FUSELAGE AT STATION 1380 HAS CRACK IN SKIN AT SHEAR TIE AREA JUST ABOVE PYLON. STOP DRILLED CRACK AND INSTALLED DOUBLER REPAIR PER AARD 53-30-00-02.SDR USAA2011050991797Skin · crackedPHX - DAILY - CRACK IN FUSELAGE SKIN AT 2.5 INCHES FORWARD OF AFT CARGO DOOR AT BS 747, S18R. REPAIRED FUSELAGE SKIN AT 2.5 INCHES FORWARD OF AFT CARGO DOOR AT BS 747, S18R IAW B737 SRM 53-00-01.SDR A6WA201140450Skin · damagedFREEZE PLUG FOR 131AL IS MIGRATING OUT. R & R FREEZE PLUG IAW REO 601R-53-11997.SDR SWAA113561Skin · crackedDURING SCHEDULED OTS CHECK FOUND, L2 DOOR FUSELAGE SKIN CRACKED AT UPPER AFT CUTOUT. REPAIRED SKIN PER SRM.SDR CHQA201100179Reinforcement · corrodedDURING INSPECTION, THE TOILET CUP ON THE LOWER AFT FUSELAGE WAS FOUND CORRODED. THE TOILET CUP WAS REPLACED WITH NO FURTHER DEFECTS NOTED.SDR DALA1133960965Skin · dentedDURING A PSV VISIT WITH CPCP TWO DENTS WERE FOUND JUST BELOW THE FORWARD CARGO DOOR AT APPROX STA 378. REPAIRED PER ER/A 492529-14.SDR FDEA201105051759Skin · misrepairedEXISTING EXTERNAL FUSELAGE SKIN REPAIR AT STA. 740, STR 25R REQUIRES REPLACEMENT DUE TO NOT BEING IN COMPLIANCE WITH APPROVED DATA. REMOVED EXISTING DOUBLER/FILLER, BS 730-750, S-25R. HFEC INSP. SKIN CUTOUT, INITIAL HOLES PER NTM 51-00-19, PT.6 AND NTM 51-00SDR C2XA11TY056Skin · damagedAIRCRAFT SUSTAINED TWO LIGHTNING STRIKES. REMOVED AND REPLACED O/B STATIC WICK BASE AND DISCHARGER, REMOVED AND REPLACED LT ELEVATOR TIP FAIRING, BLENDED OUT LIGHT DAMAGE ON FUSELAGE ON SKIN AT FRAME 18 AND STR 19R, REPAIRED DAMAGE ON SKIN AT FRM 12 & STR 19RSDR ZZDA2011453Skin · crackedFUSELAGE SKIN, STA 1022.091, LONG L13, CRACKED. ACCOMPLISHED SKIN DOUBLER REPAIR PER EA 17-53-03221IR.SDR JR2R2011050500188Doubler · corrodedBACK PLATE FOR ANTENNA BETWEEN FRAMES 310 AND 295 HAS CORROSION IN THE FWD EE BAY. REMOVED AND REPLACED BACK PLATED IAW CRJ 7 SRM 51-42-06.SDR FDEA201105041931Skin · corrodedFUSELAGE SKIN HAS CORROSION OUTBD OF STR 26R BS 1166 TO 1183. REPAIRED FUSELAGE SKIN S26R BS 1166 TO 1183 IAW EA 7-5330-136759.SDR DALA1133250623Skin · dentedREPAIR ONE DENT ON LEFT SIDE OF FUSLAGE AT STA 1937.15 (LBL2.5). AT SAT ON W/O 87236790001 N/R 176368. COMPLIED WITH EA/A 491538-14 REVO REV 1, REV 2, REV 3, AND REV 4.SDR FDEA201105041751Skin · misrepairedSKIN REPAIR AT STA.740-760, STR 27R TO 28R REQUIRES REPLACEMENT DUE TO NOT COMPLYING WITH KNOWN APPROVED DATA. REMOVED DOUBLER/FILLER AT BS 740-760, S-27R-S-28R, PER SRM 51-40-02. HFEC SKIN CUTOUT, INITIAL HOLES PER NTM 51-00-19, PT.6, AND NTM 51-00-16, PT.6. SDR AALA20110504TUL03Skin · damagedDENT APPROXIMATELY .030 DEEP ON LEFT OF FUSELAGE LOCATED APPROXIMATELY 27 INCHES AFT AND INLINE WITH TOP OF PASSENGER DOOR. INSTALLED DOUBLER PER BOEING DRAWING SG09530001 REVISION A.SDR AALA20110504TUL02Skin · damagedLEFT FORWARD FUSELAGE STATION 260 LONGERON 16 LEFT HAS A GOUGE/DENT APPROXIMATELY 2 INCHES LONG. DYE CHECKED GOUGE NO CRACKS FOUND. REMOVED GOUGE PER SRM 53-01-00. INSTALLED DOUBLER PER BOEING REPAIR DRAWING SG09530001 REVISION A.SDR V0XR413Y050411001Skin · corrodedFWD FUSELAGE, STA 167.00 TO 182.00 BETWEEN STR 30 AND 31 LT, FOUND CORROSION ON SKIN. REPAIRED CORRODED SKIN FROM STA167.00 TO 182.00 BETWEEN STR 30 AND 31 LT IAW RD8-53-11740, WORK ORDER 80022, WORK CARD 1047.SDR DALA1139180915Skin · damagedLIGHTNING STRIKES ON UPPER FWD AND MID SECTION OF LT STA 769-788 FRAME 59. REMOVED FASTENERS, FABRICATED DOUBLER AND INSTALLED.SDR SWAA113352ASkin · crackedDURING SCHEDULED SPV CHECK, FOUND CRACK FASTENER HOLE, UPPER DOOR HINGE CUTOUT. REPAIRED PER DOC.SDR SWAA113338Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACK IN AT CHEM-MILL, BS 749.5, STR 18R. REPAIRED PER DOC.SDR SWAA113337Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACK IN AT CHEM-MILL, BS 814, STR 18L. REPAIRED PER DOC.SDR SWAA113336Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACK, AT BS 374, STR 15R. REPAIRED PER DOC.SDR DALA1131239858Skin · dentedDURING MAINTENANCE VISIT AT STA-SA, A DENT WAS FOUND ON THE FUSELAGE SKIN AT STA 144 BETWEEN L18L AND L19L. THE DENT WAS SUBSEQUENTLY REPAIRED PER ER/A 491556-14 SECTION I. PERFORM SECTION II INSPECTION PER ER/A 491556-14 AS FOLLOWS: INITIAL INSPECTION - WISDR ZZDA2011449Skin · dentedFUSELAGE SKIN, STA 218, LONG L15L TO L16L, DENTED. ACCOMPLISHED SKIN DOUBLER REPAIR PER B717 SRM 53-00-01, 51-10-04 AND TRA 17-53-TR00109.SDR DALA1505073244Frame · damagedDAMAGE 9" AFT FRAME 28, STR 43, REPAIRED IAW SRM 53-21-11.SDR DALA1505063244Skin · damagedSKIN DAMAGED 5" AFT FRAME 32 .910 FROM STR 43. REPAIRED IAW SRM 53-21-11.SDR DALA1505053244Skin · damagedLIGHTNING STRIKE REPAIR, 5" FWD FRAME 29, STR 43, REPAIRED IAW SRM 53-21-11.SDR DALA1136549880Skin · dentedLOWER FUSELAGE, STA Y294, BETWEEN LONG 28 RT AND LONG 29 RT, EXTERNAL SKIN WITH A DENT. INSPECTED DENT SKIN AT STA Y294 BETWEEN LONG 28 RT AND L29 RT, FOUND TO BE OUT OF LIMITS PER SRM 53-04, FIG 38, CONDITION 1A. FABRICATED AND INSTALLED INTERNAL PERMANENTSDR DALA1136069880Skin · dentedLOWER FUSELAGE, STA Y166 BETWEEN LONGERON 24 RT AND LONG 25 RT, EXTERNAL SKIN WITH DENT MEASURED DENT AT STA Y166 BETWEEN L24 AND L25 RT, FOUND TO BE OUT OF LIMITS PER SRM 53-04, FIG 38, TABLE C, CONDITION 1A, STEP 3. FABRICATED AND INSTALLED INTERNAL REPAIRSDR USAA2011051791877Skin · crackedCLT - Q2 - CRACK IN FUSELAGE SKIN AT L1 LOWER DOOR SKIN HINGE CUTOUT AT BS 303.93 BETWEEN WL 238 TO WL 234. REPAIRED FUSELAGE SKIN AT L1 LOWER DOOR SKIN HINGE CUTOUT AT BS 303.93 BETWEEN WL 238 TO WL 234 IAW EA 102888.SDR USAA2011051791876Skin · crackedCLT - Q2 - CRACKS IN FUSELAGE SKIN AT L-1 UPPER DOOR HINGE CUTOUTS BS 303.93 BETWEEN WL 257 TO WL 261. REPAIRED FUSELAGE SKIN AT L-1 UPPER DOOR HINGE CUTOUTS BS 303.93 BETWEEN WL 257 TO WL 261 IAW EA 102888.SDR GLBA20110502FSkin · crackedMAJOR REPAIR - DURING A SCHEDULED ROUTINE INSPECTION MAINTENANCE FOUND TWO CRACKS ON LT SIDE OF FUSELAGE UPWARD ALONG F.S. 273.25 AND STRINGER 10L, LENGTHWISE ALONG W.L. 93, 2.2" HIGH AND 4.2 WIDE IN LENGTH. MAINTENANCE REPAIRED THE AFFECTED AREA AND PERFORMEDSDR SWAA113347Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND SKIN CRACK IN CHEM-MILLED AREA, BS 747+2.5 AND BELOW S-19L. REPAIRED PER DOC.SDR SWAA113356Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACK AT BS 435.5, STR 17 LT. REPAIRED PER SRM.SDR SWAA113318Skin · crackedDURING SCHEDULED RON CHECK FOUND FUSELAGE SKIN CRACK, STA 900, STR 10L. REPAIRED PER DOC.SDR DALA1130729875Skin · dentedLOWER FUSELAGE, STA Y97.25, Z49, LT SIDE EXTERNAL SKIN WITH DENT, MEASURED DENT OUT OF LIMITS IAW SRM 53-04 FIG 38 CONDITION 1A. CUT OUT DAMAGE, FABBED AND INSTALLED REPAIR DOUBLER AND REPAIR FILLER IAW SRM 53-01 FIG 4. HFEC SURFACE NO CRACKS NOTED AT IAW NDSDR UALA2011050302176Skin · gougedRAMP REPORTED DAMAGE TO ACFT ONE INCH FWD OF FWD CARGO DOOR BELOW CTR LINE IT APPEARS TO BE A PUNCTURE. DAMAGE IS A GOUGE NOT A PUNCTURE AND IS .375 INCH IN DIAMETER LOCATED .50 INCH FWD OF FWD PIT DOOR ON FUSELAGE SKIN. SKIN THICKNESS IS .200 INCH & DAMAGE SDR UALA2011050202160Skin · damagedLT FUSELAGE IS CREASED APPROX 6FT STARTING JUST FWD OF DOOR 1L EXTENDING FWD. MAJOR REPAIR ACCOMPLISHED: REMOVED DAMAGED SKIN SECTIONS, AND ACCOMPLISHED GVI AND HFEC INSPECTIONS. FABRICATED 2 EACH DOUBLERS, AND INSTALLED ONE FWD OF BS 297 BUTT SPLICE AND ONE SDR DALA1133330623Skin · damagedFUSELAGE CREASE AND DENTED SEVERAL AERAS STA 1426-1430 STR 27 TO 29 RT. COMPLIED WITH AT SAA IN SAT ON W/O 87238680001 N/R 188762, PER ER/A 491091-14 REV ORIGINAL.SDR DALA1133280623Skin · corrodedUPON REMOVAL OF VHF ANTENNA SUPPORT STRUCTURE FOR FRAME REPLACEMENT FOUND INTERIOR SURFACE OF SKIN DOUBLER CORRODED STA 1460-1480 BETWEEN STR 29R AND 30. COMPLIED WITH ER/A 491563-14 REV ORIGINAL. AT SAA IN SAT ON W/O 87243590001.SDR SWAA113349Skin · corrodedDURING SCHEDULED 22Y CHECK, FOUND CORROSION NOSE FWD COMPARTMENT BS 227.8, BETWEEN RBL 10 TO LBL 10. REPAIRED PER SRM.SDR SWAA113281Skin · crackedDURING SCHEDULED OTS CHECK, FOUND CRACK IN FUSELAGE SKIN, BS 280, STR 15R. REPAIRED PER SRM.SDR DHLA201100041Skin · corrodedFUSELAGE SKIN BULGING AND CRACKED AT FS 26.0, BETWEEN LONGERONS 35L AND 36. ACCOMPLISHED SKIN EXTERNAL DOUBLER REPAIR IAW EVA D853-0041 REV A, DWG D85300441-001-D, REV D, AND SRM 53-2-1, FIG 8. REF NR 10081-10 UNDER W/O 10081. REPAIR LOCATIONS LISTED BELOW.SDR AALA20110501TUL02Skin · damagedDEEP GOUGE AND BLENDS ON UPPER DOOR CUTOUT SKIN ALONG LOWER EDGE OF HORIZONTAL LEG OF DOOR BEAM FROM STATIONS 1164 TO 1203. INSTALLED DOUBLER PER EA MD80-53-016682.SDR SWAA113195Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 482B+13, STRINGER 16L. REPAIRED SKIN PER EA.SDR TAMF201104300096Skin · crackedDURING SC4 CHECK, FOUND A CRACK ON INBD SKIN LT SIDE, FWD TO STA 237.500. REPAIR WAS PERFORMED WITH EWO 767-54-076.SDR TAMF201104300089Skin · corrodedDURING SC4 CHECK, FOUND CORROSION ON EXTERIOR SIDE LOWER EDGE LAP SPLICE AREA OF SKIN 148T3221, STA 1582-1725, STR 36L AND SKIN 148T3251 STA 1725.5, STR 36 LT. REPAIR WAS PERFORMED WITH EWO 767-53-136SDR TAMF201104300088Skin · damagedDURING SC4 CHECK, FOUND DENT AND SCRATCH FUSELAGE SKIN STA 1175-1197, STR 23-24 LT. REPAIR WAS PERFORMED WITH EWO 767-53-131.SDR TAMF201104300087Skin · corrodedDURING SC4 CHECK, FOUND CORROSION ON FUSELAGE SKIN STA 478 STR 30-31 RT. REPAIR WAS PERFORMED WITH EWO 767-53-130.SDR TAMF201104300086Skin · corrodedDURING SC4 CK WAS FOUND CORROSION ON FUSELAGE SKIN, STA 1417-1439, STR 26-32, LT. REPAIR WAS PERFORMED WITH EWO 767-53-129.SDR TAMF201043000085Skin · dentedDURING SC4 CK WAS FOUND SKIN DENT STA 1559, STR 31-32 RT. REPAIR WAS PERFORMED WITH EWO 767-53-071.
Back to JASC 5330