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 SWAA2014050527673Light · inoperativeLEFT FWD GALLEY AREA EMERGENCY EXIT BULB INOPERATIVE. R & R BULB IAW MM.SDR SWAA2014060228607Plate · crackedNR 2 ENG COWL ACCESS PANEL PLATE CRACKED OTBD FAN COWL. R & R PLATE IAW DWG & SRM.SDR SWAA2014053028494Crease Beam · crackedCREASE BEAM INNER CHORD CRACKED AT BS 639, STRINGER 17L. REPAIRED CHORD IAW EA.SDR SWAA2014053028493Scuff Plate · crackedAFT CARGO DOOR CUT OUT AFT CORNER SCUFF PLATE CRACKED. REPAIRED CUT OUT IAW EA.SDR SWAA2014052728326Structure · crackedLEFT PYLON STRUT ACCESS 5764L CRACKED. REPAIRED STRUT IAW EA.SDR SWAA2014052728325Skin · crackedSKIN CRACKED AT BS 927+5.0, STRINGER 24L. REPAIRED SKIN IAW SRM.SDR SWAA2014052328295Skin · crackedAPU ACCESS DOOR SKIN CRACKED 17 INCHES FROM AFT EDGE CUT OUT & 6 INCHES FROM LT SIDE. REPAIRED SKIN IAW SRM.SDR SWAA2014051427970Skin · delaminatedLEFT WING NR 3 SPOILER UPPER SKIN DELAMINATED. R & R NR 3 SPOILER IAW AMM.SDR SWAA2014050527651Flap · delaminatedLEFT WING OTBD AFT FLAP DELAMINATED. R & R AFT FLAP IAW AMM.SDR SWAA2014050527644Slide · looseR2 DOOR EMERGENCY EVAC SLIDE LOOSE. SECURED SLIDE IAW MM.SDR SWAA2014052928446Frame · crackedCHORD CRACKED AT BS 727, STRINGER 18A RT AT FWD LWR FASTENER HOLE. REPAIRED CHORD IAW EA.SDR SWAA2014052928445Frame · crackedFRAME OTBD CHORD CRACKED AT BS 727, STRINGER 18A LT AT FWD LWR FASTENER HOLE. REPAIRED CHORD IAW EA.SDR SWAA2014050227632Structure · crackedL1 DOOR UPPER HINGE CUT OUT CRACKED FROM LOWER EDGE. R & R CUT OUT IAW EA.SDR SWAA2014050227598Lens · missingRIGHT OVERWING EMERGENCY EXIT LIGHT LENS MISSING. INSTALLED LENS IAW MM.SDR SWAA2014050127574Skin · delaminatedRIGHT INBD AFT FLAP DELAMINATED AT LOWER SURFACE. R & R FLAP ASSEMBLY IAW MM.SDR SWAA2014052028169Stiffener · crackedLEFT WING NR 3 FLAP TRACK FAIRING STIFFENER CRACKED. R & R STIFFENER IAW SRM & DWG.SDR SWAA2014050727768Rib · crackedRIGHT WING STATION 135.5 RIB-3, VERY AFT WEB CRACKED IN THE RIB LOWER CHORD. REPAIRED WEB IAW EA.SDR SWAA2014043027534Light · inoperativeL2 DOOR OUTSIDE EMERGENCY EXIT LIGHT INOPERATIVE. R & R LIGHT IAW MM.SDR SWAA2014061729130Stiffener · crackedCHANNEL STIFFENER CRACKED AT BS 1016+1, RBL 1. REPAIRED STIFFENER IAW EA.SDR SWAA2014061228978Frame · corrodedFRAME LOWER FLANGE CORRODED AT BS 747, BETWEEN STRINGER 25R TO STRINGER 26R. REPAIRED FRAME IAW SRM.SDR SWAA2014051528041Intercostal · crackedAFT CARGO COMPARTMENT RT INTERCOSTAL CRACKED BETWEEN BS 727A TO BS 727B, STRINGER 25R. R & R INTERCOSTAL IAW SRM & DWG.SDR SWAA2014050527661Intercostal · crackedRIGHT MLG WW SHEAR BEAM WEB INTERCOSTAL CRACKED AT OTBD UPPER HOLE. R & R INTERCOSTAL IAW SRM & DWG.SDR SWAA2014042927516Light · brokenR1 DOOR EMERGENCY EXIT LIGHT BROKEN. R & R LIGHT ASSEMBLY IAW AMM.SDR SWAA2014050527650Lens · looseRIGHT OVERWING DOOR EMERGENCY EXIT LENS LOOSE. REPAIRED LENS IAW EA.SDR SWAA2014051428012Shear Tie · crackedSHEAR TIE CRACKED AT BS 540, STRINGER 10L. R & R SHEAR TIE IAW SRM & DWG.SDR SWAA2014050527660Crease Beam · crackedL1 DOOR CREASE BEAM WEB CRACKED. R & R WEB IAW SRM & DWG.SDR SWAA2014042827489Gasper Fan · faultyDURING DESCENT AT 6000. WE GOT A BURNING SMOKE. TURN OFF GASPER & THE BURNING SMELL WENT AWAY. FOUND GASPER FAN FAULTY. R & R GASPER FAN IAW MM.SDR SWAA2014051528040Wedge · delaminatedRIGHT WING, NR 5 SLAT OTBD TE WEDGE DELAMINATED. REPAIRED WEDGE IAW SRM.SDR SWAA2014042827488Mec · faultyAIR TURNBACK EN ROUTE ALTERNATE NR GAUGES FLUCTUATED +/- 1.% N, N2, +/- 100 LBS FF, +/- 10 DEGREE EGT BELOW 75% N1. R & R MEC IAW MM.SDR SWAA2014042827478Slide · out of adjustR2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUSTMENT. ADJUSTED SLIDE IAW AMM.SDR SWAA2014042827477Lens · looseLEFT EMERGENCY EXIT SIGN LIGHT LENS LOOSE. R & R LIGHT ASSEMBLY IAW MM.SDR SWAA2014042827480Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 400, STR 9L. R & R CLIP IAW SRM & BAC.SDR SWAA2014062329336Spar · crackedRIGHT WING REAR SPAR UPPER CHORD CRACKED BETWEEN RSS 224.14 TO 215.97. REPAIRED CHORD IAW EO & EA NO.SDR SWAA2014062329335Spar · crackedLEFT WING REAR SPAR UPPER CHORD CRACKED BETWEEN RSS 224.14 TO 215.97. REPAIRED CHORD IAW EO & EA.SDR SWAA2014051528039Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 344, STRINGER 16L. R & R CLIP IAW SRM.SDR SWAA2014051528033Skin · wrinkledRIGHT WING NR 4 SLAT LOWER SKIN WRINKLED & LOOSE FASTENERS AT ACTUATOR. R & R SLAT ASSEMBLY IAW AMM.SDR SWAA2014051427995Fitting · crackedCLIP CRACKED AT BS 348.2, STRINGER 15L. R & R CLIP IAW DWG & SRM.SDR SWAA2014051427994Reveal · crackedFORWARD ENTRY DOOR CUT OUT, LOWER AFT CORNER, INNER REVEAL SUPPORT CRACKED. R & R REVEAL IAW DWG & SRM.SDR SWAA2014051427969Hinge · looseRIGHT WING AILERON TAB OTBD HINGE & BEARING LOOSE. R & R HINGE ASSEMBLY IAW CMM.SDR SWAA2014050827788Strap · crackedSTRAP CRACKED AT BS 348.7, STRINGER 16L. R & R STRAP IAW SRM & DWG.SDR SWAA2014050827787Attach Fitting · crackedATTACH CLIP CRACKED AT BS 348.7, STRINGER 16L. R & R CLIP IAW SRM & DWG.SDR SWAA2014050827786Attach Fitting · crackedATTACH CLIP CRACKED AT BS 348.7, STRINGER 16L. R & R CLIP IAW SRM & DWG.SDR SWAA2014050727750Crease Beam · corrodedR2 DOOR CREASE BEAM CORRODED BETWEEN BS 971 TO BS 997. REPAIRED BEAM IAW SRM & DWG.SDR SWAA2014050527662Skin Splice · crackedRIGHT WING TO BODY FAIRING SUPPORT LOWER STRUCTURE SKIN SPLICE CRACKED AT BS 680 WW AREA. R & R SPLICE IAW SRM & DWG.SDR SWAA2014050127581Attach Angle · crackedFUSELAGE STRINGER TO FRAME ATTACH ANGLE CRACKED AT STRINGER 9L, STATION 360. R & R ANGLE IAW SRM.SDR SWAA2014042827479Sign · looseR1 DOOR EMERGENCY EXIT SIGN LOOSE. SECURED SIGN IAW MM.SDR SWAA2014042527372Flap · delaminatedLEFT WING OTBD FOREFLAP, INBD TE DELAMINATED. R & R FORE FLAP ASSEMBLY IAW MM.SDR SWAA2014061629068Skin · crackedLEFT WING INBD FIXED LE SKIN CRACKED AT 208. REPAIRED SKIN IAW EA.SDR SWAA2014051928100Support Angle · crackedRIGHT WING TO BODY FAIRING LOWER SUPPORT STRUCTURE ANGLE CRACKED AT BS 680, WW AREA. R & R ANGLE IAW SRM & DWG.SDR SWAA2014051628072Plate · corrodedR2 DOOR UPPER HINGE GUIDE PLATE ASSEMBLY. CORRODED ON UPPER & LOWER SURFACE. R & R PLATE ASSEMBLY IAW SRM.
Back to Boeing 737-3H4