Boeing 737-5H4
Service difficulty reports · 8,230
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 = '7375H4' 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 = '7375H4' 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 SWAA2013061817260Spindle · corrodedRT WING NR 7 SPINDLE LOWER SURFACE ROOT CORRODED. R&R NR 7 FLAP SPINDLE CARRIAGE PER MT.SDR SWAA2013061717172Battery Pack · dischargedFORWARD LT EMERGENCY LIGHT BATTERY PACK CAPACITY LOW. R & R BATTERY PACK ASSY IAW AMM.SDR SWAA2013070117766Skin Panel · crackedSKIN PANEL CRACKED BETWEEN BS 727 TO 908, STR 20L TO STR 25L. REMOVED AND REPLACED SKIN PER ER AND EA.SDR SWAA2013062817722Shroud · crackedR1 DOOR EMERGENCY EVAC SLIDE SHROUD CRACKED AT FWD GIRT BAR HOOK ATTACH POINT. REPAIRED SHROUD IAW SWA.SDR SWAA2013062617620Door Frame · crackedL2 DOOR FRAME CRACKED AT 2ND FROM TOP FWD STOP PIN FITTING CUTOUT. REPAIRED FRAME IAW PO.SDR SWAA2013062617613Door Frame · crackedR1 DOOR FRAME CRACKED AT 2ND FROM TOP AFT STOP PIN FITTING CUTOUT. REPAIRED FRAME IAW PO.SDR SWAA2013061717171Battery Pack · dischargedFLIGHT DECK EMERGENCY EXIT LIGHT INOP. R & R BATTERY PACK IAW MM.SDR SWAA2013061217071Lens · brokenFWD ENTRY EMERGENCY EXIT LENS BROKEN. R & R LENS IAW MM.SDR SWAA2013061917365Skin · crackedSKIN CRACKED AT BS 444, STR 1L. REPAIRED SKIN IAW SRM AND EA.SDR SWAA2013061917364Skin · crackedSKIN CRACKED AT BS 444, STR 1L. REPAIRED SKIN IAW EA & SRM.SDR SWAA2013061917363Skin · crackedSKIN CRACKED AT BS 425, STR 1L. REPAIRED SKIN IAW EA.SDR SWAA2013070117765Skin · crackedFUSELAGE SKIN CRACKED AT STA 933, STR 21R. REPAIRED SKIN PER ER & EA.SDR SWAA2013061016939Skin · crackedFUSELAGE SKIN CRACKED AT STA 747+16, STR 24L. REPAIRED SKIN IAW SRM.SDR SWAA2013060616833Support Bracket · crackedSUPPORT BRACKET CRACKED AT BS 380, BETWEEN STR 20L TO STR 21L. R & R BRACKET IAW SRM AND DWG.SDR SWAA2013060316664Battery Pack · dischargedEMERGENCY EXIT LIGHTS IN AFT GALLEY INOP. R & R BATTERY PACK ASSY IAW AMM.SDR SWAA2013060316663Actuator · shearedLEFT WING INBD GROUND SPOILER OTBD ACTUATOR ROD END SHEARED. R & R ACTUATOR IAW MM.SDR SWAA2013060316662Spoiler · brokenLEFT WING INBD GROUND SPOILER BROKEN AT HINGE AREA. R & R SPOILER IAW AMM CK GOOD.SDR SWAA2013060316661Fitting · crackedLEFT WING GROUND SPOILER FITTING ASSY LUG ON NR 4 OTBD ACTUATOR CRACKED. REPAIRED FITTING ASSY IAW EA.SDR SWAA2013060316720Skin · crackedAFT ENTRY DOOR FUSELAGE UPPER HINGE CUTOUT CRACKED AT UPPER CORNER. REPAIRED SKIN IAW SRM.SDR SWAA2013052816502Light · inoperativeLT OVERHEAD BIN EMERGENCY LIGHT INOP AT ROW 6. RELAMPED IAW MM.SDR SWAA2013052816509Skin · crackedSKIN CRACKED AT BS 258, BETWEEN STR 20L AND STR 24L. REPAIR SKIN IAW EA.SDR SWAA2013052816503Skin · crackedFUSELAGE SKIN CRACKED AT STA 420+3, STR 1L. REPAIRED SKIN IAW EA.SDR SWAA2013052416459Skin · crackedSKIN CRACKED AT STA 767+4.6, STR 18L. REPAIRED SKIN IAW EA.SDR SWAA2013052416460Skin · crackedFUSELAGE SKIN CRACKED AT STA 767+12, STR -18L. REPAIRED SKIN IAW EA.SDR SWAA2013052316421Roller · out of adjustLEFT WING INBD AFT FLAP LOOSE. ADJUSTED ROLLERS IAW AMM.SDR SWAA2013052316420Flap · looseRIGHT WING INBD AFT FLAP LOOSE. ADJUSTED AFT FLAP IAW AMM.SDR SWAA2013053016615Flap · delaminatedRIGHT WING INBD FORE FLAP DELAMINATED. REPAIRED FORE FLAP IAW SRM.SDR SWAA2013052816516Strap · crackedSTRAP CRACKED BETWEEN BS 312 TO BS 344, STR 17. R & R STRAP IAW SRM AND DWG.SDR SWAA2013052216329Pump · faultyON TAKEOFF BOTH FORE AND AFT NR 1 FUEL PUMP LOW PRESSURE LIGHTS ILLUMINATED WITH CORRESPONDING MASTER CAUTION LIGHTS. LIGHTS WENT OUT APPROX. 1 MINUTE AFTER DECK ANGLE REDUCED. NR 1 TANK AFT PUMP LIGHT ILLUMINATED IN CRUISE FLIGHT. COMPLIED WITH QRH AND OPESDR SWAA2013052816506Skin · crackedFUSELAGE SKIN CRACKED AT BS 410 - 2, STR 16R. REPAIRED SKIN IAW EA.SDR SWAA2013052816505Skin · crackedAFT FUSELAGE SKIN CRACKED AT BS 787 + 17, STR 19L. REPAIRED SKIN IAW EA.SDR SWAA2013052816504Skin · crackedFUSELAGE UPPER CROWN SKIN CRACKED AT STA 410 + 4, STR 7. REPAIRED SKIN IAW EA.SDR SWAA2013052016202Rib · crackedLEFT WING OTBD KRUEGER FLAP OUTBD STIFFENER RIB CRACKED. R & R RIB IAW AMM.SDR SWAA2013052016224Skin · crackedSKIN CRACKED AT BS 807+15, STR 18L. REPAIRED SKIN IAW EA.SDR SWAA2013061217097Bulkhead · crackedBULKHEAD WEB CRACKED BS 1016, STR 15R. REPAIRED WEB IAW EO AND EA.SDR SWAA2013061016944Bulkhead · crackedAFT BULKHEAD DOME WEB CRACKED AT BS 1016, STR 21R. REPAIRED WEB IAW EO AND EA.SDR SWAA2013052216352Web · crackedWEB CRACKED BETWEEN BS 312 TO BS 303.9, STR 28L. REPAIRED WEB IAW SRM.SDR SWAA2013051416025Cable · looseL2 DOOR EMERGENCY EVAC SLIDE LOOSE. SECURED CABLE PER MM.SDR SWAA2013060516802Structure · corrodedBULKHEAD CHORD CORRODED AT BS 227.8, BETWEEN LBL 5 TO RBL 5. R & R CHORD IAW SRM AND DWG.SDR SWAA2013060316658Stiffener · corrodedSTIFFENER CORRODED AT BS 227.8, BL 0. R & R STIFFENER IAW SRM AND DWG.SDR SWAA2013052316424Stiffener · crackedLEFT WING NR 3 FLAP TRACK FAIRING STIFFENER CRACKED AT WBL 183.4. R & R STIFFENER IAW SRM AND DWG.SDR SWAA2013052216351Stiffener · crackedRT WING NR 6 FLAP TRACK FAIRING STIFFENER CRACKED AT WBL 183.4. R & R STIFFENER IAW SRM AND DWG.SDR SWAA2013060416736Light · delaminatedEEPLS DELAMINATED ALONG PAX CABIN. R & R EEPLS IAW AMM AND DWG.SDR SWAA2013052016204Stringer Splice · crackedSTRINGER SPLICE CRACKED AT BS 360, STR 15R. R & R SPLICE IAW SRM AND DWG.SDR SWAA2013050915856Lens · looseRIGHT OVERWING EMERGENCY EXIT LENS LOOSE. SECURED LENS PER EA.SDR SWAA2013050615666Light · inoperativeLEFT EMERGENCY EXIT LIGHT INOP AT ROW 2. REMOVED AND REPLACED BULB PER AMM.SDR SWAA2013053016614Stringer · corrodedSTRINGER CORRODED AT BS 863, STR 26R. REPAIRED STRINGER IAW SRM.SDR SWAA2013052216350Tie Clip · crackedTIE CLIP CRACKED AT BS 787, STR 20R. R & R TIE CLIP IAW SRM AND DWG.SDR SWAA2013050615665Slide · looseL2 DOOR EMERGENCY SLIDE LOOSE. SECURED SLIDE PER MT.SDR SWAA2013052416458Retainer · corrodedLEFT WING INBD FLAP, INBD CARRAIGE FWD ROLLER ASSY CORRODED. R & R RETAINER IAW CMM.
Back to Boeing 737-5H4