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 FDEA201003180914Skin · mismanufacturedFASTENERS WITH IMPROPER SPACING FWD PIT SKIN STA 605 STR 25L.SDR FDEA201003180913Skin · mismanufacturedFASTENERS WITH IMPROPER SPACING FWD PIT SKIN STA 595 STR 25L. (2 LOCATIONS)SDR FDEA201003180912Skin · mismanufacturedFASTENERS WITH IMPROPER SPACING FWD PIT STA 585 STR 25L.SDR FDEA201003180911Skin · mismanufacturedFASTENERS WITH IMPROPER SPACING FWD SKIN PIT STA 575 STR 25L.SDR FDEA201003180909Skin · mismanufacturedFASTENERS WITH IMPROPER SPACING SKIN FWD PIT STA 565 STR 25L.SDR FDEA201003180908Skin · mismanufacturedFASTENERS WITH IMPROPER SPACING SKIN FWD PIT STA 520 STR 27L. CUT OUT DAMAGED AREA THRU SKIN IAW SRM 53-30-3 FIG 1B, FABRICATED STRUCTURAL FILLER, DOUBLER AND TRIPLER IAW PF SRM 53-30-3 FIG 1B, CUT OUT DAMAGED SHEAR TIE IAW SRM 53-10-4, FIG 15, FABRICATED SSDR FDEA201003180900Skin · mismanufacturedFASTENERS WITH IMPROPER SPACING FWD SKIN PIT STA 635 BELOW STR 25L.SDR FDEA201003180899Skin · mismanufacturedFASTENERS WITH IMPROPER SPACING FWD SKIN PIT STA 600 BELOW STR 25L.SDR FDEA201003180897Skin · mismanufacturedFASTENERS WITH IMPROPER SPACING, SKIN FWD PIT STA 580, BELOW STR 25L.SDR FDEA201003180895Skin · mismanufacturedFASTENERS WITH IMPROPER SPACING FWD SKIN PIT STA 560 BELOW STR 25L.SDR FDEA201003180893Skin · mismanufacturedFASTENERS WITH IMPROPER SPACING FWD SKIN PIT STA 557 BELOW STR 25L.SDR FDEA201003180892Skin · mismanufacturedFASTENERS WITH IMPROPER SPACING FWD SKIN PIT STA 540 BELOW STR 25L.SDR FDEA201003180890Skin · mismanufacturedFASTENERS WITH IMPROPER SPACING FWD SKIN PIT STA 530 BELOW STR 25L.SDR FDEA201003180888Skin · mismanufacturedFASTENERS WITH IMPROPER SPACING FWD SKIN PIT STA 520 BELOW STR 25L.SDR FDEA201003180887Skin · mismanufacturedFASTENERS WITH IMPROPER SPACING FWD PIT SKIN STA 518 BELOW STR 25L.SDR FDEA201003180885Skin · mismanufacturedFASTENERS WITH IMPROPER SPACING FWD PIT STA 510 BELOW STR 25L.SDR FDEA201003180883Skin · mismanufacturedFASTENERS WITH IMPROPER SPACING FWD PIT STA 500 BELOW STR 25L.SDR FDEA201003180882Skin · mismanufacturedFASTENERS WITH IMPROPER SPACING FWD PIT STA 490 BELOW STR 25L. CUT OUT DAMAGED AREAS, FABRICATED FILLER USING 2024T-3 .125 DIMS 63.75" X 7.40", DOUBLER USING 2024T-3 .080 DIMS 62" X 13", TRIPLER USING 2024T-3 .125 DIMS 60" X 9.30", 3 SHEAR TIES USING BAC150SDR SWAA101609Skin · corrodedDURING SCHEDULED SPV CHECK, FOUND SKIN CORRODED AT BS 967, STR 25L. REMOVED AND REPLACED SKIN DOUBLER PER DWG.SDR FDEA201003170856Doubler · corrodedAFT PIT DOUBLER AT FRAME 58-62; LBL 56 TO RBL 56 HAS CORROSION. CORROSION FOUND TO BE OUT OF LIMITS IAW SRM 53-17-12. FORMED NEW DOUBLER SECTION IAW SRM 53-17-12, FIG 208 AND DWG A53973332. LOCATED AND DRILLED DOUBLER SECTION IAW SRM 51-72-10 AND SRM 51-40-SDR SWAA101617Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 737E, STR 10R. REPAIRED SKIN PER EA.SDR SWAA101616Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 389.5, STR 10L. REPAIRED SKIN PER EA.SDR SWAA101574Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 737C, STR 4R. REPAIRED SKIN PER EA.SDR SWAA101573Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 528, STR 4L. REPAIRED SKIN PER EA.SDR SWAA101571Skin · crackedDURING SCHEDULED CV CHECK, FOUND SKIN CRACKED AT BS 394, STR 10L. REPAIRED SKIN PER EA.SDR DALA105719872Skin · roughDURING H-CHECK, FOUND CAPTAINS PRIMARY STATIC PORT SKIN NOT SMOOTH ENOUGH INSIDE CRITICAL AREA. REPAIRED PER BOEING DRAWING SG09530001 AND SRM 51-10-4, 51-10-3.SDR R61A20100123Skin · dentedWHILE AC WAS IN FOR HEAVY CHECK, A MAJOR REPAIR WAS ACCOMPLISHED. DENT WAS FOUND ON LT FUSELAGE AT FR 25, STR 21L. MAINTENANCE REQUESTED EMB ENGINEERING SUPPORT AND RECEIVED ETD2010-170/01692. MAINTENANCE REPAIRED PER ETD AND SRM. AC STILL OUT OF SERVICE FSDR R61A20100120Skin · dentedWHILE AC WAS IN FOR HEAVY CHECK, A MAJOR REPAIR WAS ACCOMPLISHED. DENT WAS FOUND ON LT FWD FUSELAGE AT FR 26 AND FR 27, STR 20L AND STR 21L. MAINTENANCE REQUESTED EMB ENGINEERING SUPPORT AND RECEIVED ETD2010-170/01697 AND ETD2010-170/01711 FOR REPAIR. MAINTSDR R61A20100119Skin · dentedWHILE AC WAS IN FOR HEAVY CHECK, A MAJOR REPAIR WAS ACCOMPLISHED. DENT WAS FOUND ON LT FUSELAGE AT FR 27 TO FR 28, STR 20L TO STR 21L. MAINTENANCE REQUESTED EMB ENGINEERING SUPPORT AND RECEIVED ETD2010-170/01697 AND ETD2010-170/01112 FOR REPAIR. MAINTENANCESDR USAA2010031690591Skin · crackedCLT - RON - MAJOR REPAIR - A 3 INCH CRACK ON FUSELAGE SKIN AT BS 737, S18L. REPAIRED FUSELAGE SKIN AT BS 737, S18L IAW B737 SRM 53-00-01 REPAIR 31. "SUP" THIS EVENT WAS ORIGINALLY SUBMITTED ON 3/16/2010 VIA FAX ALONG WITH 3 OTHER EVENTS. WHILE REVIEWING TSDR USAA2010031691591Skin · crackedTHREE (3) INCH CRACK ON FUSELAGE SKIN AT BS 737, S18L. REPAIRED FUSELAGE SKIN AT BS 737, S18L IAW B737 SRM 53-00-01, REPAIR 31.SDR SWAA101576Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 824, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA101562Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 522.5, RBL 5. REPAIRED SKIN PER AEM EO.SDR SWAA101527Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 515B, STR 4R. REPAIRED SKIN PER DWG.SDR SWAA101526Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 485, STR 4R. REPAIRED SKIN PER DWG.SDR SWAA101525Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 435, STR 4R. REPAIRED SKIN PER DWG.SDR SWAA101524Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 425, STR 4R. REPAIRED SKIN PER DWG.SDR SWAA101523Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 515D, STR 4L. REPAIRED SKIN PER DWG.SDR SWAA101522Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 505D, STR 4L. REPAIRED SKIN PER DWG.SDR SWAA101519Skin · crackedDURING SCHEDULED 14Y CHECK, FOUND RT SIDE FUSELAGE SKIN CRACKED AT GROUND AIR CONDITIONING ACCESS DOOR CUTOUT AT BS 534. REPAIRED SKIN PER AAR EA.SDR EE4Y1003029Skin · corrodedLOWER FUSELAGE SKIN CORRODED FROM STA Y642 TO STA Y650 BETWEEN LONG 29 LT AND 29 RT.SDR SWAA101513Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED BETWEEN BS 797 TO BS 799, STR 4L. REPAIRED SKIN PER ER.SDR SWAA101500Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 933, STR 25R. REPAIRED SKIN PER SRM.SDR SWAA101493Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 817, STR 10R. REPAIRED SKIN PER ER.SDR SWAA101492Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED BETWEEN BS 508D TO BS 511C, STR 8R. REPAIRED SKIN PER ER.SDR SWAA101491Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED BETWEEN BS 430 TO BS 432, STR 1L. REPAIRED SKIN PER ER.SDR SWAA101490Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED BETWEEN BS 797 TO BS 799, STR 4L. REPAIRED SKIN PER ER.SDR SWAA101489Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED BETWEEN BS 875 TO BS 898, STR 10R. REPAIRED SKIN PER ER.SDR SWAA101488Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 471, STR 10L. REPAIRED SKIN PER ER.SDR SWAA101487Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 511C, STR 8R. REPAIRED SKIN PER SRM.
Back to JASC 5330