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 SWAA075160Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 482, STR 8L AND STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA075164Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA075170Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 7R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA075165Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 747, STR 4L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA075171Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 8R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA075169Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 4R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA075168Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 706, STR 2R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA075167Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 7L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA075166Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 685, STR 9L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA075172Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 9R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA075197Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727B, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA075162Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075161Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 559, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075163Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA075130Glowstrip · wornDURING SCHEDULED HC2 CHECK, FOUND EEPLS PHOTOLUMINESCENT STRIP WORN AT ROW 4 DEF. REMOVED AND REPLACED STRIP PER MM.SDR SWAA075132Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA075131Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA075129Flap · delaminatedDURING SCHEDULED MV2 CHECK, FOUND LEFT WING OUTBOARD T/E AFT FLAP DELAMINATED. REMOVED AND REPLACED FLAP PER MM.SDR SWAA075101Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA075108Wedge · delaminatedDURING SCHEDULED 18Y CHECK, FOUND RIGHT WING INBOARD MID FLAP T/E WEDGE LOWER SURFACE DELAMINATED. REMOVED AND REPLACED WEDGE PER MM.SDR SWAA075072Skin · delaminatedDURING SCHEDULED 18Y CHECK, FOUND RIGHT WING INBOARD FORE FLAP UPPER SURFACE DELAMINATED. REPAIRED FORE FLAP PER SRM.SDR SWAA075073Crease Beam · corrodedDURING SCHEDULED SPV CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 639, STR 17R. REPAIRED WEB PER SRM.SDR SWAA075064Lens · missingFWD CABIN EMERGENCY EXIT LIGHT LENS MISSING. INSTALLED LENS PER MM.SDR SWAA075049Flap · delaminatedDURING SCHEDULED HC2 CHECK, FOUND LEFT WING OUTBOARD FOREFLAP DELAMINATED AT INBOARD END. REMOVED AND REPLACED FLAP PER MM.SDR SWAA075046Skin · delaminatedDURING SCHEDULED 18Y CHECK, FOUND RIGHT WING INBOARD FOREFLAP DELAMINATED AT UPPER SURFACE. REPAIRED FLAP PER SRM.SDR SWAA075048Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR UPPER HINGE CUTOUT FWD END. REPAIRED SKIN PER SRM.SDR SWAA075047Battery Pack · dischargedDURING SCHEDULED BRDG CHECK, FOUND FWD FUSELAGE EMERGENCY EXIT EXTERIOR LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA075038Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 520, STR 9R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA075041Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 520, STR 16R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA075020Bearing · wornDURING SCHEDULED BRDG CHECK, RIGHT ELEVATOR TAB FAILED FREE PLAY CHECK. REMOVED AND REPLACED INPUT ROD BEARING PER MM.SDR SWAA075021Rod · wornDURING SCHEDULED BRDG CHECK, LEFT ELEVATOR TAB FAILED FREE PLAY CHECK. REMOVED AND REPLACED INPUT ROD PER MM.SDR SWAA075027Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 7R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA075011Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 947, STR 24L. REPAIRED SKIN PER SWA EA.SDR SWAA075012Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 801, STR 19L. REPAIRED SKIN PER SWA EA.SDR SWAA074997Stringer · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER 7L CRACKED AT BS 1006. REPAIRED STRINGER PER SRM.SDR SWAA074998Stringer · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER 13R CRACKED AT BS 440. REPAIRED STRINGER PER SRM.SDR SWAA074999Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 482B, STR 4R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA074940Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 482, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA074942Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 9L. REPAIRED FRAME PER SWA EA.SDR SWAA074929Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 520, STR 10R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA074930Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 400, STR 8R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA074928Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 482B, STR 5R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA074926Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 578, STR 10R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA074925Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 520, STR 14R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA074924Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 867, STR 6R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA074941Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA074943Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA074927Controller · faultyFLIGHT DECK L1 WINDOW ARCING. REMOVED AND REPLACED WINDOW HEAT CONTROLLER PER MM.SDR SWAA074910Slide · out of adjustL2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA074907Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 400, STR 8R. REMOVED AND REPLACED STRINGER CLIP PER SRM.
Back to Boeing 737-5H4