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 SWAA112487Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 747+4, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA112503Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND SKIN CRACKED AT BS 400+12, STR 1. REPAIRED SKIN PER EA.SDR SWAA112428Window · arcedL1 COCKPIT WINDOW ARCED. REMOVED AND REPLACED WINDOW PER MM.SDR SWAA112294Bulkhead · crackedDURING SCHEDULED OTS CHECK, FOUND VERTICAL BEAM WEB CRACKED AT BS 178, RBL 5.7. REPAIRED WEB PER EA.SDR SWAA112257Strap · crackedDURING SCHEDULED SPV CHECK, FOUND H-STRAP CRACKED AT BS 307, STR 10L. REMOVED AND REPLACED H-STRAP PER ER AND EA.SDR SWAA112256Angle · crackedDURING SCHEDULED SPV CHECK, FOUND ANGLE WEB CRACKED BETWEEN BS 295 TO BS 297, STR 16L. REMOVED AND REPLACED ANGLE PER SRM.SDR SWAA112241Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 11L. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA112240Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 482, BETWEEN STR 19R TO STR 22R. REPAIRED FRAME PER SRM.SDR SWAA112187Skin · corrodedDURING SCHEDULED SPV CHECK, FOUND AFT CARGO DOOR CUTOUT CORRODED BETWEEN BS 799 TO BS 801, BETWEEN STR 22R TO STR 21R. REPAIRED SKIN PER EA.SDR SWAA112296Skin · crackedDURING SCHEDULED CV CHECK, FOUND SKIN CRACKED AT BS 950.5, STR 24R. REPAIRED SKIN PER SRM.SDR SWAA112295Lens · looseRT EMERGENCY EXIT LIGHT LOOSE. SECURED LENS PER MM.SDR SWAA111995Skin · crackedDURING SCHEDULED 2HC2 CHECK, FOUND SKIN CRACKED AT BS 807, STR 24L. REPAIRED SKIN PER EA.SDR SWAA111994Skin · crackedDURING SCHEDULED 2HC2 CHECK, FOUND SKIN CRACKED AT BS 767, STR 22L. REPAIRED SKIN PER EA.SDR SWAA111993Skin · crackedDURING SCHEDULED 2HC2 CHECK, FOUND SKIN CRACKED AT BS 442.5, STR 1. REPAIRED SKIN PER EA.SDR SWAA111934Battery · dischargedDURING SCHEDULED OTS CHECK, FOUND EEPSL INOP. CHARGED BATTERY PER MM EEPLS.SDR SWAA111920Bulkhead · crackedDURING SCHEDULED OTS CHECK, FOUND CRACKED WEB AT STA 178, LBL 5.7, WL 178. REPAIRED WEB PER SRM.SDR SWAA111919Frame · crackedDURING SCHEDULED OTS CHECK, FOUND CRACK RT SIDE FRAME FWD PIT STA 482. REPAIRED FRAME PER SRM.SDR SWAA111918Frame · crackedDURING SCHEDULED OTS CHECK, FOUND CRACK LT SIDE FRAME REINFORCEMENT FWD PIT STA 482A. REPAIRED FRAME PER SRM.SDR SWAA111863Sign · looseRT OVERWING EXIT DOOR EMERGENCY EXIT SIGN LOOSE. SECURED LIGHT ASSY PER MM.SDR SWAA111706Shear Tie · corrodedDURING SCHEDULED 20Y CHECK, FOUND SHEAR TIE CORRODED BETWEEN BS 927 TO BS 947.5, STR 26R. REMOVED AND REPLACED SHEAR TIE PER SRM AND BAC DWG.SDR SWAA111705Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR UPPER FWD CORNER. REPAIRED SKIN PER EA.SDR SWAA111704Rib · crackedDURING SCHEDULED 20Y CHECK, FOUND LT WING RIB LOWER CHORD CRACKED AT WBL 135.5, BETWEEN STR 2 TO STR 3. REPAIRED RIB CHORD PER ACO.SDR SWAA111703Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 663, RBL 24.5. REPAIRED BEAM PER EA.SDR SWAA111702Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 658, RBL 24.5. REPAIRED BEAM PER EA.SDR SWAA111701Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 669, LBL 24.5. REPAIRED BEAM PER EA.SDR SWAA111700Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 665, LBL 24.5. REPAIRED BEAM PER EA.SDR SWAA111699Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 658, LBL 24.5. REPAIRED BEAM PER EA.SDR SWAA111698Skin · delaminatedDURING SCHEDULED 20Y CHECK, FOUND RT WING O/B AFT FLAP O/B SKIN DELAMINATED. REPAIRED AFT FLAP PER SRM.SDR SWAA111697Skin · delaminatedDURING SCHEDULED 20Y CHECK, FOUND LT WING I/B AFT FLAP O/B SKIN DELAMINATED. REPAIRED AFT FLAP PER SRM.SDR SWAA111696Tab · delaminatedDURING SCHEDULED 20Y CHECK, FOUND RT WING T/E AILERON CONTROL TAB DELAMINATED. REPAIRED TAB PER SRM.SDR SWAA111695Channel · corrodedDURING SCHEDULED 20Y CHECK, FOUND CHANNEL CORRODED AT BS 727B+5, LBL 8.10. REPAIRED CHANNEL PER EA.SDR SWAA111694Stiffener · crackedDURING SCHEDULED 20Y CHECK, FOUND STIFFENER CRACKED AT BS 727, STR 27L. REMOVED AND REPLACED STIFFENER PER SRM AND BAC DWG.SDR SWAA111693Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 907, STR 25R. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA111688Skin · delaminatedDURING SCHEDULED 20Y CHECK, FOUND RT WING FORE FLAP UPPER SKIN DELAMIINATED. REPAIRED FORE FLAP PER SRM.SDR SWAA111687Skin · delaminatedDURING SCHEDULED 20Y CHECK, FOUND LT WING NR 4 SLAT I/B END UPPER SKIN DELAMINATED. REPAIRED SKIN PER SRM.SDR SWAA111686Web · crackedDURING SCHEDULED 20Y CHECK, FOUND FLIGHT DECK FLOOR WEB CUTOUT HOLE CRACKED AT BS 246.6+2.5, RBL 22.5. REPAIRED WEB PER ACO.SDR SWAA111685Angle · crackedDURING SCHEDULED 20Y CHECK, FOUND RT ELEVATOR L/E STABILIZER ANGLE CRACKED. REMOVED AND REPLACED ANGLE PER SRM AND BAC DWG.SDR SWAA111684Web · crackedDURING SCHEDULED 20Y CHECK, FOUND FLIGHT DECK FLOOR WEB CUTOUT HOLE CRACKED AT BS 246.6+2.5, RBL 17. REPAIRED WEB PER ACO.SDR SWAA111656Slat · crackedDURING SCHEDULED MV2 CHECK, FOUND LT WING L/E NR 1 SLAT CRACKED. REPAIRED SLAT PER SRM.SDR SWAA111858Slide · looseL1 DOOR EMERGENCY EXIT SLIDE LOOSE. RE-INSTALLED SLIDE PER MM.SDR SWAA111615Door · crackedDURING SCHEDULED MV2 CHECK, FOUND R1 DOOR UPPER FORWARD CORNER SEAL LANDING REVEAL CRACKED. REMOVED AND REPLACED R1 DOOR PER SRM.SDR SWAA111614Skin · crackedDURING SCHEDULED 2HC1 CHECK, FOUND SKIN CRACKED AT BS 390, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA111613Skin · crackedDURING SCHEDULED 2HC1 CHECK, FOUND SKIN CRACKED AT BS 967 + 5, STR 25L. REPAIRED SKIN PER SRM.SDR SWAA111612Skin · crackedDURING SCHEDULED 2HC1 CHECK, FOUND SKIN CRACKED AT BS 927 + 6, STR 25L. REPAIRED SKIN PER SRM.SDR SWAA111611Skin · crackedDURING SCHEDULED 2HC1 CHECK, FOUND SKIN CRACKED AT BS 747 + 16, STR 21L. REPAIRED SKIN PER SRM.SDR SWAA111610Skin · crackedDURING SCHEDULED 2HC1 CHECK, FOUND SKIN CRACKED AT BS 747 + 13, STR 24L. REPAIRED SKIN PER SRM.SDR SWAA111609Skin · crackedDURING SCHEDULED 2HC1 CHECK, FOUND SKIN CRACKED AT BS 747 + 7, STR 24L. REPAIRED SKIN PER SRM.SDR SWAA111608Skin · crackedDURING SCHEDULED 2HC1 CHECK, FOUND SKIN CRACKED AT BS 747 + 4, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA111567Frame · crackedDURING SCHEDULED OTS CHECK, FOUND FRAME CRACKED AT BS 482A, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER SRM.SDR SWAA111566Frame · crackedDURING SCHEDULED OTS CHECK, FOUND FRAME CRACKED AT BS 520, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER SRM.
Back to Boeing 737-5H4