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 SWAA2013092320366Lens · out of positionAFT ENTRY DOOR EMERGENCY EXIT LIGHT LENS OUT OF POSITION. REPOSITIONED LENS IAW MM.SDR SWAA2013092320407Lens · crackedFWD AISLE EMERGENCY EXIT SIGN LENS CRACKED. R & R LENS IAW MM.SDR SWAA2013100320755Skin · crackedLT WING LE NR 2 SLAT CRACKED. REPAIRED SKIN IAW SRM.SDR SWAA2013100120629Pressure Deck · crackedMAIN WW TOP PRESSURE DECK CRACKED BETWEEN BS 672.750 TO BS 673.0 RBL 42.0. REPAIRED WEB IAW SRM.SDR SWAA2013100120628Pressure Deck · crackedMAIN WW TOP PRESSURE DECK CRACKED BETWEEN BS 665.187 TO BS 664.875 RBL 39.75. REPAIRED WEB IAW SRM.SDR SWAA2013093020557Fitting · crackedL1 DOOR AFT DOOR FRAME CLIP CRACKED AT BS 348.2 STRINGER 15L AT LOWER END. R & R CLIP IAW SRM & DRAWING.SDR SWAA2013092320385Spoiler · damagedRT WING NR 7 SPOILER DAMAGED. R & R NR 7 SPOILER IAW AMM.SDR SWAA2013092320384Spoiler · delaminatedRT WING NR 6 SPOILER DELAMINATED. R & R NR 6 SPOILER IAW AMM.SDR SWAA2013092320380Handle · looseL1 DOOR EMERGENCY EVAC SLIDE MANUAL RELEASE HANDLE LOOSE. SECURED HANDLE IAW MT.SDR SWAA2013092320379Handle · looseR1 DOOR EMERGENCY EVAC SLIDE MANUAL RELEASE HANDLE LOOSE. SECURED HANDLE IAW MT.SDR SWAA2013092320363Boot · out of positionDIVERSION AT FL350 THE CABIN ALT WARNING HORN SOUNDED CABIN ALT APPROXIMATELY 11K EMERGENCY DESCENT - CABIN ALT NEVER EXCEEDED 12K'. HOT AIR SUPPLY DUCT BOOT IN RT A/C BAY FORWARD WALL PARTIALLY OFF FLANGE, LEAKED. R & R LT SUPPLY DUCT CHECK VALVE IAW MM.SDR SWAA2013092320406Attach Angle · crackedRT WING OTBD FIREBOX LOWER OTBD EDGE OF WING PANEL ATTACH ANGLE CRACKED. REPAIRED ANGLE IAW SRM.SDR SWAA2013101421131Skin · dentedFUSELAGE SKIN DENTED AT LOWER LOBE BETWEEN STATION 796 TO STATION 807, BETWEEN STRINGER 25R TO 27R. REPAIRED SKIN IAW EA.SDR SWAA2013100921005Shear Tie · crackedSHEAR TIE CRACKED AT BS 500A BETWEEN STRINGER 15R TO STRINGER 16R. R & R SHEAR TIE IAW SRM.SDR SWAA2013100921004Skin · crackedSKIN CRACKED AT BS 400 + 4" TO 7.25" STRINGER 16L. REPAIRED SKIN IAW EA.SDR SWAA2013100921003Skin · crackedSKIN CRACKED AT BS 500B + 15" TO 17" STRINGER 16R. REPAIRED SKIN IAW EA.SDR SWAA2013100820977Slat · delaminatedLT WING NR 2 LE SLAT OTBD AFT CORNER DELAMINATED. REPAIRED NR 2 SLAT IAW SRM.SDR SWAA2013100820966Skin · crackedSKIN CRACKED AT BS 847 + 5.25" TO 6.125, STRINGER 15R. REPAIRED SKIN IAW EA.SDR SWAA2013100720860Skin · crackedSKIN CRACKED AT BS 847 + 2.5" TO 5.75, STRINGER 15R, R & R DOUBLER IAW EA.SDR SWAA2013100320754Bear Strap · crackedFWD ENTRY DOOR UPPER FWD CORNER SKIN CUTOUT CRACKED IN THE BEAR STRAP. REPAIRED SKIN IAW ATS ER & EA.SDR SWAA2013100220706Crease Beam · corrodedRT CREASE BEAM WEB CORRODED BETWEEN BS 500B & BS 500C. REPAIRED WEB IAW SRM.SDR SWAA2013092320393Light · inoperativeRT AFT NR 5 EMERGENCY EXIT SIGN INOPERATIVE. RELAMPED IAW AMM.SDR SWAA2013092320386Angle · crackedLT TE WING INBD NO STEP FWD INBD ANGLE CRACKED. R & R ANGLE IAW SOPM & SRM.SDR SWAA2013092320405Light · inoperativeRT OVERWING NR 2 EMERGENCY EXIT SIGN INOPERATIVE. RELAMPED LIGHT IAW AMM.SDR SWAA2013092320339Stringer Clip · crackedSTRINGER CLIP CRACKED AT STATION 420 STRINGER 8L. R & R CLIP IAW SRM & DRAWING.SDR SWAA2013092320338Stringer Clip · crackedSTRINGER CLIP CRACKED AT STATION 380 STRINGER 8L. R & R CLIP IAW SRM & DRAWING.SDR SWAA2013100921002Skin · crackedSKIN CRACKED AT BS 500D + 16" TO 18" STRINGER 16R. REPAIRED SKIN IAW EA.SDR SWAA2013100921001Skin · crackedSKIN CRACKED AT BS 500D + 14" TO 17" STRINGER 15R. REPAIRED SKIN IAW EA.SDR SWAA2013100720877Pressure Deck · crackedMAIN WW PRESSURE CRACKED AT BS 665.25 LBL 39.25. REPAIRED DECK IAW EA.SDR SWAA2013100720876Frame · crackedFRAME CRACKED AT BS 727 STRINGER 18A LT SIDE. R & R FRAME IAW SWA EA.SDR SWAA2013100720875Door Frame · crackedFWD CARGO DOOR FWD FRAME CRACKED AT LOWER STOP FITTING UPPER SIDE AT FASTENER HOLE LOCATION. R & R FRAME IAW SRM & DRAWING.SDR SWAA2013100320731Support Angle · crackedWING TO BODY FAIRING SUPPORT ANGLE CRACKED AT BS 540 BETWEEN STRINGER 22R & STRINGER 23R. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2013100320730Rib · crackedRT WING LOWER CHORD RIB CRACKED AT WBL 135.50 BETWEEN STRINGER 2 TO STRINGER 3. REPAIRED CHORD IAW EA.SDR SWAA2013093020569Floorbeam · crackedUPPER FLOOR BEAM ''T'' CAP CRACKED AT BS 312 RBL 20. REPAIRED ANGLES IAW SRM.SDR SWAA2013093020563Angle · crackedVERTICAL ANGLE CRACKED AT BS 312 BL O. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2013093020562Angle · crackedFWD CARGO COMPARTMENT ANGLE CRACKED AT BS 400 STRINGER 26L. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2013092620525Shear Tie · corrodedBS 500 FRAME CORRODED AT BS 500 BETWEEN STRINGER 8R TO STRINGER 27R. R & R SHEAR TIE IAW SRM.SDR SWAA2013092420456Strap · crackedSTRAP CRACKED AT BS 314 RBL 31 UNDER FLOOR STRUCTURE INTERNAL AREA EE COMPARTMENT. R & R STRAP IAW SRM & DRAWING.SDR SWAA2013092420450Shear Tie · corrodedFRAME CORRODED AT BS 500D, BETWEEN STRINGER 28R TO STRINGER 28L. R & R SHEAR TIE IAW SRM & DRAWING.SDR SWAA2013092320361Tire · separatedAIR TURNBACK, DECLARED EMERGENCY, AT ROTATION FLT CONTROL ANNOUNCE LIGHT & "A" SIDE HYD LOW PRESSURE LIGHT ILLUMINATED. LANDING GEAR DID NOT RETRACT, FOUND NR 2 TIRE LOST TREAD. R & R NR 2 MAIN TIRE IAW MM.SDR SWAA2013092320365Angle · crackedANGLE CRACKED AT BS 334, STRINGER 20L. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2013092320364Angle · crackedANGLE CRACKED AT BS 328, STRINGER 20L. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2013031820248Cover · crackedFWD ENTRY EMERGENCY EXIT LIGHT COVER CRACKED. R & R LIGHT ASSEMBLY IAW AMM.SDR SWAA2013091820211Slide · unwanted deployL1 DOOR EMERGENCY EVAC SLIDE INADVERTENTLY DEPLOYED UPON INITIAL DOOR OPENING. R&R SLIDE IAW MT.SDR SWAA2013101721253Skin · damagedSKIN DAMAGED AT STATION 852, BETWEEN STRINGER 1 TO STRINGER 2R. REPAIRED SKIN IAW EA.SDR SWAA2013101421130Door Frame · crackedPASSENGER CABIN FWD GALLEY DOOR AFT DOOR STOP FITTING THIRD FROM BOTTOM CUTOUT CRACKED ON INTERIOR RADIUS. R & R FRAME ASSEMBLY IAW SRM & DRAWING.SDR SWAA2013100921000Skin · crackedSKIN CRACKED AT BS 727C + 6" STRINGER 14R. REPAIRED SKIN IAW EA.SDR SWAA2013100720867Angle · crackedANGLE CRACKED AT BS 540 RBL 1. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2013100220711Cover · crackedVERTICAL STABILIZER COVER CRACKED LOCATED REAR SPAR AT BS 233.09. R & R COVER IAW SRM & DRAWING.SDR SWAA2013100120597Angle · crackedVERTICAL STABILIZER ANGLE CRACKED AT REAR SPAR AT BS 233.09. R &R ANGLE IAW SRM & DRAWING.
Back to Boeing 737-3H4