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 SWAA2013071118128Doubler · crackedINTERNAL DOUBLER CRACKED BETWEEN BS 360+5" - BS 380+4, STRINGER 27L - STRINGER 28R. R&R DOUBLER IAW SRM & DRAWING.SDR SWAA2013070217855Doubler · corrodedOUTFLOW VALVE DOUBLER CORRODED AT BS 982, BETWEEN STRINGER 24R - STRINGER 25R R&R DOUBLER IAW SRM.SDR DALA1316106710Skin · dentedFUSELAGE SKIN DENTED, LT SIDE AT BS 215, STARTING 45 INCHES BELOW SKIN LAP SPLICE AND 8.5 INCHES LONG. REPAIRED IAW SRM 53-00-01, FIG 201, REPAIR 3.SDR SWAA2013062417506Skin · crackedRT BS 500B+10 LOWER AFT SKIN CUTOUT CRACKED AT HOLES 2,3,5. REPAIRED SKIN IAW EA.SDR SWAA2013062417505Skin · crackedRT BS 500A+10 LOWER AFT SKIN CUTOUT CRACKED AT HOLES 1,2,3,4,7. REPAIRED SKIN IAW EA.SDR SWAA2013062417504Skin · crackedRT BS 420+10 UPPER FORWARD SKIN CUTOUT CRACKED AT HOLES 6,7. REPAIRED SKIN IAW SWA EA.SDR SWAA2013061917375Skin · crackedLEFT PILOTS WINDSHIELD CUTOUT OTBD UPPER CORNER CRACKED IN SKIN. REPAIRED CUTOUT IAW SRM.SDR SWAA2013061817284Skin · crackedRT BS 520+10 LOWER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 2, 4, 6, 7, 11, 12. REPAIRED SKIN IAW EA.SDR SWAA2013061817283Skin · crackedRT BS 500C+10 LOWER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 1, 2, 3, 4, 5. REPAIRED SKIN IAW EA.SDR SWAA2013061817282Skin · crackedRIGHT BS 500C+10 UPPER FWD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW SB.SDR SWAA2013061817279Skin · crackedRT BS 500A+10 UPPER FWD WINDOW SKIN CUTOUT CRACKED AT HOLES 1,2,3,9. REPAIRED SKIN IAW SB.SDR R61A201305290537Skin · dentedDURING HEAVY CHECK, FOUND DENT OUTSIDE FUSELAGE RT SIDE AT BS 509.5, STRINGER 22. MX BLENDED GOUGE FOUND TO OUT OF LIMITS AND PERFORMED REPAIR IAW RD 8/4-53-5474 ISSUE 1. MAJOR REPAIR.SDR SWAA2013061016977Skin · corrodedFUSELAGE SKIN CORRODED BETWEEN STA 851 TO STA 870, BETWEEN LONG 28L TO LONG 30L. REPAIRED SKIN IAW SRM.SDR SWAA2013060716886Skin · crackedRT BS 400+10 LOWER AFT WINDOW CORNER HAS HFEC CRACKED INDICATION AT HOLES 2, 3, 6, 7. REPAIRED SKIN IAW SB.SDR SWAA2013060716885Skin · crackedRT BS 500+10 UPPER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLES 3,4. REPAIRED SKIN IAW SB.SDR DALA13026810950Doubler · corrodedCORROSION ON PRODUCTION DOUBLER BELOW VERTICAL WEB, STA 1338 BETWEEN LONG 28RT-28LT AT AFT CARGO COMPARTMENT. DUE TO EXCESIVE CORROSION ON PRODUCTION DOUBLER IT WAS REPLACED IAW DWG 9915561, REV CG AND SRM 51-30-2 AND 51-30-5.SDR SWAA2013060316720Skin · crackedAFT ENTRY DOOR FUSELAGE UPPER HINGE CUTOUT CRACKED AT UPPER CORNER. REPAIRED SKIN IAW SRM.SDR UALA2013053003754Fastener · looseLOOSE FASTENER ON LT FUSELAGE PANEL 197BB JUST AFT OF LT MAIN GEAR. PLACED ON DEFERRAL LOOSE SCREW ON PANEL 197BB, SECOND ROW 11 FROM TOP, REF 53-35-00, SEC 601. REPLACED LOOSE FASTENER ON LT FUSELAGE PANEL 197BB. FASTNER SECURED.SDR REXA2013053000681Skin · damagedDURING ROUTINE LINE MX AT MX FOUND LIGHTNING DAMAGE TO THE FUSELAGE SKIN IN THE AREA OF THE SKIN JOINT ON THE AFT SIDE OF FS755 BETWEEN S-25R AND S-26R. REPAIRED IAW EA CRJ253-01628 AND ASSOCIATED 8110-3.SDR ASAA2013052895227Skin · dentedDENT IN EXTERIOR FUSELAGE, LT SIDE, BS 1088, AND 3 INCHES BELOW STRINGER 13L. ACFT GROUNDED. COMPLIED WITH EA 400, 53EA 10546 REV NEW.SDR ASOA2013061903840Skin · burnedBURN BETWEEN FS409+32 AND FS 409+48 BETWEEN STR 22L AND STR 23L. REPAIRED IAW REO 601R-53-31-788. THIS REPAIR IS CLASSIFIED AS A MAJOR REPAIR IAW ASA SOP 5702.SDR ABXA20130528442Skin · dentedOUTWARD DENT STA 1654-1678 ABOVE S36L. DENT IS OUT OF LIMITS, REPAIRED IAW SRM 53-00-01 FIG 201, REPAIR 6, ACFT WAS GROUNDED.SDR ABXA20130528441Skin · dentedOUTWARD DENT, STA 1654-1678, S32R-S33R. DENT IS OUT OF LIMITS, REPAIRED IAW SRM 53-00-01, FIG 201, REPAIR 6; ACFT WAS OUT OF LIMITS AND GROUNDED.SDR DALA13026550991Skin · damagedDURING SCHEDULED CHECK, IT WAS NOTED THE UPPER FUSELAGE HAS EVIDENCE OF A LIGHTNING STRIKE BETWEEN LONGERON 8 AND 9R, BS 946. DAMAGE FOUND TO BE OUT OF LIMITS AND WAS REPAIRED IAW SRM 53-04-1, & 53-04-2.SDR DALA13026420926Skin · crackedFUSELAGE SKIN CRACKED AT BS 1437, BETWEEN LONGERON 2-3R, REPAIRED IAW ERA 515410-14, REV ORIGINAL.SDR DALA13026410926Skin · crackedFUSELAGE SKIN CRACKED AT BS 1437, BETWEEN LONGERON 2 - 3L. REPAIRED IAW ERA 515409-14, REV ORIGINAL.SDR DALA13026263128Skin · damagedREPORT DAMAGE BELOW AFT CARGO DOOR OPENING, ALSO NOTED DINGS AFT OF REAR CARGO DOOR. FOUND WITHIN LIMITS SRM 53-41-11, PG 125/126.SDR TSAA20130528006Skin · corrodedDURING ROUTINE VISUAL INSPECTION, CORROSION DAMAGE FOUND ON FUSELAGE SKIN LOCATED AT BS 435, SL1504. DAMAGE LENGTH IS 1.375", WIDTH IS .5", AND DEPTH IS .02".SDR DALA13025605642Skin · damagedON WALK AROUND FOUND 5.5" BY 2.5" DENT ON PREVIOUS PERMANENT REPAIR LOCATED 3 FEET FWD OF LT WING LIGHT 6 INCHES ABOVE FLOOR LEVEL. ER/A 515520-14 SECTION I ISSUED FOR A FUSELAGE SKIN REPAIR AT BS 600 TO 615, S16-17L.SDR DALA13025573218Skin · dentedDURING CURRENT M-CHECK, LT SIDE OF FWD FUSELAGE JUST AFT OF FR 21 AT STR 24L, SKIN IS DENTED AND IT WAS REPAIRED IAW SRM 53-11-11, FIG 212. DOUBLER REPAIR ACCOMPLISHED IAW SRM 53-11-11, FIG 212.SDR ASAA2013052894883Skin · dentedFUSELAGE DAMAGE AFT OF L2 DOOR BOTTOM CORNER. ACFT GROUNDED. REPAIRED FUSELAGE SKIN AFT OF L2 DOOR BOTTOM CORNER STA 1010, STR 15L IAW SRM 53-00-01-2R-35.SDR AALA20130528006Skin · crackedCRACK IN SKIN AT STATION 1309 ABOVE LONGERON 7 LT. CUT OUT CRACK AND INSTALLED TEMPORARY DOUBLER IAW SRM 53-04-02, FIG 2, SHEET 29 AND PARA 3.C. (1)(C).SDR FDEA201305271095Skin · damagedFUSELAGE SKIN BS 500 - 520 BETWEEN STR 26L AND 26R. HAS NICKS AND SCRATCHES. REPAIRED IAW SRM 53-00-01 FIG.201, REPAIR 16, REV.109. REPAIR IS CAT B MAJOR.SDR FDEA201305271094Skin · damagedFUSELAGE SKIN BS 580 -600, BETWEEN STR 26L AND STR 26R EXTERNAL SURFACE HAS NICKS AND SCRATCHES. REPAIRED IAW SRM 53-00-01, FIG 201, REPAIR 16, REV. 109. REPAIR IS CAT B, MAJOR.SDR FDEA201305271093Skin · damagedFUSELAGE SKIN BS 540 -560 BETWEEN STR 26L AND STR 26R EXTERIOR SURFACE, HAS NICKS AND SCRATCHES. REPAIRED IAW SRM 53-00-01, FIG 201, REPAIR 16, REV 109. REPAIR IS CAT B MAJOR.SDR UALA2013052803653Skin · damagedDURING C1 CHECK, MULTIPLE DAMAGE NOTED ON FUSELAGE SKIN FROM BS 740-860 BETWEEN S26L-16R. REMOVED DAMAGE & REPAIRED SKIN REF EA130454 & ECRA 5330-04598.SDR COEA2013070517900Skin · damagedHEAVY CHECK, WHILE PERFORMING DVI OF FRAME 26, FOUND EXTENSIVE TOOL DAMAGE ON SKIN FORWARD OF FR 26 BETWEEN STR 12 AND 13. REPAIR IAW SRAS.SDR ASAA2013052595408Skin · dentedLEFT FUSELAGE AT BS 228, SKIN HAS A PROTRUSION BELOW 24L. ACFT GROUNDED. C/W EA 400-53EA-10505, REV NEW DATE ISSUED 6-13-13.SDR ASAA2013052595122Skin · dentedRIGHT FUSELAGE AT BS 505 SKIN IS DENTED STRINGER 23R. REPAIRED SKIN IAW SRM 53-00-01-2R-31.SDR SWAA2013061017055Skin · corrodedFUSELAGE SKIN CORRODED AT STA 863, LONG 28L. R & R SKIN IAW SRM.SDR DALA1314340682Doubler · corrodedLOWER BILGE BS 1448, STR 29L SKIN FOUND CORRODED. REPLACED DOUBLER IAW SRM 53-00-01, FIG 201, REPAIR 2.SDR DALA13026360126Skin · bulgedEXTERNAL SKIN AT BS 1219, S38R FOUND BULGED. REPAIRED IAW SRM 51-10-02, 51-40-02.SDR REXA2013052500929Doubler · corrodedTCAS ANTENNA DOUBLER FWD LOWER FUSELAGE CORRODED. REPLACED TCAS ANTENNA DOUBLER IAW SRM 51/42/06, SM-74, A-68.SDR SWAA2013052816509Skin · crackedSKIN CRACKED AT BS 258, BETWEEN STR 20L AND STR 24L. REPAIR SKIN IAW EA.SDR DALA13024670952Skin · corrodedCORROSION ON FUSELAGE SKIN UNDER WING TO FUSELAGE FILLET FAIRING BS 763 BETWEEN LONG 27R-28R IN REF 663, ZONE 50. REF 334 ZONE 50. CORROSION ON FUSELAGE SKIN WAS REMOVED IAW SRM 51-10-3, PAR 26, WITH ORIGINAL THICKNESS IS 0.091" AND MINIMUM REMAINING THICKNESSDR CALA2013052700358Skin · dentedDENT WL 190, STATION 255 RT EXTERNAL FWD FUSELAGE DENT OUT OF LIMITS. REPAIRED IAW SRM 53-00-01, FIG 201, REPAIR 3.SDR SWAA2013070918052Skin · crackedAFT ENTRY DOOR FWD LOWER CORNER CUT OUT CRACKED AT BS 951.0+ 5.75, STRINGER 17L. REPAIRED SKIN IAW SRM.SDR UALA2013052803650Skin · puncturedFUSELAGE SKIN HAS A PUNCTURE AT BS 1675, S22 & 23R. FABRICATED DOUBLER IAW SRM 53-00-01, INSURANCE CUT IAW SRM 53-00-01, REPAIR S, STEP 4. TREATED AND PRIMED IAW SRM 51-20-01. INSTALLED REPAIR IAW 53-00-01 AND 51-40-02, REPAIR 3. MAJOR REPAIR.SDR SWAA2013070817994Skin · crackedFWD GALLEY DOOR AFT LOWER CORNER DOOR CUT OUT CRACKED AT BS 332.1, STRINGER 17R. REPAIRED SKIN IAW SRM.SDR ASOA2013060403755Skin · corrodedCORROSION WAS FOUND UNDER SELF-CONTOURING SEALING PAD FROM STR26 TO STR24, FROM 409+80 TO 409+400 ON BELLY SKIN. REPAIRED IAW SRM 51-21--06 AND REO 601R-53-31-789.
Back to JASC 5330