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 SWAA103082Floor Support · corrodedDURING SCHEDULED 20Y CHECK, FOUND FLOOR SUPPORT CORRODED AT BS 770, LBL 8. REPAIRED SUPPORT PER EA.SDR SWAA103081Floor Support · corrodedDURING SCHEDULED 20Y CHECK, FOUND FLOOR SUPPORT CORRODED AT BS 750, LBL 8. REPAIRED SUPPORT PER EA.SDR SWAA103080Shear Tie · corrodedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SHEAR TIE CORRODED AT BS 847, STR 26R TO STR 27R. REMOVED AND REPLACED FRAME SHEAR TIE PER SRM.SDR SWAA103079Shear Tie · corrodedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SHEAR TIE CORRODED AT BS 767, STR 26R TO STR 27R. REMOVED AND REPLACED FRAME SHEAR TIE PER SRM.SDR SWAA103078Skin · delaminatedDURING SCHEDULED 20Y CHECK, FOUND RT WING O/B FORE FLAP UPPER SURFACE DELAMINATED. REPAIRED FLAP PER SRM AND EO.SDR SWAA103063Skin · crackedDURING SCHEDULED 2HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 864 TO BS 867, STR 25R. REPAIRED SKIN PER SRM.SDR SWAA103024Shear Tie · corrodedDURING SCHEDULED 20Y CHECK, FOUND SHEAR TIE CORRODED AT BS 787, BETWEEN STR 26R TO STR 27R. REPAIRED SHEAR TIE PER SRM.SDR SWAA102965Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 1006, STR 13R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA102964Shear Tie · corrodedDURING SCHEDULED 20Y CHECK, FOUND SHEAR TIE CORRODED AT BS 986, BETWEEN STR 25R TO STR 27R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA102937Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 482B, STR 19L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA102936Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 708, BBL 0.07. REPAIRED BEAM PER SI.SDR SWAA102935Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND RT HORIZONTAL STABILIZER LOWER SKIN CRACKED AT BS FWD OF REAR SPAR STAB STA 117. REMOVED AND REPLACED SKIN PER EA.SDR SWAA102934Skin · delaminatedDURING SCHEDULED 20Y CHECK, FOUND RT WING I/B FORE FLAP UPPER SURFACE DELAMINATED. REMOVED AND REPLACED FORE FLAP PER MM.SDR SWAA102933Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND LONGITUDINAL FLOORBEAM WEB CRACKED BETWEEN BS 709 TO BS 711, BBL 0.07. REPAIRED WEB PER SI.SDR SWAA102904Angle · crackedDURING SCHEDULED 20Y CHECK, FOUND ZEE ANGLE CRACKED AT RT WING FRONT SPAR LWR CHORD, FSS 243. REMOVED AND REPLACED ZEE ANGLE PER SRM.SDR SWAA102903Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 767, STR 24L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA102902Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 767, STR 23L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA102901Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 495, STR 15R. REPAIRED SKIN PER ER.SDR SWAA102900Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 791, STR 17L. REPAIRED SKIN PER ER.SDR SWAA102879Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 445, STR 1. REPAIRED SKIN PER ER.SDR SWAA102869Battery Pack · dischargedDURING SCHEDULED MV1 CHECK, FOUND FWD LT OVERHEAD EMERGENCY LIGHT BATTERY PACK INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA102868Battery Pack · dischargedDURING SCHEDULED MV1 CHECK, FOUND FWD RT OVERHEAD EMERGENCY LIGHT BATTERY PACK INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA102867Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 933, STR 23R. REPAIRED SKIN PER SRM AND EA.SDR SWAA102866Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 787, STR 25L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA102865Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 482B, STR 19R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA102864Light · inoperativeDURING SCHEDULED OTS CHECK, FOUND RT OVERHEAD BULLNOSE EMERGENCY EXIT LIGHT INOP AT ROW 13. REMOVED AND REPLACED LIGHT PER MM.SDR SWAA102863Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 445, STR 1. REPAIRED SKIN PER ER.SDR SWAA102852Slide · low pressureL1 DOOR EMERGENCY EVAC SLIDE GAUGE LOW PRESSURE. REMOVED AND REPLACED SLIDE ASSY PER MT.SDR SWAA102851Strap · crackedDURING SCHEDULED 20Y CHECK, FOUND L1 DOOR UPPER FWD HINGE CUTOUT IS CRACKED ON H-STRAP. REMOVED AND REPLACED STRAP PER SRM AND BAC DWG.SDR SWAA102850Strap · crackedDURING SCHEDULED 20Y CHECK, FOUND L1 DOOR LOWER FWD HINGE CUTOUT IS CRACKED ON H-STRAP. REMOVED AND REPLACED STRAP PER SRM AND BAC DWG.SDR SWAA102803Light · looseEEPLS LOOSE AT ROW 7. SECURED EEPLS PER MM.SDR SWAA102804Slide · out of positionR1 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MT.SDR SWAA102681Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 397, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA102679Lens · crackedL1 DOOR EMERGENCY EVAC SLIDE GAUGE VIEWING WINDOW LENS CRACKED. REMOVED AND REPLACED LENS PER MM.SDR SWAA102664Slide · out of positionL1 DOOR EMERGENCY EVAC SLIDE INADVERTENTLY FELL OUT OF CONTAINER, DID NOT DEPLOY. RE-INSTALLED SLIDE PER MT.SDR SWAA102653Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 482A, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER SRM.SDR SWAA102652Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 482, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER SRM.SDR SWAA102618Skin · crackedDURING SCHEDULED CV CHECK, FOUND SKIN CRACKED AT BS 884, STR 24R. REPAIRED SKIN PER SRM.SDR SWAA102617Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND SKIN CRACKED AT BS 492B, STR 15R. REPAIRED SKIN PER SRM.SDR SWAA102616Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND SKIN CRACKED AT BS 791, STR 17L. REPAIRED SKIN PER SRM.SDR SWAA102615Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 482, STR 15R. REPAIRED SKIN PER SRM.SDR SWAA102654Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 403, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA102512Shear Tie · crackedDURING SCHEDULED OTS CHECK, FOUND SHEAR TIE CRACKED AT BS 887, BETWEEN STR 24R TO STR 25R. REPAIRED SHEAR TIE PER SRM.SDR SWAA102511Frame · crackedDURING SCHEDULED OTS CHECK, FOUND FRAME CRACKED AT BS 420, STR 1. REPAIRED FRAME PER SRM.SDR SWAA102510Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 488B, STR 16R. REPAIRED SKIN PER ER.SDR SWAA102509Doubler · crackedDURING SCHEDULED OTS CHECK, FOUND CRACK ON DOUBLER STRAP ON AFT CARGO DOOR OPENING AT LOWER EDGE. REMOVED AND REPLACED DOUBLER PER SRM.SDR SWAA102508Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 424, STR 0. REPAIRED SKIN PER SRM.SDR SWAA102507Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 923, STR 24R. REPAIRED SKIN PER SRM.SDR SWAA102506Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 893, STR 25R. REPAIRED SKIN PER SRM.SDR SWAA102576Slide · out of adjustR2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.
Back to Boeing 737-5H4