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 SWAA071084Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 559, STR 9L. REPAIRED FRAME PER SWA EA.SDR SWAA071083Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 9L. REPAIRED FRAME PER SWA EA.SDR SWAA071047Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 777, STR 18L. REPAIRED SKIN PER SWA EA.SDR SWAA071048Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 520, STR 28L. REPAIRED SKIN PER SWA EA.SDR SWAA071016Glowstrip · debondedDURING SCHEDULED 18Y CHECK, FOUND FWD RT CABIN EEPLS PHOTOLUMINESCENT STRIP DISBONDED. REMOVED AND REPLACED PHOTOLUMINESCENT STRIP PER MM.SDR SWAA071001Fitting · looseDURING SCHEDULED BRDG CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE AFT GIRT BAR FITTING LOOSE. SECURED GIRT BAR FITTING PER SRM.SDR SWAA070995Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 400, STR 8L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA070862Slide · out of positionL1 DOOR EMERGENCY EVAC SLIDE FELL OUT, DID NOT DEPLOY. INSTALLED EVAC SLIDE PER MM.SDR SWAA070729Light · out of positionDURING SCHEDULED MV1 CHECK, FOUND BULL NOSE EMERGENCY EXIT LIGHT OUT OF POSITON AT ROW 3 ABC. REPOSITIONED LIGHT PER MM.SDR SWAA070705Slide · out of adjustR2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA070704Glowstrip · looseDURING SCHEDULED SPV CHECK, FOUND RIGHT FWD CABIN EEPLS PHOTOLUMINESCENT STRIP LOOSE. SECURED STRIP PER MM.SDR SWAA070678Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 931, STR 25R. REPAIRED SKIN PER SRM.SDR SWAA070677Charger · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND LT AFT CABIN EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK AND BATTERY CHARGER PER MM.SDR SWAA070663Skin · crackedDURING SCHEDULED C4 CHECK, FOUND LT HORIZONTAL STAB LOWER SKIN CRACKED AT AFT SPAR STA 87. REPAIRED SKIN PER SWA EA.SDR SWAA070662Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT EQUIPMENT COOLING DUCT CUTOUT BS 378.5, LBL 2.8. REPAIRED SKIN PER SWA EA.SDR SWAA070634Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 944, STR 24R. REPAIRED SKIN PER SRM.SDR SWAA070610Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 970, STR 21L. REPAIRED SKIN PER SWA EA.SDR SWAA070593Stringer Splice · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER SPLICE CRACKED AT BS 360, STR 4L. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA070572Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 970, STR 21L. REPAIRED SKIN PER SRM.SDR SWAA070545Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727B, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA070546Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA070544Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R AND 8L. REPAIRED FRAME PER SWA EA.SDR SWAA070509Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727B, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA070508Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA070518Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 21R. REPAIRED FRAME PER SRM.SDR SWAA070507Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA070510Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8L AND STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA070506Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA070511Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8L AND STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA070505Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA070516Floorbeam · crackedDURING SCHEDULED BRDG CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 664.5, BL 0. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA070517Window Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FIRST OFFICERS WINDOW POST CRACKED AT FWD UPPER CORNER. REPAIRED POST PER SRM.SDR SWAA070453Fitting · corrodedDURING SCHEDULED MV2 CHECK, FOUND RT MLG AFT HANGER FITTING CORRODED. REMOVED AND REPLACED AFT FITTING PER SRM.SDR SWAA070454Fitting · corrodedDURING SCHEDULED MV2 CHECK, FOUND RIGHT MLG WALKING BEAM OUTBOARD FWD STABILIZER FITTING CORRODED. REPAIRED FITTING PER SWA EA.SDR SWAA070455Fitting · corrodedDURING SCHEDULED MV2 CHECK, FOUND LT MLG WALKING BEAM OUTBOARD FWD STABILIZER FITTING CORRODED. REPAIRED FITTING PER SWA EA.SDR SWAA070450Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA070449Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8L. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA070448Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA070447Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 520, STR 10R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA070430Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 907, STR 7L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA070429Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA070403Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 663, STR 10R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA070402Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 639, STR 4L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA070401Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 616, STR 4R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA070400Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 482B, STR 5R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA070336Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 867, STR 3L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA070335Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 847, STR 10L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA070334Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 747, STR 4L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA070333Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 747, STR 4R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA070332Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 4R. REMOVED AND REPLACED STRINGER CLIP PER SRM.
Back to Boeing 737-5H4