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 SWAA096285Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER EA.SDR SWAA096284Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 807, STR 4L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096283Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 807, STR 9L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096282Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 747, STR 4L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096281Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 7L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096280Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 639, STR 4L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096279Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 7R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096278Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 482, STR 25R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096277Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 887, STR 4L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096265Slide · out of positionDURING SCHEDULED SPV CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MT.SDR SWAA096264Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 930, STR 21L. REPAIRED SKIN PER SRM.SDR SWAA096263Fitting · corrodedDURING SCHEDULED 20Y CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE GIRT BAR BOTH FITTING SPACER PLATES CORRODED. REMOVED AND REPLACED FITTING ASSY PER MM.SDR SWAA096262Fitting · corrodedDURING SCHEDULED 20Y CHECK, FOUND L2 DOOR EMERGENCY EVAC SLIDE GIRT BAR BOTH FITTING SPACER PLATES CORRODED. REMOVED AND REPLACED FITTING ASSY PER MM.SDR SWAA096261Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FWD CARGO DOOR AFT LOWER CORNER INNER CUTOUT SKIN CRACKED. REPAIRED SKIN PER SRM.SDR SWAA096260Keelbeam · corrodedDURING SCHEDULED 20Y CHECK, FOUND RT KEEL BEAM LOWER T-CHORD CORRODED AT BS 485B, STR 28R. REPAIRED BEAM PER SRM.SDR SWAA096259Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FWD CARGO DOOR AFT LOWER CORNER EDGE FRAME CRACKED. REMOVED AND REPLACED FRAME PER SRM.SDR SWAA096258Beam · corrodedDURING SCHEDULED 20Y CHECK, FOUND RT MLG BEAM I/B SUPPORT LINK CORRODED. REMOVED AND REPLACED BEAM PER MM.SDR SWAA096256Flap · corrodedDURING SCHEDULED 20Y CHECK, FOUND LT WING I/B MIDFLAP I/B GIMBLE SHAFT YOKE CORRODED ON BEARING BORES. REMOVED AND REPLACED MIDFLAP PER MM.SDR SWAA096255Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 747, BETWEEN STR 13R TO STR 14R. REPAIRED FRAME PER EA.SDR SWAA096352Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND RT OVERHEAD EMERGENCY EXIT BULLNOSE LIGHT INOP. REMOVED AND REPLACED LIGHT PER MM.SDR SWAA096247Fitting · corrodedDURING SCHEDULED 20Y CHECK, FOUND RT BS 685 FRAME LOWER FITTING CORRODED. REPAIRED FITTING PER EA.SDR SWAA096236Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 310, STR 4R. REPAIRED SKIN PER SRM.SDR SWAA096235Bulkhead · crackedDURING SCHEDULED SPV CHECK, FOUND AFT PRESSURE BULKHEAD CRACKED AT BS 1016, STR 15R. REPAIRED BULKHEAD PER SRM.SDR SWAA096234Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CRACKED AT BS 400, STR 4L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096233Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 685, STR 6L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096232Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 597, STR 7L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096231Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 597, STR 8L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096230Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 400, STR 4L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096229Frame · corrodedDURING SCHEDULED 20Y CHECK, FOUND FWD CARGO BAY FRAME CORRODED AT BS 482A, BL 0. REPAIRED FRAME PER SRM.SDR SWAA096228Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 291, BETWEEN STR 16R TO STR 17R. REPAIRED FRAME PER AAR EA.SDR SWAA096187Attach Fitting · crackedDURING SCHEDULED 20Y CHECK, FOUND RT WING I/B LOWER TRAILING EDGE PANEL SUPPORT ROD UPPER ATTACH FITTING CRACKED. REPAIRED FITTING PER SWA EA.SDR SWAA096189Lens · looseRIGHT OVERWING EMERGENCY EXIT LIGHT LENS LOOSE. REMOVED AND REPLACED LENS PER MM.SDR SWAA096176Flap · delaminatedDURING SCHEDULED 20Y CHECK, FOUND RT WING I/B FORE FLAP DELAMINATED. REPAIRED FORE FLAP PER SRM.SDR SWAA096175Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 767, STR 10R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096174Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 747, STR 10R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096173Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 5R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096172Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 6R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096171Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 8R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096170Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 578, STR 8R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096169Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 7R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096168Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 8R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096148Slat · delaminatedDURING SCHEDULED 18Y CHECK, FOUND RT WING NR 6 SLAT I/B AFT UPPER CORNER DELAMINATED. REPAIRED SLAT PER SRM.SDR SWAA096143Slat · delaminatedDURING SCHEDULED 18Y CHECK, FOUND RT WING L/E NR 4 SLAT O/B LOWER SURFACE DELAMINATED. REMOVED AND REPLACED SLAT PER MM.SDR SWAA096142Floorbeam · crackedDURING SCHEDULED 18Y CHECK, FOUND LONGITUDINAL FLOORBEAM WEB CRACKED AT BS 713, LBL 24.5. REPAIRED WEB PER AAR EA.SDR SWAA096141Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 847, STR 10R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096140Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 767, STR 7R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096123Slat · delaminatedDURING SCHEDULED 18Y CHECK, FOUND RT WING NR 4 SLAT O/B CORNER DELAMINATED. REPAIRED SLAT PER SRM.SDR SWAA096122Fitting · corrodedDURING SCHEDULED 18Y CHECK, FOUND LT HORIZONTAL STABILIZER FITTINGS LUG FACE CORRODED. REPAIRED FITTINGS PER SRM.SDR SWAA096121Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 947, STR 26L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096120Wedge · delaminatedDURING SCHEDULED 20Y CHECK, FOUND LT WING NR 3 SLAT O/B TRAILING EDGE WEDGE DELAMINATED. REPAIRED WEDGE PER MM.
Back to Boeing 737-5H4