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 DJFA2006364Frame · crackedDURING THE NOSE GEAR INSPECTION IN PHASE B3, MAINTENANCE NOTED CRACKS IN THE NOSE WHEEL WELL FRAME AT BOTH CORNERS. MAINTENANCE FOUND THAT THE FRAME, ADJOINING SKIN, AND STRAPS WERE ALL CRACKED. CRACKS VARIED IN SIZE WITH THE LARGEST AT JUST UNDER .25". ALLSDR DJFA2006363Frame · crackedDURING A SCHEDULED MAINTENANCE EVENT, MAINTENANCE REPORTED THE FLOOR BOARDS NEAR THE ENTRANCE WAY WERE SPONGY. UPON FURTHER INSPECTION, FRAME 10 WAS FOUND CRACKED. THE CRACK WAS APPROXIMATELY 1 INCH LONG AND BEGAN AT THE FORWARD NUTPLATE AND EXTENDED FROM LTSDR USAA061440Frame · crackedBS 597 RBL 64 CRACKED. INSTALLED DOUBLER IAW EA 98276, DEFECT SIZE: .5 INCH.SDR USAA061442Frame · crackedBS 480 FRAME CRACKED AT PSU RAIL ATTACH BRACKET BETWEEN S 8R-9R CRACKED. INSTALLED DOUBLER IAW TR 53-10-20D, DEFECT SIZE: .25 INCH.SDR CALA0600528Frame · corrodedINSPECTION FOUND FRAME CORRODED AT STA 227, S28L TO S28R, LBL 4 TO RBL 4. THE FRAME WAS REPAIRED IAW ECRA 5311-01286.SDR CALA0600526Frame · corrodedINSPECTION FOUND CHORD CORRODED AT STA 227, BL 0 TO RBL 6, S28L TO S28R. A REPAIR WAS INSTALLED IAW ECRA 5311-01285.SDR QXEA200603187Strap · chafedC4 PDX - FORMER REINFORCEMENT STRAP INSIDE FACE STATION 636 AT UPPER CARGO FLOOR LEVEL RIGHT SIDE IS CHAFED. REPAIRED IAW SRM 51-20-11 AND 51-20-36.SDR AWXA200700051Frame · crackedMCN - R2 DOOR CUT OUT, FORWARD UPPER STUB FRAME CRACKED, BS 952, S9R - S10R. REPLACED R2 DOOR CUT OUT, FORWARD UPPER STUB FRAME, BS 952, S9R - S10R IAW B737-300 SRM 51-40-02.SDR QXEA200603188Frame · chafedC4 PDX - INBOARD FACE OF FORMER STATION 650 IS CHAFED AT RIGHT SIDE FLOOR LEVEL. REPAIRED IAW SRM 51-20-11AND 51-20-00.SDR AWXA200700075Frame · crackedMCN - MAJOR REPAIR - FORWARD CARGO COMPARTMENT DOOR CUT OUT FORWARD FRAME CRACKED, BS 440, S24R, AT DOOR STOP FITTING. REPAIRED FORWARD CARGO COMPARTMENT DOOR CUT OUT FORWARD FRAME, BS 440, S24R, AT DOOR STOP FITTING IAW AWA ER 03-5331-07013-HF1.SDR KNNA200700007Frame · crackedCRACKED VERTICAL FITTING ON RBL-26 AND BS 727 AT UPPER LIGHTENING HOLE. REPAIR SKIN PER ACO NR 0653124.SDR KNNA200700008Frame · crackedFOUND CRACKED FRAME ON LBL-24, B-STA727. INSTALLED INTERIM REPAIR, REQ, INSP EVERY 5,000 F/HRS.SDR KNNA200700006Frame · crackedFOUND CRACKED FRAME ON BL-0, B,STA-727. REPAIRED FRAME IAW ACO NR 0653122. INTERIM REPAIR INSP EVERY 5,000 FLIGHT HOURS.SDR AWXA200700027Frame · crackedMCN - MAIN CABIN FRAME CRACKED, BS 907, BETWEEN S1L AND S2L. REPAIRED MAIN CABIN FRAME, BS 907, BETWEEN S1L AND S2L IAW B737-300 SRM 53-00-07 -2R2 FIGURE 201.SDR TRAX200601118Frame · crackedLT FS 640.00 DOUBLER CRACKED. REFER TO W/C 1003 FOR CORRECTIVE ACTION. SEE PART C OF SB 601R-53-061. VS813 12-20-06.SDR 2006UALA02376Frame · crackedFWD CARGO DOOR CUTOUT AFT FRAME IS CRACKED AT AFT SIDE OF FRAME IN THE RADIOUS JUST ABOVE LOWER STOP FITTING. MAJOR REPAIR: REMOVED DAMAGE. FABRICATED AND INSTALLED ANGLE REPAIR PER AAR EA I060544 REV IR AND UA EVA 60754.SDR MAC120601Frame · corrodedCORROSION FOUND ON FRAME 13 AT STRINGER 17 RT BEYOND SRM ALLOWABLE LIMITS.SDR SWAA064973Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 887, STR 13R. REPAIRED FRAME PER SWA EA.SDR SWAA064972Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 13R. REPAIRED FRAME PER SWA EA.SDR USAA061430Frame · crackedBS 847 FRAME AT LOWER DOOR STOP MOUNT BOLT HOLE NEAR S-24R CRACKED. REMOVED DAMAGE, FABRICATED AND INSTALLED FILLER AND REPAIR ANGLES IAW EA 98328, DEFECT SIZE: .125 INCH.SDR SWAA064943Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 986.5, S2L. REPAIRED FRAME SECTION PER EA.SDR SWAA064942Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 639, STR 17R AND STR 17L. REPAIRED FRAME SECTION PER EA.SDR 06FDEA04241Frame · wornCOCKPIT AREA FOUND DEEP WEAR ON FRAME AT STA 392 RT SIDE X=-39, AREA OF WORN AT FS 392 FRAME RT X=-39. BLENDED OUT AREA NDT NO CRACKS FOUND. FRAME REPAIRED IAW SRM 53-30-00 FIG 4 PAGE 13 VOL 1.SDR SWAA064922Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 807, STR 4L. REPAIRED FRAME SECTION PER SRM.SDR SWAA064898Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727C, STR 8R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA064897Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 597, STR 8R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA064896Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 8R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA064895Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 887, STR 8L. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA064894Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 847, STR 8L. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA064927Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 807, STR 13R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA064926Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 13L. REPAIRED FRAME SECTION PER SWA EA.SDR 06FDEA04231Frame · corrodedDURING ACCOMPLISHMENT OF C CHECK MX, AAR AIRCRAFT SERVICES, IND CORROSION WAS FOUND COMMON TO THE FORWARD SIDE OF THE AFT FRAME AT THE NR 3 CARGO DOORWAY AT STA 1142.7 BETWEEN STRINGERS 25R AND 27R (RBL 26). THE DAMAGE WAS BLENDED TO A 20:1 RATIO AND VERIFIEDSDR K11A2008123072303Frame · corrodedFRAME HAS CORROSION.SDR K11A2008121972301Frame · crackedFRAME CRACKED.SDR 06FDEA04230Frame · dentedM/D CARGO: LT INTERIOR FUSELAGE FRAME (STA 1701, L12) FOUND DENT. CARRIED OUT REPAIR AS PER SRM 53-30-00 FIGURE 1 VOULUME I. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100.SDR 06FDEA04229Frame · dentedM/D CARGO: LT INTERIOR FUSELAGE FOUND FRAME (STA 1681, L12) DENT. CARRIED OUT REPAIR AS PER SRM 53-30-00 FIGURE 1 VOULUME I. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100.SDR 06FDEA04228Frame · damagedM/D CARGO: RT INTERIOR FUSELAGE FOUND FRAME (STA 1661, L12) BROKEN. CARRIED OUT REPAIR AS PER SRM 53-30-00 FIGURE 1 VOLUME I. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100.SDR SWIA200617701Frame · crackedFS 280 RBL9 LWR FRAME CRACKED, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED REPAIR ANGLE PER BOMBARDIER REO 601R 53-11-171 AND 601R 53-11-102 P/N 86144A33.SDR SWIA200617700Frame · crackedFS 280 LBL9 UPPER FRAME CRACKED MARKED RBL 9 UPPER FRAME CRACKED, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED REPAIR PARTS PER REO 601R-53-11-136.SDR UPS07M48930Frame · corrodedINSPECTION TYPE:C FWD CARGO BILGE TRANSVERSE FRAME STA 979, BETWEEN LONG 49 & 50L, CORROSION ON FWD FACE. CORROSION REMOVED AND REPROTECTED AS PER SRM 51-21-01 VOL II REV 38. MAT'L REMOVED 0.003 INCH ORG THK 0.050 INCH THK REMAINING 0.047 INCH FOUND WITHIN LSDR SWAA064878Door Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FWD CARGO DOOR CUTOUT AFT FRAME CRACKED AT NR 5 DOOR STOP. REPAIRED FRAME SECTION PER SRM.SDR SWAA064875Frame · corrodedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 847, STR 26R. REPAIRED FRAME SECTION PER SRM.SDR SWAA064874Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 986.5, STR 7L. REPAIRED FRAME SECTION PER SRM.SDR USAA061407Frame · crackedSTA 727 S14L CRACKED. FRAME REPAIRED WITH FILLER AND DOUBLER IAW EA 98266, DEFECT SIZE: .750 INCH.SDR USAA061413Frame · crackedSTA 380 FRAME AT UPPER FLANGE BETWEEN STR S20L AND S21L CRACKED. REMOVED DAMAGE AND INSTALLED REPAIR PARTS IAW SRM 51-70-11, DEFECT SIZE: 1 INCH.SDR USAA061408Frame · crackedBS 597 RBL 64 CRACKED. INSTALLED DOUBLER IAW EA 97276, DEFECT SIZE: .5 INCH.SDR USAA061409Frame · crackedSTA 520 BETWEEN S8L AND S9L CRACKED. FABRICATED FRAME DOUBLER IAW TR 53-10-20D, DEFECT SIZE: .375 INCH.SDR SIMA200634604Frame · chafedFRAME 81 CHAFED. REMOVED AND REPLACED FRAME IAW EMB SRM 51-40-02. RETURNED AIRCRAFT TO SERVICE.SDR 06FDEA04196Frame · damagedLT FOWARD CABIN, FRAME WEB BETWEEN STR 3L AND 4L HAS (7 EA.) UNPLUGGED HOLES. REMOVED DAMAGED AND REPAIRED WITH A FORMED SECTION REPAIR REF. SRM 51-40-03 PG 1-6.SDR 06FDEA04191Frame · gougedCOMPLY WITH EA 6-5310-102004 FUSELAGE-MAINFRAME- REWORK OF 2 GOUGES ON FS 27 RING FRAME. COMPLIED WITH EA 6-5310-102004 FUSELAGE MAIN FRAME 2 GOUES ON FS 27.
Back to JASC 5311