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 ASAA0945721Frame · damagedFCB FRAME HAS DAMAGE AT NUTPLATES BS 500D STR 22R 25R. REMOVED AND REPLACED SPLICE CHANNEL PER SRM.SDR ASAA0945498Frame · damagedFCB FRAME HAS DAMAGE AT NUTPLATES BS 500D S22-25R. REMOVED AND REPLACED SPLICE CHANNEL PER SRM.SDR SWAA092784Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME WEB CRACKED AT BS 303, STR 16L. REPAIRED FRAME PER SRM.SDR SWAA092780Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND INTERIOR FRAME WEB CRACKED AT BS 291, STR 16R. REPAIRED WEB PER SRM.SDR SWAA092777Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 747, STR 8L. REPAIRED FRAME PER EA.SDR SWAA092776Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 480, STR 8L. REPAIRED FRAME PER EA.SDR SWAA092769Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 500B, STR 16R. REPAIRED FRAME PER SRM.SDR SWAA092766Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FRAME CORRODED AT BS 500, BETWEEN STR 28R TO STR 27R. REPAIRED FRAME PER SRM.SDR COMA2009050550129Frame · crackedLEFT FS 640.00 FRAME AND BONDED SKIN DOUBLER ARE CRACKED BETWEEN STRINGER 9 AND 13. REMOVED DAMAGED PARTS AND COMPLIED WITH MODIFICATION K601R36009-3 ON LT FS. 640.00 FRAME AND DOUBLER PER S/B 601R-53-061KIT DRWG K601R36009 REV B, 601R-53-61-506 REV C AND 601SDR C2XA09SH140Frame · crackedSHV - DURING C-CHECK FRAME 10 JUST ABOVE STR 10R CRACKED BELOW DV WINDOW CUTOUT. MAINTENANCE REMOVED AND INSTALLED NEW FRAME 10 CHANNEL AT FRAME 10 JUST BELOW DV WINDOW CUTOUT AND JUST ABOVE STR 10R IAW EMB-145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED TO RETUSDR C2XA09SH138Frame · crackedSHV - DURING C-CHECK FRAME 10 JUST ABOVE STR 10L CRACKED BELOW DV WINDOW CUTOUT. MAINTENANCE REMOVED AND INSTALLED NEW FRAME 10 CHANNEL AT FRAME 10 STRINGER 10L BELOW DV WINDOW CUTOUT IAW EMB-145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR IPXA09556168Frame · dentedINSPECTION TYPE:C DENT IN AFT CARGO COMPARTMENT FUSELAGE FRAME STA 1300, S-26R. DENT FOUND OUT OF LIMITS IAW SRM 53-00-07-1A, FIG 101, SH 1. REMOVED EXISTING REPAIR LOC BETWEEN S-25R & 26R PER EA757-5362-27-A1868. HFEC EXISTING AND DAMAGE CUT OUT + EXISTINGSDR IPXA09556119Frame · dentedINSPECTION TYPE:C FUSELAGE FRAME PUNCTURED IN AFT CARGO COMPARTMENT STA 1400, BETWEEN S-25L AND S-26L, 2 EA. DAMAGE WAS FOUND OUT OF LIMITS IAW SRM 53-00-07-1A FIG 101. CUT OUT DAMAGE AT TWO EACH LOCATIONS IAW SRM 53-00-07-2R5. HFEC AT CUTOUT + FASTENER HOLSDR IPXA09555977Frame · dentedINSPECTION TYPE:C DENT IN AFT CARGO COMPARTMENT FUSELAGE FRAME AT STA 1500, S-26L. REMOVED TRANSITION PANEL IAW SRM 51-40-02 2. DENT FOUND TO BE OUT OF LIMIT IAW SRM53-00-01A FIG 101. HFEC AT CUT OUT HOLES IAW NTM 51-00-01PT6/16PT6, NO CRACKS FOUND. FABRICSDR IPXA09555976Frame · dentedINSPECTION TYPE:C DENT IN AFT CARGO COMPARTMENT FUSELAGE FRAME STA 1480, S-26L . DENT FOUND TO BE OUT OF LIMITS IAW SRM 51-00-07-01A FIG 101. CUT OUT DAMAGE IAW SRM 53-00-07-2R5 FIG 201. HFEC CUT OUT HOLES IAW NTM 51-00-01PT6/16PT6. FAB REPAIR PARTS PER MASDR IPXA09555975Frame · dentedINSPECTION TYPE:C DENT IN AFT CARGO COMPARTMENT FUSELAGE FRAME AT STA1320, BTWN S-25R AN S-26R. DENT FOUND TO BE OUT OF LIMITS IAW SRM 53-00-07-1A FIG 101. HFEC CUT OUT AND EXIST HOLES PER NTM51-00-01PT6/19PT6. FAB REPAIR PARTS PER MAE TR T9/791363 7075-O HSDR IPXA09555971Frame · dentedINSPECTION TYPE:C DENT IN AFT CARGO COMPARTMENT FUSELAGE FRAME STA1280, S25L, DENT FUS FRAME FOUND TO BE OUT OF LIMITS IAW SRM 53-00-07-1A FIG 101 2. CUT OUT DAMAGE IAW SRM 53-00-07-2R5, AND EA 757-5362-27-A1869. HFEC CUT OUT AND EXISTING HOLES IAW NTM51-00-SDR SWAA092759Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 727C, STR 13L. REPAIRED FRAME PER AAR EA.SDR SWAA092758Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 559, STR 13R. REPAIRED FRAME PER AAR EA.SDR SWAA092750Frame · corrodedDURING SCHEDULED 20Y CHECK, FOUND FAIL SAFE FRAME CHORD CORRODED AT BS 727B, BETWEEN STR 26L TO STR 27L. REPAIRED FRAME PER SRM.SDR FDEA200904301489Frame · damagedFRAME AT STA 980, HAS MISDRILLED HOLES BETWEEN STR 3L-3R. CUT OUT DAMAGE SECTION OF FRAME IAW SRM 53-00-07. FABRICATED NEW FRAME SECTION MAE TRAV NR T9/787791, MAT- 7075-0.090C, IAW SRM 53-40-07. INSTALLED FRAME SECTION, STA 980, STR 5L-5R, IAW SRM 53-00-07SDR FDEA200904301488Frame · misalignedFRAME STA 1120, STR 3L-3R, HAVE MISDRILLED HOLES. CUT OUT DAMAGE FRAME SECTION IAW SRM 53-00-07. FABRICATED NEW FRAME SECTION MAE TRAV NR T9/787790, MAT- 7075-0.080C, IAW SRM 53-40-07. INSTALLED FRAME SECTION STA 1120, STR 5L-5R, IAW SRM 53-00-07. REPAIR NSDR FDEA200904301487Frame · damagedFRAME STA 1100, STR 3L-3R, HAVE MISDRILLED HOLES. CUT OUT DAMAGE FRAME SECTION IAW SRM 53-00-07. FABRICATED NEW FRAME SECTION MAE TRAV NR T9/787788, MAT 7075-0.080C, IAW SRM 53-40-07. INSTALLED FRAME SECTION STA 1100, STR 5L-5R, IAW SRM 53-00-07. REPAIR NRSDR FDEA200904301486Frame · misalignedFRAME STA 1140, STR 3L-3R, HAVE MISDRILLED HOLES. CUT OUT DAMAGE IAW SRM 53-00-07. FABRICATED FRAME SECTION MAT- 7075-0.080C, IAW SRM 53-00-07. INSTALLED FRAME SECTION STA 1140, STR 5L-5R, IAW SRM 53-00-07. REPAIR NR 1, CATEGORY A, MAJOR REPAIR.SDR FDEA200904301485Frame · damagedFRAME STA 1020, STR 3L-3R, HAS MISDRILLED HOLES. CUT OUT DAMAGE IAW SRM 53-00-07. FABRICATED FRAME SECTION MAE TRAV NR T9/787913, IAW SRM 51-40-05. INSTALLED ALL REPAIR PARTS STA 1020, STR 5L-5R, IAW SRM 53-00-07, REPAIR NR 1, CATEGORY A, MAJOR REPAIR.SDR ASAA0945390Frame · corrodedAFT CARGO FRAME REPLACEMENT. REPLACED FRAME.SDR SWAA092717Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 400, STR 13R. REPAIRED FRAME PER ER.SDR CALA2009043000229Frame · corrodedFRAME AT STATION 1460 WL 144 TO WL 138.50, LBL 9 TO RBL 9 HAS INTERGRANULAR CORROSION. REMOVED AND REPLACED FRAME AT STATION 1460 WL 144 TO WL 138.50 PER SRM 51-40-02 AND BOEING PRINTS 146N1014.SDR AALA20090504TUL02Frame · corrodedCABIN FLOORBEAM HAS CORROSION AT STATION 1640 RIGHT BODY LINE 42 TO LEFT BODY LINE 17. REMOVED AND REPLACED FLOORBEAM UPPER CHORD RIGHT BODY LINE 42 TO LEFT BODY LINE 17 PER SRM 53-00-51-2R.SDR WX0A070297Frame · crackedCANT FRAME AT STA 1510 CRACKED AT LT TAILCONE ALIGNMENT PIN APPROXIMATELY AT 7 O'CLOCK.SDR ASAA0945372Frame · crackedFWD FRAME OF AFT CARGO COMPT. CUT OUT HAS A CRACK IN FRAME AT STOP FITTING HOLE BETWEEN STR 21 22 APPROX .375 INCH LONG (BS 794 FRAME). REMOVED AND REPLACED FRAME.SDR SWAA092709Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 291.5, BETWEEN WL 232 TO WL 234 RT SIDE. REPAIRED FRAME PER ER.SDR SWAA092696Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 291.5, WL 258 RT SIDE. REPAIRED FRAME PER SWA EA.SDR SWAA092694Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 360, STR 20R. REPAIRED FRAME PER SWA EA.SDR AALA20090501TUL06Frame · crackedCRACK IN FRAME AT FASTENER HOLE AT AIR CONDITIONING RAIL ATTACH POINT AT LEFT STATION 400. LENGTH OF CRACK NOT SPECIFIED BY NDT. REPAIRED PER J1159AB.SDR AALA20090501TUL05Frame · crackedCRACK IN FRAME AT FASTENER HOLE AT AIR CONDITIONING RAIL ATTACH POINT AT LEFT STATION 480. LENGTH OF CRACK NOT SPECIFIED BY NDT. REPAIRED PER J1159AB.SDR AALA20090501TUL04Frame · crackedCRACK IN FRAME AT FASTENER HOLE AT AIR CONDITIONING RAIL ATTACH POINT AT LEFT STATION 727B. LENGTH OF CRACK NOT SPECIFIED BY NDT. REPAIRED PER J1159AB.SDR AALA20090501TUL03Frame · crackedCRACK IN FRAME AT FASTENER HOLE AT AIR CONDITIONING RAIL ATTACH POINT AT LEFT STATION 480. LENGTH OF CRACK NOT SPECIFIED BY NDT. REPAIRED PER J1159AB.SDR AALA20090501TUL02Frame · crackedCRACK IN FRAME AT FASTENER HOLE AT AIR CONDITIONING RAIL ATTACH POINT AT LEFT STATION 727B. LENGTH OF CRACK NOT SPECIFIED BY NDT. REPAIRED PER J1159AB.SDR AALA20090501TUL01Frame · crackedCRACK IN FRAME AT FASTENER HOLE AT AIR CONDITIONING RAIL ATTACH POINT AT LEFT STATION 400. LENGTH OF CRACK NOT SPECIFIED BY NDT. REPAIRED PER J1159AB.SDR AALA20090430TUL13Frame · crackedCRACK IN FRAME AT FASTENER HOLE AT AIR CONDITIONING RAIL ATTACH POINT AT RIGHT STATION 480. LENGTH OF CRACK NOT SPECIFIED BY NDT. REPAIRED PER J1159AB.SDR AALA20090430TUL12Frame · crackedCRACK IN FRAME AT FASTENER HOLE AT AIR CONDITIONING RAIL ATTACH POINT AT RIGHT STATION 440. LENGTH OF CRACK NOT SPECIFIED BY NDT. REPAIRED PER J1159ABSDR AALA20090430TUL10Frame · crackedCRACK IN FRAME AT FASTENER HOLE AT AIR CONDITIONING RAIL ATTACH POINT AT RIGHT STATION 500A. LENGTH OF CRACK NOT SPECIFIED BY NDT. REPAIRED PER J1159ABSDR AALA20090430TUL09Frame · crackedCRACK IN FRAME AT FASTENER HOLE AT AIR CONDITIONING RAIL ATTACH POINT AT RIGHT STATION 500C. LENGTH OF CRACK NOT SPECIFIED BY NDT. REPAIRED PER J1159ABSDR AALA20090430TUL08Frame · crackedCRACK IN FRAME AT FASTENER HOLE AT AIR CONDITIONING RAIL ATTACH POINT AT LEFT STATION 500F. LENGTH OF CRACK NOT SPECIFIED BY NDT. REPAIRED PER J1159ABSDR AALA20090430TUL07Frame · crackedCRACK IN FRAME AT FASTENER HOLE AT AIR CONDITIONING RAIL ATTACH POINT AT LEFT STATION 380. LENGTH OF CRACK NOT SPECIFIED BY NDT. REPAIRED PER J1159ABSDR AALA20090430TUL02Frame · crackedCRACK AT FASTENER HOLE ON RIGHT 727B FRAME AT AIR CONDITIONING ATTACH POINT. CRACK LENGTH NOT NOTED BY HHEC INSPECTOR. REPAIRED PER J1159ABSDR ASAA0945351Frame · damagedDRILL START ON FRAME DOUBLER. REMOVED DRILL START ON BS 500A DOUBLER FWD FACE.SDR ASAA0945350Frame · damagedDAMAGED EDGE OF FRAME FLANGE. REMOVED DAMAGED.SDR ASAA0945347Frame · damagedFORWARD CARGO BAY BS 440 FRAME UPPER SURFACE HAS DAMAGE IN RADIUS. REMOVED AND REPLACED FRAME PER DWG 65-20727.
Back to JASC 5311