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 2005UALA01327Frame · crackedCABIN FRAME CRACKED STA 867 BETWEEN STRINGERS 8 - 9 LEFT AT PSU ATTACH. MAJOR REPAIR ACP'D PER MM 53-10-84 REPAIR III.SDR 2005UALA01326Frame · crackedCABIN FRAME CRACKED STA 867 BETWEEN STRINGERS 8 - 9 RIGHT AT PSU ATTACH. MAJOR REPAIR ACP'D PER MM 53-10-84 REPAIR III.SDR 2005UALA01325Frame · crackedCABIN FRAME CRACKED AT STA 827 STR 8L AT PSU ATTACH. MAJOR REPAIR ACP'D PER MM 53-10-84 REPAIR III.SDR 2005UALA01324Frame · crackedLEFT CABIN STA 907 FRAME IS CRACKED BETWEEN STRINGERS 8 - 9 LEFT AT PSU SUPPORT BRACKET ATTACH. MAJOR REPAIR ACP'D PER MM 53-10-84 REPAIR III.SDR 2005UALA01323Frame · crackedRIGHT AFT CABIN FRAME STA 907 CRACKED BETWEEN STRINGERS 8 & 9 RIGHT AT PSU ATTACH. MAJOR REPAIR ACP'D PER MM 53-10-84 REPAIR III.SDR 2005UALA01322Frame · crackedLEFT CABIN STA 440 FRAME IS CRACKED BETWEEN STR 8 & 9 LEFT AT PSU SUPPORT BRACKET ATTACH. MAJOR REPAIR ACP'D PER MM 53-10-84 REPAIR III.SDR 2005UALA01321Frame · crackedRIGHT CABIN STA 440 FRAME IS CRACKED BETWEEN STRINGERS 8R & 9R AT PSU SUPPORT BRACKET ATTACH. REPAIRED FRAME REF MM53-10 -84, REPAIR III.SDR SWAA053738Shear Tie · corrodedDURING SCHEDULED D-CHECK, FOUND FUSELAGE SHEAR TIE CORRODED AT BS 500A, RBL 1. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA053729Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 20L. REPAIRED FRAME PER SWA EA.SDR SWAA053728Shear Tie · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE SHEAR TIE CRACKED AT BS 277, STR 11R. REPAIRED SHEAR TIE PER SRM.SDR ASAA0540674Frame · corrodedPAE: CORROSION ON LOWER FRAME CHORD AT BSTA 767, STR 25R TO 26 R. REMOVED AND REPLACED SHEAR TIE IAW SRM. (K)SDR ASAA0540675Frame · corrodedPAE - FOUND CORROSION ON LOWER FRAME CHORD AT BS S500F, STRINGER 25R TO 26R. REMOVED AND REPLACED SHEAR TIE IAW B737-400 SRM 53-00-07. (M)SDR ASAA0540673Frame · corrodedPAE - FOUND CORROSION ON LOWER FRAME CHORD AT BS 767, STRINGER 26R TO 27R. REMOVED AND REPLACED CHORD IAW B737-400 SRM 53-00-07. (M)SDR ASAA0540672Frame · misdrilledPAE - FOUND MISDRILLED HOLE IN FRAME UPPER FLANGE RADIUS AT BS 867, RBL 22, WL 160. REPAIRED IAW B737-400 SRM 51-70-11. (M)SDR ASAA0540671Frame · dentedPAE - FOUND DENT AT BS 727F, STRINGER 24R-25R IN FRAME. CUTOUT DAMAGE AND INSTALLED REPAIR DOUBLER IAW B737-400 SRM 51-70-11. (M)SDR ASAA0540670Frame · corrodedPAE - FOUND CORROSION LOWER FRAME CHORD AT FS 747 CORRODED FROM STRINGER 25L TO STRINGER 26L. REPAIRED BY FABRICATING AND INSTALLING REPAIR AT BS 747, STRINGER 25L TO STRINGER 26L, IAW B737-400 SRM 53-00-07. (M)SDR 0501679617Door Frame · crackedDURING L-CHECK FOUND CRACK IN AFT LOWER CORNER OF FORWARD SERVICE DOOR FRAME. REPAIRED PER EA 96-204718.SDR SWAA053716Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT FWD CARGO DOOR CUTOUT, FWD FRAME NR 5 STOP FITTING. REPAIRED FRAME PER BFG ER.SDR SWAA053714Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 616, RBL 65, WL 201. REPAIRED FRAME PER BFG ER.SDR SWAA053709Beltframe · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE BELTFRAME CRACKED AT BS 482, STR 21L. REPAIRED BELTFRAME PER SWA EA.SDR SWAA053708Beltframe · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE BELTFRAME CRACKED AT BS 482A, STR 21L. REPAIRED BELTFRAME PER SWA EA.SDR SWAA053707Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT FWD CARGO DOOR CUTOUT, AFT FRAME LOWER STOP FITTING. REPAIRED FRAME PER SWA EA.SDR SWAA053703Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500B, STR 20R. REPAIRED FRAME PER SWA EA.SDR 05FDEA03932Frame · dentedFOUND FRAME DENT AT BS 560 ABOVE STR 24L. REPAIRED FRAME AT BS 560 STR 24L IAW SRM 51-40-3.SDR 05FDEA03931Frame · dentedFRAME DENT AT BS 500, ABOVE STR 23L. TRIMED DAMAGE, FABRICATED AND INSTALLED DOUBLER PER SRM 51-40-3.SDR ASAA0540685Frame · crackedYXX - FOUND CRACKED FRAME AT BS 360, STRINGER 8 LEFT. REPAIRED FRAME IAW B737-400 SRM 53-00-07 FIG 201. (M)SDR 05FDEA03923Frame · corrodedCORROSION AT FRAME STA BS 480 AT LBL 12, TOP OF FRAME. REMOVED DAMAGED SECTION OF BEAM. FABRICATED "T" CAP REPAIR SECTION, SUPPORT ANGLES, AND REINFORCEMENT STRAPS IAW B727 SRM 53-10-8 FIGURE 3. ALODINED AND PRIMED REPAIR PARTS IAW B727 SRM 51-10-2. INSTALSDR SWAA053688Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT FWD CARGO DOOR CUTOUT, AFT FRAME NR 2 STOP FITTING. REPAIRED FRAME PER SRM.SDR SWAA053684Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE FRAME CRACKED AT AFT CARGO DOOR CUTOUT, FWD FRAME NR 5 STOP FITTING. REPAIRED FRAME PER SRM.SDR SWAA053683Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE FRAME CRACKED AT FWD CARGO DOOR CUTOUT, FWD FRAME LOWER CORNER. REPAIRED FRAME PER BFG ER.SDR AWXA200501517Frame · crackedMCN - DURING C19 CHECK DISCOVERED ANGLE CRACKED, 1.5 INCHES IN LENGTH, AT BS 178, WL 207 AND BL 29R. MAINTENANCE CUT OUT DAMAGED SECTION OF CHORD AT BS 178, WL 207 AND BL 29R IAW AMERICA WEST AIRLINES (AWA) ENGINEERING REPAIR (ER) NR 03-5300-05341-ES1. FABRISDR SWAA053675Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE STUB FRAME CRACKED AT BS 188, LT SIDE, WL 208. REMOVED AND REPLACED STUB FRAME PER SRM.SDR SWAA053674Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 1R. REPAIRED FRAME PER SRM.SDR SWAA053673Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE STUB FRAME CRACKED AT BS 188, RT SIDE, WL 207. REPAIRED STUB FRAME PER SRM.SDR SWAA053670Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 8L TO STR 9L. REPAIRED FRAME PER SRM.SDR SWAA053691Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D, STR 8L TO STR 9L. REPAIRED FRAME PER SRM.SDR SWAA053690Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D, STR 8R TO STR 9R. REPAIRED FRAME PER SRM.SDR 05FDEA03866Repair · unknownMAIN CARGO COMPT AT STA 675 L12 RT FOUND FRAME WITH REPAIR DOUBLER 11 X 3 INCHES AND FLUSH REPAIR Z 60 X 92. STRIPPED AREA IAW SRM 51-21-01 PAR 33 VOL 1. REMOVED AND REPLACED FASTENERS AS REQ ON SRM 53-30-00 FIG 4 VOL 1. TREATED AND PROTECTED AREA IAW SRM 5SDR SWIA200516320Frame · crackedFS 640 FRAME LT SIDE HAD 3' CRACK IN REINFORCEMENT ANGLE, ITEM FOUND AT C-CHECK INSPECTION. INSTALLED AT LT FS 640 BETWEEN LT STRINGER 6-12 FRAME SECTION SPLICE ANGLE AND FILLER IAW REO 601R 53-61-487 REV 'C'.SDR SWIA200516319Frame · crackedFS 640 FRAME RT SIDE HAS 2' CRACK IN REINFORCEMENT ANGLE, ITEM FOUND AT C-CHECK INSPECTION. INSTALLED FRAME SECTION REPAIR PARTS TO RT FS 640 IAW CRJ200 SRM 51-42-6; 51-42-20; AND 51-42-21.SDR SWIA200516318Frame · crackedAFT CARGO FS623 RT OTBD SIDE FRAME CRACKED, ITEM FOUND AT C-CHECK INSPECTION. INSTALLED REPAIR TO FS 621 RIGHT OTBD SIDE FRAME IAW REO 601R-53-61-117.SDR SWIA200516317Frame · crackedAFT CARGO FS621 LT SIDE OTBD FRAME CRACKED, ITEM FOUND AT C-CHECK INSPECTION. INSTALLED REPAIR ANGLES PER REO 601R-53-61-117 SHTS 1 THRU 3 REV 'B'.SDR ASAA0540662Frame · corrodedPAE - AFT CARGO BAY ODOR FRAME DOUBLER, BS 849, RBL 28, CORRODED. REPLACED FRAME ASSY PER B737-400 SRM 51-40-02. (M)SDR ASAA0540661Frame · corrodedPAE - FOUND CORROSION ON FRAME UPPER CHORD. REPAIRED PER B737-400 SRM 51-70-11. (M)SDR ASAA0540660Frame · corrodedPAE - FOUND FRAME CORRODED AT BS 727E, LBL 20. REPAIRED PER B737-400 SRM 53-00-07. (M)SDR ASAA0540659Frame · dentedPAE - FOUND DENT IN FRAME AT BS 500E, STRINGER 24R. REPAIRED DENT PER B737-400 SRM 51-70-11 AND 53-30-53. (M)SDR SWAA053663Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8L. REPAIRED FRAME PER SRM.SDR SWAA053662Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 8R. REPAIRED FRAME PER SRM.SDR AWXA200501518Frame · crackedMCN - DURING C19 CHECK DISCOVERED FRAME CRACKED, 2.2 INCHES IN LENGTH, AT BS 188, WL 200 AND BL 31R. MAINTENANCE CUT OUT DAMAGED SECTION OF FRAME FLANGE AND CHORD AT BS 188, WL 200 AND BL 31R IAW AMERICA WEST AIRLINES (AWA) ENGINEERING REPAIR (ER) NR 03-5300-SDR AWXA200501501Frame · crackedMCN - DURING C19 CHECK DISCOVERED BS 188 FRAME CRACKED, 2.0 INCHES, IN THE OUTBOARD RADIUS AT WL 208 AND BL 31L. MAINTENANCE TRIMMED OUT CRACK IAW BOEING 737-300 SRM 53-00-07 FIG 201. FABRICATED REPAIR ANGLE AND FILLERS IAW BOEING 737-300 SRM 53-00-07 FIG 20
Back to JASC 5311