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 SWAA2016010647695Door Sill · corrodedAFT SERVICE DOORWAY MOP SILL CORRODED, BETWEEN BS 907+7 - 1006. R & R MOP SILL IAW SRM.SDR SWAA2015121647193Flap · delaminatedLEFT WING INBD AFT FLAP DELAMINATED. R & R AFT FLAP IAW AMM.SDR SWAA2015121647192Lens · looseLEFT EMER EXIT LIGHT LENS COVER LOOSE. SECURED LENS IAW MM.SDR SWAA2016020148555Pressure Deck · crackedMAIN WW PRESS DECK CRACKED AT BS 665, BETWEEN LBL 38.5 - 39. REPAIRED DECK IAW ER & EA.SDR SWAA2016012548336Shear Tie · crackedFRAME SHEAR TIE CRACKED AT BS 727, STRINGER 14R. REPAIRED SHEAR TIE IAW ER & EA.SDR SWAA2016011948082Intercostal · crackedE & E ACCESS DOOR CUT OUT INTERCOSTAL CRACKED BACKSIDE OF AFT FRAME, UPPER CHORD AREA, LBL 2. R & R INTERCOSTAL IAW SRM.SDR SWAA2016011347954Frame · crackedFRAME CRACKED AT BS 360, BETWEEN STRINGER 13R - 14R. REPAIRED FRAME IAW EA.SDR SWAA2016010547644Skin · crackedRIGHT HORIZONTAL STAB LOWER SKIN CRACKED NEAR AFT SPAR & RIB NR 5. REPAIRED SKIN IAW EA.SDR SWAA2016010447639Floor Support · crackedLONGITUDINAL FLOORBEAM CRACKED AT STATION 727B, RBL 24. REPAIRED BEAM IAW EA.SDR SWAA2015121747253Battery Pack · dischargedRIGHT WING OUTSIDE EMER OVERWING LIGHT INOPERATIVE. R & R BATTERY PACK IAW AMM.SDR SWAA2015121547154Spoiler · out of adjustRIGHT WING GND SPOILER OUT OF ADJUSTMENT. R & R SPOILER IAW AMM.SDR SWAA2015121447054Sensor · out of adjustAIR TURN BACK, NR 1 LE FLAPS, TRANSIT LIGHT REMAINED ILLUMINATED WITH FLAPS UP. ADJUSTED NR 1 SLAT MID SENSOR IAW AMM.SDR SWAA2015121647181Transmission · looseDIVERSION, DECLARED EMER. NR 1 FLAP FAIRING CAME OUT OF TRACKS. R & R NR 2 FLAP TRANSMISSION IAW AMM.SDR SWAA2016012148247Support Angle · crackedRIGHT WING SUPPORT ANGLE CRACKED, BETWEEN BS 706 - 727, RBL 70.85. R & R ANGLE IAW SRM & DWG.SDR SWAA2015121547106Girt Bar · out of adjustL1 DOOR EMER EVAC SLIDE GIRT BAR OUT OF ADJUSTMENT. ADJUSTED SLIDE IAW SIP.SDR SWAA2015121547102Strap · brokenAFT WINDSCREEN LT EMER FLASHLIGHT STRAP BROKEN. R & R STRAP IAW SOPM.SDR SWAA2016020248599Frame · crackedFORWARD CARGO COMPARTMENT, FRAME CRACKED AT BS 500B, BETWEEN STRINGER 21L - 22L. REPAIRED FRAME IAW EA.SDR SWAA2016013048483Glowstrip · corrodedAFT CABIN PHOTO LUMINESCENT FLOOR PROXIMITY, LIGHTING STRIP CORRODED. R & R STRIP IAW AMM.SDR SWAA2016012648391Beam · corrodedLEFT MLG ACTUATOR WALKING BEAM CORRODED AT ACTUATOR ATTACH POINT. R & R BEAM IAW SRM.SDR SWAA2016011147847Fitting · crackedRIGHT WING AFT SPAR WING SPAR, UPPER CHORD TO BODY BATH TUB FITTING AT RSS 70.85 CRACKED. R & R FITTING IAW SRM & DWG.SDR SWAA2015121647195Battery · dischargedFORWARD GALLEY LAVATORY AREA, EMER LIGHT INOPERATIVE. R & R BATTERY IAW SRM & AMM.SDR SWAA2015121547112Flap · crackedLEFT WING OTBD FORE FLAP LE CRACKED. R & R FORE FLAP IAW AMM.SDR SWAA2015121547111Lens · looseL1 EXIT DOOR BULKHEAD EXIT LIGHT LENS LOOSE. SECURED LENS IAW SIP.SDR SWAA2015121547110Skin · crackedFORWARD CARGO DOOR, LOWER DOOR SKIN CRACKED, AT 6:00 POSITION. REPAIRED SKIN IAW SRM.SDR SWAA2015121547104Slide · out of positionL2 DOOR EMER EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW MT.SDR SWAA2015121447071Slide · looseR2 DOOR EMER EVAC SLIDE GIRT BAR LOOSE. SECURED SLIDE IAW MT.SDR SWAA2016020148536Pressure Deck · crackedMAIN WW PRESS DECK WEB CRACKED AT BS 672, LBL 39.5 AT CTR WING BOX. REPAIRED WEB IAW EA.SDR SWAA2016020148535Pressure Deck · crackedPRESSURE DECK WEB CRACKED AT BS 665, RBL 39 AT CTR WING BOX. REPAIRED WEB IAW EA.SDR SWAA2015123047520Fitting · crackedLEFT FWD MLG FITTING CRACKED AT FASTENER HOLE, STATION RSS 224. REPAIRED FITTING IAW EA.SDR SWAA2015121847270Lens · looseFORWARD ENTRY EXIT LIGHT LENS LOOSE. INSTALLED LENS IAW MM.SDR SWAA2015121547153Stiffener · crackedLEFT WING NR 3 INBD FLAP, OTBD TRACK FAIRING INBD SIDE, HOCKEY STICK, STIFFENER CRACKED. R & R STIFFENER IAW SRM & DWG.SDR SWAA2015121547107Slat · delaminatedRIGHT WING NR 6 SLAT DELAMINATED. R & R NR 6 SLAT IAW AMM.SDR SWAA2015121447075Lens · unsecureFORWARD ENTRY EMER EXIT LIGHT LENS COVER FELL OFF. REINSTALLED COVER AMM.SDR SWAA2015121447053Pump · faultyDECLARED EMER, DURING APPROACH WITH GEAR & FLAPS 30, MASTER CAUTION & HYD LIGHTS ILLUMINATED. INDICATIONS WERE A SYS HYD LOW PRESS, BOTH ENG & ELEC, LIGHTS & ZERO A SYS QTY. R & R A ELEC MOTOR DRIVEN PUMP IAW AMM.SDR SWAA2016012248304Skin · crackedRIGHT WING UPPER SKIN, CRACKED AT APPROX RSS 255.5 RT, FASTENER HOLE 1" FROM AFT EDGE. REPAIRED SKIN IAW EA.SDR SWAA2016012248303Skin · crackedRIGHT WING UPPER SKIN, CRACKED AT APPROX RSS 251 RT, FASTENER HOLE 1" FROM AFT EDGE. REPAIRED SKIN IAW EA.SDR SWAA2016012248302Skin · crackedRIGHT WING UPPER SKIN, CRACKED AT APPROX RSS 239.5 RT, FASTENER HOLE 1" FROM AFT EDGE. REPAIRED SKIN IAW EA.SDR SWAA2016012248301Skin · crackedRIGHT WING UPPER SKIN, CRACKED AT APPROX RSS 238 RT, FASTENER HOLE 1INCH FROM AFT EDGE. REPAIRED SKIN IAW EA.SDR SWAA2016012248300Skin · crackedRIGHT WING UPPER SKIN, CRACKED AT APPROX RSS 237 RT, FASTENER HOLE 1 INCH FROM AFT EDGE. REPAIRED SKIN IAW EA.SDR SWAA2016012248264Skin · crackedRIGHT WING UPPER SKIN AT APPROX RSS 236 RT, FASTENER HOLE 1" FROM AFT EDGE CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2016011948108Frame · crackedFRAME CRACKED AT BS 328, STRINGER 21R. REPAIRED FRAME IAW EA.SDR SWAA2016010847806Skin · crackedFORWARD ENTRY DOOR UPPER HINGE CUT OUT CRACKED AT BS 304.4, LT WL 257. REPAIRED CUT OUT IAW SRM.SDR SWAA2016010747781Skin · crackedFORWARD ENTRY DOOR UPPER HINGE CUT OUT, CRACKED AT BS 304.4, LT WL 258.5. REPAIRED CUT OUT IAW SRM.SDR SWAA2016010647679Skin · crackedLEFT WING UPPER SKIN REAR SPAR CRACKED IN FASTENER AREA AT RSS 247. REPAIRED SKIN IAW EA.SDR SWAA2016010647686Skin · crackedLEFT WING UPPER SKIN CRACKED AT REAR SPAR AREA, AFT FASTENER ROW, IN FASTENER AT RSS 267. REPAIRED SKIN IAW EA.SDR SWAA2016010647685Skin · crackedLEFT WING UPPER SKIN REAR SPAR AREA CRACKED AFT FASTENER ROW, IN FASTENER AT RSS 253. REPAIRED SKIN IAW EA.SDR SWAA2016010647684Skin · crackedLEFT WING UPPER SKIN CRACKED IN REAR SPAR AREA, AFT FASTENER ROW, IN FASTENER AT RSS 248. REPAIRED SKIN IAW EA.SDR SWAA2015121647183Spar · crackedRIGHT WING UPPER REAR SPAR CHORD VERTICAL FLANGE CRACKED IN FASTENER HOLE AT RSS 221. REPAIRED FLANGE IAW EA.SDR SWAA2015121547105Slide · out of positionL1 DOOR EMER EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW AMM.SDR SWAA2015121547103Holder · brokenFORWARD GALLEY AREA EMER FLASHLIGHT BASE BROKEN. R & R FLASHLIGHT BASE IAW CMM.
Back to Boeing 737-3H4