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 SWAA110327Cover · looseDURING SCHEDULED 2HC2 CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE GIRT BAR HOOKS LOOSE. REMOVED AND REPLACED COVER PER MM.SDR SWAA110322Skin · crackedDURING SCHEDULED CV CHECK, FOUND SKIN CRACKED AT BS 360, BETWEEN STR 5R TO STR 6R. REPAIRED SKIN PER EA.SDR SWAA110321Slide · out of adjustDURING SCHEDULED CV CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA110320Slide · out of adjustDURING SCHEDULED CV CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA110293Gasper Fan · faultySTRONG ODOR COMING FROM ENVIRONMENTAL SYSTEM. REMOVED AND REPLACED GASPER FAN PER MM.SDR SWAA110260Slide · out of positionL2 DOOR EMERGENCY EVAC SLIDE FELL OUT, DID NOT DEPLOY. RE-INSTALLED SLIDE PER MT.SDR SWAA110209Lens · looseDURING SCHEDULED 18Y CHECK, FOUND RT OVERHEAD EMERGENCY EXIT BULLNOSE LIGHT LENS LOOSE BETWEEN ROW 12 AND ROW 13. SECURED LENS PER MM.SDR SWAA110259Fuse · blownDURING SCHEDULED CV CHECK, FOUND L2 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED FUSE PER MM.SDR SWAA110258Channel · corrodedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO COMPARTMENT CHANNEL CORRODED AT BS 860, RBL 3. REPAIRED CHANNEL PER EA.SDR SWAA110257Channel · corrodedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO COMPARTMENT CHANNEL CORRODED AT BS 860, LBL 3. REPAIRED CHANNEL PER EA.SDR SWAA110256Channel · corrodedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO COMPARTMENT CHANNEL CORRODED AT BS 727B+5, RBL 8.10. REPAIRED CHANNEL PER EA.SDR SWAA110255Channel · corrodedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO COMPARTMENT CHANNEL CORRODED AT BS 727B+5, LBL 3. REPAIRED CHANNEL PER EA.SDR SWAA110254Channel · corrodedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO COMPARTMENT CHANNEL CORRODED AT BS 727B+5, RBL 3. REPAIRED CHANNEL PER EA.SDR SWAA110172Flap · crackedDURING SCHEDULED 18Y CHECK, FOUND RT WING O/B MID FLAP UPPER CHORD CRACKED. REPAIRED MID FLAP PER EA.SDR SWAA110171Channel · corrodedDURING SCHEDULED 18Y CHECK, FOUND AFT CARGO CHANNEL CORRODED AT BS 772, RBL 8.10. REPAIRED CHANNEL PER EA.SDR SWAA110170Skin · crackedDURING SCHEDULED 18Y CHECK, FOUND SKIN CRACKED AT BS 389, STR 17L. REPAIRED SKIN PER EA.SDR SWAA110169Stringer · corrodedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CORRODED BETWEEN BS 440 TO BS 482, STR 28L. REPAIRED STRINGER PER SRM.SDR SWAA110168Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FRAME CRACKED AT BS 907, STR 21R. REPAIRED FRAME PER EA.SDR SWAA110167Lens · brokenDURING SCHEDULED 20Y CHECK, FOUND LT OVERHEAD EMERGENCY EXIT BULLNOSE LIGHT ASSY BROKEN AT ROW 9. REMOVED AND REPLACED LENS PER MM.SDR SWAA110155Shear Tie · corrodedDURING SCHEDULED 18Y CHECK, FOUND SHEAR TIE CORRODED AT BS 787, BETWEEN STR 25R TO STR 26R. REPAIRED SHEAR TIE PER SRM.SDR SWAA110126Frame · corrodedDURING SCHEDULED 20Y CHECK, FOUND FRAME CORRODED AT BS 460, BETWEEN STR 28L TO STR 28R. REPAIRED FRAME PER SRM.SDR SWAA110125Channel · corrodedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO COMPARTMENT CHANNEL CORRODED AT BS 772, RBL 3. REPAIRED CHANNEL PER EA.SDR SWAA110083Bear Strap · corrodedDURING SCHEDULED 18Y CHECK, FOUND AFT CARGO COMPARTMENT BEAR STRAP SKIN CORRODED BETWEEN BS 827 TO BS 890, BETWEEN STR 22R TO STR 27R. REPAIRED SKIN PER EA.SDR SWAA110082Bear Strap · corrodedDURING SCHEDULED 18Y CHECK, FOUND AFT CARGO COMPARTMENT BEAR STRAP SKIN CORRODED AT BS 851, BETWEEN STR 23R TO STR 24R. REPAIRED SKIN PER EA.SDR SWAA110081Bear Strap · corrodedDURING SCHEDULED 18Y CHECK, FOUND AFT CARGO COMPARTMENT BEAR STRAP SKIN CORRODED BETWEEN BS 847 TO BS 867, BETWEEN STR 25R TO STR 26R. REPAIRED SKIN PER EA.SDR SWAA110080Bear Strap · corrodedDURING SCHEDULED 18Y CHECK, FOUND AFT CARGO BEAR STRAP SKIN CORRODED BETWEEN BS 767 TO BS 787, STR 25R. REPAIRED SKIN PER EA.SDR SWAA110076Fitting · corrodedDURING SCHEDULED 18Y CHECK, FOUND VERTICAL STABILIZER RT SIDE FITTING CORRODED AT STA 1088. REMOVED AND REPLACED FITTING PER EA.SDR SWAA110075Fitting · corrodedDURING SCHEDULED 18Y CHECK, FOUND VERTICAL STABILIZER LT SIDE FITTING CORRODED AT STA 1088. REMOVED AND REPLACED FITTING PER EA.SDR SWAA110074Frame · corrodedDURING SCHEDULED 18Y CHECK, FOUND FRAME CORRODED AT BS 482A, BETWEEN STR 28L TO STR 28R. REPAIRED FRAME PER EA.SDR SWAA110079Light · inoperativeDURING SCHEDULED MV1 CHECK, FOUND OVERHEAD EMERGENCY EXIT LIGHT INOP AT ROW 5. REPAIRED LIGHT PER MM.SDR SWAA107920Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 21L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA107919Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FRAME CRACKED AT BS 927, BETWEEN STR 18L TO STR 19L. REPAIRED FRAME PER SRM.SDR SWAA107918Flap · delaminatedDURING SCHEDULED 20Y CHECK, FOUND LT WING I/B FORE FLAP DELAMINATED. REPAIRED FORE FLAP PER SRM.SDR SWAA107917Stringer · corrodedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CORRODED AT BS 967, STR 26L. REMOVED AND REPLACED STRINGER PER SRM.SDR SWAA107916Shear Tie · corrodedDURING SCHEDULED 20Y CHECK, FOUND SHEAR TIE CORRODED AT BS 482B, BETWEEN STR 28L TO STR 28R. REMOVED AND REPLACED SHEAR TIE PER SRM AND BAC DWG.SDR SWAA107966Stringer Clip · brokenDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP BROKEN AT BS 947.5, STR 25R. REMOVED AND REPLACED STR CLIP PER SRM.SDR SWAA107870Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 482A, BETWEEN STR 19R TO STR 22R. REPAIRED FRAME PER SRM.SDR SWAA107921Battery Pack · dischargedDURING SCHEDULED MV2 CHECK, FOUND LT AFT EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA107915Skin · crackedDURING SCHEDULED MV3 CHECK, FOUND SKIN CRACKED AT BS 413, STR 1. REPAIRED SKIN PER SWA EA.SDR SWAA107874Door · crackedDURING SCHEDULED 2HC1 CHECK, FOUND LT COCKPIT EMERGENCY ROPE DOOR CRACKED. REPAIRED DOOR PER MM.SDR SWAA107873Skin · crackedDURING SCHEDULED 2HC1 CHECK, FOUND AFT CARGO DOOR OUTTER SKIN CRACKED AT OUTER HANDLE CUTOUT AFT RADIUS. REPAIRED SKIN PER SWA EA.SDR SWAA107872Skin · crackedDURING SCHEDULED 2HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT L2 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA107871Skin · crackedDURING SCHEDULED 2HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT R2 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA107848Priority Valve · faultyON LANDING IN SAN LOWERED LANDING GEAR AND GOT RED LIGHT ON LEFT GEAR. CYCLED GEAR 3 TIMES TO GET A GREEN LIGHT. REMOVED AND REPLACED MLG PRIORITY VALVE PER MM.SDR SWAA107833Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 787, STR 21R. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA107812Battery Pack · dischargedDURING SCHEDULED MV3 CHECK, FOUND L2 DOOR EXTERIOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA107798Circuit Card · faultyDIVERSION, UNSAFE NOSE GEAR, NO GREEN LIGHT ON EXIT. CYCLED SEVERAL TIMES WITH SAME INDICATION. REMOVED AND REPLACED NOSE LANDING GEAR DOWN PC SENSING CARD PER MM.SDR SWAA107769Holder · crackedDURING SCHEDULED 20Y CHECK, FOUND BOTH FWD EMERGENCY FLASHLIGHT HOLDERS CRACKED AT STRAP RETAINER INSERTS. REMOVED AND REPLACED HOLDERS PER MM.SDR SWAA107768Bracket · crackedDURING SCHEDULED 20Y CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE MOUNT BRACKET CRACKED. REMOVED AND REPLACED BRACKET PER SRM.SDR SWAA107767Flap · delaminatedDURING SCHEDULED 20Y CHECK, FOUND RT WING I/B FORE FLAP DELAMINATED. REPAIRED FORE FLAP PER SRM.
Back to Boeing 737-5H4