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 SWAA2014031025908Actuator · leakingRT WING NR 6 SPOILER ACTUATOR LEAKED. R & R ACTUATOR IAW AMM.SDR SWAA2014031025905Light · inoperativeR2 DOOR OUTSIDE EMERGENCY LIGHT INOPERATIVE. RELAMPED LIGHT IAW MM.SDR SWAA2014031025890Battery Pack · dischargedCTR CABIN OVERHEAD EMERGENCY EXIT LIGHT INOPERATIVE. R & R BATTERY PACK IAW AMM.SDR SWAA2014030725856Strap · crackedSTIFFENER STRAP CRACKED AT BS 312.5, BL 40. REPAIRED STRAP IAW SRM.SDR SWAA2014030725850Strap · crackedSTIFFENER STRAP CRACKED AT BS 312.5, BL 35. R & R STRAP IAW SRM.SDR SWAA2014030725849Strap · crackedE & E COMPARTMENT STIFFENER STRAP CRACKED AT BS 328.5. R & R STRAP IAW SRM.SDR SWAA2014040726836Skin · crackedSKIN CRACKED AT BS 328, STRINGER 17R. REPAIRED SKIN IAW EA.SDR SWAA2014040726835Skin · crackedSKIN CRACKED AT BS 947.5+5, STRINGER 11R. REPAIRED SKIN IAW SRM.SDR SWAA2014040726834Structure · crackedCHORD CRACKED AT BS 727, STRINGER 18A RT IN FWD LOWER FASTENER HOLE. REPAIRED CHORD IAW EA.SDR SWAA2014040326789Pressure Deck · crackedMAIN LANDING GEAR WW PRESSURE DECK CRACKED AT BS 664, BETWEEN BL 0- LBL 24.5. REPAIRED PRESSURE WEB IAW EA.SDR SWAA2014040326788Pressure Deck · crackedMAIN LANDING GEAR WW PRESSURE DECK CRACKED BETWEEN BS 664 - 675, BETWEEN LBL 24.5-45.5. REPAIRED PRESSURE WEB IAW EA.SDR SWAA2014040126716Pressure Panel · crackedMLG WW PRESSURE DECK CRACKED BETWEEN BS 664 - 675, BETWEEN RBL 24.5 TO RBL 45.5. REPAIRED DECK IAW SRM.SDR SWAA2014040126715Channel · crackedSTIFFENER CHANNEL CRACKED AT BS 178, BETWEEN RBL 5.7 TO RBL 17.5. R & R CHANNEL IAW SRM & DWG.SDR SWAA2014033126641Skin · crackedRIGHT WING NR 6 LOWER SURFACE SLAT SKIN CRACKED. REPAIRED SKIN IAW SRM.SDR SWAA2014032826604Rib · crackedRIGHT WING REAR SPAR UPPER RIB CHORD CRACKED AT WING STATION 198.6, STRINGER 5. REPAIRED RIB IAW EA.SDR SWAA2014032426476Skin · crackedFUSELAGE SKIN CRACKED AT BS 211.8+3, STRINGER 9R. REPAIRED SKIN IAW SRM.SDR SWAA2014032426373Cover · looseAFT CEILING EMERGENCY EXIT LIGHT COVER LOOSE. R & R COVER IAW AMM.SDR SWAA2014031926235Attach Angle · crackedFRAME ATTACH ANGLE CRACKED AT BS 1006, BETWEEN STRINGER 18R TO STRINGER 19R. R & R ANGLE IAW SRM & DWG.SDR SWAA2014031025884Light · inoperativeLT OVERWING EMERGENCY EXIT DOOR SIDE WALL LIGHT INOPERATIVE. RELAMPED LIGHT IAW AMM.SDR SWAA2014030625804Lens · looseLT EMERGENCY EXIT LIGHT LENS LOOSE. SECURED LENS IAW AMM.SDR SWAA2014040426825Frame · crackedFUSELAGE FRAME CRACKED AT LT STATION 727, STRINGER 18A, OTBD CHORD. REPAIRED FRAME IAW EA.SDR SWAA2014040426824Frame · crackedFUSELAGE FRAME CRACKED AT RT STATION 727, STRINGER 18A, OTBD CHORD. REPAIRED FRAME IAW EA.SDR SWAA2014040326800Skin · crackedSKIN CRACKED AT BS 500D, STRINGER 14R. REPAIRED SKIN IAW EA.SDR SWAA2014032426470Frame · corrodedFRAME CORRODED AT BS 1006, BETWEEN STRINGER 17R TO STRINGER 20R. R & R FRAME IAW SRM & DWG.SDR SWAA2014032426452Stringer · corrodedSTRINGER SECTION CORRODED BETWEEN BS 1006 TO BS 1016, STRINGER 26R. R & R STRINGER IAW SRM & DWG.SDR SWAA2014032426385Stiffener · crackedSTIFFENER CRACKED AT BS 727, LBL 45.5. R & R STIFFENER IAW SRM & DWG.SDR SWAA2014032426384Stiffener · crackedSTIFFENER CRACKED AT BS 727, RBL 45.5. R & R STIFFENER IAW SRM & DWG.SDR SWAA2014032426383Stiffener · crackedAFT FACE OF PRESS BULKHEAD STIFFENER CRACKED AT BS 727, STRINGER 27R. R & R STIFFENER IAW SRM & DWG.SDR SWAA2014032426382Stiffener · crackedAFT FACE OF PRESS BULKHEAD STIFFENER CRACKED AT BS 727, STRINGER 27L. R & R STIFFENER IAW SRM & DWG.SDR SWAA2014032026250Tie Clip · crackedTIE CLIP CRACKED AT BS 380, STRINGER 21L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014031926230Stringer · crackedSTRINGER CRACKED AT BS 325.3, STRINGER 21R. REPAIRED STRINGER IAW SRM.SDR SWAA2014031726119Fastener · corrodedR1 DOOR EMERGENCY EVAC SLIDE HARDWARE CORRODED. R & R HARDWARE IAW SRM.SDR SWAA2014031225978Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 328, RBL 32. R & R ANGLE IAW SRM & DWG.SDR SWAA2014031225977Web · crackedWEB CRACKED BETWEEN BS 328 TO BS 344, LBL 47. R & R WEB IAW SRM & DRAWING.SDR SWAA2014031125955Web · crackedWEB CRACKED BETWEEN BS 312 TO BS 328, LBL 47. R & R WEB IAW SRM & DRAWING.SDR SWAA2014031125954Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 328+8, STRINGER 20L. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014031025881Support Angle · crackedSUPPORT ANGLE CRACKED BETWEEN BS 887 TO BS 907, RBL 45.5. R & R ANGLE IAW SRM.SDR SWAA2014031025880Tie Clip · crackedTIE CLIP CRACKED AT BS 380, STRINGER 23L. R & R TIE CLIP IAW SRM & DRAWING.SDR SWAA2014031025879Tie Clip · crackedTIE CLIP CRACKED AT BS 380, STRINGER 22L. R & R TIE CLIP IAW SRM & DRAWING.SDR SWAA2014031025878Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 312+8, STRINGER 20L. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014031025877Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 328, STRINGER 20L. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014040126723Skin · crackedL1 DOOR SKIN CUT OUT CRACKED AT BS 303.9+6, STRINGER 6L+3. REPAIRED SKIN IAW SRM.SDR SWAA2014033126653Tee Fitting · crackedAFT CARGO COMPARTMENT DOOR T CHORD CRACKED AT AFT END OF CROSSBEAM E OF THE AFT CARGO COMPARTMENT DOOR. REPAIRED T CHORD IAW EA.SDR SWAA2014033126652Tee Fitting · crackedAFT CARGO COMPARTMENT DOOR T CHORD CRACKED. REPAIRED T CHORD IAW EA.SDR SWAA2014033126640Reveal · crackedR1 DOOR UPPER AFT CORNER REVEAL CORNER CRACKED. R & R REVEAL IAW SRM & DWG.SDR SWAA2014032826603Stiffener · corrodedFUSELAGE STIFFENER CORRODED AT STATION 1016, BL 0. REPAIRED STIFFENER IAW EA.SDR SWAA2014032826598Structure · crackedT CHORD CRACKED AT RT STATION 243.2, WL 168.6. REPAIRED CHORD IAW EA.SDR SWAA2014032626514Floor Support · crackedLONGITUDINAL FLOORBEAM CRACKED AT BS 312, RBL 20. REPAIRED FLOORBEAM IAW SRM.SDR SWAA2014032426420Angle · crackedFORWARD CARGO COMPARTMENT ANGLE CRACKED BETWEEN BS 500D TO BS 520 & BL 0. R & R ANGLE IAW SRM & DWG.SDR SWAA2014032426381Angle · crackedRT WING NR 7 MOVABLE FLAP TRACK ANGLE CRACKED. R & R ANGLE IAW SRM.
Back to Boeing 737-3H4