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 SWAA2013032514032Skin · crackedLIGHT BS 380+10 LOWER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE 3. REPAIRED SKIN IAW SB.SDR SWAA2013032113976Skin · crackedLEFT BS 500+10 LOWER AFT WINDOW CORNER SKIN CUTOUT CRACKED AT HOLES 2, 3. REPAIRED SKIN IAW SB.SDR SWAA2013032113975Skin · crackedLEFT BS 460+10 UPPER FORWARD WINDOW CORNER SKIN CUTOUT CRACKED AT HOLES 2, 3, 7. REPAIRED SKIN IAW BOEING SB.SDR SWAA2013032113974Skin · crackedLEFT BS 400+10 UPPER FORWARD SKIN CUTOUT CRACKED AT HOLES 3, 6. REPAIRED SKIN IAW BOEING SB.SDR SWAA2013032113965Skin · crackedLEFT BS 500B+10 LOWER AFT WINDOW CORNER SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW SB.SDR SWAA2013032113964Skin · crackedLEFT BS 500A+10 LOWER AFT WINDOW CORNER SKIN CUTOUT CRACKED AT HOLES 2, 3. REPAIRED SKIN IAW SB.SDR SWAA2013032113963Skin · crackedLEFT BS 500A+10 UPPER FORWARD WINDOW CORNER SKIN CUTOUT CRACKED AT HOLES 1, 3, 6. REPAIRED SKIN IAW SB.SDR SWAA2013032113990Angle · crackedL1 DOOR LOWER WEB SUPPORT ANGLE CRACKED BETWEEN BS 348.2 TO BS 351, STR 16L. REMOVED AND REPLACED ANGLE IAW DWG AND SRM.SDR SWAA2013032113989Support Angle · crackedL1 DOOR UPPER WEB SUPPORT ANGLE CRACKED BETWEEN BS 348.2 TO BS 351, STR 16L. REMOVED AND REPLACED ANGLE IAW DWG AND SRM.SDR SWAA2013032113988Web · crackedL1 DOOR WEB CRACKED AT BS 348.2, STR 16L. REMOVED AND REPLACED WEB IAW DWG AND SRM.SDR SWAA2013032013855Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 348.2, STR 15L. REMOVED AND REPLACED ANGLE PER SRM.SDR SWAA2013040114259Strap · crackedAFT PIT DOOR CLOSURE SIDEWALL PANEL AFT STRAP CRACKED. REMOVED AND REPLACED STRAP IAW SRM.SDR SWAA2013040114258Shear Tie · corrodedSHEAR TIE CORRODED AT BS 787, BETWEEN STR 23R TO STR 23L. REMOVED AND REPLACED FRAME IAW SRM AND DWG.SDR SWAA2013040114257Shear Tie · corrodedSHEAR TIE CORRODED AT BS 767 BETWEEN, STR 27R. REMOVED AND REPLACED FRAME IAW EA.SDR SWAA2013032614176Stringer Splice · corrodedSTRINGER SPLICE CORRODED BETWEEN BS 360 TO BS 380, STR 28L. REMOVED AND REPLACED SPLICE IAW SRM & DWG.SDR SWAA2013032614132Frame · corrodedSHEAR TIE CORRODED AT BS 767, BETWEEN STR 27L AND STR 26R. REMOVED AND REPLACED FRAME IAW SRM.SDR SWAA2013032614152Frame · corrodedSHEAR TIE CORRODED BS 767, BETWEEN STR 26L AND STR 27L LBL 10. REMOVED AND REPLACED FRAME IAW SRM.SDR SWAA2013032113994Stringer · crackedSTRINGER CRACKED AT BS 484, STR 2L. REPAIRED STRINGER IAW EA.SDR SWAA2013032113993Stiffener · crackedRIGHT MAIN W/W VERTICAL STIFFENER CRACKED AT BS 663.75, RBL 6.15. REPAIRED STIFFENER IAW EA.SDR SWAA2013031913822Channel · crackedCHANNEL ASSY CRACKED AT BS 540, BETWEEN BL 0 TO RBL 24.7. REMOVED AND REPLACED CHANNEL ASSY IAW SRM.SDR SWAA2013031913843Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 947, STR 25R. REMOVED AND REPLACED CLIP IAW SRM.SDR SWAA2013031313581Power Supply · inoperativeRIGHT AFT OVERWING EGRESS LIGHT INOP. REMOVED AND REPLACED POWER SUPPLY PER MM.SDR SWAA2013032514036Shear Tie · corrodedSHEAR TIE CORRODED AT BS 500A, LBL 24. REMOVED AND REPLACED SHEAR TIE IAW SRM AND DWG.SDR SWAA2013032113978Shear Tie · corrodedSHEAR TIE CORRODED AT BS 500A, BETWEEN STR 28R AND STR 28L. REMOVED AND REPLACED SHEAR TIE IAW SRM.SDR SWAA2013032113992Skin · crackedSKIN CRACKED AT BS 380, STR 14L. REPAIRED SKIN IAW EA.SDR SWAA2013031813745Stiffener · corrodedRIGHT VERTICAL STIFFENER CORRODED AT BS 500D, STR 28R. REMOVED AND REPLACED STIFFENER IAW SRM.SDR SWAA2013031413668Stringer Clip · damagedSTRINGER CLIP DAMAGED AT STA 420, STR 14R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA2013031313585Door Frame · crackedFORWARD FRAME CRACKED AT L1 DOOR. REMOVED AND REPLACED L1 DOOR ASSY PER MM.SDR SWAA2013031113534Door Frame · crackedL1 DOOR FWD LOWER FRAME CRACKED. REMOVED AND REPLACED L1 DOOR PER MM.SDR SWAA2013031413667Stringer Clip · damagedSTRINGER CLIP DAMAGED AT STA 400, STR 14R REMOVED AND REPLACED CLIP PER SRM.SDR SWAA2013031413666Stringer Clip · damagedSTRINGER CLIP DAMAGED AT STA 400, STR 14R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA2013031413651Angle · crackedINTERNAL ANGLE OF THE NR 8 O/B FLAP TRACK FAIRING SUPPORT CRACKED. REMOVED AND REPLACED ANGLE PER SRM.SDR SWAA2013031413650Support · crackedINTERNAL ANGLE OF THE NR 7 O/B FLAP TRACK FAIRING SUPPORT CRACKED. REMOVED AND REPLACED ANGLE PER SRM.SDR SWAA2013031313587Light · inoperativeR2 DOOR EXTERIOR EMERGENCY LIGHT INOP. RELAMPED PER MM.SDR SWAA2013031213560Cover · brokenEXIT LIGHT COVER BROKEN OFF AT FWD ENTRY, BETWEEN FLIGHT ATTENDANT JUMP SEAT AND L1 DOOR. REMOVED AND REPLACED EMERGENCY EXIT LIGHT ASSY PER MM.SDR SWAA2013031113528Bracket · wornL1 DOOR SLIDE FLOOR BRACKETS ASSY WORN. REMOVED AND REPLACED BRACKET ASSY HARDWARE PER MM & SRM.SDR SWAA2013031113527Bracket · wornR1 DOOR SLIDE FLOOR BRACKETS ASSY WORN. REMOVED AND REPLACED BRACKET ASSY HARDWARE PER MM & SRM.SDR SWAA2013031113533Cover · looseEXIT SIGN COVER LOOSE AT FWD F/A'S SEAT. SECURED COVER PER MM.SDR SWAA2013030813478Lens · wornFORWARD ENTRY DOOR EMERGENCY LIGHT LENS LETTERS WORN. REMOVED AND REPLACED LENS PER MM.SDR SWAA2013030813450Proximity Sensor · faultyNLG RED AND GREEN LIGHTS ILLUMINATED. RECYCLED HANDLE, NO HELP. REMOVED AND REPLACED NLG PROX SENSOR S845 PER MM.SDR SWAA2013031313598Tie Clip · crackedTIE CLIP LOCATED CRACKED ATSTA 440, STR 24L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA2013031113524Bracket · wornR2 DOOR SLIDE FLOOR BRACKETS ASSY WORN. REMOVED AND REPLACED BRACKET ASSY HARDWARE PER MM & SRM.SDR SWAA2013031113523Bracket · wornL2 DOOR SLIDE FLOOR BRACKETS ASSY WORN. REMOVED AND REPLACED BRACKET ASSY HARDWARE PER MM & SRM.SDR SWAA2013030813482Slide · out of positionFORWARD SERVICE DOOR SLIDE FELL OUT WHEN SERVICE DOOR OPENED. RE-INSTALLED SLIDE PER MT.SDR SWAA2013030813476Door Frame · crackedFORWARD SERVICE DOOR AFT LOWER FRAME CRACKED. REMOVED AND REPLACED DOOR PER MM.SDR SWAA2013032214018Frame · crackedFRAME CRACKED AT BS 360, BETWEEN STR 19R TO STR 20R. REPAIRED FRAME IAW EA.SDR SWAA2013032113991Skin · crackedSKIN CRACKED AT BS 380, STR 14R. REPAIRED SKIN IAW EA.SDR SWAA2013031913821Support Bracket · crackedR2 DOOR EMERGENCY EVAC SLIDE SUPPORT BRACKETS CRACKED. REMOVED AND REPLACED BRACKET IAW SRM AND DWG.SDR SWAA2013030713421Battery Pack · dischargedTHREE EA AFT OUTBOARD EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA2013030613389Window · arcedLEFT SIDE WINDOW (CAPT) ARCED AT LEADING EDGE NEAR ELECTRICAL CONNECTOR. REMOVED AND REPLACED WINDOW PER M/M.
Back to Boeing 737-3H4