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 SWAA074685Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 803, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA074684Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 421, STR 17R. REPAIRED SKIN PER SWA EA.SDR SWAA074603Slide · out of adjustR2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA074602Slide · out of adjustL2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA074601Stringer · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER 18R CRACKED AT BS 947. REPAIRED STRINGER PER SRM.SDR SWAA074591Flap · separatedDURING SCHEDULED 18Y CHECK, FOUND RT WING OUTBOARD MID FLAP T/E SKIN SEPARATED. REPAIRED FLAP PER SRM.SDR SWAA074592Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 947, STR 18L. REPAIRED FRAME PER SRM.SDR SWAA074554Shear Tie · corrodedDURING SCHEDULED 18Y CHECK, FOUND SHEAR TIE CORRODED AT BS 344, STR 28R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA074614Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 277, STR 16R. REPAIRED FRAME PER SWA EA.SDR SWAA074555Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 482B, STR 10R. REPAIRED SKIN PER SWA EA.SDR SWAA074513Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 520, STR 25R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA074512Bear Strap · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE SKIN BEAR STRAP CRACKED AT BS 303.9, STR 10L TO STR 13L. REPAIRED SKIN PER SWA EA.SDR SWAA074495Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 482B, STR 10R. REPAIRED SKIN PER SWA EA.SDR SWAA074461Slide · out of adjustL2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA074460Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 320, STR 20L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA074463Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND R1 DOOR LOWER HINGE CUTOUT CRACKED. REPAIRED SKIN PER SWA EA.SDR SWAA074462Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED BETWEEN BS 762 AND BS 770, STR 19L AND STR 18L. REPAIRED SKIN PER SWA EA.SDR SWAA074458Bear Strap · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE SKIN BEAR STRAP CRACKED AT BS 847, STR 16R. REPAIRED SKIN PER SWA EA.SDR SWAA074402Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER SWA EA.SDR SWAA074385Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 328, STR 6R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA074399Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727, STR 7L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA074398Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 7L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA074397Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 663, STR 10R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA074395Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 10L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA074386Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 1010, STR 7L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA074396Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 9L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA074384Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 328, STR 4R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA074390Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 9R. REPAIRED FRAME PER SWA EA.SDR SWAA074387Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA074388Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R AND STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA074383Shear Tie · corrodedDURING SCHEDULED BRDG CHECK, FOUND SHEAR TIE CORRODED AT BS 277, STR 11L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA074382Shear Tie · crackedDURING SCHEDULED BRDG CHECK, FOUND SHEAR TIE CORRODED AT BS 277, STR 9L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA074389Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 328, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA074401Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 885, BETWEEN STR 24R TO STR 25R. REPAIRED SKIN PER SWA EA.SDR SWAA074400Sign · missingAFT CABIN EMERGENCY EXIT SIGN MISSING. INSTALLED EXIT SIGN PER MM.SDR SWAA074377Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 9L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA074340Stringer Clip · crackedDURING SCHEDULED MV3 CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 482A, STR 10L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA074341Shear Tie · crackedDURING SCHEDULED MV3 CHECK, FOUND SHEAR TIE CRACKED AT BS 482A, STR 10L. REPAIRED SHEAR TIE PER SRM.SDR SWAA074352Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 16L. REPAIRED FRAME PER SRM.SDR SWAA074339Skin · crackedDURING SCHEDULED MV3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 497B, STR 10L. REPAIRED SKIN PER SWA EA.SDR SWAA074335Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 765, STR 21L. REPAIRED SKIN PER SRM.SDR SWAA074325Door Frame · crackedDURING SCHEDULED MV4 CHECK, FOUND R1 DOOR CUTOUT FWD FRAME CENTER STUB FRAME CRACKED. REPAIRED FRAME PER SWA EA.SDR SWAA074324Lens · missingL2 DOOR EMERGENCY EXIT LIGHT LENS MISSING. INSTALLED LENS PER MM.SDR SWAA074353Sign · looseFWD CABIN EMERGENCY EXIT SIGN ASSY LOOSE. SECURED SIGN ASSY PER MM.SDR SWAA074299Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 9L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA074300Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 663, STR 10R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA074301Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 4R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA074291Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 294, STR 12L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA074254Stringer · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER 15L CRACKED AT BS 380. REPAIRED STRINGER PER SRM.SDR SWAA074265Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 7L. REMOVED AND REPLACED STRINGER CLIP PER SRM.
Back to Boeing 737-5H4