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 SWAA076348Shear Tie · crackedDURING SCHEDULED BRDG CHECK, FOUND SHEAR TIE CRACKED AT BS 360, STR 13L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA076352Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 747, STR 9R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA076351Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 663, STR 10R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA076349Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 482B, STR 8R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA076350Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 8R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA076341Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 487B, STR 15R. REPAIRED SKIN PER SWA EA.SDR SWAA076316Keelbeam · corrodedDURING SCHEDULED BDRG CHECK, FOUND RT KEEL BEAM CORRODED AT BS 487B. REPAIRED KEEL BEAM PER SWA EA.SDR SWAA076317Stringer Clip · crackedDURING SCHEDULED BDRG CHECK, FOUND STRINGER CLIP CRACKED AT BS 277, STR 10R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA076318Stringer Clip · crackedDURING SCHEDULED BDRG CHECK, FOUND STRINGER CLIP CRACKED AT BS 277, STR 11R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA076263Lens · brokenL1 DOOR EMERGENCY EXIT LIGHT LENS BROKEN. REMOVED AND REPLACED LIGHT LENS PER MM.SDR SWAA076187Glowstrip · looseDURING SCHEDULED SPV CHECK, FOUND EEPLS PHOTOLUMINESCENT STRIP LOOSE AT ROW 20 DEF. SECURED STRIP PER MM.SDR SWAA076242Tab · delaminatedDURING SCHEDULED BRDG CHECK, FOUND LT ELEVATOR TAB DELAMINATED. REMOVED AND REPLACED TAB PER MM.SDR SWAA076243Skin · delaminatedDURING SCHEDULED BRDG CHECK, FOUND RT ELEVATOR TAB DELAMINATED. REMOVED AND REPLACED TAB PER MM.SDR SWAA076158Lens · crackedRT OVERWING EMERGENCY EXIT LIGHT LENS CRACKED. REMOVED AND REPLACED LENS PER MM.SDR SWAA076179Bulkhead · crackedDURING SCHEDULED BRDG CHECK, FOUND AFT PRESSURE BULKHEAD WEB CRACKED AT BS 1016, BETWEEN 10 O'CLOCK POSITION AND 3 O'CLOCK POSITION. REPAIRED WEB PER SRM.SDR SWAA076101Glowstrip · wornDURING SCHEDULED MV4 CHECK, FOUND EEPLS PHOTOLUMINESCENT STRIP WORN AT ROW 2 DEF. REMOVED AND REPLACED STRIP PER MM.SDR SWAA076147Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA076080Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 847, STR 4L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA076049Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 747, STR 10L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA076048Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 4L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA076075Slide · out of positionL1 DOOR EMERGENCY EVAC SLIDE FELL OUT, DID NOT DEPLOY. INSTALLED EVAC SLIDE PER MM.SDR SWAA076082Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 749, STR 18L. REPAIRED SKIN PER SWA EA.SDR SWAA076081Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 803, STR 24L. REPAIRED SKIN PER SWA EA.SDR SWAA076079Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED BETWEEN BS 751 AND BS 781, STR 18L AND STR 19L. REPAIRED SKIN PER SRM.SDR SWAA076078Slide · out of adjustDURING SCHEDULED C3 CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA076077Skin · delaminatedRIGHT WING NR 9 SPOILER UPPER SURFACE DELAMINATED. REMOVED AND REPLACED SPOILER PER MM.SDR SWAA076076Skin · delaminatedRIGHT WING NR 8 SPOILER UPPER SURFACE DELAMINATED. REMOVED AND REPLACED SPOILER PER MM.SDR SWAA076039Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 867, STR 8R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA076038Skin · debondedDURING SCHEDULED C2 CHECK, FOUND LT WING FORE FLAP UPPER SURFACE DISBONDED. REMOVED AND REPLACED FLAP PER MM.SDR SWAA076023Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 867, STR 8R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA076037Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 927, STR 25R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA076022Slide · out of positionL1 DOOR EMERGENCY EVAC SLIDE FELL OUT, DID NOT DEPLOY. INSTALLED EVAC SLIDE PER MM.SDR SWAA076015Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 747, STR 25L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA075981Shear Tie · corrodedDURING SCHEDULED BRDG CHECK, FOUND SHEAR TIE CORRODED AT BS 460, BL 0. REPAIRED SHEAR TIE PER SRM.SDR SWAA075974Battery Pack · dischargedDURING SCHEDULED SERVICE CHECK, FOUND AFT CABIN EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK AND CHARGER PER MM.SDR SWAA075923Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA075918Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075917Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8L AND STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA075916Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 559, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075924Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075915Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075913Slide · out of adjustDURING SCHEDULED HC1 CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA075912Light · inoperativeDURING SCHEDULED HC1 CHECK, FOUND LT AFT FUSELAGE EMERGENCY EXIT EXTERIOR LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA075911Light · inoperativeDURING SCHEDULED HC1 CHECK, FOUND L1 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA075914Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 952, STR 21L. REPAIRED SKIN PER SWA EA.SDR SWAA075901Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 482, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075902Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075878Hook · looseDURING SCHEDULED C3 CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR HOOK LOOSE. SECURED HOOK PER MM.SDR SWAA075877Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED BETWEEN BS 775 AND BS 786, STR 18L AND STR 19L. REPAIRED SKIN PER SRM.SDR SWAA075821Slide · dislodgedL1 DOOR EMERGENCY EVAC SLIDE FELL OUT, DID NOT DEPLOY. INSTALLED EVAC SLIDE PER MM.
Back to Boeing 737-5H4