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 SWAA2016042551258Skin · crackedAFT GALLEY DOOR SKIN CUT OUT CRACKED AT FASTENER HOLE ON FWD LOWER CORNER. REPAIRED SKIN IAW EA.SDR SWAA2016042551260Crease Beam · crackedRIGHT CREASE BEAM INBD CHORD CRACKED AT BS 616. REPAIRED CHORD IAW EA.SDR SWAA2016042551259Bear Strap · crackedAFT GALLEY DOOR LOWER HINGE CUT OUT BEAR STRAP CRACKED. REPAIRED DOUBLER IAW SRM & EA.SDR SWAA2016041851033Web · corrodedAFT CARGO VERTICAL LOWER WEB CORRODED, BETWEEN BS 767 - 787, STRINGER . R & R WEB IAW SRM.SDR SWAA2016041350858Door Frame · crackedAFT ENTRY DOOR CUT OUT, LOWER FRAME CRACKED AT BS 959, WL 21.1. REPAIRED FRAME IAW EA.SDR SWAA2016040550618Attach Fitting · crackedRIGHT WING TE INBD FLAP, OTBD FLAP TRACK FAIRING, INBD ATTACH FITTING ON WING CRACKED. R & R FITTING IAW DWG.SDR SWAA2016033050429Angle · crackedAFT CARGO COMPARTMENT ANGLE CRACKED AT BS 947.5+10, BETWEEN STRINGER 24L - 26L. R & R ANGLE IAW SRM & DWG.SDR SWAA2016032850261Splice · corrodedCREASE BEAM SPLICE CORRODED, BETWEEN BS 1006 - 1016, BETWEEN LBL 40 - 45. R & R SPLICE IAW DWG & SRM.SDR SWAA2016032850260Crease Beam · corrodedCREASE BEAM WEB CORRODED AT BS 1000, LBL 45. R & R WEB IAW SRM.SDR SWAA2016031449839Hydraulic Line · chafedAIR TURN BACK & DECLARED EMER. AT GEAR RETRACTION NOTICED, A SYS HYD, LOW PRESSURE LIGHTS. A SYS WENT TO ZERO LANDED NORMALLY AFTER FOLLOWING CHECKLIST. R & R RETURN & SUPPLY LINES IAW.SDR SWAA2016042551305Spar · crackedRIGHT WING UPPER REAR SPAR WEB CRACKED AT RSS 221.5, ON TE AT 5 O' CLOCK DIRECTION. REPAIRED WEB IAW EA.SDR SWAA2016042551304Spar · crackedRIGHT WING REAR SPAR WEB CRACKED AT RSS 218 ON TE AT 11 O'CLOCK DIRECTION. REPAIRED WEB IAW EA.SDR SWAA2016042551303Spar · crackedLEFT WING REAR SPAR WEB & LOWER CHORD ON RSS 224.14 +1", AT 3 O' CLOCK DIRECTION. REPAIRED WEB IAW EA.SDR SWAA2016042551302Spar · crackedLEFT WING REAR SPAR WEB & LOWER CHORD CRACKED AT RSS 215.97+6, AT 2 & 6 O' CLOCK DIRECTIONS. REPAIRED WEB IAW EA.SDR SWAA2016042551301Spar · crackedLEFT WING REAR SPAR WEB & LOWER CHORD CRACKED AT RSS 215.97+5, AT 11 O' CLOCK DIRECTION. REPAIRED WEB IAW EA.SDR SWAA2016042551300Spar · crackedLEFT WING REAR SPAR WEB & LOWER CHORD CRACKED AT RSS 215.97+4, AT 9 O' CLOCK DIRECTION. REPAIRED WEB IAW EA.SDR SWAA2016042551299Spar · crackedLEFT WING REAR SPAR WEB & LOWER CHORD CRACKED AT RSS 215.97+3, AT 5 & 12 O' CLOCK. REPAIRED WEB IAW EA.SDR SWAA2016041851064Spar · crackedRIGHT WING REAR SPAR UPPER CHORD CRACKED AT RSS 221.5 ON TE. REPAIRED CHORD IAW EA.SDR SWAA2016041851063Spar · crackedLEFT WING REAR SPAR UPPER CHORD CRACKED AT RSS 215.97+3. REPAIRED CHORD IAW EA.SDR SWAA2016041450925Spar · crackedLEFT WING REAR SPAR, UPPER CHORD CRACKED, LOCATED ON RSS 215.97+6. REPAIRED CHORD IAW EA.SDR SWAA2016041450924Spar · crackedLEFT WING REAR SPAR, UPPER CHORD CRACKED IN OPEN HOLE, LOCATED ON RSS 215.97+5. REPAIRED CHORD IAW EA.SDR SWAA2016041450923Spar · crackedLEFT WING REAR SPAR UPPER CHORD CRACKED ON RSS 215.97+4. REPAIRED CHORD IAW EA.SDR SWAA2016040450587Skin · delaminatedLEFT WING INBD FORE FLAP LOWER SKIN DELAMINATED. REPAIRED SKIN IAW SRM.SDR SWAA2016033050428Skin · delaminatedLEFT WING INBD AFT FLAP DELAMINATED FROM OTBD EDGE UPPER SKIN. REPAIRED AFT FLAP IAW SRM.SDR SWAA2016032850274Stiffener · crackedCENTER TANK STIFFENER CRACKED AT BS 546, LBL 58. R & R STIFFENER IAW SRM.SDR SWAA2016032350170Shear Tie · corrodedSHEAR TIE CORRODED AT STATION 1006, STRINGER 27L - 27R. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2016032350169Shear Tie · corrodedSHEAR TIE CORRODED AT STATION 1006, STRINGER 25R - 27R. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2016032250112Skin · delaminatedRIGHT WING UPPER SKIN, INBD FORE FLAP DELAMINATED. REPAIRED FORE FLAP IAW SRM.SDR SWAA2016032150004Angle · crackedL1 CUT OUT ANGLE CRACKED AT BS 351, STRINGER 16L. R & R ANGLE IAW SRM & DWG.SDR SWAA2016031449891Lens · looseLEFT FWD EMER LIGHT LENS LOOSE ON CEILING AT ROW 2. R & R LENS IAW AMM.SDR SWAA2016031449869Flap Track · looseLEFT WING OTBD FLAP TRACK LOOSE, 2ND FROM OTBD END. SECURED TRACK IAW CMM.SDR SWAA2016031149815Cover · unsecureFORWARD ENTRY DOOR EMER EXIT LIGHT COVER FELL OFF. R & R LIGHT IAW AMM.SDR SWAA2016031149814Lens · missingFORWARD SERVICE DOOR EMER LIGHT LENS MISSING. R & R LIGHT ASSEMBLY IAW AMM.SDR SWAA2016042551298Skin · crackedLOWER AFT CORNER OF FWD ENTRY DOOR SKIN CRACKED AT BS 344, STRINGER 16L. REPAIRED SKIN IAW SRM.SDR SWAA2016042551257Skin · crackedRIGHT LOWER AFT CORNER OF DOOR SKIN CUT OUT FASTENER HOLES CRACKED AT BS 322, STRINGER 17R. REPAIRED SKIN IAW EA.SDR SWAA2016042551256Skin · crackedFORWARD LT DOOR FUSELAGE SKIN FASTENER HOLE CRACKED ON LOWER AFT CORNER. REPAIRED SKIN IAW EA.SDR SWAA2016041851040Support Fitting · crackedLEFT WING REAR SPAR MLG AFT SUPPORT FITTING CRACKED ON RSS 215.97+6. REPAIRED FITTING IAW EA.SDR SWAA2016041550958Skin · crackedRIGHT WING UPPER SKIN CRACKED AT FASTENER HOLE, AT RSS 237.5, AFT OF REAR SPAR. REPAIRED SKIN IAW EA.SDR SWAA2016041550957Skin · crackedLEFT WING UPPER SKIN CRACKED AT FASTENER HOLE AT RSS 255 AFT OF REAR SPAR. REQUIRED SKIN IAW EA.SDR SWAA2016041450904Skin · crackedRIGHT WING UPPER SKIN CRACKED AT FASTENER HOLE, AT RSS 264, AFT OF REAR SPAR. REPAIRED SKIN IAW ER & EA.SDR SWAA2016041450903Skin · crackedRIGHT WING UPPER SKIN CRACKED AT FASTENER HOLE, AT RSS 253, AFT OF REAR SPAR. REPAIRED SKIN IAW ER & EA.SDR SWAA2016041450902Skin · crackedRIGHT WING UPPER SKIN CRACKED AT FASTENER HOLE, AT RSS 249, AFT OF REAR SPAR. REPAIRED SKIN IAW ER & EA.SDR SWAA2016041450901Skin · crackedLEFT WING UPPER SKIN CRACKED AT FASTENER HOLE, AT RSS 269, AFT OF REAR SPAR. REPAIRED SKIN IAW EA & ER.SDR SWAA2016041450900Skin · crackedLEFT WING UPPER SKIN CRACKED, AT FASTENER HOLE AT RSS 268, AFT OF REAR SPAR. REPAIRED SKIN IAW EA & ER.SDR SWAA2016041450899Skin · crackedLEFT WING UPPER SKIN CRACKED AT FASTENER HOLE, AT RSS 251, AFT OF REAR SPAR. REPAIRED SKIN IAW EA & ER.SDR SWAA2016041450898Skin · crackedLEFT WING UPPER SKIN CRACKED, AT FASTENER HOLE AT RSS 239, AFT OF REAR SPAR. REPAIRED SKIN IAW EA & ER.SDR SWAA2016041250804Skin · crackedAFT LOWER SUPPORT FOR R1 DOOR CUT OUT CRACKED. R & R CUT OUT IAW SRM.SDR SWAA2016040550610Plate · crackedRIGHT WING TE PLATE CRACKED AT LEVEL WBL 180. R & R PLATE IAW SRM & DWG.SDR SWAA2016040550609Plate · crackedLEFT WING TRAILING PLATE EDGE CRACKED, AT WBL 181.15. R & R PLATE IAW SRM & DWG.SDR SWAA2016040550617Skin · crackedAFT CARGO DOOR CUT OUT FWD LOWER CORNER SKIN CRACKED. REPAIRED SKIN IAW SRM.
Back to Boeing 737-3H4