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 SWAA072661Skin · delaminatedDURING SCHEDULED BRDG CHECK, FOUND LEFT WING NR 2 LEADING EDGE SLAT TRAILING EDGE DELAMINATED. REPAIRED SLAT PER SRM.SDR SWAA072665Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072664Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072575Lamp · inoperativeDURING SCHEDULED MV1 CHECK, FOUND L1 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA072610Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA072612Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 7R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072613Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 7R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072614Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 639, STR 4L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072615Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 400, STR 4R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072616Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 5L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072617Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 380, STR 4L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072608Door Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FWD CARGO DOOR AFT FRAME LOWER STOP FITTING LOWER CHORD CRACKED. REMOVED AND REPLACED CHORD PER SRM.SDR SWAA072609Cover · crackedDURING SCHEDULED BRDG CHECK, FOUND FWD CABIN EMERGENCY EXIT LIGHT COVER CRACKED. REMOVED AND REPLACED LIGHT COVER PER MM.SDR SWAA072555Stringer · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER 27L CRACKED AT BS 1036. REPAIRED STRINGER PER SRM.SDR SWAA072553Beltframe · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE BELTFRAME CRACKED AT BS 482, STR 20L. REPAIRED FRAME PER SWA EA.SDR SWAA072549Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 6R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072550Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 420, STR 16R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072548Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 380, STR 8L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072547Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 14L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072551Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 616, STR 4L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072552Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727B, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA072557Bulkhead · crackedDURING SCHEDULED BRDG CHECK, FOUND AFT PRESSURE BULKHEAD WEB CRACKED AT BS 1016, 3 O'CLOCK POSITION. REPAIRED WEB PER SRM.SDR SWAA072556Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA072554Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA072520Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 930, STR 21L. REPAIRED SKIN PER SRM.SDR SWAA072524Floorbeam · crackedDURING SCHEDULED BRDG CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 662, RBL 24.5. REPAIRED FLOORBEAM PER EA.SDR SWAA072523Floorbeam · crackedDURING SCHEDULED BRDG CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED BETWEEN BS 657 AND BS 669, LBL 24.5. REPAIRED FLOORBEAM PER EA.SDR SWAA072513Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072512Battery Pack · dischargedDURING SCHEDULED SERVICE CHECK, FOUND RIGHT FWD CABIN EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA072495Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 400, STR 6R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072482Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 277, STR 15L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072481Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 277, STR 10R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072480Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 294, STR 11L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072479Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 294, STR 12L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072478Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 294, STR 13L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072504Slat · delaminatedDURING SCHEDULED BRDG CHECK, FOUND RIGHT WING NR 5 L/E SLAT UPPER INBOARD T/E DELAMINATED. REPAIRED SLAT PER SRM.SDR SWAA072500Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072501Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072499Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072502Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072498Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072497Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072503Flap · delaminatedDURING SCHEDULED BRDG CHECK, FOUND LEFT WING INBOARD T/E AFT FLAP DELAMINATED AT OUTBOARD END. REPAIRED FLAP PER SRM.SDR SWAA072496Lens · brokenDURING SCHEDULED BRDG CHECK, FOUND R1 DOOR EMERGENCY EXIT LIGHT LENS BROKEN. REMOVED AND REPLACED LIGHT LENS PER MM.SDR SWAA072414Glowstrip · missingEEPLS PHOTOLUMINESCENT STRIP MISSING AT ROW 3 DEF. INSTALLED STRIP PER MM.SDR SWAA072446Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 747, STR 17L. REPAIRED SKIN PER SRM.SDR SWAA072421Skin · crackedDURING SCHEDULED OTS CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 747, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA072428Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 763, STR 21L. REPAIRED SKIN PER SRM.SDR SWAA072429Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 751, STR 23L. REPAIRED SKIN PER SWA EA.SDR SWAA072402Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 259, STR 21L. REPAIRED SKIN PER SRM.
Back to Boeing 737-5H4