Boeing 737-5H4
Service difficulty reports · 8,230
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 = '7375H4' 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 = '7375H4' 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 SWAA2012072606179Skin · crackedFUSELAGE SKIN CRACKED AT BS 344+3, STR 2L. REPAIRED SKIN PER SRM.SDR SWAA2012080706493Skin · crackedSKIN CRACKED AT BS 460 + 6, STR 17R. REPAIRED SKIN IAW SRM.SDR SWAA2012080706492Skin · crackedSKIN CRACKED AT BS 440 + 10, STR 16R. REPAIRED SKIN IAW SRM.SDR SWAA2012072006013Light · out of positionRIGHT FORWARD EMERGENCY EXIT LIGHT COVER FELL OFF. REMOVED AND REPLACED LIGHT ASSY PER M/M.SDR SWAA2012081406696Stringer · crackedSTRINGER CRACKED BETWEEN BS 857 TO BS 907, STR 4R. REPAIRED STRINGER IAW SRM.SDR SWAA2012081706778Stringer Splice · crackedSTRINGER SPLICE CRACKED BS 907, STR 2L. REMOVED AND REPLACED SPLICE PER SRM.SDR SWAA2012082306896Skin · crackedSKIN CRACKED BETWEEN BS 867+12 TO BS 867+15, STR 2L. REPAIRED SKIN IAW EA.SDR SWAA2012072006012Stiffener · crackedLEFT HORIZONTAL STABILIZER RIB 92.7 STIFFENER CRACKED. REMOVED AND REPLACED STIFFENER IAW BAC DWG AND SRM.SDR SWAA2012073006350Angle · crackedVERTICAL STABILIZER AT LOWER FWD FITTING CHANNEL SPLICE ANGLE CRACKED. REMOVED AND REPLACED SPLICE ANGLE PER BAC DWG.SDR SWAA2012071305797Lens · looseRIGHT OVERWING EMERGENCY EXIT LIGHT LENS LOOSE. REMOVED AND REPLACED LENS PER M/M.SDR SWAA2012071905996Stiffener · crackedLEFT WING I/B FLAP O/B FIXED FAIRING STIFFENER CRACKED AT STA 46. REMOVED AND REPLACED STIFFENER PER BAC DWG.SDR SWAA2012071705926Web · crackedR2 DOOR TORQUE BOX WEB CRACKED AT BS 947, STR 12R. REMOVED AND REPLACED WEB IAW SRM AND DWG.SDR SWAA2012082406953Frame · crackedFRAME WEB CRACKED AT BS 380, STR 15R. REPAIRED FRAME IAW EA.SDR SWAA2012082306895Frame · crackedFRAME INNER CHORD CRACKED AT BS 380, AT STR 15L. REPAIRED CHORD.SDR SWAA2012081306618Frame · crackedFRAME CRACKED AT BS 947.5, STR 19L. REPAIRED FRAME IAW EA.SDR SWAA2012071905982Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 827, STR 27L. REMOVED AND REPLACED CLIP IAW BAC DWG AND SRM.SDR SWAA2012071205761Attach Angle · crackedATTACH ANGLE CRACKED AT BS 361, STR 11L. REMOVED AND REPLACED ANGLE IAW SRM AND DWG.SDR SWAA2012071205760Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 482, STR 16L. REMOVED AND REPLACED CLIP IAW SRM & BAC DWG.SDR SWAA2012082306894Crease Beam · corrodedCREASE BEAM WEB CORRODED AT STA 727C, STR 17R. REPAIRED WEB IAW BAC DWG & SRM.SDR SWAA2012073106365Crease Beam · corrodedCREASE BEAM WEB CORRODED AT BS 867, STR 17L. REMOVED AND REPLACED WEB IAW BAC DWG AND SRM.SDR SWAA2012073006353Crease Beam · corrodedCREASE BEAM WEB CORRODED AT BS 400, STR 17L. REMOVED AND REPLACED WEB PER SRM & BAC DWG.SDR SWAA2012073006352Crease Beam · corrodedCREASE BEAM WEB CORRODED AT BS 867, STR 17R. REMOVED AND REPLACED WEB IAW BAC DWG.SDR SWAA2012073006346Crease Beam · corrodedCREASE BEAM WEB CORRODED AT BS 420, STR 17L. REPAIRED WEB IAW BAC DWG & SRM.SDR SWAA2012073006332Crease Beam · corrodedCREASE BEAM WEB CORRODED AT BS 619, STR 17L. REMOVED AND REPLACED WEB IAW BAC DWG AND SRM.SDR SWAA2012073006296Crease Beam · corrodedCREASE BEAM WEB CORRODED AT BS 787, STR 17R. REMOVED AND REPLACED WEB IAW BAC DWG & SRM.SDR SWAA2012071605850Crease Beam · corrodedCREASE BEAM WEB CORRODED AT BS 887, STR 17L. REMOVED AND REPLACED WEB IAW SRM & BAC DWG.SDR SWAA2012071305799Crease Beam · corrodedCREASE BEAM WEB CORRODED AT BS 747, STR 17L. REMOVED AND REPLACED WEB IAW SRM.SDR SWAA2012073006351Shear Tie · crackedSHEAR TIE CRACKED AT BS 277, STR 10L. REMOVED AND REPLACED SHEAR TIE IAW BAC DWG.SDR SWAA2012073006295Shear Tie · crackedSHEAR TIE CRACKED AT BS 277, STR 9L. REMOVED AND REPLACED SHEAR TIE IAW BAC DWG.SDR SWAA2012073006267Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 360, STR 10. REMOVED AND REPLACED CLIP IAW SRM AND BAC DWG.SDR SWAA2012070905641Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 277, STR 15L. REMOVED AND REPLACED CLIP IAW DWG AND SRM.SDR SWAA2012082406952Skin · wornFUSELAGE SKIN WORN BETWEEN BS 867 TO BS 887, STR 1L. REPAIRED SKIN IAW EA.SDR SWAA2012091007443Flap · chafedRIGHT WING OUTBOARD LEADING EDGE FORE FLAP INBOARD OF NR 1 AUX TRACK BULL NOSE CHAFED. REPAIRED FORE FLAP PER SRM AND AMM.SDR SWAA2012081706777Skin · crackedLEFT HORIZONTAL STABILIZER LOWER SKIN CRACKED AT STA 98. REMOVED AND REPLACED SKIN IAW EA.SDR SWAA2012062605323Light · brokenR1 DOOR EMERGENCY EXIT LIGHT BASE BROKEN. REMOVED & REPLACED LIGHT PER MM.SDR SWAA2012070905640Skin · crackedSKIN CRACKED AT BS 787+3, STR 18L. REPAIRED SKIN IAW ER AND EA.SDR SWAA2012062605317Uplock Sensor · faultyRED GEAR LIGHT ILLUMINATED IN FLIGHT AND REMAINED ILLUMINATED AFTER RAISING GEAR HANDLE AS DIRECTED BY QRH. FOUND RIGHT MLG UPLOCK SENSOR BAD. REMOVED AND REPLACED RIGHT MLG UPLOCK SENSOR PER AMM.SDR SWAA2012062505211Lens · brokenFWD EEPLS LENS BROKEN. REPLACED LENS PER MM.SDR SWAA2012062805374Flap · crackedLEFT WING FORE FLAP CRACKED AT FITTING. REMOVED AND REPLACED FORE FLAP IAW AMM.SDR SWAA2012062505212Lens · missingFWD EEPLS LENS MISSING. INSTALLED LENS IAW M/M.SDR SWAA2012062105142Terminal · faultyLEFT GEAR LIGHT ILLUMINATES SLOWED TO 230KTS, PUT GEAR HANDLE UP, LIGHT WENT OUT PUT GEAR HANDLE OFF. LIGHT ILLUMINATES PUT GEAR GEAR HANDLE UP, LIGHT OUT FOR REST OF CRUISE. REMOVED AND REPLACED YELLOW WIRE GROUND TERMINALS PER MM.SDR SWAA2012062105128Motor · faultyON CLIMBOUT UNABLE TO MAINTAIN CLIMB N1 WITHOUT EXCEEDING MAX CONT EGT TO MAINTAIN CLIMB N1 REQUIRES 920+ ON NR 1 ENG EGT. REMOVED AND REPLACED VBV MOTOR & VBV STOP INSTALLED NEW FLEX SHAFT PER MM.SDR SWAA2012061805000Battery Pack · faultyLEFT AFT EMERGENCY EXIT LIGHTS FAULTY. REMOVED AND REPLACED BATTERY PACK PER AMM.SDR SWAA2012061905057Slide · looseR2 DOOR EMERGENCY EVAC SLIDE LOOSE. SECURED SLIDE IAW MT.SDR SWAA2012061404886Lens · looseLEFT BULLNOSE EMERGENCY LIGHT LENS LOOSE BETWEEN ROW 10 TO ROW 11. SECURED LENS PER MM.SDR SWAA2012061404885Lens · looseRIGHT OVERWING EMERGENCY EXIT LIGHT SIGN LENS LOOSE. REMOVED AND REPLACED SIGN PER MM.SDR SWAA2012060704731Skin · crackedFUSELAGE SKIN CRACK AT BS 882-884.5, ABOVE STR 20L. REPAIRED FUSELAGE SKIN PER SRM.SDR SWAA2012060604720Mount · crackedR2 DOOR EMERGENCY EVAC SLIDE FORWARD SLIDE MOUNT CRACKED. REMOVED AND REPLACED MOUNT PER AMM.SDR SWAA2012060404576Latch · inoperativeL1 DOOR EMERGENCY EVAC SLIDE LATCH INOP. REMOVED AND REPLACED LATCH IAW MM.SDR SWAA2012060504641Skin · crackedSKIN CRACKED AT BS 767+ 17, STR 24L. REPAIRED SKIN PER SRM.
Back to Boeing 737-5H4