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 UALA2012040402098Skin · dentedFUSELAGE DENTED AT BS 395 BETWEEN STRINGERS 35-36L. EVALUATED DENT & FOUND OUT OF LIMITS. CUT-OUT DAMAGE & ACCOMPLISHED NDT FOR CRACKS. NONE FOUND. FABRICATED & INSTALLED EXTERNAL DOUBLER & FILLER REPAIR REF SRM. MAJOR REPAIRSDR A6WA201240508Skin · dentedSKIN DENTED BETWEEN FS 654.5-700.0 AND STR 20L-22L. REPAIRED FS SKIN BETWEEN 654.50-700.00, STR 20L-23L IAW REO 601R-53-61-4427.SDR SWAA2012043003600Skin · crackedL2 DOOR FUSELAGE SKIN FWD LOWER CORNER CRACKED AT UPPER RADIUS OF CORNER LOWEST FASTENER. REPAIRED SKIN PER EA.SDR SWIA201230536Skin · crackedCRACK ON OUTER SKIN OF AFT BAGGAGE BAY DOOR CUTOUT. (C-CHECK) REPAIRED OUTER SKIN OF AFT BAGGAGE BAY DOOR CUTOUT.SDR TIMA20120403006Skin · crackedA 1.75 INCH CRACK WAS DISCOVERED IN THE LOWER FUSELAGE SECTION AFT OF THE MAIN SPAR ON THE LEFT SIDE (FS 292) DURING A ROUTINE INSPECTION. THE CRACK WAS STOP DRILLED AND A DOUBLER INSTALLED IAW BEECH SRM CHAP 53-90-18.SDR USAA2012041600006Skin · crackedDROP-IN - CRACK IN OUTER SKIN FILLER AT BS 303, S10L AT L1 DOOR UPPER HINGE CUTOUT. REPAIRED FUSELAGE SKIN AT BS 303, S10L AT L1 DOOR UPPER HINGE CUTOUT IAW EA 202189 & B737 SRM 53-10-01-2R REPAIR 14.SDR USAA2012041600005Bear Strap · crackedDROP-IN - CRACK IN STRAP AT BS 303, S10L INSIDE FASTENER HOLE AT L1 DOOR UPPER HINDGE CUTOUT. REPAIRED STRAP AT BS 303, S10L AT L1 DOOR UPPER HINGE CUTOUT IAW EA 202189 & B737 SRM 53-10-01-2R REPAIR 14.SDR F3LA2012040600730Skin · damagedRIGHT SKIN PANEL FROM FRAME 1 TO FRAME 12, RT WINDSHIELD LOWER SECTION TO RT SIDE STRINGER, DAMAGED .SDR F3LA2012040600729Skin · damagedRIGHT SKIN PANEL FROM FRAME 1 TO FRAME 24, STRINGER 29 TO STRINGER 37 RT, DAMAGED.SDR SWAA2012042403362Window Post · crackedCOCKPIT LT WINDOW POST CRACKED. REMOVED AND REPLACED WINDOW POST PER SRM & BAC DRAWING.SDR K11A201204242202Skin · chafedSKIN CHAFED 1 X 1 INCH.SDR FDEA201204021232Skin · delaminatedFUSELAGE SKIN DELAMINATED. REPAIRED WITH A BONDED FILLER AND DOUBLER IAW SRM 51-70-10. MAJOR REPAIRSDR SWAA2012040902895Skin · crackedFUSELAGE SKIN CRACKED AT BS 390 + 1, STR 1L. REPAIRED SKIN PER SRM.SDR GLBA2012040203Skin · damagedDURING A SCHEDULED ROUTINE INSPECTION, FOUND THE RT FUSELAGE FS 288 HAS ELONGATED HOLES FROM ATTACHING FAIRING PANEL TO FS 327. REPAIRED THE AFFECTED AREA AND PERFORMED ALL REQUIRED RII INSPECTIONS IAW EO 12-1900-53-019. MATERIALS UTILIZED ARE INCLUDED IN TSDR FDEA201204021233Skin · dentedBS 1902 BL 0 HAS TWO DENTS IN SKIN, ONE DENT IS CREASED AND DELAMINATED. REPAIRED SKIN IAW SRM 51-70-10 AND SRM 51-70-01 REPAIR 1. MAJOR REPAIR.SDR FDEA201204021218Skin · corrodedAFTER REMOVAL OF TCAS ANTENNA FOUND CORROSION ON SKIN AT BS 420-440 AT STRINGER 28L TO 28R. REPAIRED IAW DWG 143N3003-2, SHT 1, REV C AND DWG 143N3400, SHT 21, REV B. REPAIR IS CLASSIFIED AS MAJOR.SDR DALA1234320926Skin · dentedAFT CARGO DOOR EXTERIOR SKIN HAS 8 AREAS DENTED. FOUND DENTS 1, 2, 3 ON AFT CARGO DOOR EXT SKIN TO BE OUT OF LIMITS DUE TO MORE THAN 3 ADJACENT DENTS IAW SRM 53-04-01 PG 28. COMPLIED WITH ERA 502453-14 REV ORIG.SDR SWAA2012042003290Skin · crackedFUSELAGE SKIN CRACKED AT STA 500C+5 ABOVE STR 15R. REPAIRED PER EA.SDR DALA1223839261Skin · dentedFS 1375 DENTED L25R & L24R INTERNAL SKIN DOUBLER DEFORMED. INSTALLED NEW DOUBLER AND FILLER PER SRM MD90 53-31-02.SDR AALA20120401009Skin · gougedDENT WITH GOUGE IN FUSELAGE SKIN BETWEEN STATIONS 500C AND 500D BELOW STRINGER 20 LEFT. INSTALLED DOUBLER PER SRM 53-00-01-2R.SDR AALA20120401007Skin · damagedDAMAGE TO UPPER FUSELAGE SKIN BS 430 AT STRINGER 28 RIGHT. INSTALLED DOUBLER PER SRM 53-00-01-2R.SDR DALA1219830930Skin · crackedDURING HMV AN CRACK WAS FOUND OF 0.031" ON FUSELAGE SKIN AT STA Y=1212 AND BETWEEN LONGERON 1 AND 2LT. SKIN WILL BE REPAIRED ON A ERA.SDR UALA2012040202010Skin · crackedNOSE WW LT AND RT AFT CORNERS CRACKED. REPAIRED IAW SB 747-53A2305 AND ECRA 5331-01589.SDR UALA2012040202009Skin · crackedEXTERNAL FUSELAGE SKIN CRACKED AT NLG WHEEL WELL AFT RT CORNER, BS 400. REPAIRED IAW SB 747-53A2305 AND ECRA 5331-01589.SDR UALA2012040202008Skin · crackedFUSELAGE SKIN CRACKED AT NLG WHEEL WELL LT AFT CORNER. REPAIRED IAW SB 747-53A2305 AND ECRA 5331-01589.SDR UALA2012040202007Skin · dentedLOWER FUSELAGE SKIN BS 1618 S18R AND S19R DENTED. ACCOMPLISHED INTERIM REPAIR PER ECRA 5330-04224. MAJOR REPAIRSDR SWAA2012040202783Skin · crackedFUSELAGE SKIN CRACKED AT BS 500C + 5, STR 15R. REPAIRED SKIN PER SRM.SDR DALA1219906806Skin · puncturedFUSELAGE SKIN PUNCTURED AT FS 690 BETWEEN S-24L AND S-25L. DOUBLER INSTALLED BY ER/A 501914-14 AND SRM 53-00-01 R3.SDR DALA1219860930Skin · corrodedDURING HMV CORROSION WAS FOUND ON FUSELAGE SKIN UNDER WING TO FUSELAGE FILLET FAIRING STA Y=723-807 BETWEEN LONGERON 16LT TO30. REF MD-88 SRM 53-04D PARA 57 FOR REPAIR.SDR DALA1219850930Skin · corrodedDURING HMV CORROSION WAS FOUND ON FUSELAGE SKIN UNDER WING TO FUSELAGE FAIRING STA Y=826-886,1000-1060 BETWEEN LONG 17L TO 19LT. REF MD-88 SRM 53-04D PARA 57 FOR REPAIR.SDR DALA1219840930Skin · corrodedDURING HMV CORROSION WAS FOUND ON FUSELAGE SKIN UNDER WING TO FUSELAGE FILLET FAIRING STA Y=1060-1073 BETWEEN LONG 18LT-19LT,Y=1117 LONG 27LT AND Y=1098 BETWEEN 28LT TO 29LT. REF MD-88 SRM 53-04D PARA 57 FOR REPAIR.SDR ABXR2012033100041Skin · crackedFUSELAGE SKIN CRACKED AT STA 1726. REPAIRED IAW SRM.SDR ABXR2012033100029Skin · chafedFUSELAGE SKIN DAMAGED AT STA 1809, S12R. REPAIRED IAW SRM.SDR ABXR2012033100030Skin · corrodedFUSELAGE SKIN EXPOSED BY LT FAILSAFE STRAP CORRODED. REPAIRED IAW SRM AND REA 46938REA06.SDR AALA20120422014Skin · dentedDENT IN FUSELAGE SKIN BETWEEN STATION 500G AND 500H AND BETWEEN STRINGERS 25 AND 26 RIGHT. INSTALLED 10.5 BY 11 INCH BLIND FASTENER REPAIR DOUBLER PER SRM 53-00-01-2R 4.SDR UALA2012040202033Skin · damagedSKIN DAMAGED. REPAIRED AT BS 1620 S18-19R PER ECRA 5330-04224.SDR UALA2012040202006Skin · damagedSKIN DAMAGED, REPAIRED AT DOOR 1R AT LWR DOOR CUTOUT PER ECRA 5330-04221.SDR UALA2012040202004Skin · corrodedLOWER FUSELAGE SKIN BULGING AT BS 1714 TO 1719 LBL-16. INSTALLED REPLACEMENT SKIN PANEL BS 1621-1720 S-26L TO S-26R. ALL WORK PERFORMED PER ECRA 5330-04223 AND SRM 51-40-02.SDR SWAA2012040302793Skin · crackedFUSELAGE SKIN CRACKED AT BS 787. REPAIRED SKIN PER SRM.SDR SWAA2012040202746Skin · crackedCHEM MILL FUSELAGE SKIN CRACKED BS 396, STR 15L. REPAIRED SKIN IAW ATS ER AND EA.SDR SWAA2012050403701Skin · crackedSKIN CRACKED AT BS 847, STR 18L. REPAIRED SKIN IAW SRM.SDR SWAA2012050403700Skin · crackedSKIN CRACKED AT BS 767, STR 19L. REPAIRED SKIN IAW SRM.SDR WX0A071140Skin · dentedBIRD STRIKE DURING LANDING, DENT ON RT FWD SIDE OF FUSELAGE APPROX 3 O`CLOCK POSITION. DENT IS 28" X 19" X S 3/4" DEEP WITH PULLED RIVETS IN SECOND FRAME, BENT AND CRACKED. CUT OUT DAMAGED SKIN AND FRAMES, HFEC INSPECTED AREA NO CRACKS NOTED. FABRICATED SKISDR FDEA201203291192Skin · gougedAFT CARGO DOOR SURROUND SKIN AT LOWER FORWARD CORNER SKIN EDGE HAS 2 AREAS GOUGED (1) 1" X .5", (2) 2.5" X .6250".SDR DALA1220600678Skin · damagedSTATIC DISCHARGE ON UPPER FUSELAGE SKIN BS 393 8R. REPAIRED IAW ERA 499407-14.SDR SWAA2012040302813Skin · crackedFUSELAGE SKIN CRACKED AT BS 360+5, STR 15R. REPAIRED SKIN PER SRM.SDR DALA1219756303Doubler · crackedCRACK APPROXIMATELY 1.1 X 0.6 INCH LENGTH FOUND ON THE RT UPPER LOBE DOUBLER, STA 2521 DURING HFEC INSPECTION. CARRIED OUT STA 2403.6 TO STA 2524.4EMPENNAGE UPPER LOBE DOUBLER SB747-53A2651 REV.1 AS PER PRI 499106-14AD REV. 0, 1, 2 AND 3. DATED 29FEB12.SDR DALA1219746303Doubler · crackedCRACK APPROXIMATELY 1.3 X 0.7 INCH LENGTH FOUND ON THE LT FUSELAGE TO SKIN VERTICAL STABILIZER UPPER LOBE DOUBLER STA 2521 DURING HFEC INSPECTION. CARRIED OUT STA 2403.6 TO STA 2524.4 EMPENNAGE UPPER LOBE DOUBLER SB 747-53A2651 REV 1 AS PER PRI 499106-14AD RESDR DALA1219560930Skin · corrodedDURING HMV CORROSION WAS FOUND ON FILLET PANEL RUBSTRIP FUSELAGE SKIN AT STA Y=738 AND Y=735 LONG 25RT REF MD-88 SRM 53-04D PARA 57 FOR REPAIR.SDR DALA1219550930Skin · corrodedDURING HMV CORROSION WAS FOUND ON FILLET PANEL RUBSTRIP FUSELAGE SKIN FROM STA Y=1117 TO 1136 LONG 21RT TO 29RT REF MD88 SRM 53-04D PARA 57 FOR REPAIR.
Back to JASC 5330