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 SWAA2015102045142Skin · crackedRIGHT WING FOUND CRACKED HOLE ON UPPER AFT CHORD, UPPER WING SKIN AT RSS 255. REPAIRED SKIN IAW ER & EA.SDR SWAA2015091043710Module · faultyDECLARED EMER, A HYD QTY DROPPED SIGNIFICANTLY. R & R MODULAR PACKAGE IAW MM.SDR SWAA2015091043709Boot · tornDECLARED EMER, CABIN ALT WARNING AT CRUISE FLT 250. FOUND RT PACK PRESS BOOT TORN. R & R RT AIR CONDITION PACK DUCT BOOT IAW AMM.SDR SWAA2015091043630Sign · missingLEFT DOOR OVERWING EXIT SIGN MISSING. INSTALLED SIGN IAW SIP.SDR SWAA2015091043628Lens · looseLEFT EMER OVERWING LIGHT LENS LOOSE. R & R LENS ASSEMBLY IAW AMM.SDR SWAA2015100944749Fairing · crackedRIGHT WING PYLON UPPER PANEL, JUST AFT OF NR 58710R, CRACKED AT AFT INBD SIDE CUT OUT. REPAIRED FAIRING IAW EA.SDR SWAA2015100544552Spar · crackedLEFT WING AFT SPAR WEB CRACKED AT WS 223. REPAIRED WEB IAW EA.SDR SWAA2015100544551Spar · crackedLEFT WING AFT SPAR WEB CRACKED AT WS 224. REPAIRED WEB IAW EA.SDR SWAA2015100544550Spar · crackedLEFT WING AFT SPAR WEB CRACKED AT WS 186.9. REPAIRED WEB IAW EA.SDR SWAA2015100544549Spar · crackedLEFT WING AFT SPAR WEB CRACKED AT WS 179.56. REPAIRED WEB IAW EA.SDR SWAA2015092944391Skin · crackedRIGHT WING UPPER SKIN CRACKED IN FASTENER HOLE NEAR RSS 172, COMMON TO REAR SPAR UPPER CHORD, FWD ROW. REPAIRED SKIN IAW EA.SDR SWAA2015091043632Lens · brokenL2 DOOR EMER LIGHT LENS BROKEN. R & R LIGHT ASSEMBLY IAW MM.SDR SWAA2015091043584Light · brokenENTRY DOOR EMER LIGHT BROKEN. R & R LIGHT IAW MM.SDR SWAA2015091043582Skin · crackedL1 DOOR EXTERNAL SKIN CRACKED FWD AFT RIVET ROW BELOW GATE. REPAIRED DOOR IAW SRM.SDR SWAA2015090943569Inverter · faultyDIVERSION, SMELL OF ELEC FUMES REPORTED IN THE VICINITY OF ROW 21 & 22, DURING CRUISE. GASPER FAN TURNED OFF AT 10,000 FEET, FUMES DISSIPATED, SOMEWHAT DURING DESCENT. R & R STATIC INVERTER IAW AMM.SDR SWAA2015090943568Smoke Detector · false activationDIVERSION, AFT LAVATORY SMOKE ALARM GOING OFF IN FLIGHT. PERFORMED SATISFACTORY CONDITIONAL INSPECTION FOR FUMES IN CABIN IAW MM. AFT LAVATORY SMOKE DETECTOR CHECKED GOOD IAW MM.SDR SWAA2015100644619Spar · crackedRIGHT WING REAR SPAR WEB CRACKED AT RSS 223.16, UPPER FASTENER ROW, HOLE COMMON TO UPPER REAR SPAR CHORD. REPAIRED WEB IAW EA.SDR SWAA2015100544548Spar · crackedRIGHT WING REAR SPAR WEB CRACKED AT RSS 216.97, UPPER FASTENER ROW, HOLE COMMON TO UPPER REAR SPAR CHORD. REPAIRED WEB IAW EA.SDR SWAA2015100144449Skin · crackedSKIN CRACKED AT BS 500D+5, STRINGER 2R. REPAIRED SKIN IAW SRM.SDR SWAA2015091043650Girt Bar · looseR1 DOOR EMER EVAC SLIDE GIRT BAR, GIRT LOOSE. SECURED GIRT BAR IAW MT & MM.SDR SWAA2015091043649Girt Bar · looseL1 DOOR SLIDE EMER EVAC SLIDE, GIRT BAR LOOSE. SECURED GIRT BAR IAW MT & MM.SDR SWAA2015090443507Lens · looseL1 DOOR THRESHOLD EMER LIGHT LENS LOOSE. SECURED LENS IAW MM.SDR SWAA2015100144423Link · corrodedLEFT MLG SUPPORT BEAM SWING LINK PLATE, AREA D CORRODED. R & R LINK IAW AMM.SDR SWAA2015100144401Wire · looseLEFT MAIN GEAR RED LIGHT ILLUMINATED & THERE WAS NO GREEN LIGHT AFTER A FLY BY. WHILE RUNNING CHECKLIST THE GREEN LIGHT CAME ON & RED LIGHT WENT OUT. FOUND LOOSE GND WIRE. SECURED GND WIRE IAW AMM.SDR SWAA2015090243444Girt Bar · out of positionR1 DOOR EMER EVAC SLIDE GIRT BAR OUT OF POSITION. R & R SLIDE IAW MT.SDR SWAA2016061352775Spar · crackedLEFT WING REAR SPAR WEB CRACKED AT RSS 221.14 UPPER CHORD AND FORWARD FITTING. REPAIRED WEB IAW EA.SDR SWAA2015092544279Support Fitting · crackedRIGHT WING MLG AFT SUPPORT FITTING CRACKED AT RSS 224.14. REPAIRED FITTING IAW DWG.SDR SWAA2015092344209Support Fitting · crackedLEFT WING SPAR MLG AFT SUPPORT FITTING, CRACKED AT RSS 224.14. R & R FITTING IAW SRM.SDR SWAA2015091443741Skin · crackedFUSELAGE SKIN CRACKED AT BS 941, STRINGER 4L. REPAIRED SKIN IAW SRM.SDR SWAA2015102045141Skin · crackedRIGHT WING UPPER SKIN ABOVE AFT WING SPAR, AFT ROW OPEN HOLE FASTENER CRACKED AT RSS 267. REPAIRED SKIN IAW ER & EA.SDR SWAA2015090243426Skin · crackedFUSELAGE SKIN CRACKED AT BS 949.75, STRINGER 11L. REPAIRED SKIN IAW SRM.SDR SWAA2015083143362Slide · out of positionR1 DOOR EMER EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW SIP.SDR SWAA2015083143361Fitting · missingL1 DOOR EMER EVAC SLIDE, METAL CLIP MISSING. R & R SLIDE IAW MT.SDR SWAA2015102245220Spar · crackedRIGHT WING AFT SPAR WEB, LABELED NR 6 ON INBD SIDE OF RSS 224.14, CRACKED. REPAIRED WEB IAW EA.SDR SWAA2015090443511Stringer Clip · crackedSTRINGER CLIP DAMAGED AT STATION 827, STRINGER 1. R & R CLIP IAW SRM.SDR SWAA2015083143355Bracket · crackedR2 DOOR EMER EVAC SLIDE, FWD UPPER BRACKET CRACKED. R & R BRACKET IAW SRM.SDR SWAA2015083143354Light · out of adjustCABIN CEILING EMER EXIT LIGHT OUT OF ADJUSTMENT. ADJUSTED LIGHT IAW AMM.SDR SWAA2015102045140Skin · crackedRIGHT WING UPPER SKIN ABOVE AFT WING SPAR, FWD ROW OPEN HOLE FASTENER CRACKED AT RSS 285. REPAIRED SKIN IAW ER & EA.SDR SWAA2015102045139Skin · crackedRIGHT WING UPPER SKIN ABOVE AFT WING SPAR, FWD ROW OPEN HOLE FASTENER CRACKED AT RSS 267. REPAIRED SKIN IAW ER & EA.SDR SWAA2015102045138Skin · crackedRIGHT WING UPPER SKIN CRACKED ABOVE AFT WING SPAR, AFT ROW OPEN HOLE FASTENER CRACKED AT RSS 261. REPAIRED SKIN IAW ER & EA.SDR SWAA2015102045137Skin · crackedRIGHT WING UPPER SKIN ABOVE AFT WING SPAR, AFT ROW OPEN HOLE FASTENER CRACKED AT RSS 255. REPAIRED SKIN IAW ER & EA.SDR SWAA2015102045133Skin · crackedRIGHT WING UPPER SKIN CRACKED AT AFT SPAR RSS 253. REPAIRED SKIN IAW ER & EA.SDR SWAA2015102045132Spar · crackedRIGHT WING UPPER SKIN CRACKED AT REAR SPAR AT WBL 251. REPAIRED SPAR WEB IAW ER & EA.SDR SWAA2015101344857Support Fitting · crackedRIGHT WING FWD SUPPORT FITTING LOCATED ON FWD SIDE OF AFT SPAR WEB RSS 224.14, CRACKED ON HOLE 5. R & R FITTING IAW SRM.SDR SWAA2015100944732Spar · crackedRIGHT WING REAR UPPER SPAR CRACKED ABOVE MLG BEAM AFT ATTACH FITTING AT RSS 221. REPAIRED CHORD IAW SRM.SDR SWAA2015100944748Spar · crackedLEFT WING UPPER REAR SPAR, CRACKED ABOVE MLG BEAM AFT ATTACH FITTING AT RSS 221. REPAIRED CHORD IAW SRM.SDR SWAA2015091743984Shear Web · crackedSHEAR WEB CRACKED AT BS 440, BETWEEN STRINGER 26R - 27R. R & R SHEAR WEB IAW SRM & DWG.SDR SWAA2015091043586Angle · crackedLEFT WING TE SEAL BULKHEAD LOWER ANGLE CRACKED AT WBL 209. R & R ANGLE IAW SRM.SDR SWAA2015083143351Light · inoperativeAFT LT EMER EXIT LIGHT IN OVERHEAD BAG BIN INOPERATIVE. RELAMPED LIGHT IAW AMM.SDR SWAA2015082843283Flap · delaminatedRIGHT WING OTBD AFT FLAP TE INBD CORNER DELAMINATED. R & R AFT FLAP IAW AMM.
Back to Boeing 737-3H4