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 SWAA2014061228991Attach Fitting · crackedAFT CARGO BAY ATTACH FITTING CRACKED AT BS 727, LBL 45.5. R & R FITTING IAW SRM.SDR SWAA2014061228990Frame · crackedAFT CARGO BAY FRAME CRACKED AT BS 947.5, STRINGER 19L. R & R FRAME IAW DWG & SRM.SDR SWAA2014060928839Angle · corrodedAFT CARGO BAY ON FLOOR SUPPORT REPAIR ANGLE CORRODED AT BS 772, RBL 7.5. REPAIRED ANGLE IAW EA.SDR SWAA2014060928838Floorbeam · crackedMAIN DECK FLOORBEAM UPPER FLANGE FWD SIDE CRACKED AT BS 947.5, LBL 53. REPAIRED CHORD IAW EA.SDR SWAA2014052128224Sign · brokenFORWARD ENTRY LOWER EMERGENCY EXIT SIGN BROKEN. R & R SIGN ASSEMBLY IAW MM.SDR SWAA2014060928845Floor Support · crackedLONGITUDINAL FLOORBEAM WEB CRACKED AT BS 616, LBL 45.5. REPAIRED WEB IAW EA.SDR SWAA2014060928844Floor Support · crackedLONGITUDINAL FLOORBEAM WEB CRACKED AT BS 615, LBL 45.5. REPAIRED WEB IAW EA.SDR SWAA2014060928817Skin · crackedRIGHT HORIZONTAL STABILIZER LOWER IN SPAR SKIN CRACKED AT REAR SPAR STAB BETWEEN STATION 120 TO STATION 129. REPAIRED SKIN IAW EA.SDR SWAA2014052928468Angle · crackedDOOR STOP FITTING LWR OTBD FRAME AFT ANGLE CRACKED AT BS 348.2, STRINGER 15L. R & R ANGLE IAW SRM & DWG.SDR SWAA2014052928467Angle · crackedDOOR STOP FITTING LOWER INBD HOLE FRAME AFT ANGLE CRACKED AT BS 348.2, STRINGER 14L. R & R ANGLE IAW SRM.SDR SWAA2014052128233Pump · faultyNR 2 N1 IN CLIMB POWER GOING .6% UP TO .6% BELOW CLIMB POWER BRING BACK POWER A LITTLE & N1 WAS NORMAL. R & R NR 2 ENG FUEL PUMP IAW MT.SDR SWAA2014052128195Skin · crackedDURING CROWN SKIN CRACKED AT BS 446, STRINGER 10L. REPAIRED SKIN IAW EA.SDR SWAA2014061929197Pressure Panel · crackedMAIN WW PRESS WEB CRACKED AT BS 663.75, RBL 45.50. REPAIRED WEB IAW EA.SDR SWAA2014061829161Frame · crackedFRAME CRACKED AT BS 348.2, STRINGER 16L. REPAIRED FRAME IAW EA & ER.SDR SWAA2014061829160Pressure Panel · crackedMAIN WW PRESS WEB CRACKED AT BS 663.75, LBL 24.50. REPAIRED WEB IAW SRM.SDR SWAA2014061228989Strap · crackedEND OF TIE STRAP CRACKED AT BS 347.5, STRINGER 16L. R & R TIE STRAP IAW SRM.SDR SWAA2014061228988Angle · crackedANGLE CRACKED AT BS 348.2, STRINGER 15L. R & R ANGLE IAW SRM & DWG.SDR SWAA2014052928458Stiffener · crackedAFT PRESS BULKHEAD Z STIFFENER CRACKED AT BS 1016, STRINGER 15L. REPAIRED Z STIFFENER IAW EA.SDR SWAA2014052928457Doubler · delaminatedLEFT WING NR 2 SLAT OTBD TE DOUBLER WEDGE UPPER CORNER REPAIR DELAMINATED. REPAIRED DOUBLER IAW SRM.SDR SWAA2014052728345Support Fitting · crackedSUPPORT CLIP CRACKED AT BS 348.2, STRINGER 16L. R & R CLIP IAW SRM & DWG.SDR SWAA2014052328299Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 307 TO BS 307.5, STRINGER 2L. REPAIRED SKIN IAW SRM.SDR SWAA2014052328304Angle · crackedVERTICAL ANGLE CRACKED AT BS 328, RBL 31.6. REPAIRED ANGLE IAW SRM & DWG.SDR SWAA2014051928103Plate · damagedR2 DOOR EMERGENCY EVAC SLIDE FLOOR BRACKETS ADAPTER PLATE DAMAGED. R & R PLATE IAW AMM.SDR SWAA2014051928119Lens · looseLEFT OVERWING EMERGENCY EXIT SIGN LENS LOOSE. SECURED LENS IAW SIP.SDR SWAA2014051928118Slide · out of positionR1 DOOR EMERGENCY EXIT SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW MT.SDR SWAA2014051928117Slide · unsecureL1 DOOR EMERGENCY EVAC SLIDE INADVERTENTLY FELL OUT OF CONTAINER, DID NOT DEPLOY, STILL OPERATIONAL. REINSTALLED SLIDE IAW MT.SDR SWAA2014061829159Structure · crackedRIGHT OTBD CHORD CRACKED AT BS 727, STRINGER 18A. REPAIRED CHORD IAW ER & EA.SDR SWAA2014061329026Angle · crackedLEFT WING TE 2ND SWEEPER WEB OUT FROM INBD END FOR AILERON OTBD ATTACH ANGLE CRACKED. R & R ANGLE IAW SRM.SDR SWAA2014060928816Attach Angle · crackedRIGHT WING TE 2ND SWEEPER WEB OUT FROM INBD END FOR AILERON OTBD ATTACH ANGLE CRACKED. R & R ANGLE IAW SRM.SDR SWAA2014060328653Latch · crackedL2 DOOR AFT SIDE EMER EXIT HATCH LATCH CRACKED. R & R LATCH IAW CMM.SDR SWAA2014053028520Fitting · crackedRIGHT WING NR 5 SPOILER OTBD FITTING CRACKED. R & R FITTING IAW SRM & DWG.SDR SWAA2014052928463Channel · crackedSTRINGER SPLICE CHANNEL CRACKED AT BS 360, STRINGER 15L. R & R CHANNEL IAW SRM & DWG.SDR SWAA2014052928456Skin · corrodedAFT CARGO COMPARTMENT EQUIPMENT BAY SKIN CORRODED AT BS 1006, BETWEEN STRINGER 27L TO 27R. REPAIRED SKIN IAW EA.SDR SWAA2014052728344Angle · crackedATTACHMENT CLIP ANGLE CRACKED AT BS 348.2, STRINGER 15L. R & R ANGLE IAW SRM & DWG.SDR SWAA2014052728330Support Angle · crackedBULKHEAD NOSE WW INTERNAL AREA SUPPORT ANGLE CRACKED AT BS 294.5, STRINGER 23L. R & R ANGLE IAW SRM & DWG.SDR SWAA2014052728328Frame · crackedFRAME CRACKED AT BS 348.2, BETWEEN STRINGER 13L TO STRINGER 17L. R & R FRAME IAW EA.SDR SWAA2014052328303Tie Clip · crackedTIE CLIP CRACKED AT BS 380, STRINGER 26L. R & R TIE CLIP IAW SRM.SDR SWAA2014061929196Door Frame · crackedR1 DOOR AFT FRAME CRACKED INBD SIDE OF NR 3 STOP PIN FITTING DOWN FROM TOP. REPAIRED FRAME IAW ER & EA.SDR SWAA2014061829173Fitting · corrodedSPLICE FITTING CORRODED AT BS 663, LT WING WL 71.24. R & R FITTING IAW EA & DWG.SDR SWAA2014061829172Fitting · corrodedLEFT WW BULKHEAD FITTING CORRODED AT BS 663, WL 71.24. REPAIRED FITTING IAW EO & EA.SDR SWAA2014061829158Frame · crackedBS 639 LT FRAME INBD CHORD CRACKED AT WL 216. REPAIRED CHORD IAW EA.SDR SWAA2014061228987Beam · crackedLONGITUDINAL BEAM WEB CRACKED AT BS 639, LBL 45.5. REPAIRED WEB IAW ER & EA.SDR SWAA2014060928815Holder · looseR1 DOOR EMER EVAC SLIDE SHROUD FWD & AFT GIRT BAR STOW HOLDERS LOOSE. SECURED HOLDER IAW EA.SDR SWAA2014052928470Cover · crackedAFT CARGO DOOR AFT CUT OUT COVER CRACKED. R & R COVER IAW SRM & DWG.SDR SWAA2014052728343Stiffener · crackedRIGHT WING NR 6 AFT FAIRING LOWER AREA STIFFENER CRACKED. R & R STIFFENER IAW SRM & DWG.SDR SWAA2014052728342Stiffener · crackedRIGHT WING NR 6 AFT FAIRING INTERNAL AREA INBD STIFFENER CRACKED. R & R STIFFENER IAW SRM & DWG.SDR SWAA2014052728341Angle · crackedRIGHT WING NR 6 AFT FAIRING INTERNAL AREA UPPER STRUCTURE ANGLE CRACKED. R & R ANGLE IAW SRM & DWG.SDR SWAA2014052728340Support Angle · crackedRACK E1 EQUIPMENT ELECTRONIC COMPARTMENT SUPPORT ANGLE CRACKED. R & R ANGLE IAW SRM & DWG.SDR SWAA2014052728333Frame · corrodedFRAME CORRODED AT BS 827, BETWEEN STRINGER 27R TO STRINGER 27L. REPAIRED FRAME IAW SRM.SDR SWAA2014052128216Support Fitting · crackedSUPPORT CLIP CRACKED AT BS 328+8, BETWEEN STRINGER 20L TO STRINGER 21L. R & R CLIP IAW SRM & DWG.
Back to Boeing 737-3H4