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 SWAA114617Stringer · crackedDURING SCHEDULED 20Y CHECK FOUND, STRINGER CRACKED AT BS 947+5, STR 27L. REMOVED AND REPLACED STRINGER PER SRM AND DWG.SDR SWAA114616Channel · corrodedDURING SCHEDULED 20Y CHECK FOUND, AFT CARGO COMPARTMENT CHANNEL CORRODED AT BS 767+6, RBL 8.10. REPAIRED CHANNEL IAW EA.SDR SWAA114615Light · inoperativeDURING SCHEDULED MV2 CHECK FOUND, LT OVERHEAD EMERGENCY EXIT BULLNOSE LIGHT INOP AT ROW 11. RELAMPED LIGHT PER MM.SDR SWAA114580Gasper Fan · faultyAFTER LEVEL AT FL 350, NOTICED ODOR IN COCKPIT AND CABIN. TURNED OFF GASPER FAN, ODOR CONTINUED. TURNED OFF RECIRC FAN ODOR STOPPED. REMOVED AND REPLACED GASPER FAN PER MM.SDR SWAA114570Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME SECTION AFT OUTER CHORD CRACKED AT BS 639, STR 16R. REPAIRED CHORD PER EA AND DWG.SDR SWAA114569Angle · crackedDURING SCHEDULED 20Y CHECK, FOUND CLIP ANGLE CRACKED AT BS 320, STR 20L. REMOVED AND REPLACED ANGLE IAW SRM AND DWG.SDR SWAA114568Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 25R. REMOVED AND REPLACED CLIP PER SRM AND DWG.SDR SWAA114549Floorbeam · crackedDURING SCHEDULED SPV CHECK, FOUND LONGITUDINAL FLOORBEAM WEB CRACKED AT BS 636, LBL 45.5. REPAIRED WEB PER ER.SDR SWAA114547Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 787, STR 20R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA114546Lens · delaminatedDURING SCHEDULED 20Y CHECK, FOUND FWD OVERHEAD EMERGENCY EXIT LIGHT LENS DELAMINATED. REPAIRED LENS PER MM.SDR SWAA114545Stringer · crackedDURING SCHEDULED OTS CHECK, FOUND STRINGER CRACKED AT BS 360+3.5, STR 15R. REMOVED AND REPLACED STRINGER PER EA.SDR SWAA114544Stringer · crackedDURING SCHEDULED OTS CHECK, FOUND STRINGER CRACKED AT BS 360+14.25, STR 15R. REMOVED AND REPLACED STRINGER PER EA.SDR SWAA114543Stringer · crackedDURING SCHEDULED OTS CHECK, FOUND STRINGER CRACKED AT BS 360+15.75, STR 15R. REMOVED AND REPLACED STRINGER PER EA.SDR SWAA114542Stringer · crackedDURING SCHEDULED OTS CHECK, FOUND STRINGER CRACKED AT BS 370, STR 15R. REMOVED AND REPLACED STRINGER EPR EA.SDR SWAA114541Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 380+15, STR 15R. REPAIRED SKIN PER EA.SDR SWAA114518Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 360+5, STR 15R. REPAIRED SKIN PER EA.SDR SWAA114517Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 400+10, STR 16R. REPAIRED SKIN PER EA.SDR SWAA114516Mount Bracket · crackedDURING SCHEDULED 22Y CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE AFT MOUTING BRACKET CRACKED. REMOVED AND REPLACED BRACKET IAW SRM AND DWG.SDR SWAA114519Cover · looseR1 DOOR EMERGENCY EXIT COVER LOOSE. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA114490Angle · crackedDURING SCHEDULED 20Y CHECK, FOUND ANGLE CLIP CRACKED AT BS 336, STR 20L. REMOVED AND REPLACED CLIP PER SRM AND DWG.SDR SWAA114489Angle · crackedDURING SCHEDULED 20Y CHECK, FOUND CLIP ANGLE CRACKED AT BS 328, STR 20L. REMOVED AND REPLACED ANGLE PER SRM AND DWG.SDR SWAA114488Tie Clip · brokenDURING SCHEDULED 20Y CHECK, FOUND TIE CLIP BROKEN AT BS 927, STR 24L. REMOVED AND REPLACED CLIP PER SRM AND DWG.SDR SWAA114487Support Bracket · crackedDURING SCHEDULED 20Y CHECK, FOUND SUPPORT BRACKET CRACKED AT BS 380, STR 26L. REMOVED AND REPLACED BRACKET PER SRM AND DWG.SDR SWAA114486Tie Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND TIE CLIP CRACKED AT BS 927, STR 25R. REMOVED AND REPLACED CLIP PER SRM AND DWG.SDR SWAA114485Angle · crackedDURING SCHEDULED SPV CHECK, FOUND LONGITUDINAL FLOORBEAM ANGLE CRACKED AT BS 639, LBL 45.5. REPAIRED ANGLE PER EA.SDR SWAA114436Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT L2 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER EO AND EA.SDR SWAA114432Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND SKIN CRACKED AT BS 947+4, STR 21L. REPAIRED SKIN PER EO.SDR SWAA114433Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND SKIN CRACKED AT BS 947+5, STR 22L. REPAIRED SKIN PER EO.SDR SWAA114434Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND SKIN CRACKED AT BS 927+7, STR 22L. REPAIRED SKIN PER EO.SDR SWAA114435Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND SKIN CRACKED AT BS 971, STR 21L. REPAIRED SKIN PER EO.SDR SWAA114384Beam · crackedDURING SCHEDULED 20Y CHECK, FOUND STUB BEAM CRACKED AT BS 616, LBL 70.53. REPAIRED BEAM PER EA.SDR SWAA114383Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT R2 DOOR LOWER FWD CORNER HINGE CUTOUT. REPAIRED SKIN PER EA.SDR SWAA114382Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT L2 DOOR LOWER AFT CORNER OF UPPER HINGE CUTOUT. REPAIRED SKIN PER EA.SDR SWAA114381Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND SKIN CRACKED AT BS 360, BETWEEN STR 5R TO STR 6R. REPAIRED SKIN PER EA.SDR SWAA114380Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 673.75, RBL 24.5. REPAIRED BEAM PER EA.SDR SWAA114379Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 707, LBL 24.5. REPAIRED BEAM PER EA.SDR SWAA114378Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 671, LBL 24.5. REPAIRED BEAM PER EA.SDR SWAA114377Web · crackedDURING SCHEDULED 22Y CHECK, FOUND E&E COMPARTMENT DOOR CUTOUT, RT WEB CRACKED AT BS 351, RBL 15. REPAIRED WEB PER SRM.SDR SWAA114376Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND SKIN CRACKED AT BS 440+15, STR 17L. REPAIRED SKIN PER EA.SDR SWAA114386Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 967 STR 24L. REPAIRED SKIN PER SRM.SDR SWAA114385Flap · delaminatedDURING SCHEDULED MV2 CHECK, FOUND LT WING AFT I/B FLAP DELAMINATED. REMOVED AND REPLACED AFT FLAP PER MM.SDR SWAA114341Light · inoperativeDURING SCHEDULED SPV CHECK, FOUND LT OVERWING EMERGENCY EXIT SIGN LIGHT INOP. REMOVED AND REPLACED BULB PER MM.SDR SWAA114351Crease Beam · corrodedDURING SCHEDULED 22Y CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 482A, STR 17L. REMOVED AND REPLACED WEB IAW BAC DWG.SDR SWAA114300Strap · crackedDURING SCHEDULED 20Y CHECK, FOUND LOWER STRAP CRACKED BETWEEN BS 947 TO BS 967, BETWEEN STR 22L TO STR 27L. REMOVED AND REPLACED STRAP PER SRM.SDR SWAA114301Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND SKIN CRACKED AT BS 843, STR 16L. REPAIRED SKIN PER EA.SDR SWAA114302Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR LOWER HINGE CUTOUT UPPER CORNER. REPAIRED SKIN PER SRM.SDR SWAA114324Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 727B, RBL 24.8. REPAIRED CHORD PER EA.SDR SWAA114323Floorbeam · corrodedDURING SCHEDULED 22Y CHECK, FOUND T-CAP CORRODED AT BS 986, BETWEEN LBL 5 TO RBL 14. REPAIRED T-CAP PER SRM.SDR SWAA114285Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 787, STR 19L. REPAIRED SKIN PER SRM AND EA.SDR SWAA114284Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 405, STR 17R. REPAIRED SKIN PER SRM AND EA.
Back to Boeing 737-5H4