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 SWAA2012081306624Flap · delaminatedLEFT WING I/B AFT FLAP DELAMINATED. REMOVED AND REPLACED AFT FLAP PER M/M.SDR SWAA2012100308245Structure · crackedLEFT WING UPPER CHORD INTERNAL AREA OF FUEL TANK CRACKED AT WBL 114. REPAIRED CHORD IAW EO AND EA.SDR SWAA2012100308238Web · crackedLEFT WING WEB CRACKED INTERNAL AREA OF FUEL TANK, WBL 198.6. REPAIRED WEB IAW EA AND EO.SDR SWAA2012100108150Web · crackedRIGHT WING WEB CRACKED AT WBL 198.60. REPAIRED WEB IAW EA AND EO.SDR SWAA2012082807097Web · crackedWEB CRACKED BETWEEN BS 344+8 TO BS 360, BL 0. REMOVED AND REPLACED WEB IAW SRM AND DWG.SDR SWAA2012082707030Keelbeam · corrodedLEFT KEEL BEAM LOWER SURFACE CORRODED AT BS 720, LBL 8. REPAIRED BEAM IAW EA AND EO.SDR SWAA2012082707029Keelbeam · corrodedRIGHT KEEL BEAM LOWER SURFACE CORRODED AT BS 720, RBL 8. REPAIRED CHORD IAW EA AND EO.SDR SWAA2012082707021Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 328+8, STR 21L. REMOVED AND REPLACED ANGLE IAW SRM AND DWG.SDR SWAA2012082707020Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 328, STR 21L. REPLACED ANGLE IAW SRM AND DWG.SDR SWAA2012082306912Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 344+8.5, BETWEEN STR 25R TO STR 28R. REMOVED AND REPLACED ANGLE IAW SRM AND DWG.SDR SWAA2012082306911Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 312+8, STR 21L. REMOVED AND REPLACED ANGLE IAW SRM AND DWG.SDR SWAA2012081406684Spindle · corrodedLEFT WING O/B MID FLAP NR 1 SPINDLE CORRODED ON BOTTOM SIDE. REMOVED AND REPLACED NR 1 SPINDLE PER MT.SDR SWAA2012081306634Battery · dischargedRIGHT EEPLS INOP BETWEEN ROW 8 TO ROW 15. REMOVED AND REPLACED BATTERY IAW AMM.SDR SWAA2012100108169Stiffener · corrodedLEFT BULKHEAD WEB AND CHANNEL STIFFENER CORRODED AT BS 1016, BL 0. REPAIRED STIFFENER PER EA.SDR SWAA2012092107835Tie Clip · crackedTIE CLIP CRACKED AT BS 947.5, STR 25R. REMOVED AND REPLACED TIE CLIP IAW EO AND EA.SDR SWAA2012091807737Web · crackedRIGHT SIDE PANEL WEB OF THE NLG WHEEL WELL CRACKED BETWEEN BS 243.7 TO BS 251.6. REPAIRED WEB IAW EA AND EO.SDR SWAA2012082807096Support Angle · crackedSUPPORT ANGLE CRACKED BETWEEN BS 344 TO BS 360, BETWEEN STR 25R TO STR 27R. REMOVED AND REPLACED ANGLE IAW SRM AND DWG.SDR SWAA2012082707011Tie Clip · crackedTIE CLIP CRACKED AT BS 947.5, STR 24R. REMOVED TIE CLIP IAW SRM AND DWG.SDR SWAA2012081406699Spoiler · looseRIGHT WING INBOARD GROUND SPOILER LOOSE. REMOVED AND REPLACED NR 5 SPOILER PER MM.SDR SWAA2012081306661Battery · dischargedLEFT FWD EEPLS INOP. CHARGED EEPLS IAW AMM.SDR SWAA2012081306628Actuator · faultyAFTER TAKEOFF PUT LANDING GEAR LEVER UP AND RIGHT MAIN UNSAFE LIGHT REMAINED ILLUMINATED. CYCLED GEAR DOWN- 3 GREEN, NO RED RETRACTED GEAR AGAIN, RIGHT MAIN UNSAFE LIGHT REMAINED ILLUMINATED. REMOVED AND REPLACED RIGHT MLG UPLOCK ACTUATOR PER MM.SDR SWAA2012092407889Stringer Splice · corrodedSTRINGER SPLICE CORRODED AT BS 984, STR 23R. REMOVED AND REPLACED SPLICE IAW SRM AND DWG.SDR SWAA2012091907762Shear Tie · corrodedSHEAR TIE CORRODED AT BS 947.5, BETWEEN STR 24L TO STR 26L. REMOVED AND REPLACED SHEAR TIE IAW SRM AND DWG.SDR SWAA2012082707052Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 360+10 UPPER FORWARD CORNER CUTOUT. REMOVED AND REPLACED SKIN IAW BAC DWG.SDR SWAA2012082006838Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 847+10 UPPER AFT CORNER CUTOUT. REMOVED AND REPLACED SKIN IAW BAC DWG.SDR SWAA2012081306656Flap · delaminatedLEFT WING O/B FORE FLAP DELAMINATED. REMOVED AND REPLACED FORE FLAP PER M/M.SDR SWAA2012081306648Light · inoperativeR2 DOOR LOWER EMERGENCY EXIT SIGN BULBS INOP. RELAMPED SIGN PER M/M.SDR SWAA2012092407909Skin · crackedLEFT EXTERNAL SKIN OF RUDDER CRACKED AT LEVEL OF FIN WL 107.09+7. REPAIRED SKIN IAW SRM.SDR SWAA2012091907761Stringer · corrodedSTRINGER CORRODED AT BS 965, STR 26R. REPAIRED STRINGER IAW SRM.SDR SWAA2012091807736Cargo Track · corrodedAFT CARGO COMPARTMENT TRACK CORRODED AT BS 860, RBL 13.80. REPAIRED TRACK IAW EA AND EO.SDR SWAA2012091107515Shear Tie · corrodedSHEAR TIE CORRODED AT BS 500, BETWEEN STR 27R AND STR 28R. REPAIRED FRAME IAW SRM.SDR SWAA2012091107514Frame · corrodedFRAME CORRODED AT BS 500C, BTWEEN STR 28L AND STR 28R. REPAIRED FRAME IAW SRM.SDR SWAA2012091107513Frame · corrodedFRAME CORRODED AT BS 500B, BETWEEN STR 27R AND STR 28R. REPAIRED FRAME IAW SRM AND DWG.SDR SWAA2012091107512Shear Tie · corrodedSHEAR TIE CORRODED AT BS 500, BETWEEN STR 28L AND STR 28R. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2012091107511Shear Tie · corrodedSHEAR TIE CORRODED AT BS 500, BETWEEN STR 27L AND STR 28L. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2012091007448Web · corrodedWEB LOWER SURFACE CORRODED BETWEEN BS 847 TO BS 867, STR 17L. REMOVED AND REPLACED WEB IAW SRM & DWG.SDR SWAA2012090507378Tie Clip · crackedTIE CLIP CRACKED AT BS 787, STR 21R. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.SDR SWAA2012090407307Web · corrodedWEB CORRODED BETWEEN BS 907 TO BS 927, STR 17L. REMOVED AND REPLACED WEB IAW SRM AND DWG.SDR SWAA2012090407289Tie Clip · crackedTIE CLIP CRACKED AT BS 787, STR 22R. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.SDR SWAA2012090407288Shear Tie · corrodedSHEAR TIE CORRODED AT BS 480, BETWEEN STR 27R AND STR 28R. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2012083007181Shear Tie · corrodedSHEAR TIE CORRODED AT BS 500D, BETWEEN STR 27L AND STR 28L. REMOVED AND REPLACED SHEAR TIE IAW SRM AND DWG.SDR SWAA2012083007172Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 867+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012083007157Channel · corrodedCHANNEL CORRODED AT BS 860, RBL 3.0. REPAIRED CHANNEL IAW EA.SDR SWAA2012082907128Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 847+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012082907116Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 827+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB AND TC.SDR SWAA2012082907115Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 787+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW TC.SDR SWAA2012082907114Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 727+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA AND REO.SDR SWAA2012082907113Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 847+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012082907112Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 827+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB AND TC.SDR SWAA2012082707018Shear Tie · corrodedSHEAR TIE CORRODED AT BS 500D, BETWEEN STR 28L AND STR 28R. REMOVED AND REPLACED SHEAR TIE IAW SRM AND DWG.
Back to Boeing 737-3H4