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 USAA2011122200015Skin · crackedRON - CRACKED FUSELAGE SKIN AT BS 980 AND S24R. REPAIRED FUSELAGE SKIN AT BS 980 AND S24R IAW B737 SRM 53-00-01 REPAIR 31.SDR REXA2011122101031Skin · dentedDENT ON LT FS 559-80 BETWEEN FS 15 AND 16L. REPAIRED IAW SRM 53-00-31 REPAIR 1.SDR DALA1170790963Skin · crackedDURING CURRENT PSV IN MSP, A CRACK TO THE FUSELAGE SKIN WAS FOUND AT STA 1418, S-2L. THE CRACK IS EMANATING FROM THE THRID FASTENER HOLE COMMON TO SHEAR TIE. REPAIR ACCOMPLISHED PER ER/A 498623-14.SDR UIEA2011122300728Skin · damagedTHE ACFT WAS STRUCK BY GROUND EQUIPMENT AND SUSTAINED DAMAGE TO THE FUSELAGE SKIN, BEAR STRAP AND BS-670 FRAME JUST ABOVE THE THE LOWER AFT CORNER OF THE FWD CARGO DOOR OPENING. THE SEAL DEPRESSOR WAS ALSO DAMAGED IN THE INCIDENT. THE ACFT WAS FERRIED OR REPAISDR SWAA118621Skin · crackedDURING SCHEDULED SPV CHECK, FOUND RT FUSELAGE WINDOW SKIN CRACKED AT BS 440+10, LOWER AFT CORNER. REPAIRED SKIN IAW SRM.SDR GLBA20111221FSkin · crackedDURING A SCHEDULED ROUTINE INSPECTION FOUND THE BELLY SKIN CRACKED AT FS 303, 2.3" INBD FROM WING SKIN, .2500" IN LENGTH, SECOND CRACK .1" IN LENGTH, SEPARATED BY .4" THIRD CRACK 1.8" INBD FROM WING SKIN AND IS .6" IN LENGTH. REPAIRED THE AFFECTED AREA AND PSDR JR2R2011122100653Skin · corrodedCENTER FUSELAGE SKIN CHAFED AT FS 920. BLENDED CHAFE TO .030 WITH IN LIMITS IAW RO CRJ9-53-0897.SDR CA111222003Skin · cracked(CAN) WHILE CARRYING OUT A SCHEDULED SCRATCH AND DENT SURVEY OF THE FUSELAGE ASSY, THE AME FOUND A CRACK EMANATING FROM THE AFT LATCH CUT-OUT FOR THE LT SIDE ELECTRONICS BAY DOOR IN THE NOSE OF THE ACFT. THE DAMAGE LOCATED AT BS FS189 JUST BELOW THE RVSM AREASDR IPXA11670829Skin · puncturedREF D468301 AREA A DAMAGE EXTENDS FROM BS1439 TO BS1461 AND FROM S34L TO S38R. THE DAMAGE CONSISTS OF DENTS, GOUGE AND PUNCTURES IN SKIN. STRINGERS S37L, S38L, S39L AND S39R ARE SEVERED. STRINGER 35L AND 38R ARE DEFORMED. ALL DAMAGE REMOVED AND PERFORMED RSDR IPXA11670828Skin · puncturedAREA B DAMAGE EXTENDS FROM BS 1480 TO BS 1502 AND FRO M S36L TO S39R. THE DAMAGE CONSISTS OF DENTS, GOUGE, AND PUNCTURED SKIN AND DEFLECTED AND DEFORMED STRINGER AT 38L AND 39L. ALL DAMAGE REMOVED AND PERFORMED REPAIR IAW EO B767-5300-45359-A AND SRM 53-60-01SDR SWAA118622Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 887+6, STR 4R. REPAIRED SKIN IAW SRM.SDR COEA2011122044801Skin · dentedHEAVY CK COE / MAJOR REPAIR: DENT IN FUSELAGE SKIN BETWEEN FR 30-31 AND STR 17L - 18L. REMOVED DAMAGE DRILLED OUT DISCONTINUITY TO .128" DIAMETER, CONFIRMED CRACK FREE. INSTALLED RIVET IAW ATR72 SRM.SDR ASOA20111220012Skin · dentedDENT AFT OF PAX DOOR. LT CENTER FUSELAGE SKIN BETWEEN FRAMES 19-21 AND S11-12L. CUTOUT DAMAGE, INSTALLED FILLER AND DOUBLER. ALODINED PRIMED AND PAINTED. PRESSURE CHECKED GOOD. ACFT RELEASED AND RETURNED TO SERVICE.SDR SWAA118605Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 727B+10, STR 4R. REMOVED AND REPLACED SKIN PER SRM.SDR SWAA118604Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 867+10, STR 4R. REMOVED AND REPLACED SKIN PER SRM.SDR DALA14034030963Skin · crackedDURING CURRENT PSV, FUSELAGE SKIN WAS FOUND CRACKED BS 1418, S2R. CRACK IS EMANATING FROM THE THIRD FASTENER HOLE COMMON TO SHEAR TIE. REPAIRED IAW ER/A 498624-14.SDR SWAA118734Skin · crackedDURING SCHEDULED RON CHECK, FOUND CRACK IN UPPER FUSELAGE STA 727A TO 727B+2, STR 4R LAP. REPAIRED SKIN PER EA.SDR SWAA118733Skin · crackedDURING SCHEDULED RON CHECK, FOUND FUSELAGE SKIN CRACK AT FS 727A+7.5-8 INCH AT CHEM MILL, STR 4R. REPAIRED EA.SDR QXEA2011122801445Doubler · corrodedLAVTORY DRAIN MAST EXTERNAL DOUBLER HAS CORROSION. REMOVED DOUBLER IAW SRM 51-42-05-02-01. FABRICATED NEW DOUBLER IAW DWG 85328855. ALODINED, PRIMED AND INSTALLED DOUBLER IAW TASK CARD 6-53-1058, SRM 51-42-05-02-01. COMPLIED WITH TASK CARD 6-53-1058. APPLISDR SWAA118652Skin · crackedDURING SCHEDULED OTS CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 767+11, STR 4R. REPAIRED SKIN PER SRM.SDR FDEA201112195372Skin · misrepairedFUSELAGE SKIN AT BS 425-430, STR -24L MISREPAIRED. REPAIRED IAW SRM 53-00-01, FIG 201, REPAIR 16, AT BS 425-430, S24L. CAT "B" MAJOR REPAIR.SDR FDEA201112195371Skin · misrepairedSKIN AT BS 395, S17R MISREPAIRED. REPAIRED IAW SRM 53-00-01, FIG 201, REPAIR 316, CAT "B" MAJOR REPAIR.SDR ASOA201102393Doubler · corrodedDOUBLER ON INBD SIDE OF SERVICE DOOR THRESHOLD HAS CORROSION AT FWD & AFT CORNERS OF DOOR SURROUND AT FS 320 & 348. REMOVED AND INSTALLED DOUBLER IAW SRM 51-42-06. REQUIRES SDR.SDR SWAA118590Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND SKIN CRACKED AT BS 344, STR 17R. REPAIRED SKIN IAW EA.SDR SWAA118585Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND SKIN CRACKED BETWEEN BS 760 TO BS 765, STR 22L. REPAIRED SKIN IAW SRM.SDR SWAA118580Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 887+6, BETWEEN STR 10 TO STR 10L. REPAIRED SKIN PER SRM.SDR SWAA118579Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 867+10, STR 4R. REPAIRED SKIN PER SRM.SDR SWAA118578Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 827+8, STR 2R. REPAIRED SKIN PER SRM.SDR SWAA118577Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 727A+11, STR 4R. REPAIRED SKIN PER SRM.SDR SWAA118576Skin · crackedDURING SCHEDULED RON CHECK, FOUND SKIN CRACKED AT BS 877, STR 4R. REPAIRED SKIN IAW SRM.SDR SWAA118563Skin · crackedDURING SCHEDULED 16Y CHECK, FOUND SKIN CRACKED AT BS 211.8, STR 9L. REPAIRED SKIN IAW EO.SDR R5KB2011121946589Skin · corrodedINTERNAL SKIN, CORRODED AT STA 796, STRINGER 4L.SDR SWAA118539Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED BETWEEN BS 769.5 TO BS 771.7, STR 18L. REPAIRED SKIN IAW SRM.SDR SWAA118538Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 762, STR 19L. REPAIRED SKIN IAW SRM.SDR SWAA118536Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 867+10, STR 4R. REPAIRED SKIN IAW SRM.SDR SWAA118535Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 767+11, STR 4R. REPAIRED SKIN IAW SRM.SDR SWAA118527Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 727+3, STR 4R. REPAIRED SKIN IAW SRM.SDR SWAA118509Web · crackedDURING SCHEDULED 20Y CHECK, FOUND WEB CRACKED BETWEEN BS 344 TO BS 360, STR 17L. REMOVED AND REPLACED WEB IAW SRM AND DWG.SDR SWAA118508Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 727B+10, STR 4R. REPAIRED SKIN IAW SRM.SDR SWAA118503Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND FWD CARGO PIT DOOR CUTOUT AREA LOWER AFT INNER AREA TORQUE BOX SKIN CRACKED. REMOVED AND REPLACED SKIN PER SRM AND DWG.SDR SWAA118492Web · crackedDURING SCHEDULED 24Y CHECK, FOUND FLIGHT DECK FLOOR WEB CRACKED AT BS 246.6, RBL 15. REPAIRED WEB IAW EA.SDR SWAA118741Skin · crackedDURING SCHEDULED OTS CHECK, FOUND FUSELAGE SKIN CRACK BS 727D+3, STR 4R. REPAIRED CRACK PER DOC.SDR QMLA2011121711119Access Panel · damagedAFTER TAKEOFF, WHILE PERFORMING A SLIGHT LEFT TURN, JUST PRIOR TO LEVELING OFF. HEARD A LOUD "THUD" FROM UNDERNEATH ACFT IN THE VICINITY OF PILOTS SEAT. IMMEDIATELY RETURNED TO DEPARTURE AND LANDED WITHOUT INCIDENT. ACFT GROUNDED. MX SUSPECTS THAT THE SOUSDR REXA201100941Skin · damagedDENT AND GOUGE DAMAGE ON FUSLAGE SKIN B/W FS 589 - FS 605 & STR 24R - STR 26R. REPAIRED IAW BOMBARDIER REO 601R-53-61-4329 REV B.SDR FDEA201112175329Skin · corrodedFOUND CORROSION IN AND RUNNING UNDER LAP SEAM STA 740-770, S-19R MID LAV AREA. CORROSION REPAIRED ON STAM N/R 47168460001 IAW STAM EA 757-5331-16-F3614.SDR FDEA201112175328Skin · dentedSKIN STA 780-800 BETWEEN S-15L TO S-16L DENTED. DENT FOUND OUT OF LIMITS IAW SRM 53-00-01, FIG 101, DETAIL III. REPAIRED ON STAM N/R 4716842001 IAW STAM EA 757-5331-16-F3617, REV- . MAJOR REPAIR.SDR FDEA201112175327Skin · misrepairedSKIN BS 420 BETWEEN S-18R TO S-19R MISREPAIRED. REMOVED AND NEW REPAIR INSTALLED ON STAM N/R 47168450001 IAW STAM EA 757-5311-16-F3596, REV- . MAJOR REPAIR.SDR IPXA1570721Skin · dentedFUSELAGE SKIN PANEL, IS DENTED, BS 900-1180 S4-10L. REPAIRED SKIN WITH REINFORCING REPAIR IAW SRM 53-00-01-2R-2.SDR DALA1200140929Skin · corrodedCORROSION ON FUSELAGE SKIN RUB STRIP AREA STA 1079-1080. REPAIR ACCOMPLISHED IAW SRM 53-04D FIG 53.SDR AALA20111216AFW01Skin · gougedSKIN AT STATION 1200 BETWEEN STRINGERS 29 AND 30 RIGHT GOUGED. ACCOMPLISHED DOUBLER REPAIR PER SRM 53-00-01-2R.
Back to JASC 5330