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 SWAA2013060316688Tie Clip · crackedTIE CLIP CRACKED AT BS 380, STR 8L. R & R TIE CLIP IAW SRM AND DWG.SDR SWAA2013060316677Bulkhead · crackedVERTICAL BEAM WEB CRACKED AT BS 178, LBL 5.7. REPAIRED WEB IAW SRM.SDR SWAA2013052816533Slide · out of limitsR2 DOOR EMERGENCY EVAC SLIDE ASSY PRESSURE OUT OF LIMITS. R & R SLIDE ASSY IAW MT.SDR SWAA2013070918052Skin · crackedAFT ENTRY DOOR FWD LOWER CORNER CUT OUT CRACKED AT BS 951.0+ 5.75, STRINGER 17L. REPAIRED SKIN IAW SRM.SDR SWAA2013070818020Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 787+1, STRINGER 18R. REPAIRED ANGLE IAW EO & EA.SDR SWAA2013070817995Plate · corrodedL2 DOOR EMERGENCY EVAC SLIDE GIRT BAR PLATE & HARDWARE CORRODED. R&R PLATE & HARDWARE IAW AMM.SDR SWAA2013070817994Skin · crackedFWD GALLEY DOOR AFT LOWER CORNER DOOR CUT OUT CRACKED AT BS 332.1, STRINGER 17R. REPAIRED SKIN IAW SRM.SDR SWAA2013070817993Support Angle · crackedLT WING SUPPORT ANGLE CRACKED FLAP AREA INTERNAL CAVITY FSS 194. R&R ANGLE IAW SRM & DRAWING.SDR SWAA2013070817992Pressure Deck · crackedMAIN WHEEL WELL PRESSURE DECK WEB CRACKED AT BS 664.75, LBL 39. REPAIRED WEB IAW EO & EA.SDR SWAA2013070817989Plate · corrodedR2 DOOR EMERGENCY EVAC SLIDE GIRT BAR PLATE & HARDWARE CORRODED. R&R PLATE & HARDWARE IAW AMM.SDR SWAA2013070417930Plate · corrodedLT 1 DOOR EMERGENCY EVAC SLIDE GIRT BAR FITTING PLATES CORRODED. R&R PLATES IAW MM.SDR SWAA2013070417929Skin · crackedRT WING EXTERNAL SKIN OF FIXED LEADING CRACKED AT LEVEL WBL 208. REPAIRED SKIN IAW EA.SDR SWAA2013070417913Plate · corrodedRT 2 DOOR EMERGENCY EVAC SLIDE GIRT BAR FITTING PLATES CORRODED. R&R PLATES IAW MM.SDR SWAA2013070317883Frame · corrodedFRAME LOWER FLANGE CORRODED AT BS 907, BETWEEN STRINGER 27R & STRINGER 27L. REPAIRED FLANGE IAW SRM & DRAWING.SDR SWAA2013070117783Beam · crackedSTUB BEAM CRACKED AT BS 706, LBL 46. REPAIRED WEB IAW EO & EA.SDR SWAA2013062817724Angle · corrodedL1 DOOR LOWER SILL Z ANGLE CORRODED BETWEEN BS 312 - BS 360, LBL 60.5. R&R "Z" ANGLE IAW SRM & DRAWING.SDR SWAA2013062817723Floorbeam · crackedFLOOR BEAM UPPER CHORD CRACKED AT BS 312, BETWEEN RBL 13 - RBL 39. REPAIRED CHORD IAW SRM.SDR SWAA2013062517589Floorbeam · corrodedFLOOR BEAM UPPER CHORD CORRODED AT BS 312, RBL 14. REPAIRED CHORD IAW SRM.SDR SWAA2013062517511Angle · crackedFLOOR BEAM UPPER CHORD REINFORCEMENT ANGLE CRACKED AT BS 328, RBL 58. R&R ANGLE IAW SRM & DRAWING.SDR SWAA2013062517524Sill · crackedFWD GALLEY DOOR SILL WEB CRACKED. R&R WEB IAW SRM & DRAWING.SDR SWAA2013062017438Actuator · brokenRT WING GROUND SPOILER OUTBOARD ACTUATOR BROKEN. R & R ACTUATOR IAW AMM.SDR SWAA2013061917379Angle · crackedRT WING T/E ANGLE CRACKED AT WBL 191. R & R ANGLE IAW SRM AND DWG.SDR SWAA2013061917382Bracket · crackedFWD CARGO COMPARTMENT BRACKET CRACKED AT BS 500D, STR 19L. R & R BRACKET IAW SRM AND DWG.SDR SWAA2013061917381Support Angle · crackedFWD CARGO COMPARTMENT SUPPORT ANGLE CRACKED AT BS 420, STR 26L. R & R ANGLE IAW SRM AND DWG.SDR SWAA2013061917380Web · crackedAFT CARGO COMPARTMENT WEB BRACKET CRACKED AT BS 727A, STR 25R. R & R WEB IAW SRM AND DWG.SDR SWAA2013061717191Angle · crackedRT WING OTBD T/E ANGLE CRACKED AT WBL 204. R & R ANGLE IAW SRM AND DWG.SDR SWAA2013060416754Support Angle · crackedLEFT WING SUPPORT ANGLE CRACKED AT RSS 545 INTERNAL STRUCTURE T/E. R & R ANGLE IAW SRM AND DWG.SDR SWAA2013052816532Lens · looseLT SIDE EMERGENCY EXIT SIGN LENS LOOSE. R & R COVER IAW MM.SDR SWAA2013052816531Lens · looseFORWARD ENTRY EMERGENCY EXIT SIGN COVER LOOSE. R & R LENS IAW MM.SDR SWAA2013052816530Light · inoperativeRT OVERWING EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT IAW AMM.SDR SWAA2013052816522Stringer Clip · crackedSTRINGER CLIP CRACKED AT STA 727E, STR 1. R & R CLIP IAW DWG & SRM.SDR SWAA2013052816496Lens · brokenAFT GALLEY EMERGENCY EXIT SIGN BROKEN. INSTALLED LENS IAW MM.SDR SWAA2013052816551Skin · crackedFWD ENTRY DOOR INNER SKIN CRACKED. R & R DOOR IAW AMM.SDR SWAA2013070417928Glowstrip · crackedCRACKED PHOTOLUMINSCENT STRIPS ALONG PAX CABIN. R&R EEPLS IAW AMM.SDR SWAA2013070317881Frame · corrodedFRAME LOWER FLANGE CORRODED AT BS 727E, BETWEEN STRINGER 27L & STRINGER 27R. REPAIRED FLANGE IAW SRM.SDR SWAA2013070317880Frame · corrodedFRAME LOWER FLANGE CORRODED AT BS 727D, BETWEEN STRINGER 25L & STRINGER 26L. REPAIRED FLANGE IAW SRM.SDR SWAA2013070317882Frame · corrodedFRAME LOWER FLANGE CORRODED AT BS 807, BETWEEN STRINGER 27L & STRINGER 27R. REPAIRED FRAME IAW SRM.SDR SWAA2013070217848Frame · corrodedLOWER FLANGE OF FRAME CORRODED AT BS 747, BETWEEN STRINGER 25L - STRINGER 26L. REPAIRED FRAME IAW SRM.SDR SWAA2013070217847Frame · corrodedLOWER FLANGE OF FRAME CORRODED AT BS 747, BETWEEN STRINGER 25L - STRINGER 26L. REPAIRED FRAME IAW SRM.SDR SWAA2013070117782Angle · crackedRT WING TO BODY FAIRING ANGLE CRACKED BETWEEN BS 685 + 10 TO BS 727, STRINGER 22R. R&R ANGLE IAW SRM.SDR SWAA2013070117781Frame · corrodedFRAME LOWER FLANGE CORRODED AT BS 787, BETWEEN STRINGER 26R & STRINGER 27R. REPAIRED FRAME IAW SRM.SDR SWAA2013070117809Frame · corrodedFRAME LOWER FLANGE CORRODED AT BS 787, BETWEEN STR 27L AND STR 27R. REPAIRED FRAME IAW SRM.SDR SWAA2013062717666Frame · corrodedFRAME LOWER FLANGE CORRODED AT BS 747, BETWEEN STRINGER 26L - STRINGER 27L. REPAIRED FRAME IAW SRM.SDR SWAA2013062617622Floorbeam · crackedFLOOR BEAM WEB CRACKED AT BS 328, LBL 60. R&R WEB IAW SRM & DRAWING.SDR SWAA2013062517588Frame · corrodedAFT CARGO COMPARTMENT LOWER FRAME CORRODED AT BS 787, BETWEEN STRINGER 25L - STRINGER 26L. REPAIRED FRAME IAW SRM.SDR SWAA2013062417499Support Angle · crackedLT ELEVATOR SUPPORT ANGLE CRACKED AT BS 121.59. R&R ANGLE IAW SRM & DRAWING.SDR SWAA2013061817280Support · crackedRIGHT WING UPPER SURFACE, 2 EA NYLON NUTPLATE SUPPORTS FOR PANEL 58710R CRACKED. R & R SUPPORTS IAW SRM AND DWG.SDR SWAA2013061717190Panel · crackedLEFT WING UPPER SURFACE PYLON NUTPLATE SUPPORT FOR PANEL NR 57710L CRACKED. R & R PANEL IAW SRM AND DWG.SDR SWAA2013061017004Plate · crackedRIGHT OVERWING FILLER PLATE FWD SIDE HATCH CUTOUT CRACKED. R & R PLATE IAW SRM.SDR SWAA2013060716893Support Angle · crackedLEFT WING SUPPORT STRUCTURE ANGLE CRACKED AT WBL 71.24. R & R ANGLE IAW SRM.
Back to Boeing 737-3H4