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 SWAA063447Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 520, STR 10R. REPAIRED SKIN PER SWA EA.SDR QXEA200602552Skin · dentedC4 YYC - EXTERNAL FUSELAGE BOTTOM SKIN, STATION X128.0 STRINGER 31L TO 32L HAS A DENT. REPAIRED IAW RD8-53-9231.SDR DL76G060756Skin · damagedON WALK AROUND, FOUND A/C DAMAGE AFT OF LT SERVICE PANEL STA 1559.5 BETWEEN STR 20L AND SRR 21L. INSTALLED DOUBLERS PER SRM 53-00-01 REPAIR 14 PAGE 208.SDR USAA061143Bear Strap · gougedBS 440 S-24L GOUGED. BLENDED DAMAGE, FABRICATED AND INSTALLED DOUBLER IAW EA 98035, DEFECT SIZE: 1.75 X .0625 X .040 INCH.SDR USAA061148Bear Strap · gougedBS 440 S-24L GOUGED. BLENDED DAMAGE, FABRICATED AND INSTALLED DOUBLER IAW EA 98035, DEFECT SIZE: 1.75 X .0625 X .040 INCH.SDR SWAA063441Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 944, STR 25R. REPAIRED SKIN PER SRM.SDR SWAA063438Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 924, STR 24R. REPAIRED SKIN PER SRM.SDR SWAA063437Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 942, STR 23R. REPAIRED SKIN PER SRM.SDR SWAA063436Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 931, STR 23R. REPAIRED SKIN PER SRM.SDR SWAA063435Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 932, STR 24R. REPAIRED SKIN PER SRM.SDR SWAA063434Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT E&E COOLING EXHAUST DUCT CUTOUT, BS 378.5, LBL 2.8. REPAIRED SKIN PER SWA EA.SDR CALA0600417Skin · crackedFUSELAGE CRACK AT STA 747, 12 INCHES BELOW WATER LINE. REPAIRED IAW SRM 53-00-01 REPAIR 31 FIG 201.SDR QXEA200602527Skin · crackedC4 YYC - INNER FUSELAGE SKIN AT STATION 683.200, BENEATH DORSAL FIN IS CRACKED AT TWO RIVETS. REPAIRED IAW RD8-55-1747 AND SRM 51-40-11, 51-20-51.SDR SWAA063420Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 770, STR 19L. REPAIRED SKIN PER SRM.SDR ALGR111208Panel · crackedROOF PANEL CRACKED APPROX. 1.6.SDR QXEA200602486Skin · corrodedC3 PDX - SKIN X783.102 AND 26L HAS FRETTING CORROSION IN THE RADIUS. REPAIRED IAW SRM 51-14-00, 51-21-10.SDR MWEA060195Skin · dentedFUSELAGE DENT AT STATION 508 TO 520 BETWEEN LONGERON 20R AND 21R. RECONTOURED DENT AREA FABRICATED AND INSTALLED DOUBLERS.SDR MWEA060194Skin · dentedFUSELAGE DENT AT STATION 486 TO 503 BETWEEN LONGERON 20R AND 21R. RECONTOURED DENT AREA.SDR MWEA060193Skin · dentedFUSELAGE DENT AT STATION 449 TO 465 BETWEEN LONGERON 20R AND 21R. RECONTOURED DENT AREA.SDR SWAA063411Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 498, STR 26L. REPAIRED SKIN PER SRM.SDR SWAA063410Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 505A, STR 26L. REPAIRED SKIN PER SRM.SDR SWAA063409Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 485, STR 26L. REPAIRED SKIN PER SWA EA.SDR SWAA063408Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 465, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA063407Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 365, STR 16R. REPAIRED SKIN PER SWA EA.SDR DALA1132690626Bear Strap · corrodedFUSELAGE BEAR STRAP, FS 360, S-17R, R1 DOOR CUTOUT LOWER AFT CORNER CORROSION REPAIRED IAW ERA 450307-14.SDR AALA20060838Skin · corrodedAFW - FOUND INNER SURFACE OF FUSELAGE SKIN AT STATION 1085 BETWEEN RIGHT KEEL BEAM AND STRINGER 37 RIGHT HAD CORROSION BLENDED AT DRAIN LOCATION. AREA OF DISCREPANCY IS 2.8 INCHES BY 2.3 INCHES WITH A DEPTH OF 0.266. REMOVED ALL CORROSION. PERFORMED HIGH FSDR HALA0600792Skin · gougedTWO GOUGES IN EXTERNAL FUSELAGE SKIN, BS 1358, BETWEEN STR 29L AND 30L. REPAIRED FUSELAGE SKIN BS 1358 BETWEEN STR 29L AND 30L PER SRM 53-00-01-2R-6 FIG 201.SDR UPS06848060Skin · corrodedINSPECTION TYPE:C3 SKIN CORRODED OUT OF LIMITS AT STA 1490-1690 L31L-L31R. REMOVED AND REPLACED SKIN AT STA 1490-1690 L31L-L31R IAW SRM 51-1-21 AMD 51-1-20D.SDR QXEA200602541Skin · damagedC4 YYC - LEFT SIDE SKIN HAS 5 SMOKING RIVETS FORM X545 TO X618. REPAIRED IAW SRM 51-40-11.SDR 2006UALA01749Skin · dentedLWR FUSELAGE AFT CARGO DOOR CUTOUT UPPER EDGE AFT OF FWD CORNER DENTED. REMOVED DAMAGE. FABRICATED AND INSTALLED DOUBLER, TRIPLER AND 2 FILLERS.SDR 2006UALA01747Doubler · damagedCHAFING ON PREVIOUS FUSELAGE SKIN REPAIR DOUBLER UNDER DORSAL FIN BLADE-BULB SEALS BS 886-897. MAJOR REPAIR; REMOVED DAMAGE. FABRICATED AND INSTALLED DOUBLER AND TRIPLER REPAIR.SDR HALA0600695Skin · dentedIMPACT DAMAGE ON LT FUSELAGE 3' AFT OF MED AND 5" BELOW CASP DENT IN ACFT SKIN BETWEEN LONG 18 AND 19 LT SIDE AT APP STA 215 .016 BY 2 BY 2.5 STA 222 .049 BY 3.5 BY 3. OK TO CONTINUE PER GMM4-3.2SDR SWAA063404Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 933, STR 24R. REPAIRED SKIN PER SWA EA.SDR SWAA063403Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 972, STR 24L. REPAIRED SKIN PER SWA EA.SDR SWAA063402Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 770, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA063401Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 770, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA063400Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 750, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA063399Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 750, STR 19L. REPAIRED SKIN PER SRM.SDR HALA0600791Skin · gougedFOUND TWO GOUGES IN FUSELAGE SKIN AT BS 360, BETWEEN STR 20R AND 21R. REPAIRED EXTERNAL FUSELAGE SKIN AT BS 360 BETWEEN STR 20R AND 21R PER SRM 53-00-01-A1 DETAIL 2.SDR HALA0600788Skin · damagedSEVERAL SCRATCHES AND GOUGES IN EXTERNAL FUSELAGE SKIN BS 407 TO 421, STR. 32R TO 34R. REPAIRED EXTERNAL FUSELAGE SKIN AT BS 407 - 421 STR 32R - 34R PER SRM 53-00-01-1A-1 DETAIL 2.SDR HALA0600790Skin · gougedTHREE GOUGES IN FUSELAGE SKIN AT BS 371, STR 21R. REPAIRED EXTERNAL SKIN IN FUSELAGE AT BS 371, STR 21R PER SRM 53-00-01-1A-1.SDR HALA0600789Skin · gougedTWO GOUGES IN FUSELAGE SKIN AT BS 372, STR 22R. REPAIRED EXTERNAL FUSELAGE SKIN AT BS 372, STR 22R PER SRM 53-00-01-1A-1.SDR SWAA063391Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN TEAR STRAP CRACKED AT BS 747, STR 18L. REPAIRED SKIN PER SWA EA.SDR SWAA063387Skin · chafedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CHAFED AT BS 860 TO BS 887, BETWEEN STR 2L AND STR 2R. REPAIRED SKIN PER ER.SDR SWAA063365Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 774, STR 21L. REPAIRED SKIN PER SWA EA.SDR SWAA063364Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 308, STR 18R. REPAIRED SKIN PER SWA EA.SDR SWAA063362Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 932, S21R. REPAIRED SKIN PER SRM.SDR 06FDEA03227Skin · damagedEXTERNAL FUSELAGE AT STA 1900 TO 1921 BETWEEN LONGERONS 51 AND 52 RT SIDE EXISTING REPAIR REMOVED AND REPAIRED IAW SRM 53-20-00 FIG 6 VOL 1.SDR 06FDEA03226Skin · damagedEXTERNAL FUSELAGE AT STA 1871 TO 1891 BETWEEN LONGERONS 51 AND 52 RT SIDE EXISTING REPAIR REMOVED AND REPAIR IAW SRM 53-20-00 FIG 6 VOL 1.SDR AALA20060830Skin · corrodedMCI - FOUND CORROSION AT AIRCRAFT SKIN BELOW STRINGER 35 LEFT AT STATION 446 TO 451. INSTALLED SKIN REPAIR DOUBLER AT STRINGER 35 LEFT FROM STATION 446 TO 451 PER STRUCTURAL REPAIR MANUAL 53-00-01 AND AA REPAIR DOCUMENT 53 00 01 5. SYSTEM GROUND CHECKED NORM
Back to JASC 5330