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 SWAA2016011347970Spar · crackedRIGHT WING REAR SPAR, GROUP 12 HOLES, NR 5 CRACKED IN WEB AT 6 & 12 O'CLOCK POSITION. R & R WEB IAW EA.SDR SWAA2015121146997Frame · corrodedSHEAR TIE CORRODED AT BS 787, BETWEEN STRINGER 25 - 26R. R & R FRAME ASSEMBLY IAW SRM.SDR SWAA2015120946912Floorbeam · corrodedFLOORBEAM CORRODED AT BS 986, RBL 45. REPAIRED FLOORBEAM IAW ER & EA.SDR SWAA2015120946911Shear Tie · corrodedSHEAR TIE CORRODED AT BS 947.5, BETWEEN STRINGER 25L - 26L. R & R SHEAR TIE IAW SRM & DWG.SDR SWAA2015120946902Fitting · crackedRIGHT MLG BEAM, FWD FITTING CRACKED AT FASTENER HOLE, SECOND ROW FROM INBD, THIRD FROM TOP. R & R FITTING IAW ER & EA.SDR SWAA2015120946901Skin · crackedRIGHT WING UPPER SKIN, CRACKED AT 4 FASTENER HOLES, AFT ROW COMMON TO NUTPLATE ATTACH STRIP, BETWEEN RSS 254 - 267.5. REPAIRED SKIN IAW ER & EA.SDR SWAA2015120746772Shear Tie · corrodedSHEAR TIE CORRODED AT BS 727E, BETWEEN STRINGER 26R - 27R. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2015120246628Angle · crackedANGLE CRACKED, BETWEEN BS 344 - 360, LBL 10. R & R ANGLE IAW SRM & DWG.SDR SWAA2015113046539Reveal · crackedFORWARD GALLEY AREA REVEAL CRACKED AT BS 344 AT AFT LOWER LT. R & R REVEAL IAW SRM.SDR SWAA2015113046496Shear Tie · corrodedSHEAR TIE CORRODED AT BS 887, BETWEEN STRINGER 19L - 20L. R & R SHEAR TIE IAW SRM & DWG.SDR SWAA2015112446404Intercostal · crackedAFT CARGO BAY INTERCOSTAL CRACKED, BETWEEN BS 927 - 947, STRINGER 25L. R & R INTERCOSTAL IAW SRM.SDR SWAA2015111846208Intercostal · crackedINTERCOSTAL CRACKED AT BS 277, STRINGER 14R. R & R INTERCOSTAL IAW SRM & DWG.SDR SWAA2015111646102Strap · crackedFORWARD GALLEY AREA STRAP CRACKED AT BS 328, RBL 44. R & R STRAP IAW SRM & DWG.SDR SWAA2015111646101Strap · crackedFORWARD GALLEY AREA STRAP CRACKED AT BS 328, LBL 44. R & R STRAP IAW SRM & DWG.SDR SWAA2015111646100Intercostal · crackedWEB INTERCOSTAL CRACKED, BETWEEN BS 344 - 360, BL 0. R & R INTERCOSTAL IAW SRM.SDR SWAA2015111646091Strap · crackedFORWARD GALLEY AREA STRAP CRACKED AT BS 328, RBL 31. R & R STRAP IAW SRM & DWG.SDR SWAA2015111145977Skin · delaminatedRIGHT WING NR 8 SPOILER DELAMINATED, UPPER SURFACE. R & R SPOILER IAW MM.SDR SWAA2015111145976Flap · delaminatedLEFT WING INBD AFT FLAP DELAMINATED ON LOWER FWD AREA. R & R AFT FLAP IAW AMM.SDR SWAA2015111145970Slide · out of positionL1 DOOR EMER EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW MT.SDR SWAA2015113046580Skin · delaminatedRIGHT WING NR 5 SLAT SKIN DELAMINATED, INBD EDGE. REPAIRED SKIN IAW SRM.SDR SWAA2015111246013Light · inoperativeAFT EXIT SIGN LIGHTS ON BOTTOM INOPERATIVE. R & R BULB IAW SIP.SDR SWAA2015120946915Angle · crackedLEFT WING ANGLE CRACKED ON TE AT WBL 183.40. R & R ANGLE IAW SRM & DWG.SDR SWAA2015120946914Skin · crackedRIGHT WING NR 5 SLAT SKIN, CRACKED ON LOWER INBD EDGE. REPAIRED SKIN IAW SRM.SDR SWAA2015113046498Skin · delaminatedRIGHT WING NR 5 SLAT UPPER SKIN DELAMINATED AT OTBD EDGE. REPAIRED SKIN IAW SRM.SDR SWAA2015110945869Light · inoperativeLEFT AFT EMER LIGHT INOPERATIVE. R & R LIGHT IAW AMM.SDR SWAA2015121147038Support Angle · crackedL1 DOOR SUPPORT ANGLE, CRACKED AFT LOWER EDGE STRUCTURE AT AFT GALLEY AREA. R & R ANGLE IAW SRM & DWG.SDR SWAA2015121147001Angle · crackedENTRY DOOR AFT UPPER EDGE, STRUCTURE ANGLE CRACKED AT FWD GALLEY AREA. R & R ANGLE IAW SRM & DWG.SDR SWAA2015121147000Door Frame · crackedAFT CARGO COMPARTMENT DOOR ASSEMBLY FRAME CRACKED ON LOWER EDGE. R & R DOOR ASSEMBLY IAW AMM.SDR SWAA2015120946900Spar · crackedLEFT WING REAR SPAR WEB CRACKED, COMMON TO LG SUPPORT BEAM, AFT SUPPORT FITTING RSS 225.54, UPPER ROW FASTENER 5. REPAIRED WEB IAW EA.SDR SWAA2015120446720Structure · crackedLEFT WING UPPER CHORD CRACKED AT RSS 291, VERTICAL FLANGE AFT SPAR. REPAIRED CHORD IAW EA.SDR SWAA2015113046578Spar · crackedLEFT WING SPAR LOWER CHORD CRACKED AT FASTENER HOLE AT RSS 227, HORIZONTAL FLANGE COMMON TO LOWER SKIN. REPAIRED CHORD IAW EA.SDR SWAA2015111045938Slide · out of positionR2 DOOR EMER ESCAPE SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW MT.SDR SWAA2015110945850Battery Pack · dischargedR2 DOOR EXTERIOR EMER EXIT LIGHT INOPERATIVE. R & R BATTERY PACK IAW AMM.SDR SWAA2015120946913Stiffener · crackedREAR SPAR VERTICAL STIFFENER, CRACKED AT MAIN WW AT BS 663.75, RBL 6.15. R & R STIFFENER IAW ACO.SDR SWAA2015120746766Bracket · crackedBRACKET CRACKED AT BS 727, LOWER FUSELAGE AT LOWER FUSELAGE LT SIDE. R & R BRACKET IAW SRM & DWG.SDR SWAA2015120746765Skin · crackedTAIL CONE EXTERNAL SKIN DELAMINATED AT BS 1156, BL 0. REPAIRED SKIN IAW SRM.SDR SWAA2015120746763Skin Panel · crackedRIGHT WING UPPER SKIN PANEL, CRACKED IN MOST REAR OPENED FASTENER HOLE AT TE OF SKIN PANEL RSS 252. REPAIRED SKIN IAW EA.SDR SWAA2015120746762Skin Panel · crackedRIGHT WING UPPER SKIN PANEL, CRACKED AT REAR OPENED FASTENER HOLE AT TE OF SKIN PANEL, RSS 213. REPAIRED SKIN IAW EA.SDR SWAA2015110945879Actuator · crackedRIGHT WING NR 5 GND SPOILER OTBD ACTUATOR ROD END CRACKED. R & R ACTUATOR IAW AMM.SDR SWAA2015110945878Casting · brokenRIGHT WING NR 5 GND SPOILER INBD HINGE POINT CASTING BROKEN. REPLACED NR 5 GND SPOILER IAW AMM.SDR SWAA2015110945849Fuse · inoperativeR1 DOOR AFT EMER EXIT LIGHT INOPERATIVE. R & R FUSE IAW SIP.SDR SWAA2015110945848Spindle · delaminatedLEFT WING SPINDLE DELAMINATED BETWEEN CLAY & THE MID-FLAP OR CARRIAGE LINK IAW GAP. R & R SPINDLER IAW MT.SDR SWAA2015110945847Lens · looseCENTER AISLE EMER EXIT LENS COVER LOOSE. SECURED LENS IAW MM.SDR SWAA2015123147563Skin · crackedRIGHT WING FIXED LE SKIN CRACKED AT STATION 208. REPAIRED SKIN IAW EA.SDR SWAA2015123147562Skin · crackedLEFT WING FIXED LE SKIN CRACKED AT STATION 208. REPAIRED SKIN IAW EA.SDR SWAA2015122347395Floor Support · crackedLONGITUDINAL FLOORBEAM CRACKED AT STATION 727B, LBL 45.5. REPAIRED BEAM IAW EA.SDR SWAA2015121547099Skin Panel · crackedLEFT WING UPPER SKIN PANEL, MOST AFT OPENED FASTENER HOLE ON TE OF SKIN AT RSS 233 CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2015121547098Skin Panel · crackedLEFT WING UPPER SKIN PANEL, MOST AFT OPENED FASTENER HOLE ON TE OF SKIN AT RSS 237 CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2015121547097Skin Panel · crackedLEFT WING UPPER SKIN PANEL, MOST AFT OPENED FASTENER HOLE ON TE OF SKIN AT RSS 249 CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2015120946899Attach Angle · corrodedATTACH ANGLE, CORRODED AT BS 727E, STRINGER 27L, OTBD ANGLE. R & R ANGLE IAW SRM & ER.
Back to Boeing 737-3H4