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 SWAA2016032450177Slide · looseL1 DOOR SLIDE OUT OF ADJUSTMENT. REPOSITIONED SLIDE IAW MM.SDR SWAA2016042551263Intercostal · crackedINTERCOSTAL OUTER CHORD CRACKED AT BS 291.5, BETWEEN STRINGER 9R - 10R. REPAIRED CHORD IAW EA.SDR SWAA2016041550938Intercostal · crackedINTERCOSTAL OUTER CHORD CRACKED AT BS 291.5, BETWEEN STRINGER 11R - 12R. R & R CHORD IAW EA.SDR SWAA2016041450921Intercostal · crackedINTERCOSTAL OUTER CHORD CRACKED AT BS 291.5, BETWEEN STRINGER 12R - 13R. R & R CHORD IAW EA.SDR SWAA2016032850307Cover · looseL1 DOOR EXIT SIGN COVER LOOSE. SECURED COVER IAW AMM.SDR SWAA2016032850264Lens · looseLEFT BIN EMER EXIT LIGHT LENS LOOSE AT ROW 18. SECURED LENS IAW AMM.SDR SWAA2016032850263Light · inoperativeR2 DOOR EMER EXIT LIGHT BULB INOPERATIVE. RELAMPED LIGHT IAW AMM.SDR SWAA2016032850262Slide · out of adjustR2 DOOR EMER ESCAPE SLIDE OUT OF ADJUSTMENT. ADJUSTED SLIDE IAW SRM.SDR SWAA2016032450176Lens · looseRIGHT OVERWING EXIT LIGHT LENS LOOSE. R & R EXIT LIGHT ASSEMBLY IAW MM.SDR SWAA2016042851405Link · corrodedRIGHT MLG SUPPORT BEAM INBD SWING LINK CORRODED. R & R SWING LINK ASSEMBLY IAW EA.SDR SWAA2016042851404Link · corrodedLEFT MLG SUPPORT BEAM INBD SWING LINKS CORRODED. R & R SWING LINK ASSEMBLY IAW EA.SDR SWAA2016042651353Spar · crackedRIGHT WING REAR SPAR UPPER CHORD CRACKED AT RSS 285, BETWEEN HOLE 4, 5 & 12. REPAIRED CHORD IAW EA.SDR SWAA2016042651352Spar · crackedRIGHT WING REAR SPAR WEB CRACKED, BETWEEN RSS 211 - 238, BETWEEN HOLE NR 4, 5, 7, 8 & 12. REPAIRED WEB IAW EA.SDR SWAA2016042551323Spar · crackedLEFT WING REAR SPAR WEB CRACKED, BETWEEN RSS 220 - 223. REPAIRED WEB IAW EA.SDR SWAA2016042551277Spar · crackedLEFT WING REAR SPAR UPPER CHORD CRACKED, BETWEEN RSS 220 - 285. REPAIRED CHORD IAW EA.SDR SWAA2016042251234Support Fitting · crackedRIGHT WING NR 5 HOLE MLG AFT SUPPORT FITTING CRACKED. REPAIRED FITTING IAW ER & EA.SDR SWAA2016042251233Support Fitting · crackedLEFT WING CRACKED, FOUND IN THE AFT SUPPORT FITTING AT NR 5 HOLE, RSS 222. REPAIRED FITTING IAW EA.SDR SWAA2016041450919Beam · crackedLEFT HORIZONTAL STABILIZER LOWER TE STRUCTURE, CRACKED ON THE UPPER SURFACE, 12" OTBD OF ELEVATOR STATION 176.64. REPAIRED BEAM IAW EA.SDR SWAA2016032850309Actuator · faultyAFTER LG & FLAPS RAISED, RT RED GEAR LIGHT REMAINED ILLUMINATED. CYCLED UP & BACK TO OFF AGAIN, THEN BOTH LIGHTS EXTINGUISHED. R & R RT MLG RETRACT ACTUATOR IAW AMM.SDR SWAA2016032350153Slide · out of adjustR2 DOOR SLIDE OUT OF ADJUSTMENT. ADJUSTED R2 DOOR SLIDE IAW MM.SDR SWAA2016032250108Light · inoperativeRIGHT FWD DOOR EXTERIOR EMER LIGHT INOPERATIVE. RELAMPED LIGHT IAW AMM.SDR SWAA2016032250135Controller · failedAIR TURN BACK & DECLARED EMER. DURING CLIMB OUT, BETWEEN FL 290 - 300, CABIN ALTITUDE WARNING LIGHT ILLUMINATED. CABIN ALTITUDE INDICATOR SHOWED APPROX 11000 FT.SDR SWAA2016040150777Skin · crackedRIGHT WING UPPER SKIN CRACKED HOLES, BETWEEN RSS 250 - 265.5. REPAIRED SKIN IAW ER & EA.SDR SWAA2016041150766Skin · crackedRIGHT WING UPPER SKIN CRACKED HOLE, AT RSS 270 AT 11 O'CLOCK POSITION, LOCATED ON AFT ROW REAR SPAR UPPER CHORD. REPAIRED SKIN IAW ER & EA.SDR SWAA2016040750674Skin · crackedLEFT WING UPPER SKIN CRACKED ABOVE RSS 268 AFT ROW. REPAIRED SKIN IAW ER & EA.SDR SWAA2016040750673Skin · crackedLEFT WING UPPER SKIN CRACKED ABOVE RSS 221, 2ND ROW FWD FROM AFT EDGE. REPAIRED SKIN IAW ER & EA.SDR SWAA2016040650648Spar · crackedRIGHT WING REAR SPAR WEB CRACKED AT RSS 186 UPPER ROW. REPAIRED WEB IAW ER & EA.SDR SWAA2016032250111Lens · brokenRIGHT EMER EXIT OVERWING EXIT LIGHT LENS BROKEN. R & R LENS IAW AMM.SDR SWAA2016042551313Skin · crackedRIGHT WING IN SPAR UPPER SKIN TE CRACKED AT RSS 230 & 6 O'CLOCK ORIENTATION. REPAIRED SKIN IAW EA.SDR SWAA2016042551312Skin · crackedRIGHT WING IN SPAR UPPER SKIN TE CRACKED AT RSS 237 & 12 O'CLOCK ORIENTATION. REPAIRED SKIN IAW EA.SDR SWAA2016042551311Skin · crackedRIGHT WING IN SPAR UPPER SKIN TE CRACKED AT RSS 248.5" & 12 O'CLOCK ORIENTATION. REPAIRED SKIN IAW EA.SDR SWAA2016042551310Skin · crackedRIGHT WING IN SPAR UPPER SKIN CRACKED AT RSS 249 & 6 0'CLOCK ORIENTATION. REPAIRED SKIN IAW EA.SDR SWAA2016042551309Skin · crackedRIGHT WING SKIN CRACKED IN FASTENER HOLE REAR SPAR AFT ROW ON EXTERNAL SKIN, LOCATED RSS 254 & 12 O'CLOCK. REPAIRED SKIN IAW EA.SDR SWAA2016042551308Skin · crackedLEFT WING SKIN CRACKED IN FASTENER HOLE REAR SPAR AFT ROW ON EXTERNAL, LOCATED AT RSS 251 & 6 O'CLOCK. REPAIRED SKIN IAW EA.SDR SWAA2016042551307Skin · crackedLEFT WING SKIN CRACKED IN FASTENER HOLE, REAR SPAR AFT ROW ON EXTERNAL, LOCATED AT RSS 249.5" & 6 O'CLOCK. REPAIRED SKIN IAW EA.SDR SWAA2016042151181Spar · crackedLEFT WING REAR SPAR WEB AT RSS 158 CRACKED. REPAIRED WEB IAW EA.SDR SWAA2016041450913Fitting · crackedRIGHT WING FWD MLG FITTING CRACKED IN HOLE, FWD HOLE COMMON TO LOWER SPAR CHORD RSS 221. REPAIRED FITTING IAW ER & EA.SDR SWAA2016040450592Plate · crackedRIGHT WING SUPPORT PLATE CRACKED ON RSS 237. R & R PLATE IAW SRM & DWG.SDR SWAA2016040450591Plate · crackedLEFT WING SUPPORT PLATE CRACKED ON RSS 237. R & R PLATE IAW SRM & DWG.SDR SWAA2016032150076Battery Pack · dischargedLEFT EMER EXIT LIGHTS DIM. R & R BATTERY PACK IAW MM.SDR SWAA2016032150056Strap · brokenAFT EMER FLASHLIGHT STRAP BROKEN. R & R STRAP IAW MM.SDR SWAA2016032150055Battery Pack · dischargedRIGHT EMER EXIT LIGHTS DIM. R & R BATTERY PACK IAW MM.SDR SWAA2016032150033Sensor · faultyAIR TURN BACK, ON DEPARTURE WITH THE GEAR HANDLE IN THE UP POSITION, THE LT GEAR RED LIGHT REMAINED ILLUMINATED, NO OTHER INDICATIONS. GEAR HANDLE IN DOWN POSITION, THREE GREEN LIGHTS, NO RED LIGHTS. R & R LT UPLOCK MLG & SAFETY SENSOR IAW MM.SDR SWAA2016042551306Skin · crackedLEFT WING SKIN TE CRACKED IN FASTENER HOLE REAR SPAR AFT ROW ON EXTERNAL SKIN LOCATED AT RSS 239.25 & 5 O'CLOCK. REPAIRED SKIN IAW EA.SDR SWAA2016040450590Angle · crackedLEFT WING INBD FLAP, OTBD TRACK 3, FAIRING INTERNAL STRUCTURE OF ACCESS PANEL 5736 ANGLE CRACKED. R & R ANGLE IAW SRM & DWG.SDR SWAA2016040450588Angle · crackedLEFT WING INBD FLAP, OTBD TRACK NR 3 FAIRING INTERNAL STRUCTURE OF ACCESS PANEL 5735 ANGLE CRACKED. R & R ANGLE IAW SRM & DWG.SDR SWAA2016040150531Bracket · crackedRIGHT WING NR 6 FAIRING INBD FLAP OTBD TRACK, FWD OTBD BRACKET CRACKED. R & R BRACKET IAW SRM & DWG.SDR SWAA2016032150097Sign · missingFORWARD ENTRY DOOR EXIT SIGN MISSING. INSTALLED SIGN IAW AMM.SDR SWAA2016042151180Shear Tie · corrodedSHEAR TIE CORRODED AT BS 344 RT SIDE OF E & E DOOR CUT OUT. R & R SHEAR TIE IAW SRM & DWG.SDR SWAA2016032150078Skin · damagedFUSELAGE SKIN CREASED AT BS 827, BETWEEN STRINGER 27L - 27R. REPAIRED SKIN IAW SRM.
Back to Boeing 737-3H4