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 SWAA118583Channel · corrodedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO COMPARTMENT CHANNEL CORRODED AT BS 859, LBL 3. REPAIRED CHANNEL IAW EA.SDR SWAA118582Channel · corrodedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO COMPARTMENT CHANNEL CORRODED AT BS 859, LBL 12.5. REPAIRED CHANNEL IAW EA.SDR SWAA118560Tru · faultyAIR TURNBACK, DURING CLIMBOUT PRESSURIZATION AUTOFAIL LIGHT ILLUMINATED. FOUND TR1 CB POPPED, WOULD NOT RESET. FLIGHT ATTENDANTS CALLED ABOUT ELECTRICAL SMOKE SMELL IN CABIN. REMOVED AND REPLACED NR 1 TRANSFORMER RECTIFIER PER MM.SDR SWAA118539Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED BETWEEN BS 769.5 TO BS 771.7, STR 18L. REPAIRED SKIN IAW SRM.SDR SWAA118538Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 762, STR 19L. REPAIRED SKIN IAW SRM.SDR SWAA118526Flap · delaminatedDURING SCHEDULED 20Y CHECK, FOUND RT WING I/B FORE FLAP DELAMINATED. REPAIRED FORE FLAP PER MM.SDR SWAA118513Rib · crackedDURING SCHEDULED 20Y CHECK, FOUND LT HORIZONTAL STABILIZER RIB CRACKED AT STA 105.26. REMOVED AND REPLACED RIB IAW SRM AND DWG.SDR SWAA118509Web · crackedDURING SCHEDULED 20Y CHECK, FOUND WEB CRACKED BETWEEN BS 344 TO BS 360, STR 17L. REMOVED AND REPLACED WEB IAW SRM AND DWG.SDR SWAA118501Fitting · corrodedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO COMPARTMENT CLIP CORRODED AT BS 794.3, STR 26R. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA118521Stiffener · crackedDURING SCHEDULED 20Y CHECK, FOUND STIFFENER CRACKED AT BS 727, RBL 8.10. REMOVED AND REPLACED STIFFENER IAW SRM AND DWG.SDR SWAA118630Fitting · corrodedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO COMPARTMENT ANGLE CLIP CORRODED AT BS 847, STR 26R. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA118629Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 380, STR 21L. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA118628Stringer · corrodedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CORRODED BETWEEN BS 312 TO BS 325, STR 28R. REMOVED AND REPLACED STRINGER IAW SRM AND DWG.SDR SWAA118467Skin · crackedDURING SCHEDULED 2HC2 CHECK FOUND, SKIN CRACKED AT BS 259.5+5, STR 9L. REPAIRED SKIN IAW SRM.SDR SWAA118466Skin · crackedDURING SCHEDULED 2HC2 CHECK FOUND, SKIN CRACKED AT BS 807+16, STR 19L. REPAIRED SKIN IAW SRM.SDR SWAA118465Skin · crackedDURING SCHEDULED 2HC2 CHECK FOUND, SKIN CRACKED AT BS 259.5+5, STR 10L. REPAIRED SKIN IAW SRM.SDR SWAA118468Light · inoperativeDURING SCHEDULED CV CHECK FOUND, LT EMERGENCY EXIT SIDEWALL LIGHT INOP. REMOVED AND REPLACED LIGHT PER MM.SDR SWAA20111214385Window · arcedR2 COCKPIT WINDOW ARCED. R&R R2 WINDOW AND R2 WINDOW HEAT CONTROLLER PER MM.SDR SWAA20111213404Angle · crackedDURING SCHDULED 20Y CHECK, FOUND ANGLE CRACKED AT BS 328, STR 21L. R&R ANGLE IAW SRM AND DWG.SDR SWAA118403Angle · crackedDURING SCHDULED 20Y CHECK, FOUND ANGLE CRACKED AT BS 312, STR 21L. R&R ANGLE IAW SRM AND DWG.SDR SWAA20111213402Stringer Clip · crackedDURING SCHDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 380, STR 26L. R&R CLIP IAW SRM AND DWG.SDR SWAA20111213375Beam · crackedDURING SCHEDULED 20Y CHECK, FOUND LONGITUDINAL BEAM CRACKED BETWEEN BS 700 TO BS 720, BBL 0.07. REPAIRED BEAM IAW EO.SDR SWAA118374Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND LONGITUDINAL FLOORBEAM WEB CRACKED BETWEEN BS 700 TO BS 720, RBL 24.5. REPAIRED CHORD IAW EO.SDR SWAA20111213373Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED BETWEEN BS 645 TO BS 685, LBL 24.5. REPAIRED CHORD IAW EO.SDR SWAA118355Plate · damagedDURING SCHEDULED 20Y CHECK, FOUND DAMAGED ADAPTED PLATE AND SHIM AT ESCAPE SLIDE FLOOR BRACKET AFT LT SIDE. R&R PLATE IAW MM.SDR SWAA20111213354Plate · damagedDURING SCHEDULED 20Y CHECK, FOUND DAMAGED ADAPTED PLATE AND SHIM AT ESCAPE SLIDE FLOOR BRACKET AFT RT SIDE. R&R PLATE IAW MM.SDR SWAA20111213353Structure · corrodedDURING SCHEDULED 20Y CHECK, FOUND FWD ELECTRONIC COMPARTMENT LOWER CHORD CORRODED AT BS 203.8, BETWEEN BL 0 TO LBL 4. REPAIRED CHORD IAW EO AND SWA EA.SDR SWAA118336Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND LONGITUDINAL FLOORBEAM WEB CRACKED AT BS 708.5, LBL 24.5. REPAIRED CHORD IAW EO AND SWA EA.SDR SWAA20111212335Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND LONGITUDINAL FLOOR BEAM UPPER CHORD CRACKED BETWEEN BS 640 TO BS 685, RBL 24.5. REPAIRED CHORD IAW EO AND SWA EA.SDR SWAA118334Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR FWD UPPER CORNER CUTOUT, AT BS 303.9+1.5. REPAIRED SKIN IAW EO.SDR SWAA20111212333Skin · corrodedDURING SCHEDULED 20Y CHECK, FOUND SKIN CORRODED AT BS 984, BETWEEN STR 22R TO STR 23R. REPAIRED SKIN IAW EO.SDR SWAA118332Skin · corrodedDURING SCHEDULED 20Y CHECK, FOUND SKIN CORRODED AT BS 986, BETWEEN STR 27L TO STR 27R. REPAIRED SKIN IAW EO.SDR SWAA20111212331Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED BETWEEN BS 380 TO BS 400, STR 22R. R&R CLIP IAW SRM AND DWG.SDR SWAA118330Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR LOWER CORNER CUTOUT AT BS 344. REPAIRED SKIN IAW EO.SDR SWAA20111212329Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR FWD UPPER CORNER CUTOUT AT BS 303.9+1. REPAIRED SKIN IAW EO.SDR SWAA118328Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 986.5, STR 27L. R&R CLIP IAW SRM AND DWG.SDR SWAA118327Stringer · corrodedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CORRODED BETWEEN BS 947.5+10 TO BS 967, STR 27L. REPAIRED STRINGER PER SRM.SDR SWAA20111212326Strap · crackedDURING SCHEDULED 20Y CHECK, FOUND SKIN STRAP CRACKED BETWEEN BS 947 TO BS 967, BETWEEN STR 23L TO STR 27L. R&R STRAP IAW SRM AN DWG.SDR SWAA20111212325Mount · looseDURING SCHEDULED 20Y CHECK, FOUND L2 DOOR EMERGENCY EVAC SLIDE FWD ATTACH MOUNT LOOSE. R&R MOUNT PER SOPM.SDR SWAA120111212324Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 807, STR 26R. R&R CLIP PER SRM AND DWG.SDR SWAA118323Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 787, STR 20R. R&R CLIP PER SRM AND DWG.SDR SWAA20111212322Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 400, STR 27L. R&R CLIP PER SRM AND DWG.SDR SWAA118321Bracket · damagedDURING SCHEDULED 20Y CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE LT FLOOR BRACKET DAMAGED. R&R BRACKET IAW MM.SDR SWAA20111212320Bracket · damagedDURING SCHEDULED 20Y CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE R/H FLOOR BRACKET DAMAGED. R&R BRACKET IAW MM.SDR SWAA118680Skin · crackedDURING SCHEDULED OTS CHECK, FOUND CRACK ON SKIN STA 960, BELOW STR 21. REPAIRS SKIN CRACK PER EA.SDR SWAA118484Door · looseFIRST OFFICERS EMERGENCY ESCAPE ROPE DOOR LOOSE OUT. RE-INSTALLED DOOR PER MM.SDR SWAA20111208463Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND SKIN CRACKED AT BS 520+2.5, STR 28R. REPAIRED SKIN IAW SRM.SDR SWAA118462Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND SKIN CRACKED AT BS 747+16, STR 24L. REPAIRED SKIN IAW SRM.SDR SWAA118411Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND SKIN CRACKED AT BS 344, STR 17R. REPAIRED SKIN IAW SRM AND EA.SDR SWAA118738Slat · delaminatedDURING SCHEDULED 20Y CHECK, FOUND DELAMINATION ON I/B EDGE OF LT SLAT. REMOVED AND REPLACED SLAT PER MM.
Back to Boeing 737-5H4