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 SWAA080832Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND AFT CARGO DOOR CUTOUT AFT FRAME CORRODED AT BS 794, STR 27R. REMOVED AND REPLACED FRAME PER ACO.SDR SWAA080831Sign · inoperativeDURING SCHEDULED 16Y CHECK, FOUND AFT CABIN EMERGENCY EXIT SIGN INOP. REMOVED AND REPLACED EXIT SIGN ASSY PER MM.SDR SWAA080811Skin · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE SKIN BEAR STRAP CRACKED AT BS 450, STR 24R. REPAIRED SKIN PER ER.SDR SWAA080809Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 747, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA080810Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED BETWEEN BS 867 AND BS 887, STR 24R. REPAIRED SKIN PER SRM.SDR SWAA080785Bear Strap · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE SKIN BEAR STRAP CRACKED AT BS 847, STR 26R. REPAIRED SKIN PER ER.SDR SWAA080786Actuator · crackedDURING SCHEDULED 16Y CHECK, FOUND RT WING NR 5 SPOILER OUTBOARD ACTUATOR FWD MOUNT CRACKED. REMOVED AND REPLACED SPOILER ACTUATOR PER MM.SDR SWAA080784Door Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FWD CARGO DOOR CUTOUT AFT FRAME CRACKED AT STR 25R. REPAIRED FRAME PER SRM AND BOEING DRAWING.SDR SWAA080745Floorbeam · corrodedDURING SCHEDULED 16Y CHECK, FOUND FLOORBEAM CORRODED AT BS 986.5, LBL 46 TO RBL 46. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA080760Skin · damagedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CREASED AT BS 370, STR 4L. REPAIRED SKIN PER EA.SDR SWAA080744Bear Strap · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN BEAR STRAP CRACKED AT AFT CARGO DOOR LOWER FWD CUTOUT BS 798. REPAIRED SKIN PER SRM.SDR SWAA080722Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 294, STR 6R. REPAIRED FRAME PER SRM.SDR SWAA080724Shear Tie · corrodedDURING SCHEDULED 16Y CHECK, FOUND SHEAR TIE CORRODED AT BS 827, STR 27L. REPAIRED SHEAR TIE PER SRM.SDR SWAA080723Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 277, STR 16L. REPAIRED FRAME PER SRM.SDR SWAA080721Pressure Panel · crackedDURING SCHEDULED HC1 CHECK, FOUND BEADED PRESSURE WEB CRACKED AT BS 664, RBL 40. REPAIRED WEB PER SRM.SDR SWAA080703Shear Tie · corrodedDURING SCHEDULED 16Y CHECK, FOUND SHEAR TIE CORRODED AT BS 500, STR 27L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA080702Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 277, STR 16L. REPAIRED FRAME PER SRM.SDR SWAA080701Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 9L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080700Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 460, STR 10L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080665Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 9L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080664Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 460, STR 10L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080650Fitting · corrodedDURING SCHEDULED 16Y CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE AFT GIRT BAR FITTING CORRODED. REMOVED AND REPLACED FITTING PER SRM.SDR SWAA080649Fitting · corrodedDURING SCHEDULED 16Y CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR FITTING CORRODED. REMOVED AND REPLACED FITTING PER SRM.SDR SWAA080648Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA080643Window · arcedFLIGHT DECK L1 WINDOW ARCED. REMOVED AND REPLACED WINDOW PER MM.SDR SWAA080619Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 25L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080618Stringer · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER 16L CRACKED AT BS 380. REPAIRED STRINGER PER SRM.SDR SWAA080617Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 616, RBL 65. REPAIRED FRAME PER SRM.SDR SWAA080620Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 927, STR 26R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080565Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 16L. REPAIRED FRAME PER SRM.SDR SWAA080576Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA080579Skin · corrodedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE SKIN CORRODED AT BS 790, STR 25R. REPAIRED SKIN PER SRM.SDR SWAA080580Skin · corrodedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE SKIN CORRODED AT BEAR STRAP BS 790, RBL 19. REPAIRED SKIN PER EA.SDR SWAA080566Slide · out of adjustL1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA080564Stringer Splice · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER SPLICE CRACKED AT BS 908, STR 4L. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA080536Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 520, STR 4L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080535Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 11L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080534Charger · faultyDURING SCHEDULED 16Y CHECK, FOUND AFT LT LOWER FUSELAGE EMERGENCY EXIT EXTERIOR LIGHT INOP. REMOVED AND REPLACED BATTERY CHARGER PER MM.SDR SWAA080533Skin · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BEAR STRAP BS 847, RBL 15. REPAIRED SKIN PER ER.SDR SWAA080517Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 482B, STR 6L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080498Crease Beam · crackedDURING SCHEDULED 16Y CHECK, FOUND CREASE BEAM CHORD CRACKED AT BS 560, LBL 65. REPAIRED CHORD PER SRM.SDR SWAA080499Floorbeam · corrodedDURING SCHEDULED 16Y CHECK, FOUND FLOORBEAM CORRODED AT BS 328, RBL 11 TO RBL 14. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA080500Floorbeam · corrodedDURING SCHEDULED 16Y CHECK, FOUND FLOORBEAM CORRODED AT BS 344, RBL 1. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA080501Door Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND AFT CARGO DOOR CUTOUT FWD FRAME CORRODED AT NR 5 DOOR STOP. REPAIRED FRAME PER SRM.SDR SWAA080502Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 767, STR 2L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080486Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 663, STR 4L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080485Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 482B, STR 6L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080483Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 685, STR 2R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080484Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 8R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080457Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727B, STR 8R. REPAIRED FRAME PER SWA EA.
Back to Boeing 737-5H4