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 SWAA075365Sign · missingL1 DOOR EMERGENCY EXIT SIGN MISSING. INSTALLED SIGN PER MM.SDR SWAA075404Pump · faultyRAISING GEAR HANDLE DURING CLIMBOUT, ENGINE AND ELECTRICAL -A- SYSTEM HYRAULIC LOW PRESSURE LIGHTS ILLUMINATED. PRESSURE WENT TO ZERO AND QUANTITY FLUCTUATED, THEN BOTH LIGHTS WENT OUT. AFTER LANDING WITH REVERSERS DEPLOYED -A- SYSTEM HYDRAULIC LOW PRESSURE SDR SWAA075328Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 887, STR 2R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA075329Hook · looseDURING SCHEDULED 16Y CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR HOOK LOOSE. SECURED HOOK PER SRM.SDR SWAA075321Floorbeam · crackedDURING SCHEDULED 18Y CHECK, FOUND FLOORBEAM CRACKED AT BS 706, LBL 49. REPAIRED FLOORBEAM PER SRM.SDR SWAA075326Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 8L AND 4L. REPAIRED FRAME PER SWA EA.SDR SWAA075324Light · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND RT OVERWING EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA075323Light · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND LT OVERWING EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA075322Sign · looseLEFT OVERWING EMERGENCY EXIT SIGN LOOSE. SECURED SIGN PER MM.SDR SWAA075327Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727A, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA075354Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 277, STR 16L. REPAIRED FRAME PER EA.SDR SWAA075325Sign · missingFWD CABIN EMERGENCY EXIT SIGN MISSING. INSTALLED EXIT SIGN PER MM.SDR SWAA075281Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 360, STR 14L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA075301Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 360, STR 15L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA075304Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 482A, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA075306Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 482A, STR 5R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA075279Fitting · corrodedDURING SCHEDULED 18Y CHECK, FOUND VERTICAL STABILIZER FITTING FWD AND AFT LUG FACES CORRODED. REPAIRED FITTING PER EA.SDR SWAA075280Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA075303Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 578, STR 14R. REPAIRED FRAME PER EA.SDR SWAA075305Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 520, STR 9R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA075300Skin · corrodedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 468, BL 0. REPAIRED SKIN PER EA.SDR SWAA075243Skin · delaminatedDURING SCHEDULED 18Y CHECK, FOUND RT WING INBOARD FOREFLAP DELAMINATED AT UPPER SURFACE. REMOVED AND REPLACED FOREFLAP PER MM.SDR SWAA075262Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 907, STR 4L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA075261Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 887, STR 10L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA075260Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 847, STR 10L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA075259Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 787, STR 9R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA075264Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 867, STR 4R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA075265Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 887, STR 6R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA075263Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 747, STR 8R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA075266Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 420, STR 16R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA075258Stringer Splice · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER SPLICE CRACKED AT BS 908, STR 4L. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA075244Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 16R. REPAIRED FRAME PER EA.SDR SWAA075206Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 482A, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075216Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075217Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 4L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA075229Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 706, STR 3R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA075228Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 685, STR 5R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA075227Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 616, STR 3R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA075226Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 559, STR 8R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA075225Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 482B, STR 8R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA075224Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 482A, STR 4R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA075223Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 460, STR 4R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA075222Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 400, STR 8R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA075221Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 482B, STR 8L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA075220Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 520, STR 8L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA075218Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 706, STR 1. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA075209Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 9L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA075208Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 482A, STR 8L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA075219Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 482B, STR 7L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA075207Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 8. REPAIRED FRAME PER SWA EA.
Back to Boeing 737-5H4