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 SWAA2015120446719Skin · crackedLEFT WING UPPER SKIN PANEL, MOST AFT OPENED FASTENER HOLE ON TE OF SKIN AT RSS 253 CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2015112346245Bulkhead · crackedDOME CAP WEB CRACKED AT BS 1016, LBL 1.5. REPAIRED DOME CAP WEB IAW SRM.SDR SWAA2015111846175Crease Beam · corrodedRIGHT CREASE BEAM WEB CORRODED, BETWEEN BS 770 - 787. REPAIRED WEB IAW SRM & DWG.SDR SWAA2015111846174Crease Beam · corrodedRIGHT CREASE BEAM WEB CORRODED, BETWEEN BS 440 - 460. R & R WEB IAW SRM.SDR SWAA2015111846173Crease Beam · corrodedLEFT CREASE BEAM WEB CORRODED, BETWEEN BS 400 - 420. R & R WEB IAW SRM.SDR SWAA2015111846133Frame · crackedFRAME CRACKED AT BS 440, STRINGER 24R. R & R FRAME IAW ACO.SDR SWAA2015111846132Frame · crackedFRAME CRACKED AT BS 328, BETWEEN STRINGER 20R - 21R. REPAIRED FRAME IAW ACO.SDR SWAA2015111346045Floor Support · crackedCENTER WING BOX, LONGITUDINAL FLOORBEAM, UPPER CHORD CRACKED AT BS 727B, RBL 24.50. REPAIRED CHORD IAW EA.SDR SWAA2015111246012Skin · crackedGROUND AIR HOOK UP DOOR CUT OUT SKIN CRACKED AT BS 520+7, LOWER LT SIDE. REPAIRED SKIN IAW EA.SDR SWAA2015111245995Spoiler · delaminatedRIGHT WING NR 7 FLIGHT SPOILER DELAMINATED AT TE OF SPOILER. R & R SPOILER IAW AMM.SDR SWAA2015110645824Lens · looseCENTER AISLE CEILING MOUNT, EMER EXIT LIGHT LENS ASSEMBLY LOOSE. SECURED LENS IAW MM.SDR SWAA2015121447090Spar · crackedLEFT WING AFT SPAR WEB CRACKED AT RSS 223. REPAIRED WEB IAW EA.SDR SWAA2015121447089Attach Fitting · crackedLEFT MLG BEAM ATTACH FITTING ON WING AFT SPAR, CRACKED IN FITTING AT MOST INBD FITTING TO SPAR UPPER CHORD ATTACH FASTENER. REPAIRED FITTING IAW EA.SDR SWAA2015121447088Spar · crackedRIGHT WING AFT SPAR WEB CRACKED AT RSS 220. REPAIRED WEB EA.SDR SWAA2015120746803Stiffener · crackedLEFT WING STIFFENER CRACKED, AT WING STATION RSS 240. R & R STIFFENER IAW EA & DWG.SDR SWAA2015112446399Stringer · corrodedSTRINGER CORRODED, BETWEEN BS 1006 - 1016, STRINGER 26R. R & R STRINGER IAW SRM.SDR SWAA2015112446398Shear Tie · corrodedSHEAR TIE CORRODED AT BS 1006, BETWEEN STRINGER 27L - 27R. R & R SHEAR TIE IAW SRM & DWG.SDR SWAA2015111846207Floor Support · crackedLONGITUDINAL FLOORBEAM INBD & OTBD FLANGE FASTENER, CRACKED AT BS 727B, LBL 45.5. REPAIRED BEAM IAW ER & EA.SDR SWAA2015111846139Stringer · corrodedSTRINGER LOWER CHANNEL CORRODED AT BS 986, STRINGER 25L. R & R STRINGER IAW SRM.SDR SWAA2015111846131Shear Tie · corrodedSHEAR TIE CORRODED AT BS 967, BETWEEN STRINGER 26L - 27L. R & R SHEAR TIE IAW SRM & DWG.SDR SWAA2015111646071Stringer Splice · crackedSTRINGER SPLICE CRACKED AT BS 360, STRINGER 8L. R & R SPLICE IAW SRM & DWG.SDR SWAA2015110645813Slide · out of positionL1 DOOR EMER EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW MT.SDR SWAA2015110545801Stiffener · crackedRIGHT WING AILERON NR 2 HINGE STIFFENER CRACKED. R & R STIFFENER IAW SRM.SDR SWAA2015110545773Angle · crackedLEFT OUTER WING INTERIOR TE, FWD OF AILERON NR 2 HINGE, VERTICAL LT ANGLE CRACKED. R & R LT ANGLE IAW SRM.SDR SWAA2015120946898Spar · crackedRIGHT WING REAR SPAR, CRACKED UPPER ROW 1ST INBD & 1ST OTBD OF RSS 224.14. REPAIRED SPAR IAW EA.SDR SWAA2015120946897Web · crackedRIGHT WING WEB CRACKED, UPPER ROW 1ST INBD & 1ST OTBD OF RSS 224.14. REPAIRED WEB IAW EA & ER.SDR SWAA2015113046500Carriage · corrodedLEFT WING NR 1 MAIN FLAP CARRIAGE, BOTH LOWER A FRAME ATTACH BOLT HOLES CORRODED. REPAIRED FLAP CARRIAGE IAW CMM.SDR SWAA2015111846206Door Frame · crackedL1 DOOR FRAME INNER CHORD CRACKED AT BS 348.2, STRINGER 17L. REPAIRED CHORD IAW ER & EA.SDR SWAA2015111846205Carriage · corrodedRIGHT WING NR 7 MAIN FLAP CARRIAGE, INBD LOWER A FRAME ATTACH BOLT HOLE CORRODED. REPAIRED FLAP CARRIAGE IAW CMM.SDR SWAA0188110146204Carriage · corrodedRIGHT WING NR 8 MAIN FLAP CARRIAGE, INBD LOWER A FRAME ATTACH BOLT HOLE CORRODED. REPAIRED FLAP CARRIAGE IAW CMM.SDR SWAA2015111846203Carriage · corrodedLEFT WING NR 2 MAIN FLAP CARRIAGE, INBD LOWER A FRAME ATTACH BOLT HOLE CORRODED. REPAIRED FLAP CARRIAGE IAW CMM.SDR SWAA2015111846130Shear Tie · corrodedSHEAR TIE CORRODED AT BS 947, STRINGER 26L - 24L. R & R SHEAR TIE IAW SRM & DWG.SDR SWAA2015111846129Skin · crackedSKIN CRACKED BETWEEN BS 415 - 416, STRINGER 2R. REPAIRED SKIN IAW EA.SDR SWAA2015111846186Intercostal · crackedINTERCOSTAL WEB CRACKED AT BS 303, STRINGER 16L. R & R INTERCOSTAL IAW DWG & SRM.SDR SWAA2015111446011Floor Support · crackedLONGITUDINAL FLOORBEAM CTR WING BOX WEB CRACKED, BETWEEN BS 698 - 717, LBL 24.8. REPAIRED WEB IAW EA.SDR SWAA2015111145975Stringer · corrodedSTRINGER CORRODED, BETWEEN BS 1006 - 1016, STRINGER 26R. R & R STRINGER IAW SRM & DWG.SDR SWAA2015110545790Lens · missingL1 DOOR LOWER EMER EXIT LIGHT LENS MISSING. INSTALLED LENS IAW SIP.SDR SWAA2015110545789Light · inoperativeLEFT OVERWING EMER EXIT LIGHT ON LOWER SIDEWALL BULB INOPERATIVE. R & R LIGHT IAW AMM.SDR SWAA2015110545775Battery Pack · dischargedLEFT FWD GALLEY AREA, EMER EXIT LIGHT INOPERATIVE. R & R BATTERY PACK IAW AMM.SDR SWAA2015110445748Sliding Window · faultyDIVERSION, FIRST OFFICERS SLIDING WINDOW CAME OPEN ON TAKEOFF. R & R SLIDING WINDOW IAW MT.SDR SWAA2015110445746Door · crackedR1 DOOR CRACKED AT LOWER FRAME, AFT CORNER AT AFT LOWER CORNER STOP FITTING. INSTALLED DOOR IAW AMM.SDR SWAA2015110445742Stiffener · crackedRIGHT WING AILERON NR 2 HINGE STIFFENER CRACKED. R & R STIFFENER IAW SRM.SDR SWAA2015110445741Hinge · brokenRIGHT WING INBD GND SPOILER, INBD ACTUATOR HINGE BROKEN. R & R SPOILER IAW AMM.SDR SWAA2015110445740Lens · out of adjustLEFT EMER EXIT LIGHT LENS COVER OUT OF ADJUSTMENT. ADJUSTED LENS IAW AMM.SDR SWAA2015110445739Light · inoperativeFORWARD LAVATORY EMER EXIT SIGN BULB INOPERATIVE. R & R BULB IAW AMM.SDR SWAA2015110445729Angle · crackedLEFT OUTER WING STRUCTURE, FWD OF AILERON NR 2 HINGE, VERTICAL LT ANGLE CRACKED. R & R LT ANGLE IAW SRM.SDR SWAA2015120246627Strap · brokenFORWARD CABIN FLASHLIGHT STRAP BROKEN. REPAIRED STRAP IAW AMM.SDR SWAA2015113046522Link Assy · corrodedLEFT MAIN LANDING BEAM SWING LINK CORRODED. REPAIRED LINK ASSEMBLY IAW EA.SDR SWAA2015113046521Link Assy · corrodedRIGHT MLG BEAM SWING LINK CORRODED. REPAIRED LINK ASSEMBLY IAW EA.SDR SWAA2015113046495Angle · corrodedAFT CARGO COMPARTMENT FRAME LOWER ANGLE CORRODED AT BS 947.5, STRINGER 25L. REPAIRED ANGLE IAW SRM.
Back to Boeing 737-3H4