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 SWAA092689Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 807, STR 13L. REPAIRED FRAME PER SWA EA.SDR SWAA092688Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 887, BETWEEN STR 13R TO STR 14R. REPAIRED FRAME PER SWA EA.SDR SWAA092687Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 480, STR 13L. REPAIRED FRAME PER SWA EA.SDR SWAA092686Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 360, STR 13R. REPAIRED FRAME PER SWA EA.SDR SWAA092682Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 827, BETWEEN STR 13R TO STR 14R WL 234. REPAIRED FRAME PER SWA EA.SDR SWAA092681Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 827, BETWEEN STR 13R TO STR 14R WL 233. REPAIRED FRAME PER SWA EA.SDR AALA20090430TUL03Frame · wornFORWARD CABIN BELTFRAME WORN AT STATION 344 AFT LOWER RADIUS BELOW STRINGER 2L. INSTALLED BELT FRAME REPAIR PER SRM 53-00-07-2R.SDR WX0A070296Frame · crackedSTA 1463 CANT FRAME WEB CRACKED, ABOVE LT LOWER BOXSDR USAA2009050191059Frame · crackedSAL - Q6 - MAJOR REPAIR - CRACK ON FUSELAGE FRAME AT BS 500C BETWEEN S20L TO S21L. REPAIRED FUSELAGE FRAME AT BS500C BETWEEN S20L TO S21L IAW B737 SRM 53-00-07 REPAIR 13.SDR SWAA092706Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 400, STR 13R. REPAIRED FRAME PER SWA EA.SDR C2XA09TY073Frame · crackedTYS - DURING A CURRENT 6C INSPECTION, FOUND A CRACK IN THE COCKPIT AT FR 10L NEAR STR 10 AT THE UPPER END OF THE DV WINDOW CUTOUT. MAINTENANCE REMOVED THE FRAME AND REPAIRED THE FRAME IAW IC 2009-145/03148 AND INSTALL THE FRAME IAW SRM 51-40-02. ALL WORK WASSDR C2XA09TY072Frame · crackedTYS - DURING A CURRENT 6C INSPECTION, FOUND A CRACK IN THE COCKPIT AT FR 10 NEAR STR 10 AT THE UPPER END OF THE DV WINDOW CUTOUT. MAINTENANCE REMOVED THE FRAME AND REPAIRED THE FRAME IAW IC 2009-145/03148 AND INSTALL THE FRAME IAW SRM 51-40-02. ALL WORK WAS SDR C2XA09TY071Frame · crackedTYS - DURING A CURRENT 6C INSPECTION, FOUND A CRACK IN THE COCKPIT AT FR 10 AT THE UPPER END OF THE DV WINDOW CUTOUT. MAINTENANCE REMOVED THE FRAME AND REPAIRED THE FRAME IAW IC 2009-145/03148 AND INSTALL THE FRAME IAW SRM 51-40-02. ALL WORK WAS ACCOMPLISHEDSDR CALA2009042700223Frame · crackedCABIN STATION 400 RT FRAME CRACKED BETWEEN STR 8-9 RIGHT. REPAIRED PER ECRA 5310-04933.SDR ASAA0945303Frame · dentedAFT CARGO COMPARTMENT BS 827 FRAME DENTED 2 INCHES ABOVE STR 24L.SDR ASAA0945302Frame · dentedAFT CARGO COMPARTMENT BS 747 FRAME DENTED 2 INCHES ABOVE STR 25L. REMOVED DAMAGED SECTION OF FRAME FABRICATED REPAIR PARTS AND INSTALLED.SDR ASAA0945301Frame · dentedAFT CARGO COMP BS 767 FRAME DENTED 1 INCH ABOVE STR 24R. REMOVED DAMAGED SECTION OF FRAME FABRICATED REPAIR PARTS AND INSTALLED.SDR CALA2009042700221Frame · crackedCABIN STATION 500C RIGHT FRAME CRACKED BETWEEN STR 8-9 RT. REPAIRED PER ECRA 5310-04933.SDR CALA2009042700220Frame · crackedCABIN STATION 500A RIGHT FRAME CRACKED BETWEEN STR 8-9 RT. REPAIRED PER ECRA 5310-04933.SDR CALA2009042700219Frame · crackedCABIN STATION 400 LEFT FRAME CRACKED BETWEEN STR 8-9 LEFT. REPAIRED PER ECRA 5310-04933.SDR CALA2009042700218Frame · crackedCABIN STATION 440 LT FRAME CRACKED BETWEEN STR 8 - 9 LEFT. REPAIRED PER ECRA 5310-04933.SDR FDEA200904251412Frame · damagedFRAME AT STA 800 HAS NUMEROUS MISDRILLED HOLES BETWEEN STRG 3L AND 3R INCOMING CONDITION. CUT OUT DAMAGED FRAME SECTION ON STA 800 STR 5L TO 5R IAW SRM 53-00-07 FIG 201 SHEET 1 REPAIR 1. FABRICATE FRAME SECTION ON TRAVELER NR T9/ 787916. FABRICATED CHANNESDR DL75E090894Frame · dentedAFT CARGO FRAME STA 1480 INBD OF STR 26 LT DENTED AND BULGED. REPAIRED IAW SRM 53-00-07 AT SAA SAT DURING HMV ON NR CARD 107904.SDR DL75E090890Frame · dentedAFT CARGO FRAME AT STA 1420 BETWEEN STR 26 AND 25 LT HAS MULTIPLE DENTS. REPAIRED IAW SRM 53-00-07 AT SAA SAT DURING HMV ON NR CARD 107883.SDR DL75E090885Frame · gougedAFT CARGO FRAME STA 1400 BETWEEN STR 26 AND STR 24 LT HAS GOUGES ON EXISTING REPAIR AND DENT ON FRAME BELOW REPAIR / REPAIRED FRAME IAW SRM 53-00-07 AT SAA SAT DURING HMV ON NR CARD 107884.SDR ASAA0945300Reinforcement · gougedDRILL MARKS ON FRAME REINFORCEMENT CHORD. FAB NEW FRAME MATERIAL TREATED DRILLED AND LOCATED ALODINE AND PRIME.SDR AALA20090424TUL04Frame · corrodedCORROSION ON CABIN FRAME AT STATION 328. CORROSION LEVEL 1. REPLACED FLOOR BEAM UPPER CHORD FROM RIGHT BODY LINE 1.6 TO RIGHT OUTBOARD END PER EA B737-53-006056.SDR ASAA0995229Frame · corrodedAFTER REMOVAL OF CORRODED SHIELD FOUND FRAME STA 787 CORRODED ON UPPER FLANGE BETWEEN STR 25R AND 26R.SDR ASAA0995230Frame · corrodedCORROSION AFT CARGO BAY FRAME AND DOUBLER ASSY BS 767 RBL 23 27 WL 156 158. REMOVED CORROSION PER EA900 53EA 0159.SDR ASAA0995231Frame · corrodedAFTER MOVING FLOOR SUPPORT FOR REPLACEMENT FOUND FRAME CAP BS 7271 ABOVE STR 25 TO BE CORRODED. REMOVED CORROSION PER EA900 53EA 0159.SDR SWAA092625Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 887, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA092624Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA092623Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 807, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA092622Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 767, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA092621Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727C, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA092620Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA092619Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA092618Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA092617Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME PER SWA EA.SDR ASAA0945441Frame · crackedAFTER REMOVAL OF TRANSITION PANEL FOUND FRAME CRACKED AT STA 460 ABOVE STR 25L. REMOVED DAMAGED AREA, FABRICATED, LOCATED, DRILLED DOUBLER, FABRICATED FREEZE PLUG AND INSTALLED REPAIR PARTS IAW B737 400 SRM 53 00 07.SDR SWAA092650Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 303.9, STR 16L. REPAIRED FRAME PER ACO.SDR SWAA092649Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.SDR ASOA200900478Frame · corrodedCORROSION DAMAGE AT FS 364.00 FRAME IN MAIN AVIONICS BAY STGR 25 LT TO STGR 25 RT.SDR ASOA200900477Frame · corrodedCORROSION DAMAGE AT FS 349.00 FRAME IN MAIN AVIONICS BAY STGR 25 LT TO STGR 25 RT.SDR SWAA092603Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 747, STR 13L. REPAIRED FRAME PER AAR EA.SDR SWAA092602Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 440, BETWEEN STR 13L TO STR 14L. REPAIRED FRAME PER AAR EA.SDR SWAA092601Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 420, STR 13R. REPAIRED FRAME PER AAR EA.SDR SWAA092585Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 500, STR 13L. REPAIRED FRAME PER SWA EA.SDR SWAA092584Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 807, BETWEEN STR 13R TO STR 14R. REPAIRED FRAME PER SWA EA.SDR SWAA092583Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 847, AT STR 13L. REPAIRED FRAME PER SWA EA.
Back to JASC 5311