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 SWAA115367Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 827, STR 16R. REMOVED AND REPLACED CLIP PER SRM AND DWG.SDR SWAA115366Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 16L. REMOVED AND REPLACED CLIP PER SRM AND DWG.SDR SWAA115365Shear Tie · corrodedDURING SCHEDULED 22Y CHECK, FOUND SHEAR TIE CORRODED AT BS 947, BETWEEN STR 27L TO STR 26L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA115364Flap · puncturedDURING SCHEDULED 22Y CHECK, FOUND LT WING O/B TRAILING EDGE FORE FLAP PUNCTURED. REPAIRED FORE FLAP PER SRM.SDR SWAA115315Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED BETWEEN BS 765 TO BS 767.5, STR 22L. REPAIRED SKIN PER SRM.SDR SWAA115446Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 907+17, STR 24L. REPAIRED SKIN PER SRM.SDR SWAA115445Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 924, STR 24L. REPAIRED SKIN PER SRM.SDR SWAA115317Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED BETWEEN BS 412 TO BS 415, STR 1L. REPAIRED SKIN IAW EA.SDR SWAA115285Actuator · faultyAIR TURNBACK - NR 2 KRUEGER FLAP SHOWS FULLY EXTENDED WITH FLAP HANDLE FULL UP. REMOVED AND REPLACED NR 2 L/E FLAP ACTUATOR PER MM.SDR SWAA11273Skin · crackedDURING SCHEDULED CV CHECK FOUND, SKIN CRACKED AT BS 520+4, STR 7L. REPAIRED SKIN ER SRM.SDR SWAA115272Stringer Clip · crackedDURING SCHEDULED 22Y CHECK FOUND, STRINGER CLIP CRACKED AT BS 927, STR 14R. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA115243Flap · delaminatedDURING SCHEDULED 22Y CHECK, FOUND LT WING O/B T/E AFT FLAP I/B CORNER DELAMINATED. REPAIRED AFT FLAP IAW SRM.SDR SWAA115180Slide · out of positionDURING SCHEDULED MV2 CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MM.SDR SWAA115179Actuator · crackedDURING SCHEDULED MV1 CHECK, FOUND LT WING I/B GROUND SPOILER I/B ACTUATOR CRACKED. REMOVED AND REPLACED GROUND SPOILER ACTUATOR PER MM.SDR SWAA115152Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 942, STR 25R. REPAIRED SKIN PER ER.SDR SWAA115151Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND FLOOR WEB BEAM CRACKED AT BS 639, LBL 45.5. REPAIRED WEB IAW EO.SDR SWAA115150Skin · corrodedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO COMPARTMENT SKIN CORRODED AT BS 947+5, STR 27L. REMOVED AND REPLACED SKIN PER SRM AND DWG.SDR SWAA115149Floorbeam · corrodedDURING SCHEDULED 20Y CHECK, FOUND FLOORBEAM CORRODED AT BS 986.5, LBL 6. REPAIRED CHORD IAW EO AND EA.SDR SWAA115148Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE BEAR STRAP SKIN CORRODED BETWEEN BS 847 TO BS 867, BETWEEN STR 25R TO STR 26R. REPAIRED SKIN IAW EA.SDR SWAA115147Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE BEAR STRAP SKIN CORRODED AT BS 787+9, BETWEEN STR 26R TO STR 27R. REPAIRED SKIN IAW EA.SDR SWAA115146Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE BEAR STRAP SKIN CORRODED AT BS 787+13, BETWEEN STR 25R TO STR 26R. REPAIRED SKIN IAW EA.SDR SWAA115145Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE BEAR STRAP SKIN CORRODED AT BS 767+9, BETWEEN STR 25R TO STR 26R. REPAIRED SKIN IAW EA.SDR SWAA115144Door Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO DOOR LOWER EDGE FRAME CRACKED. REMOVED AND REPLACED DOOR PER MM.SDR SWAA115143Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND LT OVERHEAD EMERGENCY EXIT BULLNOSE LIGHT INOP AT ROW 6. RELAMPED LIGHT PER MM.SDR SWAA115142Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND RT OVERHEAD EMERGENCY EXIT BULLNOSE LIGHT INOP AT ROW 1. RELAMPED LIGHT PER MM.SDR SWAA115141Skin · crackedDURING SCHEDULED 2HC1 CHECK, FOUND SKIN CRACKED AT BS 767+12, STR 22L. REPAIRED SKIN PER SRM.SDR SWAA115140Skin · crackedDURING SCHEDULED 2HC1 CHECK, FOUND SKIN CRACKED AT BS 767+16, STR 22L. REPAIRED SKIN PER SRM.SDR SWAA115139Skin · crackedDURING SCHEDULED 2HC1 CHECK, FOUND SKIN CRACKED AT BS 767+7, STR 25L. REPAIRED SKIN PER SRM.SDR SWAA115063Stringer · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CRACKED AT BS 867+7, STR 23R. REPAIRED STRINGER IAW SRM AND DWG.SDR SWAA115062Tee Fitting · corrodedDURING SCHEDULED 20Y CHECK, FOUND TEE CHORD CORRODED BETWEEN BS 380 TO BS 400, STR 17R. REMOVED AND REPLACED TEE CHORD IAW SRM AND DWG.SDR SWAA115061Strap · crackedDURING SCHEDULED 20Y CHECK, FOUND STRAP CRACKED BETWEEN BS 947 TO BS 967, BETWEEN STR 23L TO STR 25L. REMOVED AND REPLACED STRAP PER SRM AND DWG.SDR SWAA115060Shear Tie · crackedDURING SCHEDULED 20Y CHECK, FOUND SHEAR TIE CRACKED AT BS 597, BETWEEN STR 17R TO STR 18R. REPAIRED SHEAR TIE PER EO AND EA.SDR SWAA115100Web · corrodedDURING SCHEDULED 20Y CHECK, FOUND WEB CORRODED BETWEEN BS 616 TO BS 639, STR 17L. REMOVED AND REPLACED WEB IAW SRM AND DWG.SDR SWAA115099Web · corrodedDURING SCHEDULED 20Y CHECK, FOUND WEB CORRODED BETWEEN BS 747 TO BS 767, STR 17R. REMOVED AND REPLACED WEB IAW SRM AND DWG.SDR SWAA115098Web · corrodedDURING SCHEDULED 20Y CHECK, FOUND WEB CORRODED BETWEEN BS 380 TO BS 400, STR 17R. REMOVED AND REPLACED WEB IAW SRM AND DWG.SDR SWAA115097Angle · crackedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO COMPARTMENT VERTICAL ANGLE CRACKED AT BS 727, STR 27R. REMOVED AND REPLACED TEE ANGLE PER SRM AND DWG.SDR SWAA115096Angle · crackedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO COMPARTMENT VERTICAL ANGLE CRACKED AT BS 727, STR 27L. REMOVED AND REPLACED TEE ANGLE PER SRM AND DWG.SDR SWAA115095Door Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND L2 DOOR FRAME CUTOUT LOWER HINGE CRACKED. REPAIRED FRAME PER SRM.SDR SWAA115059Lens · looseDURING SCHEDULED 22Y CHECK, FOUND LT OVERHEAD EMERGENCY EXIT BULLNOSE LIGHT LENS LOOSE. REMOVED AND REPLACED LENS IAW MM.SDR SWAA115040Adapter · faultyWITH FUEL IN CENTER TANK AND WITH ALL PUMP SWITCHES ON, FUEL TRANFERS TO RT MAIN TANK AT RATE OF 20 LBS PER MIN. REMOVED AND REPLACED NR 1 AND NR 2 SHUTOFF VALVE ADAPTER HOUSING ASSY PER MM. REMOVED AND REPLACED NR 2 TANK COUPLER O-RING.SDR SWAA115018Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND LT HORIZONTAL STABILIZER LOWER SURFACE SKIN CRACKED AT STA 57.9 TO STA 105.7. REPAIRED SKIN IAW EA.SDR SWAA115017Lens · brokenDURING SCHEDULED 20Y CHECK, FOUND FWD GALLEY EMERGENCY EXIT LIGHT LENS ASSY BROKEN. REMOVED AND REPLACED LENS ASSY IAW MM.SDR SWAA115016Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND SKIN CRACKED AT BS 360+18, STR 28L. REPAIRED SKIN IAW EA.SDR SWAA115012Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 867+14, STR 23R. REPAIRED SKIN PER EA.SDR SWAA114940Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND SKIN CRACKED AT BS 986.5, BETWEEN STR 6L TO STR 7L. REPAIRED SKIN PER SRM.SDR SWAA114939Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND FLOORBEAM WEB LOWER CHORD CRACKED BETWEEN BS 660 TO BS 666, RBL 24.8. REPAIRED CHORD PER EA.SDR SWAA114936Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE BEAR STRAP SKIN CRACKED BETWEEN BS 767 TO BS 847, BETWEEN STR 25R TO STR 26R. REPAIRED SKIN PER SRM.SDR SWAA114935Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE BEAR STRAP SKIN CRACKED AT BS 867, STR 25R. REPAIRED SKIN PER SRM.SDR SWAA114934Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE BEAR STRAP SKIN CRACKED AT BS 847, BETWEEN STR 26R TO STR 27R. REPAIRED SKIN PER SRM.SDR SWAA115014Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 945, STR 24R. REPAIRED SKIN PER SRM.
Back to Boeing 737-5H4