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 CALA2014081191935Skin · dentedEXT FUSE SKIN BS 430 STRINGER 15L, DENT. FABRICATED & INSTALLED REPAIR DOUBLER & FILLER IAW SRM 53-00-01.SDR FDEA201408072109Skin · corrodedFUSELAGE EXTERNAL SKIN LAP JOINT AT STRINGER 10R FROM BS 375 TO 440 FOUND WITH CORROSION AS MARKED. A REPAIR WAS ACCOMPLISHED ON VT MAE WC 6000236749 & EA 757-5311-16-F4670 REV DATED JULY 23, 2014 & FORM 8110-3 DATED JULY 24, 2014 ATTACHED IAW EA F-5330- TSDR FDEA201408072108Skin · corrodedFUSELAGE EXTERNAL SKIN LAP JOINT AT STRINGER 10L FROM BS 375 TO 440 FOUND WITH CORROSION AS MARKED. A REPAIR WAS ACCOMPLISHED ON VT MAE WC 6000236750 & EA 757-5311-16-F4669 REV DATED JULY 23, 2014 FORM 8110-3 DATED JULY 24, 2014 IAW EA F-5330-T0310166. FUSESDR REXA2014080700509Skin · dentedFOUND A DENT TO THE LT FUSELAGE SKIN AT FS 356.00 AT STRINGER 23L. REPAIRED IAW EA CRJ253-02782.SDR SWAA2014090831640Doubler · corrodedSPLICE DOUBLER CORRODED AT BS 588 RBL 54. R & R DOUBLER IAW SRM & DWG.SDR UHLA2014080600568Skin · misrepairedSKIN FRAMES 87-88 BETWEEN STRINGERS 28-29L, HAS AN IMPROPER REPAIR. REPAIRED IAW ETD2014-170-068862.SDR SWAA2014082731287Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 483 TO 585 STRINGER 16R. REPAIRED SKIN IAW EA.SDR SWAA2014082731286Skin · crackedFUSELAGE SKIN CRACKED AT BS 442 STRINGER 16R. REPAIRED SKIN IAW EA.SDR SWAA2014081430850Skin · crackedFUSELAGE SKIN CRACKED AT BS 374 STRINGER 19R. REPAIRED SKIN IAW SRM.SDR REXA2014081000762Skin · corrodedSKIN CORRODED AT FS 605 BETWEEN STRINGER 26 & 26R MEASURING 7 INCHES X 4.5 INCHES X 0.033 INCHES DEEP. REPAIRED IAW REO 601R-53-61-5321.SDR TSAA20140806007Skin · crackedDURING SCHEDULED MX FOUND A 4 INCH FUSELAGE SKIN CRACK ON THE RT SIDE BS 344 STRINGER 15R.SDR TSAA20140806006Skin · crackedDURING SCHEDULED MX FOUND A 3 INCH FUSELAGE SKIN CRACK ON THE LT SIDE BS 727B STRINGER 18L.SDR AALA20140806008Skin · dentedDENT IN FUSELAGE SKIN AT STATION 263 BETWEEN STRINGERS 15 & 16 RT. INSTALLED DOUBLER IAW EA B737-53-036025.SDR AALA20140806003Skin · crackedCRACK IN FUSELAGE SKIN ON RT SIDE AT STATION 1380 ABOVE LONGERON 14 RT. INSTALLED EXTERNAL DOUBLER IAW AARD 53-30-00-02.SDR UHLA2014080500577Skin · damagedLT AFT FUSELAGE FAIRING HAS START DRILL INTO SKIN. REPAIRED SKIN FRAMES 77-78 STRINGER 21L IAW ETD2014-170-065382, REV A.SDR SWAA2014082731285Skin · crackedFUSELAGE SKIN CRACKED AT BS 424 STRINGER 16L. REPAIRED SKIN IAW EA.SDR SWAA2014082731284Skin · crackedFUSELAGE SKIN CRACKED AT BS 434 STRINGER 16L. REPAIRED SKIN IAW EA.SDR SWAA2014081430849Skin · crackedFUSELAGE SKIN CRACKED AT BS 417 STRINGER 19L. REPAIRED SKIN IAW SRM.SDR CALA2014080691742Skin · dentedFUSELAGE SKIN DENT AT STATION 1620 & STRINGER 19 RT. REMOVED DAMAGED AREA, PERFORMED HFEC & INSTALLED REPAIR DOUBLERS IAW ECRA 5330-04278.SDR DALA2014080604340Skin · damagedDURING INSPECTION, FOUND FUSELAGE SKIN DAMAGED BS 837 S25-27R. REPAIRED IAW ERA 517969.SDR SWAA2014092432265Skin · crackedFIRST OFFICER`S C - D NR 1 WINDOW POST UPPER END CRACKED AT BS 215 NR 1 WINDOW. REPAIRED SKIN IAW SRM & EA & ER.SDR SWAA2014082731283Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 415 TO 418 STRINGER 16L. REPAIRED SKIN IAW EA.SDR SWAA2014082731282Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 453 TO 455 STRINGER 17L. REPAIRED SKIN IAW EA.SDR SWAA2014082731281Skin · crackedFUSELAGE SKIN CRACKED AT BS 453 STRINGER 16L. REPAIRED SKIN IAW EA.SDR SWAA2014082731280Skin · crackedFUSELAGE SKIN CRACKED AT BS 443 STRINGER 17L. REPAIRED SKIN IAW EA.SDR SWAA2014082731279Skin · crackedSKIN CRACKED AT BS 466 STRINGER 17R. REPAIRED SKIN IAW EA.SDR SWAA2014082631254Skin · crackedSKIN CRACKED AT BS 787+12.3 STRINGER 24R. REPAIRED SKIN IAW EA.SDR SWAA2014082631253Skin · crackedSKIN CRACKED AT BS 787+12.25 STRINGER 24R. REPAIRED IAW EA.SDR SWAA2014082631247Skin · crackedSKIN CRACKED AT BS 787+10.5, STRINGER 24R. REPAIRED SKIN IAW EA.SDR DALA2014081404537Skin · corrodedAFT LOWER FUSELAGE SKIN CUTOUT HAS CORROSION. REMOVED CORROSION. FOUND TO BE OUT OF LIMITS. FABRICATED AND INSTALLED NEW INTERNAL SUPPORT PLATE IAW DWG 5936667, REV CC AND ERA 527393-14, REV O.SDR SWIA201439079Skin · dentedSMALL DENT IN FUSELAGE FWD OF BS 250 ABOVE STRINGER 23 AND FOUND OUT OF LIMITS IAW SRM.SDR SWAA2014081430848Skin · crackedFUSELAGE SKIN CRACKED AT BS 500D+11 STRINGER 18L. REPAIRED SKIN IAW SRM.SDR SWAA2014081430847Doubler · crackedFUSELAGE SKIN DOUBLER CRACKED AT BS 513 STRINGER 19L. REPAIRED DOUBLER IAW SRM.SDR CALA2014080691741Doubler · damagedREPAIR DOUBLER AT STATION 1710 STRINGER 15L NEED TO BE REPLACED. REMOVED DAMAGED AREA, FABRICATED & INSTALLED REPAIR IAW ECRA 5330-04276.SDR CALA2014080691736Skin · dentedEXTERNAL FUSELAGE SKIN DENTED AT THREE EACH LOCATIONS FRAME 23 & 24, STRINGER 23L & 24L. FOUND DENTS TO BE OUT OF LIMITS IAW SRM 53-11-11 FIG 115. FABRICATED REPAIR DOUBLER & INSTALLED IAW SRM 53-00-11 FIG 232 PG 505 - 506.SDR USAA2014080500006Skin · crackedRON VISIT CRACK IN FUSELAGE SKIN AT BS 727E, STRINGER 23R. REPAIRED FUSELAGE SKIN AT BS 727E, STRINGER 23R IAW SRM- 53-00-01-2R-31.SDR SWAA2014082031023Skin · crackedSKIN CRACKED AT BS 540 STRINGER 22L. REPAIRED SKIN IAW EA.SDR SWAA2014082031024Skin · crackedSKIN CRACKED AT BS 540 STRINGER 22R. REPAIRED SKIN IAW EA.SDR SWAA2014081530917Post · crackedFLIGHT DECK LT NR 1 WINDOW C - D WINDOW POST CRACKED AT THE UPPER CORNER. REPAIRED POST IAW ACO.SDR DALA2014080304447Skin · damagedLIGHTNING STRIKE ON FUSELAGE SKIN LONGERON 7L BETWEEN BS 275- 294. REPAIRED IAW SRM 53-04-1 PAR 6C, 2 COND, 2 AND 53-04-1, PAR 6D, 1 COND 1 AND SRM 51-30-2 AND 51-10-3, PAR 14-21.SDR AALA20140804013Skin · dentedDENT IN FUSELAGE SKIN FROM STATIONS 380 TO 400 BETWEEN STRINGERS 19 & 20 RT. REMOVED DAMAGE & INSTALLED DOUBLER IAW SRM 53-00-01-2R.SDR SWAA2014080730679Skin · crackedSKIN CRACKED AT BS 540 BELOW STRINGER 22L. REPAIRED SKIN IAW EA.SDR SWAA2014080730678Skin · crackedSKIN CRACKED AT BS 540 BELOW STRINGER 22R. REPAIRED SKIN IAW EA.SDR SWAA2014080630619Skin · crackedAFT ENTRY DOOR CUT OUT CRACKED AT BS 737B LBL 24.75 ON FWD INBD HOLE ON FLANGE. REPAIRED CUT OUT IAW EA.SDR SWAA2014080630618Skin · crackedAFT ENTRY DOOR CUT OUT CRACKED AT BS 737B LBL 45.75 ON AFT OTBD HOLE ON FLANGE. REPAIRED CUT OUT IAW EA.SDR SWAA2014080630617Skin · crackedAFT ENTRY DOOR CUT OUT CRACKED AT BS 737B RBL 24.75 ON FWD INBD HOLE ON FLANGE. REPAIRED CUT OUT IAW EA.SDR AALA20140803003Skin · damagedDENT WITH A RIVET PLUG WAS FOUND BETWEEN STATIONS 380 & 400 & STRINGERS 19 & 20 RT. REMOVED DAMAGE & INSTALLED DOUBLER IAW SRM 53-00-01-2R.SDR WVER0102201500009Skin · dentedOPERATOR REPORTED A DENT ON THE FUSELAGE SKIN FWD OF BS 202.75 BETWEEN STRINGERS 11-12L.SDR SIMA20140802008Skin · misrepairedVERIFY CORRECT REPAIR ON SKIN BETWEEN FRAME 27 - 28 STRINGER 13R - 14R. NO FILLER INSTALLED. PERFORMED REPAIR IAW ERS-EM-53MR-693. R & R DOUBLER.SDR DALA2014080204358Skin · corrodedCORROSION ON FUESELAGE SKIN UNDER WING TO FUSELAGE FILLET FAIRING AREA BS 1079 - 1131 BETWEEN LONGERONS 24 TO 30L. CORROSION REMOVED AND FOUND WITHIN LIMITS.
Back to JASC 5330