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 SWAA111565Frame · crackedDURING SCHEDULED OTS CHECK, FOUND FRAME CRACKED AT BS 482, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER SRM.SDR SWAA111542Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 913, STR 25R. REPAIRED SKIN PER EA.SDR SWAA111541Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 274, STR 15R. REPAIRED SKIN PER EA.SDR SWAA111540Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 371.5, STR 26L. REPAIRED SKIN PER EA.SDR SWAA111539Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 386, STR 15R. REPAIRED SKIN PER EA.SDR SWAA111866Tie Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND CRACK ON AFT CARGO COMPARTMENT TIE CLIP STA 727A, STR 21L. REPLACED TIE CLIP PER SRM.SDR SWAA111860Skin · crackedDURING SCHEDULED OTS CHECK, FOUND CRACK IN FUSELAGE SKIN STA 520 +2, BELOW STR 28R BELOW RT FWD CORNER OF CONDITIONED AIR DOOR. REPAIRED FUSELAGE SKIN PER ER.SDR SWAA111859Skin · crackedDURING SCHEDULED OTS CHECK, FOUND CRACK IN FUSELAGE SKIN STA 360 +18 ABOVE STR 15L. REPAIRED FUSELAGE SKIN PER EA.SDR SWAA111537Frame · corrodedDURING SCHEDULED 20Y CHECK, FOUND FRAME CORRODED AT BS 847, BETWEEN STR 27L TO STR 27R. REMOVED AND REPLACED FRAME PER SRM AND BAC DWG.SDR SWAA111536Frame · corrodedDURING SCHEDULED 20Y CHECK, FOUND FRAME CORRODED AT BS 847, BETWEEN STR 27L TO STR 27R. REMOVED AND REPLACED FRAME PER SRM AND BAC DWG.SDR SWAA111535Channel · corrodedDURING SCHEDULED 20YCHECK, FOUND AFT CARGO COMPARTMENT CHANNEL CORRODED AT BS 772, RBL 3.0. REMOVED AND REPLACED CHANNEL PER EA.SDR SWAA111534Channel · corrodedDURING SCHEDULED 20YCHECK, FOUND AFT CARGO COMPARTMENT CHANNEL CORRODED AT BS 772, LBL 8.10. REMOVED AND REPLACED CHANNEL PER EA.SDR SWAA111533Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 371.5, STR 26L. REPAIRED SKIN PER EA.SDR SWAA111548Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 967 + 6, STR 21L. REPAIRED SKIN PER EA.SDR SWAA111547Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 927 + 6, STR 21L. REPAIRED SKIN PER EA.SDR SWAA111418Channel · corrodedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO COMPARTMENT CHANNEL CORRODED AT BS 732, RBL 8.10. REPAIRED CHANNEL PER EA.SDR SWAA111417Channel · corrodedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO COMPARTMENT CHANNEL CORRODED AT BS 732B, RBL 3.0. REPAIRED CHANNEL PER EA.SDR SWAA111335Frame · corrodedDURING SCHEDULED 20Y CHECK, FOUND FRAME CORRODED AT BS 460, BETWEEN STR 28L TO BS 28R. REPAIRED FRAME PER SRM.SDR SWAA111334Frame · corrodedDURING SCHEDULED 20Y CHECK, FOUND FRAME CORRODED AT BS 460, BETWEEN STR 27R TO BS 28R. REPAIRED FRAME PER SRM.SDR SWAA111333Frame · corrodedDURING SCHEDULED 20Y CHECK, FOUND FRAME CORRODED AT BS 927, BETWEEN STR 25R TO BS 26R. REPAIRED FRAME PER SRM.SDR SWAA111332Stringer Splice · corrodedDURING SCHEDULED 20Y CHECK, FOUND STRINGER SPLICE CORRODED BETWEEN BS 1006 TO BS 1016, STR 26R. REMOVED AND REPLACED SPLICE PER SRM.SDR SWAA111311Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 25R. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA111290Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 947.5, STR 25R. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA111289Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND SKIN CRACKED BETWEEN BS 913 TO BS 954, BETWEEN STR 22R TO STR 27R. REPAIRED SKIN PER SRM.SDR SWAA111229Stringer Splice · corrodedDURING SCHEDULED 20Y CHECK, FOUND STRINGER SPLICE CORRODED AT BS 907, STR 22R. REMOVED AND REPLACED SPLICE PER SRM.SDR SWAA111228Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 947.5, STR 26R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA111819Skin · crackedDURING SCHEDULED 2HC2 CHECK, FOUND FUSELAGE SURFACE CRACK AT STA 520 +2 BELOW STR 28R AT CORNER OF GROUND COND AIR DOOR. REPAIRED CRACK PER SRM.SDR SWAA111818Skin · crackedDURING SCHEDULED 2HC2 CHECK, FOUND FUSELAGE CRACKED AT STA 747 +14 TO BS 747+ 17, STR 21L. REPAIRED PER SRM.SDR SWAA111817Skin · crackedDURING SCHEDULED 2HC2 CHECK, FOUND SURFACE CRACK AT STA 360+18 ABOVE STR 15L. REPAIRED PER SRM.SDR SWAA111419Skin · crackedDURING SCHEDULED MV3 CHECK, FOUND R2 DOOR CRACKED ON UPPER HINGE CUTOUT ON DOOR FRAME SKIN LOWER AFT CORNER. REMOVED AND REPLACED R2 DOOR PER MM.SDR SWAA111416Battery · dischargedDURING SCHEDULED OTS CHECK, FOUND R1 DOOR EXTERIOR EMERGENCY EXIT LIGHTS INOP. CHARGED BATTERY PER MM.SDR SWAA111415Battery · dischargedDURING SCHEDULED OTS CHECK, FOUND L1 DOOR COCKPIT ENTRY EMERGENCY EXIT LIGHTS INOP. CHARGED BATTERY PER MM.SDR SWAA111092Fitting · corrodedDURING SCHEDULED SPV CHECK, FOUND L2 DOOR EMERGENCY EVAC SLIDE GIRT BAR FITTING PLATES CORRODED. REMOVED AND REPLACED FITTING PER MM.SDR SWAA111091Fitting · corrodedDURING SCHEDULED SPV CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE GIRT BAR FITTING PLATES CORRODED. REMOVED AND REPLACED FITTING PER MM.SDR SWAA111090Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP BROKEN AT BS 807, STR 25L. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA111089Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP BROKEN AT BS 727, STR 22R. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA111088Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP BROKEN AT BS 767, STR 21L. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA111087Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP BROKEN AT BS 747, STR 25L. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA111086Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 482A, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER SRM.SDR SWAA111085Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 482, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER SRM.SDR SWAA111084Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 482A, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER SRM.SDR SWAA111083Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 482, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER SRM.SDR SWAA111063Fitting · corrodedDURING SCHEDULED 20Y CHECK, FOUND LT MLG TRUNNION FITTING LUG FACES CORRODED. REMOVED AND REPLACED FITTING PER EA.SDR SWAA111062Bracket · brokenDURING SCHEDULED 20Y CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE FWD BRACKET BROKEN. REMOVED AND REPLACED BRACKET PER SRM.SDR SWAA111288Battery Pack · dischargedDURING SCHEDULED MV1 CHECK, FOUND L2 DOOR EXTERIOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA111224Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND FUSELAGE SKIN CRACKED AT L2 DOOR LOWER FWD CORNER. REPAIRED SKIN PER SRM.SDR SWAA111227Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND SKIN CRACKED AT BS 393, STR 16R. REPAIRED SKIN PER EA.SDR SWAA111226Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND SKIN CRACKED AT BS 934, STR 24L. REPAIRED SKIN PER EA.SDR SWAA111225Slide · out of adjustDURING SCHEDULED HC2 CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA111001Fitting · corrodedDURING SCHEDULED 20Y CHECK, FOUND RT VERTICAL FIN TERMINAL FITTING CORRODED AT BS 1016. REPAIRED FITTING PER EA.
Back to Boeing 737-5H4