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 SWAA073212Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 5L. R&R STRINGER CLIP PER SRM.SDR SWAA073211Flap · debondedDURING SCHEDULED 18Y CHECK, FOUND RT WING OUTBOARD T/E AFT FLAP DISBONDED. REPAIRED FLAP PER SRM.SDR SWAA073210Hinge · crackedDURING SCHEDULED 18Y CHECK, FOUND R1 DOOR LOWER GATE HINGE CRACKED. R&R LOWER GATE HINGE PER SRM.SDR SWAA073209Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 304, STR 16L. REPAIRED FRAME PER SB.SDR SWAA073195Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 927, STR 11R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA073194Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 597, STR 16L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA073198Crease Beam · corrodedDURING SCHEDULED 18Y CHECK, FOUND CREASE BEAM WEB CORRODED BETWEEN BS 420 AND BS 440, LBL 69. REPAIRED CREASE BEAM WEB PER SRM.SDR SWAA073197Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT RT BS 616, LOWER ATTACH FASTENERS WL 201. REPAIRED FRAME PER SB.SDR SWAA073196Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT LT BS 616, LOWER ATTACH FASTENERS WL 201. REPAIRED FRAME PER SB.SDR SWAA073193Floorbeam · corrodedDURING SCHEDULED 18Y CHECK, FOUND FLOORBEAM UPPER CHORD CORRODED AT BS 294, RBL 38. REPAIRED FLOORBEAM CHORD PER SRM.SDR SWAA073192Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 787, STR 23L. REPAIRED SKIN PER SWA EA.SDR SWAA073160Stringer · crackedDURING SCHEDULED MV2 CHECK, FOUND STRINGER 18L CRACKED AT BS 747. REPAIRED STRINGER PER SRM.SDR SWAA073140Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 482A, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA073142Floorbeam · corrodedDURING SCHEDULED 18Y CHECK, FOUND FLOORBEAM CORRODED AT BS 947.5, LBL 5. REPAIRED FLOORBEAM PER SRM.SDR SWAA073132Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA073131Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA073126Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 294, STR 13L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA073127Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 420, STR 16R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA073128Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 482, STR 16R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA073129Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 663.75, STR 10R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA073125Slat · wornDURING SCHEDULED 18Y CHECK, FOUND LEFT WING NR 5 L/E SLAT WORN AT INBOARD T/E. REPAIRED SLAT PER SRM.SDR SWAA073139Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727B, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073130Shear Tie · corrodedDURING SCHEDULED 18Y CHECK, FOUND SHEAR TIE CORRODED AT BS 967, STR 8R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA073138Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA073137Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8L AND STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073136Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8L AND STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073135Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8L AND STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073134Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8L AND STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073133Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 597, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA073141Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA073143Skin · debondedDURING SCHEDULED 18Y CHECK, FOUND RIGHT WING OUTBOARD T/E AFT FLAP UPPER SKIN DISBONDED AT INBOARD END. REPAIRED FLAP PER SRM.SDR SWAA073144Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 760, STR 22L. REPAIRED SKIN PER SRM.SDR SWAA073109Skin · debondedDURING SCHEDULED 18Y CHECK, FOUND RIGHT WING INBOARD FORE FLAP LOWER SURFACE DISBONDED. REPAIRED FORE FLAP PER SRM.SDR SWAA073111Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073110Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073057Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER SWA EA.SDR SWAA073051Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 482, STR 10L. REPAIRED SKIN PER SWA EA.SDR SWAA073054Battery · inoperativeDURING SCHEDULED A1 CHECK, FOUND LEFT OVERWING EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA073031Slide · dislodgedL1 DOOR EMERGENCY EVAC SLIDE FELL OUT, DID NOT DEPLOY. INSTALLED EVAC SLIDE PER MM.SDR SWAA072990Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 616, STR 5R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072988Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT EQUIPMENT COOLING DUCT CUTOUT BS 380, BETWEEN LBL 2.8 AND BL 0. REPAIRED SKIN PER SWA EA.SDR SWAA072938Skin · crackedDURING SCHEDULED OTS CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 971, STR 21L. REPAIRED SKIN PER SRM.SDR SWAA072936Skin · crackedDURING SCHEDULED OTS CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 789, STR 18L. REPAIRED SKIN PER SWA EA.SDR SWAA072937Skin · crackedDURING SCHEDULED OTS CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 803, STR 24L. REPAIRED SKIN PER SRM.SDR SWAA072927Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 360, STR 14R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA072926Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA072895Glowstrip · looseEEPLS PHOTOLUMINESCENT STRIP LOOSE AT ROW 5 DEF. SECURED STRIP PER MM.SDR SWAA072897Slide · low pressureDURING SCHEDULED SERVICE CHECK, FOUND L2 DOOR EMERGENCY EVAC SLIDE GAUGE INDICATED OUT OF LIMITS. REMOVED AND REPLACED EVAC SLIDE PER MM.SDR SWAA072877Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 360, STR 13L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA072878Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 360, STR 15L. REMOVED AND REPLACED SHEAR TIE PER SRM.
Back to Boeing 737-5H4