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 SWAA085691Floorbeam · corrodedDURING SCHEDULED 18Y CHECK, FOUND FLOORBEAM CORRODED AT BS 986, RBL 47, WL 208. REPAIRED BEAM PER SRM.SDR SWAA085722Cover · looseFOUND AFT EMERGENCY EXIT LENS COVER LOOSE. SECURED COVER PER MM.SDR SWAA085723Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BETWEEN BS 967 TO BS 986, STR 20L. REPAIRED SKIN PER SRM.SDR SWAA085653Floorbeam · crackedDURING SCHEDULED 18Y CHECK, FOUND FLOORBEAM CRACKED AT BS 312, LBL 54. REPAIRED BEAM PER SRM.SDR SWAA085692Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 425, STR 1R. REPAIRED SKIN PER SWA EA.SDR SWAA085652Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 434, STR 1. REPAIRED SKIN PER SWA EA.SDR SWAA085609Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 800, STR 18L. REPAIRED SKIN PER SWA EA.SDR SWAA085574Skin · crackedDURING SCHEDULED 18Y CHECK, FOUND EQUIPMENT COOLING EXHAUST SKIN CUTOUT CRACKED AT BS 379, LBL 1.5. REPAIRED SKIN PER AAR EA.SDR SWAA085573Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 277, STR 10R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA085546Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FRAME CRACKED AT BS 328, BETWEEN STR 21R TO STR 20R. REPAIRED FRAME PER SRM.SDR SWAA085545Stringer Clip · damagedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP DAMAGED AT BS 277, STR 7R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA085544Skin · crackedDURING SCHEDULED 18Y CHECK, FOUND R1 DOOR FUSELAGE SKIN LOWER EXTERNAL HINGE CUTOUT CRACKED. REPAIRED SKIN PER AAR EA.SDR SWAA085477Shear Tie · crackedDURING SCHEDULED 18Y CHECK, FOUND SHEAR TIE CRACKED AT BS 540, CENTER TANK LT FRONT SPAR. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA085452Door Frame · crackedDURING SCHEDULED HC2 CHECK, FOUND R1 DOOR FRAME CRACKED AT AFT LOWER CORNER. REMOVED AND REPLACED FRAME PER MM.SDR SWAA085448Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND SKIN CRACKED AT BS 380, STR 15R. REPAIRED SKIN PER SRM.SDR SWAA085447Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND SKIN CRACKED AT BS 520, STR 16L. REPAIRED SKIN PER SRM.SDR SWAA085402Frame · crackedFOUND SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 20R. REPAIRED FRAME PER SRM.SDR SWAA085413Crease Beam · corrodedDURING SCHEDULED 18Y CHECK, FOUND LT CREASE BEAM CORRODED BETWEEN BS 312 TO BS 344. REMOVED AND REPLACED BEAM PER SRM.SDR SWAA085400Mount Bracket · crackedDURING SCHEDULED 18Y CHECK, FOUND R2 EMERGENCY ESCAPE SLIDE AFT MOUNT BRACKET CRACKED. REMOVED AND REPLACED BRACKET PER SRM.SDR SWAA085391Door Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND L1 DOOR AFT FRAME CRACKED AT NR 5 STOP FITTING FROM BOTTOM. REPAIRED FRAME PER SRM.SDR SWAA085371Crease Beam · crackedDURING SCHEDULED 18Y CHECK, FOUND LT CREASE BEAM CRACKED BETWEEN BS 346 TO BS 347. REMOVED AND REPLACED BEAM PER SRM.SDR SWAA085370Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS. 294.5, STR 11L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA085315Skin · crackedDURING SCHEDULED 16Y CHECK, FOUND BELLY SKIN CRACKED AT BS 450, BL 0 TO RBL 1.5. REPAIRED SKIN PER PAE ER.SDR SWAA085314Skin · crackedDURING SCHEDULED 16Y CHECK, FOUND BELLY SKIN CRACKED AT BS 410, AFT BL 0. REPAIRED SKIN PER PAE ER.SDR SWAA085313Skin · crackedDURING SCHEDULED 16Y CHECK, FOUND BELLY SKIN CRACKED AT BS 390, RBL 1.5 TO RBL 3 AFT. REPAIRED SKIN PER PAE ER.SDR SWAA085312Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 440, STR 14R TO STR 15R. REPAIRED PER AAR EA.SDR SWAA085214Slide · unwanted deployL1 EMERGENCY EXIT DOOR SLIDE INADVERTENTLY DEPLOYED. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA085231Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT FWD FUSE BS 400, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA085230Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 344, STR 22R TO 23R. REPAIRED SKIN PER SRM.SDR SWAA085186Power Supply · dischargedDURING SCHEDULED MV2 CHECK, FOUND RT EXTERIOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT POWER SUPPLY PER MM.SDR SWAA085095Skin · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE SKIN CRACKED AT RADIO ALTIMETER ANTENNA CUTOUT AT BS 450, BL 0. REPAIRED SKIN PER ER.SDR SWAA085100Bulkhead · crackedDURING SCHEDULED 18Y CHECK, FOUND VERTICAL BEAM WEB CRACKED AT BS 178, RBL 5.7, WL 183. REPAIRED WEB PER ER.SDR SWAA085099Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA085098Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727A, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA085097Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 597, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA085096Skin · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE SKIN CRACK AT FWD ENTRY DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER ER.SDR SWAA085044Battery Pack · dischargedDURING SCHEDULED MV2 CHECK, FOUND R1 DOOR EMERGENCY EXIT EXTERIOR LIGHT INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA084994Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA084993Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8R AND STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA084992Skin · delaminatedDURING SCHEDULED 18Y CHECK, FOUND RT WING OUTBOARD T/E AFT FLAP INBOARD END DELAMINATED. REPAIRED FLAP PER SRM.SDR SWAA084991Skin · delaminatedDURING SCHEDULED 18Y CHECK, FOUND LT WING NR 1 L/E SLAT AFT INBOARD CORNER DELAMINATED. REPAIRED SLAT PER SRM.SDR SWAA084883Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA084783Slide · low pressureDURING SCHEDULED MV2 CHECK, L2 DOOR EMERGENCY EVAC SLIDE PRESSURE GAUGE INDICATED OUT OF LIMITS. REMOVED AND REPLACED EVAC SLIDE PER MM.SDR SWAA084699Fan · faultyDIVERSION - FLIGHT CREW REPORTED STRONG BURNING ODOR IN CABIN. BURNING ODOR DISSIPATED AFTER GASPER FAN TURNED OFF. REMOVED AND REPLACED GASPER FAN PER MM.SDR SWAA084630Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND AFT CARGO DOOR CUTOUT AFT FRAME CRACKED AT NR 3 STOP FITTING. REPAIRED FRAME PER ACO.SDR SWAA084672Attach Fitting · crackedDURING SCHEDULED MV2 CHECK, FOUND LT WING NR 3 GROUND SPOILER INBOARD ATTACH FITTING CRACKED. REMOVED AND REPLACED SPOILER PER MM.SDR SWAA084613Slide · out of adjustL2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA084590Skin · crackedDURING SCHEDULED BRDG CHECK, FOUND RT HORIZONTAL STABILIZER LOWER SKIN CRACKED AT STA 125. REPAIRED SKIN PER EA.SDR SWAA084589Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 806, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA084588Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND FWD CARGO DOOR SKIN CRACKED AT DOOR HANDLE CUTOUT. REPAIRED SKIN PER SWA EA.
Back to Boeing 737-5H4