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 SWAA061039Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED BETWEEN BS 761 TO BS 764, STR 22L TO STR 23L. REPAIRED SKIN PER SWA EA & SRM.SDR SWAA061038Cover · missingEEPLS STRIP COVER MISSING BETWEEN ROW 12 TO ROW 17. REMOVED AND REPLACED EEPLS PER MM.SDR SWAA060989Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 930, STR 21R. REPAIRED SKIN PER SWA EA & SRM.SDR SWAA060920Crease Beam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND LEFT CREASE BEAM WEB CORRODED BETWEEN BS 440 TO BS 460, WL 208. REPAIRED WEB PER SWA EA & SRM.SDR SWAA060919Door Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT AFT CARGO DOOR CUTOUT, AFT FRAME LOWER STOP FITTING. REPAIRED FRAME PER SWA EA.SDR SWAA060918Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT AFT CARGO DOOR CUTOUT, FWD FRAME LOWER STOP FITTING. REPAIRED FRAME PER SWA EA.SDR SWAA060884Splice · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE STRINGER SPLICE CRACKED AT BS 907, STR 4R. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA060883Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE FRAME CRACKED AT FWD CARGO DOOR CUTOUT, AFT FRAME NR 5 STOP FITTING. REPAIRED FRAME PER SRM.SDR SWAA060882Light · looseEEPLS STRIP LOOSE AT FWD END. REMOVED AND REPLACED STRIP PER MM.SDR SWAA060859Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 927, STR 25R. REPAIRED SKIN PER SRM.SDR SWAA060842Floorbeam · crackedDURING SCHEDULED 1/2D CHECK, FOUND CABIN FLOORBEAM CRACKED AT BS 294, LBL 53. REPAIRED FLOORBEAM PER SRM.SDR SWAA060817Engine · failedAIR TURNBACK / IN FLT SHUTDOWN / DECLARED EMERGENCY. NR 1 ENG FAILURE AT 10,500 FT DURING CLIMB, EGT IND 830 DEGS AND RISING. REMOVED AND REPLACED NR 1 ENG PER MT.SDR SWAA060853Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE FRAME CRACKED AT BS 303, STR 16L. REPAIRED FRAME PER ER.SDR SWAA060816Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 14L. REPAIRED FRAME PER SWA EA.SDR SWAA060815Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN CRACKED AT L2 DOOR FWD LOWER CUTOUT, BS 950, STR 18L. REPAIRED SKIN PER SWA EA & SRM.SDR SWAA060780Lens · looseL1 DOOR LOWER EMERGENCY EXIT LIGHT LENS LOOSE. SECURED LENS PER MM.SDR SWAA060791Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 294, STR 16R. REPAIRED FRAME PER SRM.SDR SWAA060790Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 482B, STR 10L. REPAIRED SKIN PER SRM.SDR SWAA060764Web · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE BEADED WEB CRACKED AT BS 672.5, RBL 41.75. REPAIRED WEB PER SRM.SDR SWAA060763Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT FWD CARGO DOOR CUTOUT, AFT FRAME LOWER STOP FITTING. REPAIRED FRAME PER SWA EA.SDR SWAA060762Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 482B, STR 10L. REPAIRED SKIN PER SRM.SDR SWAA060753Wedge · delaminatedDURING SCHEDULED 1/2D CHECK, FOUND RIGHT WING NR 5 L/E SLAT UPPER T/E WEDGE DELAMINATED AT INBOARD END. REPAIRED SLAT PER SRM.SDR SWAA060741Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE FRAME CRACKED AT FWD CARGO DOOR CUTOUT, FWD FRAME NR 5 STOP FITTING. REPAIRED FRAME PER SRM.SDR SWAA060722Slide · out of positionL1 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MM.SDR SWAA060743Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 787, STR 20R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA060742Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 482A, STR 20R. REPAIRED FRAME PER SWA EA.SDR SWAA060721Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 787, STR 24R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA060720Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 787, STR 22R. REMOVED AND REPLACED PER SRM.SDR SWAA060719Slide · out of adjustL2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA060706Skin · delaminatedDURING SCHEDULED 1/2D CHECK, FOUND RT WING NR 5 L/E SLAT UPPER WEDGE DELAMINATED AT OUTBOARD END. REPAIRED SLAT PER SRM.SDR SWAA060705Stringer Clip · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 350, STR 16L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA060671Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE FRAME CRACKED AT L1 DOOR CUTOUT, BS 348, BETWEEN STR 13L TO STR 17L. REPAIRED FRAME PER SRM.SDR SWAA060661Lens · missingDURING SCHEDULED C1 CHECK, FOUND FWD CABIN EMERGENCY EXIT LIGHT LENS MISSING. INSTALLED LENS PER MM.SDR SWAA060634Skin · crackedDURING SCHEDULED RON CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 312, STR 6R. REPAIRED SKIN PER SWA EA & SRM.SDR SWAA060567Lens · looseDURING SCHEDULED SERVICE CHECK, FOUND LT OVERWING EMERGENCY EXIT LIGHT LENS LOOSE. SECURED LENS PER MM.SDR SWAA060566Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 797, STR 18L. REPAIRED SKIN PER SWA EA AND SRM.SDR SWAA060558Light · looseDURING SCHEDULED SERVICE CHECK, FOUND CABIN EMERGENCY EXIT LIGHT LOOSE AT ROW 6 ABC. SECURED LIGHT PER MM.SDR SWAA060550Skin · crackedDURING SCHEDULED RON CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 847, BETWEEN STR 23L TO STR 24L. REPAIRED SKIN PER SWA EA AND SRM.SDR SWAA060549Skin · crackedDURING SCHEDULED A2 CHECK, FOUND FUSELAGE SKIN CRACKED AT L2 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER SWA EA AND SRM.SDR SWAA060548Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 943, STR 24R. REPAIRED SKIN PER SRM.SDR SWAA060547Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 872, STR 24R. REPAIRED SKIN PER SRM.SDR SWAA060532Light · looseEEPLS TRACK LOOSE AT ROW 6. REMOVED AND REPLACED EEPLS PER MM.SDR SWAA060531Cable · misroutedDURING SCHEDULED C1 CHECK, FOUND L2 DOOR EMERGENCY EVAC SLIDE LATCH CABLE ASSY MISROUTED. REROUTED CABLE ASSY PER MM.SDR SWAA060467Skin · delaminatedDURING SCHEDULED C4 CHECK, FOUND LT WING NR 3 SPOILER DELAMINATED. REMOVED AND REPLACED SPOILER PER MM.SDR SWAA060452Slide · dislodgedDURING SCHEDULED RON CHECK, L1 DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA060384Skin · delaminatedDURING SCHEDULED SERVICE CHECK, FOUND RT WING OUTBD T/E AFT FLAP DELAMINATED. REMOVED AND REPLACED AFT FLAP PER MM.SDR SWAA060332Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED BETWEEN BS 881 TO BS 893, STR 24R TO STR 25R. REPAIRED SKIN PER SWA EA.SDR SWAA060331Bear Strap · corrodedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN BEAR STRAP CORRODED AT BS 867, STR 25R. REPAIRED SKIN PER SWA EA.SDR SWAA060330Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 971, STR 21L. REPAIRED SKIN PER SWA EA.SDR SWAA060307Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 750, STR 18L. REPAIRED SKIN PER SRM.
Back to Boeing 737-5H4