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 SWAA2012070505534Skin · delaminatedRIGHT WING OUTBOARD AFT FLAP DELAMINATED AT UPPER SURFACE. REMOVED AND REPLACED FLAP PER MM.SDR SWAA2012070905611Skin · delaminatedLEFT WING NR 1 SLAT DELAMINATED UPPER I/B SURFACE. REMOVED AND REPLACED NR 1 SLAT PER MM.SDR SWAA2012070905600Slat · delaminatedLEFT WING NR 3 SLAT DELAMINATED. REMOVED AND REPLACED NR 3 SLAT PER M/M.SDR SWAA2012070905595Skin · crackedFUSELAGE SKIN CRACKED AT BS 370 + 4, STR 8L. REPAIRED SKIN IAW EA.SDR SWAA2012070505548Slide · looseR1 DOOR SLIDE LOOSE. RE-INSTALLED SLIDE PER MT.SDR SWAA2012070505547Light · inoperativeEMERGENCY LIGHT ABOVE SEAT 4D INOP. RELAMPED PER MM.SDR SWAA2012070905599Door Frame · crackedR1 DOOR LOWER FRAME CRACKED AFT LOWER CORNER. REMOVED AND REPLACED R1 DOOR PER AMM.SDR SWAA2012070905598Spoiler · delaminatedLEFT WING NR 3 FLIGHT SPOILER DELAMINATED. REMOVED AND REPLACED SPOILER PANEL PER MM.SDR SWAA2012070905597Wedge · delaminatedLEFT WING NR 2 SLAT TRAILING EDGE WEDGE DELAMINATED AT O/B END. REMOVED AND REPLACED NR 2 SLAT PER MM.SDR SWAA2012070505549Skin · crackedFUSELAGE SKIN CRACKED AT BS 807, STR 10R. REPAIRED SKIN PER SRM & EA.SDR SWAA2012070405523Cover · out of positionLEFT EEPLS COVER FELL OFF AT ROW 13. RE-INSTALLED COVER PER MM.SDR SWAA2012070305525Light · looseLEFT EEPLS LOOSE BETWEEN ROW 7 TO ROW 8. REMOVED AND REPLACED EEPLS PER AMM.SDR SWAA2012070305524Skin · crackedSKIN CRACKED AT BS 370+4, STR 8L. REPAIRED SKIN IAW SRM.SDR SWAA2012070305517Skin · crackedSKIN CRACKED AT BS 908+1.5, STR 10L. REPAIRED SKIN IAW EA.SDR SWAA2012070205434Detector · faultyDECLARED EMERGENCY - MX INDICATOR FAULT LIGHT ILLLUMINATED ALONG WITH GREEN SYSTEM OK LIGHT. REMOVED AND REPLACED AFT CARGO DETECTOR PER MM.SDR SWAA2012071605857Beam · crackedL1 DOOR CHANNEL BEAM CRACKED BETWEEN BS 312 TO STA 344 IN LOWER SILL. REMOVED AND REPLACED BEAM IAW SRM AND DWG.SDR SWAA2012071605837Frame · crackedFRAME CRACKED AT BS 500C, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME IAW EA.SDR SWAA2012071205750Angle · corrodedRIGHT "Z" ANGLE CORRODED BETWEEN BS 767 TO BS 787. REMOVED AND REPLACED "Z" ANGLE IAW DWG & SRM.SDR SWAA2012071005701Skin · crackedSKIN CRACKED AT BS 927+6, STR 24R. REPAIR SKIN IAW SRM.SDR SWAA2012071005700Skin · crackedSKIN CRACKED AT BS 787+6, STR 18L. REPAIRED SKIN IAW SRM.SDR SWAA2012071005699Skin · crackedSKIN CRACKED AT BS 727D+14, STR 19R. REPAIRED SKIN IAW ER AND EA.SDR SWAA2012070905614Shear Tie · corrodedSHEAR TIE CORRODED AT BS 500 BETWEEN STRINGERS 26R AND 27R. REMOVED AND REPLACED SHEAR TIE IAW SRM AND DWG.SDR SWAA2012070205475Skin · delaminatedLEFT WING OUTBOARD AFT FLAP LOWER INBOARD SURFACE DELAMINATED. REMOVED AND REPLACED AFT FLAP PER AMM.SDR SWAA2012070205454Skin · crackedSKIN CRACKED BETWEEN BS 727D + 14 TO BS 787 + 6, BETWEEN STR 24R TO STR 18L. REPAIRED SKIN PER SRM.SDR SWAA2012070905654Skin · crackedSKIN CRACKED AT BS 500B+12, STR 1L. REPAIRED SKIN IAW AAR EA AND EA.SDR SWAA2012070905653Skin · crackedSKIN CRACKED AT BS 500A +7, STR 2R. REPAIRED SKIN IAW AAR EA AND EA.SDR SWAA2012070505546Skin · crackedFUSELAGE SKIN CRACKED AT BS 500B+12, STR 7R. REPAIRED SKIN PER SRM AND EA.SDR SWAA2012070505545Skin · crackedFUSELAGE SKIN CRACKED AT BS 500A+7, STR 2R. REPAIRED SKIN PER SRM AND EA.SDR SWAA2012070505544Skin · crackedFUSELAGE SKIN CRACKED AT BS 727D+9, STR 4R. REPAIRED SKIN PER SRM.SDR SWAA2012070505543Skin · crackedFUSELAGE SKIN CRACKED AT BS 867+ 13, STR 4R. REPAIRED SKIN PER SRM.SDR SWAA2012070205458Flashlight · inoperativeINBOARD F/A FORWARD EMERGENCY FLASHLIGHT INOP. REMOVED AND REPLACED FLASHLIGHT PER MM.SDR SWAA2012070305516Skin · crackedSKIN CRACKED AT BS 907-12, STR 10L. REPAIRED SKIN IAW EA.SDR SWAA2012070305515Skin · crackedSKIN CRACKED AT BS 907, STR 10L. REPAIRED SKIN IAW EA.SDR SWAA2012070305514Skin · crackedSKIN CRACKED AT BS 908, STR 10L. REPAIRED SKIN IAW EA.SDR SWAA2012070205485Battery · dischargedAFT EMERGENCY FLASHLIGHT BATTERIES INOP. REMOVED & REPLACED BATTERIES IAW AMM.SDR SWAA2012070205474Tab · delaminatedRIGHT WING AILERON TAB DELAMINATED. REMOVED AND REPLACED TAB PER AMM.SDR SWAA2012070205472Wire · brokenEMERGENCY EXIT LIGHT WIRING BROKEN AT BS 500A. REPAIRED WIRE IAW BSWPM & WDM & AMM.SDR SWAA2012070205457Sign · looseAFT EMERGENCY EXIT SIGN LOOSE. SECURED SIGN PER SOPM.SDR SWAA2012070205456Light · inoperativeLEFT EMERGENCY EXIT LIGHT INOP AT ROW 5. RELAMPED LIGHT PER AMM.SDR SWAA2012070205455Light · inoperativeR2 DOOR EMERGENCY EXIT SIGN BULB INOP. RELAMPED SIGN ASSY PER AMM.SDR SWAA2012070205436Adc · faultyAIR TURNBACK, ON CLIMBOUT NR 1 AUTOPILOT DISCONNECTED, N1 BUGS DECREASED TO 0. BOTH FMCS LOST ALL DATA. NO TEMP INFO. GROUND PROX INOP LIGHT ILLUMINATED. FOUND DADC-1 & TAT PROBE FAULTY. REMOVED AND REPLACED DADC NR 1 COMPUTER AND TAT PROBE PER MM.SDR SWAA2012070205427Battery · dischargedFWD EMERGENCY FLASHLIGHT BATTERIES INOP. REMOVED & REPLACED BATTERIES IAW AMM.SDR SWAA2012072306099Bulkhead · crackedVERTICAL BEAM WEB CRACKED AT BS 178, AT RBL 17. REPAIRED WEB IAW SRM.SDR SWAA2012070905631Bulkhead · crackedVERTICAL BEAM WEB CRACKED AT BS 178, LBL 17.0. REPAIRED WEB IAW SRM.SDR SWAA2012070905628Stringer Splice · crackedSTRINGER SPLICE CRACKED AT BS 360, STR 13R. REMOVED & REPLACED SPLICE IAW BAC DWG.SDR SWAA2012062805378Lens · brokenAFT EMERGENCY EXIT SIGN LIGHT LENS BROKEN. REMOVED AND REPLACED LENS IAW AMM.SDR SWAA2012071205767Tie Clip · crackedTIE CLIP CRACKED AT BS 380, STR 21L. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.SDR SWAA2012071205766Angle · corrodedANGLE CORRODED AT BS 360, STR 28L. REMOVED AND REPLACED ANGLE IAW SRM AND DWG.SDR SWAA2012070905630Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 500C, STR 10R. REMOVED AND REPLACED CLIP IAW SRM AND BAC DWG.SDR SWAA2012070905629Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 360, STR 9R. REMOVED AND REPLACED CLIP IAW SRM AND BAC DWG.
Back to Boeing 737-3H4