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 SWAA2015032337717Beam · crackedLONGITUDINAL BEAM LOWER CHORD VERTICAL FLANGE CRACKED AT BS 640, LBL 45.5. REPAIRED FLANGE IAW ER & EA.SDR SWAA2015032337716Attach Angle · corrodedFRAME LOWER WEB ATTACH ANGLE CORRODED AT BS 993, WL 208. REPAIRED ANGLE IAW DWG & SRM.SDR SWAA2015032337726Skin · crackedR1 DOOR FUSELAGE SKIN CUT OUT CRACKED AT BS 327, STRINGER 17R. REPAIRED SKIN IAW SRM.SDR SWAA2015031637464Frame · crackedLEFT FRAME OTBD CHORD LOWER FWD CRACKED AT BS 727. R & R CHORD IAW EA.SDR SWAA2015021236564Lens · missingRIGHT OVERWING LOWER EMER EXIT SIGN LIGHT LENS MISSING. INSTALLED LENS IAW AMM.SDR SWAA2015022036757Support Fitting · corrodedLEFT WING NR 1 FLAP TRACK AFT OTBD BOLT HOLE SUPPORT FITTING CORRODED. R & R FITTING IAW DWG & SRM.SDR SWAA2015021136538Bracket · crackedFORWARD STABILIZER DRUM HOUSING, AFT SUPPORT LINK A FRAME, UPPER LT ATTACH POINT, OTBD BRACKET CRACKED. R & R BRACKET IAW EA.SDR SWAA2015021136537Cover · unsecureFORWARD CABIN EMER EXIT SIGN COVER FELL OFF. R & R SIGN IAW MM.SDR SWAA2015032537777Frame · corrodedFRAME WEB CORRODED AT BS 993, STRINGER 17R. REPAIRED FRAME IAW ER & EA.SDR SWAA2015022436859Intercostal · crackedINTERCOSTAL WEB CRACKED AT BS 727, LBL 36.5. R & R WEB IAW SRM & DWG.SDR SWAA2015022336810Crease Beam · corrodedRIGHT CREASE BEAM WEB CORRODED BETWEEN BS 727 - 747 ON UPPER SURFACE. REPAIRED WEB IAW SRM.SDR SWAA2015021936717Door Sill · corrodedR1 DOOR CUT OUT SURFACE LOWER SILL WEB CORRODED AT FWD DRAIN HOLE. REPAIRED WEB IAW SRM.SDR SWAA2015021836706Crease Beam · corrodedRIGHT CREASE BEAM WEB CORRODED BETWEEN BS 807 TO 787+6, ON UPPER SURFACE. REPAIRED WEB IAW SRM.SDR SWAA2015021136535Slide · looseL2 DOOR EMER EVAC SLIDE GIRT LOOSE. SECURED SLIDE IAW MT & AMM.SDR SWAA2015021036504Cover · looseL1 DOOR EMER EXIT LIGHT COVER LOOSE. R & R LIGHT ASSEMBLY IAW MM.SDR SWAA0100020136503Cover · brokenL1 DOOR EMER EXIT LIGHT COVER BROKEN. R & R COVER IAW SIP.SDR SWAA2015033037961Web · crackedLONGITUDINAL BEAM WEB CRACKED BETWEEN BS 639 - 645, LBL 45.50. REPAIRED WEB IAW SRM.SDR SWAA2015031637440Skin · crackedAFT CARGO DOOR CUT OUT FWD LOWER CORNER SKIN CRACKED. REPAIRED CUT OUT IAW EA.SDR SWAA2015030437104Intercostal · crackedINTERCOSTAL ANGLE CRACKED BETWEEN BS 294 TO 303, STRINGER 16L. R & R INTERCOSTAL IAW SRM & DWG.SDR SWAA2015030237010Fairing · delaminatedRIGHT WING NR 7 CTR FLAP TRACK FAIRING DELAMINATED FWD INBD CORNER AT PIVOT POINT. REPAIRED FAIRING IAW SRM.SDR SWAA2015041338402Support Fitting · crackedRIGHT WING REAR SPAR AT MLG AFT SUPPORT FITTING REAR SPAR CHORD CRACKED. REPAIRED CHORD IAW EA.SDR SWAA2015041338385Spar · crackedRIGHT WING REAR SPAR AT MAIN LG AFT SUPPORT FITTING REAR SPAR WEB CRACKED AT INBD FASTENER HOLE. REMOVED WEB IAW SRM.SDR SWAA2015033138008Frame · crackedFRAME OTBD CHORD CRACKED AT BS 727, STRINGER 18A LT. R & R CHORD IAW EA.SDR SWAA2015032637861Fitting · crackedRIGHT WING REAR SPAR STATION 236 CLIP COMMON TO SPAR, OTBD OF REAR SPAR WEB CRACKED. R & R CLIP IAW DWG.SDR SWAA2015032337725Seat Track · crackedSEAT TRACK WEB CRACKED BETWEEN BS 986 - 1016, RBL 35. REPAIRED WEB IAW SRM.SDR SWAA2015040138054Frame · crackedFRAME OTBD CHORD, FWD FLANGE CRACKED AT LOWER FWD HOLE BS 727, STRINGER 18 A LT. R & R CHORD IAW EA & ER.SDR SWAA2015040138053Frame · crackedFRAME OTBD CHORD, FWD FLANGE CRACKED AT LOWER FORWARD HOLE BS 727, STRINGER 18-A RT. REMOVED & REPLACED CHORD IAW EA & ER.SDR SWAA2015032737919Rib · crackedRIGHT WING RIB LOWER CHORD CRACKED AT WBL 135.5, BETWEEN STRINGER 2 & 3. REPAIRED RIB IAW EA.SDR SWAA2015031637457Frame · crackedBULKHEAD FRAME WEB CRACKED AT BS 180, LBL 17.0. REPAIRED WEB IAW EA.SDR SWAA2015031637456Shear Tie · corrodedSHEAR TIE CORRODED AT BS 847, BETWEEN STRINGER 27R TO 27L. REPAIRED SHEAR TIE IAW EA.SDR SWAA2015030437103Shear Tie · corrodedFORWARD CARGO BAY SHEAR TIE CORRODED AT BS 500A, BETWEEN STRINGER 28R TO 28L. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2015030437102Shear Tie · corrodedFORWARD CARGO BAY SHEAR TIE CORRODED AT BS 500B, BETWEEN STRINGER 28R TO 28L. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2015030437101Shear Tie · corrodedFORWARD CARGO BAY SHEAR TIE CORRODED AT BS 500C, BETWEEN STRINGER 28R TO 28L. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2015022336839Skin · crackedRIGHT AFT CARGO BAY DOOR SUPPORT UPPER AFT CORNER SKIN CRACKED. REPAIRED DOOR IAW SRM.SDR SWAA2015021836705Support Fitting · corrodedRIGHT WING NR 8 FLAP TRACK SUPPORT FITTING OUTER BOLT HOLE CORRODED AT RSS 434.742, WBL 355. REPAIRED FITTING IAW SRM.SDR SWAA2015021036451Fuse · blownRIGHT OVERHEAD EMER LIGHTS INOPERATIVE BETWEEN ROW 1 - 5. R & R FUSE IAW MM.SDR SWAA2015021036449Fuse · blownLEFT OVERHEAD EMER LIGHTS INOPERATIVE BETWEEN ROW 14 - 18. R & R FUSE IAW MM.SDR SWAA2015020636393Bracket · crackedRIGHT WING AILERON CLOSEOUT BAY BRACKET CRACKED AT REAR SPAR STATION 545. R & R BRACKET IAW SRM.SDR SWAA2015020636392Flap · delaminatedLEFT WING OTBD AFT FLAP DELAMINATED AT OTBD END. R & R AFT FLAP IAW AMM.SDR SWAA2015020636391Support Bracket · crackedRIGHT WING NR 6 FLAP TRACK FAIRING, UPPER FIXED TE PANEL SUPPORT BRACKET, CRACKED ON OTBD SIDE. R & R BRACKET IAW SRM.SDR SWAA2015020636382Lens · brokenFORWARD ENTRY DOOR LOWER EMER EXIT LIGHT LENS COVER BROKEN. R & R LIGHT ASSEMBLY IAW MM.SDR SWAA2015033138007Spar · crackedLEFT WING REAR SPAR UPPER CHORD CRACKED AT INBD SIDE OF MLG AFT SUPPORT FITTING. REPAIRED CHORD IAW ER & EA.SDR SWAA2015033138006Spar · crackedRIGHT WING REAR SPAR UPPER CHORD CRACKED AT INBD SIDE OF MLG AFT SUPPORT FITTING. REPAIRED CHORD IAW ER & EA.SDR SWAA2015032537776Frame · crackedBS 294 STUB FRAME CRACKED AT BS 294, RBL 55. REPAIRED STUB FRAME IAW ER & EA.SDR SWAA2015032337724Crease Beam · corrodedCREASE BEAM WEB CORRODED BETWEEN BS 767 - 787, STRINGER 17L. REPAIRED BEAM IAW SRM.SDR SWAA2015031937598Skin · crackedSKIN CRACKED BETWEEN BS 868.5 - 874.25, STRINGER 1. REPAIRED SKIN IAW EA.SDR SWAA2015031637455Floorbeam · crackedFLOORBEAM CRACKED AT BS 947, LBL 55. REPAIRED BEAM IAW ER & EA.SDR SWAA2015031637454Floor Support · crackedLONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 727B, RBL 25. REPAIRED CHORD IAW EA.SDR SWAA2015031037289Skin · crackedSKIN CRACKED BETWEEN BS 500B+14 TO 500B+15, STRINGER 15R. REPAIRED SKIN IAW EA.SDR SWAA2015030937202Skin · crackedSKIN CRACKED BETWEEN BS 385 TO 386, STRINGER 15R. REPAIRED SKIN IAW EA.
Back to Boeing 737-3H4