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 SWAA2013021912822Cover Plate · looseRIGHT (F/O SIDE) OVERWING EMERGENCY EXIT SIGN COVER PLATE CAME OFF IN FLIGHT. WOULD NOT REMAIN IN PLACE. SECURED OVERWING EMERGENCY EXIT SIGN COVER PLATE REF M/M.SDR SWAA2013022813161Web · crackedCRACK ON WEB OF NLG WHEEL WELL AT BS 243.7+3.5" AND WL 169.1 RIGHT SIDE. REMOVED AND REPLACED WEB IAW SRMSDR SWAA2013031113526Shear Tie · corrodedCORROSION ON SHEAR TIE AT BS 344, BETWEEN STR 26R AND STR 27R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA2013030413278Angle · crackedCRACK ON VERTICAL ANGLE (STANCHION ASSY) LOCATED BS 294 STR 26R. REMOVED AND REPLACED ANGLE PER SRM AND DWG.SDR SWAA2013030413277Angle · crackedCRACK ON VERTICAL ANGLE (STANCHION ASSY) LOCATED ON BS 294 STR 25L. REMOVED AND REPLACED ANGLE PER SRM AND DWG.SDR SWAA2013030413276Angle · crackedCRACK ON VERTICAL ANGLE (STANCHION ASSY) LOCATED ON BS 312.5 STR 25L. REMOVED AND REPLACED ANGLE PER SRM AND DWG.SDR SWAA2013022813160Angle · crackedCRACK ON ANGLE LOCATED BETWEEN BS 312 TO BS 344, LBL 58. REMOVED AND REPLACED ANGLE IAW SRM.SDR SWAA2013022813159Strap · crackedCRACK ON STRAP LOCATED BS 328, RBL 33. REMOVED AND REPLACED STRAP IAW SRM.SDR SWAA2013022813158Angle · crackedCRACK ON ANGLE LOCATED AT BS 336 AT LEVEL S-20L. REMOVED AND REPLACED ANGLE IAW SRM.SDR SWAA2013022513066Web · crackedCRACK ON WEB LOCATED BETWEEN BS 360 TO BS 351.2 BL 0 INTERNAL AREA OF E/E COMPARTMENT. REPLACED WEB IAW SRM AND DRAWING.SDR SWAA2013022112947Strap · crackedCRACK ON STRAP LOCATED BS 312 AND BL 0 AT FLOOR STRUCTURE OF E/E COMPARTMENT. REPLACED STRAP LOCATED BS 312-12" TO BS 344+12" AND BL 0 AT FLOOR STRUCTURE OF E/E COMPARTMENT IAW B737-300 SRM 51-10-02 ITEM 8, SRM 51-40-02 AND DWG 65-45834.SDR SWAA2013022012929Attach Fitting · crackedPASSENGER CABIN STATION 294.5 S13L FRAME ATTACH CLIP IS CRACKED ON FWD SIDE OF 294 FRAME. NEW CLIP WAS ORDERED, DRILLED AND INSTALLED IAW SRM 51-40-02 AND BOEING DWG.SDR SWAA2013031113525Web · crackedMLG W/W WEB CRACKED AT BS 663.75, RBL 24. REPAIRED WEB PER EA.SDR SWAA2013030713429Pressure Deck · crackedCRACK INDICATION FOUND ON MAIN WHEEL WELL PRESSURE DECK LOCATED BS 663.75+1.5", RBL 45.5-6.0". REPAIRED WEB IAW SRM.SDR SWAA2013030713428Pressure Deck · crackedCRACK INDICATION FOUND ON MAIN WHEEL WELL PRESSURE DECK LOCATED BS 663.75+8.5", RBL 45.5-3.5". REPAIRED WEB IAW SRM.SDR SWAA2013030413314Floorbeam · corrodedCORROSION ON FLOORBEAM LOCATED BS 294.5 AND BETWEEN LBL 7 TO RBL 47 IN FLOOR STRUCTURE FWD CABIN. REPAIRED CHORD IAW SRM.SDR SWAA2013030113227Angle · crackedRIGHT Z-ANGLE, STATION 500, CRACKED AT FASTENER HOLE COMMON TO FRAME. REMOVED AND REPLACED Z-ANGLE IAW SRM AND BOEING DWG.SDR SWAA2013022813179Pressure Deck · crackedPRESSURE DECK IS CRACKED AT STATION 663+9", LBL 39.75". REPAIRED WEB IAW EA.SDR SWAA2013022713134Frame · crackedCRACK ON FRAME LOCATED BS 294.5 AND BETWEEN STR 2R TO STR 3R. REPAIRED FRAME PER SRM.SDR SWAA2013022713133Web · crackedCRACK ON WEB LOCATED AT BS 312 AND LBL 45. REPLACED WEB IAW SRM AND DWG.SDR SWAA2013022713132Angle · crackedCRACK ON ANGLE LOCATED BS 328 AND LBL 46. REPLACED ANGLE IAW SRM AND DRAWING.SDR SWAA2013022713130Angle · crackedCRACK ON ANGLE LOCATED AT CENTER POSITION OF SHELF E1-3. REPLACED ANGLE IAW SRM AND DRAWING.SDR SWAA2013022513083Strip · debondedLEFT WING L/E ACCESS PANEL 6226, FWD EDGE DELAMINATED. DISBONDED STRIP IAW SRM.SDR SWAA2013022513082Strip · debondedLEFT WING L/E ACCESS PANEL 6231 DELAMINATED AT 2 EA LOCATIONS ON FWD EDGE. REBONDED STRIP IAW SRM.SDR SWAA2013022513065Floorbeam · corrodedCORROSION ON FLOORBEAM LOCATED BS 360 AND AT LEVEL BL 0 IN FLOOR STRUCTURE FWD CABIN. REPAIRED CHORD IAW SRM.SDR SWAA2013022513061Angle · crackedCRACK ON ANGLE LOCATED BS 328 AND AT LEVEL RBL 32 IN FLOOR STRUCTURE FWD CABIN. REPLACED ANGLE IAW SRM AND DRAWING.SDR SWAA2013022513045Floorbeam · corrodedCORROSION ON FLOORBEAM LOCATED BS 312 AND AT LEVEL RBL 34 IN FLOOR STRUCTURE FWD CABIN. REPAIRED FLOORBEAM IAW SRM.SDR SWAA2013022513076Floorbeam · corrodedCORROSION ON EXISTING REPAIR FLOORBEAM LOCATED BS 312 AND BETWEEN RBL 23 TO LBL 18.5 IN FLOOR STRUCTURE FWD CABIN. REPAIRED FLOORBEAM PER SRM.SDR SWAA2013022112961Curtain · crackedLEFT WING L/E, NR 1 SLAT CURTAIN IS CRACKED. REMOVED AND REPLACED LEFT WING L/E NR 1 SLAT CURTAIN IAW AMM 27-81-51-004-001 AND AMM 27-81-51-404-008.SDR SWAA2013022112960Strap · crackedRIGHT NR 6 FLAP DRIVE, INBOARD FLAP WEAR STRAP INSIDE FAIRING CRACKED. REPLACED INBOARD FLAP WEAR STRAP AT NR 6 FLAP DRIVE INSIDE FAIRING IAW SRM 51-40-02 AND DWG 65C26300.SDR SWAA2013022012900Lens · crackedFLIGHT ATTENDANT REPORTS RIGHT OVERWING DOOR EXIT SIGN LENS CRACKED. REMOVED AND REPLACED SAID LENS PER MM.SDR SWAA2013021912752Web · crackedCRACK ON WEB LOCATED BS 328 AND LBL 45 FLOOR STRUCTURE PAX CABIN. REPLACED WEB LOCATED BS 328 AND LBL 45 FLOOR STRUCTURE PAX CABIN IAW SRM B737-300 51-40-02, 51-10-02 ITEM 8 AND DWG 65-45834.SDR SWAA2013021912749Cover · out of positionFWD ENTRY DOOR EMERGENCY EVACUATION SLIDE- MANUAL INFLATION HANDLE FLAP COVER NOT POSITIONED PROPERLY. REPOSITIONED MANUAL INFLATION HANDLE FLAP COVER ON FWD ENTRY & FWD SERVICE DOOR EMERGENCY EVAC SLIDES PER MM.SDR SWAA2013021912745Cover · out of positionSERVICE ENTRY DOOR EMERGENCY EVACUATION SLIDE- MANUAL INFLATION HANDLE FLPA COVER NOT POSITIONED PROPERLY. REPOSITIONED MANUAL INFLATION HANDLE FLAP COVER ON FWD ENTRY & FWD SERVICE DOOR EMERGENCY EVAC SLIDES PER MM.SDR SWAA2013021912838Attach Bracket · crackedRIGHT AILERON WING TRAILING EDGE FIXED I/B CLOSE OUT PANEL (O/B) ATTACH BRACKET IS CRACKED (FLAGGED). REMOVED ATTACH BRACKET AT RIGHT AILERON WING T/E FIXED I/B CLOSE OUT PANEL IAW 8737-300 SRM 51-40-02. LOCATED AND DRILLED NEW ATTACH BRACKET P/N GS-46460-47SDR SWAA2013021912837Shear Tie · corrodedFORWARD CARGO COMPARTMENT, STATION 500C, FRAME, SHEAR TIE BETWEEN STRINGER 26 LEFT AND STRINGER 27 LEFT, CORRODED. REMOVED FASTENERS COMMON TO SHEAR TIE AND TBS 500C BTWEEN STR 26L AND NO27L IAW B737-300 SRM 51-40-02. REMOVED CORROSION COMMON TO SHEAR TIE ATSDR SWAA2013021812732Gasper Fan · faultyACRID SMELL IN CENTER OF CABIN DIVERTED TO SDF. VISIBLE HAZE IN CABIN. SMELLED ELECTRICAL. REMOVED AND REPLACED GASPER FAN PER M/M, OPS CHECKS GOOD.SDR SWAA2013031113522Skin · crackedRIGHT WING LEFT SKIN CRACKED AT STA 208. REPAIRED SKIN PER EA.SDR SWAA2013031113521Skin · crackedFUSELAGE SKIN CRACKED AT BS 360, BETWEEN STR 3L & STR 4L. REPAIRED SKIN PER SRM & EA.SDR SWAA2013030813453Support Angle · crackedSUPPORT ANGLE INTERNAL STRUCTURE OF FWD CARGO DOOR CRACKED. REMOVED AND REPLACED DOOR PER MM.SDR SWAA2013030413308Attach Fitting · crackedFRAME TO INTERCOSTAL ATTACH CLIP CRACKED AT STATION 500C, BETWEEN STRINGERS 25 LEFT AND 26 LEFT. REMOVED AND REPLACED CLIP IAW SRM & DWG.SDR SWAA2013022713131Web · crackedCRACK ON WEB BETWEEN BS 277 TO BS 291.5, STR 14R. REPLACED WEB IAW SRM AND DWG.SDR SWAA2013022513086Stiffener · crackedFLOORBEAM STA 328 RBL 30, FLOORBEAM WEB VERTICAL STIFFENER CRACKED AT LOWER END. REMOVED AND REPLACED STIFFENER IAW SRM AND BOEING DWG.SDR SWAA2013022513043Angle · crackedCRACK ON ANGLE LOCATED BS 277 TO BS 291.5 AND BETWEEN STR 12R TO STR 13R IN FWD GALLEY DOOR CUTOUT STRUCTURE. REPLACED ANGLE IAW SRM AND DRAWING.SDR SWAA2013022513042Angle · crackedCRACK ON ANGLE LOCATED BS 294.5+2" AND AT LEVEL STR 7R IN FWD GALLEY DOOR CUTOUT STRUCTURE. REPLACED ANGLE IAW DRAWING.SDR SWAA2013022012922Strap · crackedE&E COMPARTMENT, LOWER FLOORBEAM STA 312 RBL 46, FLOOR STIFFENER STRAP CRACKED, MARKED. REMOVED AND REPLACED FLOOR STIFFENER E+E COMPARTMENT AT LOWER FLOORBEAM STA 312 RBL 46 IAW SRM 51-40-02 AND DWG 65-45834. APPLIED CIC TO REPAIR AREA IAW AMM 51-21-91.SDR SWAA2013021912751Angle · crackedCRACK ON ANGLE LOCATED AT TRAILING EDGE WBL 204.4 OUTBOARD SIDE OF FAIRING RIGHT WING. REPLACED ANGLE LOCATED AT TRAILING EDGE WBL 204.40 OUTBOARD SIDE OF FAIRING RIGHT WING IAW SRM B737-300 51-10-02 ITEM 8, 51-40-02 AND DRAWING 65C26300.SDR SWAA2013021912821Rivet · crackedPILOT WINDOW FRAME BETWEEN NR 1 AND NR 2 WINDOWS HAS CRACKED RIVIT AT TOP OF FRAME. REMOVED CRACKED RIVET & INSTALLED NEW RIVET AT UPPER MOST FASTENER HOLE COMMON TO SKIN & NR 1 WINDOW FRAME IAW SRM 51-40-02 AND DWG 05-86040.SDR SWAA2013021812739Wire · disconnectedFOUND FWD GALLEY RIGHT SLIDE EMERGENCY LIGHT INOP. FOUND WIRES DISCONNECTED DISPLACED FWD GALLEY FOM RESTORED WIRES REINSTALLED FWD GALLEY PER MM OPS CHECK EMERGENCY LIGHT CHECK GOOD.SDR SWAA2013030813452Stiffener · crackedVERTICAL STIFFENER CRACKED AT BS 663.75, RBL 6.15. REPAIRED VERTICAL STIFFENER PER EA.
Back to Boeing 737-3H4