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 USAA2012050700006Bear Strap · crackedFPBH VISIT - CRACK IN BEAR STRAP AT BS 303, S13L, WL 259. REPAIRED BEAR STRAP AT BS 303, S13L, WL 259 IAW B737 SRM 53-10-01PB 2R.SDR USAA2012050700005Bear Strap · crackedFPBH VISIT - CRACK IN BEAR STRAP AT BS 303, S10L, WL 263. REPAIRED BEAR STRAP AT BS 303, S10L, WL 263 IAW B737 SRM 53-10-01PB 2R.SDR SWAA2012050303652Skin · crackedFUSELAGE SKIN CRACKED AT BS 761, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA2012050303651Skin · crackedFUSELAGE SKIN CRACKED AT BS 772, STR 19L. REPAIRED SKIN PER SRM.SDR SIMA20120430009Skin · damagedON FLIGHT 2834 THE CREW REPORTED MULTIPLE LIGHTNING STRIKES EN ROUTE. ON POST FLT FOUND DAMAGE TO BOTH WING TIPS, STATIC WICK ON LEFT LOOSE, LANDING GEAR WAS UP DURING ALL STRIKES. SMELL OF ELECTRICAL BURNING IN COCKPIT. THE AIRCRAFT LANDED WITHOUT INCIDENTSDR SIMA20120430008Skin · damagedDURING MAINTENANCE INSPECTION, FOUND CENTER FUSELAGE SKIN HAS THREE LIGHTNING STRIKE BURN SPOTS ON RIVET HEADS AND FUSELAGE SKIN BEYOND ALLOWABLE LIMITS. REPAIRED IAW EO EM-5300-1965 PART C.SDR SIMA20120430007Skin · damagedDURING MAINTENANCE INSPECTION, FOUND CENTER FUSELAGE SKIN HAS ONE LIGHTNING STRIKE BURN SPOT BEYOND ALLOWABLE LIMITS. REPAIRED IAW EO-EM-5300-1965 PART B.SDR DALA1227830673Skin · damagedEXTERNAL FUSELAGE SKIN GOUGED AT FS 530, STR 28L. INSTALLED TIME LIMITED REPAIR PER ERA 499413-14 REV ORIG.SDR 3POR201204300002Skin · misrepairedINCORRECT REPAIR OF FUSEALAGE SKIN DAMAGE.SDR DALA13055060675Skin · dentedDURING HMV, FOUND A DENT IN FUSELAGE, SKIN, BS 510, S27-28L.SDR UALA2012043002548Skin · dentedFOUND DENT ON LT FUSELAGE APPROX 7 FT FWD OF DOOR 2L AND 2 FT BELOW WINDOW. DENT MEASURES APPROX 4 IN LENGTH BY 4 WIDTH. .062 DEPTH BY- 113877 :DENT OK PER SRM 53-00-01 PG 104. NO PULLED FASTENERS OR STRINGER DAMGE NOTED. ACCOMPLISHED SKIN AND STRINGER REPSDR UALA2012043002550Skin · damagedR4 DOOR DAMAGED, DENTED, AND CRACKED ON INNER SKIN AT LOWER CENTER ACCESS CUT OUT. REMOVED DAMAGE PERFORMED NDT AND NO CRACKS FOUND. FABRICATED DOUBLER REPAIR AND INSTALLED PER EA57-52-001 AND ECRA 5210-02298.SDR FOTR0503201235471Skin · corrodedCORROSION ON FUSELAGE SKIN BETWEEN BS 848-858, L28L TO 28R. REPAIRED ON FASI WO 22109, NR 35471.SDR DALA1238830918Skin · crackedRT FUSELAGE EXTERNAL SKIN HAS A CRACK AT THE FASTENER HOLE STA 1380 L14R. CUT OUT DAMAGE. COMPLIED WITH ER/A 503722-14 REV O.SDR DALA1238330918Skin · dentedRT FUSELAGE EXTERNAL SKIN HAS A REPAIR AND DENT UNIDENTIFIED STA 44 4 O`CLOCK POSITION. ACCOMPLISHED REPAIR WITH ERA 503030-14 REV ORIG AT SAA SAT HMV.SDR DALA1234160690Skin · dentedFUSELAGE DENT BS 1598 BETWEEN S27-28R, FOUND TO BE OUT OF LIMITS. CUT OUT DAMAGE AND FABRICATED DOUBLER AND INSTALLED IAW SRM 53-00-01 PG 201 REPAIR 3 FIG 201 STEPS 9 AND 10.SDR DALA1227910968Skin · crackedFUSELAGE CRACKED AT STA FS 1315.SDR DALA1227270673Skin · dentedEXTERNAL FUSELAGE SKIN HAS SHARP DENT AT FS 500, STR 28R. REPAIRED AREA IAW B757 SRM 53-00-01 FIG 201. IDENTIFIED REPAIR AS CAT "B" PERMANENT.SDR A6WA201240546Skin · gougedSKIN AT TOP OF FUSELAGE AT FS 672 IS GOUGED. FOUND TO BE BEYOND SERVICEABLE LIMITS, COMPLIED FULLY WITH REPAIR NR 3 EXTERNAL NON-FLUSH PERMANENT REPAIRS NON-PRESSURIZED AREA IAW SRM 53-00-31.SDR DALA1235660940Skin · crackedA CRACK OF 0.656 ON LT FUSE SKIN AT STA Y=1417 BTW LONG 1-2 LT, CRACK OF 0.281 ON LT INTERNAL ANGLE AT STA Y=1424 BTW LONG 1-2 CRACK OF 0.281 ON LT INTERNAL ANGLE STA 1424 BTW LONG 1-2. DOUBLER REPAIR ACCOMPLISHED IAW ERA 502201-14AD ORIG.SDR USAA2012052500011Skin Panel · corroded2S CHECK - CORROSION ON INTERNAL SKIN PANEL AT FR27+17 INCHES BETWEEN S42R TO S43R. REMOVED CORROSION ON SKIN PANEL AT FR27+17 INCHES BETWEEN S42R TO S43R, FOUND TO BE WITHIN LIMITS IAW EA 500867.SDR UALA2012043002557Skin · misrepairedEXTERNAL FUSELAGE SKIN AT BS 1430-1461 JUST BELOW CARGO DOOR WAS FOUND MISREPAIRED. REPAIRED SKIN IAW EA PT67-53-003 AND ECRA 5360- 01191. ACCOMPLISHED NDT OF AREA. NO CRACKS FOUND. ACCOMPLISHED INSURANCE CUT. FABRICATED AND INSTALLED EXTERNAL FILLER, DOUBSDR UALA2012043002556Skin · dentedDENT ON FUSELAGE AT BS 331 STRINGER S30L FOUND OUT OF SRM LIMITS. TRIMMED OUT DAMAGE IAW EA PT67-53-005 AND ECRA 5310-05483. ACCOMPLISHED NDT. NO CRACKS FOUND. ACCOMPLISHED INSURANCE CUT PER EA FABRICATED AND INSTALLED EXTERNAL DOUBLER AND FILLER REPAIR RESDR UALA2012042702509Skin · puncturedFUSELAGE PUNCTURED BOTTOM LEFT APPROXIMATELY BS 640 AND WL 144. HOLE IS APPROX 1 INCH BY 1 INCH. HOLE LOCATION IS AT BS STA 668 AND ABOVE STRINGER 26L. ACCOMPLISHED PERMANENT REPAIR IN ACCORDANCE WITH EG DOCUMENT.SDR DALA1229729234Skin · damagedDURING HMV, AFT FUSELAGE WAS DAMAGED DURING A JACKING INCIDENT. AREAS REPAIRED PER ERA 502763-14 REV O AT STA 1276 TO 1307 L24R TO L26R.SDR FDEA201204271659Skin · dentedUPPER FUSELAGE DENTED ON SKIN, BETWEEN BS 1560 STR 1L AND STR 2L. ACCOMPLISHED EA F-5330-159919. MAJOR REPAIR.SDR ABXR2012042700042Skin · damagedDENT AND GOUGE AT APPROX FUSELAGE STATION 883 RT SIDE AT LONGERON 21 RIGHT. REPAIRED IAW SERVICE DWG SG09530002.SDR C77A20130502013Skin · dentedA DENT WAS FOUND UNDER THE FO’S SIDE WINDOW ON THE SIDE OF THE FUSELAGE. BETWEEN FR 05 - 06 AND S21R AND 22R.SDR C77A201305020003Skin · dentedDURING A TURN IN MSP, DAMAGE WAS FOUND UNDER THE F/O’S SIDE WINDOW ON THE SIDE OF THE FUSELAGE. THE DAMAGE IS A DENT LOCATED BETWEEN FR 05 AND FR 06 AND STGR 21R AND 22R. FORWARD SIDE OF DENT IS LOCATED 5" AFT OF FR 05 AND AFT SIDE OF DENT IS LOCATED 11.10" SDR FDEA201204261603Skin · misrepairedSKIN FOUND MISREPAIRED. CARRIED OUT IAW SRM 53-00-15, FIG 202, REPAIR 8, REV 49. REPAIR CLASSIFIED MAJOR IAW GMM 6-2-100, REV 114.SDR FDEA201204261602Skin · misrepairedSKIN MISREPAIRED. CARRIED OUT REPAIR IAW SRM 53-00-15, FIG 202, REPAIR 8 REV 49. REPAIR CLASSIFIED MAJOR IAW GMM 6-2-100, REV 114.SDR DALA1229719234Skin · damagedDURING HMV AT MIA, THE AFT FUSELAGE WAS DAMAGED DURING A JACKING INCIDENT. AREAS REPAIRED PER ERA 502762-14 REV O AT STA 1193 THRU STA 1231 L20R- L26R.SDR SWAA2012043003584Skin · crackedSKIN CRACKED AT BS 426, STR 17R. REPAIRED SKIN PER EA.SDR UALA2012042702507Skin · puncturedAPPROXIMATELY 1 INCH BY 1 INCH PUNCTURE AT STA 1350 BETWEEN STR 20 AND 21 FROM CONTACT WITH LIFT. SHOULD ALSO READ LEFT SIDE OF ACFT. STOP DRILLED CRACKS PER SRM. OK FOR NON REVENUE FLT TO REPAIR STATION WITH MAX CABIN DIFFERENTIAL PRESSURE LIMITED TO 6.0 PSDR V0XR2012042600007Skin · dentedDENT AT X=291 BETWEEN STRINGER 11 AND 12. REPAIRED DENT IAW REPAIR DWG 8-53-12089 ISSUE 2. EDDY CURRENT GOOD, NO DEFECT. ULTRASONIC BOND CHECK GOOD, NO DEFECT.SDR V0XR2012042600005Skin · dentedDENT IN SKIN AT X=161 BETWEEN STRINGER 31 AND 32R. REPAIRED DENT WITH REPAIR DOUBLER IAW REPAIR DWG 8-53-12086.SDR V0XR2012042600004Skin · dentedDENT IN SKIN AT BS 319, S26 - 27R. DENT FOUND TO BE 0.040 DEEP AND 4.0" LONG, ASPECT RATIO 100. FABRICATED REPAIR DOUBLER AND INSTALLED IAW REPAIR DWG 8-53-12081.SDR V0XR2012042600003Skin · dentedDENT IN SKIN AT BS 304, S25R UNDER WING ICE SHIELD. DENT MEASURES 0.600 DIAMETER, 0.004 DEEP ABOVE STRINGER 25S AND IS WITHIN LIMITS IAW RD 8-53-1210. NDT SHOWS NO CRACKS INDICATED IAW NDTM PART 6.SDR V0XR2012042600002Skin · dentedDENT IN SKIN AT BS 298, S24R UNDER ICE SHIELD AREA. DENT MEASURES 0.600 DIA, 0.009 DEEP, .5" BELOW STRINGER 24S. DENT IS WITHIN LIMITS OF RD 8-53-1210. NDT INDICATES NO CRACKS IAW NDTM PT 6.SDR UHLA2012042500154Skin · damagedMAJOR REPAIR - MISDRILLED HOLE IN SKIN AT STR 26L BETWEEN FR2 AND FR3. PERFORMED REPAIR IAW ETD 2012-170-005909.SDR SWAA2012050803768Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 500C+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012050803767Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 440+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012050703736Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 807+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012050703735Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 460+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012050703732Skin · crackedRT FUSELAGE SKIN CRACKED AT BS 380+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW BAC DWG.SDR CHQA20120424136Skin · dentedDURING INSPECTION, A DENT WAS FOUND ON CENTER FUSELAGE IV SKIN BETWEEN FRAME 59 AND FRAME 60, AND STRINGERS 12R AND 13R. THE CENTER FUSELAGE IV SKIN BETWEEN FRAME 59 AND FRAME 60, AND STRINGERS 12R AND 13R, WAS REPAIRED IN ACCORDANCE WITH SRM 53-24-01.SDR UALA2012042502493Skin · misrepairedSKIN BS 1447, STR 37L MISREPAIRED. CUT OUT DAMAGE, FABRICATED AND INSTALLED HAT CHANNEL AND ANGLES PER SRM 53-00-03, FIG 201, RPR 2, TYPE IV. PERFORMED HFEC PER NDTM 51-00-16, PRT 6, NO CRACKS NOTED.SDR WX0A071185Doubler · corrodedAFT CARGO PIT DOUBLER CORRODED STA 1219 LONG 30 (CARGO DOOR CUTOUT DOUBLER). REMOVED CORROSION FROM INTERNAL DOUBLER. ACCOMPLISHED HFEC INSPECTION IAW NDT SRM 06-10-001. NO CRACKS NOTED. FABRICATED TITANIUM DOUBLER, REPAIR PARTS LOCATED DRILLED AND INSTALLSDR DALA1226780678Skin · gougedUPON REMOVING DORSAL FIN ANGLE FOUND DEEP GOUGE IN THE SKIN. REPAIRED PER ERA 501934-14 REV ORIG.SDR DALA1226740678Skin · damagedSTATIC DISCHARGE ON FUSELAGE SKIN SEAM AT STA 1335, STR 4R. REPAIRED PER ERA 499403-14 REV ORIG.
Back to JASC 5330