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 SWAA105301Retaining Clip · out of adjustL2 DOOR EMERGENCY EVAC SLIDE GIRT RETAINING CLIPS OUT OF ADJUST. ADJUSTED CLIPS PER MT.SDR SWAA106753Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 780, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA105302Battery Pack · dischargedDURING SCHEDULED OTS CHECK, EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA105239Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 937, STR 21R. REPAIRED SKIN PER SRM.SDR SWAA105240Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND OVERHEAD BULLNOSE EMERGENCY EXIT LIGHT INOP BETWEEN ROW 6 TO ROW 7. RELAMPED PER MM.SDR SWAA105238Skin · corrodedDURING SCHEDULED 2HC1 CHECK, FOUND SKIN CORRODED AT BS 967, STR 26L. REPAIRED SKIN PER SRM.SDR SWAA105182Skin · crackedDURING SCHEDULED 2HC1 CHECK, FOUND SKIN CRACKED AT BS 933, STR 24L. REPAIRED SKIN PER SRM.SDR SWAA105181Skin · crackedDURING SCHEDULED 2HC1 CHECK, FOUND SKIN CRACKED AT BS 881, STR 24R. REPAIRED SKIN PER SRM.SDR SWAA105156Actuator · faultyAIR TURNBACK, AFTER T/O LEFT MAIN LANDING GEAR LIGHT REMAINED RED IN THE UP POSITION CYCLE LANDING GEAR INDICATION WERE GOOD. RAISED GEAR LEFT MAIN RED LIGHT REMAINED ON. REMOVED AND REPLACED LT MLG ACTUATOR AND UPLOCK ACTUATOR PER MM.SDR SWAA105154Gate · crackedDURING SCHEDULED CV CHECK, FOUND L2 DOOR LOWER WASTE GATE AFT UPPER EDGE CRACKED. REMOVED AND REPLACED DOOR PER MM.SDR SWAA105019Actuator · faultyAIR TURNBACK, RED LEFT GEAR LIGHT ILLUMINATED WHEN GEAR RETRACTED. RED AND GREEN LEFT GEAR LIGHT ILLUMINATED WHEN GEAR LEVEL POSITIONED TO OFF. REMOVED AND REPLACED LT MLG I/B LOCK ACTUATOR PER MM.SDR SWAA105083Skin · crackedDURING SCHEDULED 2HC2 CHECK, FOUND SKIN CRACKED AT BS 791, STR 19L. REPAIRED SKIN PER EA.SDR SWAA105082Skin · crackedDURING SCHEDULED 2HC2 CHECK, FOUND SKIN CRACKED AT BS 780, STR 19L. REPAIRED SKIN PER EA.SDR SWAA105081Support Fitting · crackedDURING SCHEDULED 2HC2 CHECK, FOUND AFT CARGO DOOR FWD AND AFT DOOR STOP T-CAP WEB SUPPORT FITTING CRACKED. REMOVED AND REPLACED DOOR PER MM.SDR SWAA104916Lens · looseRT OVERWING EMERGENCY EXIT LIGHT LENS LOOSE. REMOVED AND REPLACED LENS PER MM.SDR SWAA104792Skin · crackedDURING SCHEDULED OTS CHECK, FOUND R2 DOOR LOWER HINGE CUTOUT CRACKED AT AFT LOWER RADIUS. REPAIRED SKIN PER SRM.SDR SWAA104752Flap · delaminatedDURING SCHEDULED OTS CHECK, FOUND LT WING O/B AFT FLAP DELAMINATED. REPAIRED AFT FLAP PER MM.SDR SWAA104635Battery · inoperativeDURING SCHEDULED MV2 CHECK, FOUND RT MID CABIN EMERGENCY EXIT LIGHT BATTERY INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA104634Slide · looseL1 DOOR EMERGENCY EVAC SLIDE LOOSE. REMOVED AND REPLACED SLIDE PER MT.SDR SWAA104561Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND SKIN CRACKED AT BS 444, STR 1. REPAIRED SKIN PER EA.SDR SWAA104502Controller · malfunctionedAIR TURNBACK/DECLARED EMERGENCY. SMELL OF SMOKE IN MID CABIN AND IN COCKPIT CLIMBING THROUGH FL280. SMOKE DISSIPATED AFTER GASPER AND RECIRC FAN TURNED OFF. REMOVED AND REPLACED RT FRONT WINDOW HEAT CONTROLLER PER MM.SDR SWAA104501Slide · out of positionR1 DOOR EMERGENCY EVAC SLIDE INADVERTENTLY FELL OUT, DID NOT DEPLOY. RE-INSTALLED SLIDE PER MT.SDR SWAA104317Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 772, STR 25L. REPAIRED SKIN PER SRM.SDR SWAA104281Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND AFT CARGO DOOR SKIN CRACKED AT HANDLE CUTOUT UPPER AFT RADIUS. REPAIRED SKIN PER EA.SDR SWAA104284Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND SKIN CRACKED AT BS 265, STR 9L. REPAIRED SKIN PER SRM.SDR SWAA104283Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND SKIN CRACKED AT BS 432, STR 17R. REPAIRED SKIN PER EA.SDR SWAA104208Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 405, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA104181Sign · looseLT EMERGENCY EXIT SIGN LOOSE. SECURED SIGN PER MM.SDR SWAA104142Flap · delaminatedDURING SCHEDULED MV1 CHECK, FOUND LT WING I/B AFT FLAP DELAMINATED. REMOVED AND REPLACED AFT FLAP ASSY PER MM.SDR SWAA104110Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 810, STR 20L. REPAIRED SKIN PER SRM.SDR SWAA104109Flap · delaminatedDURING SCHEDULED MV2 CHECK, FOUND RT WING T/E FORE FLAP DELAMINATED. REMOVED AND REPLACED FORE FLAP PER MM.SDR SWAA104070Slide · out of positionL1 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MM.SDR SWAA104072Skin · crackedDURING SCHEDULED MV3 CHECK, FOUND SKIN CRACKED AT BS 883, STR 24R. REPAIRED SKIN PER SRM.SDR SWAA104071Skin · crackedDURING SCHEDULED MV3 CHECK, FOUND SKIN CRACKED AT BS 799, STR 23L. REPAIRED SKIN PER SRM.SDR SWAA104069Lens · brokenL1 DOOR LOWER EMERGENCY EXIT SIGN LENS BROKEN. INSTALLED LENS ASSY PER MM.SDR SWAA103983Filter · leakingDIVERSION - LOSS OF SYSTEM B HYDRAULICS IN FLIGHT. REMOVED AND REPLACED BROKEN O-RING ON NR 7 SPOILER AND CASE DRAIN FILTERS PER MM.SDR SWAA103920Spindle · crackedDURING SCHEDULED MV1 CHECK, FOUND LT WING T/O FLAP NR 2 CARRIAGE SPINDLE CRACKED. REMOVED AND REPLACED NR 2 SPINDLE PER EA.SDR SWAA103923Slide · out of positionL1 DOOR EMERGENCY EVAC SLIDE FELL OUT, DID NOT DEPLOY. SECURED SLIDE PER MT.SDR SWAA103922Spoiler · delaminatedRIGHT WING NR 9 GROUND SPOILER DELAMINATED. REMOVED AND REPLACED SPOILER PER MM.SDR SWAA103921Lens · brokenRIGHT OVERWING EMERGENCY EXIT SIGN BROKEN. REMOVED AND REPLACED LENS PER MM.SDR SWAA103891Control Cable · out of rigDIVERSION - ON TAKEOFF, FULL LEFT RUDDER NEEDED TO KEEP A/C ON CENTER LINE. FOUND NOSE WHEEL WELL STEERING CABLES OUT OF RIG PER MM. RIGGED STEERING CABLES PER MM.SDR SWAA103852Light · inoperativeDURING SCHEDULED 20Y CHECK, FOUND L2 DOOR EXTERIOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA103816Sign · damagedDURING SCHEDULED 20Y CHECK, FOUND FWD ENTRY EMERGENCY EXIT SIGN DAMAGED. REMOVED AND REPLACED SIGN PER MM.SDR SWAA103815Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME WEB CRACKED AT BS 303.9, STR 16L. REPAIRED WEB PER ACO.SDR SWAA103783Skin · corrodedDURING SCHEDULED 20Y CHECK, FOUND LT WING WING ROOT I/B SKIN CORRODED. REPAIRED SKIN PER AAR EA.SDR SWAA103768Fitting · crackedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO COMPARTMENT BULKHEAD FITTING CRACKED BS 727, RBL 6.5. REMOVED AND REPLACED FITTING PER SRM BAC DWG.SDR SWAA103707Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 482A, STR 20R. REPAIRED FRAME PER SRM.SDR SWAA103670Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 927, STR 26R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA103669Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND SKIN CRACKED AT BS 522, RBL 4.5. REPAIRED SKIN PER AAR EA.SDR SWAA103767Slide · unserviceableDURING SCHEDULED MV2 CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE PRESSURE GAUGE OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.
Back to Boeing 737-5H4