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 SWAA070331Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 639, STR 4L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA070318Skin · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE SKIN CRACKED AT RADIO ALTIMETER ANTENNA CUTOUT BS 390, BL 0. REPAIRED SKIN PER ER.SDR SWAA070256Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND L2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA070255Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA070254Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA070246Light · looseDURING SCHEDULED HC1 CHECK, FOUND EEPLS STRIP LOOSE AT ROW 6 DEF. SECURED EEPLS STRIP PER MM.SDR SWAA070202Sign · looseRIGHT OVERWING EMERGENCY EXIT SIGN LOOSE. SECURED SIGN PER MM.SDR SWAA070180Slide · out of adjustDURING SCHEDULED C3 CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA070179Slide · out of adjustDURING SCHEDULED C3 CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA070161Sign · dislodgedRIGHT OVERWING EMERGENCY EXIT SIGN FELL OFF. INSTALLED EXIT SIGN PER MM.SDR SWAA070113Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 370, STR 4L. REPAIRED SKIN PER SWA EA.SDR SWAA070112Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 735B, STR 4R. REPAIRED SKIN PER SRM.SDR SWAA070111Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 745, STR 4R. REPAIRED SKIN PER SRM.SDR SWAA070110Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 927, STR 23R. REPAIRED SKIN PER SWA EA.SDR SWAA070109Tab · wornDURING SCHEDULED C3 CHECK, RIGHT ELEVATOR TAB FAILED T/E FREE PLAY CHECK. REMOVED AND REPLACED ELEVATOR TAB ASSY PER MM.SDR SWAA070091Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 930, STR 24L. REPAIRED SKIN PER SWA EA.SDR SWAA070083Slide · low pressureR2 DOOR EMERGENCY EVAC SLIDE PRESSURE GAUGE INDICATED OUT OF LIMITS. REMOVED AND REPLACED EVAC SLIDE PER MM.SDR SWAA070075Slide · out of adjustR1 DOOR EMERGENCY EVAC SLIDE OUT ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA070061Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 872, STR 25R. REPAIRED SKIN PER SRM.SDR SWAA070023Lens · missingDURING SCHEDULED SERVICE CHECK, FOUND FWD RT EMERGENCY EXIT LIGHT LENS MISSING. INSTALLED LIGHT LENS PER MM.SDR SWAA065129Frame · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME SECTION PER ER AND SB.SDR SWAA065128Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 764, STR 23L. REPAIRED SKIN PER SWA EA.SDR SWAA065127Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 762, STR 22L. REPAIRED SKIN PER SWA EA.SDR SWAA065114Rod End · wornDURING SCHEDULED SERVICE CHECK, FOUND RT ELEVATOR TAB OUTBOARD CONTROL ROD AFT END BEARING AND BUSHING WORN. REMOVED AND REPLACED RT ELEVATOR TAB OUTBOARD ROD END AND BUSHING PER MM.SDR SWAA065117Rod End · wornDURING SCHEDULED SERVICE CHECK, FOUND LT ELEVATOR TAB INBOARD CONTROL ROD AFT END BEARING AND BUSHING WORN. REMOVED AND REPLACED LT ELEVATOR TAB INBOARD ROD END AND BUSHING PER MM.SDR SWAA065091Wire · looseDURING SCHEDULED SPV CHECK, FOUND R1 DOOR EMERGENCY EXIT SLIDE LIGHT INOP. FOUND WIRE W1150 LOOSE, SECURED WIRE PER MM.SDR SWAA065090Stringer · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER 14R, CRACKED AT BS 420. REPAIRED STRINGER PER SRM.SDR SWAA065089Stringer Splice · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER SPLICE CRACKED AT BS 360, STR 14R. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA065086Light · inoperativeLEFT OVERWING EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA065083Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 947, STR 24R. REPAIRED SKIN PER SWA EA.SDR SWAA065041Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 827, STR 10R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA065019Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 980, STR 20L. REPAIRED SKIN PER SWA EA.SDR SWAA065018Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 616, STR 5R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA065017Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT R2 DOOR CUTOUT FWD LOWER CORNER. REPAIRED SKIN PER SRM.SDR SWAA065016Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 970, STR 20L. REPAIRED SKIN PER SWA EA.SDR SWAA065006Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 887, STR 10L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA065005Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 827, STR 3L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA065004Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 4L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA065003Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 10L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA065002Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 894, STR 24L. REPAIRED SKIN PER SWA EA.SDR SWAA065001Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 777, STR 23L. REPAIRED SKIN PER SWA EA.SDR SWAA065000Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 777, STR 18L. REPAIRED SKIN PER SWA EA.SDR SWAA064999Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT RADIO ALTIMETER ANTENNA CUTOUT BS 427, LBL 3. REPAIRED SKIN PER ER.SDR SWAA065022Actuator · leakingON LANDING -A- HYDRAULIC SYSTEM FAILURE, ZERO PRESSURE, ZERO QUANTITY. BOTH LIGHTS ILLUMINATED. REMOVED AND REPLACED NR 8 GROUND SPOILER ACTUATOR PER MM.SDR SWAA064882Connector · looseDURING SCHEDULED SPV CHECK, FOUND EMERGENCY EXIT LIGHT INOP AT ROW 15 ABC. RESEATED D7274 PIN CONNECTOR PER MM.SDR SWAA064859Lamp · inoperativeDURING SCHEDULED MV2 CHECK, FOUND BULLNOSE EMERGENCY EXIT LIGHT INOP AT ROW 12 DEF. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA064858Slide · low pressureDURING SCHEDULED A1 CHECK, FOUND L2 DOOR EMERGENCY EVAC SLIDE PRESSURE GAUGE INDICATED OUT OF LIMITS. REMOVED AND REPLACED EVAC SLIDE PER MM.SDR SWAA064788Connector · looseDURING SCHEDULED SPV CHECK, FOUND MID CABIN EMERGENCY EXIT OVERHEAD LIGHTS INOP. SECURED BATTERY PACK CONNECTOR PER MM.SDR SWAA064787Light · inoperativeDURING SCHEDULED SPV CHECK, FOUND FWD CABIN EMERGENCY EXIT OVERHEAD LIGHTS INOP. REMOVED AND REPLACED LIGHT BULBS PER MM.SDR SWAA064786Battery Pack · dischargedDURING SCHEDULED SPV CHECK, FOUND MID CABIN EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK PER MM.
Back to Boeing 737-5H4