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 SWAA081350Skin · crackedDURING SCHEDULED C4 CHECK, FOUND AFT CARGO DOOR SKIN CRACKED AT DOOR HANDLE CUTOUT. REPAIRED SKIN PER SWA EA.SDR SWAA081351Flap · delaminatedDURING SCHEDULED C4 CHECK, FOUND RT WING INBOARD FORE FLAP DELAMINATED. REMOVED AND REPLACED FLAP PER MM.SDR SWAA081352Guide · looseDURING SCHEDULED C4 CHECK, FOUND RT WING OUTBOARD FORE FLAP GUIDE LOOSE. REMOVED AND REPLACED FLAP PER MM.SDR SWAA081353Lug · crackedDURING SCHEDULED C4 CHECK, FOUND RT WING NR 5 GROUND SPOILER ACTUATOR LUG CRACKED. REPAIRED ACTUATOR PER SWA EA.SDR SWAA081297Stringer · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER 4R CRACKED AT BS 910. REPAIRED STRINGER PER SRM.SDR SWAA081296Actuator · faultyRETRACTED LANDING GEAR, RT MLG UNSAFE LIGHT ILLUMINATED. CYCLED GEAR, SAME INDICATION, LIGHT WENT OUT ABOVE 10000 FT. REMOVED AND REPLACED RT MLG UPLOCK ACTUATOR PER MM.SDR SWAA081295Slide · low pressureL1 DOOR EMERGENCY EVAC SLIDE PRESSURE GAUGE INDICATED OUT OF LIMITS. REMOVED AND REPLACED EVAC SLIDE PER MM.SDR SWAA081294Light · inoperativeDURING SCHEDULED SPV CHECK, FOUND R2 DOOR EMERGENCY EXIT EXTERIOR LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA081247Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 706, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA081257Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081258Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081236Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 294, STR 12L. REPAIRED FRAME PER SRM.SDR SWAA081230Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 847, STR 4R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081235Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 907, STR 5L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081234Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 907, STR 8L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081233Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 887, STR 4L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081231Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 4L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081229Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 482B, STR 6R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081228Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 867, STR 4L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081227Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 827, STR 4L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081226Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 827, STR 4R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081225Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 807, STR 4R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081224Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 482A, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA081232Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 807, STR 4L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081263Gasper Fan · faultyCREW REPORTS ODOR FROM RT PACK, TURNED PACK OFF. FOUND ODOR COMING FROM GASPER FAN. REMOVED AND REPLACED GASPER FAN PER MM.SDR SWAA081205Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME INBOARD CHORD CRACKED AT BS 616, LBL 64. REMOVED AND REPLACED CHORD PER SRM.SDR SWAA081176Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 420, STR 16R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081175Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME WEB CRACKED AT BS 303, STR 4L. REMOVED AND REPLACED WEB PER SRM.SDR SWAA081203Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081194Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081196Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 827, STR 4R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081197Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 827, STR 4L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081198Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 428B, STR 6R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081199Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 380, STR 8R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081195Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081200Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 847, STR 4R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081201Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 4L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081204Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA081202Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 807, STR 4L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081193Light · crackedL1 DOOR EMERGENCY EXIT LIGHT LENS CRACKED. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA081157Slat · crackedDURING SCHEDULED 16Y CHECK, FOUND LT WING NR 2 L/E SLAT CRACKED AT OUTBOARD T/E. REPAIRED SLAT PER SRM.SDR SWAA081158Slat · crackedDURING SCHEDULED 16Y CHECK, FOUND LT WING NR 1 L/E SLAT CRACKED AT OUTBOARD T/E. REPAIRED SLAT PER SRM.SDR SWAA081159Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 907, STR 8L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081143Shear Tie · crackedDURING SCHEDULED 16Y CHECK, FOUND SHEAR TIE CRACKED AT BS 360, STR 14R. REPAIRED SHEAR TIE PER SRM.SDR SWAA081142Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 295, STR 8L. REPAIRED FRAME PER SRM.SDR SWAA081122Crease Beam · corrodedDURING SCHEDULED 16Y CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 415, RBL 68. REMOVED AND REPLACED WEB PER SRM.SDR SWAA081123Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE STUB FRAME CRACKED AT BS 294, RBL 53, WL 208. REMOVED AND REPLACED FRAME PER SRM.SDR SWAA081124Stringer Splice · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER SPLICE CRACKED AT BS 360, STR 4L. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA081125Stringer Splice · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER SPLICE CRACKED AT BS 360, STR 15R. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA081126Stringer · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER 4L CRACKED AT BS 887. REPAIRED STRINGER PER SRM.
Back to Boeing 737-5H4