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 SWAA2013041214766Slide · out of positionR2 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MM.SDR SWAA2013041214765Lug · brokenLEFT WING GROUND SPOILER INBOARD LUG BROKEN. REMOVED AND REPLACED LEFT WING GROUND SPOILER PER AMM.SDR SWAA2013052216362Web · crackedINNER CHORD AND WEB CRACKED AT BS 616, STR 18L. REPAIRED INNER CHORD, OUTER CHORD AND WEB IAW EA.SDR SWAA2013052216361Web · crackedINNER CHORD AND WEB CRACKED AT BS 616, STR 18L. REPAIRED INNER CHORD, OUTER CHORD AND WEB IAW EA.SDR SWAA2013052116317Structure · crackedBULKHEAD RT SIDE CHORD CRACKED AT BS 178, WL 217 LT SIDE. R & R CHORD IAW EA.SDR SWAA2013052116318Structure · crackedBULKHEAD RT SIDE CHORD CRACKED AT BS 178, WL 217 RT SIDE. R & R CHORD IAW EA.SDR SWAA2013050715795Frame · crackedFRAME CRACKED AT BS 188, STR 17R. REPAIRED FRAME IAW SRM AND DWG.SDR SWAA2013050715794Frame · crackedFRAME CRACKED AT BS 188, STR 17L. REPAIRED FRAME IAW SRM AND DWG.SDR SWAA2013050715793Threshold · corrodedTHRESHOLD WEB CORRODED BETWEEN BS 947.5 TO BS 987, STR 17R. REMOVED AND REPLACED WEB IAW SRM AND DWG.SDR SWAA2013050115415Channel · crackedVERTICAL DUCT ASSY CHANNEL CRACKED BETWEEN BS 294.5 TO BS 312, STR 27R. REMOVED AND REPLACED CHANNEL IAW SRM & DRAWING.SDR SWAA2013043015376Stringer · crackedCHANNEL STRINGER CRACKED AT BS 907, STR 4R. REMOVED AND REPLACED STRINGER IAW SRM.SDR SWAA2013042615303Shear Tie · corrodedSHEAR TIE CORRODED AT BS 325.38, BETWEEN STR 26R TO STR 27R. REMOVED AND REPLACED SHEAR TIE IAW SRM AND DRAWING.SDR SWAA2013042615302Angle · crackedANGLE CRACKED AT BS 328, RBL 55. REMOVED AND REPLACED ANGLE IAW SRM AND DWG.SDR SWAA2013042415194Attach Fitting · crackedATTACH CLIP CRACKED AT BS 348.2, STR 15L. REMOVED AND REPLACED ANGLE IAW AND DWG.SDR SWAA2013042415193Fitting · crackedCLIP CRACKED AT BS 706, STR 11L. REMOVED AND REPLACED CLIP IAW SRM AND DRAWING.SDR SWAA2013042415192Fitting · crackedCLIP CRACKED AT BS 580, STR 11L. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA2013042415191Fitting · crackedCLIP CRACKED AT BS 706, STR 11R. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA2013042415157Floor Support · crackedLONGITUDINAL FLOORBEAM WEB CRACKED AT BS 707, RBL 24.8. REPAIRED WEB PER EA.SDR SWAA2013042415156Floor Support · crackedLONGITUDINAL FLOORBEAM WEB CRACKED AT BS 708, RBL 24.8. REPAIRED WEB PER EA.SDR SWAA2013041915047Floor Support · crackedLONGITUDINAL FLOORBEAM WEB CRACKED AT BS 708, BBL .07. REPAIRED WEB PER EA.SDR SWAA2013041915046Floor Support · crackedLONGITUDINAL FLOORBEAM WEB CRACKED AT BS 709, BBL .07. REPAIRED WEB PER EA.SDR SWAA2013041814989Intercostal · crackedINTERCOSTAL CRACKED BETWEEN BS 639 TO BS 663.75, STR 15R. REMOVED AND REPLACED INTERCOSTAL IAW SRM AND DRAWING.SDR SWAA2013041714964Floor Support · crackedLONGITUDINAL FLOORBEAM CRACKED AT BS 712, LBL 24.8. REPAIRED BEAM PER EA.SDR SWAA2013041714950Tie Clip · crackedTIE CLIP CRACKED AT BS 663.75, STR 10R. REMOVED AND REPLACED TIE CLIP IAW SRM AND DRAWING.SDR SWAA2013041714949Tie Clip · crackedTIE CLIP CRACKED AT BS 380, STR 8L. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.SDR SWAA2013041614895Floor Support · crackedLONGITUDINAL FLOORBEAM CRACKED AT BS 727B, RBL 24.8. REPAIRED BEAM PER EA.SDR SWAA2013041614889Stop Fitting · crackedSTOP PAD CRACKED AT BS 616, STR 11R. REMOVED AND REPLACED STOP PAD IAW SRM.SDR SWAA2013041614883Tie Clip · crackedTIE CLIP CRACKED AT BS 380, STR 22L. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.SDR SWAA2013041514836Regulator · failedDECLARED EMERGENCY - AT INITIAL DESCENT FM FL350 CABIN ALT WARNING HORN SOUNDED & CABIN ALT LIGHT CAME ON COULD NOT CONTROL ALT IN AUTO OR MANUAL PER QRH. REMOVED AND REPLACED NR 1 ENGINE BLEED AIR REGULATOR, NR 1 ENGINE PRECOOLER CONTROL VALVE, NR 2 ENGINE HSDR SWAA2013041214780Stringer Clip · crackedSTRINGER CLIP CRACKED AT STA 1006, STR 8R. REMOVED & REPLACED CLIP IAW SRM & BAC DWG.SDR SWAA2013041214771Actuator · leakingRIGHT WING INBOARD GROUND SPOILER LEAKED. REMOVED AND REPLACED GROUND SPOILER ACTUATOR PER MM.SDR SWAA2013041214764Light · inoperativeEXTERIOR EMERGENCY LIGHT AFT OF THE AFT SERVICE DOOR INOP. REMOVED AND REPLACED BULB PER MM.SDR SWAA2013041214763Light · inoperativeEXTERIOR EMERGENCY LIGHT AFT OF THE AFT ENTRY DOOR INOP. REMOVED AND REPLACED BULB PER MM.SDR SWAA2013041114733Bracket · crackedR2 DOOR EMERGENCY EVAC SLIDE BRACKETS CRACKED. REMOVED AND REPLACED BRACKETS PER AMM.SDR SWAA2013041114732Rod · looseLEFT MLG INNER DOOR LOOSE AT CONTROL ROD. REMOVED AND REPLACED INNER DOOR SUPPORT ROD ASSEMBLY AND TRAMMELED PER MM.SDR SWAA2013041114731Bushing · looseLEFT MLG INNER DOOR LOOSE AT FWD HINGE. REMOVED AND REPLACED INNER DOOR FWD HINGE BUSHINGS AND ATTACH BOLT PER MM.SDR SWAA2013051516080Duct · crackedDUCT ASSY CRACKED BETWEEN BS 294.5 TO BS 312, BETWEEN STR 26R TO STR 26L. REPAIRED DUCT ASSY IAW EO AND EA.SDR SWAA2013050715792Web · corrodedWEB CORRODED BETWEEN BS 400 TO BS 420, STR 17L. REMOVED AND REPLACED WEB IAW SRM AND DWG.SDR SWAA2013050715747Web · crackedWEB CRACKED BETWEEN BS 500A TO BS 500B, STR 26R. REMOVED AND REPLACED WEB IAW SRM AND DRAWING.SDR SWAA2013050715746Web · crackedWEB CRACKED AT BS 328, BETWEEN STR 23R TO STR 24R. REMOVED AND REPLACED WEB IAW SRM.SDR SWAA2013050615609Threshold · crackedTHRESHOLD WEB CRACKED BETWEEN BS 294.5 TO BS 328, STR 17R. REMOVED AND REPLACED WEB IAW SRM & DWG.SDR SWAA2013043015351Web · crackedWEB CRACKED BETWEEN BS 351 TO BS 360, BL 0. REMOVED AND REPLACED WEB IAW SRM AND DRAWING.SDR SWAA2013043015375Strap · crackedSTRAP CRACKED BETWEEN BS 277 TO BS 294.5, STR 17R. REMOVED AND REPLACED STRAP IAW SRM AND DRAWING.SDR SWAA2013043015374Support Fitting · crackedSUPPORT CLIP CRACKED AT BS 294.5, STR 23L. REMOVED AND REPLACED CLIP IAW SRM AND DRAWING.SDR SWAA2013043015373Panel · crackedSIDEWALL PANEL CRACKED AT BS 380, BETWEEN STR 25L TO STR 28L. REMOVED AND REPLACED PANEL IAW SRM AND DRAWING.SDR SWAA2013042615301Fitting · crackedCLIP CRACKED AT BS 560, STR 11L. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA2013042615300Tie Clip · crackedTIE CLIP CRACKED AT BS 380, STR 21L. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG 46525.SDR SWAA2013042615299Angle · crackedANGLE CRACKED BETWEEN BS 294.5 TO BS 312, STR 25L. REMOVED AND REPLACED ANGLE IAW SRM AND DRAWING.SDR SWAA2013042415190Fitting · crackedCLIP CRACKED AT BS 580, STR 11R. REMOVED AND REPLACED CLIP IAW SRM AND DRAWING.SDR SWAA2013042415189Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 325.38, BETWEEN STR 20L TO STR 21L. REMOVED AND REPLACED ANGLE IAW SRM AND DWG.
Back to Boeing 737-3H4