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 SWAA2012091307573Lens · missingLEFT OVERHEAD EMERGENCY EXIT LIGHT LENS MISSING AT ROW 6. INSTALLED LENS PER M/M.SDR SWAA2012092107848Stiffener · crackedVERTICAL STIFFENER CRACKED AT BS 727 BULKHED I/B SIDE OF RIGHT KEEL BEAM. REMOVED & REPLACED STIFFENER PER SRM & DWG.SDR SWAA2012091207539Light · inoperativeL1 DOOR LOWER EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT ASSY PER M/M.SDR SWAA2012091207532Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 747, STR 16R. REMOVED AND REPLACED CLIP IAW DWG.SDR SWAA2012092507941Shear Tie · corrodedSHEAR TIE CORRODED AT BS 500, BETWEEN STR 28L TO STR 28R. REMOVED AND REPLACED SHEAR TIE IAW SRM AND DWG.SDR SWAA2012092107833Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 540, STR 24L. REMOVED AND REPLACED ANGLE IAW SRM AND DWG.SDR SWAA2012091007444Light · inoperativeRIGHT EMERGENCY EXIT SIDEWALL DOOR LIGHT LAMP INOP. REMOVED AND REPLACED LAMP IAW AMM.SDR SWAA2012091007442Lens · brokenEMERGENCY EXIT LIGHT LENS BROKEN ON FWD LAV. REMOVED & REPLACED LENS PER MM.SDR SWAA2012091007441Slide · out of positionL1 DOOR EMERGENCY EVAC SLIDE OUT OF POSITIONING. REPOSITIONED SLIDE PER MM.SDR SWAA2012091707675Stringer Clip · corrodedSTRINGER CLIP CORRODED AT BS 867, STR 27R. REMOVED AND REPLACED CLIP IAW BAC DWG AND SRM.SDR SWAA2012091107519Cover · out of positionL1 DOOR EMERGENCY EXIT LIGHT COVER CAME OFF. RE-INSTALLED COVER IAW AMM.SDR SWAA2012091107505Stiffener · crackedRIGHT HORIZONTAL STABILIZER RIB AT STA 92.7 VERTICAL STIFFENER CRACKED. REMOVED AND REPLACED STIFFENER PER BAC DWG.SDR SWAA2012092407915Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 500B+10 WINDOW FORGING UPPER FORWARD CORNER CRACKED. REMOVED AND REPLACED SKIN IAW BAC DWG.SDR SWAA2012092107827Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 400, STR 16R. REMOVED AND REPLACED CLIP IAW DWG.SDR SWAA2012091707633Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 500B, STR 16L. REMOVED AND REPLACED CLIP IAW SRM & DWG.SDR SWAA2012091407601Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 500B, STR 16R. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA2012091407600Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 500A, STR 16R. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA2012092607994Shear Tie · crackedSHEAR TIE CRACKED AT BS 500A, STR 16L. REMOVED AND REPLACED SHEAR TIE IAW SRM AND DWG.SDR SWAA2012091707693Slat · damagedLEFT WING NR 2 SLAT I/B SLAT CAN DAMAGED BY FOD. REMOVED AND REPLACED SLAT CAN IAW BAC DWG.SDR SWAA2012091707692Slat · damagedLEFT WING NR 2 SLAT O/B CAN DAMAGED BY FOD. REMOVED AND REPLACED SLAT CAN IAW BAC DWG.SDR SWAA2012091707648Flap · puncturedRIGHT WING INBOARD FORE FLAP PUNCTURED. REPAIRED FORE FLAP IAW SRM.SDR SWAA2012091707632Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 500, STR 16L. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA2012091707631Shear Tie · crackedSHEAR TIE CRACKED AT BS 500A, BETWEEN STR 15L TO STR 16L. REMOVED AND REPLACED SHEAR TIE IAW SRM.SDR SWAA2012091707630Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 400A, STR 16L. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA2012091307580Crease Beam · corrodedLEFT CREASE BEAM WEB CORRODED BETWEEN BS 827 TO BS 847. REMOVED AND REPLACED WEB IAW SRM.SDR SWAA2012091307572Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 908, STR 4L. REMOVED & REPLACED CLIP IAW SRM & DWG.SDR SWAA2012091107520Uplock Sensor · faultyAIR TURNBACK, ON TAKEOFF, GEAR HANDLE IN UP POSITION, LEFT MAIN INLOCKED LIGHT ILLUMINATED AND WOULD NOT EXTINGUISH. LOWERED & RAISED GEAR AGAIN ALL LIGHTS EXTINGUISHED & HAD NORMAL INDICATIONS. REMOVED AND REPLACED LEFT UP & LOCKED SENSOR PER M/M.SDR SWAA2012091007494Spindle · corrodedNR 2 FLAP CARRIAGE SPINDLE CORRODED. REMOVED AND REPLACED NR 2 SPINDLE PER MT.SDR SWAA2012091007492Skin · crackedFUSELAGE SKIN CRACKED AT BS 360 + 12.5, STR 8L. REPAIRED SKIN IAW ARR EA AND EA.SDR SWAA2012091007480Web · crackedLEFT NOSE WHEEL WELL WEB CRACKED AT BS 259, WL 174. REPAIRED WEB PER EA.SDR SWAA2012091007468Lens · looseRIGHT FWD GALLEY EMERGENCY EXIT SIGN LIGHT LENS LOOSE. SECURED LENS PER M/M.SDR SWAA2012100108144Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 847+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012100108143Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 847+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012100108142Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 787 +10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012100108141Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 380 +10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012100108140Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 727+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012100108139Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 460 +10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012100108138Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 440 +10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012100108137Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 500A +10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012100108136Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 380+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012100108135Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 500B +10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012100108132Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 360 +10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012100108131Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 520 +10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012100108130Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 420 +10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012100108129Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 520 +10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012100108127Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 500C +10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012100108126Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 360 +10 LOWER AFT WINDOW CORNER CUTOUT. EPAIRED SKIN IAW EA.SDR SWAA2012100108125Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 520 +10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012092608023Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 867+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012092608022Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 827+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.
Back to Boeing 737-3H4