Boeing 737-3H4
Service difficulty reports · 52,340
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 = '7373H4' 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 = '7373H4' 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 SWAA2015042138737Bracket · damagedL2 DOOR EMER EVAC SLIDE FLOOR BRACKET DAMAGED. R & R BASE IAW AMM.SDR SWAA2015051339636Retainer · crackedL1 DOOR CUT OUT RETAINER TRIM CRACKED. REPLACED RETAINER IAW SRM.SDR SWAA2015042738983Skin · crackedSKIN CRACKED AT BS 415, STRINGER 2R. REPAIRED SKIN IAW ER & EA.SDR SWAA2015042238748Actuator · malfunctionedAIR TURN BACK, LE FLAPS TRANSIT LIGHT ILLUMINATED UPON FLAP RETRACTION. R & R 2 LE FLAP ACTUATOR IAW AMM 27-81-31.SDR SWAA2015062241025Spar · crackedRIGHT WING REAR SPAR UPPER CHORD CRACKED ABOVE INBD UPPER FASTENER OF MLG AFT SUPPORT FITTING. REPAIRED CHORD IAW EA.SDR SWAA2015061740813Spar · crackedLEFT WING REAR SPAR UPPER CORD CRACKED. REPAIRED CHORD IAW SRM & EA.SDR SWAA2015061140611Frame · crackedFOUND THE FUSELAGE FRAME ANGLE CRACKED AT BS 727, STRINGER 18A, RIGHT SIDE. REPAIRED THE FRAME ANGLE IAW EA.SDR SWAA2015061140609Frame · crackedFOUND THE FUSELAGE FRAME ANGLE CRACKED AT BS 727, STRINGER 18A, LEFT SIDE. REPAIRED THE FRAME ANGLE IAW EA.SDR SWAA2015042138747Selector Valve · faultyAIR TURN BACK, WHEN GEAR HANDLE POSITIONED TO OFF, SUSPECT MAIN GEAR FREE FALL. HIGH FUEL BURN FOR CONFIGURATION. R & R LG SELECTOR VLV IAW MM.SDR SWAA2015070641303Frame · crackedFRAME OTBD CHORD CRACKED AT BS 727, STRINGER 18A LT. REPAIRED CHORD IAW EA & DWG.SDR SWAA2015070641302Structure · crackedUPPER & LOWER CHORD CRACKED AT BS 727, STRINGER 18A RT. R & R CHORD IAW EA & DWG.SDR SWAA2015042038674Flap · delaminatedRIGHT WING OTBD AFT FLAP DELAMINATED ON INBD END. R & R AFT FLAP IAW AMM.SDR SWAA2015042038673Light · inoperativeRIGHT EMER EXIT SIDEWALL LIGHT INOPERATIVE. RELAMPED LIGHT ASSEMBLY IAW MM.SDR SWAA2015042038672Flap · delaminatedLEFT WING OTBD FORE FLAP TE DELAMINATED. R & R FORE FLAP IAW AMM.SDR SWAA2015042038671Slat · delaminatedLEFT WING NR 1 SLAT UPPER OTBD TE DELAMINATED. R & R NR 1 SLAT IAW SRM.SDR SWAA2015042038652Fuel Cap · leakingDIVERSION, FUEL LEAK OFF RT WING. R & R FUEL CAP IAW SIP.SDR SWAA2015050839454Web · crackedLEFT WING WEB CRACKED AT BS RSS 173 SECOND FASTENER HOLE DOWN FROM TOP. REPAIRED WEB IAW SRM.SDR SWAA2015041738620Glowstrip · crackedRIGHT PHOTO LUMINESCENT STRIPS CRACKED AT ROW 1. R & R STRIP IAW MM.SDR SWAA2015041738614Glowstrip · crackedLEFT PHOTO LUMINESCENT STRIPS CRACKED AT ROW 1. R & R STRIP IAW MM.SDR SWAA2015041638612Pump · failedAIR TURN BACK, FLIGHT CONTROL LIGHT & NR 1 ENG HYD LOW PRESS LIGHT SYS A HYD QTY DECREASED. FOUND A ENG PUMP FAILED. R & R PUMP IAW AMM.SDR SWAA2015052039890Flap Track · corrodedLEFT WING CORRODED ON HOLES UPPER SURFACE THAT ATTACH FLAP TRACK TRANSMISSION NR 3 LT WING. R & R FLAP TRACK IAW AMM.SDR SWAA2015051939821Flap Track · corrodedLEFT WING NR 3 FLAP TRACK CORRODED ON UPPER SURFACE. R & R NR 3 FLAP TRACK ASSEMBLY IAW AMM.SDR SWAA2015051539721Skin · crackedLEFT WING SKIN CRACKED AT TE AFT FASTENER HOLE RSS 249. REPAIRED SKIN IAW EA.SDR SWAA2015051539720Skin · crackedLEFT WING SKIN CRACKED AT TE AFT FASTENER HOLE RSS 253. REPAIRED SKIN IAW EA.SDR SWAA2015051539719Skin · crackedLEFT WING SKIN CRACKED AT TE AFT FASTENER HOLE RSS 254. REPAIRED SKIN IAW EA.SDR SWAA2015051539717Skin · crackedLEFT WING SKIN CRACKED AT TE AFT FASTENER HOLE RSS 268.8. REPAIRED SKIN IAW EA.SDR SWAA2015051139553Angle · crackedFORWARD CARGO COMPARTMENT ANGLE CRACKED AT BS 380, BETWEEN STRINGER 26L - 18L. R & R ANGLE IAW SRM & DWG.SDR SWAA2015050839462Tie Clip · crackedTIE CLIP CRACKED AT BS 867, STRINGER 27L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2015050139211Attach Fitting · crackedRIGHT WING NR 5 SPOILER OTBD ACTUATOR ATTACH FITTING CRACKED. R & R FITTING IAW CMM & DWG.SDR SWAA2015042138746Power Supply · inoperativeM167S EMER LIGHT L1187 INOPERATIVE. R & R POWER SUPPLY IAW AMM.SDR SWAA2015041638591Bracket · looseR1 DOOR EMER EVAC SLIDE GIRT BAR AFT BRACKET LOOSE. SECURED BRACKET IAW SRM.SDR SWAA2015041638590Bracket · looseL1 DOOR EMER EVAC SLIDE LINER GIRT BAR BRACKET LOOSE. SECURED BRACKET IAW SRM.SDR SWAA2015041538523Lens · looseFORWARD GALLEY EXIT SIGN LIGHT LENS LOOSE. SECURED LENS IAW SIP.SDR SWAA2015061040535Spar · crackedRIGHT WING AFT SPAR WEB CRACKED AT RSS 219. REPAIRED SPAR WEB IAW EA.SDR SWAA2015052940220Spar · crackedLEFT WING REAR SPAR WEB CRACKED AT RSS 222. REPAIRED WEB IAW EA.SDR SWAA2015051339635Skin · crackedRIGHT WING TE SKIN AT RSS 182 CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2015041638589Control Panel · malfunctionedDECLARED EMER, MCP LOCKUP. 20,000 FEET IN DESCENT AUTOPILOT DISENGAGED & ALL MODES FROZEN. NO TIME TO ATTEMPT MCP RESET BEFORE APPROACH & LANDING. RESET MODE CONTROL PANEL IAW MM.SDR SWAA2015041538527Shear Tie · crackedSHEAR TIE CRACKED AT BS 967, BETWEEN STRINGER 26L - 27L. R & R SHEAR TIE IAW SRM & DWG.SDR SWAA2015041438510Lens · looseRIGHT OVERHEAD OVERWING EMER EXIT SIGN LENS LOOSE. SECURED LENS IAW SIP.SDR SWAA2015041438485Charger · inoperativeRIGHT EMER AISLE LIGHT INOPERATIVE AT ROW 1. R & R BATTERY CHARGER IAW AMM.SDR SWAA2015041438484Light · inoperativeLEFT OVERWING EMER EXIT LATCH LIGHT INOPERATIVE. RELAMPED LIGHT IAW AMM.SDR SWAA2015061040528Spar · crackedRIGHT WING AFT SPAR WEB CRACKED AT RSS 222. REPAIRED SPAR WEB IAW EA.SDR SWAA2015042738978Bracket · crackedLEFT PYLON NR 3 FAIRING FLAP TRACK BRACKET CRACKED. R & R BRACKET IAW SRM & CMM.SDR SWAA2015041338454Slide · unwanted deployR2 DOOR EMER EVAC SLIDE INADVERTENTLY DEPLOYED. R & R SLIDE IAW MT.SDR SWAA2015041338412Battery · failedAIR TURN BACK & DECLARED EMER. AFTER TAKEOFF CLIMBING THROUGH 5,000 WE RECEIVED 2 DC FAIL LIGHTS. R & R ACFT BATTERY IAW MM.SDR SWAA2015041338390Bracket · brokenR2 DOOR EMER EVAC SLIDE GIRT BAR CLAMSHELL BRACKET BROKEN. R & R BRACKET IAW MT.SDR SWAA2015041338397Cover · brokenR1 DOOR EMER LIGHT COVER BROKEN. R & R LIGHT ASSEMBLY IAW AMM.SDR SWAA2015041338396Battery Pack · dischargedM1137 EMER EXIT BATTERY PACK INOPERATIVE AT BS 968R. R & R BATTERY PACK IAW AMM.SDR SWAA2015041038348Tab · damagedLEFT WING AILERON TAB DAMAGED ON THE UPPER SURFACE AT THE INBD END. R & R TAB IAW MM.SDR SWAA2015041038347Wedge · delaminatedLEFT WING NR 2 SLAT TE WEDGE DELAMINATED AT THE OTBD END. R & R NR 2 SLAT IAW AMM.
Back to Boeing 737-3H4