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 SWAA2015061940929Skin · crackedLEFT WING UPPER SKIN AT REAR SPAR AREA CRACKED AT RSS 266. REPAIRED SKIN IAW EA.SDR SWAA2015061940928Skin · crackedLEFT WING UPPER SKIN AT REAR SPAR AREA CRACKED AT RSS 253. REPAIRED SKIN IAW EA.SDR SWAA2015061840888Skin · crackedLEFT WING UPPER SKIN AT REAR SPAR AREA CRACKED AT RSS 237. REPAIRED SKIN IAW EA.SDR SWAA2015051939840Fairing · delaminatedRIGHT WING TO BODY FAIRING FWD OF WW DELAMINATED. R & R FAIRING IAW SRM.SDR SWAA2015051539709Tie Clip · crackedTIE CLIP CRACKED AT BS 1006, STRINGER 17A LT. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2015050439274Skin · crackedLEFT WING UPPER SKIN AT REAR SPAR AREA CRACKED AT RSS 155. REPAIRED SKIN IAW SRM.SDR SWAA2015050439254Skin · crackedLEFT WING UPPER SKIN AT REAR SPAR AREA CRACKED AT HOLE AT RSS 233. REPAIRED SKIN IAW SRM.SDR SWAA2015070641319Spar · crackedRIGHT WING REAR SPAR WEB CRACKED IN SPAR WEB UPPER CHORD ATTACH FASTENER HOLE RSS 223. REPAIRED CHORD IAW EA.SDR SWAA2015070641318Skin · crackedRIGHT UPPER WING SKIN AT AFT UPPER CHORD CRACKED AT RSS 263. REPAIRED SKIN IAW EA.SDR SWAA2015070641317Skin · crackedRIGHT UPPER WING SKIN AT AFT UPPER CHORD CRACKED AT RSS 258. REPAIRED SKIN IAW EA.SDR SWAA2015070641316Skin · crackedRIGHT UPPER WING SKIN AT AFT UPPER CHORD CRACKED AT RSS 256. REPAIRED SKIN IAW EA.SDR SWAA2015070641304Skin · crackedRIGHT UPPER WING SKIN AT AFT UPPER CHORD CRACKED AT RSS 254. REPAIRED SKIN IAW EA.SDR SWAA2015062341102Skin · crackedRIGHT UPPER WING SKIN AT AFT UPPER CHORD CRACKED AT RSS 200. REPAIRED CHORD IAW EA.SDR SWAA2015062341106Spar · crackedRIGHT WING REAR SPAR WEB CRACKED THROUGH UPPER CHORD ATTACH FASTENER HOLE, RSS 220. REPAIRED CHORD IAW EA.SDR SWAA2015062341104Skin · crackedRIGHT UPPER WING SKIN AT AFT UPPER CHORD CRACKED AT RSS 253. REPAIRED SKIN IAW EA.SDR SWAA2015062341103Skin · crackedRIGHT UPPER WING SKIN AT AFT UPPER CHORD CRACKED AT RSS 222. REPAIRED SKIN IAW EA.SDR SWAA2015061840909Spar · crackedLEFT WING REAR SPAR WEB FASTENER HOLE CRACKED AT RSS 212. REMOVED WEB ASSEMBLY IAW SRM.SDR SWAA2015061840904Fitting · crackedLEFT WING REAR SPAR WEB FOUND FASTENER HOLE FITTING CRACKED AT RSS 220. REPAIRED FITTING IAW SRM & DWG.SDR SWAA2015051939825Frame · crackedFRAME CRACKED AT BS 348.2, STRINGER 16L. REPAIRED FRAME IAW EA.SDR SWAA2015051239581Floor Support · crackedLONGITUDINAL FLOORBEAM LOWER CHORD CRACKED BETWEEN BS 660 - 666, LBL 24.5. REPAIRED CHORD IAW SRM.SDR SWAA2015050139213Slide · out of adjustR2 DOOR EMER EVAC SLIDE OUT OF ADJUSTMENT. ADJUSTED SLIDE IAW MT.SDR SWAA2015070141293Bear Strap · corrodedFORWARD CARGO DOOR SURROUND BEAR STRAP SKIN CORRODED AT BS 493, BETWEEN STRINGER 27R - 28R. REPAIRED SKIN IAW EA.SDR SWAA2015062241009Spar · crackedRIGHT WING REAR SPAR UPPER CHORD CRACKED ABOVE FITTING AT RSS 218. REPAIRED CHORD IAW EA.SDR SWAA2015060140239Floorbeam · corrodedCABIN FLOORBEAM CORRODED AT STATION 985.5, LBL 51. REPAIRED BEAM IAW EA.SDR SWAA2015060140238Floorbeam · corrodedCABIN FLOORBEAM CORRODED AT STATION 985.5, RBL 15 - 35. REPAIRED BEAM IAW EA.SDR SWAA2015052940213Stringer · crackedSTRINGER 5L CRACKED AT STATION 1016. REPAIRED STRINGER IAW EA.SDR SWAA2015052840143Crease Beam · corrodedAFT R2 DOOR WET CREASE BEAM CORRODED BETWEEN BS 947 - 986, RBL 40, STRINGER 17. R & R BEAM IAW DWG & SRM.SDR SWAA2015052239939Skin · crackedR1 DOOR EXTERNAL SKIN CRACKED AT LOWER HINGE ARM CUT OUT LOWER AFT CORNER DRAIN HOLE. REPAIRED SKIN IAW EA.SDR SWAA2015051939823Skin · crackedSKIN CRACKED AT BS 303.9, BETWEEN STRINGER 10L - 11L. R & R SKIN IAW SRM & DWG.SDR SWAA2015051339631Crease Beam · corrodedFORWARD ENTRY DOOR WAY FLOOR ATTACH CREASE BEAM CORRODED BETWEEN BS 303 - 348. R & R CREASE BEAM IAW DWG & SRM.SDR SWAA2015051139534Bracket · crackedL1 DOOR ESCAPE SLIDE GIRT BAR FLOOR FITTING CRACKED UNDER FLOOR SUPPORT. R & R BRACKET IAW AMM.SDR SWAA2015050739406Attach Angle · corrodedL1 DOOR THRESHOLD ATTACH ANGLE CORRODED BETWEEN BS 312 - 344, STRINGER 17L. R & R ANGLE IAW SRM.SDR SWAA2015043039184Slide · unsecureR1 DOOR EMER EVAC SLIDE FELL OUT OF CONTAINER, DID NOT DEPLOY. R & R SLIDE IAW MT.SDR SWAA2015043039174Lens · looseRIGHT OVERWING EMER EXIT LIGHT PANEL LENS LOOSE. SECURED LENS IAW AMM.SDR SWAA2015043039172Light · inoperativeLEFT FWD EXTERIOR EMER EXIT LIGHT INOPERATIVE. R & R LIGHT IAW AMM.SDR SWAA2015051839754Frame · crackedLEFT FRAME OTBD CHORD FWD FLANGE CRACKED AT BS 727, STRINGER 18A LOWER TWO FASTENER HOLES. REPAIRED FLANGE IAW ER & EA.SDR SWAA2015051539711Crease Beam · crackedMAIN CABIN CREASE BEAM WEB CRACKED BETWEEN BS 616 - 639, INBD AFT FASTENER HOLE AT LT SIDE. R & R CREASE BEAM IAW SRM & DWG.SDR SWAA2015050639339Crease Beam · corrodedCREASE BEAM WEB CORRODED BETWEEN BS 360 TO 380, STRINGER 17R. R & R WEB IAW SRM.SDR SWAA2015043039173Lens · missingOVERWING EXIT SIGN LENS MISSING. REINSTALLED LENS IAW SIP.SDR SWAA2015043039170Skin · crackedRIGHT HORIZONTAL STABILIZER LOWER SKIN CRACKED AT STAB STATION 150 AT AFT SPAR. REPAIRED SKIN IAW SRM.SDR SWAA2015043039169Attach Bracket · crackedR2 DOOR EMER EVAC SLIDE AFT ATTACH BRACKET CRACKED. R & R BRACKET IAW AMM.SDR SWAA2015061040532Aileron · delaminatedLEFT WING AILERON DELAMINATED AT FWD LOWER CORNER. REPAIRED AILERON IAW EA.SDR SWAA2015061040519Support Fitting · crackedRIGHT WING REAR SPAR SUPPORT FITTING CRACKED, STATION 215 - 225. REPAIRED FITTING IAW EA.SDR SWAA2015060440365Tab · delaminatedLEFT ELEVATOR TAB DELAMINATED AT HINGE CUT OUTS. REPAIRED TAB IAW SRM.SDR SWAA2015060340334Beam · crackedSTUB BEAM CRACKED AT STATION 616, STRINGER 17L. REPAIRED BEAM IAW EA.SDR SWAA2015052139906Crease Beam · crackedLEFT CREASE BEAM INBD INNER CHORD HORIZONTAL FLANGE CRACKED AT BS 639. REPAIRED FLANGE IAW EA.SDR SWAA2015051139533Frame · crackedRIGHT FRAME INNER CHORD CRACKED AT BS 616, LOWER FASTENER. REPAIRED CHORD IAW EA.SDR SWAA2015061240617Bulkhead Web · crackedFOUND THE BS 178 BULKHEAD WEB CRACKED AT RBL 17, WL 192. REPAIRED THE BULKHEAD WEB IAW EA.SDR SWAA2015061240616Bulkhead Web · crackedFOUND THE BS 178 BULKHEAD WEB CRACKED AT RBL 17, WL 183. REPAIRED THE BULKHEAD WEB IAW EA.SDR SWAA2015060340353Light · inoperativeL2 DOOR EMER EXIT LIGHT INOPERATIVE. RELAMPED IAW MM.
Back to Boeing 737-3H4