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 SWAA093897Outflow Valve · faultyDIVERSON / DECLARED EMERGENCY. DURING CRUISE AT FL 230, CABIN ALTITUDE WARNING HORN SOUNDED, CREW DONNED 02 MASKS AND COMMENCED DESCENT, COMPLETED QRH CHECKLIST. NO OTHER PROBLEMS NOTED WITH AIRCRAFT (RAPID DEPRESSURIZATION). REMOVED AND REPLACED CABIN PRESDR SWAA093905Light · missingEEPLS STRIP MISSING NEAR ROW 5. REMOVED AND REPLACED EEPLS PER MM.SDR SWAA093874Light · missingEEPLS MISSING. INSTALLED EEPLS PER MM.SDR SWAA093842Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR UPPER HINGE CUTOUT, BETWEEN BS 303 TO BS 304, BETWEEN WL 259 TO WL 260. REPAIRED SKIN PER AAR EA.SDR SWAA093822Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER AAR EA.SDR SWAA093825Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR LOWER HINGE CUTOUT BS 303, WL 239.5. REPAIRED SKIN PER SRM.SDR SWAA093823Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND AFT CARGO DOOR CUTOUT FWD FRAME CRACKED AT O/B LOWER CORNER OF LOWER DOOR STOP FITTING. REPAIRED FRAME PER AAR EA.SDR SWAA093826Attach Angle · crackedDURING SCHEDULED SPV CHECK, FOUND AFT CARGO FLOOR LOWER FRAME ATTACH ANGLE CRACKED AT BS 794, RBL 8. REMOVED AND REPLACED ANGLE PER BAC DWG.SDR SWAA093824Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR LOWER HINGE CUTOUT CRACKED AT BS 304.5, WL 239.5. REPAIRED SKIN PER SRM.SDR SWAA093744Panel · leakingAIR TURNBACK / DECLARED EMERGENCY. FUEL LEAK TOP OF RT WING - VISIBLE IN FLIGHT. FUEL WAS SEEN STREAMING FROM PANEL ON TOP OF WING. FUEL COMING FROM PANEL 8817R. REMOVED AND REPLACED PANEL PER MM.SDR SWAA093713Flap · delaminatedDURING SCHEDULED SPV CHECK, FOUND RT WING TRAILING EDGE O/B AFT FLAP DELAMINATED. REMOVED AND REPLACED AFT FLAP PER MM.SDR SWAA093712Skin · crackedDURING SCHEDULED SPV CHECK, FOUND LT HORIZONTAL STABILIZER LOWER SURFACE CRACKED. REPAIRED STABILIZER PER SWA EA.SDR SWAA093548Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR UPPER HINGE CUTOUT, BETWEEN BS 292 TO BS 304, BETWEEN WL 234 TO WL 262. REPAIRED SKIN PER EA.SDR SWAA093536Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 413, STR 17L. REPAIRED SKIN PER SWA EA.SDR SWAA093535Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 436, STR 17R. REPAIRED SKIN PER SWA EA.SDR SWAA093534Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 767, STR 22L. REPAIRED SKIN PER SRM.SDR SWAA093529Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 739.5, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA093530Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 770, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA093531Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 880.5, STR 25R. REPAIRED SKIN PER SRM.SDR SWAA093533Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 900, STR 25R. REPAIRED SKIN PER SRM.SDR SWAA093532Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 930, STR 21R. REPAIRED SKIN PER SRM.SDR SWAA093443Skin · crackedDURING SCHEDULED 2HC2 CHECK, FOUND RT WING L/E SKIN CRACKED AT STA 213. REPAIRED SKIN PER SWA EA.SDR SWAA093452Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR UPPER HINGE CUTOUT, BETWEEN BS 292 TO BS 304, BETWEEN WL 234 TO WL 262. REPAIRED SKIN PER AAR EA.SDR SWAA093422Slide · out of adjustDURING SCHEDULED 2HC1 CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA093423Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND RT OVERWING EMERGENCY EXIT SIGN LIGHT BULBS INOP. RELAMPED PER MM.SDR SWAA093369Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR LOWER HINGE CUTOUT, AT BS 292, WL 232. REPAIRED SKIN PER SRM.SDR SWAA093368Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR LOWER HINGE CUTOUT, AT BS 293, WL 236. REPAIRED SKIN PER SRM.SDR SWAA093367Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR LOWER HINGE CUTOUT, AT BS 292, BETWEEN WL 232 TO WL 236. REPAIRED SKIN PER SRM.SDR SWAA093366Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 767, STR 22L. REPAIRED SKIN PER SRM.SDR SWAA093365Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 900, STR 25R. REPAIRED SKIN PER SRM.SDR SWAA093364Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 770, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA093363Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 779, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA093362Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 930, STR 21R. REPAIRED SKIN PER SRM.SDR SWAA093361Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 880, STR 25R. REPAIRED SKIN PER SRM.SDR SWAA093323Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 847, STR 24L. REPAIRED SKIN PER SRM.SDR SWAA093234Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FWD CARGO DOOR CUTOUT FWD FRAME CRACKED AT BS 400. R&R FRAME PER ACO.SDR SWAA093235Slide · looseL1 DOOR EMERGENCY EVAC SLIDE LOOSE. SECURED SLIDE PER MM.SDR SWAA093233Lens · crackedDURING SCHEDULED CV CHECK, FOUND R2 DOOR LOWER AFT EMERGENCY EXIT LIGHT LENS CRACKED. R&R LENS PER MM.SDR SWAA093202Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE BEARSTRAP SKIN CRACKED AT L1 DOOR LOWER HINGE, BETWEEN BS 302 TO BS 304, WL 238. REPAIRED SKIN PER AAR EA.SDR SWAA093201Slide · out of positionL1 DOOR EMERGENCY EVAC SLIDE PULLED OUT OF CASE, DID NOT DEPLOY. INSTALLED SLIDE PER MT.SDR SWAA093174Sign · looseRT OVERWING EMERGENCY EXIT SIGN LOOSE. REMOVED AND REPLACED SIGN PER MM.SDR SWAA093173Slide · out of adjustDURING SCHEDULED HC2 CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA093127Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 421, STR 17L. REPAIRED SKIN PER SRM.SDR SWAA093030Slide · out of positionDURING SCHEDULED HC1 CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MM.SDR SWAA093003Battery Pack · dischargedDURING SCHEDULED MV1 CHECK, FOUND SEVERAL EGRESS LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA093002Light · inoperativeDURING SCHEDULED MV1 CHECK, FOUND RT EMERGENCY EXIT LIGHT SIDEWALL LIGHT INOP. RELAMPED EMERGENCY LIGHT PER MM.SDR SWAA093004Light · looseEEPLS STRIP LOOSE AT ROW 7. SECURED EEPLS PER MM.SDR SWAA092788Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED BETWEEN BS 920 TO BS 921, STR 24L. REPAIRED SKIN PER SRM.SDR SWAA092787Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED BETWEEN BS 824 TO BS 825, STR 24L. REPAIRED SKIN PER SRM.SDR SWAA092786Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED BETWEEN BS 799 TO BS 801, STR 23L. REPAIRED SKIN PER SRM.
Back to Boeing 737-5H4