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 SWAA096119Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER AAR EA.SDR SWAA096118Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 482A, STR 8L. REPAIRED FRAME PER AAR EA.SDR SWAA096105Slide · out of adjustDURING SCHEDULED SPV CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MT.SDR SWAA096104Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 930, STR 25L. REPAIRED SKIN PER SRM.SDR SWAA096041Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER EA.SDR SWAA096040Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME PER EA.SDR SWAA096039Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 747, STR 8R. REPAIRED FRAME PER EA.SDR SWAA096038Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 482, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA096037Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER EA.SDR SWAA096036Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 380, STR 8R. REPAIRED FRAME PER EA.SDR SWAA096035Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 807, BETWEEN STR 13L TO STR 14L. REPAIRED FRAME PER EA.SDR SWAA096026Panel · looseDURING SCHEDULED 20Y CHECK, FOUND LOWER KEEL BEAM PANEL LOOSE BETWEEN BS 663 TO BS 727. REMOVED AND REPLACED PANEL PER EA.SDR SWAA096025Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 482A, STR 8L. REPAIRED FRAME PER EA.SDR SWAA096024Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 482, STR 8L. REPAIRED FRAME PER EA.SDR SWAA096023Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME PER EA.SDR SWAA096022Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 482A, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA095983Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 7L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096008Slat · delaminatedDURING SCHEDULED 18Y CHECK, FOUND RT WING NR 5 SLAT O/B AFT UPPER CORNER DELAMINATED. REPAIRED SLAT PER SRM.SDR SWAA096007Flap · delaminatedDURING SCHEDULED 20Y CHECK, FOUND LT WING I/B FORE FLAP DELAMINATED. REPAIRED FORE FLAP PER MT.SDR SWAA096006Floorbeam · crackedDURING SCHEDULED 18Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED BS 692, RBL 24.5. REPAIRED BEAM PER SRM.SDR SWAA096005Floorbeam · crackedDURING SCHEDULED 18Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED BETWEEN BS 707 TO BS 714, BBL 0.07. REPAIRED WEB PER SRM.SDR SWAA096004Plate · corrodedDURING SCHEDULED 18Y CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR PLATE CORRODED. REMOVED AND REPLACED PLATE PER MM.SDR SWAA096003Keelbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND LT KEEL BEAM CRACKED AT BS 711, LBL 5. REPAIRED BEAM PER SRM.SDR SWAA096002Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 767, STR 22L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096001Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 616, STR 5R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096000Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 616, STR 8L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA095999Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 827, STR 8L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA095998Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 4R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA095997Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 4R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA095996Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 400, STR 3R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA095995Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 559, STR 6L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA095994Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 794, BETWEEN STR 25R TO STR 26R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA095982Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 6L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA095981Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 663, STR 10L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA095980Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 5R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA095979Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 8L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA095978Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 7L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA095977Stringer Splice · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER SPLICE CRACKED BETWEEN BS 907 TO BS 908, STR 4L. REMOVED AND REPLACED SPLICE PER SRM.SDR SWAA095976Stringer Splice · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER SPLICE CRACKED BETWEEN BS 907 TO BS 908, STR 4R. REMOVED AND REPLACED SPLICE PER SRM.SDR SWAA095975Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 460, STR 11R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA095974Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 440, STR 10R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA095973Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 460, STR 10R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096049Shear Tie · crackedDURING SCHEDULED 20Y CHECK, FOUND SHEAR TIE CRACKED AT BS 616, STR 5L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA095927Fitting · looseDURING SCHEDULED SPV CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE AFT GIFT BAR FITTING LOOSE. SECURED FITTING PER MM.SDR SWAA095926Battery Pack · dischargedDURING SCHEDULED SPV CHECK, FOUND OVERWING EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA095928Light · brokenDURING SCHEDULED MV1 CHECK, FOUND L1 DOOR LOWER EMERGENCY EXIT LIGHT ASSY BROKEN. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA095864Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND NR 2 L/E SLAT LOWER SKIN CRACKED. REPAIRED SLAT SKIN PER SRM.SDR SWAA095823Stringer Clip · crackedDURING SCHEDULED 10Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 380, BETWEEN STR 25L TO STR 26L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA095822Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 887, STR 4R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA095821Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 616, STR 4R. REMOVED AND REPLACED CLIP PER SRM.
Back to Boeing 737-5H4