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 SWAA080474Skin · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE SKIN CRACKED AT RADIO ALTIMETER ANTENNA CUTOUT BS 413, LBL 3. REPAIRED SKIN PER ER.SDR SWAA080456Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 294, STR 16R. REPAIRED FRAME PER ER.SDR SWAA080455Battery · dischargedDURING SCHEDULED MV1 CHECK, FOUND FWD CABIN EMERGENCY FLASHLIGHT INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA080426Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8L AND STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA080427Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA080424Skin · crackedDURING SCHEDULED MV4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 926, STR 21R. REPAIRED SKIN PER SRM.SDR SWAA080425Skin · crackedDURING SCHEDULED MV4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 951, STR 24R. REPAIRED SKIN PER SRM.SDR SWAA080396Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727, STR 14R. REPAIRED FRAME PER ER.SDR SWAA080355Stringer · corrodedDURING SCHEDULED 16Y CHECK, FOUND STRINGER 26R CORRODED AT BS 480. REPAIRED STRINGER PER SRM.SDR SWAA080356Shear Tie · corrodedDURING SCHEDULED 16Y CHECK, FOUND SHEAR TIE CORRODED AT BS 847, RBL 15, WL 150. REPAIRED SHEAR TIE PER SRM.SDR SWAA080338Shear Tie · crackedDURING SCHEDULED 16Y CHECK, FOUND SHEAR TIE CRACKED AT BS 360, LBL 13.5. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA080324Lens · out of positionRIGHT OVERWING EMERGENCY EXIT LIGHT LENS FELL OFF. INSTALLED LENS PER MM.SDR SWAA080315Stringer Splice · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER SPLICE CRACKED AT BS 907, STR 4R. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA080275Slide · out of adjustDURING SCHEDULED SPV CHECK, FOUND L2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA080288Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 807, STR 10R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080289Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 827, STR 4R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080290Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 847, STR 4R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080291Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 482B, STR 6R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080292Shear Tie · crackedDURING SCHEDULED 16Y CHECK, FOUND SHEAR TIE CRACKED AT BS 360, STR 15R. REPAIRED SHEAR TIE PER SRM.SDR SWAA080274Light · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND LT FWD FUSELAGE EMERGENCY EXIT EXTERIOR LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA080240Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 803, STR 24L. REPAIRED SKIN PER SRM.SDR SWAA080238Skin · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 887, STR 25R. REPAIRED SKIN PER SRM.SDR SWAA080239Bulkhead · crackedDURING SCHEDULED 16Y CHECK, FOUND AFT PRESSURE BULKHEAD WEB CRACKED AT BS 1016, STR 6L. REMOVED AND REPLACED WEB PER SRM.SDR SWAA080237Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED BETWEEN BS 780 AND BS 790, STR 18L AND STR 17L. REPAIRED SKIN PER SWA EA.SDR SWAA080221Stringer · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER 5L CRACKED AT BS 1010. REPAIRED STRINGER PER SRM.SDR SWAA080165Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 312, STR 4R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080164Shear Tie · crackedDURING SCHEDULED 16Y CHECK, FOUND SHEAR TIE CRACKED AT BS 360, STR 13R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA080172Beltframe · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE BELT FRAME CRACKED AT BS 482, STR 20R. REPAIRED FRAME PER SRM.SDR SWAA080163Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 769, STR 22L. REPAIRED SKIN PER SRM.SDR SWAA080137Slat · delaminatedDURING SCHEDULED 16Y CHECK, FOUND LT WING NR 1 L/E SLAT INBOARD T/E DELAMINATED. REPAIRED SLAT PER SRM.SDR SWAA080138Crease Beam · corrodedDURING SCHEDULED 16Y CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 360 TO BS 380, LBL 70. REMOVED AND REPLACED WEB PER SRM.SDR SWAA080145Fitting · corrodedDURING SCHEDULED 16Y CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR FITTING CORRODED. REMOVED AND REPLACED FITTING PER SRM.SDR SWAA080144Fitting · corrodedDURING SCHEDULED 16Y CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE AFT GIRT BAR FITTING CORRODED. REMOVED AND REPLACED FITTING PER SRM.SDR SWAA080143Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 482B, STR 10R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080142Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 867, STR 4R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080141Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 380, STR 8R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080140Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 277, STR 15R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080139Crease Beam · corrodedDURING SCHEDULED 16Y CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 807 TO BS 827, RBL 70. REMOVED AND REPLACED WEB PER SRM.SDR SWAA080136Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 932, STR 21R. REPAIRED SKIN PER SRM.SDR SWAA080157Lens · brokenDURING SCHEDULED BRDG CHECK, FOUND L1 DOOR EMERGENCY EXIT LIGHT LENS BROKEN. REMOVED AND REPLACED LIGHT LENS PER MM.SDR SWAA080158Connector · brokenDURING SCHEDULED BRDG CHECK, FOUND RT OVERWING EMERGENCY EXIT LIGHT CONNECTOR BROKEN. REPAIRED CONNECTOR PER MM.SDR SWAA080105Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 5L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080103Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 867, STR 4L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080104Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 7R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080102Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 520, STR 8L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080088Pressure Panel · crackedDURING SCHEDULED SPV CHECK, FOUND NLG W/W RIGHT CEILING WEB CRACKED AT SNUBBER ATTACH NUT PLATE. REPAIRED WEB PER ACO.SDR SWAA080089Pressure Panel · crackedDURING SCHEDULED SPV CHECK, FOUND NLG W/W LEFT CEILING WEB CRACKED AT SNUBBER ATTACH NUT PLATE. REPAIRED WEB PER ACO.SDR SWAA080079Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 520, STR 7L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080078Skin · crackedDURING SCHEDULED 16Y CHECK, FOUND RT WING NR 6 L/E SLAT SKIN CRACKED AT OUTBOARD T/E. REPAIRED SLAT PER SRM.SDR SWAA080081Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 747, STR 4L. REMOVED AND REPLACED STRINGER CLIP PER SRM.
Back to Boeing 737-5H4