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 SWAA116713Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 296.5, STR 7R. REPAIRED FRAME IAW EA ER.SDR SWAA116712Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR CUTOUT, BS 329, STR 8R. REPAIRED SKIN IAW ER AND EA.SDR SWAA116711Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 639, STR 16L. REPAIRED FRAME IAW ER AND EA.SDR SWAA116710Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND SKIN CACKED AT BS 727A+6, STR 21L. REPAIRED SKIN IAW ER AND EA.SDR SWAA116717Skin · crackedDURING SCHEDULED 16Y CHECK, FOUND LT WING NR 1 SLAT SKIN I/B CRACKED. REPAIRED SKIN IAW SRM.SDR SWAA116680Bulkhead · crackedDURING SCHEDULED 22Y CHECK, FOUND BULKHEAD LOWER CHORD HORIZONTAL FLANGE CRACKED AT BS 540, BETWEEN STR 21L TO STR 22L. REPAIRED FLANGE PER ER.SDR SWAA116679Bulkhead · crackedDURING SCHEDULED 22Y CHECK, FOUND BULKHEAD LOWER CHORD HORIZONTAL FLANGE CRACKED AT BS 540, STR 25L. REPAIRED FLANGE PER ER.SDR SWAA116678Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND FWD CARGO DOOR SKIN CUTOUT CRACKED. REPAIRED SKIN IAW ER AND EA.SDR SWAA116677Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 661, BBL 0. REPAIRED BEAM IAW ER AND EA.SDR SWAA116676Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND R1 DOOR FUSELAGE SKIN CRACKED AT BS 327, WL 210. REPAIRED SKIN IAW EA AND ER.SDR SWAA116675Skin · delaminatedDURING SCHEDULED 22Y CHECK, FOUND RT WING NR 5 SPOILER DELAMINATED ON UPPER SURFACE. REMOVED AND REPLACED SPOILER IAW MM.SDR SWAA116673Trim Tab · delaminatedDURING SCHEDULED 22Y CHECK, FOUND LT WING AILERON TRIM TAB I/B T/E CORNER DELAMINATED. REMOVED AND REPLACED TAB IAW MM.SDR SWAA116602Tab · delaminatedDURING SCHEDULED 22Y CHECK, FOUND LT WING AILERON TAB O/B END DELAMINATED. REPAIRED TAB IAW SRM AND DWG.SDR SWAA116601Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME WEB CRACKED AT BS 332.1, STR 8R. REMOVED AND REPLACED FRAME IAW SRM.SDR SWAA116600Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 482, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME IAW ATS ER.SDR SWAA116599Web · crackedDURING SCHEDULED 22Y CHECK, FOUND SUPPORT WEB CRACKED AT BS 344, STR 11R. REPAIRED WEB IAW ER AND EA.SDR SWAA116597Shear Tie · corrodedDURING SCHEDULED 22Y CHECK, FOUND SHEAR TIE CORRODED AT BS 482B, BETWEEN STR 28L TO STR 28R. REMOVED AND REPLACED SHEAR TIE IAW SRM AND DWG.SDR SWAA116596Floorbeam · corrodedDURING SCHEDULED 22Y CHECK, FOUND RT TEE CAP FLOOR SUPPORT UPPER SURFACE CORRODED AT ABS 986, BETWEEN BL 0 TO RBL 48. REMOVED AND REPLACED TEE CAP IAW EA.SDR SWAA116595Support Angle · crackedDURING SCHEDULED 22Y CHECK, FOUND SUPPORT ANGLE CRACKED BETWEEN BS 847 TO BS 867, STR 25R. REMOVED AND REPLACED SUPPORT ANGLE PER SRM AND DWG.SDR SWAA116594Shear Tie · crackedDURING SCHEDULED 22Y CHECK, FOUND SHEAR TIE CRACKED AT BS 967, STR 7L. REMOVED AND REPLACED SHEAR TIE IAW SRM AND DWG.SDR SWAA116593Shear Tie · corrodedDURING SCHEDULED 22Y CHECK, FOUND SHEAR TIE CORRODED AT BS 482B, BETWEEN STR 28R TO STR 28L. REMOVED AND REPLACED SHEAR TIE IAW SRM AND DWG.SDR SWAA116609Light · brokenDURING SCHEDULED 2HC2 CHECK, FOUND RT EEPLS BROKEN AT ROW 1. REMOVED AND REPLACED EEPLS PER MM.SDR SWAA116608Light · brokenDURING SCHEDULED 2HC2 CHECK, FOUND RT EEPLS BROKEN AT ROW 3. REMOVED AND REPLACED EEPLS PER MM.SDR SWAA116607Light · brokenDURING SCHEDULED 2HC2 CHECK, FOUND RT EEPLS BROKEN AT ROW 11. REMOVED AND REPLACED EEPLS PER MM.SDR SWAA116606Light · brokenDURING SCHEDULED 2HC2 CHECK, FOUND RT EEPLS BROKEN AT ROW 7. REMOVED AND REPLACED EEPLS PER MM.SDR SWAA116605Skin · crackedDURING SCHEDULED 2HC2 CHECK, FOUND SKIN CRACKED AT BS 803, STR 20L. REPAIRED SKIN PER SRM.SDR SWAA116604Skin · crackedDURING SCHEDULED 2HC2 CHECK, FOUND SKIN CRACKED BETWEEN BS 747+6 TO BS 747+8, STR 24L. REPAIRED SKIN PER SRM.SDR SWAA116549Skin · crackedDURING SCHEDULED 22Y CHECK FOUND, SKIN CRACKED AT BS 527-5, STR 17L. REPAIRED SKIN IAW EA.SDR SWAA116603Light · looseRT EEPLS LOOSE BETWEEN ROW 4 TO ROW 7. REMOVED AND REPLACED EEPLS PER MM.SDR SWAA116521Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 727A, WL 208. REMOVED AND REPLACED FRAME IAW SRM AND DWG.SDR SWAA116613Attach Angle · missingDURING SCHEDULED 2HC2 CHECK, FOUND RT ELEVATOR ATTACH ANGLE MISSING. REMOVED AND REPLACED ELEVATOR ASSY PER MM.SDR SWAA116612Skin · crackedDURING SCHEDULED 2HC2 CHECK, FOUND SKIN CRACKED AT BS 402, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA116611Slide · out of positionDURING SCHEDULED 2HC2 CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE INADVERTANTLY FELL OUT, DID NOT DEPLOY. REMOVED AND REPLACED SLIDE PER MT.SDR SWAA116610Slide · wornDURING SCHEDULED 2HC2 CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE WORN. REMOVED AND REPLACED SLIDE PER MT.SDR SWAA116490Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED BETWEEN BS 659 TO BS 669, LBL 24.5. REPAIRED CHORD PER EA AND ER.SDR SWAA116489Floor Support · corrodedDURING SCHEDULED 22Y CHECK, FOUND AFT CARGO COMPARTMENT FLOOR SUPPORT CORRODED AT BS 772, LBL 17. REPAIRED SUPPORT PER EA.SDR SWAA116488Shear Tie · corrodedDURING SCHEDULED 22Y CHECK, FOUND SHEAR TIE CORRODED AT BS 482A, BETWEEN STR 27R TO STR 26R. REMOVED AND REPLACED FRAME PER SRM.SDR SWAA116487Shear Tie · corrodedDURING SCHEDULED 22Y CHECK, FOUND SHEAR TIE CORRODED AT BS 482A, BETWEEN STR 28R TO STR 28L. REMOVED AND REPLACED FRAME PER SRM.SDR SWAA116482Keelbeam · corrodedDURING SCHEDULED 20Y CHECK, FOUND KEEL BEAM CORRODED BETWEEN BS 482B+4 TO BS 490, STR 28R. REPAIRED BEAM IAW EA.SDR SWAA116481Skin · corrodedDURING SCHEDULED 20Y CHECK, FOUND SKIN CORRODED BETWEEN BS 465 TO BS 471, BETWEEN STR 28R TOS TR 28L. REPAIRED SKIN IAW EO.SDR SWAA116480Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT L2 DOOR LOWER CORNER CUTOUT. REPAIRED SKIN IAW SRM.SDR SWAA116478Web · corrodedDURING SCHEDULED SPV CHECK, FOUND WEB CORRODED BETWEEN BS 440 TO BS 460, STR 17L. REMOVED AND REPLACED WEB IAW SRM AND DWG.SDR SWAA116476Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 321, BETWEEN STR 17L TO STR 21L. REMOVED AND REPLACED FRAME IAW SRM AND DWG.SDR SWAA116475Stringer · corrodedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CORRODED AT BS 794, STR 26R. REPAIRED STRINGER PER ER.SDR SWAA116472Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND FLOORBEAM WEB CRACKED BETWEEN BS 707 TO BS 713, BL 0. REPAIRED WEB PER SRM.SDR SWAA116467Support Fitting · crackedDURING SCHEDULED 22Y CHECK, FOUND SUPPORT FITTING CRACKED AT BS 332.1, STR 8R. REMOVED AND REPLACED FITTING IAW SRM AND DWG.SDR SWAA116550Frame · corrodedDURING SCHEDULED 22Y CHECK FOUND, SHEAR TIE CORRODED AT BS 482A, BETWEEN STR 27R TO STR 28R. REMOVED AND REPLACED FRAME PER SRM AND DWG.SDR SWAA116430Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME WEB CRACKED AT BS 277, STR 16L. REPAIRED WEB IAW SRM.SDR SWAA116429Channel · crackedDURING SCHEDULED 22Y CHECK, FOUND CHANNEL CRACKED AT BS 360, STR 4R. REPAIRED CHANNEL IAW EA.SDR SWAA116428Floorbeam · corrodedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM CORRODED AT BS 986.5, STR 16L. REPAIRED BEAM IAW ER.
Back to Boeing 737-5H4