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 SWAA020500Bear Strap · crackedDURING SCHEDULED D-CHECK, FOUND FWD ENTRY DOOR BEAR STRAP CRACKED AT UPPER AND LOWER HINGE CUTOUTS. REPAIRED BEAR STRAP.SDR SWAA020444Bracket · looseDURING SCHEDULED C1 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE AFT GIRT BAR FLOOR ATTACH BRACKET LOOSE. SECURED BRACKET PER MM.SDR SWAA020439Web · crackedDURING SCHEDULED D CHECK, FOUND WEBS CRACKED (2 EA) AT BS 195, WL 208, LBL 31 AND RBL 31. REMOVED AND REPLACED WEBS PER SRM.SDR SWAA020395Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 277, STR 16L. REPAIRED FRAME PER SRM.SDR SWAA020396Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER CLIPS CRACKED (2 EA) AT BS 294.5, STR 11L AND BS 907, STR 4L. REMOVED AND REPLACED STR CLIPS PER SRM.SDR SWAA020364Battery · dischargedDURING SCHEDULED D-CHECK, FOUND EMERGENCY EXIT LIGHTS BATTERY PACK M 1137 INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA020329Flap · delaminatedDURING SCHEDULED D CHECK, FOUND LT OTBD AFT T/E FLAP DELAMINATED AT AFT CORNER. REPAIRED T/E FLAP PER SRM.SDR SWAA020320Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAMES CRACKED (2 EA) AT STR 8R, BS'S 380 AND 440. REPAIRED FRAMES PER BFG ER.SDR SWAA020319Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAMES CRACKED (5 EA) AT STR 8L, BS'S 400, 440, 747, 867 AND 907. REPAIRED FRAMES PER BFG ER.SDR SWAA020318Frame · corrodedDURING SCHEDULED D CHECK, FOUND AFT CARGO DOOR FRAME CUTOUT CORRODED AT BS 794, RBL 28 TO 47 AND WL 159 TO 169. REPAIRED FRAME PER SRM AND BFG ER.SDR SWAA020332Slat · debondedDURING SCHEDULED D-CHECK, FOUND NR 3 L/E SLAT DISBONDED ON UPPER SURFACE AT THE T/E WEDGE ON INBOARD END AND OUTBOARD END. REPAIRED NR 3 L/E SLAT PER SRM.SDR SWAA020331Slat · debondedDURING SCHEDULED D-CHECK, FOUND NR 2 L/E SLAT DISBONDED ON UPPER SURFACE OUTBOARD END OF T/E WEDGE. REMOVED AND REPLACED NR 2 L/E SLAT PER MM.SDR SWAA020325Tee Chord · crackedDURING SCHEDULED D CHECK, FOUND VERTICAL FIN LT TEE CHORD CRACKED AT RUDDER STA 13.33. REPAIRED TEE CHORD PER SRM.SDR SWAA020293Shear Tie · crackedDURING SCHEDULED D CHECK, FOUND SHEAR TIE CRACKED AT BS 1040, BETWEEN STR'S 2R AND 3R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA020283Stringer · crackedDURING SCHEDULED D CHECK, FOUND STRINGER CRACKED AT BS 1011, STR 4 L. REPAIRED STR PER SRM.SDR SWAA020273Web · corrodedDURING SCHEDULED D CHECK, FOUND WEB CORRO DED AT BS 1016, WL 208 & LBL 15 TO LBL 25. REPAIRED WEB PER SRM.SDR SWAA020274Skin · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE SKIN CRACKED AT AFT SVC DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA020240Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAMES CRACKED (4 EA) AT STR 8L, BS'S 440, 827, 867 AND 907. REPAIRED FRAMES PER BFG ER.SDR SWAA020239Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAMES CRACKED (4 EA) AT STR 8R, BS'S 380, 440, 827 AND 867. REPAIRED FRAMES PER BFG ER.SDR SWAA020238Shear Tie · crackedDURING SCHEDULED D CHECK, FOUND SHEAR TIE CRACKED AT BS 360, BETWEEN STR 13L AND 14L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA020229Web · crackedDURING SCHEDULED D CHECK, FOUND BULKHEAD WEB CRACKED AT BS 178, LBL 10 TO LBL 12. REMOVED AND REPLACED WEB PER SWA ACO.SDR SWAA020247Splice · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER SPLICE CRACKED AT BS 907, STR 4R. REMOVED AND REPLACED STR SPLICE PER SRM.SDR SWAA020246Stiffener · crackedDURING SCHEDULED D CHECK, FOUND STIFFENER CRACKED AT BS 291.5, WL 259 RT. REMOVED AND REPLACED STIFFENER PER SRM.SDR SWAA020237Tie Clip · crackedDURING SCHEDULED D CHECK, FOUND STRINGER TIE CLIP CRACKED AT BS 706, STR 11L. REMOVED AND REPLACED TIE CLIP PER SRM AND SWA TI.SDR SWAA020220Stringer · crackedDURING SCHEDULED D CHECK, FOUND STRINGER 5R CRACKED AT BS 1006. REPAIRED STRINGER PER SRM.SDR SWAA020213Slide · out of positionDURING SCHEDULED C3 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA020241Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 188, WL 207 ON BOTH RT AND LT SIDES. REPAIRED FRAME PER SRM.SDR SWAA020181Wire · damagedDURING SCHEDULED D-CHECK, FOUND EMERGENCY EXIT BULLNOSE LIGHT INOP AT ROW 15 DEF. REPAIRED WIRING PER MM.SDR SWAA020180Mechanism · out of adjustDURING SCHEDULED D-CHECK, FOUND R2 COCKPIT WINDOW EMERGENCY RELEASE MECHANISM INOP. ADJUSTED R2 COCKPIT WINDOW RELEASE HANDLE MECHANISM PER MM.SDR SWAA020179Stringer Clip · crackedDURING SCHEDULED D CHECK, FOUND STRINGER CLIP CRACKED, BS 277, STRINGER 15R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA020178Frame · crackedDURING SCHEDULED D CHECK, FOUND BS 663 FRAME CRACKED, STRINGER 2L. REPAIRED FRAME PER SRM.SDR SWAA020163Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER CLIPS CRACKED (4 EA) AT BS 706, STR'S 2R, 3R, 2L AND 3L. REMOVED AND REPLACED STR CLIPS PER SRM.SDR SWAA020177Shear Tie · crackedDURING SCHEDULED D CHECK, FOUND BS 360 SHEAR TIES CRACKED, STRINGERS 14L-15L AND 14R-15R. REMOVED AND REPLACED SHEAR TIE SECTIONS PER SRM.SDR SWAA020167Shear Tie · crackedDURING SCHEDULED D-CHECK, FOUND SHEAR TIE CRACKED AT BS 360, STR 13L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA020166Web · crackedDURING SCHEDULED D CHECK, FOUND WEB CRACKED AT BS294.5, STR 7L. REMOVED AND REPLACED WEB PER SRM.SDR SWAA020176Web · crackedDURING SCHEDULED D CHECK, FOUND BS 294.5 ATTACHED WEB CRACKED, STRINGER 12L. REMOVED AND REPLACED WEB PER SRM.SDR SWAA020175Stringer Clip · crackedDURING SCHEDULED D CHECK, FOUND STRINGER CLIP CRACKED, BS 951, STRINGER 25R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA020157Frame · crackedDURING SCHEDULED D-CHECK, FOUND VERTICAL CHORD CRACKED AT BS 178 WL 184 AND LBL 5.7. REMOVED AND REPLACED VERTICAL CHORD PER SWA ACO.SDR SWAA020158Shear Tie · crackedDURING SCHEDULED D-CHECK, FOUND SHEAR TIE CRACKED AT BS 360, STR 13R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA020149Stringer · crackedDURING SCHEDULED D CHECK, FOUND STRINGER CRACKED AT BS 1006, STR 7L. REPAIRED STR PER SRM AND SWA T1.SDR SWAA020148Splice · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER SPLICE CRACKED AT BS 907, STR 4L. REMOVED AND REPLACED STR SPLICE PER SRM.SDR SWAA020144Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAMES CRACKED AT STR 8L, BS'S 400, 727, 867, 887 AND 907. REPAIRED FRAMES PER BFG ER.SDR SWAA020143Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAMES CRACKED AT STR 8R, BS'S 380, 400 AND 867. REPAIRED FRAMES PER BFG ER..SDR SWAA020113Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER CLIP CRACKED AT BS 887, STR 4R. REMOVED AND REPLACED STR CLIP PER SRM.SDR SWAA020109Cover · crackedDURING SCHEDULED C2 CHECK, FOUND EEPLS COVER CRACKED AT ROW NR 21. REMOVED AND REPLACED COVER PER MM.SDR SWAA020100Shear Tie · crackedDURING SCHEDULED D CHECK, FOUND SHEAR TIE CRACKED AT BS 967, BETWEEN STR'S 6L AND 7L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA020099Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER CLIP CRACKED AT BS 639, STR 3R. REMOVED AND REPLACED STR CLIP PER SRM.SDR SWAA020098Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER CLIPS CRACKED (3) AT STR 8L, BS 482A, 482B AND 520. REMOVED AND REPLACED STR CLIPS PER SRM.SDR SWAA020097Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER CLIPS CRACKED (2) AT STR 8R, BS 520 AND 639. REMOVED AND REPLACED STR CLIPS PER SRM.SDR SWAA020088Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 188, WL 207 LT. REMOVED AND REPLACED FRAME PER SRM.
Back to Boeing 737-5H4