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 SWAA120018Skin · crackedDURING SCHEDULED OTS CHECK FOUND, SKIN CRACKED AT BS 867+10, STR 4R. REPAIRED SKIN IAW EA.SDR SWAA120017Skin · crackedDURING SCHEDULED OTS CHECK FOUND, SKIN CRACKED AT BS 827+8, STR 2R. REPAIRED SKIN IAW EA.SDR SWAA120016Skin · crackedDURING SCHEDULED OTS CHECK FOUND, SKIN CRACKED AT BS 727A+11, STR 4R. REPAIRED SKIN IAW EA.SDR SWAA120014Skin · crackedDURING SCHEDULED SPV CHECK FOUND, LT FUSELAGE WINDOW SKIN CRACKED AT BS 807+10, UPPER AFT CORNER. REPAIRED SKIN IAW SB.SDR SWAA120013Skin · crackedDURING SCHEDULED SPV CHECK FOUND, LT FUSELAGE WINDOW SKIN CRACKED AT BS 827+10, UPPER AFT CORNER. REPAIRED SKIN IAW SB.SDR SWAA120012Skin · crackedDURING SCHEDULED SPV CHECK FOUND, LT FUSELAGE WINDOW SKIN CRACKED AT BS 827+10, LOWER FORWARD CORNER. REPAIRED SKIN IAW SB.SDR SWAA120011Skin · crackedDURING SCHEDULED SPV CHECK FOUND, LT FUSELAGE WINDOW SKIN CRACKED AT BS 807+10, LOWER FORWARD CORNER. REPAIRED SKIN IAW SB.SDR COMA2012010390001Skin · puncturedRT FWD FUSELAGE SKIN PUNCTURED AT FS 220.00. REMOVED AND REPLACED RT FWD SKIN PANEL IAW SRM 51-21-11, 51-25-16, 51-40-11, 51-42-06, 51-42-21, 51-42-22, 51-23-00, BOMBARDIER DWG CC670-33020 AND REO 690-53-11-355.SDR DALA1202810696Doubler · defectiveEXITING DOUBLER ON FUSELAGE NOT CONTOURED TO A/C SKIN STA 1610-1620 STR STR 17-18L. REMOVED EXISTING REPAIR DOUBLER ON FUSELAGE SKIN STA 1610-1620 STR 17-18L IAW B757 SRM 51-40-02 FIG 8 DETAIL I. FABRICATED REPAIR DOUBLER IAW B757 SRM 53-00-01 FIG 201 REPAIRSDR DALA1203970973Skin · dentedDENT ON FUSELAGE SKIN ON TOP OF FRAME AT STA 237 BETWEEN LONGERON 18L AND 19L. MEASURED DENT ON SKIN, FOUND DENT WITH CREASE, REMOVED DAMAGED AREA AT STA 237 BETWEEN LONG 18-19L, FABRICATED REPAIR PARTS AND INSTALLED IAW DC9/MD80 SRM 53-04 DURING MAINTENANCE SDR DALA1203960973Doubler · dentedTWO DENT ON REPAIR DOUBLER ON FUSELAGE SKIN BETWEEN STA 210 AND 229 AND BETWEEN 1, 6 AND 18L. REMOVED REPAIR DOUBLER, FABRICATED AND INSTALLED NEW REPAIR DOUBLER IAW DC9/MD80 SRM 53-04 DURING MAINTENANCE VISIT.SDR USAA2012010300041Skin · crackedQ6 CHECK - 2.75 INCH LONG CRACK IN FUSELAGE SKIN AT STA 727F+6, S22L. REPAIRED FUSELAGE SKIN AT STA 727F+6, S22L IAW B737 SRM 53-00-01-2R-31 DETAIL XI.SDR UALA2012120407046Skin · damagedEXTERNAL FUSELAGE SKIN CREASED BETWEEN BS 1380 TO 1400 AND STR 27R-28R. REMOVED DAMAGED SKIN AND FABRICATED A REPAIR DOUBLER, STRUCTURAL FILLER, AND FILLER AND INSTALLED BETWEEN BS 1380 TO 1390 AND AFT CARGO DOOR FORWARD LOWER CORNER OF CUTOUT PER REO G14379,SDR FDEA201112295455Skin · dentedDENT ON EXTERIOR SKIN AT BS 1690 AT STRINGER 16-17R. DENT REPAIR CARRIED OUT AS PER E.A. F-5330-154485. REPAIR IS CLASSIFIED AS MAJOR.SDR UALA2011122907154Skin · damagedEXTERNAL FUSELAGE SKIN CREASED BETWEEN BS 1380 TO 1400 AND STR 27-28R. MAJOR REPAIR ACCOMPLISHED. REMOVED DAMAGED SKIN AND FABRICATED A REPAIR DOUBLER, STRUCTURAL FILLER, AND FILLER AND INSTALLED PER REO G14379, REV. C.SDR USAA2011123000018Skin · crackedRON CHECK - FUSELAGE SKIN CRACKED AT BS 747+13 INCHES, S19L. REPAIRED FUSELAGE SKIN AT BS 747+13 INCHES, S19L IAW B737 SRM 53-00-01 REPAIR 31.SDR JR2R2011122900694Skin · chafedAFT FUSELAGE CHAFED AT CENTERLINE AND FS 970. REMOVED CHAFE AND COMPLETED MOD SUM IS670538200021IAW RO CRJ7-53-0492.SDR JR2R2011122900688Skin · damaged2 EA LIGHTNING STRIKES AT LT FWD FUSELAGE FS 212 AND 236. REPAIRED IAW RO CRJ9-53-0923.SDR AALA20111228AFW01Skin · damagedSTATION 271 BETWEEN STRINGERS 21 AND 22 RIGHT DAMAGED. ACCOMPLISHED DOUBLER REPAIR PER SRM 53-00-01-2R6.SDR USAA2012010500013Skin · crackedFPBH INSPECTION - CRACK ON FUSELAGE SKIN OF L1 DOOR CUTOUT UPPER HINGE AT BS 312, S12L, WL 259. REPAIRED SKIN OF L1 DOOR CUTOUT UPPER HINGE AT BS 312, S12L, WL 259 IAW B737-400 SRM 53-10-01.SDR UALA2011122807139Skin · dentedFUSELAGE SKIN DENTED BS 440, S25 - 26R. FOUND DENT OUT OF LIMITS. CUT-OUT DAMAGED AREA, INSTALLED DOUBLER AND FILLER IAW SRM.SDR IPXA2B70898Skin · dentedINSPECTION TYPE:2C, BLENDED DENT LOCATED APPROX 3" BEHIND TAIL STAND FITTING - STA 2600, STR 42R-26R. REPAIRED IAW HX RS R53-81-37286 REV A AND EO B747-5330-45559-A.SDR USAA2011122900001Skin · crackedRON VISIT - 2 CRACKS IN FUSELAGE SKIN AT BS 500D+16 S-12L & BS 500D+15 S-12L. REPAIRED FUSELAGE SKIN AT BS 500D+16 S-12L & BS 500D+15 S-12L IAW EA 103584.SDR SWAA118700Skin · crackedDURING SCHEDULED RON CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 727E+6, STR 4R. REPAIRED SKIN PER EA & SRM.SDR SWAA118701Skin · crackedDURING SCHEDULED RON CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 807 TO BS 827, STR 4R. REPAIRED SKIN PER EA & SRM.SDR A6WA201240206Skin · crackedRIGHT LOWER SKIN NOSE WHEEL CUTOUT AT CORNER IS CRACKED. C/W REO 601R-53-11-048, REV B.SDR USAA2011122700021Skin · crackedRON VISIT - CRACK IN FUSELAGE SKIN AT BS 760 APPROX 1 INCH ABOVE S19L. REPAIRED BS 760 APPROX 1 INCH ABOVE S19L IAW B737 SRM 53-00-01-2R-31 DETAIL XI.SDR USAA2011122700020Skin · crackedRON VISIT - CRACK IN FUSELAGE SKIN AT BS 727D+5.5 INCHES, S19L. REPAIRED FUSELAGE SKIN AT BS 727D+5.5 INCHES, S19L IAW B737 SRM 53-00-01 REPAIR 31 DETAIL XI.SDR NSVA2011363Skin · corrodedCORROSION ON RT FUSELAGE SKIN JUST ABOVE WINDOW DOUBLER EDGE AT SL1607 FROM STA 583 TO 595.5 REFER TO SAAB STATEMENT 340SDS023472 PARA 1, DATED 12-16-2011, TD 340-53-11-06 AND MM409#406977 FOR REPAIR DETAILS UNDER CONTROL # 202-33 AREA 2.SDR NSVA2011362Skin · corrodedCORROSION ON RT FUSELAGE SKIN JUST ABOVE WINDOW DOUBLER EDGE AT SL1607 FROM STA 565.5 TO 621.5 REFER TO SAAB STATEMENT 340SDS023472 PARA 1 DATED 12-16-2011, TD 340-53-11-06 AND MM409#406977 FOR REPAIR DETAILS UNDER CONTROL # 202-33.SDR NSVA2011358Skin · corrodedFUSELAGE SKIN UNDER RT ICE SHIELD NR 8 HAS 15 SMALL AREAS OF PITTING CORROSION AND 1 SMALL AREA OF PITTING CORROSION UNDER ICE SHIELD NR 7. REFER TO SAAB STATEMENT 340SDS023481, PARA 1 DATED 12-16-2011, TD 3450-53-11-05 AND MM409#406963 UNDER CONTROL #202-24 SDR DALA1170870929Skin · corrodedDURING HMV CORROSION WAS FOUND ON FUSELAGE SKIN PREVIOUS REPAIR TRIPLER AT WING FILLET PANELS RUBSTRIP SETTLEMENT AREA STA Y=757-775 BETWEEN LONGERON 26RT-23RT. REF SRM 53-04D FIG 53 FOR REPAIR.SDR DALA1170880929Finger Doubler · corrodedDURING HMV CORROSION WAS FOUND ON PRODUCTION FINGER DOUBLERS FROM STA Y=229-250 LONGERON 26RH, ALSO FROM STA Y=229-265 26LT REF SRM 53-04D FIG 12C FOR REPAIR.SDR R61A20110443Doubler · corrodedWHILE A/C WAS IN FOR HEAVY CHECK FOUND SKIN DOUBLER UNDER WASTE BOX CORRODED BETWEEN FRS 88-89 AND STR 28R-25R. MX REMOVED AND REPLACED INTERNAL SKIN DOUBLER IAW EMB 170 SRM 51-41-02, 51-43-02. P/N 170-66931-001. A/C REMAINS IN CMH FOR HEAVY CHECK COMPLETIOSDR USAA2011122800025Skin · crackedCDFI VISIT - CRACK IN FUSELAGE SKIN AT BS 178, WL 218, LBL 5.7. REPAIRED FUSELAGE SKIN AT BS 178, WL 218, LBL 5.7 IAW B737 SRM 53-08-2R-9.SDR SWAA118705Skin · crackedDURING SCHEDULED RON FOUND, FUSELAGE SKIN CRACKED AT BS 727B+10, STR 4R. REPAIRED SKIN PER EA.SDR COEA2011122353801Skin Panel · corrodedHEAVY CK COE / MAJOR REPAIR / LEVEL 2 CORROSION: UPPER EXTERNAL SKIN UNDER ADF ANTENNA HAS CORROSION (LENGTH, 9.0", WIDTH 18.0", DEPTH .012"). FOUND CORROSION AND DEEP GOUGES ON EXTERNAL SKIN UNDER ADF ANTENNA, BLENDED DAMAGE AND REMOVED CORROSION FROM EXTERNSDR JR2R2011122300675Skin · damagedGALLEY SERVICE DOOR HAS 1 EA RIVET WITH LIGHTNING DAMAGE. REPLACED RIVET IAW SRM.SDR JR2R2011122300674Skin · damagedLIGHTING STRIKE DAMAGE ON RIVETS BETWEEN FS 312 AND 318 BETWEEN STRINGER 22R AND 23R. REPLACED RIVETS IAW SRM.SDR JR2R2011122300673Skin · damagedLIGHTING STRIKE DAMAGE ON RIVETS BETWEEN FS 409 AND 442 BETWEEN STRINGER 22R AND 23R. REPLACED RIVETS IAW SRM.SDR JR2R2011122300672Skin · damagedLIGHTING STRIKE DAMAGE ON RIVETS BETWEEN FS 572 AND 661 BETWEEN STRINGER 19R AND 20R. REPLACED RIVETS IAW SRM.SDR JR2R2011122300670Skin · damagedLIGHTNING STRIKE DAMAGE AT AFT EDGE OF RT NLG DOOR CUTOUT. REPAIRED IAW SRM 53-00-00.SDR JR2R2011122300669Skin · damagedLIGHTNING STRIKE DAMAGE AT LT SIDE OF NOSE RADOME FS 202. REPAIRED IAW SRM 53-00-00.SDR JR2R2011122300668Skin · corrodedLIGHTNING STRIKE DAMAGE AT LWR FWD CORNER OF FORWARD TOILET SERVICE DOOR. REPAIRED IAW SRM 53-00-00.SDR JR2R2011122300667Skin · corrodedLIGHTNING STRIKE DAMAGE NEXT TO POTABLE WATER SERVICE DOOR. REPAIRED IAW SRM 53-00-00.SDR USAA2012011700006Skin · corroded2S CHECK - LEVEL 2 EXFOLIATION CORROSION ON FUSELAGE SKIN BETWEEN FR63 TO FR64, S41L. REPAIRED FUSELAGE SKIN BETWEEN FR63 TO FR64, S41L IAW EA 201629.SDR DALA1171233316Skin · damagedFOUND SKIN DAMAGED 2 INCHES IN DIAMETER, BELOW STRINGER 38R AND 2 INCHES AFT OF FRAME 57. REPAIRED DAMAGE AS PER A330 SRM 53-00-11 FIGURE 224 AND 225. RII INSPECTED, REPAIR INSPECTED, REPAIR OR FOR REPETITIVE INSPECTION. 256445 HNL.SDR SWAA118664Skin · crackedDURING SCHEDULED OTS CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 781, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA118663Skin · crackedDURING SCHEDULED OTS CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 847+ 51/2, STR 24L. REPAIRED SKIN PER SRM.SDR SWAA118666Bear Strap · corrodedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN BEAR STRAP CORRODED AT BS 967, STR 26R TO STR 27L. REPAIRED BEAR STRAP PER EA.
Back to JASC 5330