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 SWAA2012100508303Skin · crackedFUSELAGE SKIN CRACKED AT BS 927 + 5, STR 24R. REMOVED AND REPLACED SKIN IAW EA.SDR SWAA2012100108094Skin · crackedFUSELAGE SKIN CRACKED AT BS 927, STR 4R. REPAIRED SKIN IAW SRM.SDR SWAA2012100108106Skin · crackedFUSELAGE SKIN CRACKED BS 890, STR 18R. REPAIRED SKIN PER SRM.SDR SWAA2012092708067Hook · dirtyR2 DOOR EMERGENCY EVAC SLIDE GIRT BAR DIFFICULT TO OPERATE DUE TO DEBRIS. CLEANED & LUBED HOOKS PER M/M.SDR SWAA2012100108095Skin · crackedFUSELAGE SKIN CRACKED AT BS 498, STR 19R. REPAIRED SKIN PER EA.SDR SWAA2012092608030Slide · out of adjustR1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MT.SDR SWAA2012092608029Slide · out of adjustR2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MT.SDR SWAA2012092107869Skin · crackedFUSELAGE SKIN CRACKED AT BS 981, STR 21L. REPAIRED SKIN PER SRM.SDR SWAA2012091907783Light · looseOVERHEAD EMERGENCY EXIT BULLNOSE LIGHT LOOSE BETWEEN ROW 8 TO ROW 9. SECURED LIGHT PER MM.SDR SWAA2012100108105Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 962 TO BS 964, STR 21L. REPAIRED SKIN IAW EA.SDR SWAA2012100108104Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 882 TO BS 854.5, STR 16L. REPAIRED SKIN IAW EA.SDR SWAA2012092608028Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 882 TO BS 883, STR 15L. REPAIRED SKIN IAW EA.SDR SWAA2012091307562Skin · crackedFUSELAGE SKIN CRACKED AT BS 887 +14, STR 25R. REPAIRED SKIN PER SRM.SDR SWAA2012091307583Skin · crackedSKIN CRACKED AT BS 430+5, STR 1. REPAIRED SKIN PER EA.SDR SWAA2012091007461Spoiler · delaminatedRIGHT WING NR 6 SPOILER DELAMINATED. REMOVED AND REPLACED NR 6 SPOILER AS PER AMM.SDR SWAA2012091007467Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 927, STR 26R. REMOVED AND REPLACED CLIP IAW DWG AND SRM.SDR SWAA2012091007466Battery Pack · dischargedL1 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY PACK IAW AMM.SDR SWAA2012091007465Skin · crackedFUSELAGE SKIN CRACKED AT BS 907+13, STR 21L. REPAIRED SKIN IAW AMM.SDR SWAA2012091007464Skin · crackedFUSELAGE SKIN CRACKED AT BS 787+13, STR 22L. REMOVED AND REPLACED SKIN IAW SRM & AMM.SDR SWAA2012091007463Skin · crackedFUSELAGE SKIN CRACKED AT BS 931, STR 25R. REPAIRED SKIN IAW SRM & AMM.SDR SWAA2012091007462Skin · crackedFUSELAGE SKIN CRACKED AT BS 875, BETWEEN STR 24L TO STR 25L. REPAIRED SKIN IAW SRM & AMM.SDR SWAA2012090607407Flap · delaminatedLEFT WING O/B AFT FLAP DELAMINATED. REMOVED AND REPLACED AFT FLAP PER AMM.SDR SWAA2012090407349Sign · looseLEFT OVERWING EMERGENCY EXIT SIGN LOOSE. REMOVED AND REPLACED SIGN PER M/M.SDR SWAA2012090407314Light · inoperativeR1 DOOR EXTERIOR EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT PER MM.SDR SWAA2012090607408Skin · crackedSKIN FUSELAGE CRACKED BETWEEN BS 979 TO BS 982, STR 21L. REPAIRED SKIN IAW ER AND EA.SDR SWAA2012090407313Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 979 TO BS 982, STR 21L. REPAIRED SKIN PER SRM.SDR SWAA2012083007200Light · damagedEEPLS DAMAGED BETWEEEN ROW 6 TO ROW 8. REMOVED AND REPLACED EEPLS PER MM.SDR SWAA2012083007199Flap · delaminatedRIGHT WING NR 8 O/B AFT FLAP DELAMINATED. REMOVED AND REPLACED AFT FLAP PER AMM.SDR SWAA2012083007198Cover · looseLEFT EEPLS COVER LOOSE AT ROW 6. REMOVED AND REPLACED EEPLS PER MM.SDR SWAA2012082707082Circuit Card · faultyLEFT MAIN GEAR DISAGREE LIGHT ILLUMINATED IN DESCENT. PLACED GEAR HANDLE UP QRH AND LIGHT REMAINED ILLUMINATED. GEAR EXTENDED NORMALLY FOR LANDING WITH 3 GREEN LIGHTS, NO RED LIGHTS. REMOVED AND REPLACED CONNECTOR D4840P, E11 CIRCUIT CARD M988 LT GEAR UP & SDR SWAA2012083007197Fitting · crackedCLIP CRACKED AT BS 807, STR 19L. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA2012083007196Fitting · crackedCLIP CRACKED AT BS 807, STR 18L. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA2012083007195Stringer Clip · crackedCLIP CRACKED AT BS 787, STR 18L. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA2012082707036Slat · delaminatedRIGHT WING NR 6 SLAT DELAMINATED. REMOVED AND REPLACED NR 6 SLAT IAW AMM.SDR SWAA2012083007226Skin · crackedFUSELAGE SKIN CRACKED AT BS 831, STR 17L. REPAIRED SKIN IAW SRM.SDR SWAA2012083007225Skin · crackedFUSELAGE SKIN CRACKED AT BS 810, STR 19L. REPAIRED SKIN IAW SRM.SDR SWAA2012083007224Shear Tie · crackedSHEAR TIE CRACKED AT BS 807, STR 17L. REMOVED AND REPLACED SHEAR TIE IAW SRM AND BOEING DWG.SDR SWAA2012083007223Shear Tie · crackedSHEAR TIE CRACKED AT BS 787, STR 20L. REMOVED AND REPLACED SHEAR TIE IAW SRM AND DWG.SDR SWAA2012083007222Shear Tie · crackedSHEAR TIE CRACKED AT BS 767, STR 18L. REMOVED AND REPLACED SHEAR TIE IAW SRM.SDR SWAA2012083107220Skin · crackedFUSELAGE SKIN CRACKED AT BS 807+6, STR 19L. REPAIRED SKIN IAW SRM.SDR SWAA2012083107217Skin · crackedFUSELAGE SKIN CRACKED AT BS 747+11, STR 18L. REPAIRED SKIN IAW EA.SDR SWAA2012083007194Skin · crackedFUSELAGE SKIN CRACKED AT BS 362, BETWEEN STR 5R AND STR 6R. REPAIRED SKIN IAW EA.SDR SWAA2012080806608Battery Pack · dischargedRIGHT AFT CABIN EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK PER AMM.SDR SWAA2012080706565Spindle · corrodedNR 7 SPINDLE CORRODED. REMOVED AND REPLACED PER MT.SDR SWAA2012081506700Stringer Splice · crackedSTRINGER SPLICE CRACKED AT BS 907, STR 6R. REMOVED AND REPLACED SPLICE IAW SRM AND BAC DWG.SDR SWAA2012073106364Slide · out of positionL2 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER M/M.SDR SWAA2012080706494Stringer Splice · crackedSTRINGER SPLICE CRACKED AT BS 380, STR 15L. REPAIRED SPLICE IAW SRM.SDR SWAA2012080706564Frame · crackedFRAME CRACKED AT BS 380, STR 15R. REPAIRED FRAME IAW EA.SDR SWAA2012080106376Fitting · out of adjustR2 DOOR EMERGENCY EVAC SLIDE GIRT BAR CLIP OUT OF ADJUST. ADJUSTED CLIP PER MM.SDR SWAA2012072706241Attach Angle · crackedBULKHEAD ATTACH ANGLE CRACKED AT BS 950, STR 22L. REMOVED AND REPLACED ANGLE IAW DWG & SRM.
Back to Boeing 737-5H4