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 SWAA113290Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND CRACK FSLG SKIN AT CHEM-MILLED STEP BS 747 , STR 19R. REPAIRED PER SRM.SDR SWAA113237Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND CRACK ON KEEL BEAM SKIN, BS 706, BELOW STR 27. REPAIRED PER DOC.SDR UIEA2011042600252Skin · damagedDURING WALK-AROUND INSP, MX REPORTED DAMAGE WAS FOUND TO THE RT FUSELAGE SKIN BS1937, BELOW S37R (THE DAMAGE IS BEYOND THE SRM 53-00-01, FIGURE 101 ALLOWABLE DAMAGE 1, DETAIL III LIMITS. TIME LIMITED REPAIR ACCOMPLISHED AS DESCRIBED IN PART 1 WORK INSTRUCTIONSDR UIEA2011042600250Skin · dentedDURING WALK-AROUND INSPECTION AT ANC, MX REPORTED DAMAGE WAS FOUND TO THE RT FUSELAGE SKIN BS1928.5, BELOW S38R; 1 INCH DIAMETER. EO 4453A552 (THE DAMAGE IS BEYOND THE SRM 53-00-01, FIGURE 101 ALLOWABLE DAMAGE 1, DETAIL III LIMITS. TIME LIMITED REPAIR ACCOMSDR FDEA201104261631Skin · gougedSKIN GOUGED AT AFT FUSE LT SIDE ABOVE 4TH WINDOW FROM THE AFT ENTRY DOOR. REMOVED DAMAGE AREA (GOUGE), INSTALLED REPAIR DOUBLER, FINGER DOUBLER AND FILLER AT STA 1760 TO STA 1780, STR 10 L AND STR 11L IAW SRM 53-20-00, THIS IS A CLASS 1 REPAIR, MAJOR REPAIR.SDR DALA1129009875Skin · dentedLWR FUSELAGE BS Y1134,BETWEEN LONGS. 24 RT AND 25 RT EXT SKIN WITH DENT. DAMAGE AT STA 1134, BETWEEN L24R TO L25R, L=1.5",D=0.025", & 0.2 FROM L24R, FOUND OUT OF LIMITS IAW SRM 53-04, FIG 38, SHEET 2, TABLE C, CONDITION 1B. REFORMED DENT TO ORIGINAL CONTOUR ISDR SWAA113141Skin · crackedDURING SCHEDULED 18Y CHECK, FOUND SKIN CRACKED AT BS 400, BETWEEN STR 25R TO STR 26R. REPAIRED SKIN PER EA.SDR SWAA113134Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE SKIN CRACKED AT R2 DOOR AFT UPPER CORNER CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA113132Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 867, STR 17L. REPAIRED SKIN PER SRM.SDR AALA20120521018Skin · wornLIGHT WEAR ON AFT FUSELAGE BELLY SKIN AT STATION 727F TO 727G BETWEEN STRINGER 25 AND 26 LEFT. INSTALLED FOUR EACH RIVETS IN AREA PER SRM 53-00-01 REPAIR 13 AND EA B737-53-023770.SDR ASAA1199628Skin · crackedPOWER RECEPTACLE DOOR SURROUND CRACKED ON FORWARD SIDE. FABRICATED AND INSTALLED EXTERNAL REPAIR DOUBLER IAW TIMCO REO G13635 REV A DATED 05/09/2011 AND ASA EA 900 53EA 05391 REV NEW DATED 09MAY2011.SDR AALA20110426DWH02Skin · damagedCROWN SKIN STATIONS 500C TO 500D DAMAGED. ACCOMPLISHED DOUBLER REPAIR PER EA B737-53-016592.SDR DALA1128799871Doubler · dentedDENT IN UPPER WINDOW BELT DOUBLER, STA 712, LT SIDE. DENT MEASURES .017" X 7" DX=41 TOOL H9340. DENT FOUND TO BE OUT OF LIMITS IAW SRM 53-04, FIG 38. R & R WINDOW BELT AT STA 712, PN 9-5300-3-1772, PO 1098W037 IAW SRM 51-30-2 & 51-30-1, 51-30-5.SDR IPXA11166218Skin · damagedLIGHTNING STRIKE DMG 5 INCHES AFT OF FRAME 34 AT STR 35RT. REPAIRED IAW EO A300-5330-42399-A.SDR SWAA113111Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED BETWEEN BS 941.5 TO BS 943, STR 21R. REPAIRED SKIN PER ER AND EA.SDR SWAA113110Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND SKIN CRACKED AT BS 727E+11, STR 18R. REPAIRED SKIN PER SRM.SDR SWAA113109Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND SKIN CRACKED AT BS 624, STR 1. REPAIRED SKIN PER SRM.SDR SWAA113100Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 633.75+10, STR 4L. REPAIRED SKIN PER EA.SDR SWAA113099Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 616+11, STR 4L. REPAIRED SKIN PER EA.SDR SWAA113098Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 616+9, STR 4L. REPAIRED SKIN PER EA.SDR SWAA113087Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE SKIN CRACKED AT UPPER AFT CORNER CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA113071Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 420+14, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA113070Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 500B+14, STR 24R. REPAIRED SKIN PER SRM.SDR SWAA113069Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 907+12, STR 21R. REPAIRED SKIN PER SRM.SDR SWAA113068Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED BETWEEN BS 780 TO 781, STR 19R. REPAIRED SKIN PER SRM.SDR SWAA113067Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED BETWEEN BS 727D+7 TO 727D+8, STR 20R. REPAIRED SKIN PER SRM.SDR SWAA113066Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 727E+11, STR 18R. REPAIRED SKIN PER SRM.SDR SWAA113045Skin · crackedDURING SCHEDULED RON CHECK, FOUND SKIN CRACKED AT BS 827+10, STR 4R. REPAIRED SKIN PER EA.SDR SWAA113044Skin · crackedDURING SCHEDULED RON CHECK, FOUND SKIN CRACKED AT BS 807+10, STR 4R. REPAIRED SKIN PER EA.SDR SWAA113033Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND FUSELAGE SKIN CRACKED AT L2 DOOR LOWER HINGE CUTOUT, FWD LOWER CORNER. REPAIRED SKIN PER SRM.SDR SWAA113021Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 727E+3, STR 19R. REPAIRED SKIN PER SRM.SDR SWAA113020Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 727E+3, STR 18R. REPAIRED SKIN PER SRM.SDR SWAA113019Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 727E+12.5, STR 18R. REPAIRED SKIN PER SRM.SDR SWAA113018Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 793, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA113017Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 804, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA112989Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 624, STR 1. REPAIRED SKIN PER ER.SDR SWAA112988Skin · crackedDURING SCHEDULED MV3 CHECK, FOUND SKIN CRACKED AT BS 385, STR 15R. REPAIRED SKIN PER SRM.SDR SWAA112987Skin · crackedDURING SCHEDULED MV3 CHECK, FOUND SKIN CRACKED AT BS 395, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA112986Skin · crackedDURING SCHEDULED MV3 CHECK, FOUND SKIN CRACKED AT BS 407, STR 26L. REPAIRED SKIN PER SRM.SDR SWAA112985Skin · crackedDURING SCHEDULED 26Y CHECK, FOUND SKIN CRACKED BETWEEN BS 747+17 TO BS 747+18, STR 19L. REPAIRED SKIN PER SRM.SDR REXA201100243Skin · dentedAC SKIN DENTED AFT OF FS 280 BETWEEN S-24L AND 25L (LT SIDE AFT AND LEFT OF FWD JACK PAD). REPAIRED IAW BOMBARDIER REO 601R-53-21-1275.SDR COEA2011042501803Skin · damagedMAJOR REPAIR: FOUND FASTENER TRAPPED BETWEEN OUTER SKIN AND SUBSTRUCTURE AT APPRX FR 36LT. (UNUSED PILOT HOLE IN SKIN AND DOUBLER AT FR 36) REMOVED GILLINER TO ACCESS. REPAIRED SKIN AND DOUBLER IAW SRM AND SRI DO/TS1741/11-14956 ISSUE A. REINSTALLED GILLINESDR SWIA201126183Skin · damagedCARGO DOOR CUTOUT IS DENTED AT AFT LOWER CORNER EXTERIOR SKIN. (C-CHECK) REPAIRED PER SRM.SDR VNAA2011042700025Skin · damagedDURING SCHEDULED MAINTENANCE, REPAIRS WERE MADE TO THE FUSELAGE SKIN FROM FS 1015 TO 1047 BETWEEN STRINGERS 17L - 21L. AIRCRAFT WAS REPAIRED USING AIRCRAFT MAINTENANCE MANUALS. AIRCRAFT WAS RELEASED FOR SERVICE.SDR VNAA2011042700024Skin · damagedDURING SCHEDULED MAINTENANCE, REPAIRS WERE MADE TO THE FUSELAGE SKIN FROM FS 967 TO 977 BETWEEN STRINGERS 25L - 26L. AIRCRAFT WAS REPAIRED USING AIRCRAFT MAINTENANCE MANUALS. AIRCRAFT WAS RELEASED FOR SERVICE.SDR SWAA113108Skin · crackedDURING SCHEDULED CV CHECK, FOUND FUSELAGE SKIN CRACKED AT L2 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER SRM.SDR AALA20110424TUL02Skin · dentedDENT IN FUSELAGE SKIN STATIONS 253 TO 300 ABOVE STRINGER LONGERON 24 LEFT. INSTALLED PERMANENT REPAIR PER SRM 53-04-01 AND BOEING DRAWING SG09530002.SDR DALA1139190915Skin · damagedLIGHTNING STRIKE AFT LWR FUSELAGE STA 769-788 RT FRAME 60. REMOVED FASTENERS, FABRICATED DOUBLER AND INSTALLED.SDR DALA1131269866Doubler · crackedFUSELAGE EXTERIOR, UPPER ANTI COLLISION LIGHT, MOUNTING DOUBLER CRACKED AT FWD END AS MARKED. REMOVED CRACKED DOUBLER IAW DC9 SRM 51-30-2 FABRICATED AND INSTALLED REPLACEMENT DOUBLER IAW DC9 SRM 51-10-2, 51-30-2.SDR REXA201100247Skin · scratchedFUSELAGE SKIN SCRATCHED AND DENTED AT FS 672 BETWEEN S-23R AND S-24R. REPAIRED IAW BOMBARDIER REO 601R-53-52-4048.
Back to JASC 5330