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 DALA1219540930Skin · corrodedDURING HMV CORROSION WAS FOUND ON FILLET PANEL RUBSTRIP FUSELAGE SKIN FRON STA Y=864 TO 927 ALSO Y=927 TO 1003 LONG 18RT REF MD88 SRM 53-04D PARA 57 FOR REPAIR.SDR REXA2012033000378Skin · damagedAIRCRAFT WAS HIT BY A JET BRIDGE IN DTW, RESULTING IN SKIN DAMAGE BETWEEN FS 250 AND FS 265 BELOW THE PRODUCTION SKIN BUTT SPLICE AT S-16L. REPAIRED IAW EA CRJ253-00448B AS APPROVED BY ASSOCIATED 8110-3 DATED MARCH 29, 2012.SDR UALA2012032901979Skin · dentedEXTERNAL FUSELAGE DENTED AT BS 1413 AT STRINGER 34L & 34R. MAJOR REPAIR ACCOMPLISHED: TRIMMED OUT DAMAGE & ACP HFEC. NO CRACKS FOUND. ACP INSURANCE CUT. HFEC OPEN HOLES COMMON TO SKIN REPAIR. FABRICATED & INSTALLED EXTERNAL FILLER, DOUBLER & TRIPLER REPASDR UALA2012032901978Skin · damagedFUSELAGE SKIN AND STRINGER DAMAGED STA 1720-1740 AT S-15AL REF SCAL LP 9963950, 9964047. MAJOR REPAIR ACCOMPLISHED: INSTALLED FUSELAGE SKIN AND STRINGER REPAIRS IN REF TO SCAL ECRA 5300-01411 SEE SCAL LP 9963950, 9964047 FOR ALL REPAIR WORK PERFORMED.SDR HEEA201203293415Skin · corrodedAFT LOWER SKIN ASSY WAS FOUND TO BE CORRODED.SDR FDEA201203291191Skin · gougedDAMAGE FOUND UNDER PANEL 196ER APPROX RT BS1300-1350 ON SKIN. REWORKED IAW EA F-5330-157914 . NDT PERFORMED, NO DEFECTS APPARENT.SDR FDEA201203291190Skin · gougedDAMAGE FOUND ON SKIN PANEL 195DL APPROX BS 1240-1300. REWORKED IAW EA F5330-157913 NDT INSPECTION CARRIED OUT, NO DEFECTS APPARENT.SDR FDEA201203291189Skin · gougedDAMAGE FOUND ON SKIN PANEL 192AR APPROX RT BS 740-760. REWORKED ON EA F-5330-157912. NDT CARRIED OUT, NO DEFECTS APPARENT.SDR FDEA201203291186Skin · gougedDAMAGE FOUND UNDER WTB PANEL 192BR APPROX RT BS 760-820. . REWORKED ON EA F-5330-157912. NDT CARRIED OUT WITH NO DEFECTS APPARENT.SDR DALA1256161504Skin · damagedFUSELAGE SKIN FS 478 ABOVE STR 26L, FS 654+88 ABOVE STR 21L, FS 654 + 121 STR 19L LIGHTNING STRIKES ON FASTENERS REPAIR IAW ERA 492052-14.SDR DALA1229910931Skin · crackedCRACKS UPPER CORNER OF FWD CARGO DOOR CUTOUT. DOUBLER REPAIR ACCOMPLISHED IAW ER/A 502190-14AD REV ORIG.SDR SWAA2012050403699Skin · crackedSKIN CRACKED BETWEEN BS 764 TO BS 765.25, STR 19L. REPAIRED SKIN PER SRM.SDR IPXA2573142Skin · gougedINSPECTION TYPE: C, ACFT DAMAGE, GOUGE FROM STR 13L TO STR 19L AT BS 1633. EXTERIOR SKIN REPAIRED IAW EA 120481 IR DATED 04/18/12 AND EO B757-5330-46742-A.SDR SWAA2012041903246Skin · gougedFUSELAGE SKIN STA 420 STR 8L HAS EXISTING GOUGE. REPAIRED EA.SDR SWAA2012040902937Skin · corrodedSKIN CORRODED BS 500+8, BL 0. REPAIRED SKIN IAW SRM AND DWG.SDR SWAA2012040902936Skin · corrodedSKIN CORRODED AT BS 500A+12, BL 0. REPAIRED SKIN IAW SRM AND DWG.SDR USAA2012040300001Skin · corrodedC3 CHECK - LEVEL 2 EXFOLIATION CORROSION ON FUSELAGE SKIN BETWEEN BS 1187 TO 1207 & BETWEEN S29L TO S30. REPAIRED FUSELAGE SKIN BETWEEN BS 1187 TO BS 1207 & BETWEEN S29L TO S30 IAW EA 103773.SDR ASOA201201074Skin · corrodedFUSELAGE SKIN CORRODED BETWEEN FS 559+80 TO FS 559+112 AT STR 23R. REMOVED LIGHT CORROSION IAW SRM 51-21-06.SDR ASOA201201072Skin · corrodedFUSELAGE SKIN HAS AREA OF CORROSION AT FS 559 +112 AT STR 24R. REMOVED LIGHT CORROSION IAW SRM 51-21-06.SDR ASOA201201070Skin · corrodedFUSELAGE EXTERNAL SKIN HAS AREA OF CORROSION AT STR 24R AT BS 559.00 +112. REMOVED LIGHT CORROSION IAW SRM 51-21-06.SDR DALA1219410930Skin · crackedDURING HMV A CRACK WAS FOUND ON FUSELAGE SKIN OF 0.062" AT STA Y=374 UPPER FWD CORNER BTWEEN LONGERON 20 AND 21RT. REF MD- 88 SRM 53-05 FIG 105 FOR REPAIR.SDR DALA1219400930Skin · corrodedDURING HMV CORROSION WAS FOUND ON FUSELAGE SKIN OF FILLET PANEL AREA FROM STA Y=760 TO 769 BTWEEN LONGS 27R AND 28R ALSO STA Y=758 BTWEEN LONGS 27L AND 28L. REF MD88 SRM 53-04D PARA 57, FOR REPAIR.SDR DALA1219390930Skin · corrodedDURING HMV CORROSION WAS FOUND ON FUSELAGE SKIN UNDER WING TO FUSELAGE FILLET FAIRING STA Y=812 TO 820 BTWEEN LONGS 30 AND 29RT. REF MD88 SRM 53-04D PARA 57 FOR REPAIR.SDR DALA1219380930Skin · corrodedDURING HMV CORROSION WAS FOUND ON FUSELAGE SKIN UNDER WING TO FUSELAGE FILLET FAIRING STA Y=812 TO 820 BTWEEN LONGS 30 TO 29LT. REF MD88 SRM 53-04D PARA 57 FOR REPAIR.SDR DALA1219370930Skin · corrodedDURING HMV CORROSION WAS FOUND ON FUSELAGE SKIN UNDER WING TO FUSELAGE FILLET FAIRING STA Y=823-826 BTWEEN LONGS 29LT AND 29RT REF MD88 SRM 53-04D PARA 57 FOR REPAIR.SDR AALA20120328018Skin · dentedFUSELAGE DENT STATION 397 AND STRINGER 15 RIGHT. INSTALLED DOUBLER REPAIR PER SRM 53-00-01-2R2.SDR DALA1503929235Skin · damagedFUSELAGE SKIN LIGHTNING STRIKE LT WINDOW BELT BS 313-712. REPAIRED IAW ERA 500853-14.SDR DALA13010829229Skin · damagedWINDOW BELT LIGHTNING STRIKES FS 560-6764.SDR SWAA2012050403698Skin · crackedSKIN CRACKED AT BS 827 + 4, STR 19L. REPAIRED SKIN IAW SRM.SDR DALA1227069261Skin · damagedEXTERNAL DOUBLER REPAIR INSTALLED AT TOP OF FUSELAGE APPROX STA 351 HAS INTERNAL FINGER DOUBLER BULGING, TOOL MARKS, AND OVER 50 PERCENT OF THE FASTENERS IMPROPERLY INSTALLED. REMOVED EXISTING REPAIR AND INSTALLED NEW REPAIR PER MD 90 SRM 53-31-03 FIG 8 VOL ISDR SWAA2012041203077Doubler · corrodedDOUBLER CORRODED BETWEEN BS 967 TO BS 986, BETWEEN STR 22R AND STR 25R. REMOVED AND REPLACED DOUBLER IAW SRM AND DWG.SDR ASOA20120404048Skin · corrodedSURFACE CORROSION ALONG ENTIRE MOUNTING EXTERIOR SURFACE AND FASTENER HOLES AT BAGGAGE DOOR BUMPER PLATE. BLENDED, TREATED, PRIMED CORROSION AT BAGGAGE DOOR BUMPER PLATE.SDR ASOA201201050Skin · corrodedFUSELAGE SKIN CORRODED BETWEEN FS 559+80 TO FS 559+112 AT STR 23R. REMOVED LIGHT CORROSION IAW SRM 51-21-06.SDR ASOA201201048Skin · corrodedFUSELAGE SKIN CORRODED AT FS 559+112 AT STR 24R. REMOVED LIGHT CORROSION IAW SRM 51-21-06.SDR ASOA201201046Skin · corrodedFUSELAGE SKIN HAS AREA OF CORROSION AT STR 24R AT BS 559.00+112. REMOVED LIGHT CORROSION IAW SRM 51-21-06.SDR ASOA201201044Skin · corrodedFUSELAGE SKIN HAS SEVERAL AREAS OF CORROSION BETWEEN FS 559+80 TO FS 559+112 BETWEEN STR 26 LT AND RT. REMOVED LIGHT CORROSION IAW SRM 51-21-06.SDR USAA2012032900014Skin · crackedRON VISIT - 3 INCH CRACK IN FUSELAGE SKIN AT BS 727F+15 INCHES, S25L. REPAIRED FUSELAGE SKIN AT BS 727F+15 INCHES, S25L IAW EA 103822 & B737 SRM 53-00-01, REPAIR 31.SDR DALA1219149229Skin · damagedWHILE IN MSP, A/C 9229 SUSTAINED LIGHTNING STRIKE DAMAGE AT STA 150 LONGERON 1. THE DAMAGE WAS BLENDED AND FOUND TO BE OUT OF SRM LIMITS. REPAIRED PER ER/A 501808-14.SDR SWAA2012032902673Skin · crackedFUSELAGE SKIN CRACKED AT BS 500A +14, STR 2R. REPAIRED SKIN PER SRM.SDR SWAA2012041102990Skin · crackedL1 DOOR FUSELAGE SKIN CUTOUT UPPER FWD CORNER CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2012040902854Skin · crackedAFT CARGO DOOR CUTOUT FORWARD LOWER CORNER SKIN CRACKED. REPAIRED SKIN IAW SRM.SDR FDEA201203261121Skin · dentedBS 1185, S15R DENTED ON OUTSIDE SKIN. FOUND TO BE OUT OF LIMITS IAW SRM 53-00-01, FIGURE 101, DETAIL III. INSTALLED DOUBLER AND FILLER IAW-SRM-53-00-01 FIGURE 201 REPAIR 15. THIS IS A CAT."B" REPAIR,MAJOR.SDR SWAA2012040202785Skin · crackedFUSELAGE SKIN CRACKED AT BS 424, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA2012040202784Skin · crackedFUSELAGE SKIN CRACKED AT BS 487, STR 16R. REPAIRED SKIN IAW EA.SDR AALA20120330003Skin · dentedDENT IN THE FUSELAGE SKIN AT STATION 348 BELOW LEFT NUMBER 1 DOOR AT STRINGER 19 LEFT. ACCOMPLISHED AN EXTERNAL DOUBLER REPAIR PER SRM 53-00-01-2R 20.SDR AALA20120329006Skin · dentedDENT IN FUSELAGE SKIN AT STATION 347 BELOW STRINGER 19 RIGHT. INSTALLED INTERNAL DOUBLER PER SRM 53-00-01-2R 6.SDR SWAA2012032802648Skin · crackedSKIN CRACKED AT BS 374, STR 15L. REPAIRED SKIN IAW SRM.SDR SWAA2012032802647Skin · crackedSKIN CRACKED BS 520, STR 15R. REPAIRED SKIN IAW SRM.SDR SWAA2012032802645Skin · crackedSKIN CRACKED BS 424, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA2012032802644Skin · crackedSKIN CRACKED AT BS 487, STR 16R. REPAIRED SKIN PER SRM.
Back to JASC 5330