JASC 5311
Service difficulty reports · 61,554
Reports filed under 5311 · Fuselage Main, Frame, 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 = '5311' 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 = '5311' 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 ASOA05466Frame · crackedDURING HANGAR MAINTENANCE, THE LT FRAME STA 640 WAS FOUND TO BE CRACKED AFT OF LBL 10 BEYOND LIMITS. THE AIRCRAFT WAS INSPECTED AND FOUND TO BE SAFE FOR A FERRY FLIGHT FOR PERFORMANCE OF THE APPROPRIATE CORRECTIVE ACTION. THE AIRCRAFT LANDED SAFELY. MAINTENSDR 2005UALA00547Frame · dentedEXTERNAL FUSELAGE HAS A DENT AT FRAME STA 807 STR 28L & STR 28R. *S/D* REMOVED DAMAGE, FABRICATED AND INSTALLED NEW SHEAR TIE CLIP SUPPORT ANGLE PER SRM 51-40-02 AND SRM 53-00-07.SDR 2005UALA00486Frame · crackedCABIN OVERWING BS 616 LT SIDE FRAME WEB INNER CHORD IS CRACKED THROUGH FIRST FASTENER APPROX 7 INCHES BELOW FLOOR. REPAIRED WEB AT BS 616 LT PER MM 53-11-81 AND REPAIRED FRAME INNER CHORD PER MM 53-11-89. MANUFACTURED ANGLE AND WEB AND INSTALLED.SDR SWAA051580Frame · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE BELT FRAME CRACKED AT BS 400, STR 18R. REPAIRED BELT FRAME PER SWA EA & SRM.SDR SWAA051569Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 807, STR 9R. REPAIRED FRAME PER SRM.SDR SWAA051568Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727E, STR 9L. REPAIRED FRAME PER SRM.SDR SIMA200515706Frame · gougedABI - DURING AN MBV INSPECTION, THE LOWER FRAME 81 WAS FOUND GOUGED. REMOVED THE GOUGED FRAME. INSTALLED NEW FRAME IAW EMB 145 SRM, SRM EMB145/1142 REV 29, CHAPTERS 51-20-01, 51-20-03, 51-40-02 AND 51-40-04. (M)SDR AALA20050371Failsafe · corrodedAFW - FOUND CORROSION ON THE LOWER SURFACE OF THE LOWER MAIN SILL FAIL SAFE STRAP IN THE FORWARD CARGO AREA AT STATION 566. CORROSION WAS 2 INCHES BY 4 INCHES. BLENDED CORROSION AND PERFORMED HIGH FREQUENCY EDDY CURRENT INSPECTION OF THE BLENDED AREA TO ENSUSDR SWAA051567Frame · corrodedDURING SCHEDULED D-CHECK, FOUND BS 727 INBOARD FUSELAGE CHORD CORRODED AT RBL 10 TO LBL 10, WL 148. REMOVED AND REPLACED CHORD SECTION PER SRM.SDR SWAA051557Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727E, STR 23R TO STR 24R. REPAIRED FRAME PER SRM.SDR SWAA051555Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727C, STR 9L. REPAIRED FRAME PER SRM.SDR SWAA051552Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 663, STR 1, STR 2L & STR 2R. REPAIRED FRAME PER SRM.SDR 2005UALA00479Frame · dentedAFT PIT FUSELAGE FRAME IS DENTED AT STA 1440 LT AT FLOOR TRANSITION PANEL. DAMAGE IS ON INBOARD FLANGE IN TWO PLACES. FRAME HAS BEEN REPAIRED PER TIMCO REO G-09850, REV A, WITH A J-ANGLE PER EVA 40168.SDR 2005UALA00478Frame · damagedFUSELAGE FRAME AT STA 600 BETWEEN STR 24L AND 24L REQUIRE DTA TO BE ACCOMPLISHED. REMOVED FRAME SECTION AND FABRICATED REPAIR PARTS PER REO G09843 REV 1.SDR SWAA051519Frame · corrodedDURING SCHEDULED D-CHECK, FOUND FUSELAGE SHEAR TIE CORRODED AT BS 927, RBL 7. REMOVED & REPLACED FRAME SECTION PER SRM.SDR SWAA051516Shear Tie · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE SHEAR TIE CRACKED AT BS 360, STR 14L TO STR 15L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA051514Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 663, STR 3L TO STR 3R. REPAIRED FRAME PER SRM.SDR SWAA051542Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME PER SRM.SDR SWAA051541Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 9R. REPAIRED FRAME PER SRM.SDR SWAA051540Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 9L. REPAIRED FRAME PER SRM.SDR SWAA051539Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 9L & STR 9R. REPAIRED FRAME PER SRM.SDR SWAA051535Frame · corrodedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 767, LBL 10. REPAIRED FRAME PER SRM.SDR ASAA0580296Frame · corrodedOKC - FOUND DURING C-CHECK, FRAME CORRODED AROUND FASTENERS. REMOVED DAMAGED SECTION. INSTALLED REPAIR DOUBLER AND FILLER. (M)SDR ASAA0580295Frame · corrodedOKC - DURING C-CHECK, FOUND FRAME CORRODED AROUND FASTENERS. REMOVED DAMAGED SECTIONS. INSTALLED REPAIR DOUBLER AND FILLER. (M)SDR SWAA051500Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE STUB FRAME CRACKED AT BS 188, LT SIDE, WL 208. REMOVED AND REPLACED STUB FRAME PER SRM.SDR 05FDEA01403Frame · crackedDURING AIRPLANE'S CONVERSION FROM P TO F, FOUND CRACK 2.5 INCHES LONG ON FRAME LUG AT STA 1256 B/T L11 AND L12, RT SIDE. CUT OUT DAMAGED AREA AND REPAIR FRAME IAW SRM 53-30-00 FIG 2. CUT OUT DAMAGED AREA AND REPAIR FRAME IAW SRM 53-30-00 FIG 2.SDR U2RA3218Frame · damagedFUSELAGE FRAME DAMAGED AT STATION 1560, L21L.SDR USAA050721Frame · corrodedPIT - FOUND FRAME CORRODED 2 INCH BY 1 INCH AREA, TOP OF FRAME 17 - Y31. FABRICATED REPAIR ANGLES PER SRM 53-11-15. (M)SDR 72300212Frame · corrodedA 1 X 2 INCH AREA OF CORROSION ON BULKHEAD FRAME.SDR 2005UALA00465Frame · dentedAFT PIT FUSELAGE FRAME IS DENTED AT STA 1480 STR 25L. CUT OUT DAMAGE AND ACP HFEC WITH NO CRACK INDICATION. PER GSO TIMCO REO G10464, FABRICATED RPR AND INSTALLED.SDR 2005UALA00463Frame · dentedAFT PIT FUSELAGE FRAME IS DENTED AT STA 1520, STR 25L. REMOVED DAMAGE AND INSTALLED J ANGLE REPAIR PER RE0-G10463, EVA-50283, AND SRM51- 40-02.SDR 2005UALA00462Frame · gougedFRAME STA 1520 FROM STR 22R TO 25R IS GOUGED FROM SCREWS IN 6 PLACES. REMOVED DAMAGE AND ACP HFEC NO CRACKS INDICATED. PER REO G10474 FABRICATED NESTLED ANGLE REPAIR AND INSTALLED.SDR 2005UALA00461Frame · dentedFWD PIT FRAME IS DENTED AT STA 600 STR 24L. CUT OUT DAMAGE AND ACP HFEC WITH NO CRACK INDICATED. FABRICATED RPR PER REO G-1042 AND INSTALLED.SDR 2005UALA00460Frame · corrodedAFT PIT FRAME PREVIOUS REPAIR IS CORRODED AT STA 1600 - STR 25L TO 27L. REMOVED DAMAGE AND FABBED NEW PRODUCTION SPLICE AND ANGLE REPAIR AND INSTALLED PER REO-G10504B AND SRM51-40-02 AND EVA-50287.SDR UPS05444516Frame · crackedINSPECTION TYPE:C U/D - STA 600 FRAME CRACKED AT STRINGER S-8R AREA (CRACK LENGTH .5 INCH). U/D STA 600 AT STRINGER S-8R FRAME REPAIRED AS PER SRM 53-10-04 FIG 54.SDR SWAA051485Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME ANGLE CRACKED AT BS 947, LBL 23, WL 180. REMOVED AND REPLACED ANGLE PER SRM.SDR SWAA051480Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 767, STR 13L. REPAIRED FRAME PER SRM.SDR SWAA051478Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE STUB FRAME CRACKED AT BS 188, RT SIDE, WL 208. REPAIRED STUB FRAME PER SRM.SDR COMA0570054Frame · corrodedFS 280 - FUSELAGE TRANSVERE BEAM IS CORRODED BEYOND LIMITS. PERFORMED A MAJOR REPAIR TO FS 280 TRANSVERSE BEAM BY REMOVING CORRODED BEAM AND INSTALLING NEW BEAM P/N CC670-34175-71AW CRJ 700 SRM 51-42-06-001-001-A01 AND INSTALLING REPAIR DOUBLERS P/NS 670-53-1SDR QXEA200500991Frame · chafedFUSELAGE STATION FORWARD SIDE OF FRAME STATION X1088 BETWEEN STRINGER 9R AND 10R HYDRAULIC LINE ATTACH CLIP BROKEN OFF AND FRAME CHAFED. REPAIRED IAW REO 670-53-61-170 AND HORIZON AIR EA R-53-337.SDR 05FDEA01378Frame · damagedFWD CARGO BAY FRAME IS CREASED BS 680, STR 24L TO 25L. REPAIRED FRAME AT BS 680 STR 24L-25L PER SRM 51-40-3.SDR 05FDEA01377Frame · damagedFWD CARGO BAY FRAME IS CREASED BS 660, STR 24L. REPAIRED FRAME AT BS 660, STR 24L PER SRM 51-40-3SDR SWAA051462Frame · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 928, STR 25R. REPAIRED FRAME PER SRM.SDR MALA050433Frame · scratchedDURING LINE CHECK AFTER C3 INSPECTION FOUND SCRATCH IN FUSELAGE AT FRAME 23 LT .004 MATERIAL LOSS CLASS A DENT PER AVMAX.SDR ASAA0540255Frame · crackedVERTICAL ANGLE CRACKED AT B-STA 601, RBL 64, WI 204, AND B-STA 601 FRAME. CUT OUT DAMAGED SECTION OF 601 FRAME AND FABRICATED REPAIR ANGLE IAW EA 5330-01934, ER 05-2867. (K)SDR ASAA0540253Frame · crackedFRAME CRACKED AT HAT RACK ATTACH POINT. REPAIRED CRACKED FRAME AT HAT RACK ATTACH POINT. (K)SDR ASAA0540252Frame · crackedFRAME CRACKED AT HAT RACK ATTACH POINT. REPAIRED CRACKED FRAME AT HAT RACK ATTACH POINT. (K)SDR UPS05444663Frame · crackedINSPECTION TYPE:C AFT CARGO COMPT BS 1560 STR 34L FRAME INNER CHORD CRACKED (CRACK LENGTH 10.5 APPROX). AFT CARGO COMPT BS 1560 STR 32L TO STR 38L FRAME REPAIRED AS PER HX RS R53-62-35312 CONTINUED INSPECTION REQUIRE TO THE REPAIR AREA PER SB 747-53A2349 REV SDR DHL2005784514Frame · dentedSTA 720A FRAME IS DENTED ABOVE STR 23R. FOUND DENT TO BE OUT OF LIMITS IAW B727 SRM 53-10-1 FIG 1, CUT OUT DAMAGED AREA . FABRICATED ANGLE REPAIR IAW B727 SRM 53-10-2 FIG 3. ALODINE AND PRIMED PART AND AREA IAW B727 SRM 51-10-2. INSTALLED PART IAW B727 SSDR DHL2005784513Frame · dentedSTA 700 FRAME IS DENTED ABOVE STR 4R. FOUND DENT TO BE OUT OF LIMITS. REPAIRED IAW SRM.
Back to JASC 5311