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 SWAA060286Skin · delaminatedDURING SCHEDULED A1 CHECK, FOUND RT WING INBOARD T/E AFT FLAP DELAMINATED. REMOVED AND REPLACED AFT FLAP PER MM.SDR SWAA060270Floorbeam · crackedDURING SCHEDULED 1/2D CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 663, LBL 0.07. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA060269Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 300, STR 10L. REPAIRED FRAME PER SRM.SDR SWAA060268Door Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND AFT CARGO DOOR FRAME CRACKED AT AFT LOWER CORNER DOOR STOP CUTOUT. REMOVED AND REPLACED CARGO DOOR PER MM.SDR SWAA060229Shear Tie · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SHEAR TIE CRACKED AT BS 360, STR 15R. REPAIRED SHEAR TIE PER SRM.SDR SWAA060228Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 294.5, STR 11L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA060213Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 482, STR 20L. REPAIRED FRAME PER SWA EA.SDR SWAA060212Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 482B, STR 20R. REPAIRED FRAME PER SWA EA.SDR SWAA060200Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 613, LBL 65. REPAIRED FRAME PER SWA TRM.SDR SWAA060199Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 613, RBL 65. REPAIRED FRAME PER SWA SRM.SDR SWAA060202Splice · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE STRINGER SPLICE CRACKED AT BS 360, STR 14L. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA060201Channel · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE STRINGER CHANNEL CRACKED AT BS 360, STR 16L. REMOVED AND REPLACED STRINGER CHANNEL PER SRM.SDR SWAA060189Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT FWD CARGO DOOR CUTOUT, BS 452, STR 24R. REPAIRED FRAME PER SWA EA.SDR SWAA060188Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN CRACKED AT L2 DOOR CUTOUT, FWD LOWER CORNER. REPAIRED SKIN PER SRM.SDR SWAA060187Web · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE BEADED WEB CRACKED AT BS 665, LT SIDE. REPAIRED WEB PER SRM.SDR SWAA060186Cover · looseDURING SCHEDULED C1 CHECK, FOUND LT EXTERIOR UPPER EMERGENCY EXIT LIGHT COVER LOOSE. SECURED COVER PER MM.SDR SWAA060165Splice · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE STRINGER CHANNEL CRACKED AT BS 360, STR 14L. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA060164Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 482A, STR 20R. REPAIRED FRAME PER SWA EA.SDR SWAA060163Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 482A, STR 20L. REPAIRED FRAME PER SWA EA.SDR SWAA060166Skin · crackedDURING WALKAROUND INSP, FOUND FUSELAGE SKIN CRACKED AT BS 529, STR 10R. REPAIRED SKIN PER SWA EA.SDR SWAA060130Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND R1 DOOR FWD LOWER FRAME CRACKED AT DOOR STOP. REMOVED AND REPLACED DOOR PER MM.SDR SWAA060080Slide · out of adjustFOUND R1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE IAW MM.SDR SWAA060037Skin · crackedDURING WALK AROUND INSP, FOUND FUSELAGE SKIN CRACKED AT BS 847, STR 25L. REPAIRED SKIN PER SRM.SDR SWAA060013Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE FRAME CRACKED AT FWD CARGO DOOR CUTOUT, AFT FRAME NR 5 STOP FITTING. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA060012Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE FRAME CRACKED AT AFT CARGO DOOR CUTOUT, FWD FRAME NR 5 STOP FITTING. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA060011Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE FRAME CRACKED AT FWD CARGO DOOR CUTOUT, FWD FRAME NR 5 STOP FITTING. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA060014Web · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE BEADED WEB CRACKED AT BS 664, LBL 42. REPAIRED WEB PER SWA EA.SDR SWAA054168Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 737D, STR 23L. REPAIRED SKIN PER SWA EA & SRM.SDR SWAA054148Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT FWD CARGO DOOR CUTOUT, FWD FRAME LOWER STOP FITTING. REPAIRED FRAME PER SWA EA.SDR SWAA054151Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE FRAME CRACKED AT FWD CARGO DOOR CUTOUT, FWD FRAME NR 5 STOP FITTING. REPAIRED FRAME PER BFG ER.SDR SWAA054150Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE FRAME CRACKED AT FWD CARGO DOOR CUTOUT, AFT FRAME NR 5 STOP FITTING. REPAIRED FRAME PER BFG ER.SDR SWAA054149Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE FRAME CRACKED AT AFT CARGO DOOR CUTOUT, AFT FRAME NR 4 STOP FITTING. REPAIRED FRAME PER BFG ER.SDR SWAA054092Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 312, STR 18R. REPAIRED SKIN PER SWA EA.SDR SWAA054094Door Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND AFT CARGO DOOR AFT FRAME CRACKED AT NR 5 STOP FITTING. REMOVED AND REPLACED AFT CARGO DOOR PER MM.SDR SWAA054093Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT L1 DOOR CUTOUT, LOWER FWD CORNER. REPAIRED FRAME PER SRM.SDR SWAA054064Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FLOORBEAM CORRODED AT BS 1016, RBL 30.5. REPAIRED FLOORBEAM PER SRM.SDR SWAA054063Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN CRACKED BETWEEN BS 385 TO BS 387, STR 4R. REPAIRED SKIN PER SWA EA.SDR SWAA054043Shear Tie · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE SHEAR TIE CRACKED AT BS 360, STR 14R. REPAIRED SHEAR TIE PER SRM.SDR SWAA054091Cable · misroutedDURING SCHEDULED C1 CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE LATCH CABLE ASSY MISROUTED. REROUTED CABLE ASSY PER MM.SDR SWAA054044Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN CRACKED BETWEEN BS 498A TO BS 500A, STR 12L. REPAIRED SKIN PER SWA EA.SDR SWAA054027Rib · crackedDURING SCHEDULED 1/2D CHECK, FOUND RT WING RIB LOWER CHORD CRACKED AT WBL 135.5, BETWEEN STR 2 AND STR 3. REPAIRED RIB PER SRM AND SWA ACO.SDR SWAA054026Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 482, STR 20R. REPAIRED FRAME PER SWA EA.SDR SWAA054025Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 482A, STR 20L. REPAIRED FRAME PER SWA EA.SDR SWAA054024Skin · chafedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN CHAFED AT DORSAL FIN BLADE SEAL, BETWEEN BS 889 TO BS 919, LBL 7. REPAIRED SKIN PER SWA EA.SDR SWAA054023Skin · chafedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN CHAFED AT DORSAL FIN BLADE SEAL, BETWEEN BS 925 TO BS 927, LBL 9 & RBL 9. REPAIRED SKIN PER SWA EA.SDR SWAA053997Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 344, STR 10R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA053996Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 520, STR 16L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA053995Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 615, STR 17R. REPAIRED FRAME PER SRM.SDR SWAA053994Shear Tie · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SHEAR TIE CRACKED AT BS 360, BETWEEN STR 14R TO STR 15R. REPAIRED SHEAR TIE PER SRM.SDR SWAA053993Pressure Panel · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE BEADED WEB CRACKED AT BS 664, LBL 32. REPAIRED BEADED WEB PER SWA EA.
Back to Boeing 737-5H4