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 AALA20121102004Skin · corrodedFOUND PITTING/CORROSION ON LAVATORY VENT PORT ON FUSELAGE SKIN FROM STATION 888 TO 907. REMOVED CORROSION IN ACCORDANCE WITH SRM 51-10-02 AND ENGINEERING AUTHORIZATION B737-026880.SDR DALA1253680680Skin · dentedLEFT EXTERNAL FUSELAGE SKIN BS 1706 BETWEEN S15-16L DENTED. REPAIRED IAW ERA 507861-14, REV ORIG.SDR DALA1253660680Skin · corrodedON REMOVAL OF NUTPLATE ON FUSELAGE SKIN FOUND INNER SKIN EXFOLIATED BETWEEN BS 740-760 BETWEEN S22R. REPAIRED IAW SRM 53-00-01, REPAIR 3.SDR REXA2012110401145Skin · damagedTHE DAMAGE CONSISTS OF A BLENDOUT IN THE SKIN MEASURING 2.5 X 1.2 X 0.022 DEEP LOCATED 0.4 BELOW THE LOWER FASTENER ROW COMMON TO S-18L AND 1.1 FORWARD OF THE FORWARD FASTENER ROW COMMON TO FS 621. REPAIRED IAW EA CRJ253-00987A.SDR CALA2012110200743Skin · dentedDENT AT BS 697, STRINGER 27L DAMAGE IS JUST FWD OF THE L2 DOOR. SKIN REPAIRED IAW SRM 53-00-01, REPAIR 7.SDR CALA2012110200742Skin · gougedDENT AND GOUGE AFT OF L2 DOOR AT BS 1039 S13L. REPAIRED IAW ECRA 5330-03436.SDR UALA2012110506328Skin · damagedACP INTERIM REPAIR TO FUSELAGE SKIN FROM BS 1420-BS 1480 BET STR 18L-22L IAW ECRA 5331-01654.SDR GLBA2012110100101Skin · dentedDURING A SCHEDULED ROUTINE INSPECTION, FOUND A DENT IN THE RT FUSELAGE LOCATED BETWEEN STRINGERS 10R AND 11R AT FS 228.25 AND 243.25 IN A AREA OF 6" BY 4.6", WITH A DEPTH OF .15". REPAIRED IAW EO 12-1900-53-063. MAJOR REPAIRSDR SWAA2012110809169Skin · crackedFUSELAGE SKIN CRACKED AT BS 900, STR 2R. REPAIRED SKIN IAW EA.SDR UALA2012110506331Skin · dentedDENT IN FUSELAGE 5 FRAMES FWD OF DOOR 2L, 2 STRINGERS BELOW SKIN LAP. DENT APPROX 8 IN LONG, 4 IN WIDE, 3-8 IN DEEP AND EXTENDS INTO EXISTING DOUBLER. SUPPLEMENTAL DATA UPDATE, INSTALLED NEW REPAIR PER ECRA 5331-01652 AND TIMCO REO G15485 STA 570-660, STR 14SDR UALA2012110506329Skin · damagedAFT FUSELAGE, MISDRILLED HOLE IN SKIN AND STRINGER AT STA 1480, STR 21L. SUPPLEMENTAL DATA UPDATE, REPAIRED STR 21L IAW SRM 53-00-03, RPR 1.SDR CALA2012110200740Skin · gougedUPPER CROWN SKIN GOUGED 2 INCHES AFT OF LTV PRESSURE FEED THRU DOUBLER AT BS 727E BETWEEN STR 1 AND 2L. REPAIRED SKIN IAW ECRA 5331-01653.SDR CALA2012110200739Skin · damagedLEFT SIDE FUSELAGE DENTED JUST ABOVE LAV SERVICE PANEL 1.8 WIDTH .060 DEPTH ACROSS 2 FRAMES AND A STRINGER REPAIRED IAW ECRA 5330-03460.SDR CALA2012110200738Skin · dentedDENT IN SKIN AT BS 1486 BETWEEN S23- 24R. DENT IS APROX .025" DEEP APROX 1" IN DIA. REMOVED DAMAGED SECTION OF SKIN. FABRICATED DOUBLER. TREATED AND PRIMED AND INSTALLED IN REF TO SRM 53-00-01, FIG 201.SDR CALA2012110200735Skin · dentedDENT ON FUSELAGE FORWARD AND BELOW L2 DOOR 8 INCHES AFT OF BS 951.0 6 INCHES BELOW S17L 1.1"X1.8"X.059" DEEP.SDR CALA2012110200734Skin · dentedON ARRIVAL IT WAS NOTED THERE WAS A GOUGE & DENT 3 FEET FWD OF NR 4 DOOR RT AREA INSPECTED & FOUND TO BE WITHIN MM LIMITS, REF SRM 53-00-01.SDR CALA2012110200733Skin · wornUPPER FUSELAGE SKIN WORN IT BY DOSAL FIN AT L/E INSTALLED INTERIM REPAIR REF ECRA NR 5331-01239.SDR CALA2012110200732Skin · damagedDAMAGE DISCOVERED ON ELECTRICAL POWER DOOR & FUSELAGE SKIN AROUND DOOR, FIBERGLASS BOX DAMAGED, BENT PIN. PERFORMED INTERIM REPAIR IAW ECRA 5330-03618.SDR CALA2012110200731Skin · damagedON WALKAROUND FOUND HOLE AT STA 390, STR 16L SKIN . REPAIRED DAMAGE IAW SRM 53-00-01 REPAIR 19.SDR CALA2012110200728Skin · damagedEXTERNAL POWER CUT OUT T/E S/M LIP TORN. PERFORMED INTERIM REPAIR IAW ECRA 5330-03648.SDR CALA2012110200724Skin · dentedDENT ON SKIN BS 632, S19-20L. INSTALLED INTERIM REPAIR DOUBLERS REF ECRA 5330-03707.SDR CALA2012110100721Skin · damagedSKIN BS 654+22, STG 31RT DAMAGED. REPAIRED IAW SRM 53-00-01, FIG 201, REPAIR A .SDR CALA2012110100719Skin · damagedSKIN DAMAGED. REPAIRED IAW ECRA 5330-03676, PART 1.SDR CALA2012110100718Skin · gougedFOUND GOUGES STA 647, STR 28 ACCOMPLISH A PERMANENT REPAIR IAW ECRA 5330-03686 REV A.SDR CALA2012110100716Skin · dentedFUSELAGE SKIN DENTED 4 INCHES BELOW L1 DOOR BETWEEN BS 312 AND 340. REPAIRED IAW ECRA 5331-01649, REV A.SDR CALA2012110100706Skin · gougedLEFT FUSELAGE GOUGED AT WL 207.48, DOOR STA 76.03 LOWER FWD DOOR CUTOUT. BLENDED OUT GOUGE.SDR UALA2012110206299Doubler · damagedDAMAGE FOUND TO EXISTING FUSELAGE EXTERNAL DOUBLER REPAIR (CF0395) AT BS 640-660 BETWEEN STR 21L-22L. MAJOR REPAIR ACCOMPLISHED: REMOVED EXISTING REPAIR DOUBLER & FOUND DAMAGED FASTENER HOLES. TRIMMED OUT DAMAGE & ACP NDT OF CUTOUT & FASTENER HOLES COMMON TSDR UALA2012110206296Skin · damagedLEFT AFT FUSELAGE EXTERNAL SKIN WRINKLED IN AREA OF STATIC PORT AT BS 1360-1440 BETWEEN STR 20L-24L. MAJOR REPAIR ACCOMPLISHED: EVALUATED DAMAGED AREAS & FOUND OUT OF LIMITS OF SRM 51-10-01 FIG 7 DETAIL 7. REMOVED ADJACENT EXISTING FLUSH REPAIR & CUT-OUT DAMSDR FOTR3355512032012Skin · gougedDEEP GOUGE FOUND FUSELAGE SKIN LT SIDE, STA 259, STR 27. REPAIRED ON FAS WO 22148, NR 33555.SDR FOTR2819812032012Skin · corrodedFUSELAGE SKIN RT SIDE LAP JOINT AT STR 4R HAS CORROSION SPOTS BETWEEN BS 480 AND BS 620. REPAIRED ON FAS WO 22148, NR 28198.SDR SWAA2012112009630Skin · crackedCRACK AROUND FASTENER HOLE AND FWD GALLEY DOOR FWD DOOR CUTOUT. REPAIRED FWD GALLEY DOOR UPPER FWD DOOR CUTOUT IAW B737-300 EO AEM-HC53-510/12 R0 AND EA.SDR AALA20121107031Skin · scratchedSCRATCHES/GOUGES IN FUSELAGE SKIN BETWEEN LONGERONS 29 AND 28 RIGHT AT STATION 486. BLENDED GOUGES AND INSTALLED INTERNAL DOUBLER PER SRM 53-04-02SDR CALA2012110200723Skin · dentedFOUND DENT AFT OF R2 DOOR, FWD OF APU INLET. REPAIRED DENT IAW EC/RA 5331-01338.SDR AALA20121101006Skin · corrodedAFT LAVATORY VENT AREA, FUSELAGE SKIN FROM STATIONS 1016 TO 1040 BETWEEN STRINGERS 20 AND 21 LEFT. ACCOMPLISHED CORROSION REMOVAL PER EA B737-53-026848.SDR AALA20121101005Skin · corrodedAFT LAVATORY VENT AREA, FUSELAGE SKIN FROM STATIONS 1064 TO 1088 BETWEEN STRINGERS 22 AND 24 LEFT. ACCOMPLISHED CORROSION REMOVAL PER EA B737-53-026848.SDR AALA20121101004Skin · corrodedAFT LAVATORY VENT AREA, FUSELAGE SKIN FROM STATIONS 888 TO 947 BETWEEN STRINGERS 24 AND 26 LEFT. ACCOMPLISHED CORROSION REMOVAL PER EA B737-53-026848.SDR AALA20121101003Skin · corrodedAFT LAVATORY VENT AREA, FUSELAGE SKIN FROM STATIONS 1064 TO 1088 BETWEEN STRINGERS 20 AND 22 LEFT. ACCOMPLISHED CORROSION REMOVAL PER EA B737-53-026848.SDR CALA2012110100713Skin · dentedSKIN FOUND DENTED AT BS 674, WL 207. FUSELAGE SKIN REPAIRED IAW SRM 53-00-01, FIG 202, REPAIR 7.SDR CALA2012110100712Skin · dentedAFT FUSELAGE DENTED AT BS 1410 BL 0. REPAIRED IAW ECRA 5331-01388.SDR CALA2012110100711Skin · gougedFUSELAGE SKIN GOUGED BS 580 AT S29L. REMOVED DAMAGE MATERIAL; INSTALLED DOUBLER REF SRM 53-00-01.SDR CALA2012110100709Skin · dentedLEFT FUSELAGE AT BS 1710, STR 15L HAS DENT CROSSING OVER STRINGER CUTOUT DAMAGED SECTION OF STRINGER AND INSTALLED A STRINGER REPAIR REF SRM 53-00-03.SDR CALA2012110100705Skin · damagedFOUND DAMAGE IN FUSELAGE SKIN AT BS 1320, STRINGER 29LT. INSTALLED A REPAIR FILLER AND DOUBLER REF SRM 53-00-01.SDR CALA2012110100704Skin · dentedFUSELAGE SKIN DENTED BETWEEN BS 189 AND 195 AT BL 0. R & R DAMAGED INTERNAL BUTT SPLICE IAW DWG 65C27 793 AND SRM 51-10-02 AND SRM 51-40-02.SDR CALA2012110100703Skin · damagedSKIN DAMAGE AT BS 487 STRINGER 47L. SKIN REPAIRED IAW SRM 53-00-01 REPAIR 7 FIG 202.SDR CALA2012110100702Skin · dentedSKIN FOUND DENTED AT BS 467 STR 41L, DEPTH 0.064" WIDTH 1", LENGTH 2.674". EXCEEDS SRM 53-00-01 FIG 102 ALLOWABLE DAMAGE LIMITS. SKIN REPAIRED & REPAIR DOUBLER CRITICAL ROW FASTENERS INSTALLEDSDR N6WA2012103101Skin · damagedDAMAGE TO FUSELAGE SKIN. REPAIRED SKIN AT FS 1088.20 - 1098.2, S21-24L IAW REO 670-53-61-914.SDR AALA20121031022Skin · corrodedAFT LAVATORY VENT AREA, FUSELAGE SKIN FROM STATIONS 1016 TO 1040 BETWEEN STRINGERS 22 AND 24 LEFT. ACCOMPLISHED CORROSION REMOVAL PER EA B737-53-026848.SDR AALA20121031021Skin · corrodedAFT LAVATORY VENT AREA, FUSELAGE SKIN FROM STATIONS 1006 TO 1016 BETWEEN STRINGERS 22 AND 24 LEFT. ACCOMPLISHED CORROSION REMOVAL PER EA B737-53-026848.SDR AALA20121031020Skin · corrodedAFT LAVATORY VENT AREA, FUSELAGE SKIN FROM STATIONS 967 TO 1006 BETWEEN STRINGERS 22 AND 24 LEFT. ACCOMPLISHED CORROSION REMOVAL PER EA B737-53-026848.SDR AALA20121031019Skin · corrodedAFT LAVATORY VENT AREA, FUSELAGE SKIN FROM STATIONS 927 TO 967 BETWEEN STRINGERS 22 AND 24 LEFT. ACCOMPLISHED CORROSION REMOVAL PER EA B737-53-026848.
Back to JASC 5330