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 SWAA081127Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 616, STR 5L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081103Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 380, STR 15R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081111Shear Tie · crackedDURING SCHEDULED 16Y CHECK, FOUND SHEAR TIE CRACKED AT BS 559, STR 17R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA081112Stringer · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER 15L CRACKED AT BS 380. REPAIRED STRINGER PER SRM.SDR SWAA081113Shear Tie · crackedDURING SCHEDULED 16Y CHECK, FOUND SHEAR TIE CRACKED AT BS 967, STR 7L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA081114Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081110Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 294, STR 11L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081100Light · inoperativeDURING SCHEDULED MV1 CHECK, FOUND L2 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA081099Light · inoperativeDURING SCHEDULED MV1 CHECK, FOUND RIGHT OVERWING EMERGENCY EXIT EXTERIOR LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA081102Light · inoperativeDURING SCHEDULED MV1 CHECK, FOUND BULLNOSE EMERGENCY EXIT LIGHT INOP AT ROW 22 DEF. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA081098Light · inoperativeDURING SCHEDULED MV1 CHECK, FOUND L2 DOOR EMERGENCY EXIT EXTERIOR LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA081101Light · inoperativeDURING SCHEDULED MV1 CHECK, FOUND BULLNOSE EMERGENCY EXIT LIGHT INOP AT ROW 16 ABC. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA081097Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA081079Fitting · corrodedDURING SCHEDULED 16Y CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE AFT GIRT BAR FITTING CORRODED. REMOVED AND REPLACED FITTING PER SRM.SDR SWAA081078Fitting · corrodedDURING SCHEDULED 16Y CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR FITTING CORRODED. REMOVED AND REPLACED FITTING PER SRM.SDR SWAA081077Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 21L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081073Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 277, STR 15R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081080Shear Tie · crackedDURING SCHEDULED 16Y CHECK, FOUND SHEAR TIE CRACKED AT BS 277, STR 8L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA081049Light · inoperativeDURING SCHEDULED MV1 CHECK, FOUND L1 DOOR EMERGENCY EXIT EXTERIOR LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA081034Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA081036Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 482A, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081037Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 559, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081038Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 597, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081039Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081040Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 747, STR 10L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081035Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081031Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 927, STR 25R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081032Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 616, STR 5R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081030Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 22L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081033Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8L AND STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081017Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 440, STR 14R. REPAIRED SHEAR TIE PER EA.SDR SWAA081016Bushing · wornDURING SCHEDULED SPV CHECK, LT ELEVATOR TAB NR 2 HINGE FAILED FREE PLAY CHECK. REMOVED AND REPLACED NR 2 HINGE BUSHING PER MM.SDR SWAA080983Bearing · wornDURING SCHEDULED SPV CHECK, RIGHT ELEVATOR TAB NR 1 HINGE FAILED FREE PLAY CHECK. REMOVED AND REPLACED NR 1 HINGE BEARING AND BOLT PER MM.SDR SWAA080982Slide · out of positionL1 DOOR EMERGENCY EVAC SLIDE FELL OUT, DID NOT DEPLOY. INSTALLED EVAC SLIDE PER MM.SDR SWAA080940Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA080908Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 944, STR 24R. REPAIRED SKIN PER SWA EA.SDR SWAA080901Stringer Splice · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER SPLICE CRACKED AT BS 360, STR 14R. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA080863Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 294.5, STR 7R. REPAIRED FRAME PER SWA EA.SDR SWAA080862Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 887, STR 4L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080861Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 787, STR 10L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080860Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 380, STR 8R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080864Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 482, STR 8R AND STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA080865Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 482A, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA080868Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA080859Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 482A, STR 4R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080867Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA080866Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 559, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA080915Floorbeam · corrodedDURING SCHEDULED 16Y CHECK, FOUND FLOORBEAM CHORD CORRODED AT BS 360, RBL 45 TO RBL 60. REPAIRED FLOORBEAM CHORD PER SRM.SDR SWAA080909Slat · delaminatedDURING SCHEDULED HC2 CHECK, FOUND RT WING NR 5 L/E SLAT DELAMINATED AT OUTBOARD END. REMOVED AND REPLACED NR 5 SLAT PER MM.SDR SWAA080879Slide · low pressureR1 DOOR EMERGENCY EVAC SLIDE PRESSURE GAUGE INDICATED OUT OF LIMITS. REMOVED AND REPLACED EVAC SLIDE PER MM.
Back to Boeing 737-5H4