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 SWAA000767Warning Light · illuminatedABORTED TAKEOFF, NR 1 ENG T/R OVERHEAD LIGHT ILLUMINATED DURING TAKEOFF. RESEATED NR 1 ENG T/R FAULT BOX. OPERATED T/R. NO DEFECT NOTED.SDR SWAA000757Relay · inoperativeDIVERSION, ACFT PRESSURIZATION INOP, LT NAV SYS INOP. DESCENDED AND AVOIDED DROPPING O2 MASKS. DIVERTED TO AUS. REMOVED AND REPLACED RELAY R275. SYSTEMS OP CK GOOD PER MM.SDR SWAA000755Cover · crackedDURING SCHEDULED C1 CHECK, FOUND EEPLS TRACK COVERS CRACKED AT ROWS 2 AND 15. REMOVED AND REPLACED FLOOR TRACK COVERS PER MM.SDR SWAA000702Light · inoperativeDURING SCHEDULED RON, FOUND LH OVERWING EMERGENCY EXIT LIGHT INOP. R&R LIGHT ASSY PER MM.SDR SWAA000696Cover · missingEEPL TRACK LENS COVER MISSING AT OVERWING EXIT. INSTALLED LENS COVER PER MM.SDR SWAA000695Cover · crackedSECTION OF EEPL TRACK COVER CRACKED. R & R TRACK COVER SECTION PER MM.SDR SWAA000669Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAMES CRACKED, BS 440, BETWEEN STRINGERS 8 - 9 RT AND BS 787, BETWEEN STRINGERS 8 -9 LT. REPAIRED FRAMES PER SRM AND ER 00-0361.SDR SWAA000643Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAMES CRACKED, BS 727B, BS 827, BS 520, BETWEEN STRINGERS 8 -9 RT AND BS 907, BS 827. BETWEEN STRINGERS 8 -9 LT. REPAIRED FRAMES PER SRM AND EO 00-00361.SDR SWAA000663Actuator · leakingDURING FLIGHT @ 28000 FEET, LOST A-SYS HYDRAULICS. R&R NR 3 FLIGHT SPOILER ACTUATOR DUE TO LEAK.SDR SWAA000632Frame · crackedDURING SCHEDULED D CHECK, FOUND BS 360 FUSELAGE FRAME CRACKED, STRINGER 8L. REPAIRED FRAME PER SRM.SDR SWAA000631Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND BS 947 FLOOR BEAM UPPER SURFACE CORRODED, RBL 5 AND RBL 48. REPAIRED BEAM PER SRM.SDR SWAA000619Light · inoperativeEEPLS INOPERATIVE AT MID CABIN. SECURED LOOSE WIRING PER MM.SDR SWAA000626Battery Pack · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND LT OVERWING EMERGENCY EXIT LIGHT INOPERATIVE. R&R BATTERY PACK PER MM.SDR SWAA000614Blade · bird strikeAIR TURNBACK, BIRD STRIKE IN NR 1 ENGINE INTAKE. COMPLIED WITH BIRD STRIKE BORESCOPE INSP. R&R NR 1 ENGINE FAN BLADE SET AND NR 1 ENGINE PRECOOLER VALVE PER MM.SDR SWAA000609Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED, BS 188. WL 208. REPAIRED FRAME PER SRM.SDR SWAA000601Stringer · crackedDURING SCHEDULED D CHECK, FOUND STRINGER SPLICE 4 LT CRACKED, BS 907. R&R STRINGER SPLICE SECTION PER SRM.SDR SWAA000593Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND BS 986.5 UPPER SURFACE OF FLOORBEAM CORRODED, LBL 10 TO LBL 44. REPAIRED FLOORBEAM PER ER 00-245P2 AND SRM.SDR SWAA000583Frame · crackedDURING SCHEDULED D CHECK, FOUND 2 EACH FUSELAGE FRAMES CRACKED, BS 787 BETWEEN STRINGERS 8 - 9 RT, AND BS 867, BETWEEN STRINGERS 8 LT AND 9 LT. REPAIRED FRAMES PER SRM.SDR SWAA000584Mount · corrodedDURING SCHEDULED D CHECK, FOUND CORROSION DAMAGE IN VERTICAL STABILIZER RT FWD MOUNT LUG BORE. REPAIRED LUG PER ER 00-0278.SDR SWAA000572Cover · looseEEPLS TRCK LOOSE AT MID CABIN. SECURED TRACK COVER PER MM.SDR SWAA000569Cover · looseEEPLS TRACK COVERS LOOSE AT MID CABIN. SECURED TRACK COVERS PER MM.SDR SWAA000565Bulkhead · crackedDURING SCHEDULED D CHECK, FOUND BS 178 BULKHEAD CRACKED, LBL 5 TO RBL 1. R&R BULKHEAD WEB PER ACO 7154-53.SDR SWAA000557Slide · dischargedDURING SCHEDULED RON, FOUND AFT SERVICE DOOR EVACUATION SLIDE PRESSURE INDICATOR LOW. R&R SLIDE ASSY PER MM.SDR SWAA000553Warning Light · illuminatedABORTED TAKE-OFF - WITH THRUST LEVERS SET AT MID POSITION, NR 1 ENG T/R LIGHT ILLUMINATED AT OVERHEAD PANEL, MASTER CAUTION LIGHT ALSO ILLUMINATED. NO FAULT INDICATIONS ON EAU OPERATED AND INSPECTED NR 1 ENG T/R ASSY. NO ABNORMALITIES NOTED. RESET EAU ANSDR SWAA000549Skin · delaminatedDURING SCHEDULED SERVICE CHECK, F OUND RT ELEVATOR LOWER SKIN DELAMINATED IN 2 AREAS, APPROX STA 94.1, 8.5 INCHES AFT OF FRONT SPAR. REPAIRED SKIN PER SRM.SDR SWAA000534Bracket · looseDURING SCHEDULED C4 CHECK, FOUND BOTH AFT DOOR EVACUATION SLIDE GIRT BAR FLOOR ATTACH BRACKETS LOOSE. TIGHTENED BRACKETS PER MM.SDR SWAA000532Skin · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE SKIN CORRODED AND CRACKED, BS 856, JUST BELOW STRINGER 18R. REPAIRED SKIN PER SRM AND ER NR 00-0289.SDR SWAA000503Light · looseDURING SCHEDULED C3 CHECK, FOUND EEPLS LOOSE AT ROW 12, COVER CRACKED AT ROW 3, AND LENS MISSING AT OVERWING EXIT. SECURED AND REPLACED LENS COVER AND TRACK PER MM.SDR SWAA000502Frame · crackedDURING SCHEDULED D-CHECK, FOUND FWD CARGO DOOR CUTOUT LOWER FRAME CRACKED, BS 452 AT LOWER DOOR STOP. REPAIRED FRAME PER SRM.SDR SWAA000480Indicator · dislodgedDURING SCHEDULED C2 CHECK, FOUND AFT SERVICE DOOR EVACUATION SLIDE INDICATOR OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA000481Battery · inoperativeFWD EMERGENCY FLASHLIGHT INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA000459Frame · crackedDURING SCHEDULED D CHECK, FOUND BS 178 BULKHEAD RT AND LT SIDE CHORDS CRACKED, WL 208. REPAIRED CHORD SECTIONS PER SRM.SDR SWAA000450Flashlight · inoperativeDURING SCHEDULED SPECIAL VISIT FOUND, FWD EMERGENCY FLASHLIGHT INOP. REMOVED AND REPLACED FLASHLIGHT PER MM.SDR SWAA000449Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND BS 986 FLOORBEAM UPPER SURFACE CORRODED, LBL 53-RBL 53. REPAIRED BEAM PER ER NR OO-0212 AND SRM.SDR SWAA000448Frame · crackedDURING SCHEDULED D CHECK, FOUND 5 FUSELAGE FRAMES CRACKED, BS 827, BS 907, STRINGER 8L, BS 727B, BS 747, BS 787, STRINGER 8R. REPAIRED FRAMES PER ER NR 00-210A AND SRM.SDR SWAA000447Frame · crackedDURING SCHEDULED D CHECK, FOUND 5 FUSELAGE FRAMES CRACKED, BS 400, STRINGERS 8L-9L AND 8R-9R, BS 440, BS 482, AND BS 482A, BETWEEN STRINGERS 8R-9R. REPAIRED FRAMES PER ER NR 00-210A AND SRM.SDR SWAA000421Bracket · corrodedDURING SCHEDULED D-CHECK, FOUND FWD ENTRY DOOR EVACUATION SLIDE GIRT BAR FLOOR BRACKETS CORRODED. REMOVED AND REPLACED BRACKETS PER SRM.SDR SWAA000420Splice · crackedDURING SCHEDULED D-CHECK, FOUND 2 STRINGER SPLICES CRACKED, BS 907, STRINGERS 4R AND 4L. REMOVED AND REPLACED STRINGER SPLICES PER SRM.SDR SWAA000419Light · inoperativeDURING SCHEDULED SPECIAL VISIT, FOUND EEPLS INOP. REMOVED AND REPLACED 3 LIGHT MODULES AND SUPPLY BOX CIRCUIT BREAKER PER MM.SDR SWAA000386Engine · damagedAFTER TAKEOFF, OIL AND SKYDROL FUMES IN CABIN, FWD LAV SMOKE DETECTOR ACTIVATED. FOUND THROUGH BORESCOPE INSPECTION OIL STREAKS AT NR 1 ENG 2ND STG HPC. REMOVED AND REPLACED NR 1 ENG AND BOTH A/C HEAT EXCHANGERS PER MM.SDR SWAA000384Bulkhead · crackedDURING SCHEDULED D-CHECK, FOUND BY ULTRASONIC INSP BS 178 BULKHEAD CRACKED, WL 209-213, LBL 5-LBL 6. REPAIRED BULKHEAD PER SRM.SDR SWAA000383Shear Tie · crackedDURING SCHEDULED D-CHECK, FOUND SHEAR TIE CRACKED, BS 360, BETWEEN STRINGERS 13L-14L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA000375Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND 12 STRINGER CLIPS CRACKED, STRINGER 11L, BS 706, BS 597, STRINGER 4L, BS 663, BS 616, BS 578, BS 847, STRINGER 5R, BS 727C, STRINGER 5L, BS 578, STRINGER 11R, BS 707, STRINGER 7L, BS 727C, BS 727A, AND STRINGER 8L, BS 727A. REMSDR SWAA000317Bracket · looseDURING SCHEDULED C4 CHECK, FOUND AFT ENTRY AND SERVICE DOOR EVACUATION SLIDE AFT GIRT BAR FLOOR BRACKETS LOOSE. TIGHTENED BRACKETS PER MM.SDR SWAA000316Bulkhead · crackedDURING SCHEDULED D-CHECK, FOUND BS 178 BULKHEAD 10 CRACKS, LBL 5 TO RBL 7. REPAIRED BULKHEAD PER SRM.SDR SWAA000315Beam · corrodedDURING SCHEDULED D-CHECK, FOUND CREASE BEAM CORRODED, BS 727B-727C, BBL 70. REPAIRED BEAM PER SRM.SDR SWAA000310Cover · crackedDURING SCHEDULED C3 CHECK, FOUND EEPLS TRACK COVERS CRACKED, LOOSE AT ROWS 21 AND ROW 1. REPLACED TRACK COVERS PER MM.SDR SWAA000300Blade · bird strikeNR 1 ENG ENCOUNTERED A BIRD STRIKE DURING TAKEOFF. C/W BIRD STRIKE INSPECTION AND REMOVED AND REPLACED NR 1 ENG FAN BLADES PER MM.SDR SWAA000287Target · out of adjustAIR TURNBACK, DURING CLIMB, FWD CARGO DOOR LIGHT ILLUMINATED. ADJUSTED FWD CARGO DOOR TARGET PER MM. OPS CK GOOD.SDR SWAA000282Charger · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND LT OVERWING EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY CHARGER PER MM.
Back to Boeing 737-5H4