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 SWAA2015040638128Tie Clip · crackedTIE CLIP CRACKED AT BS 767, STRINGER 21L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2015033037955Flap · delaminatedLEFT WING OTBD AFT FLAP DELAMINATED. R & R AFT FLAP IAW MM.SDR SWAA2015052940202Frame · crackedFUSELAGE FRAME CRACKED AT STATION 520, STRINGER 21R - 22R. REPAIRED FRAME IAW EA.SDR SWAA2015052640007Light · brokenRIGHT EMER LIGHT ASSEMBLY ON AFT GALLEY AREA CUT OUT BROKEN. R & R LIGHT ASSEMBLY IAW SRM.SDR SWAA2015041038345Support Angle · crackedSUPPORT ANGLE CRACKED BETWEEN BS 291.5 TO 294, STRINGER 17R. R & R ANGLE IAW SRM & DWG.SDR SWAA2015033037978Handle · dirtyLANDING GEAR INDICATOR LIGHTS SHOWED THREE GREEN & THREE RED ON SHORT FINAL, AFTER GO AROUND FWD GEAR CYCLED. REMOVED DEBRIS ON GEAR HANDLE IAW SIP.SDR SWAA2015033037959Cover · looseL1 DOOR EXIT SIGN COVER LOOSE. SECURED COVER IAW EA.SDR SWAA2015033037936Wire · chafedDIVERSION, NR 2 ENG OIL PRESS & TEMP GAUGES READ ZERO. OIL TEMP & PRESS ACFT CB POPPED. FOUND WIRE CHAFED & EXPOSED. REPAIRED WIRE IAW WDM.SDR SWAA2015033037934Pump · malfunctionedAIR TURN BACK, ENG SHUTDOWN & DECLARED EMER AT 36,000'. WHILE CROSS FEEDING NR 1 ENG FLAME OUT. R & R NR 1 ENG DRIVEN FUEL PUMP IAW MT.SDR SWAA2015061140610Skin · crackedFOUND THE FUSELAGE SKIN CRACKED AT R1 DOOR CUTOUT BS 294.3, STRINGER 13R. REPAIRED THE SKIN IAW EA.SDR SWAA2015043039183Shear Tie · corrodedSHEAR TIE CORRODED AT BS 727E, BETWEEN STRINGER 27L - 27R. REPAIRED SHEAR TIE IAW ER & EA.SDR SWAA2015042939107Skin · delaminatedLEFT WING LE NR 2 SLAT OTBD SIDE DELAMINATED. R & R NR 2 SLAT IAW AMM.SDR SWAA2015041338389Angle · crackedRIGHT AFT STRUT NACELLE ANGLE CRACKED AT BS 279.50. R & R ANGLE IAW DWG & SRM.SDR SWAA0300030137973Battery Pack · dischargedRIGHT EMER LIGHT INOPERATIVE BETWEEN ROW 20 - 24. R & R BATTERY PACK IAW AMM.SDR SWAA2015033037972Lens · looseFORWARD ENTRY EXIT LIGHT LENS LOOSE. R & R LENS IAW AMM.SDR SWAA2015033037952Lens · brokenL2 DOOR EMER LIGHT LENS BROKEN. R & R LIGHT ASSEMBLY IAW AMM.SDR SWAA2015061040521Support Fitting · crackedRIGHT WING REAR SPAR SUPPORT FITTING CRACKED ABOVE MLG. REPAIRED FITTING IAW EA.SDR SWAA2015042738980Angle · crackedRIGHT WING TE AREA ANGLE CRACKED AT LEVEL WBL 71.24. R & R ANGLE IAW SRM & DWG.SDR SWAA2015042338801Flap Track · corrodedLEFT WING NR 1 FLAP TRACK ATTACH PAD AREA HOLE CORRODED. REPAIRED HOLE IAW CMM.SDR SWAA2015042038663Web · crackedWEB CRACKED BETWEEN BS 616 - 639, STRINGER 17L. R & R WEB IAW SRM & DWG.SDR SWAA2015041338391Skin · delaminatedLEFT WING NR 2 SLAT INBD EDGE UPPER SURFACE DELAMINATED. REPAIRED NR 2 SLAT IAW SRM.SDR SWAA2015040738247Lug · corrodedLEFT WING NR 4 FLAP TRACK AFT ATTACHMENT LUG BORE CORRODED. REPAIRED LUG BORE IAW CMM.SDR SWAA2015040738246Lug · corrodedRIGHT WING NR 5 FLAP TRACK OTBD LUG CORRODED. REPAIRED LUG IAW CMM.SDR SWAA2015040738235Floorbeam · crackedFLOORBEAM WEB CRACKED AT BS 639+1.5, RBL 45.5. REPAIRED WEB IAW SRM.SDR SWAA2015040238074Skin · delaminatedLEFT WING OTBD FORE FLAP DELAMINATED ON LOWER INBD SURFACE. REPAIRED FORE FLAP IAW SRM.SDR SWAA2015040238071Slat · delaminatedRIGHT WING NR 4 SLAT ON INBD END AT LE DELAMINATED A UPPER TE AREA. REPAIRED NR 4 SLAT IAW SRM.SDR SWAA2015032737912Light · inoperativeEMERGENCY EXIT BULLNOSE LIGHT INOPERATIVE AT 12 ABC. FOUND OVERHEAD BIN ATTACH BOLT BINDING LIGHT ASSEMBLY. REPOSITIONED BOLT & OPERATIONS CHECKED GOOD IAW MM. .SDR SWAA2015052539971Tee Fitting · crackedWING TO BODY FAIRING AREA TEE CHORD CRACKED AT BS 727, BETWEEN STRINGER 22R TO 26R. R & R TEE CHORD IAW SRM & DWG.SDR SWAA2015052239934Support Channel · corrodedAFT CARGO COMPARTMENT SUPPORT CHANNEL CORRODED BETWEEN BS 727D - 727E, BETWEEN STRINGER 27L - 27R. REPAIRED CHANNEL IAW EA.SDR SWAA2015051139520Skin · delaminatedRIGHT WING NR 8 SPOILER UPPER EXTERNAL SURFACE DELAMINATED. R & R SPOILER IAW AMM.SDR SWAA2015050439272Frame · crackedFRAME WEB CRACKED AT BS 328, BETWEEN STRINGER 20R - 21R. REPAIRED FRAME IAW ACO.SDR SWAA2015050439271Skin · crackedLEFT WING FIXED LE SKIN CRACKED AT LEVEL FSS 536+7. REPAIRED SKIN IAW SRM.SDR SWAA2015042438879Shear Tie · corrodedSHEAR TIE CORRODED AT BS 767, BETWEEN STRINGER 26L - 27L. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2015041438508Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 1120, STRINGER 2L. R & R CLIP IAW SRM.SDR SWAA2015040838293Fairing · crackedLEFT WING NR 2 FLAP FAIRING TAIL CONE CRACKED FROM TWO HOLES TO THE FWD EDGE. REPAIRED FAIRING IAW SRM.SDR SWAA2015040638134Flap · delaminatedLEFT WING OTBD FORE FLAP DELAMINATED ON THE OTBD TE. REPAIRED FORE FLAP IAW SRM.SDR SWAA2015040638133Skin · crackedFUSELAGE SKIN CRACKED AT BS 424.5, STRINGER 2R. REPAIRED SKIN IAW EA.SDR SWAA2015040138037Shear Tie · corrodedFORWARD CARGO BAY FRAME SHEAR TIE CORRODED AT BS 500C, BETWEEN STRINGER 28L - 28R. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2015032737913Lens · unsecureFORWARD ENTRY EMER EXIT LIGHT LENS FELL OFF. R & R LIGHT ASSEMBLY IAW MM.SDR SWAA2015032637879Cover · crackedL1 EMER EXIT LIGHT COVER CRACKED. R & R COVER IAW SIP.SDR SWAA2015051839778Bulkhead · crackedAFT PRESS BULKHEAD WEB CRACKED AT BS 1016, STRINGER 23L. REPAIRED WEB IAW EA.SDR SWAA2015050439270Door Frame · crackedAFT FWD CORNER OF AFT CARGO COMPARTMENT DOOR FRAME ANGLE CRACKED. REPAIRED FRAME IAW EA.SDR SWAA2015042338858Skin · delaminatedLEFT WING INBD FORE FLAP LOWER SKIN DELAMINATED. REPAIRED FORE FLAP IAW SRM.SDR SWAA0100040138343Bracket · crackedRIGHT WING NR SUPPORT TRANSMISSION INTERNAL AREA BRACKET CRACKED. R & R BRACKET IAW SRM & DWG.SDR SWAA2015040938319Shear Tie · corrodedSHEAR TIE CORRODED AT BS 767, BETWEEN STRINGER 26R - 27R. REPAIRED SHEAR TIE IAW SRM & DWG.SDR SWAA2015040638135Bracket · crackedBRACKET CRACKED BETWEEN BS 380 - 400, STRINGER 1. R & R BRACKET IAW DWG & SRM.SDR SWAA2015040238070Strap · crackedSTRAP CRACKED BETWEEN BS 294.5+13 - 344+5, RBL 34. R & R STRAP IAW SRM & DWG.SDR SWAA2015033037951Strap · crackedSTRAP CRACKED BETWEEN BS 294.5+13 TO 360+5, RBL 46. R & R STRAP IAW SRM & DWG.SDR SWAA2015033037950Strap · crackedSTRAP CRACKED BETWEEN BS 294.5+13 TO 344+5, BL 0. R & R STRAP IAW SRM & DWG.SDR SWAA2015032637900Door · crackedRIGHT WING FIXED LE FSS 196 IN CORNER OF DOOR 6405R CRACKED. REPAIRED DOOR IAW EA.
Back to Boeing 737-3H4