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 SWAA072401Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 259, STR 23L. REPAIRED SKIN PER SRM.SDR SWAA072400Light · inoperativeDURING SCHEDULED MV1 CHECK, FOUND R2 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA072399Skin · crackedFUSELAGE SKIN CRACKED AT BS 374, STR 15L. REPAIRED SKIN PER SWA EA.SDR SWAA072379Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 277, STR 9L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072385Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 947, STR 24R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072380Shear Tie · crackedDURING SCHEDULED BRDG CHECK, FOUND SHEAR TIE CRACKED AT BS 277, STR 8L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA072381Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 482B, STR 10L. REPAIRED SKIN PER SWA EA.SDR SWAA072358Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 11L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072359Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 8L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072363Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 927, STR 25R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072352Light · missingDURING SCHEDULED MV1 CHECK, FOUND L1 DOOR EMERGENCY EXIT LIGHT LENS MISSING. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA072360Shear Tie · crackedDURING SCHEDULED BRDG CHECK, FOUND SHEAR TIE CRACKED AT BS 277, STR 8L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA072361Shear Tie · crackedDURING SCHEDULED BRDG CHECK, FOUND SHEAR TIE CRACKED AT BS 277, STR 9L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA072344Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA072346Shear Tie · crackedDURING SCHEDULED BRDG CHECK, FOUND SHEAR TIE CRACKED AT BS 639, STR 7L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA072345Shear Tie · crackedDURING SCHEDULED BRDG CHECK, FOUND SHEAR TIE CRACKED AT BS 616, STR 7L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA072343Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA072342Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA072341Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA072301Glowstrip · wornDURING SCHEDULED MV2 CHECK, FOUND EEPLS PHOTOLUMINESCENT STRIP WORN BETWEEN ROW 4 DEF AND ROW 6 DEF. REMOVED AND REPLACED STRIP PER MM.SDR SWAA072300Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 972, STR 21L. REPAIRED SKIN PER SWA EA.SDR SWAA072299Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 770, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA072282Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 616, STR 5R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072281Skin · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 783, STR 20L. REPAIRED SKIN PER SRM.SDR SWAA072254Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 5R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072253Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 5L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072255Skin · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 787, STR 23L. REPAIRED SKIN PER SRM.SDR SWAA072242Stringer · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER 6L CRACKED AT BS 727B. REPAIRED STRINGER PER SRM.SDR SWAA072211Door Frame · crackedDURING SCHEDULED MV4 CHECK, FOUND R1 DOOR FWD STUB FRAME CRACKED AT BS 294.5, STR 12R. REPAIRED FRAME PER SWA EA.SDR SWAA072156Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA072163Stringer · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER 8R CRACKED AT BS 482A. REPAIRED STRINGER PER SRM.SDR SWAA072158Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 482A, STR 8R. R&R STRINGER CLIP PER SRM.SDR SWAA072159Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 460, STR 2L. R&R STRINGER CLIP PER SRM.SDR SWAA072160Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 706, STR 5L. R&R STRINGER CLIP PER SRM.SDR SWAA072161Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 706, STR 3L. R&R STRINGER CLIP PER SRM.SDR SWAA072162Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 807, STR 10R. R&R STRINGER CLIP PER SRM.SDR SWAA072157Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727B, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA072094Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER SRM.SDR SWAA072102Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 5R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072101Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 616, STR 4R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072099Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 685, STR 3L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072100Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 685, STR 1. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072103Skin · crackedFUSELAGE SKIN CRACKED AT BS 757, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA072097Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 520, STR 5R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072096Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 520, STR 8R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072095Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 482A, STR 5L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072087Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 827, STR 10R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072085Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CHORD CRACKED AT LH BS 616, WL 199. REPAIRED CHORD PER SRM.SDR SWAA072086Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CHORD CRACKED AT RT BS 616, WL 199. REPAIRED CHORD PER SRM.SDR SWAA072084Skin · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 788, STR 24L. REPAIRED SKIN PER SRM.
Back to Boeing 737-5H4