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 SWAA2013102221335Skin · crackedRT BS 767+10 LOWER FWD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW SB.SDR SWAA2013102221334Skin · crackedRT BS 847+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW SB.SDR SWAA2013102221333Skin · crackedRT BS 827+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW SB.SDR SWAA2013102221332Skin · crackedLT BS 847+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 2,3. REPAIRED SKIN IAW SB.SDR SWAA2013102221331Skin · crackedLT BS 787+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 2,3,5. REPAIRED SKIN IAW SB.SDR SWAA2013101821262Skin · crackedRT FS SKIN CRACKED AT BS 787+ 10, UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SERVICE BULLETIN.SDR SWAA2013101821261Skin · crackedRT FS SKIN CRACKED AT BS 767+ 10, UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SERVICE BULLETIN.SDR SWAA2013101821259Skin · crackedRT FS SKIN CRACKED AT BS 867+ 10, LOWER FWD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SERVICE BULLETIN.SDR SWAA2013101821258Skin · crackedRT FS SKIN CRACKED AT BS 867+ 10, UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SERVICE BULLETIN.SDR SWAA2013101421160Flap Track · corrodedRT WING NR 7 FLAP TRACK CORRODED. R & R NR 7 FLAP TRACK IAW AMM.SDR SWAA2013101121089Stringer Clip · crackedSTRINGER CLIP CRACKED AT STATION 887, STRINGER 2R. R &R CLIP IAW SRM & DRAWING.SDR SWAA2013100921006Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 500C STRINGER 16R. R & R CLIP IAW EA.SDR SWAA2013100921033Flap Track · corrodedRT WING NR 7 FLAP TRACK CORRODED AT ATTACH POINT TO WING AREA ON AFT SIDE. R &R TRACK IAW MM.SDR SWAA2013100820978Cover · looseRT EMERGENCY EXIT LIGHT COVER ON FORWARD GALLEY LOOSE. R & R COVER IAW AMM SIP.SDR SWAA2013100820974Light · inoperativeRT OVERWING EXIT SIGN BULBS INOPERATIVE. RELAMPED BULBS IAW AMM.SDR SWAA2013100720878Retainer · brokenRT OVER WING EXIT EMERGENCY LIGHT BULB RETAINERS BROKEN. R & R LIGHT IAW SOPM.SDR SWAA2013101421129Flap Track · corrodedRT WING NR 7 FLAP TRACK FLANGES CORRODED. R & R NR 7 FLAP TRACK IAW MM.SDR SWAA2013101421128Jackscrew · corrodedLT WING NR 2 FLAP TRANSMISSION CORRODED AT JACKSCREW ATTACHMENTS TO GIMBAL. R & R JACK SCREW ASSEMBLY IAW AMM.SDR SWAA2013100921010Light · inoperativeRT EMERGENCY EXIT SIGN LIGHT INOPERATIVE. RELAMPED LIGHTS IAW AMM.SDR SWAA2013100921025Light · inoperativeLT EMERGENCY EXIT SIGN LIGHT INOPERATIVE. RELAMPED LIGHTS IAW AMM.SDR SWAA2013100921022Flap Track · corrodedNR 7 FLAP TRACK MATING SURFACE TO AFT SPAR CORRODED ON MATING SURFACE & AROUND BOLT HOLES. R & R NR 7 FLAP TRACK IAW MM.SDR SWAA2013100820973Casting · brokenLT WING NR 4 GROUND SPOILER OTBD ACTUATOR HINGE CASTING ON SPOILER BOARD BROKEN. R & R SPOILER IAW AMM.SDR SWAA2013100720963Fdu · faultyON LANDING ROLL FIRE WARNING LIGHTS & BELL CAME ON & WOULD NOT RESET, NO FIRE. HANDLES OR OTHER LIGHTS ILLUMINATED. R &R FIRE DETECTION UNIT IAW MM.SDR SWAA2013100921024Stringer Clip · brokenSTRINGER CLIP BROKEN AT BS 847, STRINGER 1. R & R CLIP IAW SRM & BAC DRAWING.SDR SWAA2013100720803Skin · delaminatedLT WING NR 1 FLIGHT SPOILER TE UPPER SURFACE DELAMINATED. R & R SPOILER IAW MM.SDR SWAA2013101421121Skin · crackedRT WING NR 5 SLAT HAS SMALL SKIN CRACKED AT LOWER SIDE, AFT ROW FASTENERS AT INBD AUXILIARY TRACK. REPAIRED SLAT IAW SRM.SDR SWAA2013100921046Module · faultyWITH FLAPS 0-15 WE NOTICED THE AILERONS BINDING. WITH THE AUTOPILOT ENGAGED THE AUTOPILOT WOULD NOT ROLL MORE THAN 10 DEGREES WHEN THE LOC CAPTURED. THE AUTOPILOT ROLL MODE WAS DISCONNECTED WITH THE ROLL MODE IN CLOCKWISE THE AILERONS WERE BINDING AIRSPEED WSDR SWAA2013100220709Angle · crackedRT WING AILERON BALANCE BAY ANGLE CRACKED AT INBD SIDE OF NR 2 HINGE. R & R ANGLE IAW SRM.SDR SWAA2013100220703Wire · damagedLT EMERGENCY EXIT LIGHT BATTERY PACK INOPERATIVE. SPLICED WIRE IAW BSWPM & AMM.SDR SWAA2013100220702Light · inoperativeRT AFT OVERHEAD BIN EMERGENCY LIGHT INOPERATIVE. SECURED LIGHT IAW WDM & MM.SDR SWAA2013100220712Cover · brokenRT OVERWING EMERGENCY EXIT LIGHT LENS COVER BROKEN. R & R COVER IAW EA.SDR SWAA2013100220705Battery · dischargedAFT INBD EMERGENCY FLASHLIGHT BATTERY INDICATOR INOPERATIVE. R & R BATTERY IAW MM.SDR SWAA2013100220704Cover · brokenFWD ENTRY EMERGENCY LIGHT COVER BROKEN. R & R LIGHT IAW AMM.SDR SWAA2013100220701Slide · out of positionL2 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW MT.SDR SWAA2013102221326Stringer Splice · crackedSTRINGER SPLICE CRACKED AT STATION 360, STRINGER 8L. R & R SPLICE IAW SWA EA.SDR SWAA2013101121111Transmission · corrodedNR 2 FLAP TRANSMISSION CORRODED AT GIMBAL ATTACH AREAS. R & R NR 2 FLAP TRANSMISSION IAW AMM.SDR SWAA2013100120579Slide · out of positionR1 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW MT.SDR SWAA2013101421120Fairing · crackedLT WING NR 1 FLAP TRACK FAIRING MID CRACKED AT LE. REPAIRED FAIRING IAW EA.SDR SWAA2013100720863Skin · crackedSKIN CRACKED BETWEEN BS 500D+ 15 - BS 500D+ 16 STRINGER 16R. REPAIRED SKIN IAW ER & EA.SDR SWAA2013100120578Slide · out of positionR1 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW MT.SDR SWAA2013100120625Door Frame · crackedFWD ENTRY DOOR LOWER FRAME CRACKED AT LOWER FWD STOP FITTING. R & R DOOR IAW AMM.SDR SWAA2013102221365Stringer Clip · crackedSTRINGER CLIP CRACKED AT STATION 440, STRINGER 9R. R & R CLIP IAW DRAWING & SRM.SDR SWAA2013102221343Stringer Clip · crackedSTRINGER CLIP CRACKED AT STATION 420, STRINGER 9R. R & R CLIP IAW DRAWING & SRM.SDR SWAA2013100720868Support Fitting · crackedLT WING GROUND SPOILER SUPPORT FITTING CRACKED AT WBL 119.25. R & R FITTING IAW DRAWING & SRM.SDR SWAA2013100720862Skin · crackedSKIN CRACKED BETWEEN BS 972 TO BS 973, STRINGER 21L. REPAIRED SKIN IAW ER & EA.SDR SWAA2013100720861Stiffener · crackedVERTICAL STIFFENER CRACKED AT BS 663 LBL 6. REPAIRED STIFFENER IAW EA.SDR SWAA2013100720797Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 727D+12.5 TO BS 727D+14, STRINGER 19L. REPAIRED SKIN IAW SRM.SDR SWAA2013100720796Skin · crackedFUSELAGE CRACKED BETWEEN BS 790.5 TO BS 791 STRINGER 18L. REPAIRED SKIN IAW SRM.SDR SWAA2013100220715Stiffener · crackedREAR SPAR VERTICAL STIFFENER CRACKED AT BS 663 RBL 6. REPAIRED STIFFENER IAW EA.SDR SWAA2013100220684Shear Tie · crackedSHEAR TIE CRACKED AT BS 727A BETWEEN STRINGER 14L TO STRINGER 15L. R & R SHEAR TIE IAW SRM & DRAWING.
Back to Boeing 737-3H4