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 SWAA080082Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 887, STR 4L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080083Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 277, STR 10R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080084Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 8R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080085Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 747, STR 4R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080080Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 639, STR 2L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080087Skin · delaminatedDURING SCHEDULED 16Y CHECK, FOUND LT WING INBOARD FORE FLAP LOWER SURFACE DELAMINATED. REPAIRED FLAP PER SRM.SDR SWAA080086Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 787, STR 4R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080017Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 787, STR 10L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080034Skin · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 750, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA080033Skin · crackedDURING SCHEDULED THRU CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 971, STR 21L. REPAIRED SKIN PER SWA EA.SDR SWAA080032Slide · out of adjustL1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA080022Mount · wornDURING SCHEDULED SERVICE CHECK, FOUND NR 1 ENGINE FWD OUTBOARD MOUNT WORN. REMOVED AND REPLACED MOUNT PER MM.SDR SWAA080042Shear Tie · crackedDURING SCHEDULED BRDG CHECK, FOUND SHEAR TIE CRACKED AT BS 967, STR 7L. REPAIRED SHEAR TIE PER SRM.SDR SWAA080043Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 559, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA080044Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 706, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA080045Tee Fitting · crackedDURING SCHEDULED BRDG CHECK, FOUND RIGHT W/W SUPPORT RING LOWER TEE CHORD CRACKED AT STA 712. REPAIRED TEE CHORD PER SRM.SDR SWAA080046Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 967, STR 7L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080041Floorbeam · corrodedDURING SCHEDULED BRDG CHECK, FOUND FLOORBEAM CORRODED AT BS 986, LBL 30 TO LBL 47. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA076526Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727B, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA076525Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA076524Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 597, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA076523Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA076522Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 482A, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA076521Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 482, STR 8R AND STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA076520Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R AND STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA076527Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA076460Frame · crackedDURING SCHEDULED BRIDGE CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA076470Stringer Clip · crackedDURING SCHEDULED BRIDGE CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 360, STR 5L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA076469Skin · crackedDURING SCHEDULED BRIDGE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 394, RBL 2 AT RADIO ALTIMETER CUTOUT. REPAIRED SKIN PER SWA EA.SDR SWAA076468Fitting · corrodedDURING SCHEDULED BRIDGE CHECK, FOUND RT WING AFT SPAR SUPPORT FITTING NR 7 MAIN FLAP TRACK CORRODED AT OUTBOARD FLAP TRACK MOUNT HOLE. REMOVED AND REPLACED AFT SPAR SUPPORT FITTING PER MM.SDR SWAA076467Support Fitting · corrodedDURING SCHEDULED BRIDGE CHECK, FOUND LT WING AFT SPAR SUPPORT FITTING NR 1 MAIN FLAP TRACK CORRODED AT OUTBOARD FLAP TRACK MOUNT HOLE. REMOVED AND REPLACED AFT SPAR SUPPORT FITTING PER MM.SDR SWAA076466Floorbeam · crackedDURING SCHEDULED BRIDGE CHECK, FOUND FUSELAGE FLOORBEAM CRACKED AT BS 947.5, LT LOWER SIDE AT CORNER FASTENER HOLE. REPAIRED FLOORBEAM PER SWA EA & SRM.SDR SWAA076465Frame · crackedDURING SCHEDULED BRIDGE CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA076464Frame · crackedDURING SCHEDULED BRIDGE CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA076463Frame · crackedDURING SCHEDULED BRIDGE CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA076462Frame · crackedDURING SCHEDULED BRIDGE CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727B, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA076459Frame · crackedDURING SCHEDULED BRIDGE CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 482, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA076458Frame · crackedDURING SCHEDULED BRIDGE CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA076457Frame · crackedDURING SCHEDULED BRIDGE CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA076456Frame · crackedDURING SCHEDULED BRIDGE CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 277, STR 16R. REMOVED AND REPLACED FRAME PER SRM.SDR SWAA076461Frame · crackedDURING SCHEDULED BRIDGE CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727A, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA076474Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA076471Skin · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 479, STR 23R. REPAIRED SKIN PER SRM.SDR SWAA076472Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 727B, STR 8L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA076478Floorbeam · corrodedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FLOORBEAM CORRODED AT BS 946, RBL 5. REPAIRED FLOORBEAM PER SRM.SDR SWAA076473Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727B, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA076475Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA076477Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 277, STR 16L. REPAIRED FRAME PER SRM.SDR SWAA076476Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA076395Stringer · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER 4L CRACKED AT BS 867. REPAIRED STRINGER PER SRM.
Back to Boeing 737-5H4