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 SWAA2013081619279Skin · crackedRT BS 400+10 UPPER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW SB.SDR SWAA2013081419216Skin · crackedRT BS 500B+10 LOWER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 3,4,12. REPAIRED SKIN IAW SB.SDR SWAA2013080919003Light · inoperativeAFT LT INTERIOR EMERGENCY EXIT SIGN INOPERATIVE. RELAMPED SIGN IAW AMM.SDR SWAA2013080919002Light · inoperativeAFT RT INTERIOR EMERGENCY EXIT SIGN INOPERATIVE. RELAMPED SIGN IAW AMM.SDR SWAA2013080919001Light · inoperativeFWD LEFT INTERIOR EMERGENCY EXIT SIGN INOPERATIVE. RELAMPED SIGN IAW AMM.SDR SWAA2013080919000Strap · crackedFLOOR BEAM STABILIZER STRAP CRACKED AT BS 312, RBL 31. R&R STRAP IAW SRM.SDR SWAA2013080718929Fitting · crackedFORWARD ENTRY UPPER HINGE CUT-OUT ON DOOR FRAME BRACKET CRACKED IN FORWARD OTBD AREA OF HINGE SHELF AREA, OTBD OF HINGE TRACK PLATE. R&R FITTING IAW SRM.SDR SWAA2013080618855Skin · crackedFORWARD ENTRY DOOR FRAME UPPER HINGE CUT OUT CRACKED AT HINGE CUT OUT RADIUS OF EXISTING REPAIR & EXTENDING FORWARD BETWEEN THE RIVET ROWS. REPAIR SKIN IAW SRM.SDR SWAA2013080518835Nut Plate · crackedRT WING NUT PLATE STRIP TE CRACKED AT WBL 202. R&R PLATE IAW SRM.SDR SWAA2013080518834Nut Plate · crackedLT WING NUT PLATE STRIP TE CRACKED AT WBL 202. R&R PLATE IAW SRM.SDR SWAA2013080218807Light · inoperativeRT OVERWING EMERGENCY EXIT LIGHT INOPERATIVE. R&R BULB IAW SIP.SDR SWAA2013080218799Skin · delaminatedLT AILERON TAB DELAMINATED ON UPPER SURFACE AREA AROUND CONTROL RODS. R&R TAB ASSEMBLY PER MM.SDR SWAA2013080218797Battery Pack · dischargedAFT EMERGENCY LIGHTS INOPERATIVE, BATTERY PACK PER MMSDR SWAA2013080218796Hook · out of adjustR1 DOOR EMERGENCY EVAC SLIDE GIRT BAR HOOK OUR OF ADJUSTMENT. ADJUSTED HOOKS PER SIP.SDR SWAA2013080218794Actuator · faultyDIVERSION, WHEN LANDING, GEAR LEVER IS PLACED IN THE OFF POSITION THE RIGHT MAIN RED LANDING REMAINS ILLUMINATED GOES OFF WHEN HANDLE IS PLACED IN UP POSITION. R&R RT MAIN GEAR MODULAR PACKAGE & RT UPLOCK ACTUATOR.SDR SWAA2015060140232Skin · crackedNUMBER 1 LE SLAT SKIN CRACKED AT LOWER SURFACE. REPAIRED SLAT IAW SRM.SDR SWAA2013080118749Light · inoperativeRT OVERWING HATCH EMERGENCY EXIT LIGHT INOPERATIVE. R&R LIGHT ASSEMBLY IAW MM.SDR SWAA2013080118745Flap · delaminatedLT WING OTBD AFT FLAP DELAMINATED. R&R AFT FLAP IAW MM.SDR SWAA2013073118716Sign · brokenR1 DOOR EXIT SIGN BROKEN. R&R SIGN IAW MM.SDR SWAA2013073118702Slide · looseR1 DOOR SLIDE EVACUTION LOOSE. SECURED SLIDE ASSEMBLY IAW MT.SDR SWAA2013080618886Slide · looseL1 DOOR EMERGENCY EVAC SLIDE Z FOLD LOOSE. SECURED SLIDE IAW MM.SDR SWAA2013073118710Stringer Clip · crackedSTRINGER CLIP CRACKED AT STATION 360, STRINGER 9L. R&R CLIP IAW SRM.SDR SWAA2013072918642Light · inoperativeAFT GALLEY RT EMERGENCY LOWER EXIT LIGHT INOPERATIVE. R&R LIGHT ASSEMBLY IAW MMSDR SWAA2013081219053Stringer Splice · crackedSTRINGER SPLICE FITTING CRACKED AT STATION 908, STRINGER 4L. R&R FITTING IAW DRAWING.SDR SWAA2013073018670Light · inoperativeL1 DOOR EMERGENCY EXIT LIGHT INOPERATIVE. R&R EMERGENCY EXIT LIGHT ASSEMBLY IAW MM.SDR SWAA2013072918641Battery Pack · inoperativeEMERGENCY LIGHT BATTERY PACK ASSEMBLY INOPERATIVE. R&R EMERGENCY LIGHT BATTERY PACK ASSEMBLY IAW AMM.SDR SWAA2013072618605Flap · delaminatedLT WING INBD AFT FLAP DELAMINATED ON OTBD CORNER. R&R FLAP ASSEMBLY IAW MM.SDR SWAA2013072618604Cover · looseFWD ENTRY LIGHT COVER FELL OFF. RESECURED FWD ENTRY EXIT LIGHT COVER IAW MM.SDR SWAA2013072618603Battery · dischargedAFT EMERGENCY FLASHLIGHT INOPERATIVE. R&R FLASHLIGHT BATTERY IAW MM.SDR SWAA2013081219052Skin · crackedSKIN CRACKED AT STATION 380, STRINGER 14L. REPAIRED SKIN IAW EA.SDR SWAA2013080218795Skin · crackedSKIN CRACKED BETWEEN STATION 433 TO 436, STRINGER R. REPAIRED DOUBLER IAW EA.SDR SWAA2013080118728Skin · crackedSKIN CRACKED BETWEEN STATION 433 TO STATION 436, STRINGER 2R. REPAIRED SKIN IAW SWA EA.SDR SWAA2013081419213Stringer · crackedSTRINGER CRACKED AT STATION 727 +10, STRINGER 1. REPAIRED STRINGER IAW EA.SDR SWAA2013081419212Skin · crackedSKIN CRACKED AT STATION 380, STRINGER 14R. REPAIRED SKIN IAW EA.SDR SWAA2013080518815Lock Plate · dirtyR2 DOOR EMERGENCY EVAC SLIDE GIRT BAR DIFFICULT TO REMOVE. CLEANED DEBRIS FROM LOCK PLATE IAW MM.SDR SWAA2013072418534Lens · wornR1 DOOR EMERGENCY EXIT SIGN COVER WORN. R&R LENS IAW AMM.SDR SWAA2013073018671Skin · crackedL1 DOOR SKIN CRACKED AT UPPER AFT CORNER. REPAIRED SKIN IAW SRM.SDR SWAA2013072318489Sign · looseFWD GALLEY EMERGENCY EXIT SIGN LOOSE. R&R SIGN IAW MM.SDR SWAA2013072518552Rib · crackedRT WING AFT LOWER RIB CHORD CRACKED AT WBL 135.5. REPAIR CHORD IAW EA.SDR SWAA2013072418545Bracket · crackedCRACK ON HPTCC BRACKET LOCATED AT 4:00 O'CLOCK ON OTBD SIDE NR 2 ENGINE. R&R BRACKET IAW EA.SDR SWAA2013072418536Skin · crackedSKIN CRACKED AT STATION 767+8, STRINGER 10R. REPAIRED SKIN IAW EA.SDR SWAA2013072418535Skin · crackedSKIN CRACKED AT STATION 727G+10, STRINGER 10R. REPAIRED SKIN IAW EA.SDR SWAA2013072218431Lens · missingL2 DOOR EMERGENCY EXIT LIGHT COVER PLATE MISSING. INSTALLED LENS IAW SIP.SDR SWAA2013072418532Fitting · crackedRT ELEVATOR PANEL COVER CLIP CRACKED. R&R CLIP IAW SRM & DRAWING.SDR SWAA2013072218437Slide · low pressureR2 DOOR EMERGENCY EVAC SLIDE PRESSURE LOW. R&R SLIDE IAW MT.SDR SWAA2013072218436Flap · delaminatedRT WING OTBD AFT FLAP DELAMINATED. R&R AFT FLAP IAW AMM.SDR SWAA2013080618896Tab · delaminatedRT ELEVATOR TAB DELAMINATED. REPAIRED TAB IAW EO & EA.SDR SWAA2013080518838Support Angle · crackedLT WING TE UPPER PANEL SUPPORT ANGLE CRACKED JUST OTBD OF PYLON. R&R ANGLE IAW SRM.SDR SWAA2013080518837Support Angle · crackedLT WING TE AILERON WIPER WEB SUPPORT ANGLE CRACKED AT RSS 545. R&R ANGLE IAW SRM.SDR SWAA2013080118754Fitting · crackedLT WING TE UPPER PANEL MIDDLE SUPPORT ANGLE FORWARD CLIP ON INNER PART OF PYLON INBD SIDE CRACKED. R&R CLIP IAW SRM.
Back to Boeing 737-3H4