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 QXEA200500808Skin · gougedYYC - AFT FUSELAGE SKIN GOUGED AT STATION 5.00 BETWEEN STRINGER 26R AND 25R. REPAIRED IAW CRJ700/900 SRM 51-12-00-001-001-A01, 53-00-01-101-001-A01 AND CRJ700 SRM 51-25-01-001-001-A01.SDR QXEA200500801Skin · nickedYYC - FUSELAGE EXTERIOR SKIN AT STATION 1000, BETWEEN STRINGER 14L AND 15L HAS NICK ON SKIN. REPAIRED IAW HORIZON AIR EA R-53-306, REO 670-53-61-165 AND CRJ700 SRM 51-25-01-001-001-A01.SDR QXEA200500803Skin · nickedYYC - FUSELAGE EXTERIOR HAS NICK AT STATION 823 BELOW STINGER 15R. REPAIRED IAW HORIZON AIR EA R-53-301, REO 670-53-41-013 AND CRJ700 SRM 51-25-01-001-001-A01.SDR A6WA200540156Skin · damagedLEFT SIDE AFT FUSELAGE SKIN DAMAGED BETWEEN FS 574-621, STRINGERS 17L-19L. MEASURES 2 INCH LONG BY 1 INCH WIDE BY .096 INCH DEEP. INSTALLED EXTERNAL DOUBLER AND TRIPLER TO DAMAGED FUSELAGE SKIN IAW BOMBARDIER, INCH REO 601R-53-61-1039. (M)SDR SWAA051078Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 930, STR 25R. REPAIRED SKIN PER SRM.SDR SWAA051077Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 787, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA051076Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 500 D, STR 15R. REPAIRED SKIN PER SWA EA.SDR SWAA051075Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 312, STR 18R. REPAIRED SKIN PER SRM.SDR 20030826Skin · corrodedDURING ROUTINE INSPECTION, UNDER BELLY SKIN CORROSION WAS IDENTIFIED AT FS 225.5 TO FS 230.95 APPROX. 5.5 INCH BY 19.5 INCH. CORRODED SKIN WAS REPLACED AND REPAIRED IAW EO. AIRCRAFT RETURNED TO SERVICE.SDR SWAA051073Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 500D + 2, STR 12R. REPAIRED SKIN PER SWA EA.SDR SWAA051064Skin · crackedDURING SCHEDULED RON CHECK, FOUND 2 EA FUSELAGE SKIN CRACKS AT BS 747 & BS 727 E, STR 16R. REPAIRED SKIN PER SWA EA & SRM.SDR ASAA0510042Skin · tool damageYXX - BONDED DOUBLER AND AIRCRAFT SKIN DAMAGED AT BSTA 827 AT STR 21L BY TOOL. BONDED DOUBLER AND AIRCRAFT SKIN AT BSTA 827 AT STR 21L REPAIRED IAW SRM. (K)SDR ASAA0540212Skin · lightning strikeLIGHTING STRIKE AT FRAME 211.8 ON CREASE BEAM. REMOVED DAMAGED, COMPLIED WITH A HFEC INSPECTION IAW MFG NDT MANUAL, NO DEFECTS NOTED. FABRICATED AND INSTALLED A REPAIR FILLER, DOUBLER, AND TRIPLER IAW SRM. (K)SDR ASAA0540210Skin · chafedLT FUSELAGE EXTERNAL SKIN CHAFED AT LT STAB AFT OF BOTTOM LUG CUTOUT STA 1150-1140. REMOVED DAMAGED SKIN, FABRICATED AND INSTALLED REPLACEMENT SKIN IAW SRM. (K)SDR QXEA200500806Skin · nickedYYC - FUSELAGE EXTERIOR UPPER SKIN HAS THREE NICKS AT FASTENERS BETWEEN STATION 295 TO 322 AND STRINGER 6R. REPAIRED IAW CRJ700 SRM 51-40-00-001-001-A01, REO 670-53-00-045.SDR QXEA200500805Skin · nickedYYC - FUSELAGE EXTERIOR UPPER SKIN HAS NICK AT STATION 364 AND STRINGER 4R. REPAIRED IAW CRJ700 REO 670-53-00-045 AND SRM 51-25-01-001-001-A01.SDR QXEA200500829Skin · nickedYYC - FUSELAGE EXTERIOR AT STATION 310 AND STRINGER 11R HAS TWO NICKS AT FASTENERS. REPAIRED IAW CRJ700 REO 670-53-00-045 AND SRM 51-25-01-001-001-A01.SDR ABXA050099Skin · damagedFORWARD CARGO COMPARTMENT, FORWARD DOOR OPENING LOWER AFT SKIN CUTOUT, PREVIOUS SPEED TAPE REPAIR CAME LOOSE. REPAIRED AREA IAW REA D853-51391MR.SDR UPS05444386Skin · corrodedLOWER FX EXTERNAL SKIN SURFACE RT POTABLE WATER TANK SERVICE CONNECTOR ATT DOUBLER FOUND SURFACE CORROSION AT STA 975 TO STA 980. CORROSION BLEND OUT 0.040 INCH BY 1 INCH BY 3 INCH EXCEED SRM 53-30-01 FIG 1 LIMITS, DOUBLER REPLACED AS PER SRM 51-10-01 PG 9.SDR 2005UALA00338Skin · dentedFUSELAGE DENT STA 389 BETWEEN STR 17L AND 18L. INSTALLED DOUBLER REPAIR.SDR 2005UALA00336Skin · gougedFWD CARGO DOOR CUTOUT, FWD SIDE AT APPROXIMATELY MID POSITION WAS FOUND TO HAVE DEEP GOUGE. INSTALLED 25 IN X 27 IN, TRIPLER REPAIR.SDR 2005UALA00317Skin · puncturedFUSELAGE LEFT SIDE STA 500 PUNCTURED SKIN AT STR 24L. UNDETERMINED CAUSE OF DAMAGE. SKIN REPAIRED PER STANDARD BOEING SRM.SDR 05FDEA00958Doubler · damagedREPAIR AT EXTERNAL DOUBLER BS 990 TO BS 1000 BL 0 WL 148, 18 INCHES BY 18.5 INCHES NEEDS EVALUATION TO DETERMINE PER SRM OR APPROVED DATA. REPAIRED DOUBLER PER FED EX EA 7-5330-86271SDR 72300155Skin · corrodedA 10.5 X 25 INCH AREA OF CORROSION ON SKIN INTERIOR.SDR SWAA051037Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED AT R2 DOOR FWD LOWER CUTOUT. REPAIRED SKIN PER SRM.SDR USAA050469Skin · crackedCLT - FOUND FUSELAGE SKIN CRACKED 1.75 INCH, STATION 727D, STRINGER 24L, BELOW ICE LIGHT. INSTALLED DOUBLER AND TRIPLER IAW SRM 53-00-01, FIG 229. (M)SDR SWAA051041Skin · crackedDURING SCHEDULED RON CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 940, STR 23L. REPAIRED SKIN PER SRM.SDR SWAA051027Skin · crackedDURING SCHEDULED C4 CHECK, FOUND 2 EA FUSELAGE SKIN CRACKS BETWEEN BS 312 & BS 317, BETWEEN STR 18R & STR 19R. REPAIRED SKIN PER SWA EA & SRM.SDR 2005UALA00315Skin · damagedLT FUSELAGE STA 599 TO 618 STRINGER 16L TO 17L. DAMAGE CAUSED BY CONTACT WITH GROUND EQUIPMENT. DAMAGE WAS CUTOUT AND DOUBLER REPAIR INSTALLED.SDR QXEA200500802Skin · nickedYYC - FUSELAGE EXTERIOR HAS NICK AT STATION 1060 AND STRINGER 13L. REPAIRED IAW CRJ700/900 SRM 53-61-01-001-002-A01 AND CRJ700 SRM 51-25-01-001-001-A01.SDR C1HA200595005Skin · dentedFUSELAGE SKIN 2.7 INCH AFT OF STA 259 AND JUST BELOW STR 17L HAS OUTWARD DENT, MARKED P4. CUT OUT DENT DAMAGE, FAB FILLER USING .050 2024T3 PO 0440785 AND REPAIR DOUBLER USING .063 2024T3 PO 0442440, DRILLED, ALODINE, PRIMED AND INSTALLED FILLER AND REPAIR DOSDR DHL2005740508Skin · damagedACCOMPLISHED IDENTIFICATION OF EXISTING REPAIR ON FUSELAGE SKIN AT STA 1148 AND STRINGER 29L PER ASTAR J/C FCD 500001-001B. REMOVED EXISTING REPAIR AT STA 1148 AND STR 29L IAW B727 SRM 51-30-2, DRAIN MAST REMOVED IN EA 38100001-001B. CUT OUT DAMAGE AT SKIN DSDR 2005UALA00314Skin · damagedLT FUSELAGE STATION 440 TO 475, STRINGER 16L TO 17L. DAMAGE CAUSED BY CONTACT WITH GROUND EQUIPMENT. DAMAGE SKIN WAS CUTOUT AND DOUBLER REPAIR INSTALLED.SDR 2005UALA00312Skin · gougedFUSELAGE SKIN ON LT SIDE BETWEEN STA 598 AND 604 AT STR 17L IS GOUGED. DAMAGE CAUSED BY CONTACT WITH GROUND EQUIPMENT. DAMAGE WAS CUTOUT AND DOUBLER WAS INSTALLED.SDR 2005UALA00311Skin · damagedFUSELAGE SKIN ON LT SIDE BETWEEN STA 418 AND 435 AT STR 17L IS DAMAGED. DAMAGE CAUSED FROM CONTACT WITH GROUND EQUIPMENT. DAMAGE WAS CUTOUT AND A REPAIR DOUBLER INSTALLED.SDR 2005UALA00309Skin · dentedDENT WAS FOUND AT BS 1708 STR 17R APPROX 2 INCHES LONG. DENT DAMAGE ON FUSELAGE SKIN CAUSED BY IMPACT. DAMAGE TO THE SKIN WAS CUTOUT AND A DOUBLER, TRIPLER, AND FILLER REPAIR STACKUP WAS INSTALLED.SDR QXEA200500749Skin · gougedYYC - LOWER FUSELAGE SKIN AT FS 975 AND STRINGER 27 HAS GOUGE CAUSED BY WING/FUSELAGE FAIRING CENTRAL CHANNELS. REPAIRED IAW CRJ700 SRM 51-42-21-001-001-A01 AND SRM 51-25-16-001-001-A01.SDR ABXA050088Doubler · corrodedDURING ROUTINE LINE MAINTENANCE, FOUND THE FUSELAGE DOUBLER BETWEEN EXTERIOR SKIN AND JACK PAD FITTING AT STA 1072, LONGERON 30, CORRODED BEYOND LIMITS. REPLACED DOUBLER IAW DC-9 SRM 51-30-3 AND 51-30-2.SDR UPS05844315Frame · crackedINSPECTION TYPE:C1 B-PIT DOOR AFT TORQUE BOX LWR FRAME AT STA 580 IS CRACKED BETWEEN L33R AND L33R. FABRICATED AND INSTALLED 2 DOUBLERS AND 1 FILLER AND INSTALLED IAW SRM 53-02-00-0 FIG 001B SHT 3, 53-2-0 FIG 1B, 51-1-21A, 51-1-21 AND EO DC-8 5320-6176-B.SDR 2005UALA00305Skin · damagedAFT CARGO DOOR CUTOUT FWD EDGE 20 INCHES FROM LOWER DOOR SILL, SUSTAINED DAMAGE MEASURING .2187 INCHES DEEP BY 4 INCHES LONG. INSTALLED TRIPLER EXT FUSE SKIN REPAIR 20" X 8".SDR 2005UALA00298Skin · dentedFUSELAGE SKIN DENTED OVER FRAME AT STA 560 BETWEEN STRINGERS 16L AND 17L. DENT IS .070 INCH DEEP. DENT WAS CUTOUT AND THE FUSELAGE SKIN REPAIRED USING A DOUBLER.SDR 05FDEA00917Skin · damagedDURING LIFT TRUCK POSITIONING STRUCK A/C ON LT SIDE AND CAUSED HORIZONTAL SCRATCH/HOLES APPROXIMATELY 14 INCHES IN LENGTH AT BS 300 TO 314 AND 18 INCHES BELOW WL 208 CHORD (FLOORBEAM). REPAIRED NOTED DAMAGE PER BOEING 727 SRM 53-30-3. THIS REPAIR WAS DEEMED SDR 05FDEA00872Skin · lightning strikeLIGHTNING STRIKE ON CROWN BS 588 BETWEEN STR 1 AND STR 2L. FOUND TO BE OUT OF LIMITS. REPAIRED SKIN IAW FED EX EA 7-5330-866368.SDR SWAA051019Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT L2 DOOR UPPER AFT CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA051018Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT R2 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA051012Skin · crackedDURING WALK AROUND INSPECTION, FOUND FUSELAGE SKIN CRACKED AT BS 727D + 2, STR 19R. REPAIRED SKIN PER SWA EA.SDR SWAA051011Skin · crackedDURING WALK AROUND INSPECTION, FOUND FUSELAGE SKIN CRACKED AT BS 312, STR 20R. REPAIRED SKIN PER SWA EA.SDR UALA200504AASkin · dentedFOUND FUSELAGE EXTERNAL SKIN HAS A GROUP OF DENTS FROM BS 380-400 BETWEEN STR. 15L-17L. S/O 269010, N/R 22034SDR 05FDEA00871Skin · misdrilledDRILL START IN FUSELAGE SKIN BELOW FWD GALLEY DOOR. REPAIRED DRILL START PER FED EX EA 7-5330-86265.SDR DHL2005740543Skin · corrodedREMOVED INBD FLOW CONTROL VALVE TO FOM S/M IAW B727 MM 21-58-21. REMOVED OUTBD FLOW CTL VLV TO FOM S/M REPAIR IAW B727 MM 21-58-31. REMOVED FASTENERS AT FUSE EXT SKIN BS 1223 BELOW STR 20L IAW B727 SRM 51-30-2, CUTOUT 4 EA DAMAGED AREAS DIM 3 3/8" BY 1 1/4"
Back to JASC 5330