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 EE4Y100111Skin · delaminated((EE4Y)) LOWER FUSELAGE LT AIR CONDITIONING BAY DOOR INNER SKIN DELAMINATED AT STA 138.SDR SWAA103107Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND SKIN CRACKED AT BS 854, STR 24L. REPAIRED SKIN PER ER.SDR SWAA103103Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 372, STR 15L. REPAIRED SKIN PER EA.SDR FDEA201005271686Skin · gougedSKIN FOUND GOUGED AT LAP SEAM FWD OF STA 1300 S-20R. GOUGE FOUND OUT OF LIMITS IAW SRM 53-00-01 FIG 101 DET IV. ACCOMPLISHED EA F 5330-131194.SDR IPXA10560306Skin · damagedINSPECTION TYPE:C2, FOUND DRILL START IN SKIN AT STR 11, LT BS 1210. DRILLED OUT DAMAGE AT INSTALLED RIVET IN SKIN AT STR 11, LT BS 1210 IAW ER 10-2965.SDR SWAA103140Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED BETWEEN BS 372 TO BS 379, STR 15L. REPAIRED SKIN PER ER.SDR FDEA201005261673Skin · crackedNLG WHEEL WELL - LT FWD DOOR, WHEEL WELL CUTOUT SKIN FOUND CRACKED. REPAIR CARRIED OUT IAW SRM 53-50-00 FIG 25, VOLUME I, REVISION 96 AND EA 8-5350-139237, REPAIR CLASSIFIED AS MINOR IAW GMM 6-2-100, REV 110.SDR FDEA201005261665Skin · dentedFUSELAGE SKIN DENT, 2EA, AT BS 330, 2" BELOW S22R, ARE OUT OF LIMITS. (IN-PROCESS: REPAIR IS REQUIRED) EVALUATED UPPER DENT IAW SRM 53-00-01, FIG 101,DETAIL 3 AND FOUND TO BE W/I LIMITS ; A=.742",Y=.011",A/Y=67.45. EVALUATED LOWER DENT IAW SRM 53-00-01, FIG 1SDR DALA1011213354Skin · dentedDURING H-CHECK FOUND DENT IN LOWER FUSELAGE SKIN BETWEEN FR11 & FR11A APPROX 13 INCHES FROM STRINGER 30. REPAIRED IAW SRM 53-11-11 PARAGRAPH 5H.SDR EE4Y100104Skin · crackedLOWER EXTERNAL FUSELAGE AT BS 306 STRINGER 18R SKIN WITH CRACK.SDR DALA1014350179Skin · damagedDURING HMV, FOUND EXISTING REPAIR DOUBLER ON FUSELAGE SKIN BETWEEN STA 1439 AND STA 1461 S36R & S38R WITH SEVERAL FASTENER HOLES OUT OF ROUND ALONG WITH GOUGE AND SCRATCH MARKS ON SKIN AND STRINGER. REPAIRED IAW SRM AND ERA480441-14AD. (DL76L101603)SDR FDEA201005251651Skin · misrepairedEXISTING REPAIR ON FUSELAGE SKIN AT STA 715, LONGERON 29L EVALUATED AND FOUND PREVIOUSLY ACCOMPLISHED IAW SRM 53-20-00 FIG 13, VOLUME I, REV 96. HOWEVER, 08 EACH EXISTING BOLTS WERE FOUND PREVIOUSLY INSTALLED NOT IAW SRM. 08 EACH EXISTING BOLTS R & R WITH LOCSDR DALA1012900179Skin · unknownFUSELAGE SKIN REPAIR PREVIOUSLY INSTALLED ON 1-14-97 AT FS 1439-1461 AT STR 36R-38R WRITTEN UP ON AAI WAS REPLACED ON ERA 480441-14AD.SDR COEA2010052506917Skin · damagedHEAVY CK COE: MAJOR REPAIR: LT CREASE BEAM BETWEEN FR 13-14 FOUND DRILL STARTS ON INSIDE SURFACE OF EXTERNAL FUSELAGE SKIN BELOW STR 14LT. REMOVED DRILL STARTS IN AREA OF APPROXIMATE 1 X 3 INCH. FOUND BLENDED AREA OF SKIN TO BE OUT OF LIMITS. DOUBLER CUTOUSDR GLBA20100519HSkin · crackedMAJOR REPAIR - DURING ROUTINE SCHEDULED MAINTENANCE FOUND BELLY SKIN CRACKED AT FS 303.25 LEFT SIDE, 2.1" IN LENGTH, 2.25" INBOARD FROM SKIN EDGE. MAINTENANCE REPAIRED THE AFFECTED AREA AND PERFORMED ALL REQUIRED RII INSPECTIONS I.A.W. EO 10-1900-53-021. MATERSDR IPXA10B60061Skin · corrodedCORRISION AT FRAME 740 S-46L. REPAIRED IAW SRM 53-00-01 REPAIR 15, DETAIL 1,SDR DALA1011136301Skin · corrodedDURING L-CHECK FOUND CORROSION ON FUSELAGE SKIN AT RT AFT WASTE VACUUM EXHAUST BS 2080- BS 2100. REPAIRED IAW SRM 51-10-02 AND DWG 65B04153.SDR DALA1011146301Skin · corrodedDURING L CHECK FOUND CORROSION IN SKIN AT LT BS 1240 LBL106. REPAIRED IAW ERA480448-14AD SECTION I. SECTION II REQUIRES INSP PRIOR TO ACCUMULATION OF 20,000 TOTAL ACFT CYCLES OR 100,000 FLIGHT HOURS WHICHEVER COMES FIRST. THEREAFTER REPEAT INSP EVERY 8000 CYCLSDR C2XA10TY083Skin · chafedFUSELAGE SKIN IS CHAFED INSIDE RT PRE COOLER PYLON AREA PANEL 424DB. CUT OUT DAMAGE AREA, FABRICATED AND INSTALLED FILLER AND DOUBLER IAW EMB ETD 2010-145/04181.SDR QMLRMR0191Panel · puncturedACFT BONDED PANEL ON BELLY WAS PUNCTURED AND DENTED DURING GROUND HANDLING OF HELICOPTER WITH TUG-A-LUG. PERFORMED STRUCTURAL REPAIR ON (LT AFT BELLY) PANEL INSTALLATION PN 222-031-430-101 IAW MFG FIELD REPAIR NR 10RI-013 DATED 04/01/2010 UNDER STATEMENT OF SDR A6WA201040389Skin · damagedACFT STRUCK BY TUG ON TAIL ON RT SIDE BETWEEN VS 55.625-VS 67.50. REMOVED DAMAGED SKIN IN SECTION STR 13R AND BUTT SPLICE STRAP. REPAIRED IAW 601R-53-71-116.SDR A6WA201040388Skin · damagedMUSTIPLE DENTS, GOUGES AND TEARS IN FUSELAGE BELOW CARGO DOOR. DAMAGE IS ISOLATED TO SKIN. REMOVED DAMAGED SKIN, FABRICATED FILLER AND DOUBLER AND INSTALLED FILLER AND DOUBLER IAW REO 601R-53-61-3678.SDR SWAA103076Skin · crackedDURING SCHEDULED OTS, FOUND FUSELAGE SKIN CRACKED AT BS 504B, STR 4L. REPAIRED SKIN PER SRM.SDR IPXA10M60018Skin · dentedFUSE SKIN DENTED STA 1964. REPAIRED IAW EO MD11-5330-36005.SDR UIEA2010052400002Skin · damagedDAMAGE WAS FOUND TO THE 65B23701-6 FUSELAGE SKIN AT BS 550 BETWEEN S-31L AND -32L AFTER A BURST EQUIPMENT COOLING EXHAUST VALVE STRUCK THE S-31L STRINGER AND SKIN. REFER TO EO 4453A363 FOR THE STRINGER REPAIR. ACCOMPLISH PART 1 OF THIS EO PRIOR TO FURTHER FLIGSDR VGQY2010052400012Skin · bulgedFUSELAGE SKIN FOUND BULGING AT STA 2360 STR 34L - 42L. REMOVED BOLTS AND NUTS (TOTAL 8 EACH) AT STA 2360 BULKHEAD STR 34L TO STR 42L PER AMM 20-51-01 REV 90. HFEC INSPECTION CARRIED OUT IAW NDTPM D6-7170 REV 134 PART 6 51-00-00 FIG 23 ON BULGING SKIN. NO CRSDR SWAA103073Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 328 -2.5", STR 17R. REPAIRED SKIN PER ER.SDR FDKA2010052300121Skin · crackedLT RVSM FILLER PERM REPAIR IN WORK, COMPLY WITH RO EMB145-53-0254. MX C/W RVSM CRACK PERM REPAIR.SDR USAA2010052491012Skin · crackedCLT - MAJOR REPAIR - C6 CHECK - CRACKED EXTERNAL FUSELAGE SKIN, BS 727D +16 INCHES, S24R. REPAIRED EXTERNAL FUSELAGE SKIN, BS 727D +16 INCHES, S24R IAW B737 SRM 53-00-01 REPAIR 31.SDR USAA2010052491006Skin · crackedCLT - MAJOR REPAIR - C6 CHECK - CRACKED EXTERNAL FUSELAGE SKIN, BS 727F + 2 INCHES, S22R. REPAIRED EXTERNAL FUSELAGE SKIN, BS 727F + 2 INCHES, S22R IAW B737 SRM 53-00-01 REPAIR 31.SDR SWAA103063Skin · crackedDURING SCHEDULED 2HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 864 TO BS 867, STR 25R. REPAIRED SKIN PER SRM.SDR SWAA103049Skin · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 985.5+8.82 TO BS 1006, STR 5R. REPAIRED SKIN PER EO.SDR SWAA103046Doubler · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE SKIN DOUBLER CRACKED AT BS 847 TO BS 867, STR 4R. REPAIRED SKIN PER EA.SDR FDEA201005211604Skin · dentedDENT AT STA 1704 BETWEEN S-15L TO S16L. ACCOMPLISHED EA F-5330-131187. FUSELAGE PLATES/ SKIN DAMAGE TO AND NEAR EXISTING REPAIR BS 1701, BETWEEN S-14L AND 16L. THIS IS A CLASS "B" REPAIR, PRIOR TO ACFT REACHING 37,500 FC NEW 8100-9 WILL NEED TO BE ISSUED. MSDR UALA2010052101731Skin · damagedLT SIDE OF FUSELAGE DAMAGED. DAMAGE CAUSED IS A APPROX 5 FT LONG GOUGE APPROX 2FT FWD OF DOOR 2L. DAMAGE CAUSED BY RT FWD STANCHION ON CARGO KING. ACCOMPLISHED PERMANENT REPAIR IAW EVA-73780 ON OV WU K1222G.SDR FDEA201005201581Skin · unknownFUSELAGE EXTERIOR SKIN WITH EXISTING REPAIR DOUBLER AT BS 395 TO BS 418, BETWEEN STR 17R TO STR 19R. EXISTING REPAIR R & R IAW STA ENG EA 757-5311-08-E-0733, REV.A AND FEDEX EA F-5330-139347 (EXISTING FLUSH REPAIR BETWEEN BS 395-BS 414 AND S-17R -S-19R. DTE PESDR UIEA2010052000008Skin · corrodedCORROSION ON EXT FUSELAGE SKIN STA 1720 STR 45R-46R (CORROSION REMOVED IAW SRM 51-10-01. FOUND WITHIN ALLOWABLE DAMAGE LIMITS IAW SRM 53-30-01, FIG 1 AFTER CLEANUP AND AREA PROTECTED IAW SRM 51-10-02.)SDR EIAA2010028Skin · corrodedBS 1479 STR 14R-15R SKIN CORROSION. REMOVED CORROSION, FABBED AND INSTALLED REPAIR PER B747 SRM 53-30-03 FIG 47.SDR EIAA2010027Skin · corrodedR4 MED AFT CUTOUT BS 1719 STR 18-19R BS 1718 STR 22R-23R INTERIOR SKIN CORRODED. CORROSION REMOVED, FABBED AND INSTALLED REPAIR PER EA-53-1244.SDR EIAA2010025Skin · corrodedBS 1241 STR 7R-12R SKIN CORRODED. REMOVED CORROSION, FABBED AND INSTALLED REPAIR PER B747 SRM 53-30-03 FIG 47.SDR EIAA2010023Skin · damagedBULK CARGO DOOR FUSELAGE SKIN EXISTING REPAIR FOUND DEVIATION OF SB 747-53A2673, BS 2080 STR 31R, 32R, 33R. REMOVED EXISTING REPAIR, FABBED AND INSTALLED NEW REPAIR PER EA-53-1252 AND B747 SRM 53-30-03 FIG 1.SDR SWAA103021Skin · corrodedDURING SCHEDULED 16Y CHECK, FOUND SKIN CORRODED AT BS 527, STR 28R. REPAIRED SKIN PER EO.SDR SWAA103016Skin · corrodedDURING SCHEDULED 16Y CHECK, FOUND FWD CARGO COMPT BEAR STRAP SKIN CORRODED BETWEEN BS 500 TO BS 500A, BETWEEN STR 25R TO STR 26R. REPAIRED SKIN PER EO.SDR SWAA103015Skin · corrodedDURING SCHEDULED 16Y CHECK, FOUND FWD CARGO COMPT BEAR STRAP SKIN CORRODED BETWEEN BS 492 TO BS 500, BETWEEN STR 26R TO STR 27R. REPAIRED SKIN PER EO.SDR SWAA103014Skin · crackedDURING SCHEDULED 16Y CHECK, FOUND SKIN CRACKED BETWEEN BS 787 TO BS 807, STR 4L. REPAIRED SKIN PER AEM.SDR SWAA103013Skin · crackedDURING SCHEDULED 16Y CHECK, FOUND SKIN CRACKED BETWEEN BS 727E TO BS 747, STR 4R. REPAIRED SKIN PER AEM.SDR SWAA103012Skin · crackedDURING SCHEDULED 16Y CHECK, FOUND SKIN CRACKED BETWEEN BS 767 TO BS 787, STR 4R. REPAIRED SKIN PER AEM.SDR SWAA103011Skin · crackedDURING SCHEDULED 16Y CHECK, FOUND SKIN CRACKED BETWEEN BS 907 TO BS 927, STR 10R. REPAIRED SKIN PER AEM.SDR SWAA102984Skin · crackedDURING SCHEDULED CV CHECK, FOUND SKIN CRACKED AT BS 735E, STR 4R. REPAIRED SKIN PER EA.SDR SWAA102983Skin · crackedDURING SCHEDULED CV CHECK, FOUND SKIN CRACKED AT BS 736B, STR 4R. REPAIRED SKIN PER EA.
Back to JASC 5330