Boeing 737-5H4
Service difficulty reports · 8,230
Newest first. General aviation reporting is voluntary.
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 aircraft_model_key = '7375H4' 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 aircraft_model_key = '7375H4' 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 SWAA052258Lamp · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND L2 DOOR EXTERNAL EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT PER MM.SDR SWAA052231Skin · crackedDURING SCHEDULED A1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 522, STR 10R. REPAIRED SKIN PER SWA EA .SDR SWAA052207Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 774, STR 25L. REPAIRED SKIN PER SRM.SDR SWAA052190Slide · dischargedDURING SCHEDULED RON CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE PRESSURE INDICATING LOW. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA052177Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT L2 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER SWA EA.SDR SWAA052134Slide · dislodgedL1 DOOR EVACUATION SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR SWAA052117Slide · out of positionR2 DOOR EVACUATION SLIDE OUT OF POSITITON. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA051992Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 944, STR 25R. REPAIRED SKIN PER SRM.SDR SWAA051991Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 764, STR 23L. REPAIRED SKIN PER SRM.SDR SWAA051932Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 747, STR 23L. REPAIRED SKIN PER SRM.SDR SWAA051933Battery · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND LT OVERWING EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA051931Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 770, STR 18L. REPAIRED SKIN PER SWA EA.SDR SWAA051930Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 520, STR 10L. REPAIRED SKIN PER SWA EA.SDR SWAA051888Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 259.5, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA051887Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 927, STR 25R. REPAIRED SKIN PER SRM.SDR SWAA051836Beltframe · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE BELT FRAME WEB CRACKED AT BS 1040, LT SIDE BLEED AIR DUCT. REPAIRED BELT FRAME WEB PER SRM.SDR SWAA051798Stringer · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE STRINGER CRACKED AT BS 360, STR 15L. REMOVED AND REPLACED STRINGER SECTION PER SRM.SDR SWAA051803Crease Beam · crackedDURING SCHEDULED 1/2D CHECK, FOUND LT CREASE BEAM WEB CRACKED AT BS 616 TO BS 639, STR 17L. REPAIRED WEB PER SWA EA.SDR SWAA051802Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR LOWER HINGE BOX CUTOUT, BEAR STRAP UPPER CORNER. REMOVED AND REPLACED STRAP PER SRM.SDR SWAA051801Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 294.5, STR 11L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA051800Stringer · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE STRINGER CRACKED AT BS 344, STR 8R. REMOVED AND REPLACED STRINGER SECTION PER SRM.SDR SWAA051799Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 344, STR 10R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA051797Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 520 + 6, STR 10R. REPAIRED SKIN PER SWA EA.SDR SWAA051796Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 870, STR 23R. REPAIRED SKIN PER SRM.SDR SWAA051795Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 400, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA051804Battery · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND LT EMERGENCY OVERWING EXIT LIGHT & CENTER AISLE EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA051775Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME WEB CRACKED AT BS 303, L1 DOOR LOWER STOP FITTING CUTOUT. REPAIRED FRAME PER SRM.SDR SWAA051774Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA051773Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 727A, STR 25L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA051871Bushing · wornIN ALL PHASE OF FLIGHT - VIBRATION FELT & TAIL OSCILLATION. REMOVED AND REPLACED LT ELEVATOR TAB INBOARD HINGE HARDWARE PER MM.SDR SWAA051759Gusset · crackedDURING SCHEDULED 1/2D CHECK, FOUND R1 DOOR AFT LOWER GUSSET CRACKED. REMOVED AND REPLACED GUSSET PER SRM & BAC DRAWING.SDR SWAA051746Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 344, STR 11R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA051731Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT R2 DOOR CUTOUT, FWD LOWER CORNER. REPAIRED SKIN PER SRM.SDR SWAA051730Pressure Panel · crackedDURING SCHEDULED 1/2D CHECK, FOUND NLG W/W CEILING PANEL CRACKED AROUND LT & RT BRAKE MOUNT PADS. REPAIRED PANEL PER SWA EA & SRM.SDR SWAA051729Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 947, STR 25R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA051728Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR CUTOUT, AFT LOWER CORNER. REPAIRED SKIN PER SRM.SDR SWAA051719Rib · crackedDURING SCHEDULED 1/2D CHECK, FOUND RT WING RIB LOWER CHORD CRACKED AT WBL 135.5, BETWEEN STR 2 & STR 3. REPAIRED RIB PER SRM & SWA TASKCARD.SDR SWAA051718Floor Support · crackedDURING SCHEDULED 1/2D CHECK, FOUND 4 EA NR 2 LONGITUDINAL FLOORBEAM CRACKS BETWEEN BS 658 TO BS 673.5, LBL 24.75. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA051717Floor Support · crackedDURING SCHEDULED 1/2D CHECK, FOUND 5 EA NR 3 LONGITUDINAL FLOORBEAM CRACKS BETWEEN BS 658 TO BS 673.5, RBL 24.75. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA051716Beltframe · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE BELTFRAME CRACKED AT BS 1006, STR 17R. REPAIRED BELTFRAME PER SRM.SDR SWAA051715Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 277, STR 16R. REPAIRED FRAME PER SWA EA.SDR SWAA051714Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN CRACKED AT EQUIPMENT COOLING EXHAUST AFT CUTOUT, BS 378.13, LBL 2.80. REPAIRED SKIN PER SWA EA.SDR SWAA051720Light · looseDURING SCHEDULED A2 CHECK, FOUND EMERGENCY BULLNOSE LIGHT LOOSE AT ROW 15 ABC. SECURED LIGHT PER MM.SDR SWAA051703Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 663, STR 10L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA051693Pressure Panel · crackedDURING SCHEDULED 1/2D CHECK, FOUND BEADED PRESSURE WEB CRACKED AT BS 663, LBL 30. REPAIRED WEB PER SRM.SDR SWAA051684Battery Pack · inoperativeDURING SCHEDULED SPECIAL VISIT, FOUND FWD, CENTER & AFT CABIN EMERGENCY LIGHTS INOP. REMOVED AND REPLACED BATTERY PACKS PER MM.SDR SWAA051683Ballast · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND RT OVERWING EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BALLAST PER MM.SDR SWAA051634Flap · delaminatedDURING SCHEDULED A2 CHECK, FOUND LT WING OUTBOARD T/E AFT FLAP DELAMINATED. REMOVED AND REPLACED AFT FLAP PER MM.SDR SWAA051616Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND 4 EA FUSELAGE SKIN CRACKS AT BS 749, STR 18L, BS 772, STR 18L, BS 780, STR 17L & BS 784, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA051589Power Supply · dischargedDURING SCHEDULED A2 CHECK, AFT CABIN EMERGENCY LIGHTS INOP WHEN POWER REMOVED. REMOVED AND REPLACED AFT POWER SUPPLY PER MM.
Back to Boeing 737-5H4