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 SWAA2015092844325Shear Tie · corrodedSHEAR TIE CORRODED AT BS 787, STRINGER 27L. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2015092844324Stringer · corrodedSTRINGER CORRODED AT BS 987, STRINGER 25L. REMOVED & REPAIRED STRINGER IAW SRM.SDR SWAA2015092244162Shear Tie · corrodedFRAME SHEAR TIE, CORRODED AT BS 1006, BETWEEN STRINGER 27L - 27R. R & R SHEAR TIE IAW SRM.SDR SWAA2015092244161Shear Tie · corrodedFRAME SHEAR TIE, CORRODED AT BS 747, STRINGER 27L. R & R SHEAR TIE IAW SRM.SDR SWAA2015091743985Stringer · corrodedSTRINGER CORRODED BETWEEN BS 898 - 902, STRINGER 21R. REPAIRED STRINGER IAW SRM.SDR SWAA2015090943531Crease Beam · corrodedLEFT INBD CREASE BEAM CHORD CORRODED, BETWEEN BS 950 TO 994, LBL 65. R & R CHORD IAW SRM & DWG.SDR SWAA2015081942969Skin · crackedLEFT WING TE UPPER SKIN CRACKED AT STATION 254.97 FROM FASTENER TO EDGE OF SKIN. REPAIRED SKIN IAW EA.SDR SWAA2015081342809Lens · missingRIGHT OVERWING EMER EXIT HATCH SIGN LENS MISSING. REINSTALLED LENS IAW AMM.SDR SWAA2015081142732Cover · looseRIGHT OVERWING EMER EXIT LIGHT COVER LOOSE AT ROW 12. SECURED COVER IAW SIP.SDR SWAA2015081142687Flashlight · inoperativeFORWARD GALLEY OTBD EMER FLASHLIGHT INOPERATIVE. R & R FLASHLIGHT ASSEMBLY IAW AMM.SDR SWAA2015100144419Frame · corrodedFRAME LOWER FLANGE CORRODED AT BS 1006, BETWEEN STRINGER 22R - 23R. REPAIRED FLANGE IAW EA & DWG.SDR SWAA2015092944395Stiffener · corrodedAFT PRESS BULKHEAD CHANNEL STIFFENER CORRODED AT BS 1016, BETWEEN STRINGER 27L - 27R. REPAIRED STIFFENER IAW EA.SDR SWAA2015092944394Bulkhead · corrodedAFT PRESS BULKHEAD WEB CORRODED AT BS 1016, BETWEEN STRINGER 26L - 26R. REPAIRED WEB IAW EA.SDR SWAA2015092344208Skin · crackedSKIN CRACKED AT BS 834, STRINGER 1L. REPAIRED SKIN IAW EA.SDR SWAA2015091443770Beam · corrodedLEFT MLG BEAM THAT ATTACH SUPPORT FITTING ASSEMBLY CORRODED. REPAIRED FLANGE IAW EO & EA.SDR SWAA2015091443757Spar · corrodedLEFT WING UPPER REAR SPAR CHORD CRACKED AT APPROX RSS 217. REPAIRED CHORD IAW EA & ER.SDR SWAA2015091043645Crease Beam · corrodedRIGHT CREASE BEAM WEB CORRODED BETWEEN BS 440 - 460. R & R WEB IAW SRM & DWG.SDR SWAA2015083143360Crease Beam · corrodedCREASE BEAM WEB CORRODED BETWEEN BS 807 - 827 LT. R & R WEB IAW SRM & DWG.SDR SWAA2015081742867Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 500A, STRINGER 16R. R & R CLIP IAW SRM.SDR SWAA2015081242762Skin · crackedFUSELAGE CROWN SKIN CRACKED AT BS 500B+3, STRINGER 1L. REPAIRED SKIN IAW SRM.SDR SWAA2015081242761Skin · crackedFUSELAGE CROWN SKIN CRACKED AT BS 500C+3, STRINGER 2R. REPAIRED SKIN IAW SRM.SDR SWAA2015081142733Flap Track · crackedRIGHT WING NR 5 FLAP TRACK CRACKED AT FWD INBD BOLT HOLE. R & R NR 5 FLAP TRACK IAW AMM.SDR SWAA2015081142726Controller · faultyDECLARED EMER CABIN ALTITUDE WARNING HORN SOUNDED AT ALTITUDE. EMER DESCENT ACCOMPLISHED. CABIN ALTITUDE WENT UP ABOVE 10000 FT. PAX OXYGEN MASKS DID NOT DEPLOY. A PORTION OF CRUISE WAS FLOWN IN FREEZING MOISTURE. R & R NR 2 CABIN PRESS CONTROLLER IAW MM.SDR SWAA2015081142686Battery Pack · dischargedAFT RT EMER LIGHTS INOPERATIVE IN CABIN AISLE AT LOCATION M1672. R & R BATTERY PACK IAW MM.SDR SWAA2015102245243Fairing · crackedLEFT WING AFT UPPER SURFACE, FIXED PYLON FAIRING, CRACKED ON INBD AFT EDGE IN CUT OUT. REPAIRED FAIRING IAW EA.SDR SWAA2015091643948Doubler · crackedSTUB BEAM DOUBLER CRACKED AT BS 639, LBL 52. R & R DOUBLER IAW ER & EA.SDR SWAA2015091443756Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 500C+15.5 - 500C+16.6, STRINGER 2R. REPAIRED SKIN IAW SRM.SDR SWAA2015091443751Skin · crackedSKIN CRACKED, BETWEEN BS 810 - 811.4, STRINGER 2R. REPAIRED SKIN IAW SRM.SDR SWAA2015090143416Skin · crackedFORWARD GALLEY DOOR CUT OUT CRACKED AT LOWER AFT RADIUS 1" FWD OF SCUFF PLATE EDGE. REPAIRED CUT OUT IAW SRM.SDR SWAA2015090143399Angle · crackedLEFT WING TE AILERON BALANCE BAY VERTICAL SUPPORT CRACKED AT RSS 545. R & R ANGLE IAW SRM.SDR SWAA2015081842923Door Frame · crackedC1 DOOR CUT OUT IN FUSELAGE FRAME CRACKED AT BS 492, IN FRAME WEB AT INBD TOP CORNER OF NR 5 DOOR STOP MOUNT AREA. R & R FRAME IAW ACO & DWG.SDR SWAA2015081442849Skin · delaminatedLEFT WING AFT OTBD TE FLAP SKIN DELAMINATED OTBD LOWER SURFACE. REPAIRED FLAP SKIN IAW SRM.SDR SWAA2015081142676Sign · unsecureL1 DOOR OVERHEAD EXIT SIGN LIGHT ASSEMBLY FELL OFF. R & R LIGHT ASSEMBLY IAW AMM.SDR SWAA2015101644981Skin · crackedCROWN SKIN CRACKED AT BS 520+3, STRINGER 2L. REPAIRED SKIN IAW EA.SDR SWAA2015101644980Skin · crackedSKIN CRACKED AT BS 500D+15, STRINGER 5R. REPAIRED SKIN IAW EA.SDR SWAA2015100144448Skin · crackedSKIN CRACKED AT BS 500C+5, STRINGER 7R. REPAIRED SKIN IAW EA.SDR SWAA2015100144447Skin · crackedSKIN CRACKED AT BS 480+3, STRINGER 2L. REPAIRED SKIN IAW SRM.SDR SWAA2015100144446Skin · crackedSKIN CRACKED AT BS 360+2.5, STRINGER 1R. REPAIRED SKIN IAW SRM.SDR SWAA2015100144445Skin · crackedSKIN CRACKED AT BS 807-4, STRINGER 2R. REPAIRED SKIN IAW SRM.SDR SWAA2015100144403Skin · crackedCROWN SKIN CRACKED AT BS 540-14, STRINGER 2R. REPAIRED SKIN IAW SRM.SDR SWAA2015100144402Skin · crackedCROWN SKIN CRACKED AT BS 480+2, STRINGER 2R. REPAIRED SKIN IAW SRM.SDR SWAA2015091443742Light · inoperativeLEFT AFT TWO OVERHEAD BIN LIGHTS INOPERATIVE AT ROW 23. R & R LIGHT IAW AMM.SDR SWAA2015091443719Light · inoperativeR2 DOOR LIGHT INOPERATIVE AT ROW 23. R & R LIGHT IAW AMM.SDR SWAA2015081842929Stringer Splice · crackedSTRINGER SPLICE CRACKED AT BS 360, STRINGER 4L. R & R SPLICE IAW SAM.SDR SWAA2015081542884Slat · delaminatedLEFT WING NR 3 SLAT DELAMINATED INBD AFT WEDGE. REPAIRED NR 3 SLAT IAW SRM.SDR SWAA2015081742865Skin · crackedSKIN CRACKED AT BS 360, BETWEEN STRINGER 5R - 6R. REPAIRED SKIN IAW EA.SDR SWAA2015081142645Flap · delaminatedRIGHT WING INBD AFT FLAP DELAMINATED OTBD AFT CORNER. REPAIRED AFT FLAP IAW SRM.SDR SWAA2015081142631Actuator · faultyUPON RAISING GEAR HANDLE, LT GEAR, RED LIGHT & LT GEAR GREEN LIGHT REMAINED ILLUMINATED. THREE GREEN LIGHTS, NO RED WITH HANDLE DOWN, NORMAL LANDING. R & R LT MLG RETRACT ACTUATOR IAW MM.SDR SWAA2015080742625Light · inoperativeGALLEY 1 EXIT SIGN BULB INOPERATIVE. R & R BULB IAW AMM.SDR SWAA2015080742623Door Frame · crackedR1 DOOR AFT FRAME TORQUE BOX CUT OUT AREA AFT LOWER CORNER FRAME CRACKED. R & R R1 DOOR IAW AMM.
Back to Boeing 737-3H4