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 SWAA2014042127229Floor Support · crackedLONGITUDINAL FLOORBEAM UPPER CHORD CRACKED BETWEEN BS 666 TO BS 674, LBL 24.8. REPAIRED CHORD IAW ER & EA.SDR SWAA2014041026996Skin · delaminatedRIGHT WING OTBD FORE FLAP UPPER SURFACE DELAMINATED. REPAIRED FORE FLAP IAW SRM.SDR SWAA2014040726880Support Angle · crackedLT WING RSS 546 WIPER WEB SUPPORT ANGLE CRACKED AT INBD SIDE OF AILERON HINGE FITTING. R & R ANGLE IAW SRM.SDR SWAA2014040326803Skin · delaminatedRIGHT WING OTBD AFT FLAP LOWER SURFACE DELAMINATED. REPAIRED AFT FLAP IAW SRM.SDR SWAA2014032726567Angle · crackedRIGHT WING LOWER TE PANEL SUPPORT CRACKED JUST OTBD OF NR 6 FLAP TRACK FAIRING. REPAIRED ANGLE IAW EA.SDR SWAA2014032726566Actuator · leakingLEFT WING NR 2 FLIGHT SPOILER ACTUATOR LEAKED. R & R ACTUATOR IAW AMM.SDR SWAA2014032726565Actuator · leakingRIGHT WING NR 7 FLIGHT SPOILER ACTUATOR LEAKED. R & R ACTUATOR IAW AMM.SDR SWAA2014032626545Pcu · leakingDIVERSION A SYS LEAKED FOLLOWED BY TOTAL A SYS FAILURE. R & R AILERON PCU IAW MM.SDR SWAA2014032626523Battery Pack · dischargedFORWARD ENTRY EMERGENCY LIGHT BATTERY PACK INOPERATIVE. R & R BATTERY PACK IAW MM.SDR SWAA2014032426481Casting · brokenLEFT WING NR 4 GND SPOILER INBD ACTUATOR CASTING BROKEN. R & R SPOILER IAW SRM.SDR SWAA2014032426480Hinge Fitting · brokenLEFT WING NR 4 GND SPOILER CTR OTBD HINGE FITTING BROKEN. R & R SPOILER IAW AMM.SDR SWAA2014032426482Lens · fadedRIGHT OVERWING EMERGENCY LIGHT LENS COVER FADED. R & R COVER IAW MM.SDR SWAA2014060328630Slide · unsecureR1 DOOR EMER EVAC SLIDE INADVERTENTLY FELL OUT, DID NOT DEPLOY, STILL OPERATIONAL. REINSTALLED SLIDE IAW MT.SDR SWAA2014040126713Skin · crackedFUSELAGE SKIN CRACKED AT BS 341, STRINGER 2L. REPAIRED SKIN IAW SRM.SDR SWAA2014033126655Flap · delaminatedRIGHT WING TE OTBD FORE FLAP DELAMINATED. REPAIRED FORE FLAP IAW SRM.SDR SWAA2014033126654Flap · delaminatedLEFT WING OTBD FORE FLAP DELAMINATED. REPAIRED FORE FLAP IAW SRM.SDR SWAA2014033126623Channel · crackedCHANNEL CRACKED BETWEEN BS 663 TO BS 675, BETWEEN RBL 24.8 TO RBL 30. R & R CHANNEL IAW SRM & DWG.SDR SWAA2014033126622Bracket · crackedBRACKET CRACKED AT BS 663 TO BS 675, BETWEEN RBL 30 TO RBL 37. R & R BRACKET IAW SRM & DWG.SDR SWAA2014032626530Actuator · leakingLEFT WING NR 1 SPOILER HYD ACTUATOR LEAKED. R & R ACTUATOR IAW AMM.SDR SWAA2014032526495Coalescer Bag · dirtyAIR TURN BACK ON CLIMB OUT, OIL BURNING SMELL FOG & MIST AT ROW 8 & AFT. R & R WATER SEPARATOR BAGS IAW MM & MT.SDR SWAA2014032426460Slat · crackedRIGHT WING NR 4 LE SLAT CRACKED. R & R SLAT IAW AMM.SDR SWAA2014032426365Slide · low pressureL2 DOOR EMERGENCY EVAC SLIDE PRESS INDICATOR LOW. R & R SLIDE IAW MT.SDR SWAA2014042127228Lens · missingFORWARD ENTRY OVERHEAD EMERGENCY EXIT SIGN LENS ASSEMBLY MISSING. R & R SIGN ASSEMBLY IAW MM.SDR SWAA2014040726870Frame · crackedSTUB FRAME CRACKED AT BS 947, STRINGER 17R. REPAIRED FRAME IAW EA.SDR SWAA2014032426439Slide · out of positionR2 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW MT.SDR SWAA2014032426367Smoke Detector · faultyAIR TURN BACK, DECLARED EMERGENCY. PASSING THROUGH 10,000 FEET WE GOT AN AFT CARGO WARNING LIGHT. R & R AFT SMOKE DETECTORS IAW MM.SDR SWAA2014042227306Beam · crackedFORWARD ENTRY DOOR LOWER EDGE GATE BEAM CRACKED AT AFT END AT STOP PIN FITTING. R & R DOOR IAW MM.SDR SWAA2014032626517Lens · looseLEFT OVERHEAD BIN BULLNOSE PANEL EMERGENCY EXIT LIGHT LENS LOOSE. SECURED LENS IAW AMM.SDR SWAA2014032426472Fitting · crackedFORWARD CARGO DOOR LOWER AFT CORNER ANGLE FITTING CRACKED ATTACHED TO THE SUPPORT TEE AT DOOR BS 34.25, 7 INCHES ABOVE LOWER FRAME. R & R DOOR IAW AMM.SDR SWAA2014032426436Lens · missingLEFT CABIN OVERHEAD BIN BULLNOSE EMERGENCY LIGHT LENS MISSING AT ROW 18. INSTALLED LENS IAW MM.SDR SWAA2014032426366Outflow Valve · faultyCLIMBING THROUGH FL310 TO CRUISE ALT 350 THE CABIN ALT WARNING SOUNDED. R & R OUTFLOW VLV & HEATER GASKET IAW MM.SDR SWAA2014032426414Flap · delaminatedLT WING OTBD AFT FLAP DELAMINATED ON INBD END. R & R AFT FLAP IAW MM.SDR SWAA2014032826613Shear Tie · crackedSHEAR TIE CRACKED AT STATION 380, STRINGER 14L. R & R SHEAR TIE IAW SRM.SDR SWAA2014032426461Flap · delaminatedRIGHT WING INBD FORE FLAP DELAMINATED. R & R FORE FLAP IAW MM.SDR SWAA2014032426459Skin · crackedFUSELAGE SKIN CRACKED AT BS 727B+9, STRINGER 10R. REPAIRED SKIN IAW EA.SDR SWAA2014032426458Skin · crackedFUSELAGE SKIN CRACKED AT BS 500D+10, STRINGER 10L. REPAIRED SKIN IAW EA.SDR SWAA2014032426438Battery Pack · dischargedLEFT EMERGENCY LIGHTS INOPERATIVE. R & R BATTERY PACK IAW MM.SDR SWAA2014032426379Battery Pack · inoperativeRT EMERGENCY LIGHTS INOPERATIVE. R & R BATTERY PACK IAW MM.SDR SWAA2014062329294Fairing · delaminatedLEFT WING INBD FLAP OTBD TRACK FAIRING INBD LOWER SURFACE DELAMINATED. REPAIRED FAIRING IAW EA.SDR SWAA2014041026980Structure · corrodedCHORD CORRODED AT BS 227.8, BETWEEN LBL 10 TO RBL 10. R & R CHORD IAW SRM & DWG.SDR SWAA2014040726901Shear Tie · crackedSHEAR TIE CRACKED AT BS 380, BETWEEN STRINGER 14L TO STRINGER 15L. R & R SHEAR TIE IAW SRM & DWG.SDR SWAA2014040726845Stringer · crackedSTRINGER CRACKED AT BS 500, STRINGER 8R. R & R STRINGER IAW SRM.SDR SWAA2014040726840Stringer · crackedSTRINGER CRACKED AT BS 500, STRINGER 8R. R & R STRINGER IAW SRM.SDR SWAA2014032426442Bracket · out of adjustR2 DOOR EMERGENCY EVAC SLIDE GIRT BAR STORAGE BRACKET OUT OF ADJUSTMENT. ADJUSTED BRACKET IAW AMM.SDR SWAA2014032426346Bracket · crackedLT WING REAR SPAR BRACKET CRACKED AT WING STATION 243. INBD OF INBD GND SPOILER OTBD HINGE BRACKET. R & R BRACKET IAW SRM.SDR SWAA2014032426345Hinge · looseRT WING AILERON TAB OTBD HINGE LOOSE. R & R TAB IAW MM.SDR SWAA2014032426344Attach Bracket · crackedRT WING TRAILING REAR SPAR ATTACH BRACKET CRACKED AT REAR SPAR STATION 238. R & R BRACKET IAW SRM.SDR SWAA2014032026275Spoiler · out of adjustRIGHT WING NR 5 GND SPOILER INBD ACTUATOR OUT OF ADJUSTMENT. R & R SPOILER IAW AMM.SDR SWAA2014032026274Actuator · out of adjustRIGHT WING NR 5 GND SPOILER OTBD ACTUATOR ROD END OUT OF ADJUSTMENT. R & R ACTUATOR IAW AMM.SDR SWAA2014032026272Battery Pack · dischargedRT CABIN EMERGENCY EXIT LIGHT INOPERATIVE AT SEAT ROW 7. R & R BATTERY PACK IAW AMM.
Back to Boeing 737-3H4