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 SWAA074264Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 867, STR 10L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA074266Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 294.5, STR 11L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA074238Logic Card · faultyTHIRTY MINUTES PRIOR TO DESCENT NLG RED LIGHT ILLUMINATED. WHEN GEAR HANDLE SELECTED TO DOWN POSITION NLG INDICATED UNSAFE. CYCLED GEAR TWICE BEFORE SAFE INDICATION. REMOVED AND REPLACED NLG M983 LOGIC CARD PER MM.SDR SWAA074235Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 7R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA074221Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 374, STR 26R. REPAIRED SKIN PER SRM.SDR SWAA074215Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 520, STR 16L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA074216Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 277, STR 15L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA074214Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 16L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA074213Keelbeam · corrodedDURING SCHEDULED BRDG CHECK, FOUND LEFT KEEL BEAM CORRODED AT BS 488B, LBL 6.50. REPAIRED KEEL BEAM PER SRM.SDR SWAA074163Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 440, STR 16L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA074138Skin · damagedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CREASED AT BS 426, STR 17R. REPAIRED SKIN PER SWA EA.SDR SWAA074100Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND R1 DOOR EMERGENCY EXIT EXTERIOR LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA074070Slide · out of positionR2 DOOR EMERGENCY EVAC SLIDE FELL OUT, DID NOT DEPLOY. INSTALLED EVAC SLIDE PER MM.SDR SWAA074043Light · brokenL1 DOOR EMERGENCY EXIT LIGHT ASSY BROKEN. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA074044Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 385, STR 10R. REPAIRED SKIN PER SWA EA.SDR SWAA074026Glowstrip · wornDURING SCHEDULED C2 CHECK, FOUND EEPLS PHOTOLUMINESCENT STRIP WORN AT RT OVERWING EMERGENCY EXIT ROW. REMOVED AND REPLACED STRIP PER MM.SDR SWAA074025Light · inoperativeDURING SCHEDULED C2 CHECK, FOUND LT OVERWING EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA074033Coalescer Bag · contaminatedAIRTURN BACK, ENCOUNTERED HYDRAULIC FLUID SMELL ON TAKEOFF. REMOVED AND REPLACED WATER SEPARATOR BAGS PER MM.SDR SWAA074007Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 801, STR 15L. REPAIRED SKIN PER SWA EA.SDR SWAA074032Check Valve · faultyDURING FLIGHT WITH RT PACK RUNNING, BAD HYDRAULIC FLUID SMELL IN CABIN. REMOVED AND REPLACED HYDRAULIC CHECK VALVES ON RESERVOIR PRESSURIZATION MODULE PER MM.SDR SWAA073997Slide · out of positionR2 DOOR EMERGENCY EVAC SLIDE FELL OUT, DID NOT DEPLOY. INSTALLED EVAC SLIDE PER MM.SDR SWAA073968Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 934, STR 24L. REPAIRED SKIN PER SWA EA.SDR SWAA073969Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 488A, STR 10R. REPAIRED SKIN PER SWA EA.SDR SWAA073970Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 494, STR 10R. REPAIRED SKIN PER SWA EA.SDR SWAA073971Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 385, STR 10R. REPAIRED SKIN PER SWA EA.SDR SWAA073726Cable · frayedDURING SCHEDULED HC1 CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE CABLE FRAYED. REMOVED AND REPLACED EVAC SLIDE CABLE PER MM.SDR SWAA073724Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 295, STR 14R. REPAIRED SKIN PER SWA EA.SDR SWAA073723Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED BETWEEN BS 807 AND BS 827, STR 18L AND STR 17L. REPAIRED SKIN PER SWA EA.SDR SWAA073725Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT GROUND AIR HOOK UP CUTOUT BS 520, RBL 7.5. REPAIRED SKIN PER SWA EA.SDR SWAA073717Slide · unwanted deployDURING SCHEDULED 18Y CHECK, L1 DOOR EMERGENCY EVAC SLIDE INADVERTENTLY DEPLOYED. REMOVED AND REPLACED EVAC SLIDE PER MM.SDR SWAA073708Lens · looseDURING SCHEDULED 18Y CHECK, FOUND RT OVERWING EMERGENCY EXIT LIGHT LENS LOOSE. SECURED LENS PER MM.SDR SWAA073664Keelbeam · corrodedDURING SCHEDULED 18Y CHECK, FOUND KEEL BEAM CORRODED AT BS 487B, STR 28R. REPAIRED KEEL BEAM PER SRM.SDR SWAA073666Frame · corrodedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 992, RBL 46. REPAIRED FRAME PER ER.SDR SWAA073656Door Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND AFT CARGO DOOR CUTOUT AFT FRAME WEB CRACKED AT LOWER OUTBOARD CORNER. REMOVED AND REPLACED FRAME WEB PER ACO.SDR SWAA073622Slide · out of adjustR1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA073600Floorbeam · corrodedDURING SCHEDULED RON, FOUND FUSELAGE FLOORBEAM CORRODED AT BS 986.5, RBL 44. REPAIRED FLOORBEAM PER ER.SDR SWAA073572Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND AFT CARGO DOOR CUTOUT FWD FRAME CRACKED NR 5 DOOR STOP. REPAIRED FRAME PER SRM.SDR SWAA073573Bulkhead · crackedDURING SCHEDULED SPV CHECK, FOUND AFT PRESSURE BULKHEAD WEB CRACKED AT BS 1016, STR 7L. REPAIRED WEB PER SRM.SDR SWAA073574Frame · crackedDURING SCHEDULED SPV CHECK, FOUND STUB FRAME CRACKED AT BS 296, STR 16R. REPAIRED FRAME PER SRM.SDR SWAA073551Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 986, STR 20R. REPAIRED FRAME PER SRM.SDR SWAA073553Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073552Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073459Skin · crackedDURING SCHEDULED MV4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 930, STR 25R. REPAIRED SKIN PER SRM.SDR SWAA073500Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT STR 4L. REPAIRED FRAME PER SRM.SDR SWAA073445Stringer · corrodedDURING SCHEDULED 18Y CHECK, FOUND STRINGER 27R CORRODED AT BS 540. REPAIRED STRINGER PER SRM.SDR SWAA073443Shear Tie · crackedDURING SCHEDULED 18Y CHECK, FOUND SHEAR TIE CRACKED AT BS 360, STR 14L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA073440Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073444Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 7R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA073437Slat · crackedDURING SCHEDULED 18Y CHECK, FOUND LRFT WING NR 2 L/E SLAT CRACKED AT OUTBOARD END. REPAIRED SLAT PER SRM.SDR SWAA073435Stringer Splice · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER SPLICE CRACKED AT BS 360, STR 16L. REMOVED AND REPLACED STRINGER SPLICE PER SRM.
Back to Boeing 737-5H4