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 SWAA072879Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 400, STR 15R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA072871Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 616, STR 5L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072870Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 5L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072874Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 400, STR 8L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072873Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 482, STR 5R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072872Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 482, STR 4R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072876Stringer Splice · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER SPLICE CRACKED AT BS 360, STR 15L. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA072875Stringer Splice · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER SPLICE CRACKED AT BS 360, STR 14L. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA072881Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 967 AT JOGGLE ABOVE L2 DOOR. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA072869Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072868Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072867Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 482, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072880Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 482, STR 15R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA072866Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072882Bracket · brokenLEFT WING OUTBOARD FORE FLAP BRACKET BROKEN OFF. REMOVED AND REPLACED FORE FLAP PER MM.SDR SWAA072832Controller · arcedFLIGHT COMPARTMENT L2 WINDOW ARCING. REMOVED AND REPLACED L2 WINDOW AND WINDOW HEAT CONTROLLER PER MM.SDR SWAA072807Slide · out of adjustL1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA072825Stringer · crackedDURING SCHEDULED 8Y CHECK, FOUND STRINGER 1 CRACKED BETWEEN BS 661 AND BS 667. REPAIRED STRINGER PER SRM.SDR SWAA072824Bear Strap · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE SKIN BEAR STRAP CRACKED AT FWD GALLEY DOOR CUTOUT AFT LOWER CORNER. REPAIRED SKIN PER SWA EA.SDR SWAA072827Frame · crackedDURING SCHEDULED 8Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 663.75, STR 1. REPAIRED FRAME PER SWA EA.SDR SWAA072820Flap · delaminatedDURING SCHEDULED SPV CHECK, FOUND RIGHT WING INBOARD T/E AFT FLAP DELAMINATED AT OUTBOARD END. REPAIRED FLAP PER SRM.SDR SWAA072826Skin · crackedDURING SCHEDULED 8Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 812, STR 23L. REPAIRED SKIN PER SRM.SDR SWAA072828Skin · crackedDURING SCHEDULED 8Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 758, STR 22L. REPAIRED SKIN PER SWA EA.SDR SWAA072755Glowstrip · looseEEPLS PHOTOLUMINESCENT STRIP LOOSE BETWEEN ROW 10 DEF AND ROW 12 DEF. REMOVED AND REPLACED STRIP PER MM.SDR SWAA072762Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072763Skin · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 782, STR 23L. REPAIRED SKIN PER SRM.SDR SWAA072744Bearing · wornDURING SCHEDULED C4 CHECK, RIGHT ELEVATOR FAILED FREE PLAY CHECK. REMOVED AND REPLACED CONTROL ROD BEARING PER MM.SDR SWAA072750Beltframe · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE BELTFRAME CRACKED AT BS 482A, STR 20R. REPAIRED FRAME PER SWA EA.SDR SWAA072749Beltframe · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE BELTFRAME CRACKED AT BS 787, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072751Beltframe · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE BELTFRAME CRACKED AT BS 294, STR 13L. REPAIRED FRAME PER SWA EA.SDR SWAA072752Beltframe · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE BELTFRAME CRACKED AT BS 294, STR 12L. REPAIRED FRAME PER SWA EA.SDR SWAA072753Beltframe · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE BELTFRAME CRACKED AT BS 294, STR 11L. REPAIRED FRAME PER SWA EA.SDR SWAA072748Skin · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 951, STR 24R. REPAIRED SKIN PER SRM.SDR SWAA072747Skin · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 780, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA072743Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 446, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA072695Stringer · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER 7L CRACKED AT BS 295. REPAIRED STRINGER PER SRM.SDR SWAA072701Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 482, STR 20L. REPAIRED FRAME PER SWA EA.SDR SWAA072694Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 277, STR 10L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072693Wire · brokenDURING SCHEDULED BRDG CHECK, FOUND L1 DOOR EMERGENCY EXIT LIGHT INOP. FOUND BROKEN WIRE ON CONNECTOR, REPAIRED WIRE PER MM.SDR SWAA072702Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072703Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072704Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA072700Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 482, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072698Shear Tie · crackedDURING SCHEDULED BRDG CHECK, FOUND SHEAR TIE CRACKED AT BS 360, STR 14L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA072696Shear Tie · crackedDURING SCHEDULED BRDG CHECK, FOUND SHEAR TIE CRACKED AT BS 277, STR 11L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA072697Shear Tie · crackedDURING SCHEDULED BRDG CHECK, FOUND SHEAR TIE CRACKED AT BS 277, STR 9L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA072699Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 294, STR 13L. REPAIRED FRAME PER SWA EA.SDR SWAA072684Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA072682Skin · crackedDURING SCHEDULED C4 CHECK, FOUND AFT CARGO DOOR HANDLE CUTOUT SKIN CRACKED AT FWD END. REPAIRED SKIN PER SWA EA.SDR SWAA072683Skin · crackedDURING SCHEDULED C4 CHECK, FOUND R2 DOOR UPPER HINGE SKIN CUTOUT CRACKED AT UPPER CORNER. REPAIRED SKIN PER SWA EA.
Back to Boeing 737-5H4