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 SWAA2013081519246Slide · out of positionL2 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW AMM.SDR SWAA2013082119405Shear Web · crackedSHEAR WEB CRACKED BETWEEN BS 348.2 TO BS 351.2, BETWEEN STRINGER 17L TO STRINGER 15L. R&R SHEAR WEB IAW SRM.SDR SWAA2013081619258Connector · brokenFWD ENTRY EXIT LIGHT ON LOWERED CEILING STRUCTURE CONNECTOR BROKEN. R&R CONNECTOR IAW SWPM.SDR SWAA2013081519245Flap · delaminatedLT WING OTBD FORE FLAP DELAMINATED. R&R FORE FLAP IAW AMM.SDR SWAA2013081419217Target · looseNO GREEN LIGHT NOSE GEAR ON APPROACH, CYCLED GEAR ALL THREE GREEN. FOUND STRIKER TARGET LOOSE. RESCORED TARGET IAW MM.SDR SWAA2013082719622Door Frame · crackedFWD CARGO DOOR CUTOUT FRAME WEB CRACKED AT BS 440, STRINGER 24R. R&R FRAME IAW EA.SDR SWAA2013081519254Lens · missingPASSENGER CABIN FORWARD ENTRY DOOR EMERGENCY EXIT LIGHT LENS MISSING. INSTALLED LENS IAW SIP.SDR SWAA2013081319143Battery Pack · dischargedRT AFT EXTERIOR EMERGENCY EXIT LIGHTS INOPERATIVE. R&R BATTERY PACK IAW AMM.SDR SWAA2013081919337Angle · crackedRT WING TE ANGLE CRACKED AT CAVITY RSS 546. R&R ANGLE IAW SRM & DRAWING.SDR SWAA2013081419182Door · crackedL1 DOOR AFT UPPER CORNER CRACKED. REPAIRED DOOR IAW SRM.SDR SWAA2013081419175Skin · crackedSKIN CRACKED AT BS 500A + 10, STRINGER 10L. REPAIRED SKIN IAW EA.SDR SWAA2013081319164Sign · looseR1 DOOR EMERGENCY EXIT LIGHT ASSEMBLY LOOSE. SECURED SIGN IAW MM.SDR SWAA2013081219070Sign · brokenFORWARD GALLEY OVERHEAD EMERGENCY EXIT SIGN BROKEN. R&R SIGN IAW AMM.SDR SWAA2013082819655Bulkhead · crackedVERTICAL BEAM WEB CRACKED AT BS 178, RBL 5.7. REPAIRED WEB IAW EA & EO.SDR SWAA2013082719621Web · crackedLT SIDE NLG WW WEB CRACKED AT BS 243.7+3.5 WL 169. REPAIRED WEB IAW EA.SDR SWAA2013082619565Strip · crackedNR 1 ENGINE THRUST REVERSER OTBD FWD EDGE STRIP CRACKED. R&R STRIP IAW SRM & DRAWING.SDR SWAA2013082619553Bulkhead · crackedVERTICAL BEAM WEB CRACKED AT BS 178 RBL 5.7. REPAIRED WEB IAW EA.SDR SWAA2013082119402Lens · brokenL1 DOOR EMERGENCY EXIT SIGN UPPER POSITION LENS ASSEMBLY BROKEN. R&R LENS IAW AMM.SDR SWAA2013082119385Lens · brokenR2 DOOR EMERGENCY EXIT SIGN UPPER POSITION LENS ASSEMBLY BROKEN. R&R LENS IAW AMM.SDR SWAA2013081419173Coalescer Bag · dirtyDIRTY SOCK SMELL DURING FLIGHT. R&R RT COALESCER BAG IAW MM.SDR SWAA2013082619564Skin · crackedLT WING NR 2 SLAT SKIN CRACKED AT OTBD END. REPAIRED SKIN IAW SRM.SDR SWAA2013082619563Frame · missingFRAME OF INTER CHORD MISSING AT BS 348.2 STRINGER 15L. INSTALLED CHORD IAW EO & EA.SDR SWAA2013082319478Skin · crackedRT WING NR 6 INBD EDGE SLAT SKIN CRACKED. REPAIRED SKIN IAW SRM.SDR SWAA2013082119401Attach Angle · crackedLT HORIZONTAL STABILIZER CENTER SECTION ATTACH ANGLE CRACKED. R&R ANGLE IAW SRM & DRAWING.SDR SWAA2013082119400Latch · crackedRT WING ACCESS PANEL NR 6540R LATCH CRACKED. R&R LATCH IAW SRM.SDR SWAA2013081919336Attach Angle · crackedRT HORIZONTAL STABILIZER CENTER SECTION ATTACH ANGLE CRACKED. R&R ANGLE IAW SRM & DRAWING.SDR SWAA2013081919335Stiffener · corrodedAFT CARGO COMPARTMENT STIFFENER CORRODED BETWEEN BS 1006 TO BS 1016, STRINGER 26R. R&R STIFFENER IAW SRM & DRAWING.SDR SWAA2013081519255Access Panel · crackedRT WING ACCESS PANEL PLATE CRACKED ON PANEL NR 6531R. R&R PANEL IAW SRM & DRAWING.SDR SWAA2013081419172Sign · missingR1 DOOR LIGHT SIGN MISSING. INSTALLED SIGN IAW SIP.SDR SWAA2013081419215Shim · crackedLT WING FIXED TE SUPPORT STRUCTURE ACCESS PANEL 5735L SHIM CRACKED. R&R SHIM IAW SRM & DRAWING.SDR SWAA2013081319163Angle · crackedLT WING INBD TE STRUCTURE ANGLE CRACKED AT WBL 184.63. R&R ANGLE IAW SRM & DRAWING.SDR SWAA2013081219069Fitting · out of adjustL1 DOOR EMERGENCY EVAC SLIDE GIRT BAR CLIPS OUT OF ADJUSTMENT. ADJUSTED CLIPS IAW MT.SDR SWAA2013081219016Glowstrip · dirtyRT PHOTOLUMINESCENCE STRIP DIRTY AT ROW 8. CLEANED EEPLS IAW STANDARD INDUSTRY PRACTICES.SDR SWAA2013081219015Web · crackedRT NOSE WW CRACKED AT STATION 259.5 - 1", WL 179. REPAIRED WEB IAW SRM.SDR SWAA2013081219051Cover · brokenR1 DOOR EMERGENCY EXIT LIGHT COVER BROKEN. R&R COVER IAW MM.SDR SWAA2013082719620Bulkhead · corrodedBULKHEAD LOWER CHORD CORRODED AT BS 1016, BL 0. REPAIRED CHORD IAW EO & EA.SDR SWAA2013082619562Stringer · corrodedSTRINGER CORRODED AT BS 947.5 STRINGER 27L. REPAIRED STRINGER IAW SRM.SDR SWAA2013082619561Plate · crackedAFT CARGO COMPARTMENT PLATE CRACKED AT BS 794 BETWEEN STRINGER 25R TO STRINGER 24R. R&R PLATE IAW SRM & DRAWING.SDR SWAA2013081919334Frame · corrodedFRAME CORRODED AT BS 947.5, BETWEEN STRINGER 27L TO STRINGER 27R. REPAIRED FRAME IAW SRM.SDR SWAA2013081419214Plate · crackedRT HORIZONTAL STABILIZER ACCESS PANEL 9226R PLATE CRACKED. R&R PLATE IAW SRM & DRAWING.SDR SWAA2013081419183Shim · corrodedRT WING OTBD FLAP NR 7 FLAP TRACK TAPERED SHIM CORRODED ON LOWER SIDE. REPAIRED SHIM IAW SRM.SDR SWAA2013081319144Flap Track · corrodedRT WING OTBD FLAP TRACK NR 7 CORRODED ON TRACK ATTACHMENT AREA TO AFT SPAR. R&R FLAP TRACK IAW MM.SDR SWAA2013081219019Flap Track · corrodedRT WING NR 7 FLAP TRACK AFT ATTACH POINT TO AFT SPAR CORRODED. R&R NR 7 FLAP TRACK IAW AMM.SDR SWAA2013081219017Cover · inoperativeR2 DOOR EMERGENCY EVAC SLIDE GIRT BAR RETAINING BRACKET INOPERATIVE. R&R COVER IAW MM & MT.SDR SWAA2013080918989Hinge Fitting · crackedLT WING TE AILERON BALANCE BAY VERTICAL ANGLE INBD & FWD OF NR 2 HINGE FITTING CRACKED. R&R FITTING IAW SRM.SDR SWAA2013080919004Fitting · crackedRT WING VERTICAL ANGLE CRACKED IN AILERON BALANCE BAY FWD & INBD OF NR 2 AILERON HINGE FITTING. R&R FITTING IW SRM.SDR SWAA2013080818978Pump · faultyAIR TURNBACK, TOTAL LOSS OF B SYSTEM HYDRAULIC FLUID DURING FLAP RETRACTION, AFTER TAKEOFF. R&R NR 2 ELECTRIC HYDRAULIC PUMP NR 2 ENGINE HYDRAULIC PUMP NR 7 HYDRAULIC PUMP NR 7. SPOILER ACTUATOR IAW AMM.SDR SWAA2013082819654Skin · crackedL2 DOOR FORWARD LOWER DOOR SKIN CUT OUT CRACKED BETWEEN BS 927 TO BS 987, BETWEEN STRINGER 15L TO STRINGER 20L. REPAIRED SKIN IAW EO & EA.SDR SWAA2013082619552Strap · corrodedSTRAP CORRODED AT BS 947.5 STRINGER 27L. R&R STRAP IAW SRM & DRAWING.SDR SWAA2013082619551Skin · crackedL2 DOOR FWD LOWER CORNER FS SKIN CRACKED BETWEEN BS 927 TO BS 987 BETWEEN STRINGER 15L TO STRINGER 20L. REPAIRED SKIN 987 IAW EO & EA.
Back to Boeing 737-3H4