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 SWAA2012092507944Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 847+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012092507943Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 787+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012091007465Skin · crackedFUSELAGE SKIN CRACKED AT BS 907+13, STR 21L. REPAIRED SKIN IAW AMM.SDR SWAA2012091007464Skin · crackedFUSELAGE SKIN CRACKED AT BS 787+13, STR 22L. REMOVED AND REPLACED SKIN IAW SRM & AMM.SDR USAA2012091000029Skin · crackedQ6 CHECK - CRACK IN FUSELAGE SKIN AT BS 800, S19L. REPAIRED FUSELAGE SKIN AT BS 800, S19L IAW B737 SRM 53-00-01-2R-31.SDR DALA12006600993Doubler · corrodedRADIO ALTIMETER INTERIOR DOUBLER CORRODED BS 598 BETWEEN LONGERON 30 AND 29R. REMOVED CORRODED DOUBLER AND DRILLED NEW ONE. TREATED AND PRIMED. INSTALLED NEW DOUBLER PER SRM 51-30.SDR UALA2012090504996Paint · peelingRIGHT SIDE RVSM AREA BY F/O HAS LARGE SECTION OF PAINT ABOUT SIZE OF SILVER DOLLAR MISSING. REMOVED PEELING PAINT AT FWD EDGE OF EXTRA CRITICAL AREA, APPROX 3" X 2.25" IN GOLD STRIPE. DEPTH OF MISSING PAINT IS .005", SKIN WAVINESS CHECK GOOD. REPRED PAINT RSDR SWAA2012091007463Skin · crackedFUSELAGE SKIN CRACKED AT BS 931, STR 25R. REPAIRED SKIN IAW SRM & AMM.SDR SWAA2012091007462Skin · crackedFUSELAGE SKIN CRACKED AT BS 875, BETWEEN STR 24L TO STR 25L. REPAIRED SKIN IAW SRM & AMM.SDR USAA2012091000028Skin · crackedQ6 CHECK - CRACK ON FUSELAGE SKIN AT BS 727D+19 INCHES & 0.5 INCHES ABOVE S24L. REPAIRED FUSELAGE SKIN AT BS 727D+19 INCHES & 0.5 INCHES ABOVE S24L IAW B737 SRM 53-00-01-2R-31.SDR SWAA2012090607395Skin · crackedLEFT OVERWING EMERGENCY EXIT UPPER CUTOUT CRACKED AT BS 616+6. REPAIRED SKIN PER EA.SDR DALA1247941521Skin · corrodedSKIN BULGED AFT OF AFT LAV SERVICE PANEL BOTTOM CENTER FUSELAGE. COMPLIED WITH PERMANENT REPAIR PER ERA 506773-14 REV ORIG REF NRC 007.SDR UALA2012090404966Skin · corrodedLEFT LAV TANK EXHAUST VENT CUTOUT SKIN IS CORRODED AND CRACKED APPROX .5 INCH LOWER EDGE. GAINED ACCESS, REMOVED VENT NOZZLE ASSY, STARTED REMOVING INNER DOUBLER REF AVO 1408. REMOVED DAMAGE, MANUFACTURED REPAIR PIECES, STARTED INSTALLATION. REPAIRED LEFT LSDR DALA1247770932Skin · crackedDURING HMV, A CRACK WAS FOUND ON FUSELAGE SKIN LOCATED ON FWD UPPER CORNER AT FWD CARGO COMPARTMENT DOOR CUTOUT BTW STA Y=374.5 AND LONGERONS 20-21 RT. DUE TO EXISTING REPAIR IN CLOSE PROXIMITY SKIN STA Y=323-404 AND BETWEEN LONGERON 18-22 RT WAS REMOVED AND SDR UALA2012090404941Skin · dentedRAMP REPORTS DENT AT LEFT FUSE AT STA 755 BET STR 15L + 16L. AFT OF DOOR 2L. MEASUREMENTS ARE 1.5\ WIDTH X 1.75\ LENGTH, .070\ DEEP. A-Y=21.4 CONT OF AMIS ITEM 0672022. ACP A INTERIM REPAIR BURNISH OUT ALL SHARP EDGES AND DENT IS SMOOTH AND FREE FROM SHARP CSDR AALA20120913018Skin · corrodedCORROSION ON FUSELAGE SKIN FROM STATIONS 1064 TO 1088, STRINGERS 20 TO 22. ACCOMPLISHED CORROSION REMOVAL PER EA B737-53-025949.SDR AALA20120913017Skin · corrodedCORROSION ON FUSELAGE SKIN FROM STATIONS 1016 TO 1040, STRINGERS 20 TO 23. ACCOMPLISHED CORROSION REMOVAL PER EA B737-53-025949.SDR AALA20120913016Skin · corrodedCORROSION ON FUSELAGE SKIN FROM STATIONS 987 TO 1016, STRINGERS 21 TO 23. ACCOMPLISHED CORROSION REMOVAL PER EA B737-53-025949.SDR AALA20120913014Skin · corrodedCORROSION ON FUSELAGE SKIN FROM STATIONS 967 TO 987, STRINGERS 21 TO 23. ACCOMPLISHED CORROSION REMOVAL PER EA B737-53-025949.SDR AALA20120913013Skin · corrodedCORROSION ON FUSELAGE SKIN FROM STATIONS 947 TO 967, STRINGERS 21 TO 23. ACCOMPLISHED CORROSION REMOVAL PER EA B737-53-025949.SDR AALA20120913012Skin · corrodedCORROSION ON FUSELAGE SKIN FROM STATIONS 927 TO 947, STRINGERS 21 TO 23. ACCOMPLISHED CORROSION REMOVAL PER EA B737-53-025949.SDR AALA20120913011Skin · corrodedCORROSION ON FUSELAGE SKIN FROM STATIONS 907 TO 927, STRINGERS 24 TO 25. ACCOMPLISHED CORROSION REMOVAL PER EA B737-53-025949.SDR AALA20120907003Skin · corrodedCORROSION ON FUSELAGE SKIN FROM STATIONS 907 TO 927, STRINGERS 21 TO 22. ACCOMPLISHED CORROSION REMOVAL PER EA B737-53-025949.SDR AALA20120912012Skin · corrodedCORROSION ON FUSELAGE SKIN FROM STATIONS 907 TO 927 AT STRINGERS 22 TO 24. ACCOMPLISHED CORROSION REMOVAL PER EA B737-53-025949.SDR IPXA2675122Doubler · damagedDOUBLER DAMAGED AT BS 450. REPAIR IAW EO B767-5330-48402-A.SDR UALA2012090404932Skin · dentedSKIN DENTED BETWEEN FRAMES 22-23 AND S22-23L REPAIR ACCOMPLISHED IAW SRM 53-11-11 FIG 212.SDR SWAA2012090407249Skin · crackedFUSELAGE SKIN CRACKED AT BS 727E +8, STR 4R. REPAIRED SKIN PER EA.SDR DALA1247640932Skin · damagedDURING HMV, SCRATCHES WERE FOUND ON RT WINDOW BELT AFT EDGE UPPER CORNER BTW Y=712-731. AREA WAS BLENDED OUT AND REPAIRED IAW ERA 504399-14 REV ORIG.SDR DALA1247630932Skin · damagedDURING HMV, SCRATCHES WERE FOUND AROUND RT WINDOW BELT FWD UPPER AND LOWER CORNERS ALSO AFT UPPER AND LOWER CORNERS STAY=769-788. AREA WAS BLENDED OUT AND REPAIRED IAW ERA 504393-14 REV ORIGAND ER/A 504399-14 REV ORIG.SDR DALA1247610932Skin · damagedDURING HMV SCRATCHES WERE FOUND ON RT WINDOW BELT UPPER AFT CORNER BTW BS 807-826. BLENDED DAMAGE AREA AND REPAIRED IAW ER/A 504399-14 REV ORIG.SDR DALA1247590932Skin · damagedDURING HMV SCRATCHES WERE FOUND AROUND RT WINDOW BELT FWD UPPER AND LOWER CORNERS. ALSO, AFT UPPER AND LOWER CORNERS BS 788-807. SRATCHES WERE BLENDED OUT AND REPAIRED IAW ER/A 504399-14 REV ORIG.SDR AALA20120831007Skin · corrodedCORROSION ON INTERNAL SKIN FROM STATIONS 750 TO 760 AT LONGERONS 30 TO 29 LEFT AND RIGHT. INSTALLED DOUBLER PER SRM 53-04-03 FIGURE 11 SHEET 1 VIEW A.SDR R61A201208300457Doubler · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE WASTE BOX DOUBLER HAS CORROSION STRINGER 28R BETWEEN FRAME 88 AND 89. MAINTENANCE REMOVED AND REPLACED THE WASTE BOX DOUBLER IAW EMB 170 SRM 51-21-00, 51-41-00, AND 51-43-00. THE AIRCRAFT IS OUT OF SERVSDR SWAA2012090407248Skin · crackedFUSELAGE SKIN CRACKED AT BS 500D+5, STR 8L. REPAIRED SKIN PER EA.SDR AALA20120830003Skin · damagedFOUND RIVET SET DAMAGE TO OUTER FUSELAGE SKIN AT STA 727G PLUS 4 BETWEEN STRINGERS 27R AND 27L. INSTALLED EXTERNAL DOUBLER REPAIR PER SRM 53-00-01-2R 3.SDR USAA2012083100010Skin · crackedB CHECK - CRACK FUSELAGE SKIN AT BS 727E +7 INCHES, S24L. REPAIRED FUSELAGE SKIN AT BS 727E +7 INCHES, S24L IAW B737-300 SRM 53-00-01-2R-31.SDR USAA2012083100009Skin · crackedB CHECK - CRACK FUSELAGE SKIN AT BS 727E +13 INCHES, S23L. REPAIRED FUSELAGE SKIN AT BS 727E +13 INCHES, S23L IAW B737-30 SRM 53-00-01, REPAIR 31.SDR USAA2012083100008Skin · crackedB CHECK - CRACK FUSELAGE SKIN AT BS 727 +7 INCHES, S23L. REPAIRED FUSELAGE SKIN AT BS 727 +7 INCHES, S23L IAW B737-300 SRM 53-00-01-2R-31.SDR KCSA201208301192Skin · damagedBS 1994 - 2000 STR 47L - 50L EXTERIOR SKIN HAS CORROSION.SDR ASOA20120830090Skin · crackedDURING C-CHECK, CRACK AROUND RIVET FRAME 75, STRINGER 2L-3L VERIFIED WITH EDDY CURRENT. MX PERFORMED REPAIR BY INSTALLING FABRICATED REPAIR DOUBLER AND FILLER AT FRAME 75 BETWEEN STRINGER 2L-3L IAW EC5330-02313. THE ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR ASOA20120830081VSkin · corrodedDURING C-CHECK UNDER FLOOR SKIN BTWN FRAME 11 AND 12 STR 21R-20R HAS CORROSION (LOCAL LEVEL 2). MX PERFORMED REPAIR TO SKIN FRAME 11-12 STR 21R-20R IAW EC5320-01681. THE ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR SWAA2012100108165Skin · corrodedSKIN CORRODED AT BS 520, BETWEEN STR 27R AND STR 28R. REPAIRED SKIN IAW EO AND EA.SDR ASOA2012092402271Doubler · corrodedTCAS ANTENNA INTERNAL DOUBLER CORRODED AT CONNECTOR FS 303.00, STGR27. FOUND TCAS ANT DOUBLER EXFOLIATED. REMOVED CORRODED TCAS ANTENNA DOUBLER, LOCATED, DRILLED AND INSTALLED NEW SERVICABLE TCAS ANTENNA INTERNAL DOUBLER IAW SRM 51-42-06-001-001-A01. FOUND SDR SWAA2012092107830Skin · crackedSKIN CRACKED AT BS 1156+5, RBL 3. REPAIRED SKIN IAW SRM.SDR 29GA95553082912Skin · corrodedDURING SCHEDULE ROUTINE MAINTENANCE DISCOVERED EXFOLIATION ON OUTER BELLY SKIN BETWEEN STRINGER 14L AND 15L AT FS 318.25. REMOVED DAMAGED AREA AND INSTALLED EXTERNAL REPAIR DOUBLER.SDR SWAA2012090607408Skin · crackedSKIN FUSELAGE CRACKED BETWEEN BS 979 TO BS 982, STR 21L. REPAIRED SKIN IAW ER AND EA.SDR SWAA2012090407333Skin · crackedFUSELAGE SKIN CRACKED AT BS 827+9, STR 4L. REPAIRED SKIN PER EA.SDR SWAA2012090407313Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 979 TO BS 982, STR 21L. REPAIRED SKIN PER SRM.SDR USAA2012090400003Skin · crackedC6 CHECK - CRACK IN FUSELAGE SKIN AT BS 882 APPROX 1 INCH ABOVE S25R. REMOVED DAMAGE, FABRICATED AND INSTALLED TEAR STRAP, FILLERS AND DOUBLER IAW B737 SRM 53-00-01-2R-31, DETAIL XIX.SDR USAA2012083100012Skin · crackedB-CHECK - CRACK IN FUSELAGE SKIN AT BS 727E+6 INCHES, S23L. REPAIRED FUSELAGE SKIN AT BS 727E+6 INCHES, S23L IAW SRM 53-00-01-2R REPAIR 31.
Back to JASC 5330